Accounts Payable Aging Report

The accounts payable aging report is the one report that tells you, at a glance, who you owe and how late you are. It sorts every unpaid vendor bill into buckets by how long it has been outstanding, which turns a vague sense of "we have a lot of bills" into a prioritized payment list. This guide explains what the report is, what the aging buckets mean, how to run it in QuickBooks, how to build one in Excel, and how to read it when cash is tight. Written for US bookkeepers, AP staff, and controllers.

What is an accounts payable aging report?

An accounts payable aging report is a list of your unpaid vendor bills grouped by how long they have been outstanding. It shows each vendor, the amounts owed, and how those amounts spread across time buckets such as current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90 days. It is the standard tool for deciding which bills to pay next.

Think of it as a snapshot of a liability, taken on a specific date, sliced by age. The total at the bottom should tie to the accounts payable balance on your balance sheet as of that same date. What the balance sheet cannot tell you, and the aging report can, is whether that payable is a healthy stack of bills that are not due yet or a pile of invoices you are 90 days late on.

What is AP aging in accounting?

AP aging is the practice of classifying outstanding payables by the length of time they have been unpaid. In accounting it serves two purposes: operational, as the basis for scheduling payments and protecting vendor relationships, and analytical, as evidence of whether the company is meeting its obligations on time and how much short-term cash it needs.

Auditors care about it too. During an accounts payable audit, the aging report is a starting point for testing completeness and cutoff, because unusually old items often signal a bill that was recorded twice, a credit that was never applied, or a liability that should have been written off.

What are the aging buckets on an AP aging report?

Most AP aging reports use 30-day buckets: current (not yet past due), 1 to 30 days past due, 31 to 60 days past due, 61 to 90 days past due, and 91 days or more past due. Each bill lands in exactly one bucket based on its due date. Totals run down each vendor row and across each bucket column.

The distinction between "current" and "1 to 30" trips people up in QuickBooks. Current means the bill is outstanding but not yet due under its payment terms, so a Net 30 bill issued last week sits in current, not in 1 to 30. The past-due columns count days beyond the due date, not days since the invoice was written. If your report seems to age bills too fast, check whether due dates were entered at all, because a missing due date usually defaults to the invoice date and pushes everything a month older than it should be.

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

The summary shows one row per vendor with totals across each aging bucket, which is what you want for a payment run or a quick health check. The detail report shows one row per individual bill, with its date, due date, and amount, which is what you want when you are investigating a specific balance or chasing down what makes up an old total.

The working pattern is to start with the summary, find the vendor with money sitting in the 90-plus column, then open the detail report for that vendor to see which specific bills are stuck and why. Nine times out of ten it is a bill on hold pending a credit, a duplicate, or an invoice that was entered but never approved.

What does an accounts payable aging report look like?

A typical summary looks like the table below, with vendors down the left and aging buckets across the top. The bottom row totals each bucket, and the far-right total ties to accounts payable on the balance sheet for that date.

Read it vendor by vendor. Atlas Freight is mostly current, which is fine. Brightline has drifted into 31 to 60, which means late fees or a strained relationship are coming. Cedar Print has $3,100 parked in the 91-plus column with nothing else outstanding, and that isolated old balance is the classic signature of a disputed bill or an unapplied credit rather than a cash problem.

How do you run an accounts payable aging report in QuickBooks?

In QuickBooks Online, select Reports from the left menu, scroll to the "What you owe" section, and choose Accounts payable aging summary, or Accounts payable aging detail for the bill-level view. Set the report date and the aging interval, then run it. You can change the number of days per bucket and the number of periods shown in the report settings.

Two settings are worth adjusting. The report date should usually be today rather than a period end, because you are making a payment decision now. And the aging interval defaults to 30 days, which suits Net 30 terms, but if most of your vendors are on Net 15 you will see problems sooner by tightening it. Export to Excel if you want to sort by the 90-plus column, which is the fastest way to surface what actually needs attention.

How do you create an accounts payable aging report in Excel?

Build a table with vendor, invoice number, invoice date, due date, and amount. Add a column calculating days past due as today's date minus the due date. Then use nested IF formulas or a SUMIFS across bucket columns to place each amount in the right bucket, and pivot by vendor. The whole thing takes about twenty minutes to set up once.

The catch is not the formula. It is getting the invoice data into the spreadsheet in the first place. If your bills arrive as PDFs and someone retypes the vendor, invoice number, date, due date, and amount for each one, the report is only as current as the last time they had a spare afternoon, and manual keying carries roughly a one in ten error rate. An AI invoice PDF to Excel converter reads a folder of bills and returns those exact fields as clean columns, which is the input an aging formula needs. For the underlying approach, invoice data extraction software explains how any vendor layout gets read without a template.

Why is the accounts payable aging report important?

It drives three decisions. It tells you which bills to pay first when cash is limited, so you protect critical vendors and avoid late fees. It reveals process failures, since bills stranded in old buckets usually mean a broken approval or an unresolved dispute. And it feeds short-term cash forecasting, because the current bucket is the money leaving in the next few weeks.

It is also a negotiating tool in both directions. Seeing that you consistently pay a vendor early gives you standing to ask for a discount, and our guide to the early payment discount covers whether taking one is worth the cash. Seeing that a vendor's balance is always aging tells you the terms you agreed to are not the terms you can actually meet. When cash is genuinely tight, the aging report only works alongside a real view of what is in the bank, which usually means turning the latest bank statement into a spreadsheet you can compare against.

What is the difference between accounts payable aging and accounts receivable aging?

Accounts payable aging tracks money you owe to vendors. Accounts receivable aging tracks money customers owe you. They use identical bucket structures and look nearly the same on the page, but they answer opposite questions: AP aging asks who to pay next, AR aging asks who to chase next. Both roll up to short-term cash planning.

Reading them side by side is how you spot a working capital squeeze early. If your receivables are aging into 60 and 90 days while your payables are all current, you are financing your customers with your own cash. Our explainer on days payable outstanding covers the metric that formalizes that comparison.

How often should you review the AP aging report?

Weekly is the practical cadence for most US businesses, timed just before the payment run so the report reflects what you are about to decide. Review it monthly at close as well, to confirm that the total ties to the accounts payable balance on the balance sheet and to clear anything that has drifted into the 90-plus bucket.

Teams running a scheduled payment run typically pull the aging summary the morning of the run, sort by due date within the current bucket, and pay everything reaching its due date before the next run. That single habit eliminates most late fees without paying anyone early.

Why is my AP aging report wrong?

The usual causes are missing or incorrect due dates, bills entered against the wrong vendor, duplicate bills entered twice from a PDF and a reminder email, vendor credits recorded but never applied to an open bill, and payments made outside the system so the bill never cleared. Each one distorts the buckets rather than the total, which is why the report can look strange while the balance sheet looks fine.

Almost all of these are data-entry failures, not accounting failures. A due date typed as the invoice date ages a bill a full bucket early. A vendor name entered slightly differently splits one supplier into two rows. Reducing manual keying is the fix, which is why teams move invoice capture upstream: our guide to preventing duplicate invoice payments covers the duplicate case specifically, and vendor credits explains the unapplied-credit case. If you run QuickBooks, QuickBooks AP automation shows where the native bill capture stops and what still gets typed by hand.

Turning the aging report into an action list

The report is only useful if it changes what you do this week. Sort by the oldest bucket first and ask a different question of each one. Anything in 91-plus is not a payment decision, it is an investigation: find out whether it is a dispute, a duplicate, or a credit and close it out. Anything in 31 to 90 is a relationship risk, so pay it or call the vendor. Anything current is a scheduling exercise, so pay it on the due date, not before, unless a discount makes early payment worth the cash.

Then look at why the old items got old. If bills sit unapproved for weeks, the problem is your invoice approval workflow, not your payment discipline. If bills arrive and take days to be entered, the problem is capture, and clean extraction fixes it at the source. Upload an invoice to the tool at the top of this page to see the fields an aging report actually runs on, or read how accounts payable automation software connects capture, approval, and payment into one chain.