Accounts Payable Aging Report: How to Read the AP Aging Report and Aging Schedule

An accounts payable aging report lists every unpaid vendor bill sorted by how long it has been outstanding, grouped into buckets that are almost always current, 1 to 30 days, 31 to 60, 61 to 90, and over 90. The total at the bottom has to equal the accounts payable balance on your balance sheet for the same date. If it does not, one of the two reports is wrong, and it is usually not the aging.

It is the report you run before you decide who gets paid this Friday, and the report a lender or a buyer asks for when they want to know whether the payables balance on your balance sheet is a normal operating float or a pile of bills you cannot cover. Here is how to read it, the four reasons it stops tying to the balance sheet, how to run it in QuickBooks, and what the numbers on it actually tell you about the business.

What is accounts payable aging?

Accounts payable aging is the practice of sorting what you owe by age. Each open bill is measured from either its bill date or its due date, depending on a setting you control, and dropped into a bucket. The report then subtotals by vendor and by bucket, so you can see both who you owe and how late you are.

It is the mirror image of the accounts receivable aging report, which sorts what customers owe you. The two answer opposite halves of the same question, and reading them together is how you find out whether a cash squeeze is a collections problem or a spending problem. Receivables stretching while payables stay current means you are financing your customers. Payables stretching while receivables stay current usually means the money went somewhere else, most often inventory or an owner distribution.

One naming quirk trips people up in QuickBooks Online. The AR aging sits under a report group called "Who owes you" and the AP aging sits under "What you owe." People search for the payables report in the first group, do not find it, and conclude QuickBooks does not have one. It does.

What are the standard accounts payable aging buckets?

Current, 1 to 30, 31 to 60, 61 to 90, and 91 and over. That five-bucket layout is the default in QuickBooks, Xero, NetSuite and Sage, and because everyone uses it, a lender reading your report knows exactly what they are looking at without asking. Change the interval at your own cost: a report with 15-day buckets is not wrong, but it makes comparison to anything else harder.

The setting that actually changes the report is whether aging runs from the bill date or the due date. Aging by due date is the useful one for operations, because a bill dated three weeks ago on net 45 terms is not late and should sit in Current. Aging by bill date puts that same bill in the 1 to 30 bucket and makes a perfectly healthy payables ledger look delinquent. QuickBooks defaults to due date. If your report looks alarming and nothing in the business changed, check this setting first.

What does an accounts payable aging report look like?

Rows are vendors, columns are buckets, and the bottom right corner is the total payable. Here is a small one for a company with roughly $86,000 outstanding.

Accounts payable aging summary at June 30

Vendor	Current	1 to 30	31 to 60	61 to 90	91 and over	Total
Ridgeline Supply	$18,400	$6,200	$0	$0	$0	$24,600
Marlow Freight	$9,750	$3,100	$1,900	$0	$0	$14,750
Kestrel Print Co	$0	$0	$4,300	$4,300	$8,600	$17,200
Harbor IT Services	$5,900	$2,400	$0	$0	$0	$8,300
Everly Insurance	$12,000	$0	$0	$0	$0	$12,000
All other vendors	$6,150	$2,400	$600	$0	$0	$9,150
Total	$52,200	$14,100	$6,800	$4,300	$8,600	$86,000

Read the bottom row first. Sixty-one percent of this balance is current and another 16 percent is under 30 days, which is a normal operating float. The problem is one vendor. Kestrel Print Co has nothing in Current and $12,900 past 60 days, which is not a cash flow pattern, it is a dispute, a lost invoice, or a vendor nobody has called. A balance that is old across every vendor is a cash problem. A balance that is old at one vendor is an administrative problem, and it is the more common of the two.

What is the difference between the AP aging summary and the AP aging detail report?

The summary is the table above: one row per vendor, amounts by bucket. The detail report gives one row per open bill, with the bill date, due date, bill number, terms, original amount and open balance. You use the summary to decide and the detail to investigate.

The detail is what you need whenever a number looks wrong, because the summary hides everything that explains it. A vendor showing $8,600 in the over-90 bucket could be one large disputed invoice or eleven small ones nobody ever entered a payment against. It could also be a bill that was paid by check outside the system, so the payment reduced cash but never got applied to the bill. Only the detail shows you which.

How do I run the accounts payable aging report in QuickBooks?

In QuickBooks Online, go to Reports, then either search "aging" or scroll to the "What you owe" group. You will find A/P Aging Summary and A/P Aging Detail. Open the one you want and set three things before reading it.

The report date. This is not the same as a date range. The AP aging is a point-in-time report, so it shows what was open as of the date you pick. For a close, set it to the last day of the period, not to today, or it will not tie to the balance sheet you are producing.

The aging method and interval. Under Customize, then Aging, choose whether to age by due date or transaction date, and set the days per aging period and the number of periods. Leave it at 30 and 4 unless you have a reason.

The accounting method. Under Customize, then General. This one matters more than people expect. On cash basis, QuickBooks Online suppresses unpaid bills, so the AP aging can come back showing essentially nothing while your accrual balance sheet shows $86,000 in payables. If the report looks empty and you know it should not, this is almost always why.

In QuickBooks Desktop the same reports live under Reports, then Vendors and Payables, as A/P Aging Summary and A/P Aging Detail, with the aging interval under Customize Report and then the Aging tab. Desktop also offers Vendor Balance Detail, which is the better report when you are reconciling a single vendor's account against the statement they sent you.

Why doesn't my AP aging report match the balance sheet?

Because something posted to the accounts payable account without going through a bill. The aging report is built from the vendor subledger, meaning open bills and their payments. The balance sheet is built from the general ledger control account. When they disagree, the difference is almost always one of four things.

A journal entry posted directly to accounts payable. This is the most common cause by a wide margin. Someone made an adjusting entry that debited or credited AP without naming a vendor and without an underlying bill, so the control account moved and the subledger did not. In QuickBooks Desktop the Verify Data utility flags these; in QuickBooks Online you find them by running the general ledger report filtered to the AP account and looking for transaction types that are not Bill, Bill Payment or Vendor Credit.

A date mismatch. The aging is dated one day off from the balance sheet, or one is on cash basis and the other on accrual. Check both before assuming there is a real problem, because this explains a large share of the differences people spend an hour hunting.

Unapplied vendor credits or payments. A vendor credit that was recorded but never applied to a bill sits in the subledger as a negative and may or may not net into the total depending on the report. The fix is to apply it, not to write a journal entry.

More than one AP account. Some charts of accounts carry a second payables account for a specific purpose, and the aging report defaults to showing all of them combined while the balance sheet line you are comparing to is only one. Check the chart of accounts before anything else if the difference is a round, large number. Getting that structure right upstream is the subject of chart of accounts to financial statements.

This tie-out belongs in your close checklist, not in your investigation queue. The AP aging total at period end should equal the AP line on the balance sheet before you produce anything, which is one of the steps in the QuickBooks month end close checklist.

What does negative accounts payable on the aging report mean?

It means you have paid a vendor more than you owe them, at least according to the books. Three things cause it. You recorded a payment against a bill that was never entered, so the payment has nothing to reduce. You entered a vendor credit for a return or an overpayment and never applied it. Or you paid a deposit in advance of the bill arriving, which is genuinely a prepaid asset rather than negative AP and should be reclassified before the statements go out.

Negative payables sitting in the total is worth fixing rather than ignoring, because it understates your real payables. A report showing $86,000 that contains a negative $9,000 from an unapplied credit is really telling you that you owe $95,000 to the vendors you actually owe, and $9,000 is owed to you. Those are different obligations and a lender reading a net figure gets the wrong picture of both.

How is days payable outstanding calculated from the aging report?

Days payable outstanding, or DPO, is average accounts payable divided by cost of goods sold for the period, multiplied by the number of days in the period. Using the example above, if this company had $430,000 of COGS in the quarter and averaged $86,000 in payables, DPO is 86,000 divided by 430,000 times 91, which is about 18 days.

Eighteen days is fast. Paying that quickly is not automatically good: it means the company is funding its own working capital rather than using the interest-free credit its vendors already extended. On the other end, a DPO drifting from 30 to 55 days over three quarters is the single clearest early signal of a cash squeeze, and it shows up in the payables ledger months before it shows up anywhere a lender would normally look.

The honest exception is early payment discounts, which are worth far more than they look. Terms of 2/10 net 30 mean a 2 percent discount for paying 20 days early, which annualizes to roughly 36 percent. If you have the cash, taking those discounts beats almost any other use of it, and the aging detail report is where you find which bills still have a discount window open.

What lenders and buyers read into your payables

Anyone underwriting you compares the aging profile to the balance sheet total, then to your cash. A payables balance concentrated in Current with a healthy cash balance is unremarkable. The same balance sitting in the 60 and 90 day buckets while cash is thin is a working capital problem, and it changes the terms you are offered. The same logic applies in diligence when someone is buying the business, where an aged payables balance is treated as debt-like and comes straight off the purchase price.

This is also why the payables number that appears on issued statements has to be complete. The failure mode at close is not fraud, it is cutoff: bills for goods and services received before period end that arrive in the mail two weeks later. Under accrual accounting the expense belongs in the period the goods were received, not the period the invoice showed up, so a proper close includes an accrual for those. Skipping it understates both expenses and liabilities, which is the flattering direction and the one reviewers look for first. The accrual requirement is part of what makes a set GAAP financial statements rather than something that merely looks like them.

Most of the work above is administrative rather than analytical, which is why AP is one of the first functions finance teams hand to software. Routing bills for approval, matching them to purchase orders and posting them without keying anything is what accounts payable automation exists to do, and a payables ledger that stays clean produces an aging report you can trust without a reconciliation first.

Turning the aging into statements

The aging report is a subledger, not a financial statement. What it feeds is the accounts payable line inside current liabilities on the balance sheet, and the change in that line between two periods is a source or use of cash on the statement of cash flows. Payables that grew $22,000 during a quarter added $22,000 to operating cash flow, which is why a company with falling profit can still look cash positive for a while: it is paying its vendors slower.

If you are producing a statement pack from a bookkeeping export, the aging is one of the reconciliations you run before you start, alongside the bank and the receivables subledger. Once the subledgers tie, the statements are built from the trial balance rather than from any of them, which is the process on trial balance to financial statements. AIStatements takes that export and returns the income statement, balance sheet and cash flow statement formatted and tied to each other, with the written read on what moved, in about a minute.

AIStatements does not produce an accounts payable aging report. That report lives in your accounting system, because it needs the individual open bills, and no statement generator should be inventing a vendor subledger. What it does is take the tied-out balances and build the statements those balances belong in.