Skip to main content
Banking · 5 min read

Opening Balance Reconciliation in India: Resolving Month-Start Discrepancies

Opening balance reconciliation is the first control check of every new accounting period — confirming that the opening balance in the books matches the prior period's closing balance. For Indian companies running monthly reconciliation across multiple bank accounts, GST ledgers, and TDS receivables, opening balance discrepancies are the first detection point for prior-period errors that were not resolved. This guide covers the common causes and resolution sequence.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 21 March 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

Opening balance mismatches across bank, TDS receivable, and GST ITC ledgers signal unresolved prior-period errors — most commonly NACH credits received on the last working day, TDS wrongly booked in the wrong quarter (Form 26AS variance), or GST credit notes booked in March but appearing in April GSTR-2B. Left unresolved, they cascade into every subsequent reconciliation.

How It's Resolved

Opening balance reconciliation runs a four-ledger cut-off check on the first day of every period: bank book opening equals prior-month bank statement closing adjusted for outstanding items; TDS receivable opening equals cumulative Form 26AS balance; GST ITC opening equals prior GSTR-3B Table 6B closing; cash-on-hand opening equals prior physical count. Variances are classified (timing, quarter-mismatch, cut-off error) and routed to a prior-period adjustment journal.

Configuration

Four-ledger cut-off check (bank, TDS, GST, cash), Schedule III materiality threshold (typically ₹5 lakh), and prior-period-adjustment GL posting rules.

Output

Opening balance sign-off per ledger, prior-period adjustment journal entries per Companies Act 2013 Schedule III, variance audit trail for each cause category, and Board-report-ready materiality disclosure.

Opening balance reconciliation in India is the control step that confirms the beginning balance of every account — bank, TDS receivable, GST ITC — matches the audited closing balance of the prior period. For companies running monthly reconciliation across 5 or more bank accounts alongside GST and TDS ledgers, this check is not administrative: it is the earliest detection point for errors that propagated from a prior period without being resolved.

What Opening Balance Reconciliation Is

Opening balance reconciliation verifies that the opening balance recorded in the books of accounts at the start of a new accounting period equals the closing balance of the immediately preceding period — after all entries, adjustments, and reversals have been posted.

For bank accounts, this means the book opening balance must equal the bank statement closing balance from the last day of the prior month, adjusted for any outstanding items (deposits in transit, outstanding cheques) that carried forward. For GST ITC ledgers, the opening balance must match the closing ITC balance from the prior month’s GSTR-3B. For TDS receivables, it must align with the cumulative TDS credit per Form 26AS as at the prior period end.

The importance of the check is that any undetected error from the prior period — a missed posting, a duplicate entry, a cut-off error — will cause the current period’s reconciliation to fail from the first line.

The Four Main Causes in the Indian Context

NACH Credits Received After Period-End

NACH (National Automated Clearing House) credits from NPCI are processed in batch cycles. A NACH mandate instructed for the 31st of the month may clear in the bank on 31st but reach the company’s ERP via the bank statement file only on 1st of the following month. If the ERP auto-posts on statement receipt date, the credit lands in the new period — creating an opening balance variance equal to the NACH credit amount. For companies with high NACH collection volumes (collections from dealers, EMI receipts, franchise payments), this pattern affects multiple credits in the same month-end cycle.

TDS Receivable Posted in the Wrong Period

TDS deducted under Section 194C (contractors), 194J (professional services), or 194H (commission) is deductible when the payment is made by the counterparty, not when the Form 16A certificate is issued. Companies that book TDS receivables on certificate receipt rather than payment date will consistently post TDS in the wrong period, creating opening balance mismatches in the TDS receivable ledger at every quarter-end.

GST Credit Note Posted Late

If a supplier issues a GST credit note for a purchase invoice that was already paid and booked in the prior period, and the credit note arrives in the new period, the ITC reversal or adjustment must be posted in the current period. If the accounts payable team books the credit note in the prior period (to match the original invoice), the GST ITC ledger closing balance will differ from what GSTR-2B shows — propagating into an opening balance variance in the new period.

Inter-Bank Transfer Not Cleared

An inter-bank RTGS or NEFT transfer initiated on the last working day of the month may leave Bank A on that date but credit Bank B only on the next working day. If the books record the debit from Bank A and the credit to Bank B on the same date, but the bank statement for Bank B shows the credit the following day, the Bank B opening balance will be understated by the transfer amount.

Resolution Sequence

The correct resolution sequence for an opening balance mismatch starts with the bank statement and works backward through the journal entries.

Step 1: Start with the bank statement. Pull the prior month’s final bank statement and confirm the closing balance. This is the authoritative figure. Any difference between the book closing balance and the bank closing balance from the prior period defines the opening variance.

Step 2: Check the BRS for unresolved items. Review the prior-period Bank Reconciliation Statement for items that were listed as outstanding and were expected to clear. If those items have since cleared in the bank but were not posted in the books, they are the source of the opening balance variance.

Step 3: Identify the period of origination. For each unresolved item, determine whether it originated in the prior period or earlier. Prior-period items require adjustment entries; items from two or more periods back may require a prior-period adjustment disclosure.

Step 4: Pass correction entries. Post the correction journal entries with appropriate narration referencing the original transaction date, UTR number (for NEFT/RTGS items), or NACH mandate reference. Lock the prior period in the ERP after posting to prevent further entries.

Opening Balance Mismatch Reference Table

Mismatch TypeCommon CauseResolution StepTypical Resolution Time
Bank opening balance shortNACH credit cleared in bank on 31st, booked in ERP on 1stPost prior-period NACH credit; reopen prior period temporarily30–60 minutes per item
TDS receivable overstatedTDS booked on certificate date instead of payment dateReverse incorrect posting; re-post in correct period with Form 16A reference1–2 hours per quarter
GST ITC opening mismatchCredit note posted in wrong period by AP teamPass ITC adjustment in current period; reconcile with GSTR-2B ARN45–90 minutes per credit note
Inter-bank transfer gapLast-day RTGS credited to recipient bank next working dayMark as outstanding in prior-period BRS; clear in first week of current period15–30 minutes
Opening balance variance post-auditPrior-period adjustment entry missed during year-end closePass prior-period adjustment entry; disclose if material above ₹5 lakh2–4 hours including review

India-Specific Controls

Indian companies filing monthly GSTR-3B must ensure that the GST ITC opening balance in the books reconciles with the prior month’s GSTR-3B closing ITC balance before the current month’s return is filed. A mismatch here — caused by a late credit note or a supplier amendment in GSTR-1 — will cascade into the current month’s ITC claim and may attract notice under Rule 36(4) of the CGST Rules, which caps provisional ITC at 105% of the ITC available in GSTR-2B.

For TDS receivables, the opening balance should be verified against Form 26AS at the start of each quarter. Any TDS credit appearing in Form 26AS for the prior quarter that is not reflected in the TDS receivable ledger opening balance indicates a missed posting that must be corrected before the advance tax computation for the current quarter.

Reconciliation benchmarks India finance shows that finance teams with formal opening balance controls reduce period-start exceptions by 60–70% compared to teams that begin current-period reconciliation without verifying the opening balance.

Automated reconciliation software India that carries forward unresolved prior-period items as flagged opening exceptions — rather than silently rolling them into the current period — eliminates the most common source of recurring opening balance mismatches.

For companies managing GST ITC opening balances alongside bank reconciliation, GST reconciliation software that cross-references the books ITC ledger with GSTR-2B auto-populated data at period start catches credit note timing errors before GSTR-3B filing deadlines.

Opening balance verification and period-end reconciliation controls for Indian finance functions are addressed in guidance published by the Institute of Chartered Accountants of India (ICAI), including standards on prior-period adjustments and the documentation required for statutory auditors reviewing opening balances.

Primary reference: Institute of Chartered Accountants of India (ICAI) — where standards for opening balance verification and period-end reconciliation controls in Indian finance functions are published.

Frequently Asked Questions

What is the most common cause of opening balance mismatches in Indian bank reconciliation?
The most common cause is a NACH or ECS credit received on the last working day of the month that the bank posts on that date but the company's ERP records in the following period — a 1-day timing difference that creates an opening balance variance of exactly the credit amount. For companies processing 200 or more NACH mandates monthly, this timing mismatch can affect 5–12 transactions in any given month-end cycle.
How should a TDS receivable that was posted in the wrong period be corrected in the opening balance?
The correction requires a journal entry reversing the prior-period TDS receivable debit and re-posting it in the correct period. The TDS certificate (Form 16A or 16B) carries the quarter and financial year of deduction, which determines the correct period. If the TDS deduction was under Section 194C or 194J and was booked in Q3 but the certificate covers Q2, the correction must be made before filing the ITR for that financial year to avoid mismatch in Form 26AS.
How long does opening balance reconciliation typically take for a company with 5 bank accounts?
For a company with 5 bank accounts running monthly reconciliation, opening balance verification should take 30–60 minutes if the prior period was clean and signed off. If prior-period items were left unresolved, the investigation extends to 2–4 hours per account. Companies that automate opening balance carry-forward and flag unresolved prior-period items reduce this to under 15 minutes per account in 90% of months.
Can an opening balance mismatch in GSTR-2B affect the bank opening balance reconciliation?
A GSTR-2B mismatch does not directly affect the bank opening balance, but it can affect the ITC ledger opening balance. If a GST credit note was received from a supplier in March but not reflected in GSTR-2B until April, and the company booked the ITC in March, the ITC ledger opening balance for April will show a higher credit than what GSTR-2B supports — creating a GST reconciliation exception that must be resolved separately from the bank reconciliation.
What is the correct journal entry to correct an opening balance variance discovered in the current period?
The standard approach is a prior-period adjustment entry: debit or credit the relevant account (bank, TDS receivable, GST ITC) with a corresponding credit or debit to a Prior Period Adjustments account (under Other Income or Other Expenses per Schedule III of the Companies Act 2013). If the amount is material (typically above ₹5 lakh for mid-size companies or as defined in the accounting policy), it must be disclosed separately in the notes to financial statements.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.