Create the Accounts Receivable Aging report

The Accounts Receivable (A/R) Aging Report shows you how much you're owed at any point in time by each of your customers. You can use the report to keep track of:

  • How much your customers owe you.
  • How long your customers have owed you money.
  • Which of your customers owe you the most money.
  • In the Detailed report, due dates for sales invoices.

The report is broken down by aging periods, which by default is every 30 days. You can change this if necessary.

To change the default aging periods

  1. From Settings, click Default Settings.
  2. In the Customer Defaults section, enter the default aging period in days in the Aging boxes.

    For example, if you want your first aging period to start at 40 days, enter 40 in the first box. The report shows transactions from days 0 to 39, then days 40 and beyond.

  3. Click Save.

    After you change the default aging periods, outstanding values are grouped by the number of days specified on the A/R Aging Report.

To produce the Accounts Receivable (A/R) Aging Report

  1. From Reporting, click More.
  2. Click Accounts Receivable (A/R) Aging Report.

    Note: The 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 Type to search box.

  3. Change the end date of the report by entering a date in the To field.
  4. Sort by customer name or outstanding amount.

    If you use analysis types, you can filter the report based on analysis type and category. Only the customers who belong to the selected analysis type or category appear on the report. Click More to filter by analysis type and category.

  5. Click the customer's name to view their account. To return to the report, click Back in your browser.
  6. Choose to export as CSV or PDF.

    Note: To view the A/R Aging Breakdown, click Detailed. From here you can see outstanding transactions with due dates. Click a transaction to view details. To return to the Accounts Receivable (A/R) Aging Report, click Summary.

About negative amounts

If you see a negative amount on the Accounts Receivable (A/R) Aging report, it represents a credit that you owe a customer. To find it, check your sales credit notes and payments for a transaction that has not been applied to a sales invoice. Once found, apply it to the correct sales invoice to credit your customer.