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.
Navigate to the ‘Breakdown’ section and select ‘Aged Creditors'.
The Aged Creditors report shows how much you owe each supplier and a breakdown of each bill. If your business is registered for VAT, the figures shown on the report will be inclusive of VAT.
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.
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.
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.
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.
Viewing the report
You can view the bill dates and due dates for each supplier by selecting the arrow next to their name.
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.