Tally ERP 9 Bank Reconciliation — Quick Navigation
Before the detailed guide, here is the essential navigation path and keyboard shortcuts for Tally ERP 9 bank reconciliation:
Navigation Path
Gateway of Tally → Banking → Bank Reconciliation → [Select Bank Account]
Key Shortcuts in Bank Reconciliation Screen
Alt+OImport bank statement CSV file
Alt+AAccept / Save reconciliation
Alt+PPrint Bank Reconciliation Statement
F5Toggle reconciliation mode
Ctrl+F9Debit note voucher entry
Ctrl+F10Credit note voucher entry
Prerequisites: What You Need Before Starting
- Tally ERP 9 Release 5.x or 6.x — bank statement import (Alt+O) is available in these releases
- Bank ledger in Tally — your bank account must be set up as a ledger under "Bank Accounts" group
- Bank statement in CSV format — convert your PDF using bankstatementengine.com (Date, Narration, Debit, Credit, Balance columns)
- Existing vouchers entered in Tally — all payments and receipts for the period should already be entered in Tally before reconciling
Important: Enter all your vouchers in Tally before doing bank reconciliation. The reconciliation process matches existing Tally entries to bank statement lines — it doesn't create new vouchers automatically (except for unmatched bank entries that you add manually).
Step-by-Step: Bank Reconciliation in Tally ERP 9
1
Convert your bank statement PDF to Tally CSVDownload your bank statement PDF from net banking (HDFC NetBanking, SBI YONO, ICICI Internet Banking, Axis Mobile Banking, Kotak 811). Upload at bankstatementengine.com — enter password if the PDF is password-protected. Click "Download Tally" to get the CSV file in Date, Narration, Debit, Credit, Balance format.
2
Open Tally ERP 9 and select your companyLaunch Tally ERP 9. From the Company Selection screen, select your company. Ensure you are working in the correct financial year (F1: Accounting Features → Financial Year Beginning Month should match your period).
3
Navigate to Banking → Bank ReconciliationFrom Gateway of Tally, press B for Banking → then R for Bank Reconciliation (or navigate using arrow keys). Alternatively: Gateway of Tally → Banking → Bank Reconciliation.
4
Select the bank account ledgerA list of bank accounts appears. Select the one you want to reconcile (e.g., "HDFC Bank Current A/c" or "State Bank of India"). Set the date range for reconciliation (e.g., 01-04-2026 to 30-04-2026).
5
Press Alt+O to import bank statementThe Bank Reconciliation screen shows your Tally ledger entries. Press Alt+O to open the Import dialog. Tally prompts you to select the bank statement file. Browse to your downloaded CSV file and select it.
6
Map columns in the import dialogTally shows the CSV columns and asks you to map them to Tally fields:
• Column with dates → Date
• Column with narration/description → Narration
• Column with withdrawal amounts → Debit
• Column with deposit amounts → Credit
• Column with balance → Balance
If you used our converter, the columns are already in this order and Tally typically auto-maps them.
7
Confirm import — Tally loads bank transactionsPress Enter to confirm. Tally ERP 9 imports all bank statement transactions and displays them in the reconciliation screen alongside your existing Tally ledger entries.
8
Tally auto-matches transactionsTally ERP 9 attempts to auto-match bank statement lines with Tally vouchers based on amount and date proximity. Matched entries are shown in green. Unmatched entries appear in red — either in the bank statement side or the Tally side.
9
Manually match remaining entriesFor unmatched entries: click on a Tally voucher on the left and the corresponding bank statement line on the right to manually match them. Common unmatched items include bank charges (enter as payment vouchers), interest earned (enter as receipt vouchers), and timing differences (mark as outstanding).
10
Save with Alt+A and print BRSOnce all reconcilable items are matched, press Alt+A to save. Press Alt+P to print the Bank Reconciliation Statement (BRS). The BRS shows: Bank Balance as per Statement, add/less: Timing Differences, equals Book Balance as per Tally. Print or export to PDF for your audit file.
Common Issues in Tally ERP 9 Bank Reconciliation
Alt+O option not visible
If Alt+O is not visible in your Bank Reconciliation screen, you are likely on an older version of Tally ERP 9. The bank statement import feature was added in Release 5.x. Upgrade to Tally ERP 9 Release 6.4.9 (the latest ERP 9 version) to access this feature.
Date format mismatch
Tally ERP 9 expects dates in DD-MM-YYYY format. If your CSV has dates in a different format (YYYY-MM-DD or MM/DD/YYYY), the import will fail. Our converter automatically produces dates in DD-MM-YYYY format to match Tally's requirement exactly.
Amounts showing in wrong columns after import
This happens when the Debit and Credit columns are mapped incorrectly. If all your debits appear as credits, re-run the import and swap the Debit and Credit column mapping. Our converter always puts withdrawals in the Debit column and deposits in the Credit column — consistent with Tally ERP 9's expectation.
Closing balance doesn't match after reconciliation
If the reconciled balance in Tally doesn't match your bank statement closing balance, check for: (1) missing vouchers in Tally that exist in the bank statement; (2) duplicate vouchers in Tally; (3) wrong amounts in Tally vouchers. Use the Bank Book report (Gateway of Tally → Accounts Books → Bank Book) to audit your entries.
Tally ERP 9 vs Tally Prime — Bank Reconciliation Differences
| Feature | Tally ERP 9 | Tally Prime |
|---|
| Navigation | Banking → Bank Reconciliation | Go To (Ctrl+G) → Bank Reconciliation |
| Import shortcut | Alt+O | Import button |
| Save shortcut | Alt+A | Save button |
| Interface | Text-based | Graphical/Visual |
| Auto-matching | Basic | Improved |
| CSV format required | Date, Narration, Dr, Cr, Balance | Same |
| Our converter output | ✅ Compatible | ✅ Compatible |
Banks Supported for Tally ERP 9 Reconciliation
HDFC Bank
SBI
ICICI Bank
Axis Bank
Kotak Mahindra
PNB
Bank of Baroda
Canara Bank
Union Bank
IndusInd Bank
Yes Bank
RBL Bank
IDFC First
Federal Bank
Bank of India
UCO Bank
Frequently Asked Questions
How do I open Bank Reconciliation in Tally ERP 9?
Gateway of Tally → Banking → Bank Reconciliation. Select your company if prompted. Choose the bank account ledger from the list. The Bank Reconciliation screen opens showing all pending entries.
How do I import a bank statement in Tally ERP 9 using Alt+O?
Convert your bank statement PDF to CSV using bankstatementengine.com. In Tally ERP 9 Bank Reconciliation screen, press Alt+O. Select the CSV file. Map columns (Date, Narration, Debit, Credit, Balance). Press Enter to import. Tally loads all bank transactions and auto-matches where possible.
How do I print a BRS in Tally ERP 9?
After completing reconciliation in the Bank Reconciliation screen, press Alt+P. Select the date range. Tally ERP 9 generates the Bank Reconciliation Statement (BRS). You can save as PDF for audit records.
What version of Tally ERP 9 supports bank statement import?
Bank statement import via CSV (Alt+O) is available in Tally ERP 9 Release 5.x and Release 6.x. If Alt+O is not visible, upgrade to the latest Release 6.4.9 or migrate to Tally Prime.
What is the difference between bank reconciliation in Tally ERP 9 vs Tally Prime?
Both perform the same reconciliation function. Tally ERP 9 uses keyboard shortcuts (Alt+O, Alt+A, Alt+P) and a text interface. Tally Prime has a graphical interface with buttons. The CSV format for bank statement import is identical in both. Our converter output is compatible with both versions.
Get Your Tally ERP 9 Import File — Free in 30 Seconds
Convert any Indian bank statement PDF → CSV for Alt+O import in Tally ERP 9
Convert Bank Statement PDF →