Free Accounts Payable KPI Template (Excel)
What's in the accounts payable KPI template
One tab, AP Ledger, holds up to 200 invoices: invoice date, vendor, amount, due date, and payment date once it's paid.
Status, days to pay and a paid-on-time flag calculate automatically for every invoice - leave payment date blank and status reads OPEN or OVERDUE based on today's date versus the due date; fill it in and status switches to PAID.
The summary below the table rolls up invoices received, paid, and overdue, plus % paid on time and a simplified Days Payable Outstanding (DPO).
Simplified DPO, alongside the metrics that matter day to day
DPO here is (unpaid invoice balance divided by total invoiced) times 30 - a quick estimate you can calculate from a simple ledger, not the full formal DPO calculation some ERPs run against average daily purchases.
It's paired with the metrics AP teams check daily: how many invoices are open, how many are overdue, and what share are getting paid on time - vendor invoice aging most competitor dashboards (Financial Cents, HighRadius-style layouts) also track, alongside this simplified DPO.
The AP-side companion to the site's AR KPI dashboard
This template exists to complement the site's live Accounts Receivable KPI Dashboard - if you're tracking what customers owe you, this tracks what your business owes vendors, using the equivalent structure.
Use both together to see your full working-capital picture: cash coming in from customers on the AR side, cash going out to vendors on this AP side.
How to use it
- Log each invoice's date, vendor, amount and due date.
- Enter the payment date once an invoice is paid - status, days to pay and on-time flag update automatically.
- Check the summary below the table for invoices paid/overdue, % paid on time, and simplified DPO.
Download the free Free Accounts Payable KPI Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Small Business Bookkeeping & Tax Dashboard
If you need bookkeeping beyond AP tracking, the paid Bookkeeping template ($19) adds Schedule C categorization, a quarterly tax dashboard, and CPA-ready export.
See the full versionFrequently asked questions
How does the status column work?
It reads PAID once you enter a payment date. Until then, it reads OPEN or OVERDUE depending on whether today's date has passed the due date.
How is DPO calculated here?
Simplified DPO = (unpaid invoice balance / total invoiced) x 30. It's a quick estimate, not the full average-daily-purchases DPO formula some ERPs use.
How many invoices can it hold?
Up to 200 rows on the AP Ledger sheet.
Does this replace the Accounts Receivable KPI Dashboard?
No, it complements it. This tracks payables (money you owe); the AR dashboard tracks receivables (money owed to you).
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets.