What the report tells you 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. Aging periods by days | Criteria | | < 30 days | 0 – 29 days | | < 60 days | 30 – 59 days | | < 90 days | 60 – 89 days | | < 120 days | 90 – 119 days | | Older | 120 days or older | 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. Aging periods by calendar month | Categorize unpaid transactions by month: | | Current | Transactions dated in the current month | | 1 month | Transactions dated last month | | 2 months | Transactions dated two months ago | | 3 months | Transactions dated three months ago | | Older | Transactions are older than three months | For example, if today's date is 10 July, categorize July invoices as Current and June invoices as 1 Month. Choose whether to age your transactions by calendar months or days. - From Settings, Business settings, select Record and transaction settings.
- Choose from Aging by days or by calendar months.
Why it's important The report helps track business health by showing: - Total money owed and duration of outstanding debts
- Priority vendors for payment
- Vendors offering the best credit terms
- Payment timelines for potential investors
Run the report For all vendors - Go to Reports, All reports.
- Select Accounts Payable Aging.
- 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. | - Select Calculate.
For a single vendor Enter the vendor name in the Search box. Up to a specific date - Run the report for a past date to show the total owed then.
- Enter the required date and click Calculate.
Include details of unpaid invoices Choose Detailed to include a list of unpaid invoices. Per group of vendors or other analysis type - From More, choose the Analysis Type and Category.
- Click Calculate.
Print or export the report Select Export and choose CSV or PDF. Save or print from your internet browser menu. 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. |