Accounts payable aging report: how to read and use it
An accounts payable aging report lists unpaid supplier invoices grouped by how long they are outstanding, usually current, 1–30, 31–60, 61–90 and over 90 days past due, so AP can see what to pay first.
Last updated
Quick answer
What is an accounts payable aging report?
An accounts payable aging report lists every unpaid supplier bill grouped by how long it has been outstanding, usually current, 1–30, 31–60, 61–90 and over 90 days past due, with totals per vendor. AP uses it to plan payment runs, catch late or disputed bills, and reconcile payables to the general ledger at month end.
Formula
Days past due = Report date − Due date; Past due % = Past-due balance ÷ Total open payables × 100
Example: Open payables are $412,300, of which $122,300 is past due. Past due % = $122,300 ÷ $412,300 × 100 = 29.7%.
An AP aging report groups unpaid bills by how overdue they are, typically current, 1–30, 31–60, 61–90 and over 90 days. Reviewing it weekly shows which suppliers are at risk of being paid late and which old balances may be duplicates, unapplied credits or disputes. Its total should match the AP control account at month end.
Definition
The AP aging report is a standard accounting report that shows every open bill by vendor and age bucket, with totals for each bucket. It helps the team schedule payments, spot late bills before suppliers chase them, find disputed or forgotten invoices, and reconcile the AP subledger to the general ledger at month end. Accounting systems such as QuickBooks Online (A/P Aging) and Xero (Aged Payables) produce one as standard. The accounts receivable aging report is the mirror image: it groups what customers owe you by age, and is the main tool for collections.
How an aging report is built
Every aging report has an "as of" date. For each open invoice, the report subtracts the due date from that date to get the days past due, then places the invoice in a bucket. An invoice not yet due goes in Current. One that is 41 days past due goes in 31–60. Each row is a vendor, each column a bucket, and the bottom row totals each bucket.
Some reports age from the invoice date instead of the due date. The two give different answers: a net 60 invoice dated 45 days ago is current by due date but in the 31–60 bucket by invoice date. Check which setting your report uses before drawing conclusions. A detail version lists each invoice with its number, dates and amount; a summary version shows totals per vendor.
The report's grand total should equal the accounts payable control account in the general ledger on the same date. A difference means a bill posted to the wrong account, a manual journal to AP, or an unapplied payment or credit.
How to read an AP aging report
Start with the column totals. Current is your normal pipeline. The 1–30 bucket is usually timing: approvals running a little late. Balances over 60 or 90 days are rarely just slow payment. They usually point to a dispute nobody closed, an invoice stuck in approval, a duplicate, or a bill that should not be in AP at all.
Then scan by vendor. Negative balances are usually unapplied credits or overpayments you can recover or use. The same amount appearing twice for one vendor can be a duplicate bill. Compare open invoices with vendor statements for your largest suppliers.
AR aging works the same way in reverse. Instead of planning payments, you use it to decide which customers to chase. A large and growing over-90 bucket in AR is a bad-debt risk and pushes up days sales outstanding.
| Vendor | Current | 1–30 | 31–60 | 61–90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| Northline Supply | $120,000 | $32,000 | $0 | $0 | $0 | $152,000 |
| Metro Freight | $64,000 | $18,500 | $12,000 | $0 | $0 | $94,500 |
| Brightway IT | $46,000 | $0 | $0 | $0 | $0 | $46,000 |
| Coastal Packaging | $38,000 | $21,000 | $9,500 | $9,800 | $0 | $78,300 |
| Delta Facilities | $22,000 | $6,500 | $5,000 | $0 | $8,000 | $41,500 |
| Total | $290,000 | $78,000 | $26,500 | $9,800 | $8,000 | $412,300 |
Past due is $122,300, or 29.7% of open payables. The $17,800 over 60 days (Coastal Packaging and Delta Facilities) is where to look for disputes, duplicates and stuck approvals.
| System | Report name |
|---|---|
| QuickBooks Online | A/P Aging Summary and A/P Aging Detail |
| Xero | Aged Payables Summary and Aged Payables Detail, aged by due date or invoice date |
| NetSuite | A/P Aging summary and detail reports |
| Business Central | Aged Accounts Payable, aged by due date, posting date or document date |
| Sage Intacct | AP Aging report in Accounts Payable reports |
Why It Matters
Aging reports reveal payment performance at a glance. A growing 90+ day bucket signals process problems, disputes or cash flow issues that need attention before supplier relationships deteriorate. The report also feeds cash planning: the Current and 1–30 columns show roughly how much cash the next few payment runs will need.
Examples
Reading the buckets
Total open AP is $412,300: $290,000 current, $78,000 at 1–30 days, $26,500 at 31–60, $9,800 at 61–90 and $8,000 over 90. Past due is $122,300, or 29.7% of the total. The team pays the 1–30 items in this week's run and investigates the $17,800 over 60 days.
Placing an invoice in a bucket
The report is run as of October 31. An invoice due September 20 is 41 days past due, so it appears in the 31–60 bucket. An invoice due November 15 is still current.
Month-end check
The aging report totals $412,300 but the AP control account in the general ledger shows $415,100. The $2,800 difference points to a bill posted to the wrong account or a manual journal that needs investigating.
Common Mistakes
Not knowing the aging basis
Confirm whether the report ages by due date or invoice date. By invoice date, long-term invoices look overdue when they are not.
Ignoring negative balances
Credits and overpayments sit quietly in the report. Apply them to open bills or ask the supplier for a refund.
Paying the oldest bills blindly
Old items are often disputed or duplicated. Check why a bill is old before paying it.
Skipping the reconciliation
Tie the aging total to the AP control account every month end. An unreconciled aging report hides posting errors.
Missing unrecorded bills
The report shows only bills that have been entered. Invoices stuck in someone's inbox or in approval are not on it, so the true liability can be higher.
In Practice
- Run the AP aging report weekly as of today's date, aged by due date.
- Review bucket totals to see how much is current and how much is past due.
- For anything over 30 days, find the reason: approval, dispute, missing receipt or duplicate.
- Apply open credits and resolve disputes with suppliers.
- Use the Current and 1–30 columns to plan the next payment run.
- At month end, reconcile the aging total to the AP control account in the general ledger.
Tools and Further Reading
- Payment run: Turn the aging report into a payment schedule.
- Days payable outstanding: Measure how long you take to pay on average.
- DPO calculator: Calculate DPO from your balances.
- What net 30 means: How due dates, and so aging buckets, are set.
- AR aging calculator: For receivables: turn aging buckets into a DSO estimate.
- Free accounts payable course: Seven self-paced modules covering the AP process, matching, approvals, paying bills, the close and AP metrics.
How Aequo AP Helps
Aequo AP syncs approved bills to QuickBooks Online, Xero, FreshBooks, Zoho Books or Business Central, where the standard AP aging report stays accurate. Inside Aequo AP, the exception aging report shows how long invoices have been stuck in review, which is often why bills turn up late on the aging. Vendor payments inside Aequo are coming soon. For receivables, the free AR aging calculator turns your aging buckets into a DSO estimate.
Start Free TrialFrequently Asked Questions
What are the aging buckets?
Most reports use current (not yet due), 1–30, 31–60, 61–90 and over 90 days past due. Some count from the invoice date instead of the due date, so check the report setting.
How do you read an AP aging report?
Start with the column totals to see how much is current and how much is overdue, then look at vendors with balances over 60 days, negative balances and repeated amounts. Each of those usually has a specific cause to fix.
How often should you review the AP aging report?
Weekly for payment planning, and at every month end to reconcile it to the AP balance in the general ledger.
What is the difference between AP aging and AR aging?
AP aging shows what you owe suppliers. AR aging shows what customers owe you. Both use the same age buckets. AP aging helps plan payments; AR aging drives collections.
Why doesn't my AP aging match the balance sheet?
Usually because of a bill posted to the wrong account, a manual journal entry to accounts payable, or an unapplied payment or credit. Compare the two on the same date and investigate the difference.
What does a large 90+ day balance mean?
It usually means a process problem rather than slow payment: an unresolved dispute, a duplicate or incorrect bill, or an invoice waiting for a missing approval or receipt.
Deep Dive Guides
AR Aging
Analyze your receivables aging, estimate bad debt exposure, and see the cash flow impact of faster collections.
DPO Calculator
Calculate days payable outstanding from your AP balance and cost of goods sold, then model whether paying early for a discount beats holding the cash.
Glossary: dpo
Canonical definition and related AP context.
analytics dashboard
Product capability and workflow fit.
Month-End Close Software: What to Automate First (2026)
Month end close software automates reconciliations, exception handling, and reporting so finance teams can close faster with fewer errors and better visibility.
Ready to automate your AP?
See how Aequo AP can transform your accounts payable process.