The Aged Debtors report

Summary

The features of the Aged debtors report in Accounting Start.

Description

Use the Aged Debtors report to check how much you’re owed at any point in time by each of your customers.

Resolution

What the report tells you

The aged debtors report shows a list of all outstanding invoices your customers haven’t yet paid you for, less any outstanding credit notes you’ve issued to your customers. It helps you determine how much money you can expect to receive from each customer. It also gives you a total amount that should reach you by a specific date.

NOTE: Don’t forget, if you’re registered for VAT, the report includes the VAT. This is because that’s how much money you will receive from your customer.

The aged debtors report divides your unpaid invoices out by time period.

When you run an aged report, we calculate the total amount owed to you for each ageing period. Accounting Start works out the age of a transaction from the transaction date.

Ageing periods by days >

The total of unpaid transactions shows in each period based on the numbers of days past the invoice date.

< 30 days	The age of the transaction is between 0 – 29 days.
< 60 days	The age of the transaction is between 30 – 59 days.
< 90 days	The age of the transaction is between 60 – 89 days.
< 120 days	The age of the transaction is 90 – 119 days.
Older	The age of the transaction is 120 days or older.

For example, if today's date is 10 July, invoices dated between 11 June and 10 July show in the < 30 days column. Invoices dated 11 May to 10 June show in the < 60 days column.

Ageing periods by calendar month >

The total of unpaid transactions shows in each column based on the month. The first column is the current month. Subsequent columns show outstanding transactions for the previous months.

For example, if today's date is 10 July, invoices dated anytime in July show in the Current column. Invoices dated anytime in June show in the 1 Month column.

Current	transactions dated in the current month
1 month	transactions dated last month
2 months	transactions dated 2 months ago
3 months	transactions dated 3 months ago
Older	transactions are older than 3 months

Choose whether to age your transactions by calendar months or days.

From More, then Business Settings, choose Record and Transaction Settings.
Choose from ageing by days or by calendar months.

Run the report

For all customers

Go to Reporting.
Select Aged Debtors.
Choose the date to run the report up to. Transactions age based on this date.
Choose how to sort the report:
- by Name to see the amount owed by each customer alphabetically
- by Outstanding amount to see who owes you the most first
Select Calculate.

For a single customer

Enter the customer's name in the Search box.

Up to a specific date >

You may want to run the report to show the total amount due at a point in time in the past. This is often required by your Accountant for auditing purposes.

Comparing the aged debtors report with the trial balance also confirms you've entered all the transactions correctly.

When you run the report (for a date in the past), any payments received after that date are not included. So, invoices that customers have paid subsequently will show as outstanding.

Enter the required date and choose Calculate.

Include details of unpaid invoices >

To include a list of unpaid invoices as well as the total amount outstanding, choose Detailed.

Print or export the report

Select Export then choose one of the following:

CSV – Depending on your Internet browser, the file automatically downloads to your Downloads folder. Or you’re prompted to save the file. If prompted, browse to where you want to save the file then select Save
PDF – The PDF opens in a new window or tab, and you can then print or save it from your Internet browser menu

Show the net and VAT amounts on outstanding invoices

The aged debtors report only shows the gross value of your customer debt. Some businesses like to see the net and VAT amounts separately. This is so they can check their net income and how much they owe in tax.

To find this in Accounting, use the sales invoice list and filter it to show outstanding invoices only. Once filtered, select all the invoices and export the list to PDF or CSV file.

Go to Sales.
Select the Outstanding tab.
Set the date range to match your aged debtor's report.
Select the settings icon on the left of the column headers, and select Net, VAT. Select Save.
Select Search.

Solution Properties

Solution ID: 222001000100440
Last Modified Date: Mon Dec 18 07:31:34 UTC 2023
Views: 0