Forum Discussion

Marina1's avatar
Marina1
Experienced User
4 years ago

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/2022SJSJ004402Henry (Koko) Ariihee: Credit from 00035020$0.00($62.80)
25/05/2022SJ00035332Sale; Henry (Koko) Ariihee($318.90)($381.70)
25/05/2022SJSJ004447Henry (Koko) Ariihee: Credit from 00035332$0.00($381.70)
25/05/2022CRCR034627Payment; 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?

 

1 Reply

Replies have been turned off for this discussion
  • Hi Marina1 

     

    An Aged Receivables report includes ALL open invoices recorded in AccountRight, aged according to the date selected.

    A Receivables Reconciliation reports displays only the invoices open as at the date selected.

    The Customer ledger displays all transactions within a date range, the balance is determined by the date range selected. 

     

    As the Aged Receivables and Receivables Reconciliation are different reports they will display different balances and transactions. 

     

    The Help Article, Receivables, payables or inventory out of balance, has detailed information to assist with out of balance issues.

     

    Please let me know if you need further help.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.