Payment KPIs for finance teams: 8 to track and how to calculate them

Payment KPIs measure how reliably and cheaply your business turns invoices into cash. The core set for most finance teams is: collection rate, payment success rate, unpaid (returned) debit order rate, days sales outstanding, effective cost of payments and the share of payments reconciled automatically. Track these monthly with consistent definitions and you'll see collection problems weeks before they show up in the bank balance.

Below, each KPI with its formula, a worked example and what usually moves it.

Before you start: definitions and data

Payment KPIs are only useful if they're calculated the same way every month. Agree on:

• The period. Calendar month is simplest.
• Amounts in or out of VAT. For collection KPIs, VAT-inclusive amounts are fine because that's what customers pay; just be consistent.
• Attempts vs invoices. A card retried three times is one invoice but three attempts. Decide which each KPI counts.
• Source of truth. Pull from your billing system and gateway statements, not from memory or email.

The payment KPIs

1. Collection rate

What it tells you: how much of what was due actually got paid.

Formula: amount collected on invoices due in the period ÷ amount due in the period × 100.

Example: R420,000.00 due in August; R394,800.00 collected by 7 September. Collection rate = 94%.

What moves it: clear payment terms, easy ways to pay, reminders, automatic collection methods (card on file, debit order), and prompt follow-up on the aged receivables report.

Measure at a fixed cut-off (for example, seven days after month-end) so months are comparable.

2. Payment success rate

What it tells you: the share of automated payment attempts that succeed first time, for recurring card or tokenised payments.

Formula: successful first attempts ÷ total first attempts × 100.

Example: 1,240 recurring card charges attempted; 1,153 succeed first time. Success rate = 93%.

What moves it: expired cards, insufficient funds, issuer declines and fraud rules. Track the decline reasons your gateway returns; our guide to card declined reasons explains the common ones.

3. Recovery rate after retries

What it tells you: how much of the initially failed amount your dunning process recovers.

Formula: amount recovered from initially failed payments ÷ total initially failed amount × 100.

Example: 87 failed charges worth R43,500.00; R26,100.00 recovered through retries and reminders within 14 days. Recovery rate = 60%.

What moves it: retry timing, clear failed-payment emails with a pay link, and making card updates easy. See dunning management.

4. Unpaid debit order rate

What it tells you: the share of debit order collections returned unpaid by the customer's bank.

Formula: number (or value) of unpaid collections ÷ number (or value) of collections submitted × 100.

Example: 800 debit orders submitted; 36 returned unpaid. Unpaid rate = 4.5%.

What moves it: collection date relative to customers' payday, correct bank details, clear mandates, and re-presenting unpaids at a sensible time. Also track disputes separately from insufficient funds, because they point to different problems.

5. Days sales outstanding (DSO)

What it tells you: on average, how many days it takes to collect after a sale on credit.

Formula (simple version): closing receivables ÷ credit sales in the period × days in the period.

Example: R180,000.00 receivables at month-end; R420,000.00 credit sales in a 30-day month. DSO ≈ 12.9 days.

What moves it: your payment terms, how quickly you invoice, and how quickly you follow up. Compare DSO with your standard terms: 30-day terms with a DSO of 45 days means customers are paying late on average.

6. Effective cost of payments

What it tells you: what it costs to collect each rand.

Formula: total payment fees (gateway, bank, debit order, chargeback fees) ÷ total collected × 100.

Example: R9,870.00 in fees on R394,800.00 collected. Effective cost = 2.5%.

What moves it: payment method mix, gateway pricing, failed transaction fees and chargebacks. Break it down by method and gateway. Check each provider's current pricing page rather than relying on old rate cards.

7. Auto-reconciliation rate

What it tells you: how much of your incoming money is matched to invoices without manual work.

Formula: payments matched automatically ÷ total payments received × 100.

Example: 1,420 payments received; 1,306 matched automatically; 114 needed manual work. Auto-reconciliation rate ≈ 92%.

What moves it: consistent payment references, gateway payments linked to invoices, statement imports and good matching rules. Unreconciled items are also where errors and fraud hide.

8. Chargeback and dispute rate

What it tells you: how often customers dispute card payments or debit orders.

Formula: number of chargebacks or disputes ÷ number of transactions × 100.

What moves it: recognisable statement descriptors, clear billing, easy cancellation and warnings before renewals. Card schemes and acquirers monitor dispute levels, so a rising trend needs attention early.

Putting the KPIs on one page

(Figures illustrative.) Set targets from your own trend rather than borrowed benchmarks, give each KPI an owner, and add one line of commentary for anything that moved noticeably.

Common mistakes

• Mixing attempts and invoices in success-rate figures, which makes retries look like failures.
• Moving cut-offs, so collection rates aren't comparable month to month.
• Averaging across payment methods, hiding a problem in one gateway or one debit order batch.
• Tracking too many KPIs. Eight is plenty; many teams start with four.

How CentraPoint helps

CentraPoint keeps invoices, gateway payments, Netcash debit order batches and recorded EFT and cash payments together, so most of these KPIs can be built from one data set. Statement import and reconciliation auto-match collections, unpaids, fees and payouts, with an exception queue for the rest. The standard reports and report builder let you save KPI reports, schedule them by email and export to CSV or XLSX. Read more about reconciliation in the docs.

Frequently asked questions

What are the most important payment KPIs?

For most finance teams: collection rate, payment success rate, days sales outstanding and effective cost of payments. Add unpaid debit order rate if you collect by debit order, and auto-reconciliation rate as volumes grow.

How do you calculate collection rate?

Divide the amount collected on invoices due in the period by the total amount due, and multiply by 100. Use a fixed cut-off date so months are comparable.

What is a good DSO?

It depends on your terms and industry. Compare DSO with your standard payment terms and your own history; a DSO well above your terms means customers are paying late.

How often should payment KPIs be reviewed?

Monthly for the full set, with a weekly look at collections and failed payments so problems are caught quickly.