Free Download · 67-Page PDF
The Reconciliation Manager's Field Guide
The day-by-day playbook for running the Indian monthly close as a 20-day cadence — bank Days 1–5, TDS Days 6–10, GSTR-2B ITC Days 11–15, GSTR-1 vs 3B Days 16–20. Four runbooks, four Excel/Sheets recipes, three detective cases, three letter template packs, and two catch-up manuals. Every step has a named role, a statute anchor, and a sign-off gate.
What's inside — six parts and three appendices
Part I — The 20-Day Monthly Close Framework
The umbrella cadence: bank on Days 1–5, TDS on Days 6–10, GSTR-2B ITC on Days 11–15, GSTR-1 vs 3B on Days 16–20. Each window has a named owner, an entry gate, an exit gate, and a hand-off condition so nothing lands on the next window with unresolved variances.
Part II — The Four Stream Runbooks
Bank reconciliation Days 1–5 (MT940 + narration + CARO 2020 sign-off), TDS reconciliation Days 6–10 (Section 393 payment codes 1001–1092 + Form 168 shortfall check), GSTR-2B ITC reconciliation Days 11–15 (2B vs purchase register vs IMS actions, Section 16(4) countdown), GSTR-1 vs 3B reconciliation Days 16–20 (turnover reconciliation + DRC-01B triage). Day-by-day tasks with role labels and statute anchors.
Part III — The Four Excel Recipes
Narration parsing (regex + LEFT/MID/FIND for UTR, cheque number, counterparty extraction), three-way ITC match (purchase register vs 2B vs IMS with dropdown categorisation and at-risk queue), TDS receivable aging (challan-to-return-to-Form-26AS with days-outstanding buckets), platform settlement decomposition (gross sale → commission → GST on commission → TDS 194-O → net remit, one row per order).
Part IV — The Detective Series
Three worked cases: the Rs 47,236 unreconciled credit (five-day trail from bank statement to buried NEFT to intercompany transfer to correct GL), the Form 168 shortfall (deductor filed Form 168 with wrong payment code — how the deductee catches it and files the 72-hour response), the DRC-01B 72-hour triage (portal notice arrives, the 72-hour clock starts, the reconciliation-first response that closes it without payment).
Part V — The Blackbook
Three letter template packs, escalation-sequenced. Vendor GSTR-1 follow-up (6 letters: Day 5 reminder → Day 10 formal → Day 15 escalation to vendor CFO → Day 20 CA-signed → Day 25 legal notice hint → Day 30 credit-hold instruction), deductor Form 168 query (5 letters: Day 5 shortfall notification → Day 10 payment-code query → Day 15 supporting-docs demand → Day 20 escalation → Day 25 auditor-copy), aggregator settlement dispute (4 platform-specific packs: Razorpay, PayU, Cashfree, Amazon).
Part VI — Catch-Up Manuals
Two rescue playbooks for teams that have fallen behind. The 90-day GSTR-2B catch-up manual (three months of unreviewed 2B files, IMS actions logged retroactively, at-risk credits triaged before the November 30 Section 16(4) deadline). The TDS pre-March-31 correction sprint (Form 26Q/27Q corrections, payment-code fixes, deductee-level restatement, all before year-end closes the correction window).
Appendix A — Downloadable Asset Index
Cross-reference to every free asset on the Terra Insight resources hub — workbooks, letter packs, calculators, catalogues, checklists — with the specific runbook step each one plugs into.
Appendix B — Statute Reference
One-page anchors: Section 393 payment codes 1001–1092 (2026 TDS regime), Section 16(4) (ITC cut-off), Section 43B(h) (MSME payment deduction), DRC-01B (ITC-mismatch notice), IMS (Invoice Management System), Form 168 (deductor challan), CARO 2020 (bank reconciliation reporting), ICAI SA (audit sampling references).
Appendix C — Terra Insight Product Bridge
Where the manual runbooks stop scaling: which parts of the 20-day cadence continue to fit an Excel/Sheets workflow, and which crossover point (volume, supplier count, entity count, IMS frequency) makes a live reconciliation platform the cheaper option.
67 pages, cross-referenced.
Every runbook step in Parts II–VI names the specific Terra Insight insights article,
free workbook, or letter pack that goes deeper on that step — so a reader can either
work straight through the eBook cover-to-cover or use it as an index into the site's
full library. Written for finance controllers, GST managers, TDS deductees, and CA-firm
engagement teams running the Indian monthly close as a repeatable process.
Get the Field Guide
The download appears immediately below — no wait, no follow-up call.
Your Field Guide is ready
Download reconciliation-manager-field-guide.pdf →Submission failed. You can still download the Field Guide directly.
Where this Field Guide fits
The eBook indexes into the wider Terra Insight library — two pillar articles it operationalises, the four companion workbooks it references, the three letter packs it embeds, the toolkit it plugs into, and the software crossover point it names in Appendix C.
Monthly Close Playbook — India Pillar
The umbrella methodology this field guide operationalises: the four-leg model (bank, TDS, GST, platform settlements) sequenced across a 20-day cadence.
Reconciliation Failure Mode Analysis — India Pillar
The diagnostic pillar for what goes wrong and why. The F2 eBook is its methodology sibling — same 20-day frame, but organised by failure signature instead of daily runbook.
Three-Way ITC Reconciliation Workbook
Companion Excel workbook for the Days 11–15 GSTR-2B stream: purchase register vs 2B vs IMS actions with the Section 16(4) at-risk queue pre-wired.
Bank Narration Parser Workbook
Companion Excel workbook for the Days 1–5 bank stream: regex-based extraction of UTR, cheque number, and counterparty from raw HDFC/ICICI/SBI narration strings.
TDS Receivable Aging Workbook
Companion Excel workbook for the Days 6–10 TDS stream: challan-to-return-to-Form-26AS reconciliation with aging buckets for deductee-side follow-up.
Vendor GSTR-1 Follow-Up Letter Pack
The six-letter escalation pack referenced in Part V — Day 5 reminder through Day 30 credit-hold instruction, editable Word/Google Docs.
Deductor Form 168 Query Letter Pack
The five-letter Form 168 pack referenced in Part V — shortfall notification through auditor-copy, with the payment-code query template pre-filled.
Aggregator Settlement Dispute Letter Pack
The four-platform pack referenced in Part V — Razorpay, PayU, Cashfree, and Amazon dispute letters with per-platform ticket-format quirks baked in.
Controller's Toolkit
Sibling free bundle: close checklist, variance-classification reference, CSV templates, calculator index — the operational scaffolding this field guide references throughout.
Reconciliation Software — India
The automated equivalent — what a live reconciliation platform looks like when the 20-day manual cadence stops scaling (Appendix C explains the crossover point).
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.
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.
Can I share it with my team or my auditor?
Yes, we welcome forwarding. Share it with your finance team, your CA, your internal auditor, your ERP consultant — anyone who works on the Indian monthly close. The eBook complements the site articles rather than replacing them; each part cross-references the underlying Terra Insight insights posts so a reader can go deeper on any single runbook, recipe, or letter template.
Disclaimer.
The worked examples in Part IV (Rs 47,236 unreconciled credit, Form 168 shortfall,
DRC-01B 72-hour triage) and every rupee figure elsewhere in the eBook are illustrative
only — invented amounts, invented supplier and deductor names, invented UTRs — chosen to
make each detective case walk through a specific reconciliation pattern. This Field Guide
is a working reference, not tax advice; verify statutory decisions against your GST advisor
or Chartered Accountant before filing.
When the 20-day cadence stops fitting a workbook
Excel and Google Sheets carry a monthly close cleanly up to a threshold. Past that — more entities, more supplier GSTINs, IMS running continuously instead of once a month, platform settlement files arriving daily rather than monthly — the runbooks in this Field Guide need a live reconciliation platform underneath to keep working. Appendix C names the crossover point. TransactIG configures in 2–4 weeks. ISO 27001:2022 certified.