Articles & Blogs

How an Aged Debtor Report can help your clients

Go to any accountancy software, and you can usually hunt down an aged debtor report for your business or your clients business. But why are they useful?

Go to any accountancy software, and you can usually hunt down an aged debtor report for your business or your clients business. But why are they useful?

First up, let’s get the definition straight.

Put simply, an aged debtor report is a list of all unpaid invoices due to your business. This shows you the overall amount of money you’re owed at any one time, and is grouped by customer.

The aged debtors report usually divides out unpaid invoices that are due to be paid to you within 30 days, in 30 to 60 days, in 60 to 90 days and in more than 90 days.

An aged debtor report can help you track your clients debts and allows you to prioritise debt that needs chasing. It can help you develop your advisory services, as it can provide insight for your clients on who they should be giving credit to. An aged debtor report can also be useful for examining payment terms - your client may want to shorten their payment period terms if they are facing frequent overdue invoices from one customer.

As an accountant, it’s important to keep on top of your clients' aged debt reports. Perhaps you could provide one for each meeting you have with a client as a means of monitoring their cashflow.

To make things easier for you, we’ve listed where you can find the Accountancy software generated aged debtor reports on the four main platforms.

Where to find Aged Debtor Reports

On FreeAgent:

Head to Accounting > Reports > Aged Debtors.

From here you can see a breakdown of each invoice that is currently outstanding over specified time periods.

On Xero:

Head to Accounting > Reports > Sales > Aged Receivables Detail (New).

From here you can select a date range, and click Report settings to customise the report. Update it to see the most recent report.

On Sage:

Head to Reporting > More > Aged Debtors.

This report shows all customers with an outstanding balance up to the current date. To view the report for a particular customer, enter their company name or reference in the search box.

You can sort by either name or outstanding amount, and you can also use analysis types to filter the report.

On Quickbooks:

Head to the Main QuickBooks menu > Reports > Customers & Receivables list > A/R Aging Detail.

This report will show you all outstanding invoices and sort them by due date. Depending on the payment terms you have set for your customers, you will see those that are due in 0-30 days, 30-60 days, 60-90 days and over 90 days past due.

If you’re interested in helping your clients improve their cashflow, why not try itsettled?

We help accountancy firms across the UK improve and scale their credit control operations.

Our credit management and debt recovery software automatically collects overdue invoices using a proven process that has collected over £420 million for 1,600 UK SME's. Saving your clients time, improving their working capital position and allowing them to thrive.

Find out more about how we work with accountants.

Interested in how we can help you and your clients? Sign up today for a free 7 day trial.

Ready to get started?

email us now so we can start helping you

Start chasing payments now

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.