Accounts Payable Aging Report: What It Shows and How to Use It

An accounts payable aging report lists what you owe suppliers and how long each bill has been outstanding or when it falls due. It is the main tool for deciding which bills to pay, when to pay them and how much cash you need in the coming weeks. This guide shows how to read the report, how to turn it into a payment plan and cash forecast, and how to use it to spot problems. It builds on days payable outstanding and supports cash flow management.

What the report shows

A basic AP aging report shows, for each supplier, the amount owed in age buckets. The most useful version for cash management is a due-date view: it shows when each bill is due, not just how old it is.

Not yet due is $150,000 ($48,000 + $42,000 + $60,000), and past due is $40,000, which is 21.1 percent of the total. The balance of $190,000 should tie to the payables account in your ledger.

Reading the report

1. Start with the totals

• Total payables and how they compare with last month and with purchases. A rise may signal growth, or stretching.
• Past-due share. Past due items should be rare and explained. Here, 21 percent is high.
• The age of the oldest items. Anything over 60 days past due deserves immediate attention.

2. Look at each supplier

Supplier C has amounts in every bucket, including $3,000 more than 60 days past due. That suggests either disputes, missing approvals or a decision to stretch. Supplier A is entirely current, which is what you want from a key supplier.

3. Check for reasons behind past-due items

4. Reconcile

Tie the report total to the general ledger payables balance. Differences point to unrecorded invoices, unapplied payments or timing issues. A reliable report is the basis for decisions.

Turning the report into a payment plan

For the next two weeks, the report gives your commitments:

• Due in 0 to 7 days: $48,000
• Due in 8 to 14 days: $42,000
• Past due: $40,000
• Total to consider in the next 14 days: $130,000 ($48,000 + $42,000 + $40,000)

If the cash forecast shows $110,000 available over that period, there is a $20,000 gap to manage. Options include collecting a receivable early, delaying payments to suppliers who agree to it, or drawing on a credit line. Do not simply let the oldest items sit.

Prioritization when cash is tight

Rank payments by the consequence of delay.

Talk to suppliers in lower tiers before the due date and agree on dates. See should you pay suppliers early or late?.

Using the report in a weekly routine

1. Run the report by due date, with unapproved invoices flagged.
2. Review the payment run. Pay invoices on the last run before the due date, unless a discount applies.
3. Check past-due items and assign owners.
4. Compare to the cash forecast. Make sure the next two to four weeks of payments match the forecast.
5. Look for discounts. Identify invoices eligible for early-payment discounts and test the return. See 2/10 net 30 explained.
6. Look for unusual items: duplicates, round amounts, unfamiliar suppliers or changed bank details.
7. Update the forecast. Replace estimates with actual scheduled payments.

A weekly AP review agenda

A twenty-minute weekly meeting between the person who runs payments and the finance lead keeps the report useful.

1. Cash position: current balance and the forecast for the next four weeks.
2. Payments due this week and next: confirm amounts, dates and any early-pay discounts.
3. Past-due items: for each, the reason, the owner and the agreed date.
4. Disputes and credits: status, expected resolution and impact on cash.
5. Unapproved invoices: who holds them and when they will be approved.
6. Supplier issues: calls, holds or changes in terms.
7. Decisions: which invoices to pay in the next run, which to delay by agreement and what to escalate.

Record decisions and dates in a short note. Over a few months, the notes show which suppliers or processes cause repeated delay.

Handling disputes and credit notes

Disputed invoices often sit in the aging report for weeks. Treat them as a separate category.

• Pay the undisputed portion on time, and tell the supplier what is disputed and why.
• Set a resolution date and assign an owner, usually in purchasing or operations.
• Record the credit note when received so that the balance reduces correctly.
• Track dispute aging just like payables aging, since a disputed invoice that is wrong in the supplier's favor still becomes a cash payment if not resolved.

Clean handling of disputes keeps DPO meaningful and protects supplier relationships.

Forecasting outflows

For the existing payables, the report gives the exact amounts and due dates. For future purchases, use purchase orders and the expected payment terms. Combine them:

The first two weeks are fixed by existing bills; the later weeks depend on purchases not yet invoiced. Past-due amounts of $40,000 would be added to week 1 or spread by agreement. This table feeds the supplier payments line of the 13-week cash flow forecast.

Metrics to track from the report

Controls and fraud checks

The AP aging report is also a control tool. Look for:

• Duplicate invoices with the same number or amount.
• New suppliers with large invoices.
• Changes in bank details shortly before payment.
• Round-dollar invoices or invoices just under approval limits.
• Invoices without purchase orders where one is required.
• Unusual growth in payables to one supplier.

Verify bank detail changes by calling a known contact, not using details in the same email. Segregate duties among those who set up suppliers, approve invoices and release payments.

For product companies

Payables for inventory follow the purchasing plan, which follows the demand forecast. A sudden jump in payables may reflect a large buy ahead of a season, or an overbuy. Compare payables to the inventory plan and the days of cover. If payables for slow-moving items are rising, it may be time to adjust orders. See demand planning and inventory optimization.

Common mistakes

• Using the invoice date instead of the due date.
• Paying invoices as approved.
• Ignoring unapproved invoices, which become surprise liabilities.
• Not reconciling to the ledger.
• Letting past-due items age without contact.
• Not scheduling payments around cash.
• Skipping the fraud review.

Related guides

To improve your terms, see how to negotiate better supplier payment terms. For ways to finance supplier payments or extend terms safely, see supply chain finance.

FAQs

What is an accounts payable aging report?

It is a report that lists amounts owed to suppliers by age or due date, helping you plan payments and manage cash.

How do I use the AP aging report for cash planning?

Use the due-date view to total payments due in the next one to four weeks, compare with forecast cash and decide which to pay, delay or negotiate.

What is a good percentage of payables past due?

Ideally very low and explained. A rising share of past-due payables signals stretching or process problems. Track the trend.

How often should I review the AP aging report?

Weekly, before each payment run, with a monthly review of trends and DPO.

Should the AP aging report match the general ledger?

Yes. The total should reconcile to the payables account on the balance sheet. Differences indicate timing or recording errors.