An accounts payable aging report lists every unpaid supplier invoice you hold, sorted by how long it has been outstanding. The conventional columns are 0-30, 31-60, 61-90 and over 90 days. Its job is to tell you which invoices are overdue and which to pay next. Run weekly, it is the control on cash leaving the business, in the same way an AR aging report is the control on cash coming in — the split between the two ledgers is set out in accounts payable vs receivable.
Download the AP aging report template. No email required. Paste your open bills into the invoice-level sheet; the report buckets them by days overdue and totals them by supplier.
What the report actually contains
The report is a snapshot of your open payables ledger at a point in time. Most systems produce one row per unpaid invoice, or one row per supplier with invoices summed across the age columns.
- Supplier name and invoice number
- Invoice date and due date, which are not the same thing
- Amount still outstanding
- The age bucket the invoice falls into
- A total per supplier and a total per bucket
The sum of all buckets should tie to the accounts payable balance on your balance sheet. If it does not tie, the report is wrong before anyone reads it. That reconciliation is the first check, not an afterthought. It belongs in your month-end close checklist.
How to read the buckets
| Bucket | Normal reading | What to do about it |
|---|---|---|
| 0-30 days | Current supplier invoices in the ordinary run of business | Confirm each invoice's actual due date before assuming it is not yet payable |
| 31-60 days | Either slightly late on net 30, or still current on net 45 or net 60 | Split the column by terms; a net 30 invoice sitting here is late |
| 61-90 days | Late under almost any standard commercial terms | Find out whether it is a dispute, a missing approval, or a deliberate cash decision |
| Over 90 days | A broken process, or a supplier you have effectively stopped paying | Resolve or write off; duplicates and stale credits hide in this column |
Concentration matters as much as age. One supplier holding 60% of the over-90 column is a relationship problem heading for a stop-supply notice. Twenty suppliers each holding a small slice is a workflow problem, and it is almost always approvals.
The trap: the buckets assume 30-day terms
The standard layout assumes every invoice is due 30 days after it is issued. Real invoices are not. Some are due on receipt, some at 45 or 60 days, some anywhere in between. Two consequences follow, and they run in opposite directions.
An invoice in the 0-30 column on net 15 terms can already be late. An invoice in the 31-60 column on net 60 terms can be perfectly current. Sort by due date as well as by age, and carry the payment term on every row. Otherwise the report misleads you twice: it hides genuine lateness and manufactures lateness that does not exist. This is the single biggest misreading trap on the AP side, and it has no equivalent on the receivables side, where you set the terms yourself.
For a reference point on what net 30 means in practice, US federal agencies default to paying 30 days after the payment period starts when the contract is silent (5 CFR 1315.4). Most commercial terms sit near that default. Yours are whatever you signed.
Days payable outstanding: the number the report feeds
Days payable outstanding is the efficiency ratio built on top of the aging report. It is the average number of days a company takes to pay its suppliers. The formula is ending accounts payable divided by purchases per day, where purchases per day is annual cost of goods sold divided by 365.
Compute it monthly, next to the aging report, not instead of it. The aging report tells you which invoices are old. DPO tells you whether the whole payables book is drifting.
Read that 59-day figure carefully. It covers the top 1,000 US public non-financial companies. It is not a target for a 40-person company. Large buyers hold leverage a fast-growing private business does not have. Treat it as context for the range, not as a number to hit.
Discipline or distress?
A high DPO is genuinely ambiguous. It can reflect strong bargaining power with suppliers. It can equally reflect payment delays and cash strain. The ratio alone cannot tell you which one you are looking at. The aging report can, because the two leave different shapes.
- Discipline: a thin over-90 column, invoices paid on their stated due date, longer terms negotiated up front and then honoured
- Distress: a fat over-90 column, payment runs skipped, the same suppliers rolling forward month after month
- Discipline: terms are the same for every invoice from a given supplier
- Distress: terms are whatever cash allowed that week
One more tell. If DPO rose while the over-90 bucket stayed flat, you renegotiated terms. If DPO rose because the over-90 bucket grew, you are simply paying late and calling it working capital management.
Where AP aging sits in the cash conversion cycle
The cash conversion cycle measures how long money invested in inventory takes to come back as cash. The formula is DIO plus DSO minus DPO. A shorter cycle is generally better, and paying suppliers is one of its three levers alongside selling inventory and collecting from customers.
DPO enters as a subtraction, which is exactly where the trap sits. You can shorten the cycle by taking longer to pay, without selling faster or collecting faster. The operating business has not improved. Only the timing has. If you are using the cycle to judge whether operations are getting better, watch the three components separately, and read working capital and free cash flow alongside it.
Paying early for a discount: the arithmetic
Suppliers offer early-payment discounts. Whether to take one is an interest rate question, not a savings question. You are lending the supplier money for a fixed period and collecting the discount as interest.
The US government uses a fixed decision rule for this, and it is a good one. Convert the discount to an effective annual rate, then compare it against Treasury's Current Value of Funds Rate. If the converted rate is larger, take the discount and pay early. If it is smaller, decline it and pay as close to the due date as possible (Treasury, Prompt Payment discount calculator). The standard conversion is the discount percentage divided by 100 minus that percentage, multiplied by 360, divided by the number of days between the discount date and the due date.
| Terms | Days of cash given up | Effective annual rate | Versus 4.00% CVFR |
|---|---|---|---|
| 2/10 net 30 | 20 | 36.7% | Take it |
| 1/10 net 30 | 20 | 18.2% | Take it |
| 0.5/10 net 30 | 20 | 9.0% | Take it |
| 0.25/10 net 30 | 20 | 4.5% | Clears 4.00% by half a point; take it when cash is comfortable, skip it when it is not |
| 0.5/10 net 60 | 50 | 3.6% | Skip it and hold the cash |
Treasury set the Current Value of Funds Rate at 4.00% for calendar 2026, down from 5.00% for 2025 (fiscal.treasury.gov). The rate exists for exactly this kind of judgement, including cash discounts. Substitute your own cost of funds if it is higher. A revolver at 11% moves three rows of that table from take to skip. The method survives the substitution; only the threshold changes.
0.5% in 10 days, net 30, gives up 20 days of cash. 0.5 divided by 99.5, multiplied by 360, divided by 20, is 9.0% effective annual. Against the 4.00% Current Value of Funds Rate for 2026, take it. Against a revolver at 11%, skip it.
Pay early, but not earlier than you must
If you take a discount, pay as close as possible to the discount date without passing it. Paying on day three of a ten-day window gives away seven days of cash for nothing. The federal rule states it directly: when a discount is taken, payment is made as close as possible to, but no later than, the discount date (5 CFR 1315.7).
Do not claim a discount you did not earn. Under the same rule, taking a discount after the discount date triggers an interest penalty. The commercial equivalent is a supplier chasing a short payment and a reconciliation mess in your AP ledger for the next three months. If you miss the window, pay the full amount on the due date.
If you decline the discount, the invoice reverts to its normal due date (fiscal.treasury.gov, Prompt Payment discounts). Those are the only two branches. There is no third option where you keep the cash and the discount.
What the report does not show: the supplier's side
Stretching payables moves cash from your supplier's balance sheet onto yours. The aging report shows your half of that transfer and nothing else. The supplier's half is real, and it is measurable.
In 2011 the federal QuickPay reform began paying small contractors roughly 15 days sooner, across about $64 billion of annual contract value. Jean-Noel Barrot and Ramana Nanda found payroll at those suppliers rose about 10 cents for every accelerated dollar, two thirds of it from new hires (NBER Working Paper 22420). They put the direct effect at roughly $6 billion of additional annual payroll and just over 75,000 jobs over the three years following the reform. They also document substantial crowding out of hiring at firms the reform did not touch, so the net effect on aggregate employment was far smaller, and close to zero where unemployment was already low. The supplier-level effect is the part that matters here, and the authors frame it explicitly as a cash conversion cycle intervention.
Their working-capital arithmetic is the mirror image of yours. A supplier with $1 million of sales, paid 30 days after delivery, has about $80,000 of cash tied up in receivables at any moment. Shifting to 15-day payment permanently frees about $40,000 for them. When you extend terms instead, you take that amount back.
This is not an argument for paying everything early. It is an argument for knowing the cost sits outside the report. A small supplier stretched to 75 days may quote higher next year, deprioritise your work, or stop bidding. None of that appears in a bucket.
A long DPO can be manufactured
One further limit. A long DPO can be produced by a supplier finance programme rather than by negotiation. A bank pays your supplier early and you pay the bank later. Buyers in these programmes typically present the obligation in the same balance sheet line as accounts payable. FASB's ASU 2022-04 does not change that presentation. It requires you to disclose the programme's key terms, the amount outstanding, and where in the balance sheet those obligations sit.
So payables and DPO can both look healthy while the underlying obligation behaves more like borrowing. If you use supplier finance, carry it as its own line on the aging report and disclose it. Anyone reading your financials, including a lender, will want the split.
A routine that keeps the report honest
- Weekly: refresh the aging, sort by due date, and build the payment run from the next seven days of due dates rather than from the oldest column
- Weekly: review every invoice past 60 days and assign a reason code to each one — dispute, missing approval, missing goods receipt, or deliberate cash decision
- Monthly: tie the report total to the AP balance during the close, then compute DPO and compare it with the prior month
- Monthly: list every discount offered and every discount taken, with the effective annual rate, so the trade-off is recorded rather than assumed
The over-60 reason codes are the step most teams skip, and they are the step that turns the report from a list into a decision. A dispute and a cash decision look identical in a bucket. They require completely different actions.
Where Zinance fits
Zinance runs outsourced bookkeeping, tax and fractional-CFO work for US companies. On the payables side that means a clean ledger that ties to the balance sheet every month, an aging report carrying due dates and reason codes rather than four raw columns, and a DPO figure tracked over time instead of recalculated in a panic.
The mechanics sit in AR and AP services and bookkeeping. The judgement calls — which terms to renegotiate, which discounts clear your cost of funds, which suppliers you cannot afford to stretch — sit in fractional CFO. If you want to see how your own payables read, book a demo.