Free Download · Excel workbook · 10 tabs · 153 formulas
Reconciliation Control Register Template
The failure mode analysis worksheet extended with ICFR-testable control mapping. Fifty-three failure modes pre-populated across bank, TDS, GSTR-2B, and GSTR-1 vs 3B streams — each row already carrying its Section 143(3)(i) ICFR flag and its ICAI SA 315 risk level. A working artifact for internal audit, ICFR consultant, and statutory audit preparation.
What's inside — 6 components
12-class function-level failure mode taxonomy reference
A single-page classification schema for the twelve function-level failure modes reconciliation processes are actually exposed to — from missed match to false accept to duplicate posting — with plain-English definitions and the reconciliation-specific example each maps to. The vocabulary every downstream tab keys off.
SOD anchor scale S1–S10 with Indian statute anchors
A ten-point Severity of Detection scale calibrated to Indian statutory consequence — Section 16(4) time-barred ITC anchoring S10 at the top, down through Section 143(1) intimation, TDS 201(1A) interest, 234-series interest, statutory notice, and material variance, to trivial petty-cash class at S3. Every failure-mode row picks a severity from this scale, not a made-up number.
Action Priority 3×3×3 lookup replacing RPN
A 27-cell Action Priority matrix (High / Medium / Low across severity × occurrence × detectability) that replaces the traditional Risk Priority Number multiplication — because a 2 × 5 × 5 = 50 and a 5 × 5 × 2 = 50 are not the same audit conversation. Lookup-driven so each failure-mode row surfaces its priority without a manual calculation.
4 pre-populated control registers with 20 columns each
Four working registers covering the four reconciliation streams a mid-sized Indian finance function actually runs — Bank (14 controls), TDS (14 controls), GSTR-2B (14 controls), and GSTR-1 vs 3B (11 controls). Twenty columns per row including ICFR Testable Y/N, SA 315 Risk Level, Test Frequency, Evidence Retained, Owner, Reviewer, and Status — the exact columns a statutory auditor or ICFR consultant asks for on day one.
ICFR Test Plan Summary — auto-populated
A single summary tab that reads across all four control registers and auto-populates the ICFR test plan bucket: 40 controls classified SA 315 High-risk (annual walkthrough + quarterly re-performance) and 13 classified Medium (annual walkthrough + sample-based re-performance). No manual roll-up — change a risk level in a register and the summary re-computes.
Formula Reference — LibreOffice-compatible
A documented formula reference showing every INDEX / MATCH, SUMIFS, COUNTIF, and nested-IF pattern the workbook uses. Deliberately no XLOOKUP, FILTER, or SORT — so the workbook opens and runs unchanged in LibreOffice Calc, older Excel installs, and the audit-firm laptops that still ship with Office 2019.
Illustrative data included.
The four registers ship pre-populated with 53 illustrative failure-mode rows across the
four reconciliation streams — invented control IDs, invented owners, invented evidence
references — so every formula, lookup, ICFR flag, SA 315 classification, and Test Plan
Summary roll-up is visibly wired up on first open. A
REPLACE WITH YOUR CONTROL DATA note sits on each register tab —
calibrate the pre-populated rows to your actual control environment before the audit-committee handoff.
Get the Workbook
The download appears immediately below — no wait, no follow-up call.
Your Workbook is ready
Download reconciliation-control-register-template.xlsx →Submission failed. You can still download the Workbook directly.
Where this workbook fits
This is the audit-ready operational asset for reconciliation control design. Read the pillar it sources from, the parent article it operationalises, the companion online worksheet, or the book-length reference.
Reconciliation Failure Mode Analysis — India Pillar
The full pillar the twelve-class taxonomy and Action Priority matrix are sourced from — where the method comes from, how it applies to reconciliation specifically, and why RPN misleads audit conversations.
Reconciliation Control Plan Template — India
The parent article this workbook operationalises: what a control plan for an Indian reconciliation function contains, how it maps to ICFR, and the columns every audit-ready register carries.
Action Priority vs Materiality in Reconciliation
Why an Action Priority matrix and a materiality threshold answer different questions — and how to use them together without collapsing one into the other.
Severity, Occurrence, Detection in Reconciliation
The three axes calibrated for reconciliation work: what a severity 8 vs 4 actually looks like on the ledger, how to score occurrence honestly, and why detection is usually the underweighted axis.
6P Cause Taxonomy for Reconciliation
People, process, policy, platform, provider, and posting — the six-cause taxonomy that turns "supplier error" into a fix you can actually assign to an owner.
Reconciliation Process Design Worksheet — Web Tool
The companion online worksheet: an empty-template starter for teams beginning their first design pass. Where this Excel workbook lands as the pre-populated, audit-ready extension.
Reconciliation Process Design — Free eBook
The companion book-length reference: the design method behind both the online worksheet and this control-register workbook, with worked examples and audit-committee narrative.
Reconciliation Software India
The automated equivalent — what a live continuous-controls reconciliation looks like when a spreadsheet register stops scaling to the volume the audit committee is asking about.
Frequently Asked Questions
Is the workbook 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.
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 Process Design Worksheet at /tools/reconciliation-process-design-worksheet/?
The online worksheet is an empty-template starter — a blank canvas your team fills in as it works through the first design pass on a single reconciliation. This Excel workbook is the pre-populated extension of that same method: the 53 failure modes across bank, TDS, GSTR-2B, and GSTR-1 vs 3B streams are already in place; each row already carries an ICFR Testable flag, an SA 315 risk level, a test frequency, and an evidence-retained note; and the ICFR Test Plan Summary already rolls up 40 SA 315 High-risk and 13 Medium-risk controls. The online worksheet is where a team starts. This workbook is what a team hands off to an internal auditor, ICFR consultant, or statutory audit team when the design pass needs to survive an audit conversation.
Disclaimer.
The 53 pre-populated failure-mode rows across the four reconciliation streams are
illustrative only — invented control IDs, invented owners, invented evidence references,
invented reviewer names — so every formula, lookup, ICFR Testable flag, SA 315 classification,
and ICFR Test Plan Summary roll-up has something to compute against on first open. Calibrate
the pre-populated rows to your actual control environment, control frequencies, and evidence
artefacts before an audit-committee handoff or statutory-audit walkthrough. This workbook is
a working template, not audit advice; validate ICFR classification, SA 315 risk-level
alignment, and Section 143(3)(i) applicability with your internal audit head, ICFR consultant,
or statutory auditor before relying on it for a formal audit record.
When the register stops scaling
A spreadsheet register lands the design pass and survives the first audit conversation. Past that — once controls need to run continuously, evidence needs to be captured automatically, and SA 315 re-performance needs an audit trail rather than a manual sample — a live continuous-controls reconciliation makes sense. TransactIG configures in 2–4 weeks. ISO 27001:2022 certified.