Aged Creditors report

This article explains how to access, filter, view and export the Aged Creditors report in FreeAgent which shows you which suppliers you owe at a particular date, and how much you owe them.

Accessing the report

Navigate to the ‘Accounting’ tab at the top of the screen and select ‘Reports’ from the drop-down menu.

Reports option highlighted in drop-down menu under Accounting tab.

Navigate to the ‘Breakdown’ section and select ‘Aged Creditors'.

'Aged Creditors' highlighted in the Breakdown section of the Reports page.

The Aged Creditors report shows how much you owe each supplier and a breakdown of each bill

You can choose to show or hide this information for each supplier by selecting the arrow next to their name.

The column headers (0-30 days etc) indicate how long before the report date each bill was dated. There's also a grand total of how much you owe your suppliers at the bottom of the screen.

Aged Creditors report set to Today.

Filtering the report

You can also choose whether you view this information ageing by the 'bill date' (the date the bill was created), or by the 'due date' (the date tied to the payment terms of the bill). This means you can view how long the bill is overdue by either by the issued date, or by the due date.

'Age by due date' selected on drop-down menu.

Alternatively, there are a number of different dates you can view the Aged Creditors report as at. You can view it at:

  • today’s date
  • the end of a specific accounting year
  • a custom date of your choice

Select the viewing option you want to use from the ‘Date’ drop-down menu.

'Custom Date' highlighted in drop-down menu.

If you choose the ‘Custom date’ option, you’ll be prompted to enter your chosen date in the ‘as at’ field. Select 'Apply' to view the report as at that date.

Custom date selected using a date picker.

Viewing the report

You can view the bill dates and due dates for each customer by selecting the arrow next to their name.

Example customer data aged by bill date.

Export the report

You can export the Aged Creditors report as either a CSV or PDF file. Choose the appropriate format from the 'Export Report' drop-down menu.

Export Report drop-down menu highlighted and showing options for CSV and PDF files.

Did you find this article useful?