UO AR Aged Debtors report
As of 16/06/2025, a new security element has been added to the UO AR Aged Debtors Report, ensuring that invoices returned in an output will be for the department of the user only, based on their default salesperson setting. Central users will still see all invoices.
In addition, the report will now return data for all receipts requested, irrespective of whether the receipt is open or closed at the selected GL date. This can be filtered on the Excel output as required.
Why run this report?
- For reviewing information about open items within seven age brackets (buckets). The report can print detailed or summarized information about customers' current and overdue invoices.
- For viewing credit memos, on-account credits, unidentified payments, and on-account and unapplied cash amounts.
When should you run this report?
This report is recommended for your month/quarter end preparation and closure and at any time to get a snapshot of ALL unpaid invoices.
How to run this report
Select the following report parameters:
Which outputs does this report have?
• Excel - a simple list of data that can be filtered but has no totals.
• Excel Pivot - designed to make analysis of the data easier, the default layout can be changed once the report has opened in Excel from this output.
Two report output examples are available for this report:
- Report output example: UO AR Aged Debtors (Excel) (PDF)
- Report output example: UO AR Aged Debtors (Excel Pivot) (PDF)
Which roles have access to this report?
- UO Receivables Dept Reports
- UO Credit Control – Collector
- UO Credit Control – Central
- XX Receivables
