What Is Bank Reconciliation in Tally?
Bank reconciliation in Tally is the process of comparing and matching:
- Tally's bank ledger — transactions you have entered in Tally under your bank account (payments, receipts, journal entries)
- Your actual bank statement — transactions recorded by the bank (credits, debits, charges, interest)
The goal is to ensure both records agree. Any difference must be identified, explained, and resolved. Tally ERP 9 and Tally Prime provide a dedicated Bank Reconciliation module under the Banking menu that automates the matching process once you import your bank statement.
Time-saving tip: The single biggest time saver in Tally bank reconciliation is importing your bank statement electronically (via CSV) instead of matching manually line by line. Our free converter turns your bank statement PDF into the CSV that Tally can import in under 60 seconds.
Why Bank Reconciliation Matters for Indian Businesses
- GST compliance: Bank deposits visible to tax authorities must match turnover declared in GSTR-1. Regular reconciliation prevents GST scrutiny notices (ASMT-10) for unexplained bank credits.
- Income Tax (ITR): Bank statements are compared with ITR filing during tax assessment. Unrecorded bank transactions create discrepancy notices (under section 133(6)).
- Audit readiness: Statutory auditors and tax auditors (under section 44AB) require reconciled bank accounts. Regular monthly reconciliation makes the annual audit smooth.
- Fraud detection: Unauthorized transactions, duplicate payments, or missed receipts are caught during reconciliation before they compound.
- Accurate financials: P&L and Balance Sheet in Tally are only reliable if bank balances are reconciled and accurate.
Common Bank Reconciliation Differences in Tally
⏱ Timing Differences
Cheques issued but not yet cleared in the bank. Deposits made but not yet credited by bank. These are temporary — resolve when the transaction clears.
🏦 Bank Charges
SMS charges, account maintenance fees, NEFT/RTGS charges, chequebook fees. Bank debits these directly — must be entered in Tally as payment vouchers.
💰 Interest Earned
Bank credits interest on savings/current account balance. Enter in Tally as receipt voucher (Dr Bank A/c, Cr Interest Income) and reconcile.
💳 Auto-Debits
Standing instructions — insurance premiums, loan EMIs, utility bill payments. These auto-debit from the bank but may not be in Tally.
📥 Direct Credits
NEFT/RTGS received directly in bank account — customer payments, GST refunds, TDS refunds. Enter as receipt vouchers in Tally.
❌ Data Entry Errors
Amount entered incorrectly in Tally. Wrong ledger account used. Duplicate entry. Correct by altering or cancelling the wrong voucher.
How to Do Bank Reconciliation in Tally ERP 9 — Step by Step
1
Convert your bank statement PDF to Tally CSVDownload the bank statement PDF from your bank's net banking (HDFC, SBI, ICICI, Axis, Kotak etc.). Upload it at bankstatementengine.com and click "Download Tally" to get a CSV with Date, Narration, Debit, Credit, Balance columns.
2
Open Bank Reconciliation in Tally ERP 9Go to Gateway of Tally → Banking → Bank Reconciliation. Select your company if prompted. A list of bank accounts (bank ledgers) appears.
3
Select the bank account to reconcileChoose the bank ledger (e.g., "HDFC Current Account" or "SBI Savings Account"). Tally shows all pending reconciliation entries — transactions in Tally that are not yet matched to bank statement entries.
4
Import the bank statement CSVPress Alt+O (Import from bank). Select your downloaded CSV file. Map the columns: Date → Date, Narration → Narration, Debit → Debit, Credit → Credit, Balance → Balance. Click Import.
5
Tally auto-matches transactionsTally compares the imported bank statement lines with existing ledger entries and auto-matches where amounts and dates align. Matched entries are marked in green. Unmatched entries remain for manual review.
6
Handle unmatched entriesFor items in bank statement but missing from Tally: create payment or receipt vouchers. For Tally entries not in bank: verify timing differences (outstanding cheques). Once all entries are explained, the reconciliation is complete.
7
Save the reconciliationPress Alt+A to save. Tally records the Bank Reconciliation Statement date. You can print the Bank Reconciliation Statement (BRS) for audit records.
How to Do Bank Reconciliation in Tally Prime — Step by Step
1
Convert PDF to Tally CSVSame as above — use bankstatementengine.com to convert your bank statement PDF to Tally-compatible CSV.
2
Open Banking in Tally PrimePress Ctrl+G (Go To) → type "Bank Reconciliation" → select it. Or from the left menu: Banking → Bank Reconciliation.
3
Select bank account and date rangeChoose your bank account from the list. Set the date range (e.g., 01-04-2026 to 30-04-2026). Tally Prime shows all ledger entries in that period.
4
Click Import to load bank statementClick the Import button (top right). Select your converted CSV file. Map columns — Tally Prime usually auto-detects the standard five-column format from our converter. Click Import to load all bank transactions.
5
Match and reconcileTally Prime shows bank statement transactions on one side and Tally ledger entries on the other. Click to match corresponding entries. Tally Prime's visual interface makes this easier than ERP 9. Save when done.
Banks Supported for Tally Reconciliation
HDFC Bank
SBI
ICICI Bank
Axis Bank
Kotak Mahindra
PNB
Bank of Baroda
Canara Bank
Union Bank
IndusInd Bank
Yes Bank
Federal Bank
IDFC First
RBL Bank
Bank of India
Central Bank
Indian Bank
UCO Bank
Frequently Asked Questions
What is bank reconciliation in Tally?
Bank reconciliation in Tally is the process of matching transactions in your Tally bank ledger with your actual bank statement. Any differences — timing gaps, bank charges, interest credits, missed entries — are identified and resolved. Tally ERP 9 and Tally Prime have a built-in Bank Reconciliation module under the Banking menu.
How do I import a bank statement into Tally for reconciliation?
Convert your bank statement PDF to Tally CSV at bankstatementengine.com. In Tally ERP 9: Gateway of Tally → Banking → Bank Reconciliation → select bank ledger → Alt+O → import CSV. In Tally Prime: Go To → Banking → Bank Reconciliation → select account → Import → select CSV.
What causes differences in Tally bank reconciliation?
Common causes: timing differences (uncleared cheques), bank charges (service fees, SMS charges), interest earned, auto-debits (loan EMIs, insurance), direct deposits (NEFT received), and data entry errors in Tally. Each type has a specific resolution path.
How often should I do bank reconciliation in Tally?
Monthly at minimum for GST compliance. Weekly for high-volume current accounts. Complete reconciliation before filing GSTR-3B each month to ensure all taxable receipts and payments are captured correctly.
How do I handle bank charges in Tally bank reconciliation?
When bank charges appear in the bank statement but not in Tally: create a payment voucher — debit "Bank Charges" expense account, credit the bank ledger, date it to the actual bank debit date. Then return to Bank Reconciliation — the new entry matches the bank statement and can be reconciled.
Is bank reconciliation in Tally mandatory for GST filing?
Not legally mandatory, but practically essential. GST authorities compare bank deposits with declared turnover. Unreconciled accounts create discrepancies that trigger ASMT-10 scrutiny notices. Regular reconciliation is the easiest way to avoid GST notices.
Tally Tools & Related Resources
Start Your Tally Bank Reconciliation — Import PDF in Seconds
Free · All Indian banks · Tally ERP 9 & Prime compatible · No signup
Convert Bank Statement PDF →