Re: [GNC] best accounting practice for refund
Thanks! > On Jun 26, 2019, at 7:41 PM, Adrien Monteleone > wrote: > > In that case, certainly, you need to use credit notes. > > I don’t see any reason why this ‘wouldn’t work from an accounting standpoint’ > but if you find a problem, instead of cutting a check to the customer as > payment for the credit note, combine this with option #2 I listed, and this > time, use that Liabilities:Customer Deposits account to ‘pay’ the credit > note. This will show you have a liability to them and then you can decrease > it by using it to later pay for future work. The credit note is cleared out > instantly and you still track the money, however, any Aging Report or > Customer Report will no longer reflect this deposit liability as a credit to > them. You’d have to handle that part manually in an outside spreadsheet. (you > could export the Customer/Aging Report to one sheet tab, export an Account or > Transaction Report to another in the same workbook, and then devise a 3rd tab > with references to those two to create the proper consolidated report) > > Note that doing it this way really isn’t necessary as GnuCash will track your > overall AR and the balance for each customer if you just leave the Credit > Notes hanging around until applied as future payments. > > I’d say you should speak to a local CPA, and then if you still have options, > which one you go with would be a matter of personal preference. > > Regards, > Adrien > >> On Jun 26, 2019, at 8:51 PM, Eric Rathhaus (general) via gnucash-user >> wrote: >> >> Hi Geert - >> >> I already issued the invoices and processed my clients payments against the >> invoices. These payments are for filing fees to the US government for which >> I subsequently cut checks. I created a job for this client that I use to >> invoice these fees alone. The size of the filing fees is too high for me to >> provide my client short-term loans to cover and then invoice later. My >> client, in turn, won’t issue a payment without an invoice. So I issue an >> invoice to my customer to get the prepayment. There are some complicated >> legal reasons why once per year some of the filing fees won’t be cashed by >> the government. The rest of the year everything is fine as I just ensure >> the client paid all the invoices for the special job and then bill for my >> work and other expenses on invoices for each specific job. This year I have >> over $12k of funds I need to return to the client somehow. In the past I >> created a credit note under the special job and sent my client a check. >> This year they want me to use the credit to offset invoices for subsequent >> work. I like the idea of creating a credit note under the special filing >> fee job I use for these payments and then applying the credit against other >> invoices I issue but I’m not sure if it will work from an accounting >> standpoint. >> >>> On Jun 26, 2019, at 1:29 PM, Geert Janssens >>> wrote: >>> >>> The way I understand your scenario I believe you can model what the >>> customer >>> does almost one to one into gnucash actions. >>> >>> 1. Customer prepays for expenses -> Create a payment for that customer >>> using >>> Business->Customer->Process Payment >>> You can choose to map this payment to outstanding invoices or not. If you >>> don't, it will simply register a prepayment for the customer. >>> >>> 2. At some point you send an invoice to the user -> Create this invoice >>> using >>> Business->Customer->New Invoice... and post it. >>> >>> 3. Now you can choose - does your invoice have (some of) the prepaid >>> expenses >>> ? If so, apply (part of) that prepayment to your invoice using Business- Customer->Process Payment >>> After this there may be an outstanding balance the customer still has to >>> pay. >>> >>> 4. If the customer pays that outstanding balance, create the payment via >>> Business->Customer->Process payment. >>> >>> Then repeat for the next cycle/invoice. >>> >>> If you are importing your payments instead of manually entering them, you >>> can >>> also select the payment in the respective account, right-click and choose >>> "Assign as payment..." instead of the above mentioned "Process Payment" >>> >>> As Adrien also suggests at any time you could look at the Receivables Aging >>> or >>> Customer report to see what's the customer's current balance. >>> >>> Regards, >>> >>> Geert >>> >>> Op woensdag 26 juni 2019 21:52:43 CEST schreef Adrien Monteleone: You have at least 2 options I can think of at the moment: #1 - continue to issue credit notes in your system, but don’t send them out or pay them with a check. When you have the next positive invoice, ‘pay’ a portion (or all) of that invoice with the credit note. Simply process a payment, select the credit note line and an invoice line you want to apply it to in the top part of the window. GnuCash will offset the invoice with the
Re: [GNC] best accounting practice for refund
In that case, certainly, you need to use credit notes. I don’t see any reason why this ‘wouldn’t work from an accounting standpoint’ but if you find a problem, instead of cutting a check to the customer as payment for the credit note, combine this with option #2 I listed, and this time, use that Liabilities:Customer Deposits account to ‘pay’ the credit note. This will show you have a liability to them and then you can decrease it by using it to later pay for future work. The credit note is cleared out instantly and you still track the money, however, any Aging Report or Customer Report will no longer reflect this deposit liability as a credit to them. You’d have to handle that part manually in an outside spreadsheet. (you could export the Customer/Aging Report to one sheet tab, export an Account or Transaction Report to another in the same workbook, and then devise a 3rd tab with references to those two to create the proper consolidated report) Note that doing it this way really isn’t necessary as GnuCash will track your overall AR and the balance for each customer if you just leave the Credit Notes hanging around until applied as future payments. I’d say you should speak to a local CPA, and then if you still have options, which one you go with would be a matter of personal preference. Regards, Adrien > On Jun 26, 2019, at 8:51 PM, Eric Rathhaus (general) via gnucash-user > wrote: > > Hi Geert - > > I already issued the invoices and processed my clients payments against the > invoices. These payments are for filing fees to the US government for which > I subsequently cut checks. I created a job for this client that I use to > invoice these fees alone. The size of the filing fees is too high for me to > provide my client short-term loans to cover and then invoice later. My > client, in turn, won’t issue a payment without an invoice. So I issue an > invoice to my customer to get the prepayment. There are some complicated > legal reasons why once per year some of the filing fees won’t be cashed by > the government. The rest of the year everything is fine as I just ensure the > client paid all the invoices for the special job and then bill for my work > and other expenses on invoices for each specific job. This year I have over > $12k of funds I need to return to the client somehow. In the past I created > a credit note under the special job and sent my client a check. This year > they want me to use the credit to offset invoices for subsequent work. I > like the idea of creating a credit note under the special filing fee job I > use for these payments and then applying the credit against other invoices I > issue but I’m not sure if it will work from an accounting standpoint. > >> On Jun 26, 2019, at 1:29 PM, Geert Janssens >> wrote: >> >> The way I understand your scenario I believe you can model what the customer >> does almost one to one into gnucash actions. >> >> 1. Customer prepays for expenses -> Create a payment for that customer using >> Business->Customer->Process Payment >> You can choose to map this payment to outstanding invoices or not. If you >> don't, it will simply register a prepayment for the customer. >> >> 2. At some point you send an invoice to the user -> Create this invoice using >> Business->Customer->New Invoice... and post it. >> >> 3. Now you can choose - does your invoice have (some of) the prepaid >> expenses >> ? If so, apply (part of) that prepayment to your invoice using Business- >>> Customer->Process Payment >> After this there may be an outstanding balance the customer still has to pay. >> >> 4. If the customer pays that outstanding balance, create the payment via >> Business->Customer->Process payment. >> >> Then repeat for the next cycle/invoice. >> >> If you are importing your payments instead of manually entering them, you >> can >> also select the payment in the respective account, right-click and choose >> "Assign as payment..." instead of the above mentioned "Process Payment" >> >> As Adrien also suggests at any time you could look at the Receivables Aging >> or >> Customer report to see what's the customer's current balance. >> >> Regards, >> >> Geert >> >> Op woensdag 26 juni 2019 21:52:43 CEST schreef Adrien Monteleone: >>> You have at least 2 options I can think of at the moment: >>> >>> #1 - continue to issue credit notes in your system, but don’t send them out >>> or pay them with a check. When you have the next positive invoice, ‘pay’ a >>> portion (or all) of that invoice with the credit note. Simply process a >>> payment, select the credit note line and an invoice line you want to apply >>> it to in the top part of the window. GnuCash will offset the invoice with >>> the credit note for you. If the credit note is more than the invoice, it >>> will retain the left over as remaining AR credit to be used on subsequent >>> invoices. You can see the customer’s balance any time either by
Re: [GNC] best accounting practice for refund
Hi Geert - I already issued the invoices and processed my clients payments against the invoices. These payments are for filing fees to the US government for which I subsequently cut checks. I created a job for this client that I use to invoice these fees alone. The size of the filing fees is too high for me to provide my client short-term loans to cover and then invoice later. My client, in turn, won’t issue a payment without an invoice. So I issue an invoice to my customer to get the prepayment. There are some complicated legal reasons why once per year some of the filing fees won’t be cashed by the government. The rest of the year everything is fine as I just ensure the client paid all the invoices for the special job and then bill for my work and other expenses on invoices for each specific job. This year I have over $12k of funds I need to return to the client somehow. In the past I created a credit note under the special job and sent my client a check. This year they want me to use the credit to offset invoices for subsequent work. I like the idea of creating a credit note under the special filing fee job I use for these payments and then applying the credit against other invoices I issue but I’m not sure if it will work from an accounting standpoint. > On Jun 26, 2019, at 1:29 PM, Geert Janssens > wrote: > > The way I understand your scenario I believe you can model what the customer > does almost one to one into gnucash actions. > > 1. Customer prepays for expenses -> Create a payment for that customer using > Business->Customer->Process Payment > You can choose to map this payment to outstanding invoices or not. If you > don't, it will simply register a prepayment for the customer. > > 2. At some point you send an invoice to the user -> Create this invoice using > Business->Customer->New Invoice... and post it. > > 3. Now you can choose - does your invoice have (some of) the prepaid expenses > ? If so, apply (part of) that prepayment to your invoice using Business- >> Customer->Process Payment > After this there may be an outstanding balance the customer still has to pay. > > 4. If the customer pays that outstanding balance, create the payment via > Business->Customer->Process payment. > > Then repeat for the next cycle/invoice. > > If you are importing your payments instead of manually entering them, you can > also select the payment in the respective account, right-click and choose > "Assign as payment..." instead of the above mentioned "Process Payment" > > As Adrien also suggests at any time you could look at the Receivables Aging > or > Customer report to see what's the customer's current balance. > > Regards, > > Geert > > Op woensdag 26 juni 2019 21:52:43 CEST schreef Adrien Monteleone: >> You have at least 2 options I can think of at the moment: >> >> #1 - continue to issue credit notes in your system, but don’t send them out >> or pay them with a check. When you have the next positive invoice, ‘pay’ a >> portion (or all) of that invoice with the credit note. Simply process a >> payment, select the credit note line and an invoice line you want to apply >> it to in the top part of the window. GnuCash will offset the invoice with >> the credit note for you. If the credit note is more than the invoice, it >> will retain the left over as remaining AR credit to be used on subsequent >> invoices. You can see the customer’s balance any time either by looking at >> an AR aging report, or a Customer Report. Outstanding credit notes appear >> in the Invoices Due Reminder window. >> >> #2 - If your client regularly pays in advance based on an estimate and you >> invoice later, instead of applying the payment to an invoice, apply it to a >> Liabilities:Customer Deposits account. Then when you create and post the >> final invoice, process a payment for it from this account. You could keep a >> separate deposit account for each customer but that might get tedious. You >> can run a report on the account sorted by payee to show that info and even >> keep that report open in a tab if desired, choosing to refresh it as >> needed. If this might only happen for pre-paid expenses, then you can still >> use this method, but only for the pre-paid expense part, which you could >> (or not) choose to invoice separately. >> >> Regards, >> Adrien >> >>> On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: >>> >>> Hi - I have a client for whom I have many jobs. On some of these jobs, >>> the client prepaid expenses that I did not use. In the past, I’ve always >>> created a credit note for a refund and sent the client a check. However, >>> my client prefers instead that I credit this amount towards future work. >>> I’m not sure how to accomplish this cleanly. I could keep a running >>> total of the amount and discount from the total prepayment until it’s >>> used up. But this seems clunky and maybe not the best practice. Any >>> other suggestions on how
Re: [GNC] GnuCash and OSX.15
> On Jun 26, 2019, at 10:42 AM, Alan Magnus wrote: > > When I open Gnucash in 10.15 this is what I see > > > > Open System Preferences and select Security and Privacy, then select the Privacy pane. In the list at the left scroll down to Files and Folders. Make sure that GnuCash is in the right pane and that Documents Folder is selected. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] best accounting practice for refund
You’re welcome. That would work for existing excess pre-payments that were already applied to an existing invoice. But for future such cases, probably option #3 would be the simplest unless you really need to issue credit notes for some reason. I guess otherwise, it is a personal preference. Regards, Adrien > On Jun 26, 2019, at 5:36 PM, Eric Rathhaus (general) > wrote: > > Thanks Adrien. I think option 1 sounds best as it is one client with > multiple jobs. > >> On Jun 26, 2019, at 12:52 PM, Adrien Monteleone >> wrote: >> >> You have at least 2 options I can think of at the moment: >> >> #1 - continue to issue credit notes in your system, but don’t send them out >> or pay them with a check. When you have the next positive invoice, ‘pay’ a >> portion (or all) of that invoice with the credit note. Simply process a >> payment, select the credit note line and an invoice line you want to apply >> it to in the top part of the window. GnuCash will offset the invoice with >> the credit note for you. If the credit note is more than the invoice, it >> will retain the left over as remaining AR credit to be used on subsequent >> invoices. You can see the customer’s balance any time either by looking at >> an AR aging report, or a Customer Report. Outstanding credit notes appear in >> the Invoices Due Reminder window. >> >> #2 - If your client regularly pays in advance based on an estimate and you >> invoice later, instead of applying the payment to an invoice, apply it to a >> Liabilities:Customer Deposits account. Then when you create and post the >> final invoice, process a payment for it from this account. You could keep a >> separate deposit account for each customer but that might get tedious. You >> can run a report on the account sorted by payee to show that info and even >> keep that report open in a tab if desired, choosing to refresh it as needed. >> If this might only happen for pre-paid expenses, then you can still use this >> method, but only for the pre-paid expense part, which you could (or not) >> choose to invoice separately. >> >> Regards, >> Adrien >> >>> On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: >>> >>> Hi - I have a client for whom I have many jobs. On some of these jobs, the >>> client prepaid expenses that I did not use. In the past, I’ve always >>> created a credit note for a refund and sent the client a check. However, >>> my client prefers instead that I credit this amount towards future work. >>> I’m not sure how to accomplish this cleanly. I could keep a running total >>> of the amount and discount from the total prepayment until it’s used up. >>> But this seems clunky and maybe not the best practice. Any other >>> suggestions on how to account for the refund against future work? >>> >>> Kind regards, >>> >>> Eric W. Rathhaus >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] best accounting practice for refund
Thanks Adrien. I think option 1 sounds best as it is one client with multiple jobs. > On Jun 26, 2019, at 12:52 PM, Adrien Monteleone > wrote: > > You have at least 2 options I can think of at the moment: > > #1 - continue to issue credit notes in your system, but don’t send them out > or pay them with a check. When you have the next positive invoice, ‘pay’ a > portion (or all) of that invoice with the credit note. Simply process a > payment, select the credit note line and an invoice line you want to apply it > to in the top part of the window. GnuCash will offset the invoice with the > credit note for you. If the credit note is more than the invoice, it will > retain the left over as remaining AR credit to be used on subsequent > invoices. You can see the customer’s balance any time either by looking at an > AR aging report, or a Customer Report. Outstanding credit notes appear in the > Invoices Due Reminder window. > > #2 - If your client regularly pays in advance based on an estimate and you > invoice later, instead of applying the payment to an invoice, apply it to a > Liabilities:Customer Deposits account. Then when you create and post the > final invoice, process a payment for it from this account. You could keep a > separate deposit account for each customer but that might get tedious. You > can run a report on the account sorted by payee to show that info and even > keep that report open in a tab if desired, choosing to refresh it as needed. > If this might only happen for pre-paid expenses, then you can still use this > method, but only for the pre-paid expense part, which you could (or not) > choose to invoice separately. > > Regards, > Adrien > >> On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: >> >> Hi - I have a client for whom I have many jobs. On some of these jobs, the >> client prepaid expenses that I did not use. In the past, I’ve always >> created a credit note for a refund and sent the client a check. However, my >> client prefers instead that I credit this amount towards future work. I’m >> not sure how to accomplish this cleanly. I could keep a running total of >> the amount and discount from the total prepayment until it’s used up. But >> this seems clunky and maybe not the best practice. Any other suggestions on >> how to account for the refund against future work? >> >> Kind regards, >> >> Eric W. Rathhaus > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] best accounting practice for refund
Thanks, Derek. But the refund comes from several jobs for which I sent one invoice in advance to cover costs. Subsequently those costs were not incurred for some but not all the jobs. And how does the credit note get accounted for when using the sum to pay for future invoices? > On Jun 26, 2019, at 1:24 PM, Derek Atkins wrote: > > You would only need a credit note if a client cancelled their contract and > wanted (part of) their deposit back. > > -derek > Sent using my mobile device. Please excuse any typos. > On June 26, 2019 10:21:56 PM Tim Quinn wrote: > >> Many of my wife’s tutoring clients will prepay for several sessions (to get >> scheduling preference and a slight price discount). I create a separate >> invoice for each client visit (that way the customer report shows the >> payments and individual sessions nicely), and after posting each invoice I >> pay it using the remaining balance from the prepayment. GnuCash keeps track >> of all that very nicely as Adrien described. >> >> I have never used credit notes for this, though. GnuCash knows that the >> subsequent invoices and the prepayment involve the same customer so it’s >> really easy to pay those later invoices using what’s left of the prepayment. >> >> I am not seeing the value in adding credit notes into this picture. Am I >> missing something? >> >> Thanks. >> >> - Tim >> >>> On Jun 26, 2019, at 2:52 PM, Adrien Monteleone >>> wrote: >>> >>> You have at least 2 options I can think of at the moment: >>> >>> #1 - continue to issue credit notes in your system, but don’t send them out >>> or pay them with a check. When you have the next positive invoice, ‘pay’ a >>> portion (or all) of that invoice with the credit note. Simply process a >>> payment, select the credit note line and an invoice line you want to apply >>> it to in the top part of the window. GnuCash will offset the invoice with >>> the credit note for you. If the credit note is more than the invoice, it >>> will retain the left over as remaining AR credit to be used on subsequent >>> invoices. You can see the customer’s balance any time either by looking at >>> an AR aging report, or a Customer Report. Outstanding credit notes appear >>> in the Invoices Due Reminder window. >>> >>> #2 - If your client regularly pays in advance based on an estimate and you >>> invoice later, instead of applying the payment to an invoice, apply it to a >>> Liabilities:Customer Deposits account. Then when you create and post the >>> final invoice, process a payment for it from this account. You could keep a >>> separate deposit account for each customer but that might get tedious. You >>> can run a report on the account sorted by payee to show that info and even >>> keep that report open in a tab if desired, choosing to refresh it as >>> needed. If this might only happen for pre-paid expenses, then you can still >>> use this method, but only for the pre-paid expense part, which you could >>> (or not) choose to invoice separately. >>> >>> Regards, >>> Adrien >>> On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: Hi - I have a client for whom I have many jobs. On some of these jobs, the client prepaid expenses that I did not use. In the past, I’ve always created a credit note for a refund and sent the client a check. However, my client prefers instead that I credit this amount towards future work. I’m not sure how to accomplish this cleanly. I could keep a running total of the amount and discount from the total prepayment until it’s used up. But this seems clunky and maybe not the best practice. Any other suggestions on how to account for the refund against future work? Kind regards, Eric W. Rathhaus >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: >
Re: [GNC] Column Detection when Importing Transactions from CSV
On 6/26/19 12:31 PM, Patrick wrote: > When importing transactions from a CSV file, is there a way to have GnuCash > automatically detect the meaning of the columns based on the CSV headers? > The headers in my CSV file are "Date", "Description", "Account", etc., so I > was wondering if GnuCash had the ability to determine what the columns were > from these headers, so that I don't have to select them from the dropdown > menus every time I do an import. > > Regards, > Patrick The screen where you pick these has a field at the very top where you can name this setup and then save it. You will have to select this name on the next import but it will remember: * The field assignments * The account into which you are doing the import * The date format * How many lines to skip It was a big help when I discovered that! --Steve -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Employees function fields
GNUCash Gurus, I have a couple questions about the Employees section of GNUCash. I have gone through all the available online documentation I was able to find and tried searching the list archives but wasn’t able to locate what I needed so I thought I’d try posting to the list. 1) What is the purpose of the Username field when creating a new user. If the employee is uniquely identified by the Employee Number field, what does the Username field add / do differently? 2) What is the Credit Account field in the Billing section for? At first I thought it would be the credit account for vouchers (i.e. the A/P liability) but that seems to be handled at the point I post a voucher and this field only allows me to choose accounts of type Credit Card so I’m at a loss as to its purpose. The docs don’t say anything about it other than that it exists so I thought I’d inquire here. Thanks very much, Scott ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] best accounting practice for refund
Yes, that’s more along the lines of what I thought a credit memo would fit for. That said, there are cases in which a client pays full rate for one session, then decides to convert to a package of sessions. I record the “ex post facto” discount to apply to that first session as a credit memo and use that in paying the next session. I could probably just record the discount as a line in the invoice for the next session, but that requires me to remember to do that later and GnuCash is better at remembering things than I am. - Tim > On Jun 26, 2019, at 3:24 PM, Derek Atkins wrote: > > You would only need a credit note if a client cancelled their contract and > wanted (part of) their deposit back. > > -derek > Sent using my mobile device. Please excuse any typos. > On June 26, 2019 10:21:56 PM Tim Quinn wrote: > >> Many of my wife’s tutoring clients will prepay for several sessions (to get >> scheduling preference and a slight price discount). I create a separate >> invoice for each client visit (that way the customer report shows the >> payments and individual sessions nicely), and after posting each invoice I >> pay it using the remaining balance from the prepayment. GnuCash keeps track >> of all that very nicely as Adrien described. >> >> I have never used credit notes for this, though. GnuCash knows that the >> subsequent invoices and the prepayment involve the same customer so it’s >> really easy to pay those later invoices using what’s left of the prepayment. >> >> I am not seeing the value in adding credit notes into this picture. Am I >> missing something? >> >> Thanks. >> >> - Tim >> >>> On Jun 26, 2019, at 2:52 PM, Adrien Monteleone >>> wrote: >>> >>> You have at least 2 options I can think of at the moment: >>> >>> #1 - continue to issue credit notes in your system, but don’t send them out >>> or pay them with a check. When you have the next positive invoice, ‘pay’ a >>> portion (or all) of that invoice with the credit note. Simply process a >>> payment, select the credit note line and an invoice line you want to apply >>> it to in the top part of the window. GnuCash will offset the invoice with >>> the credit note for you. If the credit note is more than the invoice, it >>> will retain the left over as remaining AR credit to be used on subsequent >>> invoices. You can see the customer’s balance any time either by looking at >>> an AR aging report, or a Customer Report. Outstanding credit notes appear >>> in the Invoices Due Reminder window. >>> >>> #2 - If your client regularly pays in advance based on an estimate and you >>> invoice later, instead of applying the payment to an invoice, apply it to a >>> Liabilities:Customer Deposits account. Then when you create and post the >>> final invoice, process a payment for it from this account. You could keep a >>> separate deposit account for each customer but that might get tedious. You >>> can run a report on the account sorted by payee to show that info and even >>> keep that report open in a tab if desired, choosing to refresh it as >>> needed. If this might only happen for pre-paid expenses, then you can still >>> use this method, but only for the pre-paid expense part, which you could >>> (or not) choose to invoice separately. >>> >>> Regards, >>> Adrien >>> On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: Hi - I have a client for whom I have many jobs. On some of these jobs, the client prepaid expenses that I did not use. In the past, I’ve always created a credit note for a refund and sent the client a check. However, my client prefers instead that I credit this amount towards future work. I’m not sure how to accomplish this cleanly. I could keep a running total of the amount and discount from the total prepayment until it’s used up. But this seems clunky and maybe not the best practice. Any other suggestions on how to account for the refund against future work? Kind regards, Eric W. Rathhaus >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this
Re: [GNC] best accounting practice for refund
Thanks Tim, I forgot about that method, so: #3 - enter a payment from a customer without choosing an invoice to post it against. GnuCash will retain that amount as a pre-payment you can apply later as needed. (same procedure as outlined in #1) Individual customer balances are available from the Receivables Aging Report or a Customer Report. I’m going to look over the wiki and documentation, and if this or more isn’t there, document it under "Using GnuCash”. This general question seems to come up often enough on the list. Regards, Adrien > On Jun 26, 2019, at 3:20 PM, Tim Quinn wrote: > > Many of my wife’s tutoring clients will prepay for several sessions (to get > scheduling preference and a slight price discount). I create a separate > invoice for each client visit (that way the customer report shows the > payments and individual sessions nicely), and after posting each invoice I > pay it using the remaining balance from the prepayment. GnuCash keeps track > of all that very nicely as Adrien described. > > I have never used credit notes for this, though. GnuCash knows that the > subsequent invoices and the prepayment involve the same customer so it’s > really easy to pay those later invoices using what’s left of the prepayment. > > I am not seeing the value in adding credit notes into this picture. Am I > missing something? > > Thanks. > > - Tim > >> On Jun 26, 2019, at 2:52 PM, Adrien Monteleone >> wrote: >> >> You have at least 2 options I can think of at the moment: >> >> #1 - continue to issue credit notes in your system, but don’t send them out >> or pay them with a check. When you have the next positive invoice, ‘pay’ a >> portion (or all) of that invoice with the credit note. Simply process a >> payment, select the credit note line and an invoice line you want to apply >> it to in the top part of the window. GnuCash will offset the invoice with >> the credit note for you. If the credit note is more than the invoice, it >> will retain the left over as remaining AR credit to be used on subsequent >> invoices. You can see the customer’s balance any time either by looking at >> an AR aging report, or a Customer Report. Outstanding credit notes appear in >> the Invoices Due Reminder window. >> >> #2 - If your client regularly pays in advance based on an estimate and you >> invoice later, instead of applying the payment to an invoice, apply it to a >> Liabilities:Customer Deposits account. Then when you create and post the >> final invoice, process a payment for it from this account. You could keep a >> separate deposit account for each customer but that might get tedious. You >> can run a report on the account sorted by payee to show that info and even >> keep that report open in a tab if desired, choosing to refresh it as needed. >> If this might only happen for pre-paid expenses, then you can still use this >> method, but only for the pre-paid expense part, which you could (or not) >> choose to invoice separately. >> >> Regards, >> Adrien >> >>> On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: >>> >>> Hi - I have a client for whom I have many jobs. On some of these jobs, the >>> client prepaid expenses that I did not use. In the past, I’ve always >>> created a credit note for a refund and sent the client a check. However, >>> my client prefers instead that I credit this amount towards future work. >>> I’m not sure how to accomplish this cleanly. I could keep a running total >>> of the amount and discount from the total prepayment until it’s used up. >>> But this seems clunky and maybe not the best practice. Any other >>> suggestions on how to account for the refund against future work? >>> >>> Kind regards, >>> >>> Eric W. Rathhaus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] best accounting practice for refund
You would only need a credit note if a client cancelled their contract and wanted (part of) their deposit back. -derek Sent using my mobile device. Please excuse any typos. On June 26, 2019 10:21:56 PM Tim Quinn wrote: Many of my wife’s tutoring clients will prepay for several sessions (to get scheduling preference and a slight price discount). I create a separate invoice for each client visit (that way the customer report shows the payments and individual sessions nicely), and after posting each invoice I pay it using the remaining balance from the prepayment. GnuCash keeps track of all that very nicely as Adrien described. I have never used credit notes for this, though. GnuCash knows that the subsequent invoices and the prepayment involve the same customer so it’s really easy to pay those later invoices using what’s left of the prepayment. I am not seeing the value in adding credit notes into this picture. Am I missing something? Thanks. - Tim On Jun 26, 2019, at 2:52 PM, Adrien Monteleone wrote: You have at least 2 options I can think of at the moment: #1 - continue to issue credit notes in your system, but don’t send them out or pay them with a check. When you have the next positive invoice, ‘pay’ a portion (or all) of that invoice with the credit note. Simply process a payment, select the credit note line and an invoice line you want to apply it to in the top part of the window. GnuCash will offset the invoice with the credit note for you. If the credit note is more than the invoice, it will retain the left over as remaining AR credit to be used on subsequent invoices. You can see the customer’s balance any time either by looking at an AR aging report, or a Customer Report. Outstanding credit notes appear in the Invoices Due Reminder window. #2 - If your client regularly pays in advance based on an estimate and you invoice later, instead of applying the payment to an invoice, apply it to a Liabilities:Customer Deposits account. Then when you create and post the final invoice, process a payment for it from this account. You could keep a separate deposit account for each customer but that might get tedious. You can run a report on the account sorted by payee to show that info and even keep that report open in a tab if desired, choosing to refresh it as needed. If this might only happen for pre-paid expenses, then you can still use this method, but only for the pre-paid expense part, which you could (or not) choose to invoice separately. Regards, Adrien On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: Hi - I have a client for whom I have many jobs. On some of these jobs, the client prepaid expenses that I did not use. In the past, I’ve always created a credit note for a refund and sent the client a check. However, my client prefers instead that I credit this amount towards future work. I’m not sure how to accomplish this cleanly. I could keep a running total of the amount and discount from the total prepayment until it’s used up. But this seems clunky and maybe not the best practice. Any other suggestions on how to account for the refund against future work? Kind regards, Eric W. Rathhaus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Column Detection when Importing Transactions from CSV
Thank you for the response and for the helpful guidance. I am using version 3.5, and I see now that there is an option to "Save Settings" in the CSV importer. Regards, Patrick On Wed, Jun 26, 2019 at 2:54 PM Geert Janssens wrote: > Op woensdag 26 juni 2019 21:31:54 CEST schreef Patrick: > > When importing transactions from a CSV file, is there a way to have > GnuCash > > automatically detect the meaning of the columns based on the CSV headers? > > The headers in my CSV file are "Date", "Description", "Account", etc., > so I > > was wondering if GnuCash had the ability to determine what the columns > were > > from these headers, so that I don't have to select them from the dropdown > > menus every time I do an import. > > > > Regards, > > Patrick > > GnuCash can't guess, but as of version 3.0 you can set the columns once > and > save this preset for a future import. So if the columns in your csv files > are > not changing this should reduce the amount of work on import. > > Regards, > > Geert > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] best accounting practice for refund
You have at least 2 options I can think of at the moment: #1 - continue to issue credit notes in your system, but don’t send them out or pay them with a check. When you have the next positive invoice, ‘pay’ a portion (or all) of that invoice with the credit note. Simply process a payment, select the credit note line and an invoice line you want to apply it to in the top part of the window. GnuCash will offset the invoice with the credit note for you. If the credit note is more than the invoice, it will retain the left over as remaining AR credit to be used on subsequent invoices. You can see the customer’s balance any time either by looking at an AR aging report, or a Customer Report. Outstanding credit notes appear in the Invoices Due Reminder window. #2 - If your client regularly pays in advance based on an estimate and you invoice later, instead of applying the payment to an invoice, apply it to a Liabilities:Customer Deposits account. Then when you create and post the final invoice, process a payment for it from this account. You could keep a separate deposit account for each customer but that might get tedious. You can run a report on the account sorted by payee to show that info and even keep that report open in a tab if desired, choosing to refresh it as needed. If this might only happen for pre-paid expenses, then you can still use this method, but only for the pre-paid expense part, which you could (or not) choose to invoice separately. Regards, Adrien > On Jun 26, 2019, at 1:46 PM, Eric Rathhaus office wrote: > > Hi - I have a client for whom I have many jobs. On some of these jobs, the > client prepaid expenses that I did not use. In the past, I’ve always created > a credit note for a refund and sent the client a check. However, my client > prefers instead that I credit this amount towards future work. I’m not sure > how to accomplish this cleanly. I could keep a running total of the amount > and discount from the total prepayment until it’s used up. But this seems > clunky and maybe not the best practice. Any other suggestions on how to > account for the refund against future work? > > Kind regards, > > Eric W. Rathhaus ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash and OSX.15
Click either yes or no then use File > Open to browse the file you want to open. Presumably that is not the file mentioned in the dialog as that does not exist. Colin On Wed, 26 Jun 2019 at 18:42, Alan Magnus wrote: > When I open Gnucash in 10.15 this is what I see > > > > > Alan Magnus > Kingston, Jamaica > Caribbean > alanmag...@flowja.com > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash and OSX.15
When I open Gnucash in 10.15 this is what I see Alan Magnus Kingston, Jamaica Caribbean alanmag...@flowja.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash and OSX.15
On Wed, Jun 26, 2019, 07:06 Alan Magnus via gnucash-user < gnucash-user@gnucash.org> wrote: > I am running the new beta version of OSX v15 on a Mac. Since installation, > Gnucash will not run saying my file cannot be found. Seems more likely that GnuCash is running, but cannot find your working file. I have tried selecting files directly and trying to open them. No luck. There is a known issue on Macs, where GnuCash always tries to open the last file that it worked with. Often, Mac users report clicking on a working file, and GnuCash starts and opens a different file, or GnuCash starts and cannot find the file, even though the user just clicked on it. > Any ideas of what the problem is? > After GnuCash starts clear/acknowledge any error messages, and from the main menu, select file>open, and then navigate to the file you want to open. When you do this, GnuCash will ask you if you want to save the current file (a default file it opens when it cannot find the file it wanted to). You shouldn't need to bother saving it. Good luck! > > Alan Magnus > Kingston, Jamaica > Caribbean > alanmag...@flowja.com > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash and OSX.15
> On Jun 26, 2019, at 9:37 AM, Alan Magnus via gnucash-user > wrote: > > I am running the new beta version of OSX v15 on a Mac. Since installation, > Gnucash will not run saying my file cannot be found. I have tried selecting > files directly and trying to open them. No luck. Any ideas of what the > problem is? > > Alan Magnus > Kingston, Jamaica > Caribbean > alanmag...@flowja.com > > Gnucash 3.2 and 3.5 work for me in Mac OS 10.15. Finance-Quote is not working, but I have to figure out if that’s me or if it’s Apple. Dave -- Dave Reiser dbrei...@icloud.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash and OSX.15
Have you tried using File > Open and browsing to the file? If that doesn't work then what happens. Note that if you are on a Mac you can't open the file by double clicking it, if that is what you were doing. Colin On Wed, 26 Jun 2019 at 15:06, Alan Magnus via gnucash-user wrote: > > I am running the new beta version of OSX v15 on a Mac. Since installation, > Gnucash will not run saying my file cannot be found. I have tried selecting > files directly and trying to open them. No luck. Any ideas of what the > problem is? > > Alan Magnus > Kingston, Jamaica > Caribbean > alanmag...@flowja.com > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash and OSX.15
I am running the new beta version of OSX v15 on a Mac. Since installation, Gnucash will not run saying my file cannot be found. I have tried selecting files directly and trying to open them. No luck. Any ideas of what the problem is? Alan Magnus Kingston, Jamaica Caribbean alanmag...@flowja.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.