New to Tally XML Converter?

Download our sample file to see the expected format for bank statements:

The file should have columns for Date, Narration, Cheque No, Withdrawal, and Deposit.

Bank Ledger Name:

Bottom Ledger Name (e.g., Suspense A/c):

Select Excel/CSV File: File should have columns: Date, Narration, Cheque No, Withdrawal, Deposit

Use Advanced Bank Entries Format Enables additional Tally-specific fields like PARTYLEDGERNAME, EFFECTIVEDATE, TRANSACTIONTYPE, and other bank allocation details.

How to Use the Tally XML Converter

Prepare Your Bank Statement

Export your bank statement from your online banking portal or prepare it in Excel with these columns:

Date: Transaction date in any recognizable format
Narration: Description of the transaction
Cheque No: Cheque number if applicable (can be blank)
Withdrawal: Amount withdrawn/debited from account
Deposit: Amount deposited/credited to account

Download our sample file if you need a reference: CSV Format Excel Format

Enter Ledger Names

You need to specify two ledger names that exist in your Tally:

Bank Ledger Name: The name of your bank account in Tally (e.g., HDFC Bank)
Bottom Ledger Name: Usually a suspense account to handle unreconciled entries (e.g., Suspense A/c)

Choose Advanced Format (Recommended)

The Advanced Bank Entries Format includes additional Tally-specific tags like PARTYLEDGERNAME, EFFECTIVEDATE, and proper bank allocations for better compatibility with Tally.

Upload and Convert

Upload your Excel/CSV file and click "Convert to XML". The system will generate Tally-compatible XML with all your transactions.

Import to Tally

Download the generated XML file and import it into Tally using:

Open Tally
Go to Gateway of Tally → Import of Data
Select the downloaded XML file
Verify and accept the transactions

About Tally XML Converter

Tally XML Converter is a powerful, free tool designed to streamline the process of importing bank statements into Tally accounting software. This tool bridges the gap between your bank's statement format and Tally's required XML format.

Key Features:

Universal Format Support: Works with Excel (.xlsx, .xls) and CSV files
Advanced Tally Integration: Generates properly structured XML with all required Tally tags
Bank Reconciliation Ready: Creates proper bank allocations for easy reconciliation in Tally
Payment & Receipt Vouchers: Automatically determines appropriate voucher types
Secure Processing: All processing happens locally - your financial data never leaves your computer
Fast & Efficient: Converts hundreds of transactions in seconds

This tool is especially useful for accountants, bookkeepers, and business owners who want to save time on manual data entry and reduce errors when updating their Tally accounting records.

"The Tally XML Converter saves me hours of manual data entry every month. What used to take a full day now takes just minutes!"

— Accounting Professional