Accounts payable dashboards are most useful when each metric has a documented population, formula, date basis and exception rule. Otherwise a polished KPI tile can conceal a misleading denominator. This guide explains how to define AP performance measures that finance managers can independently reconcile.
1. On-time payment rate
Definition: qualifying invoices paid on or before their due date divided by qualifying invoices paid during the reporting period and on or before the reporting cutoff. Multiply by 100 for a percentage.
Illustrative example: as of 19 October, five invoice records show three payments dated on or before the reporting date and two payments dated later. Of those three eligible payments, two were on time. On-time rate is 2 ÷ 3 = 66.67%, not 3 ÷ 5 = 60% or 3 ÷ 3 = 100%. The two future payments must not enter an as-at report.
Document how partial payments, reversals, credits and disputed invoices are counted. A different, explicitly labelled measure may consider invoices due in the period rather than invoices paid in the period—do not mix definitions.
2. Overdue AP value and overdue share
Overdue AP value is the signed open amount for in-scope invoices whose valid due date precedes the report as-at date. Overdue share is overdue open AP divided by total comparable open AP, subject to documented treatment of credits and negative total denominators.
Example: total comparable open AP $125,000 and overdue exposure $20,000 gives 16% overdue share. Report both numerator and denominator. If an item has a missing due date, place it in a data-quality exception rather than silently excluding it.
3. Invoice processing cycle time
A simple definition is the elapsed calendar days from invoice receipt date to final processing decision. Median and 90th-percentile cycle time often reveal delay patterns better than the arithmetic mean alone. Distinguish receipt-to-entry, entry-to-approval and approval-to-payment stages; a single aggregate number is rarely sufficient to identify where the bottleneck sits.
4. First-pass match rate
Definition: invoice items that satisfy all required validation and matching checks without manual exception intervention divided by all eligible invoice items first processed. Set a controlled list of qualifying exception categories and specify whether a later successful rematch changes the original first-pass outcome (usually it should not).
Example: 92 of 120 initially processed invoices matched on first pass. Rate = 92 ÷ 120 = 76.67%. Exclude cancelled duplicates or invalid rows only according to an explicit population rule; also disclose exclusion counts.
5. Exception clearance rate
To avoid ambiguous 'coverage' wording, define clearance rate as the number of eligible exceptions resolved with documented disposition during the period divided by total eligible exceptions requiring disposition under the policy. Distinguish it from 'exception count remaining', and show reopenings separately.
Make every KPI traceable to source records
| KPI | Required source fields | Primary risk |
|---|---|---|
| On-time rate | Invoice ID, due date, paid date, status, as-at date | Future-dated payment included |
| Overdue share | Open signed amount, due date, currency | Missing dates or unapplied credits dropped |
| Processing time | Received date, milestone dates | Unreliable or overwritten timestamps |
| First-pass match | Initial review outcome and eligible population | Successful rework labelled first-pass |
| Exception clearance | Case ID, open/close decisions, reviewer | Closed without evidence |
Dashboard QA checks finance managers should run
- Compare each card against a separately calculated source-data pivot or manual sample.
- Test a future date, missing due date, blank ID, invalid text amount, negative credit and payment reversal.
- Check the first and last configured input rows.
- Confirm trend charts use a consistent period population and currency.
- Retest after changing the as-at date; past results must not move unexpectedly.
- Show stale data, source load time and unreviewed exception counts prominently.
Frequently asked questions
How many KPIs should an AP dashboard have?
As many as support decisions; a short, well-defined group is usually more useful than numerous decorative measures. Add drill-down lists for material exceptions.
Should dashboard values be considered approval evidence?
No. Metrics provide visibility. Payment approvals, reconciliations and investigations still require their separate authorised evidence.
See the AP Month-End Checklist and the payment-run readiness guide to connect measurement with control decisions.
Educational KPI definitions only. Agree metric policies with your finance team.
Put this into practice: AP KPI & Performance Dashboard calculates on-time payment rate, ageing, approval cycle time and days to pay straight from your invoice list. Macro-free Excel with a Worked Example and a Blank edition, one-time payment, instant download. Or start with the free 20 Essential AP Controls Checklist (printable PDF).