What Is AP Aging? Reading the Report That Runs Your Cash Flow
The AP aging report is a structured view of every unpaid invoice in accounts payable, grouped by how long each has been outstanding. It is typically generated weekly or monthly and reviewed by the controller, CFO, and AP manager as part of normal cash-flow management. On any meaningful accounting platform, it's a built-in report with standardized aging buckets.
The reason the report exists: paying invoices on time is a cash-flow decision, and cash-flow decisions require knowing what's due when. A lump-sum AP balance without aging detail hides the single most important piece of information — which payments are coming due soonest and which are already past due. Aging detail makes the AP balance actionable.
Most aging reports use the same set of buckets by convention. The buckets aren't mandatory — some organizations use 7-day or 14-day buckets for tighter tracking — but the 0/30/60/90 convention is the one everyone recognizes.
Standard AP aging buckets
- Current (not yet due) — invoices within the contractual payment terms
- 0-30 days past due — invoices overdue but still in the early collection zone
- 31-60 days past due — invoices that should have been paid and weren't, likely with a cash flow or operational cause
- 61-90 days past due — invoices where the vendor is almost certainly calling; serious AP attention needed
- Over 90 days past due — either a disputed invoice, a vendor that fell off the radar, or a genuine payment crisis
Some systems split the 'current' bucket by when payment is due (e.g. 1-10 days to due date, 11-20, 21-30), giving forward visibility into the upcoming payment schedule. This is particularly useful for cash-flow planning, since it shows what volume of payment will be required in the next 30 days if all current invoices pay on time.
A useful AP aging report has two dimensions: the aging buckets across the top (current, 1-30, 31-60, 61-90, 90+), and the vendors down the side. Each cell shows the dollar amount owed to that vendor in that aging bucket. Totals run both directions — total across buckets per vendor, and total across vendors per bucket.
The first read is the bucket totals. A healthy AP operation has the vast majority of the balance in the current bucket, small amounts in 0-30 past due, and negligible amounts in 31+ past due. When the 31-60 or 61-90 buckets start growing, something operational has broken — approvals are stalled, cash is tight, or invoices are getting lost.
The second read is vendor-level. Even when the overall bucket totals look healthy, individual vendors with significant past-due balances can be cause for concern. A single vendor with $80,000 in the 61-90 bucket may be close to suspending services, refusing future orders, or filing a mechanic's lien. The aggregate is fine; the specific relationship is not.
Beyond the headline numbers, specific patterns in an AP aging report point to specific operational problems.
Diagnostic patterns to watch for
- Growing 31-60 bucket week over week — approval workflow is backed up or short-staffed
- Concentrations in a single vendor — that relationship needs immediate attention before it disrupts supply
- Invoices in 90+ that have been there for months — either a disputed balance that should be resolved, or a vendor the business has simply stopped paying
- Large 'current' bucket with a spike of invoices all due the same day — cash flow planning gap for that date
- Total AP balance growing faster than revenue — spending is outpacing the business's capacity to pay
- AP balance shrinking while revenue is steady — payment velocity increasing, potentially good news but worth understanding the cause
The 90+ bucket is where quiet disasters accumulate. Invoices here are often there because no one knows what to do with them — there's a legitimate dispute that hasn't been resolved, or the invoice was misfiled, or the vendor hasn't followed up. A weekly rhythm of clearing the 90+ bucket (either paying it, formally disputing it, or writing it off) prevents the bucket from becoming a graveyard.
The aging report is the raw material for cash flow planning. Combined with the payment schedule (when each vendor gets paid per contractual terms), it produces a forward view of cash outflows. A controller who can see 'we have $2.1M due in the next 7 days, $3.8M in the next 14, $5.5M in the next 30' can make informed decisions about funding timing, draw requests, and treasury management.
Get AP insights in your inbox
Get our weekly roundup of AP automation tips and industry news. No spam, ever.
No spam. Unsubscribe anytime.
Without aging detail, cash flow planning becomes a guess. The total AP balance doesn't tell you when the payments come due; the aging report does. This is why aging is the report that shows up in every weekly CFO packet on a serious finance operation.
The aging report is also a vendor-relationship management tool. Vendors pay attention to their own AR aging — they know exactly how long your invoices have been outstanding. A vendor sees their own AR aging and calibrates their behavior based on it: offering extended credit to customers who pay on time, tightening terms for customers who don't, and in extreme cases suspending shipments or filing liens.
Your AP aging is therefore partly a record of your reputation. A consistent pattern of paying vendors within terms builds vendor goodwill that converts into better prices, larger credit lines, and prioritization when supply gets tight. A consistent pattern of late payments does the opposite — at exactly the moments when you most need vendor flexibility.
Your AP aging and the vendor's AR aging for your account should agree. They usually don't, exactly — timing differences, invoices in transit, credits and adjustments. The controlled process of reconciling the two (typically monthly on important vendor relationships) catches errors in both directions: invoices the vendor sent that you didn't receive, invoices you received that the vendor thinks they didn't send, payments applied to the wrong invoice, credits that haven't been posted.
Vendor statement reconciliation is separate from aging analysis but closely related. The aging report identifies old balances that warrant vendor outreach; vendor statements confirm whether the old balances are legitimate or reconciliation errors. Doing both on a regular rhythm is the foundation of clean AP operations.
Modern AP automation doesn't eliminate aging reports — it changes what's on them. Two specific improvements matter. First: the 90+ bucket should approach zero because invoices can't sit there undetected — automated systems surface them continuously. Second: the cause of each past-due invoice should be knowable — automated approval workflow logs show exactly why an invoice is stuck, which party is holding it up, and how long it has been in that state.
The controller's aging-report review shifts from 'what do we owe' to 'why are these specific items stuck and who needs to unblock them.' That's a meaningfully different conversation, and it's the one that actually moves cash flow.
AP aging is the report every controller reads before asking any other question about payables. Properly produced and regularly reviewed, it's the primary tool for cash flow management, vendor relationship management, and operational troubleshooting. A clean aging report — meaning most of the balance is in 'current,' past-due amounts are specific and actionable, and the 90+ bucket is being actively worked down — is one of the clearest signs of a well-run AP operation.
Written by
Sarah Blake
Head of Product
Former AP Manager at a $200M construction firm, now leads product at Covinly. Writes about what AP teams actually need from automation — beyond the marketing promises.
View all posts