Accounts Payable Aging Report: Example and How to Read It

If you want to know what your business owes and when it comes due, the accounts payable aging report is the one document that puts it all on a single page. It groups every unpaid vendor invoice by how long it has been outstanding, so you can see at a glance what is current, what is creeping toward late, and what is badly overdue. This guide explains what an accounts payable aging report is, shows a worked example, walks through how to read and create one, and covers how to use it to manage cash and protect vendor relationships. By the end you will know exactly what those 30, 60, and 90 day columns are telling you.

What is an accounts payable aging report?

An accounts payable aging report is a financial report that lists all of your unpaid vendor invoices and sorts them into time buckets based on how long each one has been outstanding. The standard buckets are current (not yet due), 1 to 30 days, 31 to 60 days, 61 to 90 days, and 91 or more days past due. Each vendor gets a row, each aging bucket gets a column, and the totals show how much you owe in each time band and overall. The report is sometimes called an AP aging schedule or aged payables report, and it is one of the core reports finance teams run every month.

It sits inside the broader accounts payable process as the snapshot that answers a simple question: of everything we owe right now, what needs to be paid first?

Why the accounts payable aging report matters

Accounts payable is usually one of the largest short-term liabilities on the balance sheet, and the aging report is how you keep it under control. It does four jobs at once. It shows which invoices are due or overdue so you can pay on time and avoid late fees and strained vendor relationships. It surfaces early payment discounts you can still capture, like 2/10 net 30, before the window closes. It tells you roughly how much cash you need and when, which feeds directly into cash flow planning. And it exposes problems hiding in your payables: duplicate entries, invoices stuck in approval, or balances that should have cleared months ago.

Read over time, the report also reveals trends. A 91+ column that keeps growing is a warning sign that invoices are slipping through approval or that cash is tight. A current column that dominates means you are paying on schedule. Either way, the aging report turns a pile of invoices into a decision tool.

What an accounts payable aging report looks like

The layout is a grid. Vendors run down the left, aging buckets run across the top, and the bottom row totals each column. Here is a simple example for a business at month-end.

This business owes $21,200 in total. Most of it ($14,600) is current and not yet a problem. But $3,100 to Brightline Freight is already 31 to 60 days past due, and $1,250 to Coastal Office Supply has sat in the 91+ column, which is exactly the kind of stale balance that needs a closer look.

How to read an accounts payable aging report

Read the report from the most overdue column inward, then use the totals to plan. Start with the 91+ column, because those invoices carry the highest risk of late fees, service interruptions, or a damaged vendor relationship, and an aged balance can also signal an error rather than a real debt. Work back through 61 to 90 and 31 to 60, deciding what to clear next. Then look at the current and 1 to 30 columns to plan upcoming payments and catch any early payment discounts before they expire.

While you read, watch for a few specific things. A debit balance (a negative number) usually means an unapplied credit memo or a duplicate payment you should investigate and recover. A large 91+ balance for a vendor you know you pay on time often means a missing or duplicated entry, not an actual overdue bill. And a column total that keeps climbing month over month points to a process bottleneck upstream, usually slow approvals or invoices that never made it into the system.

How to create an accounts payable aging report

If you are building one by hand, the process is straightforward, even if it is tedious at volume.

• Gather every outstanding invoice and vendor statement so you are working from a complete set of what you owe.
• Group the invoices by vendor, then by due date within each vendor.
• Set up columns for your aging buckets in 30 day increments (current, 1 to 30, 31 to 60, 61 to 90, 91+).
• Place each invoice amount in the bucket that matches how many days past due it is, measured from the invoice due date to today.
• Total each row to see what you owe each vendor, total each column to see what you owe in each time band, and total everything for your full payables balance.

Most accounting systems (QuickBooks, Xero, NetSuite, Sage) can generate this report on demand, which beats rebuilding a spreadsheet every month. The catch is that the report is only as accurate as the data behind it: if invoices are sitting unentered in an inbox, they will not appear, and the aging report will understate what you actually owe.

How often should you run the report

Run the accounts payable aging report at least monthly, as part of the month-end close, where reviewing the aging is a standard step before you close the subledger. Busy teams with high invoice volume benefit from a weekly review so overdue items never pile up. With a connected accounting system or AP automation, you can pull the aging on demand any day of the month, which is the real advantage of moving off a manual spreadsheet: the report reflects reality right now, not a snapshot from two weeks ago.

Accounts payable aging report vs accounts receivable aging report

The two reports mirror each other but point in opposite directions. An accounts payable aging report tracks money you owe to vendors and suppliers, grouped by how overdue each bill is, and you use it to manage outgoing cash and pay on time. An accounts receivable aging report tracks money customers owe you, grouped by how overdue each customer invoice is, and you use it to chase collections and manage incoming cash. Both use the same 30, 60, and 90 day buckets, but AP aging is about your obligations while AR aging is about your assets. Together they give finance a full view of cash moving out and cash coming in.

What the aging report tells you about cash and DPO

Beyond paying bills on time, the aging report feeds your wider cash strategy. By showing exactly when obligations come due, it lets you time payments against expected cash inflows, so you hold onto cash as long as the terms allow without going late. It also connects to days payable outstanding, one of the key accounts payable KPIs: a healthy aging profile (most balances current, very little in 90+) usually means a DPO that stretches terms sensibly while keeping vendors happy. If your aging is drifting older across the board, your DPO may be climbing because of process delays rather than a deliberate cash decision, which is worth fixing before it costs you discounts or goodwill.

From a stale spreadsheet to a real-time aging report

The biggest weakness of a manual aging report is timing. By the time someone exports invoices, sorts them into buckets, and circulates the spreadsheet, the picture is already a little out of date, and any invoice still sitting unentered is simply missing. That is how teams end up surprised by an overdue balance that was real all along.

Automation closes that gap. Accounts payable software captures invoices with AI as they arrive, codes and matches them, routes approvals on rules, and keeps a complete, current payables ledger, so the aging report is always live rather than a monthly rebuild. It flags duplicates and unapplied credits that would otherwise show up as odd balances in the aging, and it syncs clean data into your accounting system so the numbers tie out. You still decide who to pay and when; the software just makes sure the aging report in front of you is accurate and up to the minute. If you are weighing options, our guide to the best AP automation software covers what to look for, and removing manual invoice data entry is the single change that does most to keep an aging report honest.

Frequently asked questions

What is an accounts payable aging report?

An accounts payable aging report is a financial report that lists all unpaid vendor invoices and groups them by how long they have been outstanding, usually in current, 1 to 30, 31 to 60, 61 to 90, and 91+ day buckets. It shows how much you owe each vendor and in each time band, giving a quick snapshot of what is due and what is overdue.

What is an accounts payable aging report used for?

It is used to manage outgoing cash and vendor relationships. Finance teams use it to see which invoices are due or overdue, prioritize which vendors to pay first, capture early payment discounts before they expire, plan how much cash is needed and when, and spot problems like duplicate entries or stale balances that need investigation.

How do you read an accounts payable aging report?

Start with the most overdue column (91+) and work inward, deciding what to clear first to avoid late fees and protect supplier relationships. Then review the current and 1 to 30 columns to plan upcoming payments and catch discounts. Watch for debit balances and unusually old amounts, which often signal duplicate payments or missing entries rather than real debt.

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

An accounts payable aging report tracks money you owe to vendors, sorted by how overdue each bill is, and helps you manage payments and outgoing cash. An accounts receivable aging report tracks money customers owe you, sorted by how overdue each invoice is, and helps you manage collections and incoming cash. Both use the same 30, 60, and 90 day buckets.

How often should you run an accounts payable aging report?

Run it at least monthly as part of the month-end close, and weekly if you process a high volume of invoices. With a connected accounting system or AP automation you can pull it on demand any day, which keeps the report current instead of relying on a snapshot that is already out of date by the time it circulates.

How do you create an accounts payable aging report?

Gather all outstanding invoices, group them by vendor and due date, set up columns for your aging buckets in 30 day increments, place each invoice in the bucket matching its days past due, then total each row, each column, and the whole report. Most accounting systems can generate it automatically, which is faster and more accurate than a manual spreadsheet.