Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Customer Overpaid Invoice
08-03-2018, 08:34 AM
Post: #1
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!

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
08-03-2018, 10:01 AM
Post: #2
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
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
08-03-2018, 05:09 PM (This post was last modified: 08-03-2018 06:21 PM by falkoner.)
Post: #3
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).

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
08-03-2018, 07:41 PM
Post: #4
RE: Customer Overpaid Invoice
Thank you both! I will try both methods to get myself better acquainted with the options.

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
08-05-2018, 11:04 AM
Post: #5
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!

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)