Bank Reconciliation in Tally Prime — Complete Guide with Bank Statement Import

What Is Bank Reconciliation in Tally Prime?

Bank reconciliation in Tally Prime is the process of matching the transactions recorded in your Tally Prime company books against the transactions on your official bank statement. The goal is to confirm that every payment, receipt, and transfer that appears on your bank statement has a corresponding voucher in Tally — and to identify any discrepancies (uncleared cheques, bank charges not yet entered, timing differences, errors).

Tally Prime made bank reconciliation significantly faster than Tally ERP 9 by introducing Auto Bank Reconciliation — the ability to import your bank statement directly into Tally and have it automatically match transactions to vouchers based on date, amount, and narration. This reduced what used to be hours of manual work to minutes.

Tally Prime vs Tally ERP 9 — Bank Reconciliation Differences

Tally Prime Bank Statement Import Format

Tally Prime's Auto Bank Reconciliation requires your bank statement in a specific Excel format. The file must contain these columns in the correct order:

Key requirements:

• Date format: DD-MMM-YYYY (e.g., 15-Jun-2026). Tally Prime is strict — other formats (DD/MM/YYYY, YYYY-MM-DD) will fail to import
• Separate debit and credit columns: Do not use a single "Amount" column with +/- signs
• Numeric values: Amount cells must be numbers, not text. Avoid currency symbols (₹) in the cells
• No merged cells: The header row must be a simple single row, no merged cells above
• No blank rows: Remove any summary rows, subtotals, or blank rows between transactions

How to Do Bank Reconciliation in Tally Prime — Step by Step

Step 1: Convert your bank statement to Tally format

Download your bank statement PDF from NetBanking. Upload it to Bank Statement Engine (above) and download the Tally Excel file from the results page. Verify the date format is DD-MMM-YYYY and amounts are numeric.

Step 2: Open Bank Reconciliation in Tally Prime

Gateway of Tally → Banking → Bank Reconciliation. If you don't see Banking in the menu, ensure your company has bank ledgers configured under Accounts → Ledgers with the group set to Bank Accounts or Bank OD Accounts.

Step 3: Select your bank ledger

Tally Prime shows a list of bank ledgers in your company. Select the bank account you want to reconcile. The screen shows all unreconciled vouchers with their transaction dates and amounts.

Step 4: Import the bank statement (Auto Bank Reconciliation)

Press Alt+B (Import Bank Statement) or click the Import Bank Statement button. Browse to your Tally-format Excel file and open it. Tally Prime reads all transactions from the Excel and attempts to auto-match them to existing vouchers based on:

• Transaction date (exact match or within tolerance)
• Amount (exact match in debit or credit column)
• Narration / cheque number (partial match for confirmation)

Step 5: Review auto-matched transactions

Tally Prime shows three categories after import:

• Matched (green): Bank entry matched to a Tally voucher — reconciliation date auto-set to bank value date
• Unmatched bank entries (orange): Transactions on the bank statement with no matching Tally voucher — likely missing entries (bank charges, interest, standing instructions)
• Unmatched Tally vouchers (yellow): Tally vouchers not found on the bank statement — uncleared cheques, timing differences

Step 6: Resolve unmatched entries

For unmatched bank entries: create the missing vouchers in Tally (bank charges as a journal, direct debits as payment vouchers). For unmatched Tally vouchers: verify if the cheque is still outstanding or was returned.

Step 7: Accept the reconciliation

Once all differences are resolved, the closing balance on the bank statement should match the balance in Tally. Press Ctrl+A to accept and save the reconciliation.

How to Enable Auto Bank Reconciliation in Tally Prime

Auto Bank Reconciliation is available in Tally Prime Release 2.0 and above (released 2021). If you are on an older release, update Tally Prime first.

To confirm Auto Bank Reconciliation is active:

1. Go to Gateway of Tally → F11 (Features) → Accounting Features
2. Ensure Enable Bank Reconciliation is set to Yes
3. Ensure your bank ledgers are grouped under Bank Accounts (not Sundry Creditors or any other group)

If Alt+B is not visible in the Bank Reconciliation screen, your Tally Prime version is below Release 2.0. Download the latest release from the Tally Solutions website.

Troubleshooting: Tally Prime Bank Reconciliation Issues

Bank statement import fails or shows no transactions

The most common cause is date format mismatch. Tally Prime requires DD-MMM-YYYY (e.g., 15-Jun-2026). If your Excel file has dates in DD/MM/YYYY or any other format, Tally will either fail to import or import with incorrect dates. Use Bank Statement Engine's Tally output — it automatically uses the correct format.

Amounts imported as text instead of numbers

If your Excel file contains amounts formatted with currency symbols (₹1,234.00) or thousand-separator commas in text format, Tally will read them as text and fail to match. Bank Statement Engine outputs clean numeric values without symbols.

Auto-match is not finding matches despite correct amounts

Tally Prime matches on date + amount. If a voucher in Tally has a slightly different date than the bank statement (e.g., cheque issued on Monday but cleared on Wednesday), it won't auto-match. You can manually match these by selecting the Tally voucher and the bank entry and pressing Enter to reconcile.

Opening balance does not match

If your Tally opening balance for the bank account does not match the opening balance on the bank statement, reconcile it from the beginning of the financial year or enter an opening balance adjustment voucher. The reconciliation closing balance will only match if the opening balances match.

Bank Reconciliation in Tally Prime: Manual Method (Without Import)

If you prefer not to import a file, Tally Prime also supports manual bank reconciliation:

1. Gateway of Tally → Banking → Bank Reconciliation → select bank ledger
2. Tally shows all unreconciled vouchers. For each voucher that appears on your bank statement, press Space or Enter to open it
3. Enter the Bank Date (the date the transaction cleared on the bank statement)
4. Press Ctrl+A to save the reconciliation date for that voucher
5. Repeat for every matched transaction
6. After all matches, the balance difference should equal uncleared items only

The manual method is practical for small accounts (under 50 transactions per month) but becomes time-consuming for larger volumes. Use the import method for accounts with 100+ monthly transactions.

Bank Statement PDF to Tally Prime Import Format — How Bank Statement Engine Helps

The biggest practical obstacle to Tally Prime auto bank reconciliation is getting your bank statement into the correct Excel format. Most Indian banks provide:

• Password-protected PDF statements — readable by humans but not directly importable into Tally
• Excel downloads that use the bank's own column format — not matching Tally's required structure
• CSV downloads — closer but still requiring date format conversion and column restructuring

Bank Statement Engine handles all of this. Upload your bank statement PDF (including password-protected PDFs from HDFC, SBI, ICICI, Axis, Kotak, PNB, Canara, and all other Indian banks), and the Tally download on the results page gives you the exact Excel format Tally Prime expects — correct column names, DD-MMM-YYYY dates, clean numeric values, no currency symbols.

Frequently Asked Questions