An accounts payable aging report (also called an AP aging report, aged payables report, or AP aging schedule) lists every unpaid vendor invoice and groups it by age, usually how many days it is past its due date. Common groups, called aging buckets, are Current, 1 to 30, 31 to 60, 61 to 90, and over 90 days past due.
Finance teams use it to see what they owe, to whom, and which bills need attention first, so they can plan cash, avoid late fees, and spot invoices stuck in approval or dispute.
As your business grows, keeping track of unpaid bills from memory, email, and spreadsheets stops working. The AP aging report gives you one organized view of every open vendor invoice and how old it is. This guide covers what the report contains, how aging is calculated, a detailed example with charts, and how to turn the report into payment decisions.
What Is an Accounts Payable Aging Report?
An accounts payable aging report is a list of your company's unpaid vendor invoices, sorted into time periods based on how long each invoice has been outstanding. Instead of one total for what you owe, it shows how that total is spread across time, by vendor and by invoice.
It answers four practical questions:
- How much do we owe in total?
- Which vendors do we owe?
- What is already past due, and by how much?
- What will come due soon?
Most companies run it from their accounting system or ERP. It's a core report in managing accounts payable, and it's the mirror image of the accounts receivable aging report, which tracks what customers owe you.
What Information Does an AP Aging Report Include?
A summary report shows totals by vendor and bucket. A detailed report adds one row per invoice. A useful detailed report includes these fields:
| Field | What it tells you |
|---|---|
| Vendor name | Who you owe |
| Invoice number | Which specific bill |
| Invoice date | When the vendor issued it |
| Due date | When it must be paid under the payment terms |
| Original amount | The full invoice total |
| Amount paid and credits | Partial payments and credit memos already applied |
| Outstanding balance | What is still owed |
| Days past due | How late the invoice is as of the report date |
| Aging bucket | The time group the invoice falls into |
| Status | Pending approval, approved, disputed, or scheduled for payment |
The status column isn't standard in every accounting system, but it's the field that turns an aging list into something you can act on.
Unpaid vs Overdue: Why the Difference Matters
Every invoice on an AP aging report is unpaid, but not every unpaid invoice is overdue. Treating them the same leads to bad decisions, like rushing to pay bills that aren't due yet or ignoring ones stuck in a dispute.
| State | What it means | Typical action |
|---|---|---|
| Unpaid, not yet due | Valid invoice within its terms | Schedule for payment on time |
| Pending approval | Waiting for someone to sign off | Chase the approver before the due date |
| Approved, awaiting payment | Ready to pay | Include in the next payment run |
| Partially paid | Some of the balance has been paid | Confirm the remaining balance is correct |
| Overdue | Past the due date and unpaid | Find the cause and prioritize |
| Disputed | Amount or goods are in question | Resolve with the vendor before paying |
AP Aging Buckets Explained
Aging buckets are the time ranges invoices are sorted into. The five below are a typical setup, not a universal rule. Some businesses use 15-day buckets, add a 120+ bucket, or age from invoice date instead of due date. What matters is that you use the same definition every time.
| Bucket | What it means | Typical action |
|---|---|---|
| Current | Not yet due | Pay on schedule; watch invoices close to their due date |
| 1 to 30 days | Recently past due | Check why it's late and pay soon |
| 31 to 60 days | Moderately past due | Look for approval or dispute issues; contact the vendor |
| 61 to 90 days | Significantly past due | Escalate internally and set a resolution date |
| Over 90 days | Seriously past due | Investigate: dispute, duplicate, or missing credit? |
Accounts Payable Aging Report Example
Here's a worked example for a fictional company with three vendors, using a report date of September 30, 2026. First the invoice-level detail, then the summary it rolls up into.
Invoice-level detail
| Vendor | Invoice # | Invoice date | Due date | Amount | Paid | Balance | Days past due | Bucket | Status |
|---|---|---|---|---|---|---|---|---|---|
| ABC Supplies | ABC-1042 | Sep 10 | Oct 10 | $4,500 | $0 | $4,500 | 0 (due in 10) | Current | Approved |
| ABC Supplies | ABC-1017 | Aug 15 | Sep 14 | $1,200 | $0 | $1,200 | 16 | 1 to 30 | Pending approval |
| TechVendor Inc. | TV-883 | Aug 5 | Sep 4 | $2,800 | $0 | $2,800 | 26 | 1 to 30 | Approved |
| TechVendor Inc. | TV-861 | Jul 10 | Aug 9 | $2,000 | $500 | $1,500 | 52 | 31 to 60 | Partially paid |
| TechVendor Inc. | TV-840 | Jun 15 | Jul 15 | $800 | $0 | $800 | 77 | 61 to 90 | Disputed (price) |
| Office Solutions | OS-310 | Sep 20 | Oct 20 | $800 | $0 | $800 | 0 (due in 20) | Current | Pending approval |
| Office Solutions | OS-288 | Jul 20 | Aug 19 | $3,200 | $0 | $3,200 | 42 | 31 to 60 | Approved |
| Office Solutions | OS-201 | May 1 | May 31 | $450 | $0 | $450 | 122 | Over 90 | Possible duplicate |
Summary by vendor
| Vendor | Current | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| ABC Supplies | $4,500 | $1,200 | $0 | $0 | $0 | $5,700 |
| TechVendor Inc. | $0 | $2,800 | $1,500 | $800 | $0 | $5,100 |
| Office Solutions | $800 | $0 | $3,200 | $0 | $450 | $4,450 |
| Total | $5,300 | $4,000 | $4,700 | $800 | $450 | $15,250 |
| % of total | 34.8% | 26.2% | 30.8% | 5.2% | 3.0% | 100% |
How to interpret this example
- ABC Supplies: Mostly current. The one overdue invoice (ABC-1017) is late because it's still waiting for approval, so the fix is chasing the approver, not finding cash.
- TechVendor Inc.: Every dollar is past due. TV-883 is approved and should go in the next payment run. TV-861 has a partial payment to confirm. TV-840 is disputed and shouldn't be paid until the price issue is settled.
- Office Solutions: OS-288 is approved but 42 days late, which suggests it was missed in a payment run. OS-201 is 122 days old and flagged as a possible duplicate. Check it before paying.
Notice that the bucket alone doesn't tell you what to do. The status column does.
How Is Accounts Payable Aging Calculated?
Most AP aging reports age invoices by due date, which measures how late each invoice is:
Zero or negative = Current | Positive = place in the matching overdue bucket
Outstanding balance = original amount minus payments minus credits applied
Some reports age by invoice date instead (report date minus invoice date). That shows how long you've held the invoice regardless of terms, which can help spot slow processing. Due-date aging is better for payment risk. Pick one method, label the report clearly, and keep it consistent.
A few rules keep the numbers accurate:
- Age the outstanding balance, not the original amount, when partial payments exist
- Apply vendor credit memos before aging, or show them as negative amounts
- Use a fixed report date, such as month-end, so reports are comparable
How to Create an Accounts Payable Aging Report
Most accounting systems and ERPs generate an AP aging report automatically. If you need to build one in Excel or Google Sheets, follow these steps:
- Export open invoices from your accounting system, including partial payments and credits
- Add the key columns: vendor, invoice number, invoice date, due date, amount, paid, balance, and status
- Set a report date in one cell
- Calculate days past due and assign each invoice to a bucket
- Build a summary with a pivot table: vendors as rows, buckets as columns, balance as values
- Reconcile the total to the AP balance in your general ledger
Spreadsheet formulas you can copy
With the report date in cell B1, the due date in column D, and the balance in column G:
How to Read and Analyze an AP Aging Report
Start with the totals, then work down to vendors and invoices. These are the patterns worth investigating:
- Balances in older buckets. Anything over 60 days usually has a reason: dispute, missing approval, duplicate, or a missed payment run.
- Concentration by vendor. One vendor holding most of the past-due balance points to a specific relationship or process problem.
- Repeat late invoices. The same vendor appearing overdue every month often means invoices go to the wrong person or arrive late.
- Current invoices near their due date. These need approval now to stay on time.
- Disputed and pending-approval items. These explain much of the overdue balance and need owners and deadlines.
- Unapplied credits and partial payments. They can make a vendor look more overdue than it is.
- Change over time. Compare this report with last month's. A growing 31 to 60 bucket is an early warning even if totals look stable.
How AP Aging Helps With Cash Flow and Payment Decisions
The aging report is a planning tool, not just a list of late bills. Finance teams use it to:
- Plan cash needs: the Current bucket plus approved overdue items shows what you'll need to pay in the coming weeks
- Prioritize payments: pay approved, undisputed overdue invoices and critical vendors first
- Avoid late fees: catch invoices before they cross their due date
- Capture early-payment discounts: identify invoices with discount terms, such as 2/10 net 30, before the discount window closes
- Manage working capital: pay on terms rather than early, unless a discount makes early payment worthwhile
For more on how AP timing affects cash, see how AP automation affects cash flow.
How Invoices Move Through AP Aging
Each invoice moves through the report as it progresses through your AP process:
Delays at any step push invoices into older buckets. Late entry shortens the time left to pay. Slow approval is the most common cause of 1 to 30 day items. Missed payment runs leave approved invoices sitting overdue. Unresolved disputes create most 60+ day balances. Our guide to invoice workflow vs invoice approval explains where these delays usually happen.
AP Aging Report vs AR Aging Report
| Feature | AP aging report | AR aging report |
|---|---|---|
| Tracks | Money you owe vendors | Money customers owe you |
| Purpose | Manage outflows and liabilities | Manage inflows and collections |
| Main risk | Late fees and strained vendor relationships | Cash shortfalls and bad debt |
| Main action | Prioritize and schedule payments | Follow up on collections |
| Related metric | Days payable outstanding (DPO) | Days sales outstanding (DSO) |
Reviewed together, they show your short-term cash position from both sides. For a broader comparison, see accounts payable vs accounts receivable.
AP Aging Report vs AP Subledger vs General Ledger
| Record | What it shows | Used for |
|---|---|---|
| AP aging report | Outstanding vendor balances organized by age | Payment priorities and cash planning |
| AP subledger | Every vendor transaction: invoices, payments, credits | Detailed vendor history and research |
| General ledger | The total accounts payable balance | Financial statements |
The aging report total should match the AP subledger, which should match the AP control account in the general ledger. If they don't, something is missing or misposted. Our accounts payable reconciliation guide explains how to find the difference.
AP Aging and Days Payable Outstanding (DPO)
AP aging and DPO are related but measure different things. The aging report is a snapshot of which invoices are open and how late they are. DPO is a performance metric that shows how long, on average, your company takes to pay suppliers.
A rising DPO alongside a growing 31+ day bucket usually means you're paying late. A rising DPO with a mostly current aging report can mean you've negotiated longer terms. You need both to tell the difference.
Common AP Aging Mistakes and Best Practices
Common mistakes
- Mixing invoice-date and due-date aging
- Ignoring partial payments and credits
- Leaving invoices out because they're still in someone's inbox
- Not reconciling the total to the general ledger
- Reviewing only the totals, never the old items
- Treating disputed invoices like ordinary overdue ones
Best practices
- Use one aging method and label it on the report
- Enter invoices as soon as they arrive
- Add a status column for approval and dispute
- Give every 60+ day item an owner and a date
- Reconcile to the GL at every month-end
- Share a short summary with leadership
Limitations of an AP Aging Report
The aging report gives you visibility, but it doesn't make decisions for you. On its own, it doesn't tell you:
- Whether an invoice is valid or a duplicate
- Whether it has been approved
- Whether the vendor or your team is disputing the amount
- Whether cash is available to pay it
- Whether it should be paid now, given your terms and priorities
It's also only as accurate as the data behind it. Invoices that haven't been entered yet don't appear at all, so a clean-looking report can still hide liabilities sitting in email.
Key AP Aging Metrics to Track
| Metric | How to calculate it | In the example |
|---|---|---|
| Past-due percentage | Past-due balance / total balance | $9,950 / $15,250 = 65% |
| Over-60-day percentage | 61+ day balance / total balance | $1,250 / $15,250 = 8% |
| On-time payment rate | Invoices paid by due date / invoices paid | Track over time |
| Days payable outstanding | See the formula above | Track over time |
| Discount capture rate | Discounts taken / discounts offered | Track over time |
| Average days past due by vendor | Weighted average of days past due per vendor | Highlights problem vendors |
For definitions of these and other measures, see our guide to accounts payable metrics.
How AP Software Can Improve AP Aging Visibility
Most aging problems start earlier in the process: invoices entered late, approvals that stall, and no record of which invoices are disputed. AP automation helps by capturing invoices as soon as they arrive, routing them for approval, and keeping a status on every invoice, so the data behind your aging report is complete and current.
Quick Payable is an AP automation app built on Salesforce. It captures invoices by email or upload with AI OCR, flags duplicates, routes approvals by approver monetary limit, and tracks each invoice from pending approval to paid. Its AP dashboards and reports show invoice status, upcoming payments, spend by vendor, and approval cycle time. Quick Payable doesn't include a prebuilt aging-bucket report today, but because the data lives in Salesforce, admins can build custom reports on top of it, and the status data helps explain why invoices on your accounting system's aging report are late.
Want a Clearer View of Your AP?
See how Quick Payable helps finance teams manage invoices, approvals, payment status, and AP reporting inside Salesforce. Try it free for 15 days, no credit card required.
Key Takeaways
- An AP aging report groups unpaid vendor invoices by how far past due they are.
- Unpaid and overdue aren't the same. Add a status column so you know why an invoice is late.
- Typical buckets are Current, 1 to 30, 31 to 60, 61 to 90, and over 90 days, but use whatever definition fits, consistently.
- Age the outstanding balance after partial payments and credits, and reconcile the total to the general ledger.
- Use it with DPO and on-time payment rate to judge whether you pay late or simply on longer terms.
Frequently Asked Questions
What is an accounts payable aging report?
An accounts payable aging report lists a company's unpaid vendor invoices and groups them by how long they have been outstanding, usually by days past the due date. It shows what you owe, to whom, and which invoices need attention first.
What are aging buckets in accounts payable?
Aging buckets are time ranges used to group invoices, typically Current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days past due. Businesses can use different ranges as long as they apply them consistently.
How do you calculate accounts payable aging?
Subtract each invoice's due date from the report date to get days past due. Zero or negative means the invoice is current. Positive values go into the matching overdue bucket. Use the outstanding balance after partial payments and credits.
Should AP aging be based on invoice date or due date?
Due date is more common because it shows payment risk. Invoice-date aging shows how long you have held an invoice regardless of terms, which can help spot slow processing. Choose one method and label the report clearly.
What is the difference between AP aging and AR aging?
AP aging tracks money your business owes vendors. AR aging tracks money customers owe your business. AP aging supports payment planning, while AR aging supports collections.
How often should you run an AP aging report?
It depends on payment volume. High-volume teams often review it before every payment run, while smaller businesses may review it weekly or monthly. At minimum, run it at every month-end close and reconcile it to the general ledger.
What is the difference between AP aging and DPO?
AP aging is a snapshot of open invoices and how late they are. Days payable outstanding is an average of how long your company takes to pay suppliers over a period. Using both shows whether you are paying late or simply on longer terms.
Can AP automation improve aging report accuracy?
It can help by capturing invoices as soon as they arrive, reducing manual entry errors, and tracking approval and payment status. The aging report is only as accurate as the invoice data behind it, so faster and more complete entry makes it more reliable.
By