The Accounts Payable Aging report

Use the Accounts Payable Aging report to track how much you owe vendors at any time. The report helps you monitor:

• Amounts owed to vendors
• Duration of outstanding debts
• Vendors owed the most money
• Due dates for purchase invoices (Detailed report)
• Vendor credit limits

The report lists unpaid invoices minus any unrefunded credit notes. It shows the total amount owed and the payment due date, including tax if applicable.

For example, on 10 July, invoices dated 11 June to 10 July show in < 30 days; 11 May to 10 June show in < 60 days.

Run the report

For all vendors

1. Go to Reports, All reports.
2. Select Accounts Payable.
3. Choose how to sort the report:
   

   By Name	To see the amount you owe each vendor alphabetically.
   By Outstanding	To see the amount you owe the most money to first.

4. Select Calculate.

For a single vendor

Enter the vendor name in the Search box.

Up to a specific date

1. Run the report for a past date to show the total owed then.
2. Enter the required date and click Calculate.

Include details of unpaid invoices

Choose Detailed to include a list of unpaid invoices.

Print or export the report

Select Export and choose CSV or PDF. Save or print from your internet browser menu.

Common issues

Negative amounts on the Accounts Payable Aging Report

Negative amounts indicate outstanding credit notes not yet applied to invoices or refunded. Apply credit notes to invoices via Contacts.

The balance on a vendor record and the Accounts Payable Aging Report don't match

Differences usually arise from future-dated transactions included in vendor balances but not in the report. Choose the correct date for the report.

About analysis types

The Accounts Receivable Aging report