The Accounts Payable Aging Report: Knowing What You Owe and When

The report that answers "what do we owe, and when?"

Most owners learn to watch their accounts receivable aging — the report of who owes them and how late. Far fewer regularly read its twin, the accounts payable aging report, which shows the other direction: who you owe, broken down by how overdue each bill is. That's a mistake, because the AP aging is one of the most useful planning tools a small business has. It tells you, at a glance, how much cash you'll need over the next few weeks and whether any vendor relationships are quietly going sour. (General education, not accounting advice.)

What an AP aging report is

An AP aging report lists every open vendor bill you have not yet paid, grouped into time buckets based on how long each has been outstanding relative to its due date. The standard layout looks a lot like the AR version, just pointed the other way:

• Current — bills not yet due.
• 1 to 30 days past due
• 31 to 60 days past due
• 61 to 90 days past due
• Over 90 days past due

Each vendor gets a row, each bucket gets a column, and the bottom row totals the whole accounts payable balance — which should tie back to the accounts payable line on your balance sheet. Some reports age from the invoice date and some from the due date; aging from the due date is more useful, because a bill on Net 30 terms isn't actually late until thirty days have passed.

Reading it: the buckets tell a story

The shape of the report tells you how you're managing your obligations:

• Most of the balance in Current is the healthy picture. You're paying bills on time, not early enough to drain cash needlessly and not late enough to damage relationships.
• A growing 1-to-30 bucket can be fine if it's deliberate — paying on terms rather than on receipt is good cash management. It's a warning sign only if those bills are slipping past their actual due dates.
• Anything in the 60-plus buckets deserves immediate attention. A genuinely overdue bill risks late fees, interest, a vendor putting you on credit hold, or a supplier you depend on simply refusing the next order.

One subtlety worth checking: a very old item sitting in the over-90 column is sometimes not a real debt at all. It can be a bill that was already paid but never matched, or a duplicate. Stale entries like these are exactly what a month-end close review is meant to catch, the same way you scrub stale items off the receivables side.

Using it to plan cash

The AP aging pairs naturally with a cash-flow forecast. The AR aging tells you what's likely to come in; the AP aging tells you what has to go out and by when. Read together, they answer the question that actually keeps owners up at night: will there be enough in the account to cover what's due?

This is also where the report helps you avoid two opposite mistakes. Paying every bill the moment it arrives feels responsible but needlessly shortens your cash position. Paying everything at the last possible second protects cash but risks late fees and strained suppliers. The aging report lets you steer between them: pay on terms, prioritize the bills closest to due, and time large payments around when receivables are expected to land.

A quick worked example

Suppose your AP aging shows three vendors. Vendor A: one bill for four thousand dollars, currently in the Current bucket, due next week. Vendor B: two thousand dollars sitting in the 31-to-60 column. Vendor C: six hundred dollars in the over-90 column that you're fairly sure you already paid.

The report just turned a vague sense of "we owe some money" into a concrete action list: budget the four thousand for next week, call Vendor B to clear the genuinely overdue two thousand before it becomes a problem, and investigate the Vendor C item, which is probably a matching error rather than a real liability. That is the whole value of the report — it converts your payables into prioritized, time-bound decisions.

Hosting Books builds the AP aging from your entered bills automatically and keeps it tied to the payables balance on your balance sheet, so the report you plan from always matches the books behind it.

This article is general educational information about accounting concepts and is not accounting advice for your specific situation.