AP Aging Report Explained

The AP aging report is one of the most important reports in accounts payable. It shows how much you owe, to whom, and how long invoices have been outstanding. Here’s how to read it, use it, and act on what it tells you.

What Is an AP Aging Report?

An AP aging report organizes your outstanding payables by how old they are. It groups unpaid invoices into “buckets” based on days since the invoice date (or due date), giving you a snapshot of your payment obligations.

Standard Aging Buckets

Most aging reports use these standard categories:

Bucket	Days Outstanding	Status
Current	0-30 days	Not yet due
31-60 days	31-60 days	Recently past due
61-90 days	61-90 days	Significantly overdue
90+ days	Over 90 days	Seriously delinquent

Some reports add more granularity: - 1-15 days - 16-30 days - 31-45 days - 46-60 days - And so on

Reading an AP Aging Report

Sample Report

AP AGING REPORT
As of: January 31, 2025

Vendor              Current    31-60     61-90      90+       Total
---------------------------------------------------------------------------
ABC Supplies        $5,000     $2,000    $0         $0        $7,000
XYZ Services        $3,500     $0        $1,500     $0        $5,000
Office Depot        $1,200     $800      $0         $300      $2,300
Tech Solutions      $0         $0        $4,000     $2,500    $6,500
---------------------------------------------------------------------------
TOTAL              $9,700     $2,800    $5,500     $2,800    $20,800

Percentage          46.6%      13.5%     26.4%      13.5%     100%

What This Tells You

Total owed: $20,800 in unpaid invoices
Current: $9,700 (47%) is not yet due—healthy
Past due: $11,100 (53%) is overdue—concerning
Seriously past due: $2,800 over 90 days—needs immediate attention
Problem vendor: Tech Solutions has $6,500 all past due

Aging by Invoice Date vs. Due Date

Reports can age invoices two ways:

Invoice Date Aging

Counts days from when the invoice was dated. A 30-day-old invoice with Net 30 terms shows as “Current” even though it’s due now.

Pros: Simpler to calculate Cons: Doesn’t reflect actual past-due status

Due Date Aging

Counts days from when payment was due. An invoice 10 days past its due date shows as “1-30 past due.”

Pros: Shows true delinquency status Cons: Requires tracking payment terms

Best practice: Use due date aging for managing cash and vendor relationships.

Using the AP Aging Report

1. Cash Flow Management

The aging report tells you when money needs to go out:

Bucket	Action	Cash Impact
Current	Schedule for payment by due date	Plan for this outflow
31-60	Prioritize—pay now	Immediate need
61-90	Pay immediately if possible	Urgent
90+	Investigate and resolve	May affect vendor relationship

2. Payment Prioritization

When cash is tight, use aging to prioritize:

Pay first: - Critical vendors (can’t operate without them) - Vendors threatening credit holds - Invoices accruing interest/late fees - Invoices with early payment discounts expiring

Pay next: - Oldest invoices (worst aging) - Largest amounts (reduce total exposure) - Vendors with upcoming large orders

3. Vendor Relationship Management

Aging reveals vendor management issues:

Pattern	What It Means	Action
All current	Good payment habits	Maintain
Mostly 31-60	Slight cash flow strain	Monitor
Significant 61-90	Relationship risk	Communicate with vendor
High 90+	Serious problem	Immediate action required

4. Problem Identification

Look for these red flags:

Single large old invoice: May indicate dispute, lost invoice, or approval bottleneck

One vendor all past due: Could be a dispute or internal routing issue

Everything aging: Systemic cash flow or process problem

Invoices stuck in one bucket: Something’s holding up the process

Investigating Aged Items

When you find old invoices, ask:

Why Is It Outstanding?

Dispute: Vendor and your team disagree on charges
Lost in approval: Stuck waiting for someone’s sign-off
No budget: Expense wasn’t planned, waiting for resolution
Cash constraints: Company can’t pay yet
Process failure: Invoice was lost or never entered

What Needs to Happen?

Resolve dispute and pay (or get credit)
Get approval and release for payment
Obtain budget or management approval
Prioritize when cash is available
Find invoice and process properly

Who Needs to Act?

AP team
Approving manager
Department head
Purchasing
Vendor AR department

Improving Your Aging

Reduce Current → Past Due Movement

Process invoices faster
Get approvals sooner
Match to POs immediately
Resolve exceptions quickly

Clear Aged Items

Weekly review of 60+ day items
Escalation process for 90+ items
Regular vendor communication
Dispute resolution procedures

Prevent Items from Aging

Centralized invoice intake
Automated matching
Clear approval workflows
Exception handling procedures

Reporting Best Practices

Run Regularly

Weekly: For payment planning
Month-end: For close and management review
Ad hoc: When cash flow is tight

Compare Periods

Track aging trends:

Metric	December	January	Trend
Total Payables	$25,000	$20,800	↓ Good
% Past Due	45%	53%	↑ Concerning
90+ Days	$1,500	$2,800	↑ Problem

Share with Stakeholders

CFO/Controller: Overall picture and trends
Department heads: Their vendor obligations
Purchasing: Vendor relationship status
Treasury: Cash needs timing

AP Aging vs. AR Aging

Don’t confuse them:

	AP Aging	AR Aging
What it shows	Money you owe	Money owed to you
Who uses it	AP team, Treasury	AR team, Sales
Goal	Pay on time, not early	Collect as fast as possible
Old is bad because…	Damages relationships, late fees	Ties up your cash, bad debt risk

Key Takeaways

AP aging shows what you owe and how long it’s been outstanding
Use due date aging to see true past-due status
Current (0-30) should be your largest bucket
90+ days requires immediate attention
Weekly review prevents aging problems from growing
Investigate why items are stuck, not just how old they are

Want to see how long invoices wait before even entering your AP system? See how BillerPlus tracks invoice receipt to approval →

AP Aging Report Explained - How to Read and Use It