Re: [GNC] Processing refunds
On Tue, 15 Dec 2020 21:50:07 +0300 Parker Graham wrote: > You sent this to wrong email > > > > Sent from myMail for iOS > A misconception. As the moderator, I can see that Parker Graham, of the given email address is subscribed to the Gnucash-user mailing list. The Gnucash-user mailing list sent the mail, not the author of the email. It is courteous to use the list for all queries and replies. Subscribers who don't want to receive the emails can alter this themselves from the Gnucash-user Mailman interface. The address is at the bottom of every email. Liz ___ 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] Processing refunds
That’s very strange. I didn’t send it to your address. I sent it using Thunderbird’s NewsReader via Gmane only to the list. (though you might well receive the list messages via e-mail) And I’m sending this reply the same way. Regards, Adrien On 12/15/20 12:50 PM, Parker Graham wrote: You sent this to wrong email Sent from myMail for iOS Tuesday, December 15, 2020, 1:47 PM -0500 from Adrien Monteleone : Unless you posted invoices for the rest of the year, you should not have issued a credit note. I just did a test book with the following transactions: 1. Annual pre-payment for 1 year @ $1200 (assuming $100/month) 2. Invoice for Dues on 1/31/20 posted. 3. Applied a portion of pre-payment to invoice of 1/31/20 ($1100 pre-payment remaining) 4. Invoice for Dues on 2/28/20 posted. 5. Applied a portion of pre-payment to invoice of 2/28/20 ($1000 pre-payment remaining) 6. Invoice for Dues on 3/31/20 posted. 7. Applied a portion of pre-payment to invoice of 3/31/20 ($900 pre-payment remaining) At this point the Customer has a credit of $900. There is no need to issue a credit note. (they have not been 'invoiced' for dues not yet paid, but the opposite) So an 8th transaction would be in order: 8. Refund of $900. Do this using 'Business > Customer > Process Payment' for the date you issued the refund; select the Pre-payment line (there should be no invoices still visible to select) and make sure the 'Payment' box shows "0.00" and the 'Refund' box shows the remaining amount of their pre-payment that you are refunding. (that should happen by default when you select the pre-payment line) Be sure to select the proper asset account from which you are issuing the refund. (Checking, Cash, etc.) Re-load or re-run the applicable Customer Report to verify the Totals. Also note you can now show 'links' to relevant documents under Options > Display. I prefer 'detailed' but use whatever you find best. Showing links will make it clear what payments applied to which invoices. Regards, Adrien On 12/12/20 2:56 PM, Don Earnhardt wrote: I am really struggling with this. Creating and paying a Credit Note does indeed reduce the income appropriately. However, the Customer Report shows a Totals increase instead of a reduction. Here is my situation. I use GnuCash to manage income and expenses for a non-profit organization (actually a community band). Our members pay monthly dues, and frequently people pay quarterly, semi-annually, and even annually. Therefore several people paid in advance at the beginning of the year. Now that COVID has prevented us from meeting since the end of March, I would like to refund the dues over payments to those members who have paid in advance (beyond the first quarter). At the end of each quarter, I print Customer Reports for each member to show how much they have paid. I create and Pay Invoices to show their payments on the Customer Report. The statements accumulate so that the last one of the year shows everything that was paid for the year. I would like for the refunded payments to reduce the Totals at the bottom of the Customer Report, but instead the refunds look like additional payments, increasing the Total, instead of Reducing them. What can I do to show the refunds correctly? ___ 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] Processing refunds
You sent this to wrong email Sent from myMail for iOS Tuesday, December 15, 2020, 1:47 PM -0500 from Adrien Monteleone : >Unless you posted invoices for the rest of the year, you should not have >issued a credit note. > >I just did a test book with the following transactions: > >1. Annual pre-payment for 1 year @ $1200 (assuming $100/month) >2. Invoice for Dues on 1/31/20 posted. >3. Applied a portion of pre-payment to invoice of 1/31/20 ($1100 >pre-payment remaining) >4. Invoice for Dues on 2/28/20 posted. >5. Applied a portion of pre-payment to invoice of 2/28/20 ($1000 >pre-payment remaining) >6. Invoice for Dues on 3/31/20 posted. >7. Applied a portion of pre-payment to invoice of 3/31/20 ($900 >pre-payment remaining) > >At this point the Customer has a credit of $900. There is no need to >issue a credit note. (they have not been 'invoiced' for dues not yet >paid, but the opposite) > >So an 8th transaction would be in order: > >8. Refund of $900. > >Do this using 'Business > Customer > Process Payment' for the date you >issued the refund; select the Pre-payment line (there should be no >invoices still visible to select) and make sure the 'Payment' box shows >"0.00" and the 'Refund' box shows the remaining amount of their >pre-payment that you are refunding. (that should happen by default when >you select the pre-payment line) Be sure to select the proper asset >account from which you are issuing the refund. (Checking, Cash, etc.) > >Re-load or re-run the applicable Customer Report to verify the Totals. >Also note you can now show 'links' to relevant documents under Options > >Display. I prefer 'detailed' but use whatever you find best. Showing >links will make it clear what payments applied to which invoices. > >Regards, >Adrien > >On 12/12/20 2:56 PM, Don Earnhardt wrote: >> I am really struggling with this. Creating and paying a Credit Note does >> indeed reduce the income appropriately. However, the Customer Report shows >> a Totals increase instead of a reduction. Here is my situation. I use >> GnuCash to manage income and expenses for a non-profit organization >> (actually a community band). Our members pay monthly dues, and frequently >> people pay quarterly, semi-annually, and even annually. Therefore several >> people paid in advance at the beginning of the year. Now that COVID has >> prevented us from meeting since the end of March, I would like to refund the >> dues over payments to those members who have paid in advance (beyond the >> first quarter). >> >> At the end of each quarter, I print Customer Reports for each member to show >> how much they have paid. I create and Pay Invoices to show their payments on >> the Customer Report. The statements accumulate so that the last one of the >> year shows everything that was paid for the year. I would like for the >> refunded payments to reduce the Totals at the bottom of the Customer Report, >> but instead the refunds look like additional payments, increasing the Total, >> instead of Reducing them. What can I do to show the refunds correctly? > >___ >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] Processing refunds
Unless you posted invoices for the rest of the year, you should not have issued a credit note. I just did a test book with the following transactions: 1. Annual pre-payment for 1 year @ $1200 (assuming $100/month) 2. Invoice for Dues on 1/31/20 posted. 3. Applied a portion of pre-payment to invoice of 1/31/20 ($1100 pre-payment remaining) 4. Invoice for Dues on 2/28/20 posted. 5. Applied a portion of pre-payment to invoice of 2/28/20 ($1000 pre-payment remaining) 6. Invoice for Dues on 3/31/20 posted. 7. Applied a portion of pre-payment to invoice of 3/31/20 ($900 pre-payment remaining) At this point the Customer has a credit of $900. There is no need to issue a credit note. (they have not been 'invoiced' for dues not yet paid, but the opposite) So an 8th transaction would be in order: 8. Refund of $900. Do this using 'Business > Customer > Process Payment' for the date you issued the refund; select the Pre-payment line (there should be no invoices still visible to select) and make sure the 'Payment' box shows "0.00" and the 'Refund' box shows the remaining amount of their pre-payment that you are refunding. (that should happen by default when you select the pre-payment line) Be sure to select the proper asset account from which you are issuing the refund. (Checking, Cash, etc.) Re-load or re-run the applicable Customer Report to verify the Totals. Also note you can now show 'links' to relevant documents under Options > Display. I prefer 'detailed' but use whatever you find best. Showing links will make it clear what payments applied to which invoices. Regards, Adrien On 12/12/20 2:56 PM, Don Earnhardt wrote: I am really struggling with this. Creating and paying a Credit Note does indeed reduce the income appropriately. However, the Customer Report shows a Totals increase instead of a reduction. Here is my situation. I use GnuCash to manage income and expenses for a non-profit organization (actually a community band). Our members pay monthly dues, and frequently people pay quarterly, semi-annually, and even annually. Therefore several people paid in advance at the beginning of the year. Now that COVID has prevented us from meeting since the end of March, I would like to refund the dues over payments to those members who have paid in advance (beyond the first quarter). At the end of each quarter, I print Customer Reports for each member to show how much they have paid. I create and Pay Invoices to show their payments on the Customer Report. The statements accumulate so that the last one of the year shows everything that was paid for the year. I would like for the refunded payments to reduce the Totals at the bottom of the Customer Report, but instead the refunds look like additional payments, increasing the Total, instead of Reducing them. What can I do to show the refunds correctly? ___ 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] Processing refunds
I am really struggling with this. Creating and paying a Credit Note does indeed reduce the income appropriately. However, the Customer Report shows a Totals increase instead of a reduction. Here is my situation. I use GnuCash to manage income and expenses for a non-profit organization (actually a community band). Our members pay monthly dues, and frequently people pay quarterly, semi-annually, and even annually. Therefore several people paid in advance at the beginning of the year. Now that COVID has prevented us from meeting since the end of March, I would like to refund the dues over payments to those members who have paid in advance (beyond the first quarter). At the end of each quarter, I print Customer Reports for each member to show how much they have paid. I create and Pay Invoices to show their payments on the Customer Report. The statements accumulate so that the last one of the year shows everything that was paid for the year. I would like for the refunded payments to reduce the Totals at the bottom of the Customer Report, but instead the refunds look like additional payments, increasing the Total, instead of Reducing them. What can I do to show the refunds correctly? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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] Processing refunds
Op vrijdag 22 maart 2019 19:41:23 CET schreef Geert Janssens: > Hi Martijn, > > You create a Credit Memo by selecting > Business->Customer->New Invoice... > And then in the invoice window select Credit Note rather than invoice. > > As a sidenote, please trim your reply and fix the subject if you reply to a > digest message. Thanks. ...which I promptly failed to do myself :( Sorry about that. I must be tired. 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] Processing refunds
Op donderdag 21 maart 2019 14:59:29 CET schreef Martijn Heuts: > Hello, > When I process a refund I pull up the customer's invoice, click on 'Pay > invoices' and enter therefund amount in the 'refund' column. My P&L report > did not show a difference when I compared it before and after processing > the refund.Is there another way I should process the refund or is there a > better report to show this refund? I would think the total income on the > P&L should be less the refund. Thanks for giving my better insight in > GNUcash! > Martijn As far as I understand paying a refund doesn't change your income. It only moves money from one asset account (your bank account) to another asset account (your accounts receivable). Your exact use case is not very clear from your description. What's the reason of the refund ? * Did the customer pay you more than you invoiced ? In that case the income was already created by the invoice, the (over)payment and refund were merely asset moves. * Was part of an invoice disputed and the user requested a reduction ? In that case you should create a credit note first (which would decrease your income), and the refund would be to "pay" for this credit note. 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.