This is what happens without an accounts payable aging report — a tool that groups unpaid vendor bills by how long they've been outstanding, so you always know exactly what you owe and when.
This guide covers what an AP aging report is, how to read and calculate it, how to prepare one, and the best practices that keep your payables under control.
Key Takeaways
- AP aging reports group unpaid invoices into time buckets: Current, 1-30, 31-60, 61-90, and 90+ days
- Protect cash flow, capture early-payment discounts, and prevent vendor disputes
- Weekly or monthly reviews catch duplicate invoices and coding errors before they compound
- Modern ERP and accounting software automates this reporting and cuts manual spreadsheet work
What Is an Accounts Payable Aging Report?
An AP aging report is a summary of every unpaid vendor invoice, organized by how long each one has been outstanding. It's a short-term liability management tool — the report AP teams pull up when they need to answer one question fast: what do we owe, and how urgent is it?
Standard Aging Buckets
Most reports use 30-day intervals, the industry standard confirmed by NetSuite's AP reporting guide:
- Current — not yet due
- 1-30 days — recently overdue
- 31-60 days — moderate concern
- 61-90 days — serious attention needed
- 90+ days — high risk
Aging vs. Turnover: Not the Same Thing
Aging tracks specific invoices by their individual age. Turnover ratios average how fast a company pays its bills overall. One shows you line-item detail; the other gives you a single efficiency number. They answer different questions and shouldn't be confused.
A related distinction is AP aging versus AR aging. AP aging tracks what you owe suppliers; AR aging tracks what customers owe you. Same bucket structure, opposite direction of cash flow.
Who Uses This Report?
- AP staff — daily prioritization of which invoices to pay first
- Financial managers and executives — cash flow forecasting and vendor negotiation leverage
- Auditors — verifying liabilities are recorded accurately during close
How to Read and Calculate an Accounts Payable Aging Report
Take each vendor's outstanding invoice amount and sort it into a bucket based on days since the due date (or transaction date, depending on how your system is configured). NetSuite's documentation notes this date basis matters. Verify which one your report uses before drawing conclusions.
Reading a Report the Right Way
Don't start at the top. Start with the 90+ days column, where the oldest past-due balances sit. Then work backward through 61-90, 31-60, and finally Current, building your payment plan from most critical to least.
A typical report structure looks like this:
| Vendor | Invoice # | Due Date | Current | 1-30 | 31-60 | 61-90 | 90+ | Total |
|---|---|---|---|---|---|---|---|---|
| Vendor A | INV-1021 | 11/15 | $0 | $2,400 | $0 | $0 | $0 | $2,400 |
| Vendor B | INV-0987 | 09/02 | $0 | $0 | $0 | $1,850 | $0 | $1,850 |
| Vendor C | INV-0755 | 06/10 | $0 | $0 | $0 | $0 | $3,200 | $3,200 |
Credit and debit memos adjust these totals. A credit memo reduces the amount owed (subtract it). A debit memo increases it (add it). Both need to be applied before you total each bucket, or your numbers won't reconcile with vendor statements.
Early Payment Discounts and Risk
Terms like 2/10 net 30 mean a 2% discount if paid within 10 days, full amount due at 30. On a $2,000 invoice, that's a $40 discount. Small per invoice, but it compounds across dozens of vendors monthly. Your aging report's Current bucket is where you spot these opportunities before the discount window closes.
Each bucket carries a different risk signal:
- 1-30 days: Normal operational lag, low concern
- 31-60 days: Watch for cash flow tightening
- 61-90 days: Investigate: payment terms or disputes may need resolution
- 90+ days: Red flag for cash flow problems or unresolved vendor conflicts
How to Prepare an Accounts Payable Aging Report
Building this report is a repeatable process:
- Gather invoice data: invoice number, vendor name, due date, payment terms, and amount for every open bill
- Set aging timeframes: stick with 30-day intervals unless your business has unusual payment cycles
- Sort and total: bucket each invoice, then total by vendor and by aging category
- Reconcile: cross-check totals against vendor statements and the general ledger to catch discrepancies before they become audit issues
Most modern accounting and ERP platforms generate this report automatically and update it in real time. Manual spreadsheets are where duplicate entries and stale due dates creep in.
Growing manufacturers and industrial distributors often hit a wall here. Their existing systems weren't built to connect invoice data across procurement, accounting, and vendor management in one place.
Gushwork's custom software development work, including ERP and CRM implementation for B2B SMBs, closes that gap. Finance teams get a system that pulls accurate, real-time data instead of a spreadsheet that's already outdated by the time someone opens it.
Benefits of Using an AP Aging Report
An aging report does more than list bills. It's a control mechanism.
- Forecast cash flow with clear visibility into what's coming due, so you plan disbursements instead of reacting to them
- Strengthen vendor relationships by paying strategically and on time, which keeps suppliers willing to extend favorable terms
- Capture early-payment discounts and avoid penalties by catching Current-bucket invoices before terms lapse
- Prevent fraud and billing errors: APQC's research on AP cost reduction notes that clear invoice controls help surface duplicate or incorrect billing before payment goes out
Top-performing AP organizations spend roughly $0.38 per $1,000 of revenue processing invoices, compared to $0.92 for bottom performers, according to APQC.
On $1 billion in revenue, that gap represents over $500,000 in annual savings, much of it tied to the process discipline an aging report enforces.
Best Practices and Common Pitfalls to Avoid
Review cadence matters. Run the report monthly at minimum; weekly if your payment volume or cash position demands closer attention.
Common AP aging report errors:
- Duplicate invoices entered twice under slightly different reference numbers
- Incorrect due dates pulled from the wrong terms field
- Mismatched general ledger entries that throw off reconciliation
- Stale vendor records causing payments to route incorrectly
Automation handles most of these issues. Integrated systems flag anomalies and update aging buckets automatically, so AP staff spend less time re-keying spreadsheets and more time optimizing days payable outstanding (DPO).
Frequently Asked Questions
What is an accounts payable aging report?
It's a report listing unpaid vendor invoices, grouped into aging buckets (Current, 1-30, 31-60, 61-90, 90+ days) so you can track outstanding liabilities and prioritize payments.
How do I read an accounts payable aging report?
Start with the oldest overdue bucket (90+ days) to assess urgency, then work through the current and near-term buckets to plan upcoming payments.
How is accounts payable aging calculated?
Each invoice's outstanding amount is sorted into a date-range bucket based on days since the due date, then adjusted for any credit or debit memos affecting the balance.
What does aging mean in accounting terms?
Aging tracks how long specific invoices or line items have remained outstanding. It's different from turnover ratios, which average payment speed across the whole business.
How often should a company review its AP aging report?
Monthly at minimum, weekly for businesses with high invoice volume or tight cash positions. Regular review catches errors and overdue bills before they escalate.
What's the difference between an AP aging report and an AP trial balance?
The aging report sorts all outstanding invoices by due date for payment prioritization. The trial balance verifies that general ledger liability accounts are coded and balanced correctly.
