An AP aging report is a list of everything your business owes its suppliers, grouped by how long each invoice has been outstanding, so you can see at a glance what is due now and what is already overdue. AP stands for accounts payable. The report sorts unpaid bills into age buckets, typically current, 1 to 30 days, 31 to 60, 61 to 90, and 90 plus. It is also called an accounts payable aging report or an aged payables report.
It is the payables mirror image of an AR aging report. Where the AR version shows money owed to you, the AP version shows money you owe out. Finance teams use it to schedule payments, protect supplier relationships, and avoid late fees, all while holding onto cash as long as sensibly possible. For a small business, it is one of the simplest reports to run and one of the most revealing, because the shape of the buckets tells you in seconds whether you are on top of supplier payments or quietly falling behind.
What you owe, by age.Supplier bills sorted into buckets like current, 30, 60 and 90 plus days.
The opposite of AR aging.AP aging is money going out; AR aging is money coming in.
It drives payment timing.Use it to pay on time, keep suppliers happy and manage cash.
Each row is a supplier, and each column is an age bucket showing how much of their balance falls into it. The total column is what you owe that supplier in full; the bucket columns tell you how urgent it is. Here is a simple example.
| Supplier | Current | 1 to 30 | 31 to 60 | 61 to 90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Northwind Supplies | 4,200 | 0 | 0 | 0 | 0 | 4,200 |
| Acme Logistics | 1,500 | 2,000 | 0 | 0 | 0 | 3,500 |
| Brightline Print | 0 | 900 | 1,100 | 0 | 0 | 2,000 |
| Delta Hardware | 0 | 0 | 0 | 650 | 1,400 | 2,050 |
| Total payable | 5,700 | 2,900 | 1,100 | 650 | 1,400 | 11,750 |
Example only. Figures rounded for illustration.
Read it from right to left: start with the total you owe, then look at how much sits in the older buckets, because anything past current is at risk of a late fee or a strained supplier. In the example above, you owe 11,750 in total. Most of it (5,700) is current and not yet due, which is healthy. But Delta Hardware has 1,400 sitting in the 90 plus column, the danger zone. That is the row to act on first: it is the most overdue, most likely to trigger a late charge, and most likely to put a useful supplier offside.
The skill is balancing two opposing goals. You want to hold cash as long as possible, so you do not pay early for no reason. But you do not want bills aging into the late buckets, because that costs you fees and goodwill. A clean AP aging report has most of its value in the current and 1 to 30 columns and very little beyond 60 days. A report with a fat 90 plus column is a sign that payments are slipping, which often points to a cash-flow problem worth investigating with a cash flow forecast. It is also worth checking the buckets against each supplier's actual terms. A balance sitting in the 1 to 30 column is not late if that supplier is on net 30, so the buckets show age, not necessarily lateness, until you line them up against the terms you agreed.
An AP aging report shows what your business owes suppliers, grouped by age; an AR aging report shows what customers owe your business, grouped by age. One tracks money going out, the other money coming in. They are built the same way, with the same buckets, but they answer opposite questions. Your AP aging tells you whether you are paying suppliers on time. Your AR aging analysis tells you whether your customers are paying you on time. Read together they show your cash timing: if your receivables age slower than your payables, cash gets tight, because money is going out before it is coming in.
This is exactly why the two reports are most powerful side by side. If customers routinely take 60 days to pay you while suppliers expect payment in 30, you are funding that 30 day gap out of your own pocket. The fix usually lies on the AR side, by collecting faster, rather than stretching suppliers and damaging those relationships.
Finance teams run it at least monthly, and often weekly, as the basis for a payment run. It answers three practical questions that decide who gets paid in each cycle.
Which suppliers sit in the overdue buckets and need paying immediately to avoid a late fee or a strained relationship.
Which balances are still current, so payment can sensibly be held a little longer without any harm.
Whether the total you owe is trending higher over time, a sign the payment cycle is stretching.
It also feeds key metrics. The report is the raw material behind days payable outstanding, which measures the average time you take to pay suppliers, and you can estimate that figure with the days payable outstanding calculator. In Xero or QuickBooks, the AP aging report (sometimes labelled aged payables) is a standard report you can run on demand, broken down by supplier and bucket. The numbers are only as good as your bookkeeping, though: bills entered late or with the wrong date will land in the wrong bucket and distort the picture. The same discipline that keeps your accounts payable tidy keeps the aging report trustworthy.
A healthy AP aging report is weighted toward the current and 1 to 30 day columns; once meaningful balances appear in the 60 and 90 plus buckets, the report is telling you something is wrong. The catch is that several different problems look identical on the report, a balance stuck in an old bucket, yet each needs a different fix.
Not enough cashThe most common culprit: a liquidity problem rather than an admin one, where bills cannot be paid on time.
Disputed invoicesA bill nobody has resolved, sitting unpaid in an old bucket while the disagreement drags on.
Bills lost in approvalAn invoice stuck in an approval queue, never signed off and never scheduled for payment.
Duplicate entriesDouble-entered bills that were never cleaned up, inflating what the report says you owe.
Watching the report over several months matters more than any single snapshot. If the older buckets are slowly fattening, your payment cycle is stretching, and that trend usually traces back to the other side of the ledger. When customers pay you slowly, you pay suppliers slowly in turn. That is why the most effective lever is often not on the payables side at all: collecting receivables faster with AR insights and reporting frees the cash to keep your own payables current, which protects supplier terms and your credit standing.
Don't let these critical mistakes hurt your
collections - See how to fix them, today!
Request an AI summary of Paidnice
