Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A finance controller at an IT services company started tracking reconciliation KPIs after the company received its second GST demand notice in 18 months. The first metric calculated: the GSTR-2B match rate for the prior 12 months was 69%. Industry benchmark: 80–88%.
The gap explained the demand notices — 31% of GSTR-2B transactions were being manually reviewed, with a 3–5% error rate in manual matching generating excess ITC claims. Fixing the match rate to 85% eliminated the demand notice risk.
The KPI was available all along. It was not being tracked.
The Six Core Reconciliation KPIs
KPI 1: Auto-Match Rate
Definition: Percentage of transactions matched automatically, without human intervention.
Formula: (Transactions auto-matched ÷ Total transactions) × 100
Targets by type:
| Reconciliation type | Minimum acceptable | Target | Best-in-class |
|---|---|---|---|
| Bank vs cash book | 80% | 90% | 96% |
| TDS vs Form 26AS | 65% | 80% | 90% |
| GSTR-2B vs purchase register | 70% | 85% | 90% |
| Platform settlement | 70% | 88% | 95% |
| NACH batch vs mandates | 65% | 85% | 92% |
How to use: Monitor monthly. A decline of more than 5 percentage points month-over-month requires immediate root cause investigation — do not wait for the next month.
KPI 2: Days to Close
Definition: Business days from the last day of the reconciliation period to the completion and sign-off of all reconciliations.
Formula: Date of sign-off − Date of period end (in business days)
Targets:
- Bank reconciliation: Day 2
- Platform settlement: Day 3
- TDS reconciliation: Day 5
- GSTR-2B reconciliation: Day 5 (must be before GSTR-3B filing on Day 20)
- Full reconciliation sign-off: Day 7
How to use: Plot the close date for each reconciliation type across 12 months. A trend toward later close dates signals increasing backlog or process degradation.
KPI 3: Exception Resolution Rate
Definition: Percentage of reconciliation exceptions resolved within their target SLA.
Formula: (Exceptions resolved within SLA ÷ Total exceptions generated) × 100
Target: 90% of exceptions resolved within SLA.
An exception resolution rate below 80% means 20% of exceptions are breaching SLA — these become the aging items that generate regulatory risk.
KPI 4: Exception Aging Distribution
Definition: Percentage of open exceptions by age bucket.
Target distribution:
- 0–7 days (within SLA): 70%+ of open exceptions
- 8–30 days (approaching deadline): less than 25%
- 31–90 days (at risk): less than 5%
- 90+ days (critical/unrecoverable risk): 0% target
When the 31–90 day bucket exceeds 5%, the backlog is growing and the ITC claim deadline risk is increasing. When 90+ items exist, some may be past the recovery window.
KPI 5: ITC Leakage Rate
Definition: Percentage of eligible ITC not claimed or reversed due to reconciliation failure.
Formula: (ITC available in GSTR-2B − ITC successfully claimed in GSTR-3B) ÷ ITC available × 100
Target: Below 1%. Above 2% is a significant control issue.
At ₹5 crore monthly purchases at 18% GST, even a 1% ITC leakage rate is ₹9,000 per month — ₹1.08 lakh per year. At ₹50 crore monthly, it is ₹10.8 lakh per year.
KPI 6: TDS Credit Recovery Rate
Definition: Percentage of TDS booked as receivable that is successfully recovered through Form 26AS and set off against advance tax.
Formula: (TDS recovered in ITR ÷ TDS receivable booked in period) × 100
Target: Above 95%. A rate below 90% indicates systematic deductor errors, missed correction requests, or outdated TAN registers.
KPI Dashboard Design
A reconciliation KPI dashboard for CFO review should show:
- Current month vs target: Each KPI vs its target, with red/amber/green status
- 12-month trend: Each KPI plotted over the last year to show direction
- Exception aging heatmap: Visual distribution of open exceptions by age and type
- ITC and TDS value at risk: Total rupee value of exceptions in the 31–90 day and 90+ day buckets
- Close cycle comparison: Actual close date vs target for each reconciliation type
This dashboard should require no manual compilation — it should be generated automatically from the reconciliation system as a scheduled report.
Setting KPI Targets for Different Business Stages
KPI targets should reflect the current state of the business, not an aspirational ideal:
- Early stage (manual process): Focus on Days to Close and Exception Aging. Match rate improvement requires tooling investment.
- Growth stage (transitioning to automation): Focus on Auto-Match Rate improvement. Target 80% match rate in year 1, 88%+ by year 2.
- Mature stage (automated): Track all six KPIs. The focus shifts from process establishment to continuous improvement and benchmark comparison.
Reconciliation software India that generates all six KPIs automatically — from the matching engine’s output — produces the CFO dashboard without additional reporting overhead. The KPIs are a byproduct of the reconciliation process, not a separate reporting exercise.
TDS reconciliation software with deductor-level match rate and TDS credit recovery rate tracking gives the finance team the specific data they need to manage TDS KPIs at the counterparty level — identifying which deductors are dragging the overall TDS credit recovery rate below target.
The Institute of Chartered Accountants of India publishes guidance on internal control performance measurement — which includes the framework for setting and monitoring KPIs for core finance functions including reconciliation.