Bank Reconciliation in Tally and Accounting Software: How to Identify Timing Differences and Errors

In corporate bookkeeping, the bank ledger in your accounting software and your physical bank account statement represent two independent records of the exact same financial transactions. Yet, at any given month-end, the closing balances in these two records almost never match.

A Bank Reconciliation Statement (BRS) is the foundational internal control schedule that systematically bridges this gap. Preparing a timely BRS prevents fraudulent diversions, identifies bank overcharges, ensures statutory compliance, and provides management with true, actionable cash visibility.

Learn more about our outsourced Bookkeeping & Accounting Management.

Reconciliation discrepancies fall into three distinct functional categories:

Tally Prime provides both manual and electronic bank reconciliation workflows:

Manual BRS Workflow:

1. Navigate to Gateway of Tally > Banking > Bank Reconciliation.
2. Select the specific Bank Ledger to view the transaction schedule.
3. Press F5 (Reconcile) to display the Bank Date column alongside the voucher date.
4. Compare each line with your physical bank passbook or e-statement. Enter the actual date the cheque or transfer cleared the bank.
5. Watch the Balance as per Company Books and Balance as per Bank synchronize. The "Difference" line must reach zero.

Auto BRS Workflow (Using Bank E-Statements):

1. In the Bank Ledger Master, set Enable Auto BRS to "Yes" and select your bank.
2. Download the monthly statement from net banking in `.xlsx`, `.csv`, or `.xml` format.
3. Open the BRS screen in Tally Prime, click Alt + B (Bank Statement), and import the downloaded file.
4. Tally will auto-match transactions based on Cheque/UTR reference numbers and amounts, displaying an instant summary of matched and unmatched rows.

Stale Cheques (> 90 Days):

Under the Negotiable Instruments Act, cheques are valid for only 3 months. If a cheque issued to a vendor has not been presented within 90 days, it becomes legally stale:

• Reverse the payment voucher by debiting the Bank Ledger and crediting the Creditor Account.
• Re-issue a fresh cheque or initiate a direct NEFT/RTGS transfer upon re-confirmation.

Unidentified Customer Credits:

Direct UPI or RTGS deposits without customer reference numbers must be parked in a dedicated Suspense / Unidentified Receipts Ledger until matched against sales orders. Never leave them unaccounted in BRS.

• Complete BRS on or before the 5th of every month for the preceding period.
• Ensure bank charges and interest certificates are downloaded and booked under proper expense/income heads.
• Verify that overdraft (OD) or cash credit (CC) limit interest matches the bank's sanctioned interest rate.
• Obtain a formal sign-off from the Finance Manager and attach the BRS to the monthly management reporting pack.

For professional bookkeeping clean-up and accounting automation, consult the D BIZ Accounting Desk.