A guide to the Aged Debtors report

This article explains how to access the Aged Debtors report in FreeAgent which shows you which customers owe you money at a particular date, and how much they owe you.

Accessing the report

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

Screenshot showing the 'Accounting' menu with 'Reports' highlighted

In the ‘Breakdown’ section, select ‘Aged Debtors'.

Aged_Debtors.png

The Aged Debtors report shows how much each customer owes you, and a breakdown of each invoice. 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 customer by selecting the arrow next to their name.

The column headers (0-30 Days etc) indicate how long before the report date you issued each invoice. There's also a grand total of how much your customers owe you at the bottom of the screen.

Screenshot_2020-11-12_at_16.36.35.png

Viewing the report

There are a number of different ways you can view the Aged Debtors report. You can view it as at:

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

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

Screenshot_2020-11-12_at_16.26.19.png

If you choose the ‘Custom Date’ option, you’ll be prompted to enter your chosen date in the ‘As at’ field.

Screenshot_2020-11-12_at_16.28.09.png

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

Screenshot_2021-12-20_at_16.42.23.png

You can set up automatic emails from FreeAgent to remind your customers to pay an invoice when it’s due or overdue, or manually send a reminder email once an invoice is overdue.

Did you find this article useful?