webERP Forum
Customer Overpaid Invoice - Printable Version

+- webERP Forum (
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: How To ? (/forumdisplay.php?fid=6)
+--- Thread: Customer Overpaid Invoice (/showthread.php?tid=8185)

Customer Overpaid Invoice - VortecCPI - 08-03-2018 08:34 AM

While reconciling a bank statement I noticed the customer's check is showing a deposit amount $0.01 higher than the invoice amount.

What is the best procedure to adjust this in webERP?

Any help is GREATLY appreciated!

RE: Customer Overpaid Invoice - phil - 08-03-2018 10:01 AM

This does create a bit of messing around.... probably should be some way to write these amounts off more easily. However, I think the best plan currently is:

Enter a negative payment of 0.01 to the customer to clear the account - allocate to the 0.01 overpaid
Then enter a positive payment of 0.01 as a GL payment to the happy finds account or sales account
Clear both the negative and positive payments from the bank reconciliation statement

RE: Customer Overpaid Invoice - falkoner - 08-03-2018 05:09 PM

The normal way we recommend dealing with this is to enter a zero receipt with a 0.01 discount against it. Obviously the discount would need to be positive or negative depending on which way the 0.01 balance is. Then of course you need to allocate the cents off against each other, clearing the issue. This has the benefit of reflecting the reality of the situation (you are effectively getting or giving a discount on the sale).


RE: Customer Overpaid Invoice - VortecCPI - 08-03-2018 07:41 PM

Thank you both! I will try both methods to get myself better acquainted with the options.

RE: Customer Overpaid Invoice - VortecCPI - 08-05-2018 11:04 AM

I ended up using Tim's solution as I liked the idea of the amount being tracked in the Sales Discounts account.

Thank you both again for your help! You guys always come through for me!