Skip to content
Definition

Accounts payable aging report: how to read and use it

An accounts payable aging report lists unpaid supplier invoices grouped by how long they are outstanding, usually current, 1–30, 31–60, 61–90 and over 90 days past due, so AP can see what to pay first.

Last updated

Quick answer

What is an accounts payable aging report?

An accounts payable aging report lists every unpaid supplier bill grouped by how long it has been outstanding, usually current, 1–30, 31–60, 61–90 and over 90 days past due, with totals per vendor. AP uses it to plan payment runs, catch late or disputed bills, and reconcile payables to the general ledger at month end.

Formula

Days past due = Report date − Due date; Past due % = Past-due balance ÷ Total open payables × 100

Example: Open payables are $412,300, of which $122,300 is past due. Past due % = $122,300 ÷ $412,300 × 100 = 29.7%.

An AP aging report groups unpaid bills by how overdue they are, typically current, 1–30, 31–60, 61–90 and over 90 days. Reviewing it weekly shows which suppliers are at risk of being paid late and which old balances may be duplicates, unapplied credits or disputes. Its total should match the AP control account at month end.

Definition

The AP aging report is a standard accounting report that shows every open bill by vendor and age bucket, with totals for each bucket. It helps the team schedule payments, spot late bills before suppliers chase them, find disputed or forgotten invoices, and reconcile the AP subledger to the general ledger at month end. Accounting systems such as QuickBooks Online (A/P Aging) and Xero (Aged Payables) produce one as standard. The accounts receivable aging report is the mirror image: it groups what customers owe you by age, and is the main tool for collections.

How an aging report is built

Every aging report has an "as of" date. For each open invoice, the report subtracts the due date from that date to get the days past due, then places the invoice in a bucket. An invoice not yet due goes in Current. One that is 41 days past due goes in 31–60. Each row is a vendor, each column a bucket, and the bottom row totals each bucket.

Some reports age from the invoice date instead of the due date. The two give different answers: a net 60 invoice dated 45 days ago is current by due date but in the 31–60 bucket by invoice date. Check which setting your report uses before drawing conclusions. A detail version lists each invoice with its number, dates and amount; a summary version shows totals per vendor.

The report's grand total should equal the accounts payable control account in the general ledger on the same date. A difference means a bill posted to the wrong account, a manual journal to AP, or an unapplied payment or credit.

How to read an AP aging report

Start with the column totals. Current is your normal pipeline. The 1–30 bucket is usually timing: approvals running a little late. Balances over 60 or 90 days are rarely just slow payment. They usually point to a dispute nobody closed, an invoice stuck in approval, a duplicate, or a bill that should not be in AP at all.

Then scan by vendor. Negative balances are usually unapplied credits or overpayments you can recover or use. The same amount appearing twice for one vendor can be a duplicate bill. Compare open invoices with vendor statements for your largest suppliers.

AR aging works the same way in reverse. Instead of planning payments, you use it to decide which customers to chase. A large and growing over-90 bucket in AR is a bad-debt risk and pushes up days sales outstanding.

Example AP aging summary as of October 31 (illustrative)
VendorCurrent1–3031–6061–90Over 90Total
Northline Supply$120,000$32,000$0$0$0$152,000
Metro Freight$64,000$18,500$12,000$0$0$94,500
Brightway IT$46,000$0$0$0$0$46,000
Coastal Packaging$38,000$21,000$9,500$9,800$0$78,300
Delta Facilities$22,000$6,500$5,000$0$8,000$41,500
Total$290,000$78,000$26,500$9,800$8,000$412,300

Past due is $122,300, or 29.7% of open payables. The $17,800 over 60 days (Coastal Packaging and Delta Facilities) is where to look for disputes, duplicates and stuck approvals.

The AP aging report in common accounting systems
SystemReport name
QuickBooks OnlineA/P Aging Summary and A/P Aging Detail
XeroAged Payables Summary and Aged Payables Detail, aged by due date or invoice date
NetSuiteA/P Aging summary and detail reports
Business CentralAged Accounts Payable, aged by due date, posting date or document date
Sage IntacctAP Aging report in Accounts Payable reports

Why It Matters

Aging reports reveal payment performance at a glance. A growing 90+ day bucket signals process problems, disputes or cash flow issues that need attention before supplier relationships deteriorate. The report also feeds cash planning: the Current and 1–30 columns show roughly how much cash the next few payment runs will need.

Examples

Reading the buckets

Total open AP is $412,300: $290,000 current, $78,000 at 1–30 days, $26,500 at 31–60, $9,800 at 61–90 and $8,000 over 90. Past due is $122,300, or 29.7% of the total. The team pays the 1–30 items in this week's run and investigates the $17,800 over 60 days.

Placing an invoice in a bucket

The report is run as of October 31. An invoice due September 20 is 41 days past due, so it appears in the 31–60 bucket. An invoice due November 15 is still current.

Month-end check

The aging report totals $412,300 but the AP control account in the general ledger shows $415,100. The $2,800 difference points to a bill posted to the wrong account or a manual journal that needs investigating.

Common Mistakes

  • Not knowing the aging basis

    Confirm whether the report ages by due date or invoice date. By invoice date, long-term invoices look overdue when they are not.

  • Ignoring negative balances

    Credits and overpayments sit quietly in the report. Apply them to open bills or ask the supplier for a refund.

  • Paying the oldest bills blindly

    Old items are often disputed or duplicated. Check why a bill is old before paying it.

  • Skipping the reconciliation

    Tie the aging total to the AP control account every month end. An unreconciled aging report hides posting errors.

  • Missing unrecorded bills

    The report shows only bills that have been entered. Invoices stuck in someone's inbox or in approval are not on it, so the true liability can be higher.

In Practice

  1. Run the AP aging report weekly as of today's date, aged by due date.
  2. Review bucket totals to see how much is current and how much is past due.
  3. For anything over 30 days, find the reason: approval, dispute, missing receipt or duplicate.
  4. Apply open credits and resolve disputes with suppliers.
  5. Use the Current and 1–30 columns to plan the next payment run.
  6. At month end, reconcile the aging total to the AP control account in the general ledger.

Tools and Further Reading

How Aequo AP Helps

Aequo AP syncs approved bills to QuickBooks Online, Xero, FreshBooks, Zoho Books or Business Central, where the standard AP aging report stays accurate. Inside Aequo AP, the exception aging report shows how long invoices have been stuck in review, which is often why bills turn up late on the aging. Vendor payments inside Aequo are coming soon. For receivables, the free AR aging calculator turns your aging buckets into a DSO estimate.

Start Free Trial

Frequently Asked Questions

What are the aging buckets?

Most reports use current (not yet due), 1–30, 31–60, 61–90 and over 90 days past due. Some count from the invoice date instead of the due date, so check the report setting.

How do you read an AP aging report?

Start with the column totals to see how much is current and how much is overdue, then look at vendors with balances over 60 days, negative balances and repeated amounts. Each of those usually has a specific cause to fix.

How often should you review the AP aging report?

Weekly for payment planning, and at every month end to reconcile it to the AP balance in the general ledger.

What is the difference between AP aging and AR aging?

AP aging shows what you owe suppliers. AR aging shows what customers owe you. Both use the same age buckets. AP aging helps plan payments; AR aging drives collections.

Why doesn't my AP aging match the balance sheet?

Usually because of a bill posted to the wrong account, a manual journal entry to accounts payable, or an unapplied payment or credit. Compare the two on the same date and investigate the difference.

What does a large 90+ day balance mean?

It usually means a process problem rather than slow payment: an unresolved dispute, a duplicate or incorrect bill, or an invoice waiting for a missing approval or receipt.

Ready to automate your AP?

See how Aequo AP can transform your accounts payable process.