Late bills hide inside long invoice lists. The Accounts Payable Aging Dashboard in Excel puts every open vendor invoice into aging buckets and shows what is past due by vendor, entity and department on one clickable screen.
Watch the Accounts Payable Aging Dashboard in Excel: Aging, DPO and Past Due walkthrough
Launch offerFrom your first Pivot Table to the Data Model, DAX, Power Query and a one-page KPI dashboard. 11h 51m of video by PK, with practice files, quizzes and a capstone.
What Is an Accounts Payable Aging Dashboard?
An accounts payable aging dashboard shows how much you owe your vendors and how old each unpaid invoice is. This one is an Excel workbook with five pages. You keep your vendor invoices on a Data tab, click Refresh All, and the pivot tables behind the charts update the Overview, Aging, Vendors, Entities and Payments pages. It works as an accounts payable aging report template you can reuse every month.
Inside the Dashboard
Overview Page
Five KPI cards sit across the top: Total Open AP, Total Past Due, DPO (Days), Discounts Offered and Past Due Invoices, plus Overdue %. Below them you get total open AP by aging bucket (Current, 1-30, 31-60, 61-90 and 90+ days), overdue % by entity and total past due by vendor category.
Aging Page
Open invoices by aging bucket, past due by payment terms, open AP vs past due by department and open AP by status.
Vendors Page
The top 10 vendors by past due and by open AP, overdue % by vendor category and open AP vs past due by vendor tier.
Entities Page
Open AP vs past due by entity, DPO by entity, overdue % by department and past due invoices by AP specialist.
Payments Page
Invoiced vs paid by month, discount capture % by entity and discounts offered vs taken by vendor category.
How It Works
The Data tab holds one row per vendor invoice. Formula columns work out the open balance, days past due, aging bucket, past due amount, month, year and quarter. A Support tab holds the pivot tables that feed the charts. Four slicers (Year, Month, Aging Bucket and Entity) filter all five pages at once, so you can look at one entity or one aging bucket in a click.
Pros and Limits
- One screen for open AP, past due, DPO, discounts offered and past due invoices
- No macros, no add-ins, no subscription
- Works for any vendor invoice list you can paste into the Data tab
- It is not a live connector to accounting software, so you refresh it yourself
- Built for desktop Excel on Windows, Excel 2016 or later, or Microsoft 365
Frequently Asked Questions
Does it connect to my accounting or ERP software?
No. It is an add-data-and-refresh workbook. Type or paste your vendor invoices on the Data tab, click Refresh All, and every card, chart and slicer updates. There is no live link to QuickBooks, Xero, SAP or any other system.
Is this an accounts payable aging report excel template?
Yes. It ages every open vendor invoice into Current, 1-30, 31-60, 61-90 and 90+ day buckets, then shows the result by vendor, entity and department.
Does it need macros or add-ins?
No. It uses formulas, pivot tables, charts and slicers only, so there is nothing to enable beyond opening the file.
Which Excel version do I need?
Desktop Excel for Windows, Excel 2016 or later, or Microsoft 365. The slicers and pivot tables do not work fully in Excel for the web.
How do I age the report to a new date?
Change the Report Date column on the Data tab, then click Refresh All. Days past due and the aging bucket recalculate for every invoice.
What does DPO show?
Days payable outstanding: open balance divided by invoiced amount, times 365, for whatever is in view. It reacts to the Year, Month, Aging Bucket and Entity slicers.
Is the sample data real?
No. The 500 vendor invoices on the Data tab are fictional. Replace them with your own and refresh.
Can I keep real financial data in it?
Yes, but an Excel file is only as private as where you store it. Keep your copy somewhere access-controlled and share it with named people only.
Get the Accounts Payable Aging Dashboard
Get the dashboard here: Accounts Payable Aging Dashboard in Excel. For the customer side of the ledger, try the Accounts Receivable Aging Dashboard in Excel.