Receivables Reconciliation Reports variances
What is the most accurate report to use for AR?
My understanding is AR reports are supposed to be accurate, however this is not the case with MYOB.
The Aged Receivables Summary when checked against the customer ledger balances are way out
Receivables Reconciliation is always out of balance from month to month
It would seem that the most accurate report is the customer ledger
For example - the following is taken from the customer ledger - Customer Henry has a credit balance of $522.80
But the credit balance of $522.80 is not showing on the Reconciliation Report, and in the AR Summary report its showing a -0.01 balance
Henry (Koko) Ariihee | *None | -$62.80 | |||
03/05/2022 | SJ | SJ004402 | Henry (Koko) Ariihee: Credit from 00035020 | $0.00 | ($62.80) |
25/05/2022 | SJ | 00035332 | Sale; Henry (Koko) Ariihee | ($318.90) | ($381.70) |
25/05/2022 | SJ | SJ004447 | Henry (Koko) Ariihee: Credit from 00035332 | $0.00 | ($381.70) |
25/05/2022 | CR | CR034627 | Payment; Henry (Koko) Ariihee | ($141.10) | ($522.80) |
Total: | ($460.00) | ($522.80) |
In the AR Summary
Henry (Koko) Ariihee | ($0.01) | ($0.01) | $0.00 | $0.00 | $0.00 |
In the Receivable reconciliation Summary Report
Henry is missing in the ledger.
So whats going on?
Why are there variances between reports?