Using the Supplier Aged Debt Report

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

  • Find out how much you owe to your suppliers, broken down by the age of the debt.
  • View a list of your suppliers with the amounts spent.
  • Change the date range of the report.
  • Save, print or email the report.
What does the report show?

The Supplier Aged Debt report shows how much money you owe (or owed) to your suppliers on a certain date.

The aged debt table shows the amount of money owed to each of your suppliers split into time periods. The 0-14 period represents unpaid purchase 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 purchase invoices that were raised earlier (between 15 and 30 days ago). If you always pay your suppliers within 30 days of their 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 owe to each supplier.

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. Paying your suppliers later can improve your cash flow (at their expense), but may also indicate that your business is having problems paying its suppliers.

The Purchases from Suppliers table shows the total value of purchase invoices received for each supplier over the time range of the report. This is used to help show the suppliers you spend the most money with. Note that the values are net (excluding tax) in this case 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.