Accounts Payable Aging Report: How to Read It (+ Example)

Quick answer: An accounts payable aging report lists every unpaid supplier bill grouped by age, usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due. It shows what you owe, to whom and how late, so you can plan payments, avoid late fees and spot errors like duplicate bills.

The AP aging report is one of the simplest and most useful reports in small business bookkeeping. This guide explains what each part means, how to read it, how to build one in a spreadsheet, and how to use it to make better payment decisions.

What is an accounts payable aging report?

Accounts payable (AP) is money your business owes to suppliers for goods or services received but not yet paid for. An AP aging report (also called an AP aging schedule or aged payables report) sorts those unpaid bills into time buckets based on how many days have passed since the due date or invoice date. It is the mirror image of the accounts receivable aging report, which shows what customers owe you. Our guide to accounts payable vs accounts receivable explains the difference in detail.

What are the aging buckets?

Bucket	Meaning	Usual action
Current	Not yet due	Schedule payment by the due date; take early payment discounts if worthwhile
1 to 30 days past due	Recently overdue	Pay in the next payment run
31 to 60 days	Moderately overdue	Prioritize; contact the supplier if you need more time
61 to 90 days	Seriously overdue	Agree a payment plan; risk of credit hold
Over 90 days	Very late, or disputed or in error	Investigate, resolve disputes, correct errors

Some businesses use 15-day buckets or add a "due in the next 7 days" column for weekly planning.

Accounts payable aging report example

Here is an AP aging report for a small print shop as of October 31, aged by due date.

Supplier	Current	1-30	31-60	61-90	90+	Total
Paper Supply Co.	$3,200	$1,450	$0	$0	$0	$4,650
Ink Wholesale LLC	$1,100	$0	$0	$0	$0	$1,100
Equipment Lease Inc.	$850	$850	$0	$0	$0	$1,700
Delivery Partners	$0	$0	$620	$0	$0	$620
Signage Studio	$0	$0	$0	$0	$1,800	$1,800
Total	$5,150	$2,300	$620	$0	$1,800	$9,870
% of total	52%	23%	6%	0%	18%	100%

How to read an AP aging report

Using the example above:

1. Check the total. $9,870 should match the accounts payable balance on the balance sheet and in the general ledger. If it does not, something is posted incorrectly.
2. Look at the distribution. 52% current is reasonable, but 23% is already past due. That suggests payments are slipping.
3. Investigate the oldest items. The $1,800 Signage Studio bill is over 90 days. The owner finds the sign was installed with the wrong colors and the bill is on hold pending a credit note. It should be flagged as disputed.
4. Check for duplicates. Equipment Lease has $850 in two buckets. That is two monthly payments, but confirm the earlier one was not paid and simply not recorded. See how to prevent duplicate invoice payments.
5. Compare with cash. If the bank has $6,000 and AR due this week is $4,000, the owner can clear the 1-30 and 31-60 buckets now and schedule current bills by due date.

How to create an AP aging report: step by step

1. Record every bill. Enter each supplier invoice with invoice number, date, due date and amount as soon as it arrives. Our accounts payable process guide covers approval and matching steps.
2. Record payments and credits. Apply each payment and credit note to the correct bill.
3. Choose the aging basis. Due date for payment planning, invoice date for supplier analysis.
4. Run the report. In QuickBooks, Xero, Zoho Books, Wave and similar software, look for "A/P Aging Summary" or "Aged Payables."
5. In a spreadsheet: add a column for days past due (today minus due date), then use IF formulas to place each amount in a bucket and a pivot table to total by supplier.
6. Reconcile to the ledger. The report total should equal the AP balance.
7. Review and act. Decide what to pay, what to query and what to correct.

How to use the AP aging report to manage cash

• Plan payment runs. Pay by due date, not by arrival date, to hold cash longer without paying late.
• Capture early payment discounts. Terms like 2/10 net 30 are worth about 37% annualized; paying early often beats keeping the cash.
• Prioritize critical suppliers. Pay those who could stop supply or charge penalties first.
• Negotiate early. If you cannot pay, contact the supplier before the bill hits 60 days and agree a plan.
• Match with receivables. Compare AP due dates with expected customer payments. If customers are slow, tighten your own invoice payment terms and invoice promptly with a free invoice generator.
• Track trends. Use the accounts payable turnover ratio and other AP KPIs to see whether you are paying faster or slower over time.

AP aging summary vs AP aging detail

Most accounting software offers two versions of the report.

Report	Shows	Use it for
AP aging summary	One line per supplier with totals in each bucket	Quick overview, month-end review, sharing with a lender
AP aging detail	Every open bill with number, date, due date and balance	Payment runs, investigating old items, finding duplicates

Here is the detail behind the Paper Supply Co. line in the example above:

Bill no.	Invoice date	Terms	Due date	Days past due	Open balance
PS-4471	Sep 15	Net 30	Oct 15	16	$1,450
PS-4532	Oct 10	Net 30	Nov 9	Current	$1,700
PS-4560	Oct 24	Net 30	Nov 23	Current	$1,500
Total Paper Supply Co.					$4,650

The detail view shows only one bill is late, and by 16 days. The owner pays PS-4471 this week and schedules the other two for their due dates.

Is paying early worth it? Early payment discount math

Suppose Ink Wholesale offers 2/10 net 30 on a $1,100 bill. Paying within 10 days saves $22. You give up 20 days of cash use to save 2%, which works out to about 2/98 times 365/20, or roughly 37% a year. Unless your cash is needed for something urgent, or you would have to borrow at a higher rate to pay early, taking the discount usually makes sense. The aging report helps you spot bills with discount terms in the current bucket before the window closes.

What is a good accounts payable aging profile?

There is no universal target, but these signals help you judge your report:

Signal	Healthy	Warning
Share of balance current	Most of the balance	Less than half
Balance over 60 days	Little or none, only known disputes	Growing month after month
Number of suppliers past due	One or two, briefly	Many, including critical suppliers
Supplier reaction	Normal credit terms	Credit holds, demands for cash on delivery
Report vs ledger	Matches every month	Unexplained differences

A worsening profile is often a symptom of slow customer payments rather than overspending. If your own customers pay late, your payables age too. Compare the AP aging report with your AR aging report side by side, and track days sales outstanding alongside days payable outstanding. The difference between how fast you collect and how fast you pay drives your cash conversion cycle.

How to talk to a supplier when you are behind

If the report shows bills you cannot pay on time, contact the supplier before they chase you. Explain the situation briefly, propose a specific schedule (for example, three weekly payments), and confirm it in writing. Most suppliers prefer a reliable plan to silence. Then keep to it; a broken promise damages the relationship far more than the original delay.

AP aging report checklist for month end

1. Enter all supplier bills received this month, including those still in email.
2. Match bills to purchase orders and delivery notes (the three-way match).
3. Apply all payments and credit notes to the correct bills.
4. Run the AP aging summary and compare the total with the AP balance in the ledger and on the balance sheet.
5. Review every item over 60 days and note the reason (dispute, cash timing, error).
6. Check for duplicate supplier names and duplicate invoice numbers.
7. Plan next month's payment runs based on due dates and expected receipts.

Internal controls that keep the report accurate

• Separate duties: the person who enters bills should not be the only one approving payments.
• Use an approval workflow: see our guide to invoice approval workflows.
• Require invoice numbers: reject bills without a unique number; it is the simplest duplicate check.
• Verify bank detail changes: call the supplier on a known number before changing payment details, as fake "new bank account" emails are a common fraud.

Common AP aging report mistakes

• Bills not entered. Invoices sitting in an inbox do not appear, so the report understates what you owe.
• Payments not applied. A payment recorded on account but not matched to a bill leaves the bill showing as overdue.
• Ignoring disputed items. Old disputed bills distort the picture. Note them and resolve them.
• Mixing up dates. Entering the receipt date instead of the invoice date shifts bills into the wrong buckets.
• Never reconciling. If the report does not match the ledger, decisions are made on wrong numbers.
• Paying everything early. Paying a net 30 bill on day 2 without a discount reduces your cash buffer for no benefit.

Finally, avoid deleting or voiding old bills just to make the report look cleaner. If a bill is genuinely not owed, record a credit note or adjustment with a reason, so there is an audit trail your accountant and any lender can follow.

AP aging and your working capital

Accounts payable is part of working capital, and the aging report shows how much short-term pressure you face. Paired with your AR aging report and a cash flow forecast, it tells you whether you can meet obligations over the next month. Supplier bills that you receive should look professional too; if you sell to other businesses, make sure your own invoices include clear due dates and terms, which you can set in our invoice templates.

Review your accounts payable aging report weekly or before every payment run, investigate anything over 60 days and reconcile it to the ledger each month. And when you bill your own customers, our invoice generator is free, requires no sign-up and creates a downloadable PDF in your browser, so your receivables move as smoothly as your payables.