Using the Customer Aged Debt Report

You can run a Customer Aged Debt report by choosing Customers in the Other Reports screen. You can:

  • Find out the level of credit you are giving your customers.
  • View a list of your best customers (in terms of sales).
  • Change the date range of the report.
  • Save, print or email the report.
What does the report show?

The Customer Aged Debt report shows how much money you are (or were) owed on a certain date.

The aged debt table shows the amount of money owed by each customer split into time periods. The 0-14 period represents your unpaid sales invoices that were dated in the last 14 days (or 14 days before the end date set for the report). Similarly, the 15-30 period shows the value of unpaid sales invoices that were raised earlier (between 15 and 30 days ago). If your customers always pay your invoices within 30 days of the invoice date, you should not expect to see any values in the 31-45 day column or older.

The total column on the right shows the total value you are owed by each customer.

The total row on the bottom shows the total value in each period. Values shown in the columns 91+ and 61-90 indicate debt that is older than 60 days. These will adversely affect your cash flow and you may be advised to contact your customers to arrange payment.

The Sales to Customers table shows the total value of your invoices for that customer over the time range of the report. This is used to help show your best customers. Note that the values are net (excluding tax) in this case because they show the income value whereas the aged debt figures show amounts owed, which are inclusive of tax.

How does EasyBooks pick the initial date range?

The Next Consolidation date specified in the Business Settings is used as the end date of the report. If this date has not yet passed, the report uses current date instead. If you've consolidated your profit and loss, the day after your last consolidation is used as the start date. Otherwise the date of the earliest transaction is used.

How do I save, print or email the report?

In the report screen, click send located in the top-right corner of the screen, followed by one of the send options.

Options in this Screen

Previous Period/Next Period

Click to view the report for the previous or next financial period. The report will run for the whole of the financial period selected.

Start Date

You can set the start date to any date prior to the currently selected end date.

End Date

You can set the end date to any date after to the currently selected start date.