Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
Without KPIs, reconciliation quality is judged retrospectively at audit. A 69% GSTR-2B match rate — 31% manual review with 3–5% error — quietly produces excess ITC claims and Section 50 interest notices that no monthly review would have caught.
Track six KPIs: auto-match rate, days-to-close, exception resolution rate, exception ageing, ITC leakage, and TDS credit recovery. Review match rate and ageing weekly, close cycle monthly, ITC leakage and TDS recovery quarterly (aligned with GST and advance tax). Investigate any downward drift immediately rather than waiting for a demand.
Per-type KPI dashboard, target thresholds (match rate above 85%, close by day 5, ITC leakage below 2%, TDS recovery above 90%), and weekly/monthly/quarterly review cadence by role.
A finance controller and CFO view of reconciliation health that flags deterioration early, prevents notices, and produces a benchmarked year-end KPI scorecard.
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.