Accounts Payable Aging Report: Template and Excel

An accounts payable aging report is one of the few finance reports that earns its keep every single week. It tells you, at a glance, which vendor bills are due now, which are slipping past terms, and how much cash you need on hand to stay current. Controllers use it to plan payment runs, catch duplicate or disputed invoices before they get paid twice, and protect supplier relationships that fall apart the moment payments run late. This guide explains what the report is, how the aging math works, the standard bucket layout, and how to build one in Excel or pull it from QuickBooks, with a template structure you can copy.

What is an accounts payable aging report?

An accounts payable aging report is a summary of every unpaid vendor invoice your business owes, grouped by how long each invoice has been outstanding. It lists payables by vendor and sorts the amounts into time buckets, usually current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and 91 days or more. The point is to show, in one view, exactly what you owe and how overdue any of it is.

Accountants also call it an AP aging report or an AP aging schedule. It is the payables mirror image of the accounts receivable aging report your sales side uses to chase customers. Where the receivable version tracks money coming in, the payable version tracks money going out, so it drives payment timing and short-term cash planning.

How do you calculate accounts payable aging?

You calculate accounts payable aging by subtracting each invoice date or due date from the report date, which gives the number of days the invoice has been outstanding. The formula is simply: report date minus invoice (or due) date equals aging days. You then drop each invoice into the bucket that matches its age and total the amounts in each column.

One decision shapes the whole report: do you age from the invoice date or the due date. Aging from the invoice date shows how long you have held the bill since it arrived. Aging from the due date shows how far past terms a payment actually is, which is usually the more useful view for an AP manager deciding what to pay next. Pick one method and apply it consistently, because mixing the two makes the report impossible to trust.

What are the aging buckets in an accounts payable aging report?

The standard aging buckets are current (not yet due), 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days past due. Most accounting systems and templates use these 30-day increments because they line up cleanly with common net 30 and net 60 vendor terms and make overdue balances easy to spot.

The buckets are not a rule carved in stone. A business that pays mostly on net 15 terms might use 15-day increments, and some teams add a 120-plus column to isolate the truly stale items that signal a dispute or a lost invoice. Whatever ranges you choose, anything sitting in the 60-plus columns deserves attention, because those balances are either late, in dispute, or recorded incorrectly.

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

To create an accounts payable aging report in Excel, list every open invoice in a table with columns for vendor, invoice number, invoice date, due date, and amount, then add a formula that calculates each invoice's age and a set of bucket columns that sort the amount by that age. A PivotTable on vendor and bucket then rolls it into a clean summary.

Here is a layout that works. In your data table, add an Aging Days column with =TODAY()-[due date]. Then add five bucket columns and use a nested IF, for example =IF(A2<=0,Amount,0) for the current column and =IF(AND(A2>0,A2<=30),Amount,0) for the 1 to 30 column, repeating the pattern for each range. Insert a PivotTable with vendors as rows and the bucket columns as values to get per-vendor totals and a grand total row. The whole thing takes ten minutes once your invoice data is sitting in rows. The slow part is never the formulas. It is getting dozens of PDF bills typed into the spreadsheet in the first place, which is the step worth automating.

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

In QuickBooks Online, open Reports, search for "Accounts Payable Aging Summary" or "Accounts Payable Aging Detail," set the report date and aging interval, then run it. The summary version shows totals per vendor by bucket, while the detail version lists each open bill inside those buckets. You can export either one to Excel for further sorting or to share with a reviewer.

QuickBooks Desktop offers the same two reports under Reports, then Vendors and Payables. The numbers are only as good as the bills entered, though. If invoices are still sitting in an inbox or a folder, they will not appear on the aging report at all, which is exactly how an unrecorded liability slips through. Entering bills promptly is what keeps the report honest, and it is the reason teams that convert invoices to QuickBooks from a structured file rather than rekeying them tend to have cleaner, more current aging schedules.

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

An accounts payable aging report tracks money you owe to vendors, grouped by how overdue each bill is, while an accounts receivable aging report tracks money customers owe you, grouped by how overdue each customer invoice is. One manages outgoing cash and supplier relationships; the other manages incoming cash and collections.

The mechanics are nearly identical, which is why the two reports look so similar. Both age open balances into 30-day buckets and both total by counterparty. The action they drive is opposite. A payable aging report tells you what to pay and when; a receivable aging report tells you who to call for collection. Finance teams read them side by side to forecast net cash position over the coming weeks.

How often should you run an accounts payable aging report?

Most businesses run an accounts payable aging report at least monthly, and many AP teams pull it weekly or before each payment run. Monthly is the minimum for closing the books and for review, but weekly snapshots give a far more accurate picture when cash is tight or invoice volume is high.

The right cadence depends on how fast your payables move. A company processing a few hundred invoices a month benefits from a weekly view so nothing drifts into the 60-plus columns unnoticed. The report is only useful if it reflects reality, so the discipline that matters more than frequency is entering invoices as they arrive. A report run weekly off stale data is worse than a monthly report off current data.

Why is an accounts payable aging report important?

An accounts payable aging report is important because it turns a pile of open bills into a clear payment plan, protects cash flow, and surfaces problems before they cost money. It shows which vendors to pay now, where you can capture early payment discounts, and which balances are overdue enough to threaten a supplier relationship or a credit line.

It is also a control tool. Reviewing the aging schedule regularly is how teams catch duplicate invoices, amounts that do not match the purchase order, and payments applied to the wrong bill. Auditors lean on it too, because the aging detail is where unrecorded liabilities and cutoff errors show up. For a finance leader, the report is a quick read on whether the AP process is under control or quietly falling behind. It pairs naturally with the accounts payable KPIs most teams track, since days payable outstanding and on-time payment rate are both calculated from the same open-invoice data.

Build the aging report faster with clean invoice data

Every step above assumes one thing: your invoice details already live in rows you can sort. Vendor, invoice number, invoice date, due date, and amount have to be captured accurately before any bucket formula or PivotTable can work, and that capture is where most of the time goes. InvoiceXLSX reads PDF and image invoices and returns clean Excel or CSV with each field in its own column, so you can extract invoice data to Excel and drop it straight into your aging template. Run a backlog through the invoice PDF to Excel converter, pull full invoice line item data when you need detail behind a balance, and let the team automate accounts payable data entry so the report reflects today rather than last week. Accurate data also reduces invoice processing costs across the board. To make sure the report ties out, reconcile it against your vendor statements, and when you need to confirm which bills were actually paid, convert your bank statement to Excel and match payments against the aging detail. If your prepared data needs to land in QuickBooks, a CSV to QBO converter turns the file into an import your accountant can post directly.