Forum Discussion

Jojo16's avatar
Jojo16
User
4 years ago
Solved

Debtors reconciliation/trial balance

Can someone please explain why the Aged Receivables and the Receivables reconciliation are both different amounts and neither match the trail balance when I report a certain date?  

I want to know the which figure is correct. 

Thanks

Reports
  • Komal_S's avatar
    Komal_S
    4 years ago

    Hi Jojo16 

     

    Aged Receivables report shows the ageing of invoices as of a certain date and therefore will include all the invoices posted after the date entered. Whereas, Receivables Reconciliation report will just display the outstanding invoices as of a certain date. 


    Essentially, the figures in Trade Debtors account should be equal to the figure shown in receivables reconciliation report for the same period. In order to verify if the figures are correct, please go the Find transactions tab in the command center, search by Trade Debtors account for the date range specified above and check if the Ending balance is same as shown on trial balance, and receivables reconciliation reports. 

     

    If it's different, please let us know so we can investigate further.

1 Reply

Sort By
Replies have been turned off for this discussion
  • Komal_S's avatar
    Komal_S
    MYOB Moderator
    4 years ago

    Hi Jojo16 

     

    Aged Receivables report shows the ageing of invoices as of a certain date and therefore will include all the invoices posted after the date entered. Whereas, Receivables Reconciliation report will just display the outstanding invoices as of a certain date. 


    Essentially, the figures in Trade Debtors account should be equal to the figure shown in receivables reconciliation report for the same period. In order to verify if the figures are correct, please go the Find transactions tab in the command center, search by Trade Debtors account for the date range specified above and check if the Ending balance is same as shown on trial balance, and receivables reconciliation reports. 

     

    If it's different, please let us know so we can investigate further.