You have $23,000 in the checking account, a quiet week ahead, and a nagging feeling you are forgetting a bill. Then the email arrives: your packaging supplier is putting your account on hold over an invoice from eleven weeks ago — one that slipped past you while you were paying the bills that shouted loudest. The accounts payable aging report exists so this never happens to you. It is a single page that sorts every unpaid bill you owe by how long it has been sitting there, and learning to read it takes about ten minutes.
What an AP Aging Report Actually Is
Accounts payable is the total of your short-term obligations to suppliers for goods and services bought on credit. If you do not pay within the agreed terms, the payable is in default — which can trigger late fees, interest, or the supplier cutting off your credit. The aging report is simply that total broken down by age: each vendor, each open invoice, its due date, and the amount owed, grouped into time buckets.
Most accounting systems use the same standard buckets:
- Current — invoices not yet due under their payment terms
- 1–30 days past due
- 31–60 days past due
- 61–90 days past due
- Over 90 days past due
Each row shows the vendor name, invoice number, due date, and amount. The report answers two questions at a glance: how much do I owe in total, and how much of it is already late? The total across all buckets should equal — accountants say "foot to" — the accounts payable balance on your balance sheet. If it does not, something is wrong in the books, which we will come back to.
One important distinction: this is the mirror image of the accounts receivable aging report, which tracks money customers owe you. The AR report drives collections; the AP report drives payments. Businesses that watch only one side get surprised by the other. Your customers paying late and your suppliers demanding payment on time is exactly the squeeze that kills cash flow at profitable companies.
What Each Bucket Is Telling You
The buckets are not just sorting bins. Each one carries a different message and demands a different action.
Current: your upcoming cash needs
The Current column is your short-term cash forecast. These invoices are not due yet, but they will be — usually within 30 days. Add this column up and you know roughly how much cash needs to stay in the account rather than going to inventory, equipment, or an owner's draw. A Current balance that keeps growing faster than revenue means you are buying faster than you are selling, and a cash crunch is forming weeks before it arrives.
1–30 days past due: pay these first
A week or two late is common and usually harmless — checks in the mail, approval bottlenecks, a bookkeeper on vacation. But this bucket is where late fees are born. Many vendor agreements start charging interest or flat late fees at 30 days past the due date, so every invoice here has a quiet deadline. When cash is tight, pay this bucket in order of consequence: first the vendors who will cut you off or charge penalties, then everyone else.
Also watch the trend. A 1–30 day bucket that was $4,000 last month and is $18,000 this month means your payment process is slipping, not just one invoice. Something changed — find it before the invoices slide into the next bucket.
31–60 days past due: relationships are fraying
At this age, vendors notice. You may already be getting reminder calls, and some suppliers start holding shipments for accounts 45 or 60 days out. Ask yourself why each invoice is here. Valid reasons exist — you are disputing a short shipment, waiting on a credit memo, holding retention on a job. But "we just haven't gotten to it" is not a strategy; it is how small businesses end up paying rush fees and losing early-payment discounts they never knew they had.
61–90 days past due: damage control
Invoices this old signal one of three things: a genuine dispute, a broken payment process, or a business that cannot pay its bills. Vendors at this stage may report you to business credit bureaus, which drags down scores that lenders check before approving loans and lines of credit. Your business credit score is built in large part on exactly this payment behavior, so a fat 61–90 bucket is borrowing trouble at higher interest later.
Treat every invoice here as an exception that needs a name, a reason, and a resolution date — in writing. If it is a dispute, document it. If it is a cash problem, call the vendor before they call you; suppliers will often accept a payment plan from a customer who communicates, and almost never from one who goes silent.
Over 90 days: investigate, do not just pay
The oldest bucket is where errors hide. An invoice sitting unpaid for four months might be a bill you genuinely owe — or it might be a duplicate entry, an invoice already paid by a different method, a credit memo never applied, or a charge for goods you returned. Paying it without checking can mean paying twice. Review every line over 90 days individually: confirm the goods or services were received, confirm no payment or credit already covers it, then either pay it immediately or clear the error from your books.
Reconcile the Report to Your Balance Sheet
Here is the control that separates clean books from fiction: the total of the aging report must equal the accounts payable balance on your general ledger. Run both numbers at month-end. When they disagree — and periodically they will — the difference almost always traces to one of a few causes:
- Timing differences. A bill entered in the subledger but dated in the next period, or a payment recorded on one side but not the other.
- Unapplied vendor credits. A credit memo sitting unmatched to any invoice inflates what you appear to owe.
- Journal entries posted directly to the AP control account. A manual adjustment that bypasses the vendor subledger breaks the tie-out by design.
- Stale or invalid aged items. Invoices that were never real obligations — duplicates, voided bills never removed — lingering in the oldest buckets.
Reconciling monthly catches fraud as well as error. Fake-vendor schemes and altered payables both show up as aging entries that cannot be tied to real receiving documents. If nobody reconciles, nobody notices.
Turn the Report Into One Number: Days Payable Outstanding
The aging report is a snapshot; days payable outstanding (DPO) is the trend. DPO measures the average number of days you take to pay suppliers:
DPO = (Average Accounts Payable / Cost of Goods Sold) × 365
A DPO of 30 means you pay suppliers in about a month on average. A rising DPO means you are stretching payments further — which preserves cash in the short run but strains vendor relationships and can signal financial distress if it climbs far past your actual terms. A falling DPO means faster payments, which may mean you are leaving money on the table by paying Net 30 invoices on day five with no discount for it.
Track DPO alongside its siblings: days sales outstanding (how fast customers pay you) and days inventory outstanding (how long stock sits). Together they form the cash conversion cycle, the number of days your cash is tied up between paying suppliers and collecting from customers. The AP aging report is where you manage your third of that cycle.
Decode the Payment Terms on Your Invoices
You cannot prioritize the buckets without understanding the terms printed on the invoices inside them. The common ones:
- Net 30 / Net 60 / Net 90. Full payment due 30, 60, or 90 calendar days after the invoice date (or sometimes after delivery — check the contract). Net 30 is the most common B2B default.
- 2/10 Net 30. Take a 2% discount if you pay within 10 days; otherwise the full amount is due in 30 days. Similar offers like 1/10 Net 30 or 3/15 Net 45 work the same way.
- Due on receipt. Pay immediately. Common for first orders and small jobs.
The discount terms deserve a second look because most owners misjudge them badly. Skipping a 2/10 Net 30 discount to hold cash for 20 extra days is equivalent to borrowing at roughly 36% annualized interest — far more than any line of credit charges. Unless your cost of capital is genuinely higher than that, or cash is so tight that payroll is at risk, the discount is almost always the better deal. The AP aging report is how you spot discount deadlines before they expire: sort the Current bucket by due date and pay the discounted invoices first.
A Weekly AP Routine That Takes 20 Minutes
A report you never open is decoration. Put this on the calendar every week, ideally on the same day you run payroll or review the bank balance:
- Print the aging report sorted by due date. Look at the totals row first: Current, each past-due bucket, and the grand total. Compare each bucket to last week — movement matters more than levels.
- Clear anything newly past due. For each invoice that slid out of Current, decide today: pay it, dispute it in writing, or schedule it with a date. Nothing sits undecided.
- Harvest discounts. Scan the Current bucket for invoices with early-payment discounts expiring in the next seven days. Pay the ones where the discount beats your cost of capital.
- Age the exceptions. Every invoice over 60 days gets a written status: who owns it, why it is unpaid, and when it resolves. No status, no excuse — pay it.
- Tie out monthly. At month-end, confirm the aging total matches the AP balance on the balance sheet before you close the books.
This routine also protects you from the two classic AP failures: the duplicate payment (the same invoice paid twice because nobody checked whether it was already on the report) and the phantom balance (an old entry everyone assumes someone else verified). Both are caught by a human reading the report with fresh eyes, which is exactly what software alone never does.
Common Mistakes That Bloat the Buckets
- Paying whoever calls loudest. Squeaky-wheel payments leave quiet vendors aging into late fees and credit holds. Pay by due date and consequence, not by volume of reminders.
- Paying everything immediately. Rushing every invoice out the door feels responsible, but paying a Net 30 bill on day two with no discount donates three-plus weeks of float to your vendor. Schedule payments for their due dates and keep the cash working for you until then.
- Letting one person run the whole cycle. The person who enters bills should not be the only one who approves and pays them. Even in a two-person office, the owner reviewing the aging report before payments go out is a real control.
- Ignoring small balances. A $180 invoice in the 90-day bucket looks trivial — until the vendor sends it to collections and it lands on your business credit file. Clear small stale items ruthlessly.
- Never negotiating terms. If your customers pay you on Net 60 but your suppliers demand Net 15, the mismatch funds itself out of your pocket. Suppliers grant longer terms more often than owners expect, especially to customers with a clean payment history — which the aging report proves.
Keep Your Bills — and Your Cash — Under Control
Every dollar in the 60-day bucket is a dollar of trust you are spending with a supplier; every discount deadline you miss is a dollar of profit you donated for nothing. The AP aging report turns both from invisible leaks into a one-page action list. Run it weekly, reconcile it monthly, and pay by strategy instead of by noise — your vendors, your credit score, and your future self at tax time will all thank you.
Clean payables records compound, too. When every bill is entered once, matched to its payment, and tied to the general ledger, your books tell the truth about cash flow instead of a hopeful story. Beancount.io gives you plain-text accounting with complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.
