Tally Prime Bank Statement Import Guide

Tally Prime remains the dominant accounting software across India, the Middle East, and beyond. One of its most powerful automation features is Auto Bank Reconciliation (Auto BRS), which completely eliminates the manual ticking and checking of the company cash book against the bank ledger.

However, to use Auto BRS, you must supply Tally with a supported bank statement file format (Excel or CSV). If your client hands you paper printouts or scanned PDFs, Tally cannot use them.

This guide explains how to bridge that gap: getting data out of a messy PDF and structuring it for a seamless Tally Prime import.

The Challenge with Indian Bank Statements

If you process accounts for Indian businesses (HDFC, ICICI, SBI, Axis, Kotak), you know their PDF statement layouts are notoriously complex.

They frequently feature wrapped “Narration” text that spans four or five lines. They use specific Chq/Ref No columns that merge with branch details. A standard “PDF to Word” converter will completely mangle these tables, creating blank rows and incorrectly misaligning the Withdrawal/Deposit columns.

Step 1: Purpose-Built Extraction

You must use a tool mathematically designed for bank formats.

Instead of typing out months of backlogged transactions, you can drag the PDF into SmartBankStatement, which is specifically designed to handle Indian bank statement formats. It intelligently forces multi-line narrations back into a single cell, maintains separate Withdrawal and Deposit columns, and guarantees the closing balance ties out exactly.

Once converted, export the data to an Excel file (.xlsx or .csv).

Configuring Auto Reconciliation in Tally Prime

Once you have a clean Excel file containing the bank transactions, you can import it to automatically reconcile your ledger.

Before attempting the import, ensure your bank account ledger in Tally is configured for reconciliation:

1. Go to Gateway of Tally > Alter > Ledger (select your Bank Ledger).
2. Ensure Enable Auto Reconciliation is set to Yes.
3. Provide the path for new bank statements in the Set/Alter Auto BRS Configuration section if you wish to define a default folder.

Validating Your Excel Format

Tally Prime generally expects a clean Excel template with clear headers. While Tally provides some supported bank formats natively, you can often map custom Excel files directly during the import process.

Your Excel file should prominently feature:

• Date
• Narration / Particulars
• Cheque No. / Ref No.
• Withdrawal
• Deposit

Remove any unnecessary title headers (like “Statement of Account for XYZ Corp”) from the top of the Excel sheet so the first row represents the column titles or the immediate start of the data.

Performing the Import

1. Navigate to Gateway of Tally > Banking > Bank Reconciliation.
2. Select the specific Bank Ledger.
3. The Bank Reconciliation screen will open, showing “Company Book” transactions.
4. Press Alt+O (or click Import) from the top menu and select Bank Statement.
5. File Path: Enter the folder path where you saved your cleanly extracted Excel file.
6. File Name: Select the specific file.
7. Tally will attempt to import the rows. If it succeeds, it will split the screen: showing Company Book entries on top, and the newly imported Bank Statement entries on the bottom.

Tally will now attempt to automatically match amounts, instruments, and dates. Transactions that do not match indicate missing entries in your books (e.g., bank charges, direct deposits) that you must pass vouchers for.

The “Date Formatting” Trap

The most common reason a Tally Excel import fails is an incorrect date format mismatch. Tally is heavily reliant on the financial year and strict date validation.

If your Excel file says 04-30-2026 (US styling: Month-Day-Year), but Tally expects 30-04-2026 (Day-Month-Year), the import will crash or silently drop rows. Always format your Date column in Excel to explicitly match your regional OS settings before saving and attempting the import into Tally.