Free Download · 64-Page PDF
The Reconciliation Process Design eBook
The failure mode analysis methodology for Indian finance reconciliation, in one 64-page PDF. Severity anchors tied to Section 16(4) permanent loss, Section 200A demand notices, DRC-01B triggers, CARO 2020 observations, Section 201(1A) interest, and Ind AS 21 forex restatement. Four stream-specific failure mode taxonomies. Seven detection techniques and seven prevention controls with the volume ceilings past which each stops working. A one-page control plan template you can lift into your next audit committee pack.
What's inside — 6 parts
Part I — The Methodology
The 12-class function-level failure mode taxonomy for Indian reconciliation. The Severity-Occurrence-Detection anchor scale, calibrated to Indian statutory consequences rather than borrowed abstractions. Action Priority replaces materiality and Risk Priority Number so a Severity-10 permanent-loss row cannot be washed out by a low-occurrence score. The 6P cause taxonomy — People, Policy, Process, Portal, Period, Partner — a finance-native replacement for cause categories designed for a physical production line.
Part II — The Four Stream-Specific Failure Mode Analyses
Invoice to Bank — 14 failure modes across UTR mismatch, partial settlements, currency conversion drift, and reversal timing. TDS receivable against Form 168 — 14 failure modes across cross-era rate boundary errors, deductor-side section-code slippage, and quarterly cadence gaps. GSTR-2B input tax credit — 14 failure modes with the Section 16(4) November 30 permanent loss row anchored at Severity 10. GSTR-1 versus GSTR-3B — 11 failure modes with the DRC-01B demand row anchored at Severity 8.
Part III — Manual Detection and Prevention
The seven manual detection techniques a finance team actually has — ratio analysis, tick-and-tie, exception aging, peer review, cutoff testing, sample-based reperformance, and analytical review — each documented with the volume ceiling past which it stops catching the failures it was supposed to catch. Then the seven prevention controls that stop the failure earlier: templates, cutoff calendars, approval matrices, dual-key sign-off, training curricula, master-data governance, and vendor onboarding gates.
Part IV — When Manual Outgrows Itself
The 14-row manual-versus-automated comparison, framed as a failure mode comparison rather than a feature comparison. Five quantified thresholds — transaction volume, supplier count, stream complexity, statutory penalty exposure, and audit observation history — that tell a controller when the manual process has stopped covering the risk. The CA-firm portfolio-scale process design chapter for practices running the same reconciliation across 50 or more client engagements.
Part V — The Working Artefacts
The one-page reconciliation control plan template that lifts straight into an audit committee pack — with four filled examples covering an invoice-to-bank stream at a manufacturing controller, a TDS receivable stream at an IT services CFO, a GSTR-2B stream at a distribution finance manager, and a GSTR-1 versus 3B stream at a retail head-of-finance. Every High-Priority row on the control plan traces back to a Severity-Occurrence-Detection score in Parts I to IV.
Plus Appendices
Quick-reference cards for the SOD anchor scale and the 12-class failure mode taxonomy — printable, one page each. A link to the companion Excel worksheet that operationalises the control plan template. And the Terra Insight product bridge — where the failure modes documented in Parts II and III correspond to features that stop being manual and start being automated.
Illustrative data throughout.
Every worked example, filled control plan row, and scored failure mode uses invented
supplier names, invented invoice numbers, and invented amounts so the reader sees the
method wired up end-to-end. No customer data, and no customer names, appear anywhere in
the eBook. Score your own stream against your own ledger before circulating the control
plan inside your organisation.
Get the eBook
The download appears immediately below — no wait, no follow-up call.
Your eBook is ready
Download reconciliation-process-design-ebook.pdf →Submission failed. You can still download the eBook directly.
Where this eBook fits
This is the design-layer methodology in the Terra Insight reconciliation library. Pair it with the operations-layer Field Guide, the monthly close playbook it feeds, and the companion worksheet that operationalises the control plan.
Reconciliation Failure Analysis — The Pillar Method
The web pillar this eBook expands on: the seven-step design discipline that installs failure analysis on top of every stream a finance team runs.
Monthly Close Playbook — India Pillar
Sibling methodology pillar: the day-by-day close cadence across bank, TDS, GST-1/3B, and GSTR-2B legs. Design layer and operations layer used together.
Reconciliation Manager Field Guide (F1 eBook)
The operations-layer sibling: day-by-day close-week playbook, hand-off scripts, escalation ladders. Complementary to this design-layer eBook — use both.
Reconciliation Process Design Worksheet
The companion Excel worksheet: severity scoring cells, cause-tagging dropdowns, and the control plan template pre-wired so a controller can score their own stream in one sitting.
Controller's Toolkit
Sibling free bundle: close checklist, variance-classification reference, CSV templates, calculator index. The everyday desk kit alongside this eBook.
Reconciliation Software India
The automated equivalent — what the failure modes in Parts II and III look like when detection and prevention stop being manual and start being continuous.
The full failure mode analysis cluster — 14 articles
Every part of the eBook has an in-depth web companion. Read a single brief for a specific stream, or read the pillar for the full method.
Reconciliation Failure Analysis — Pillar
The Anchored SOD Rating Scale
Action Priority vs Materiality
The 6P Cause Taxonomy
Invoice to Bank — Failure Modes
TDS Form 26AS / Form 168 — Failure Modes
GSTR-2B ITC — Failure Modes
GSTR-1 vs GSTR-3B — Failure Modes
Manual Detection Techniques
Prevention Controls for Manual Reconciliation
When Manual Reconciliation Tops Out
The One-Page Control Plan Template
Failure Analysis for CA Firms
Manual vs Automated — Failure Mode Comparison
Frequently Asked Questions
Is the eBook really free?
Yes. There is no charge and no trial period. The download link appears immediately on this page after you submit the form — nothing is emailed to you first, and there is no waiting period. The 64-page PDF is unwatermarked, unlocked, and yours to circulate inside your finance team or share with an auditor.
What happens after I submit the form?
The download link appears immediately on this page — nothing is emailed to you first, and there is no waiting period. We use your details to send an occasional update on Indian reconciliation (statutory changes, new calculators, worked examples); you can ignore or unsubscribe from those at any time without losing access to the download you already have.
How does this differ from the Reconciliation Manager Field Guide eBook?
This eBook is the design layer — how to think about failure modes and rate them, how to anchor severity to a Section 16(4) permanent loss versus a Section 201(1A) interest tick, how to build a control plan the internal auditor can test. The Reconciliation Manager Field Guide is the operations layer — the day-by-day close-week playbook, hand-off scripts, and escalation ladders a controller runs on the ground each month. Both are complementary. Design once with this eBook, operate every month with the Field Guide.
Disclaimer.
Every worked example and every filled control plan row in the eBook is illustrative —
invented supplier names, invented invoice numbers, invented amounts — so the reader sees
the method wired up end-to-end. No customer data, and no customer names, appear anywhere.
The severity anchors, statutory references, and taxonomies are Terra Insight editorial
judgment against publicly-available Indian tax and audit rules; verify statutory
classification decisions against your Chartered Accountant or GST advisor before acting
on them. Author: Terra Insight Editorial Team.
When the control plan needs a live system underneath it
Manual detection and prevention hold up to a defined volume. Past the thresholds documented in Part IV — or once the Section 16(4) November 30 deadline is arriving with unmatched ITC still open — the failure modes require continuous detection, not monthly. TransactIG configures in 2–4 weeks. ISO 27001:2022 certified. Hosted in AWS Mumbai, DPDP-aligned.