Forum Discussion

Umy's avatar
Umy
Experienced User
2 years ago
Solved

Trade Receivable Aging report

I want to download my trade receivable aging report as at 31/12/2022.

However, the result also includes my sales invoice of 2023. Why?
How can I get the correct aging as cutoff date?

 

Thank you.

  • Hi Umy 

     

    The Aged Receivables report displays ALL open invoices irrespective of the invoice date and ages them according to the date that is entered in the As of date.

     

    The Receivables Reconciliation reports uses the As of date as the cut off date and then ages the transactions according to that date.

     

    For example, I enter a sale invoice dated 16/03/2023. If I run the Aged Receivables report as of 28/02/2023 that invoice will appear as it is open. If I run the Receivables Reconciliation report as of 28/02/2023 it will not appear as it is dated after the date I'm running the report for.

     

    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.

2 Replies

Replies have been turned off for this discussion
  • Hi Umy 

     

    The Aged Receivables report displays ALL open invoices irrespective of the invoice date and ages them according to the date that is entered in the As of date.

     

    The Receivables Reconciliation reports uses the As of date as the cut off date and then ages the transactions according to that date.

     

    For example, I enter a sale invoice dated 16/03/2023. If I run the Aged Receivables report as of 28/02/2023 that invoice will appear as it is open. If I run the Receivables Reconciliation report as of 28/02/2023 it will not appear as it is dated after the date I'm running the report for.

     

    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.

    • Umy's avatar
      Umy
      Experienced User

      Dear Tracey_H,

       

      I understand your solution. However, why is invoice 2022 paid on 2023 is not appear in the reconciliation report as at 31 Dec 2022?