✅ 100% Free 🇮🇳 All Indian Banks 📋 Exact Tally Columns ⚡ Instant Results 🔒 Secure & Private

Tally Bank Statement Import — Excel Format

The exact column structure Tally Prime expects for bank statement import, why imports fail, and a free converter that produces the correct format from any bank PDF automatically.

📁

Skip the template — get the format pre-filled

Upload your bank statement PDF and download Excel already in Tally import format

Convert to Tally Format →

No signup required · Files deleted after 24 hours · HTTPS encrypted · Never shared

The Exact Excel Format for Tally Bank Statement Import

Tally Prime's bank statement import (Alt+O → Transactions → Bank Statement) expects a simple, strict structure — one transaction per row, with these columns:

DateParticularsDebitCreditInstrument No.
01-04-2026NEFT/AXIS BANK/RENT APRIL25000.00
03-04-2026UPI/CR/CLIENT PAYMENT INV-2241118000.00
05-04-2026CHQ PAID VENDOR SUPPLIES42700.00752727
08-04-2026BANK CHARGES GST590.00

The five formatting rules that matter

Why Manual Formatting Takes So Long

Copy-pasting from a bank PDF into Excel produces none of the above. SBI statements split narrations across lines; HDFC merges date and value-date; ICICI embeds the page number into the data; scanned statements can't be copied at all. Cleaning a 10-page statement by hand typically takes 30–60 minutes — and one missed merged-row means your Tally ledger won't reconcile.

Our converter does this automatically: upload the bank statement PDF (any Indian bank, digital or scanned) and download an Excel file already in the structure above. Every transaction is also balance-verified — checked against the statement's running balance — so the amounts you import into Tally are arithmetically proven, not just extracted.

Import Walkthrough: Tally Prime 3.0+

1
Convert

Upload your bank PDF above, download the Tally-format Excel

2
Alt+O in Tally

Gateway of Tally → Import → Transactions → Bank Statement

3
Map & Accept

Map columns, review the voucher preview, accept — done

Troubleshooting Tally Excel Import Errors

Error / SymptomCauseFix
"Date format invalid"Dates stored as textUse DD-MM-YYYY real date values — our output does this by default
All amounts import as debitCombined amount columnSeparate debit and credit columns
Rows skipped during importEmpty particulars or malformed rowsRemove artifact rows; join multi-line narrations
Ledger doesn't reconcile after importMisread or missing amountsUse balance-verified conversion — errors are flagged before download
Duplicate vouchersStatement period overlapImport non-overlapping date ranges; Tally flags duplicates on instrument no.

Related Guides

Frequently Asked Questions

What Excel format does Tally bank statement import need?
One transaction per row: Date (DD-MM-YYYY), Particulars, Debit, Credit, optional Instrument No. Real date values, clean numeric amounts, no merged cells or statement artifacts.
Where can I download the template?
You don't need a blank template — upload your bank statement PDF and download Excel already in the correct structure, filled with your actual transactions.
Which Tally versions support direct Excel import?
Tally Prime 3.0 and later import Excel directly via Alt+O. Older versions (ERP 9) require XML conversion or a TDL-based utility.
Why does my import fail?
Usually: text-formatted dates, combined debit/credit columns, multi-line narrations splitting rows, or page artifacts in the data. Converting through our tool eliminates all of these.
Does this work with scanned statements?
Yes — OCR runs automatically on scanned PDFs, and balance verification catches recognition errors before you import into Tally.

Get Your Statement in Tally Import Format

100% free · No signup · All Indian banks · Balance-verified output

Convert Now →