Quick Answer

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:

Common fields in an AP aging report
FieldWhat it tells you
Vendor nameWho you owe
Invoice numberWhich specific bill
Invoice dateWhen the vendor issued it
Due dateWhen it must be paid under the payment terms
Original amountThe full invoice total
Amount paid and creditsPartial payments and credit memos already applied
Outstanding balanceWhat is still owed
Days past dueHow late the invoice is as of the report date
Aging bucketThe time group the invoice falls into
StatusPending 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.

Invoice states you will see on an aging report
StateWhat it meansTypical action
Unpaid, not yet dueValid invoice within its termsSchedule for payment on time
Pending approvalWaiting for someone to sign offChase the approver before the due date
Approved, awaiting paymentReady to payInclude in the next payment run
Partially paidSome of the balance has been paidConfirm the remaining balance is correct
OverduePast the due date and unpaidFind the cause and prioritize
DisputedAmount or goods are in questionResolve 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.

Typical AP aging buckets (aged by due date)
BucketWhat it meansTypical action
CurrentNot yet duePay on schedule; watch invoices close to their due date
1 to 30 daysRecently past dueCheck why it's late and pay soon
31 to 60 daysModerately past dueLook for approval or dispute issues; contact the vendor
61 to 90 daysSignificantly past dueEscalate internally and set a resolution date
Over 90 daysSeriously past dueInvestigate: 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

Detailed AP aging report as of September 30, 2026 (example data)
VendorInvoice #Invoice dateDue dateAmountPaidBalanceDays past dueBucketStatus
ABC SuppliesABC-1042Sep 10Oct 10$4,500$0$4,5000 (due in 10)CurrentApproved
ABC SuppliesABC-1017Aug 15Sep 14$1,200$0$1,200161 to 30Pending approval
TechVendor Inc.TV-883Aug 5Sep 4$2,800$0$2,800261 to 30Approved
TechVendor Inc.TV-861Jul 10Aug 9$2,000$500$1,5005231 to 60Partially paid
TechVendor Inc.TV-840Jun 15Jul 15$800$0$8007761 to 90Disputed (price)
Office SolutionsOS-310Sep 20Oct 20$800$0$8000 (due in 20)CurrentPending approval
Office SolutionsOS-288Jul 20Aug 19$3,200$0$3,2004231 to 60Approved
Office SolutionsOS-201May 1May 31$450$0$450122Over 90Possible duplicate

Summary by vendor

AP aging summary as of September 30, 2026 (example data)
VendorCurrent1 to 3031 to 6061 to 90Over 90Total
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 total34.8%26.2%30.8%5.2%3.0%100%
Outstanding payables by aging bucket Example data: Current 5,300 dollars, 1 to 30 days 4,000 dollars, 31 to 60 days 4,700 dollars, 61 to 90 days 800 dollars, over 90 days 450 dollars. Total 15,250 dollars. About 65 percent of the balance is past due. Outstanding payables by aging bucket (example) $0 $2k $4k $6k $5,300 Current $4,000 1 to 30 $4,700 31 to 60 $800 61 to 90 $450 Over 90 Days past due as of September 30, 2026
Figure 1. In this example, $9,950 (about 65%) of the $15,250 balance is already past due, and $5,500 is more than 30 days late.
Aging mix by vendor Stacked bars for each vendor showing how their balance splits across aging buckets. ABC Supplies is mostly current. TechVendor Inc. is entirely past due, spread from 1 to 90 days. Office Solutions has a large 31 to 60 day balance and a small invoice over 90 days. Aging mix by vendor (example) ABC Supplies $5,700 TechVendor Inc. $5,100 Office Solutions $4,450 Current 1 to 30 31 to 60 61 to 90 Over 90
Figure 2. Looking by vendor shows where the risk sits. TechVendor's entire balance is past due, which usually points to a process or dispute problem, not just timing.

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:

Days past due = report date minus invoice due date
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:

Days past due (H2): =$B$1-D2 Aging bucket (I2): =IF(H2<=0,"Current",IF(H2<=30,"1-30",IF(H2<=60,"31-60",IF(H2<=90,"61-90","90+"))))

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:

Invoice received Entered with due date Approved Scheduled for payment Paid Removed from aging

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

AP aging vs AR aging
FeatureAP aging reportAR aging report
TracksMoney you owe vendorsMoney customers owe you
PurposeManage outflows and liabilitiesManage inflows and collections
Main riskLate fees and strained vendor relationshipsCash shortfalls and bad debt
Main actionPrioritize and schedule paymentsFollow up on collections
Related metricDays 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

Three related AP records
RecordWhat it showsUsed for
AP aging reportOutstanding vendor balances organized by agePayment priorities and cash planning
AP subledgerEvery vendor transaction: invoices, payments, creditsDetailed vendor history and research
General ledgerThe total accounts payable balanceFinancial 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.

DPO = (average accounts payable / cost of goods sold) × number of days in the period

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

Metrics that go with the AP aging report
MetricHow to calculate itIn the example
Past-due percentagePast-due balance / total balance$9,950 / $15,250 = 65%
Over-60-day percentage61+ day balance / total balance$1,250 / $15,250 = 8%
On-time payment rateInvoices paid by due date / invoices paidTrack over time
Days payable outstandingSee the formula aboveTrack over time
Discount capture rateDiscounts taken / discounts offeredTrack over time
Average days past due by vendorWeighted average of days past due per vendorHighlights 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.

Shyam Agarwal
Sr. Project Manager

Shyam Agarwal is a technology professional with 12+ years of experience in Salesforce consulting, development, and administration. He writes about accounts payable, AP automation, and Salesforce, drawing on his experience delivering scalable technology solutions that support business needs and improve operational efficiency.