A handful of well-defined AP measures tells you more than a dashboard of thirty. Pick the ones that show cost, speed, accuracy and control.
Track a small set of AP KPIs from your invoice register: cost per invoice, invoice cycle time, first-time match rate, on-time payment rate, exception rate, duplicate payments found and early payment discounts captured. Define each one in writing, calculate it the same way every month, and review the trend rather than a single month's number.
Every KPI below comes from one table, one row per invoice. Export it from your accounting system each month:
Write a one-line definition for each KPI before you calculate it. Most arguments about AP performance are really arguments about definitions.
Cost per invoice is the total cost of the AP function for the period (people, software, outsourcing) divided by the number of invoices processed. Keep the cost definition stable or the trend means nothing.
Invoices per full-time equivalent is invoices processed divided by AP headcount in FTEs. Use it alongside accuracy measures, never alone, or you reward speed over care.
Invoice cycle time is the number of days from receipt to approval. Add a helper column J:
=IF(F2="","",F2-C2)
Then report the median rather than the average, because a few stuck invoices distort the mean:
=MEDIAN(J2:J5000)
MEDIAN ignores the empty-text results for unapproved invoices. List anything over your target separately so someone chases it.
First-time match rate is the share of PO invoices that matched to the order and goods receipt without manual intervention:
=COUNTIFS(G2:G5000,"Y",H2:H5000,"<>")/COUNTIFS(H2:H5000,"<>")
Exception rate is the reverse: invoices that needed a query, a price correction or a quantity fix. A rising exception rate usually points to purchasing or receiving, not AP. See the three-way match guide.
On-time payment rate is invoices paid on or before the due date as a share of invoices paid:
=SUMPRODUCT((E2:E5000<>"")*(E2:E5000<=D2:D5000))/COUNT(E2:E5000)
The first condition stops blank (unpaid) rows counting as on time. Track early payments too: paying well before the due date without a discount costs you cash. Days payable outstanding gives the balance-sheet view of the same question.
Early payment discounts captured is discounts taken divided by discounts offered. Missed discounts are a direct, measurable cost. See early payment discounts.
=SUMIFS(I2:I5000,H2:H5000,"")/SUM(I2:I5000)UK teams often say "purchase ledger" and "creditors"; US teams say "accounts payable" and "vendors". The KPIs are the same. Decide whether invoice amounts include VAT or sales tax and keep it consistent across months.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
There isn't one. A useful minimum set is cycle time, first-time match rate, on-time payment rate and duplicate payments found, because together they cover speed, accuracy, supplier relationships and control.
Median for the headline, because a few long-stuck invoices pull the average up. List the outliers separately so they get resolved.
Monthly, as part of the close or a short AP review meeting, with a rolling 12-month trend so seasonal patterns are visible.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.