Re: Applying Customer overpayments
copying to list - sorry still using a webmail interface I'm not used to. - Alan, When making the payment, you should have had the option to choose the balancing account, you would have had to select AR instead of Checking if I recall correctly. I'd delete the entire payment and re-apply it. The overpayment resides in AR as a contra-balance. You could transfer this to a Customer Deposits liability account if you think you won't apply it for some time and don't want to lose track or just want to keep things neat and tidy. Doing this also allows you to see WHO has overpaid/pre-paid and by how much. If the money stays in AR it's just a lump total for all customers. You could also end up with odd balances in AR and not see clearly why at a glance without sifting through historical transactions. Regards, Adrien On Fri, Feb 9, 2018 at 12:45 AM, Alan Johnsonwrote: > > *replying to the list > > Geert, > > Thanks. That worked. However it wanted to apply the funds to the checking > account (which were already deposited/received). I deleted that part of the > transaction from the AR register, and the balance offset still works, just > does not reflect as a payment on the customer report. Is there a better > account to debit the funds? In the balance sheet / P I don't see any sort > of customer funds held/liability that would be where the offset would go. > > Also, this feature wasn't in the documentation (at least that I could > find). The documentation merely states that GnuCash would keep track of any > overpayment. It sounds like a feature like QuickBoox payment system check > box "Apply customer balance to invoice" is needed. > Alan > > > > On 2/8/2018 1:09 PM, Geert Janssens wrote: > >> Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson: >> >>> Hello, I'm having an issue with GnuCash. A customer has a >>> overpayment/credit balance. How do I apply it to an invoice so that it >>> comes out of the AR report at the bottom of the customer report? The >>> total due / sums are correct, but the customer report has a 91+ day >>> balance of (0.03). I would like to apply the payment to an invoice / fix >>> the AR box on the customer report. This is on version 2.6.19. >>> >>> - Go to Business->Customer->Process Payment >> - Select the customer you refer to above >> - You should get a list of open invoices and overpayments >> - Select both the 0.03 overpayment and the invoice you want to apply it to >> (using shift- or ctrl-click) >> - If you only want to apply this 0.03, adjust the amount to exactly that >> 0.03 >> - Click Ok >> >> 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. > ___ 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: Applying Customer overpayments
*replying to the list Geert, Thanks. That worked. However it wanted to apply the funds to the checking account (which were already deposited/received). I deleted that part of the transaction from the AR register, and the balance offset still works, just does not reflect as a payment on the customer report. Is there a better account to debit the funds? In the balance sheet / P I don't see any sort of customer funds held/liability that would be where the offset would go. Also, this feature wasn't in the documentation (at least that I could find). The documentation merely states that GnuCash would keep track of any overpayment. It sounds like a feature like QuickBoox payment system check box "Apply customer balance to invoice" is needed. Alan On 2/8/2018 1:09 PM, Geert Janssens wrote: Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson: Hello, I'm having an issue with GnuCash. A customer has a overpayment/credit balance. How do I apply it to an invoice so that it comes out of the AR report at the bottom of the customer report? The total due / sums are correct, but the customer report has a 91+ day balance of (0.03). I would like to apply the payment to an invoice / fix the AR box on the customer report. This is on version 2.6.19. - Go to Business->Customer->Process Payment - Select the customer you refer to above - You should get a list of open invoices and overpayments - Select both the 0.03 overpayment and the invoice you want to apply it to (using shift- or ctrl-click) - If you only want to apply this 0.03, adjust the amount to exactly that 0.03 - Click Ok 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: Applying Customer overpayments
Op donderdag 8 februari 2018 18:41:56 CET schreef Alan Johnson: > Hello, I'm having an issue with GnuCash. A customer has a > overpayment/credit balance. How do I apply it to an invoice so that it > comes out of the AR report at the bottom of the customer report? The > total due / sums are correct, but the customer report has a 91+ day > balance of (0.03). I would like to apply the payment to an invoice / fix > the AR box on the customer report. This is on version 2.6.19. > - Go to Business->Customer->Process Payment - Select the customer you refer to above - You should get a list of open invoices and overpayments - Select both the 0.03 overpayment and the invoice you want to apply it to (using shift- or ctrl-click) - If you only want to apply this 0.03, adjust the amount to exactly that 0.03 - Click Ok 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.
Applying Customer overpayments
Hello, I'm having an issue with GnuCash. A customer has a overpayment/credit balance. How do I apply it to an invoice so that it comes out of the AR report at the bottom of the customer report? The total due / sums are correct, but the customer report has a 91+ day balance of (0.03). I would like to apply the payment to an invoice / fix the AR box on the customer report. This is on version 2.6.19. Thanks, Alan ___ 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.