Accounts Payable Aging Explained
An accounts payable aging report is a simple list of the bills you owe, grouped by how long they have been waiting. It sounds dull, but it is one of the most useful pages in your bookkeeping. It shows which suppliers you need to pay this week, which bills are slipping past their due dates and whether your payment habits are quietly damaging relationships you depend on.
Key takeaways
- An accounts payable (AP) aging report groups unpaid supplier bills into time buckets, usually current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due.
- It helps you plan payments, protect supplier relationships and spot errors such as duplicate or disputed bills.
- Review it weekly or every two weeks, and more often during busy seasons when bills pile up.
- Old balances are not always unpaid debts; some are errors, credits or disputes that need cleaning up.
If you have ever been surprised by a supplier putting your account on hold, or found the same invoice paid twice, you already know why AP aging matters. Most small businesses track what customers owe them quite carefully. What they owe others tends to live in an inbox, a pile on the desk or a vague mental note.
As the year heads into its final quarter, that vagueness gets expensive. Seasonal stock orders, year-end service invoices and annual renewals all land around the same time. A clear aging report helps you decide what to pay, when and in what order, so you finish the year with tidy books and suppliers who are happy to work with you again.
What accounts payable aging means
Accounts payable is the money your business owes to suppliers and service providers for things you have already received but not yet paid for. Every unpaid supplier bill sits in AP until you pay it.
Aging simply means sorting those bills by how old they are. Most reports measure age from the bill's due date, though some use the invoice date. The result is a table showing, for each supplier, how much is not yet due and how much is overdue by different amounts of time.
The usual aging buckets
- Current: bills that are not yet due.
- 1 to 30 days past due: recently overdue, often just a timing slip.
- 31 to 60 days past due: getting uncomfortable; the supplier has probably noticed.
- 61 to 90 days past due: a problem worth a phone call.
- Over 90 days past due: either a serious overdue balance or something that needs investigating, such as a dispute or an error.
Pro tip
Check whether your report ages bills from the invoice date or the due date. A bill with 30-day terms looks "31 to 60 days old" on an invoice-date report even when it is only just due. Due-date aging is usually easier to act on.
AP aging vs AR aging
Accounts receivable (AR) aging is the mirror image: it lists what customers owe you. AR aging tells you who to chase; AP aging tells you who you owe. Looking at both side by side shows whether money is coming in fast enough to cover what needs to go out. (A related ratio, AP turnover, measures how quickly you pay on average, but the aging report is the practical, bill-by-bill view.)
How to read an AP aging report
Most accounting software can produce an aging report in a couple of clicks, usually under a payables or bills section. If you keep bills in a spreadsheet, you can build one yourself with the template below. Either way, read it in the same order each time.
- Look at the total first. How much do you owe in total, and how does it compare with last month?
- Check the overdue columns. Anything past due needs a decision: pay it, schedule it or query it.
- Scan the oldest bucket closely. Balances over 90 days are often errors, disputes or forgotten credits rather than real debts.
- Look at concentration. Is one supplier a large share of what you owe? That relationship needs extra care.
- Compare with your cash. Can you cover current and soon-due bills from cash on hand and expected receipts?
A copyable AP aging template
Use these columns in a spreadsheet. The suppliers and amounts below are made-up examples.
| Supplier | Current | 1 to 30 days | 31 to 60 days | 61 to 90 days | Over 90 days | Total owed | Action |
|---|---|---|---|---|---|---|---|
| Packaging supplier (example) | $1,400 | $650 | $0 | $0 | $0 | $2,050 | Pay overdue amount this week |
| Wholesale stock supplier (example) | $3,200 | $0 | $1,100 | $0 | $0 | $4,300 | Call to agree a payment date |
| Equipment repair firm (example) | $0 | $0 | $0 | $0 | $380 | $380 | Check: disputed invoice? |
Add a "Notes" column for disputes, agreed payment plans and credits you are waiting for. Those notes save a lot of head-scratching later.
Example
Lena runs a small print studio. Her aging report shows $380 owed to a repair firm for over 90 days. She assumes it is a forgotten bill and nearly pays it. Instead she checks her notes and emails: the repair was redone under warranty, and the firm had promised a credit note that never arrived. One polite email later, the credit is issued and the balance clears. Her report is now accurate, and she did not pay for the same repair twice. (Names and figures are a made-up example.)
Why AP aging matters for small businesses
An aging report is not just a bookkeeping chore. It shapes your cash, your supplier relationships and the accuracy of your accounts.
Cash planning
Knowing exactly what is due in the next two to four weeks makes your cash forecast much more reliable. It also helps you spot weeks when several big bills land together, so you can spread payments or arrange funds in advance.
Supplier trust
Suppliers notice who pays on time. Reliable payers often get better terms, priority stock in busy seasons and more flexibility when they really need it. Persistent late payment can lead to credit holds, stricter terms or requests for payment upfront. Some places also have rules or codes about paying suppliers on time, so check what applies to you.
Accurate books
Old balances that never clear can make your accounts look worse (or better) than reality. Duplicate bills, unrecorded credits and invoices entered twice all show up as odd entries in the aging report. Cleaning them up keeps your balance sheet honest, which matters for lenders, investors and your year-end accounts.
Common mistake
Paying the loudest supplier first. The one who calls most often is not always the most important. Prioritize based on due dates, the importance of the supply to your business and any late payment terms in your agreements, not on who sends the most reminders.
Building a payment plan from your aging report
Once you can see everything you owe, turn it into a simple payment schedule. This is where the report starts saving you money and stress.
Set your payment priorities
- Essentials first. Payroll, rent, utilities, taxes and any supplier you cannot operate without.
- Overdue bills with late fees or interest. Check your agreements; these cost you more the longer they wait.
- Bills due this week. Pay on the due date, not later, to keep your reputation strong.
- Early payment discounts. If a supplier offers a discount for paying early and you have the cash, it can be worth taking. Compare it with your other cash needs first.
- Everything else on its due date. There is usually no reason to pay much earlier unless you get something for it.
Use payment runs
Many small businesses pay bills once or twice a week in a "payment run" rather than one at a time. You review the aging report, choose what to pay, approve it and send the payments together. It saves time, reduces the risk of paying the same bill twice and gives you a regular moment to check your cash.
Pro tip
If you cannot pay a bill on time, tell the supplier before the due date, not after. Offer a specific date or a short payment plan. Most suppliers would much rather hear from you early than chase you later, and they remember who was honest.
Cleaning up old and odd balances
Before year-end is a great time to tidy the oldest buckets in your report. Many of those balances are not real debts at all. Work through each one and decide what it is.
- Duplicate bills: the same invoice entered twice. Remove or void the duplicate in your records.
- Missing credit notes: a return, refund or discount that the supplier agreed but never documented. Ask for the credit note.
- Disputed invoices: work you have challenged. Record the dispute and follow up until it is resolved.
- Unapplied payments: money you paid that was not matched to the bill. Match it in your software.
- Supplier statement differences: request a supplier statement and compare it with your records line by line.
Do not simply delete old balances to make the report look clean. Each one should be resolved with a clear reason and, where needed, a document. If you are unsure how to record a correction, ask your bookkeeper or accountant. This article is general information, not accounting or legal advice.
Your AP aging action plan
- Run an AP aging report from your accounting software or spreadsheet
- Confirm whether it ages from invoice date or due date
- Note every balance in the 31 days and older buckets
- Investigate anything over 90 days for errors, credits or disputes
- Request statements from your biggest suppliers and reconcile them
- Set one or two weekly payment runs
- Contact any supplier you will pay late, before the due date
- Review the report alongside your cash forecast every week through year-end
Frequently asked questions
How often should I review my AP aging report?
Weekly is a good habit for most small businesses, and at least every two weeks for very small ones. During busy seasons or tight cash periods, check it before every payment run.
Is it bad to have bills in the overdue columns?
A few recent, small overdue bills are common and often just timing. Large or growing balances in the older buckets are a warning sign, either of cash pressure or of errors in your records. Both are worth fixing quickly.
Should I always pay as late as possible to keep cash?
Paying on the due date is a fair way to manage cash. Paying after the due date regularly can cost you fees, goodwill and better terms. Aim to be reliable rather than slow.
Do I need accounting software to track AP aging?
No. A spreadsheet with supplier, invoice date, due date, amount and status works for a small number of bills. Accounting software saves time as volume grows. Check current features and pricing before choosing one.
Related reading
The bottom line
An accounts payable aging report turns a vague sense of "we owe some people" into a clear picture of who, how much and how late. Read it in the same order each week, pay essentials and due bills on time, talk to suppliers early when you need more time and clean up the odd old balances before year-end.
Run your first aging report today and spend half an hour with it. You will likely find at least one bill to query, one supplier to thank with an on-time payment and a much calmer view of your cash for the months ahead.
