The Aged Trade Creditors report gives your practice a clear picture of all unpaid supplier invoices, grouped by how long they’ve been outstanding. It displays amounts owed to vendors, consultants, and service providers, segmented into aging periods such as 0–30 days, 31–60 days, 61–90 days, and 90+ days.
This report is essential for managing your accounts payable. It helps you keep track of upcoming obligations, prioritise payments, and maintain strong relationships with suppliers by ensuring bills are paid on time.
Why Use This Report?
-
Stay on top of payables: Quickly see who you owe, how much, and when payment is due.
-
Improve cash flow forecasting: Anticipate outgoing payments and manage your practice’s working capital more effectively.
-
Avoid late fees or strained supplier relationships: Timely payments maintain your practice’s reputation and credit terms.
-
Streamline payment workflows: Use the report to plan batch payments where appropriate.
By regularly reviewing the Aged Trade Creditors report, your practice can stay financially healthy, organised, and in control of its obligations — ensuring smooth operations and strong supplier partnerships.
Prior to generating the report you are able to customise the way the information is presented to you via the following options:
1. Date Range - This report is an 'As At' report. This means that technically it is not a date range, but more a Date To. It only shows transactions up until that day.
2. Select Sort Order - You are able to sort by:
a. Creditor Name - Choosing this option will sort by the creditor.
b. Creditor Surname - Choosing this option will sort by the creditor, however this time using the surname as the chronological order.
c. Total - This will appear in descending order.
d. Current - This will appear in descending order.
e. 31 to 60 - This will appear in descending order.
f. 61 to 90 - This will appear in descending order.
g. 90 plus - This will appear in descending order.
3. Show Detail - If this tick box in not ticked the report will only provide you with totals. Whereas if it is on (see second image below) you will have additional details such as invoice #, date of invoice, matter details etc
Once the report is generated the information you get (assuming you have the show detail checkbox ticked) is:
1. As At - the Date you chose.
2. Creditor - this will show the creditor name.
3. Total - The total due for that trade creditor.
4. Current - Any invoices issued 30 or less days ago.
5. 31 - 60 - Any invoices issued between 31 and 60 days ago.
6. 61 - 90 - Any invoices issued between 61 and 90 days ago.
7. 90+ - Any invoices issued more than 90 days ago.
8. Details - Date of expense, description, outstanding amount.
9. Total - The total at the bottom is a combined total of all outstanding amounts, with further totals specifically for each age grouping.