See how much you owe and how old each unpaid bill is. The Accounts Payable Aging Dashboard in Power BI turns your vendor invoice list into a complete accounts payable aging report by vendor, vendor category, entity, department and AP specialist. Add your invoices to the Excel data file, click Refresh in Power BI, and every card and chart updates.
Watch the Accounts Payable Aging Dashboard in Power BI walkthrough
Good to know: this is an add-data-and-refresh template, not a live connector to your accounting software. It needs Power BI Desktop (free). The sample data is fictional. Join 10,000+ customers in 180+ countries.
What You Get
- A Power BI .pbix file with Overview, Aging, Vendors, Entities and Payments pages
- Cards for Total Open AP, Total Past Due, Past Due % and DPO, with month-over-month change
- An accounts payable aging report that always reconciles to the total
- A vendor open AP scorecard with in-cell bars
- Right-click drill-through to a Details page with every invoice behind a number
- 5 synced filters on every page: date range, entity, department, vendor category and a page-specific filter
- An Excel data file with 500 sample vendor invoices, plus a user manual (PDF)
Key Features
Overview Page
Total Open AP, Total Past Due, Past Due % and DPO cards with month-over-month change and lollipop trends, open AP by aging bucket, open AP by status, invoiced vs paid by month and open AP by entity.
Aging Page
An accounts payable aging report by vendor category (Current, 1-30, 31-60, 61-90 and 90+ days) that reconciles to the total, open invoices by bucket, past due by payment terms and open AP by vendor tier.
Vendors Page
A vendor open AP scorecard with in-cell bars and past due by vendor category.
Entities Page
Open vs past due by entity, open AP by department and AP specialist workload.
Payments Page
Paid by month with discount capture rate, average days to pay by payment terms and early-payment discounts available vs taken.
More Dashboards Page
Links to more Power BI dashboards from Next Gen Templates.
Who Is It For?
Accounts payable managers, controllers, finance managers, procurement teams and business owners who review what they owe every week or month. It also suits bookkeepers who report payables for clients.
How to Use
- Download the ZIP and unzip it. It holds the .pbix file, the Excel data file and the user manual.
- Add your vendor invoices to the Excel data file.
- Open the .pbix file in Power BI Desktop and click Refresh.
- Use the five filters to focus on an entity, department or vendor category.
- Right-click any number and choose Drill through to see the invoices behind it.
Comparison
| Feature | This dashboard | Plain invoice list |
|---|---|---|
| Aging buckets and past due % | Cards and charts | Manual formulas |
| Vendor aging report by category and tier | Scorecard and filters | Build yourself |
| Days to pay and discount capture | Payments page | Build yourself |
| Drill-through to invoices | Right-click | Scroll and search |
| Live link to accounting software | No | No |
Frequently Asked Questions
Does it connect to my accounting software?
No. It is an add-data-and-refresh template. Add your vendor invoices to the Excel data file that comes in the ZIP, click Refresh in Power BI, and every card and chart updates. There is no live link to QuickBooks, Xero, SAP or any other system.
Do I need Power BI Pro?
No. Open the .pbix file in Power BI Desktop, which is free. Publishing to the Power BI service is optional and is your choice.
What does one invoice row hold?
Each of the 500 sample rows holds an invoice date, due date, vendor, vendor category, vendor tier, entity, department, AP specialist, payment terms, status and the invoiced, paid and open amounts. Replace them with your own invoices.
How are the aging buckets worked out?
Open invoices are grouped as Current, 1-30, 31-60, 61-90 and 90+ days past due, and the buckets always add up to the Total Open AP card.
How does the drill-through work?
Right-click a vendor, entity or month in a visual and choose Drill through to open the Details page with every invoice behind that number.
Is the sample data real?
No. The 500 vendor invoices in the Excel file are fictional. Replace them with your own and click Refresh.
Can I keep real financial data in it?
Yes, but a Power BI file is only as private as where you store and share it. Keep your copy somewhere access-controlled and share it with named people only.
Get the Dashboard
Download the Accounts Payable Aging Dashboard in Power BI and review your payables on one screen. It works as an accounts payable dashboard Power BI users can refresh in seconds, and an AP aging report Power BI file you can reuse every month. To track what customers owe you, see the Accounts Receivable Aging Dashboard in Power BI. Prefer a workbook? Try the Accounts Payable Aging Dashboard in Excel, or browse all Power BI templates.
Reviews
There are no reviews yet.