What is an AP Aging Report?

An AP aging report is a financial document that groups unpaid vendor invoices by how long they've been outstanding — typically in 30-day buckets (Current, 1-30, 31-60, 61-90, and 90+ days past due). It shows your team exactly which bills are on track, which are slipping, and which are heading toward late fees or vendor relationship damage.

Most finance teams generate this report. Far fewer actually act on it. The aging report isn't a scorecard to review at month-end. It's an early warning system that tells you where cash is about to leave, which vendor relationships are at risk, and whether your AP process is keeping pace with invoice volume.

How an AP Aging Report Works

An aging report pulls every open (unpaid) invoice from your accounting system and sorts each one into a time bucket based on its due date or invoice date.

Standard aging buckets:

Bucket	Status	What It Signals
Current (not yet due)	Healthy	Invoice received, payment not yet required
1-30 days past due	Watch	Missed the payment window — investigate
31-60 days past due	Warning	Late fees likely accruing, vendor follow-up expected
61-90 days past due	Escalation	Relationship at risk, possible credit hold
90+ days past due	Critical	Supply chain risk, potential write-off, dispute likely

Each line item shows the vendor name, invoice number, invoice date, due date, and amount. The report totals each bucket, giving you both a vendor-level and company-level view of payment health.

There are two aging methods. Due date aging counts days from when payment was due — this is what most AP teams use because it measures payment performance. Invoice date aging counts from when the invoice was issued — useful for tracking processing speed from receipt to payment.

How to Read an AP Aging Report

Reading the report top-to-bottom is a waste of time. Use this sequence:

Start with the distribution. In a healthy AP function, 70-80% of your total outstanding balance sits in the Current column. If more than 20% of payables are past due, your payment process has a structural problem — not a one-off miss.

Check the 90+ bucket first. These invoices represent real risk: vendor credit holds, supply disruptions, late fee accumulation, and damaged relationships. Every invoice over 90 days needs a name attached to it and a resolution plan this week.

Look for vendor concentration. If one vendor holds 30% of your past-due balance, that's a single point of failure. A credit hold from that vendor could halt operations.

Spot the repeaters. Vendors showing balances spread across multiple buckets — some current, some 60 days out — usually indicate a dispute, an approval bottleneck, or invoices stuck in three-way matching.

Compare to last period. A single aging snapshot tells you where you are. Two snapshots tell you which direction you're heading. If your 60+ balance grew 15% month-over-month, you have a process problem that won't fix itself.

AP Aging Report vs. AR Aging Report

Aspect	AP Aging Report	AR Aging Report
Tracks	Money you owe vendors	Money customers owe you
Managed by	Accounts payable team	Accounts receivable team
Risk of aging	Late fees, credit holds, vendor loss	Cash shortfall, bad debt write-offs
Action trigger	Pay or resolve dispute	Collect or escalate
Cash flow impact	Outflows	Inflows

They're mirror images. Your AP aging report is someone else's AR aging report. Both use the same bucket structure, but the actions they drive are opposite — one pushes cash out faster, the other pulls cash in faster.

When to Act on Your Aging Report

Run your AP aging report when:

• Weekly during normal operations to catch slippage before it hits 60 days
• Daily during month-end close to clear open items
• Before cash flow forecasting to feed accurate payment timing data
• After any vendor dispute to track resolution progress

Skip building a custom aging report when:

• Your AP automation tool already surfaces aging data in its dashboard — focus on the alerts, not the report

AP Aging Report Best Practices

1. Set bucket-level thresholds, not just totals. A $500,000 total AP balance means nothing without context. But "$85,000 in the 60+ bucket, up from $40,000 last month" triggers investigation.

2. Match the report to your general ledger. Your aging report total should equal your AP balance on the trial balance. If it doesn't, you have unrecorded invoices, posting errors, or timing differences to resolve.

3. Assign owners to past-due buckets. Every invoice over 30 days should have someone responsible for resolution. Unassigned past-due invoices age silently until they become emergencies.

4. Automate the report, not just the generation. Most teams automate pulling the report but still manually review it. Use AP automation to flag exceptions, send escalation alerts, and route past-due items to the right person automatically.

5. Track early payment discount misses. Cross-reference your aging data with discount terms. Every invoice that ages past its discount window (typically 10 days for 2/10 net 30 terms) represents a 36.7% annualized return your team left on the table.

Key Takeaways

• Definition: An AP aging report groups unpaid invoices by days outstanding in 30-day buckets to show payment health at a glance
• Reading order: Check overall distribution first, then 90+ days, then vendor concentration, then period-over-period trend
• Healthy benchmark: 70-80% of outstanding payables in the Current bucket, with declining balances in each past-due category
• Action rule: Every invoice over 30 days past due needs an assigned owner and a resolution plan

Related Terms

• Accounts Payable KPIs - Metrics like DPO and cost per invoice that aging data feeds into
• Accounts Payable Dashboard - Real-time view where aging data surfaces alongside other AP metrics
• Payment Reconciliation - Process that resolves discrepancies found through aging analysis
• Accounts Payable Turnover Ratio - Formula that uses the same payment timing data as aging reports