Customer Statement balance due incorrect.
Hi, My Customer Statement Balance Due is incorrect. I've attached screenshots of the Customer Statement and Receivables Reconciliation. We've recently upgraded from AR v19.6 so we're still adju...
Forum Discussion
Hi Gavin,
Thanks for the fast response.
There are two issues:
1. On the Statemet - the customer Total Amount Due (40,870.51) does not agree with the final statement balance (50,338.15)
2. The Receivables Account is out of balance.
1. My primary concern is the Statement balance that has the missleading bottom line.
All the transaction are showing and all the invoice terms are consistant (14 days) and they are showing in the right currency.
Any idea why its missing a random $9,467.64?
Hi RodneyPollen
Thanks for clarifying the issue - take a look at the first few posts here - MYOB needed to run a script on the file to fix the issue (a payment was not showing due to bug in software). Other than seeing the numbers don't add up, there is not enough info provided to identify cause. You will need to look at the History on all invoices to see where the discrepancy comes from.
You cannot tell if your Receivables Reconciliation is out of balance as you are looking at one Supplier only. Generate same report for all suppliers to see if the register total matches the account.
Regards
Gavin
