Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Customer Overpaid Invoice
08-03-2018, 08:34 AM,
Customer Overpaid Invoice
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!
08-03-2018, 10:01 AM,
RE: Customer Overpaid Invoice
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
Phil Daintree
webERP Admin
Logic Works Ltd
08-03-2018, 05:09 PM, (This post was last modified: 08-03-2018, 06:21 PM by falkoner.)
RE: Customer Overpaid Invoice
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).

08-03-2018, 07:41 PM,
RE: Customer Overpaid Invoice
Thank you both! I will try both methods to get myself better acquainted with the options.
08-05-2018, 11:04 AM,
RE: Customer Overpaid Invoice
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!

Forum Jump:

Users browsing this thread: 1 Guest(s)