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
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 | < 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 2 months ago | | 3 months | transactions dated 3 months ago | | Older | transactions are older than 3 months | For example, if today's date is 10 July, categorize July invoices as Current and June invoices as 1 Month. Change your aging periods Choose whether to age your transactions by calendar months or days. - From Settings, then Business Settings, choose Record and Transaction Settings.
- Choose from Aging by days or by calendar months.
Why is it 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 - From Reporting, choose More.
- Select Accounts Payable Aging.
- Choose how to sort the report.
- By Name to see the amount you owe each vendor alphabetically
- By Outstanding amount to see who you owe the most money to first
- Click 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.
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. |