Bank Statement to Tally Import – Complete 2025 Step-by-Step Guide & FAQs

Published on: 27-11-2025 Call CA Tally HelpDesk +91 9205471661, 8368262875

Managing bank reconciliation manually is one of the most time-consuming tasks for businesses. Downloading bank statements, typing each transaction into Tally, and then matching entries can take hours—especially for companies with heavy daily transactions. Tally makes this process much easier by giving multiple ways to import bank statements directly into your books.

Whether your statement is in Excel, CSV, or text format, you can import it into Tally using a Bank Statement Import Utility, Tally’s built-in features, or custom XML templates. This guide explains each method in a simple, step-by-step, practical way, so that even a non-technical user can follow it easily.

Why Importing Bank Statements into Tally is Important

Instead of entering every debit or credit manually, importing saves time and reduces errors. It improves accuracy, enables faster reconciliation, and gives business owners more control over their banking data.

Importing bank statements into Tally helps you:

• Save 80% of bookkeeping time
• Eliminate data entry mistakes
• Maintain accurate cash & bank ledgers
• Speed up GST reporting
• Automate reconciliation
• Track charges, interest, IMPS/NEFT entries, EMI deductions, etc.

This is why most CA firms, accountants, and businesses now prefer automated bank imports inside Tally.

 Types of Bank Statements You Can Import into Tally

Tally allows importing statements from:

✔ Excel (.xlsx or .xls)

✔ CSV (Comma-separated Values)

✔ TXT (Plain text formats)

✔ XML (Structured import format for Tally)

If the bank doesn’t provide a Tally-compatible format, you can convert it using:

• Excel templates
• Import utilities
• Third-party converters
• Custom mapping sheets

 Method 1: Import Bank Statement in Tally Prime Using Excel/CSV (Recommended)

This is the most popular method because most banks (SBI, HDFC, ICICI, Axis, Kotak, Bank of Baroda, etc.) provide Excel or CSV downloads.

 Step-by-Step Guide: Importing Excel Bank Statement to Tally

Follow these simple steps:

STEP 1: Download the Bank Statement from Net Banking

Go to your bank’s portal and download the statement in:

• Excel (.xlsx) or
• CSV file

Columns usually include Date, Narration, Debit, Credit, Balance.

STEP 2: Prepare the Statement for Tally

Tally requires clean data, so ensure your Excel sheet has:

• No blank rows
• Proper date column
• Narration properly written
• Debit & credit separated
• Amount column should not contain commas or symbols

If needed, clean the data:

• Remove merged cells
• Ensure dates are in DD-MM-YYYY
• Remove formulas and convert them to plain values

STEP 3: Use Tally Import Utility (Excel to Tally)

You can use:

• Built-in Tally Prime Bank Reconciliation tool
• Excel-to-Tally Import Tools
• XML Converter Tools

Choose the utility and map the columns:

Mapping ensures Tally understands each column correctly.

STEP 4: Generate XML File for Tally

After mapping, export the sheet to XML format, which is the only importable structure Tally accepts.

Your file becomes something like:

bankstatement.xml

STEP 5: Import XML into Tally

Open Tally → Select Company.

Go to:

Gateway of Tally → Import Data → Vouchers → Select XML file

Tally will show a confirmation message:

✔ “Data Imported Successfully”

STEP 6: Check Entries in Bank Ledger

After import, open:

Gateway of Tally → Display → Account Books → Ledger → Bank Name

All transactions like:

• ATM
• IMPS
• NEFT/RTGS
• POS
• Bank charges
• Interest earned
• EMI
• UPI

Will reflect properly.

 Method 2: Use Tally Prime's Built-In Bank Reconciliation Feature

Tally Prime has an Auto Bank Reconciliation feature where you can import a bank-provided file.

Supported file types:

✔ MT940

✔ CAMS format

✔ Excel format (bank-specific)

How to Use Auto Bank Reconciliation

1. Go to Bank Ledger
2. Press B: Bank Reconciliation
3. Select Import Bank Statement
4. Upload Excel/CSV/MT940
5. Tally matches entries automatically

Matched entries turn green, while unmatched remain white.

 Method 3: Manual Import Using XML Templates

Some businesses prefer custom XML import.

Create an XML file containing:

• Voucher type (Payment/Receipt/Contra)
• Date
• Ledger names
• Amounts
• Narration

Then import using:

Gateway of Tally → Import Data → Vouchers

This method is technical but powerful for advanced automation.

 What Gets Imported Automatically?

Tally imports:

• Date
• Description/Narration
• Debit Amount
• Credit Amount
• Bank charges
• UPI/IMPS references
• Cheque numbers
• Transaction references
• Running balance

Tally does NOT automatically import:

• Ledger mapping
• GST classification
• Cost centres

You must review these after import.

Step-by-Step Example

Suppose your Excel has:

After import, Tally will create:

• Contra voucher (for ATM withdrawal)
• Receipt voucher (for UPI income)
• Payment voucher (for bank charges)

You only need to verify ledger names.

Common Errors & How to Fix Them

❗ Error: “Date Format Not Valid”

✔ Convert date format to DD-MM-YYYY or DD/MM/YYYY

❗ Error: “Invalid Ledger”

✔ Make sure all required ledgers already exist in Tally
✔ Or enable “Create new ledger while importing”

❗ Error: “Incorrect XML Structure”

✔ Your XML file must follow Tally’s import schema
✔ Use converter tools to auto-generate correct XML

 Frequently Asked Questions (FAQs)

1. Can I import PDF bank statements directly into Tally?

No. You must first convert PDF to Excel or CSV.

2. Do all banks provide Tally-compatible formats?

No, only some do. For others, you must use Excel + Converter Tools.

3. Can I import multiple bank statements at once?

Yes, if your utility supports batch XML generation.

4. Will Tally automatically match entries during reconciliation?

Yes — if the narration and amount match the bank statement.

5. Can I undo an import?

No direct undo option. But you can:

• Restore company backup
• Or delete vouchers manually

6. Which Tally versions support bank import?

• Tally ERP9
• Tally Prime
• Tally Prime Edit Log

All support XML voucher import.

7. What if my bank statement has combined debit/credit in one column?

Split them into Debit and Credit columns before import.

8. Can I import UPI, ATM, card swipe transactions?

Yes, all appear correctly as debit or credit entries.

9. Does Tally create new ledgers automatically?

Only if the utility allows mapping; otherwise create ledgers manually.

10. Is this import process safe?

Yes, as long as you keep a company backup before importing.

Powered by Binarysoft Technologies
Authorized Tally Partner
Location : 1626/33, 1st Floor, Naiwalan, Karol Bagh, New Delhi – 110005, INDIA
Contact us : +91 7428779101, 9205471661
Email us :  tally@binarysoft.com (10:00 AM – 6:00 PM, Mon–Fri)