Forum Discussion

Experienced User

2 years ago

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....

Tracey_H
2 years ago
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.

Tracey_H

Former Staff

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.