What Is an Accounts Payable Aging Report? Definition & Benefits

An accounts payable aging report shows every unpaid vendor invoice a business owes, grouped by how long they have been outstanding or overdue. I managed full-cycle accounts payable for a manufacturing client processing more than 20 supplier invoices a day, and this report was the first thing I checked before running any payment batch. At that volume, waiting until month-end to see what's overdue isn't an option.

The report groups invoices into aging buckets, typically Current, 1-30, 31-60, 61-90, and 90+ days, so you can see at a glance which payments need attention first. For a business with a handful of vendors, this might be a formality. For a business managing dozens of active suppliers with different terms and payment schedules, it's the tool that keeps cash flow predictable and prevents a vendor relationship from souring over a payment that slipped through the cracks.

Example of an accounts payable aging report

Here's a simplified example of what an A/P aging summary might look like:

 At first glance, Supplier A has the largest outstanding balance. However, Supplier C deserves more immediate investigation because $2,400 has been outstanding for more than 90 days.

That doesn't automatically mean Supplier C should be paid first. The old balance could be a disputed bill, an unapplied vendor credit, a duplicate transaction, or a payment that wasn't properly applied. The aging report tells you where to investigate first, not necessarily which bill to pay first.

What information is included in an A/P aging report?

An A/P aging detail report commonly includes:

• Vendor name
• Bill or invoice number
• Invoice date
• Due date
• Original invoice amount
• Remaining or open balance
• Aging bucket
• Total amount owed to the vendor

Vendor credits, credit memos, and payments can also affect the outstanding balances shown on the report.

Why is an A/P aging report important?

Reviewed regularly, an A/P aging report shapes how you manage cash, catch vendor issues early, and keep your books accurate.

When & how to generate an A/P aging report

Most guides recommend reviewing an A/P aging report at least monthly, and that's a reasonable baseline if your vendor list and invoice volume are small.

However, when I was processing 20+ supplier invoices a day for a manufacturing client, monthly wasn't nearly often enough. I ran the report before every payment batch, sometimes multiple times a week, because a lot can change in a few days when invoices are coming in at that pace.

A reasonable schedule might look like this:

The important thing is to review the report often enough that overdue invoices don't surprise you.

Also check the report's as-of date before using it for payment decisions or reconciliation. An aging report is a point-in-time report, so running it as of August 15 can produce different aging classifications from running it as of August 31.

In QuickBooks Online, go to Reports in the left-hand menu, then look under the What you owe section for Accounts payable aging summary or Accounts payable aging detail, depending on which view you need.

How to read an A/P aging report

There are two versions of this report, and knowing which one to pull matters depending on what decision you're trying to make.

1. A/P aging summary: This shows one total per vendor, broken into aging buckets. It tells you how much you owe each vendor in total, but not which specific invoices make up that balance. I relied on this version most when cash was tight, and I needed a fast read on where the biggest exposure was sitting before deciding who to pay.
2. A/P aging detail: This breaks that same information down to the invoice level, showing each individual bill, its amount, and which aging bucket it falls into. This is the version I pulled when I needed to act on something specific, like confirming exactly which invoice was overdue before calling a vendor, or verifying that a payment we'd made had actually been applied to the right bill.

A pattern worth watching for in the detail report: when a vendor's total balance looks reasonable at the summary level, but the detail shows one old invoice sitting far past due while everything else is current. That's often the invoice that slipped through, whether from a data entry error, a missed approval, or a dispute nobody followed up on. The summary report alone wouldn't have flagged it since the vendor's overall balance looked fine.

How to use the A/P aging report to manage vendor payments

In an ideal world, there's always enough cash to pay every bill on time. In practice, most businesses have to choose which vendors get paid first when cash is limited. The aging report is what makes those choices deliberate instead of reactive.

1. Set aside cash for payroll first. Before allocating anything to vendors, make sure payroll and payroll taxes are covered. Once that's set aside, decide how to divide what's left among outstanding bills.
2. Give the 90+ days overdue column the most attention. These invoices are most likely to trigger late fees, damage vendor relationships, or cause a vendor to pause shipments until payment clears.
3. Know which vendors you can't afford to lose. Not every vendor carries the same weight. If a single supplier accounts for most of your materials, they get priority over a vendor you could replace without disrupting operations.
4. Watch for unusual items. An invoice that's larger than the vendor's typical amount, or one that shows as outstanding despite a payment already being sent, is worth a second look. Contact the vendor directly to resolve it, whether that means requesting a corrected invoice or providing proof of payment.
5. Use a clean payment history as leverage. If your aging report shows a consistent pattern of on-time payments, you can use that when asking a vendor for extended terms or an early payment discount.

Payment method considerations

How you pay matters as much as when you pay. A few things I learned managing high-volume AP:

• Ask suppliers if they accept credit cards. When there's no significant processing fee, paying by credit card extends the time before cash actually leaves the business, which helps with short-term cash flow. Just make sure the balance gets paid off on time to avoid interest charges eating into that benefit.
• Verify banking details before the first ACH payment to a new supplier. I confirm bank information by phone and email, using contact details I already have on file for that supplier, not the ones listed on a new invoice. This is a basic safeguard against sending money to the wrong account, whether that's a simple data entry error or a fraud attempt.
• Choose between credit card and ACH based on the payment itself. Credit cards make sense when the rewards or terms are worth it and the fees stay reasonable. For larger or recurring vendor payments, ACH is usually the more cost-effective option.

How to reconcile an A/P aging report to the balance sheet

The A/P aging report acts as a subsidiary record supporting the accounts payable balance in the general ledger.

In simple terms:

• A/P aging report: Shows which vendors you owe, the outstanding bills, and how old those balances are.
• Balance sheet: Shows the total accounts payable liability.
• General ledger: Contains the accounting entries making up the A/P control account.

For example, suppose your A/P aging report totals $48,500, while the accounts payable balance on your balance sheet is $51,200 as of the same date. The $2,700 difference should be investigated rather than simply accepted.

Possible causes include an incorrect posting, unapplied transaction, opening-balance problem, or an adjustment posted directly to the A/P account.

This reconciliation is particularly important at month-end and year-end because the aging report supports the A/P amount being reported on the financial statements.

Common issues that make an A/P aging report inaccurate

An aging report is only as reliable as the data behind it. Before trusting it to guide payment decisions, know where the report can go wrong.

Incorrect vendor terms and dates

If a vendor's terms are entered incorrectly — say, Net 30 when the actual agreement is Net 60 — the report can make an invoice appear overdue earlier than it should. I made it a habit to verify vendor terms when onboarding a new supplier into QuickBooks Online because a wrong setup at that stage can affect every future bill until someone catches it.

Invoice and due dates also matter. Entering the wrong date can shift a bill into the wrong aging bucket and distort which balances appear most urgent.

Duplicate bills

Entering the same vendor invoice twice overstates both the amount owed to the vendor and total accounts payable. Review invoice numbers, amounts, dates, and supporting documents when an outstanding balance looks unusual.

Payments not applied to bills

A business may have already paid the vendor while the bill continues to appear on the aging report because the payment wasn't properly applied to the outstanding transaction. This is one reason an old invoice shouldn't automatically be paid again just because it appears in the 90+ day column.

Unapplied vendor credits

Vendor credits reduce what you owe, but an unapplied credit may sit separately from the bill it was intended to offset. Review available vendor credits before issuing a payment, especially when a vendor's balance doesn't agree with its statement.

Old disputed invoices

A disputed invoice can remain on an aging report for months if nobody follows up. Instead of allowing these items to accumulate indefinitely, document the dispute, assign responsibility for resolving it, and follow up with the vendor.

Direct entries to accounts payable

Transactions or adjustments posted directly to the A/P control account can cause the general ledger balance to differ from the aging report. This is one reason I prefer A/P transactions to flow through the proper vendor and bill workflow whenever possible.

Differences between your records and vendor statements

The aging report reflects what's in your accounting system, not necessarily what the vendor's records show.

Periodically comparing your A/P aging report with vendor statements can uncover:

• Payments the vendor hasn't applied
• Invoices you never received
• Missing vendor credits
• Duplicate invoices
• Different outstanding balances

I did this reconciliation regularly with higher-volume vendors instead of waiting for a vendor to flag a discrepancy themselves.

A/P aging vs A/R aging

Accounts payable aging and accounts receivable aging use a similar concept but look at opposite sides of the business.

A/P aging helps determine what the business needs to pay, while A/R aging helps determine what the business needs to collect.

Frequently Asked Questions (FAQs)