Bank Statement to Tally XML Converter — Free Online Tool
Convert your bank statement into Tally Prime Payment and Receipt vouchers instantly. Supports Advanced Bank Entries format with BANKALLOCATIONS, cheque numbers, and instrument details. 100% browser-based — your data never leaves your device.
1 Download the Excel Template
5 columns: Date · Narration · Cheque No · Withdrawal · Deposit
2 Enter Ledger Names & Upload File
The name of your bank account ledger in Tally.
The ledger on the other side of the transaction (suspense, cash, or party).
Use Advanced Bank Entries Format
Enables ALLLEDGERENTRIES.LIST + BANKALLOCATIONS.LIST — recommended for bank reconciliation in Tally.
Supports .xlsx, .xls, and .csv files. Your data never leaves your browser.
📋 Expected File Format:
| Date | Narration | Cheque No | Withdrawal | Deposit |
|---|---|---|---|---|
| 01/04/2026 | NEFT Payment | 123456 | 5000 | |
| 02/04/2026 | Salary Credit | 68000 |
- • Withdrawal > 0 → Payment voucher
- • Deposit > 0 → Receipt voucher
- • Cheque No is stored in
INSTRUMENTNUMBER - • Rows with both amounts 0 are skipped automatically
3 Preview & Validate
Showing first 10 rows. All rows will be processed.
4 Generate & Download XML
Review the summary above, then click to generate your Tally-ready XML file.
How to Use the Bank Statement Converter
Follow these steps to convert your bank statement to Tally Payment/Receipt XML:
-
1
Download and fill the Excel template
Click "Download Bank Template" above. The format is: Date · Narration · Cheque No · Withdrawal · Deposit. You can also export this from your internet banking portal — just map the columns to match.
-
2
Enter your Bank Ledger and Suspense/Bottom Ledger names
The Bank Ledger is your bank account name in Tally (e.g., "SBI Current A/c"). The Bottom/Suspense Ledger is the other side — usually a Suspense account that you'll reconcile later, or a cash/party ledger if you know it.
-
3
Keep Advanced Bank Entries ON (recommended)
Advanced mode generates
ALLLEDGERENTRIES.LISTwithBANKALLOCATIONS.LISTinside — this enables proper bank reconciliation in Tally. Cheque numbers appear inINSTRUMENTNUMBER. -
4
Upload, preview, and download
Upload the file, review the first 10 rows, then click "Generate Bank XML". Import the XML into Tally Prime via Import (Alt+O) → Transactions.
How to Import This XML into Tally Prime
Once you've downloaded the XML file, follow these steps inside Tally Prime:
-
1
Open Tally Prime. Make sure your Bank Ledger and Suspense/Bottom Ledger already exist in your company's Chart of Accounts.
-
2
In Tally Prime, go to Import (Alt+O) → Transactions. (In older Tally ERP 9: Gateway of Tally → Import of Data → Vouchers)
-
3
Browse to the downloaded XML file and press Enter. Tally will process all Payment and Receipt vouchers.
-
4
On success, Tally shows "Vouchers created: X". If you see errors, check the common error fixes guide.
-
5
Verify & Reconcile: Go to Day Book to check vouchers. Use Bank Reconciliation (Ctrl+F10 from bank ledger) to reconcile cheque entries against the statement.
Excel Template Column Guide
The bank statement template uses only 5 columns — the ledger names are entered in the tool:
| Column | Required? | Example | Notes |
|---|---|---|---|
| Date | Required | 01/04/2026 | Accepts DD/MM/YYYY, YYYY-MM-DD, or Excel serial date format. |
| Narration | Recommended | NEFT/COMPANY A PAYMENT | Transaction description. Stored in Tally's NARRATION tag. Can be left blank. |
| Cheque No | Optional | 123456 | Stored in INSTRUMENTNUMBER in Advanced mode. Used for bank reconciliation in Tally. |
| Withdrawal | Conditional | 5000.00 | Amount going out of bank. Creates a Payment voucher. Leave blank or 0 for deposits. |
| Deposit | Conditional | 68000.00 | Amount coming into bank. Creates a Receipt voucher. Leave blank or 0 for withdrawals. |
Bank Statement Tool — FAQ
How does the tool decide if it's a Payment or Receipt voucher?
Simple rule: if the "Withdrawal" column is greater than 0, the tool creates a Payment voucher (money going out of bank). If the "Deposit" column is greater than 0, it creates a Receipt voucher (money coming in). Rows where both are 0 or blank are skipped automatically.
What is the "Bottom / Suspense Ledger" and what should I use?
The Suspense Ledger is the counter-ledger on the other side of every bank transaction. Since one bank statement can have payments to many different parties, the tool uses one fixed ledger name for all entries — that's the "Bottom" ledger. Common choices: a "Suspense A/c" (which you then split manually in Tally), "Cash", or if all transactions are to one party, that party's ledger name.
What is "Advanced Bank Entries Format"?
Advanced mode generates ALLLEDGERENTRIES.LIST (instead of plain LEDGERENTRIES.LIST) and includes a BANKALLOCATIONS.LIST block inside the bank ledger entry. This enables Tally's Bank Reconciliation feature and stores cheque numbers in INSTRUMENTNUMBER. It is recommended for all bank statement imports.
Can I use a CSV file exported from my internet banking?
Yes. The tool accepts .csv files. Just make sure the columns are in the right order or named correctly: Date, Narration, Cheque No, Withdrawal, Deposit. The column matcher is case-insensitive and space-insensitive, so minor naming differences (like "Debit" instead of "Withdrawal", or "Credit" instead of "Deposit") will need to be renamed before uploading.
The Tally XML folder tool required uploading to a server. Is this different?
Yes — this is completely browser-based. Your file is processed in JavaScript inside your browser and never sent to any server. The XML is generated and downloaded directly to your device. This gives you the same output quality as the server-based tool, but with full privacy.