How to Import Any Indian Bank Statement into TallyPrime — 2026 Step-by-Step Guide

Why importing bank statements manually into Tally takes so long

A typical current-account statement runs 200 to 400 transactions a month. Entering each one as a manual voucher in TallyPrime — date, narration, amount, contra ledger — is the kind of work that quietly eats two evenings a month at every CA firm in India. The numbers are not difficult. They are just slow, and small typos in the running balance create reconciliation problems that take longer to find than the original entry took to make.

The good news is that TallyPrime has supported XML voucher import since the earliest Tally.ERP days. Once your transactions are in the right XML shape, an entire month imports in a few seconds, with every voucher numbered, dated, and ready for ledger assignment.

The two methods: manual voucher entry vs XML import

Manual voucher entry is the default flow new Tally users learn. Open Gateway of Tally, go to Accounting Vouchers, press F5 for Payment or F6 for Receipt, and type each row from the bank PDF. It works, but throughput tops out at roughly sixty entries an hour once you account for tea breaks and ledger lookups.

XML import inverts the workflow. Instead of typing into Tally, you produce a single XML file containing every voucher and let TallyPrime ingest it through the Import menu. The same 400-transaction month finishes in under a minute, and the imported vouchers behave exactly like manually entered ones — they are editable, deletable, and visible in every report.

Step-by-step: convert PDF to Tally XML and import into TallyPrime

Start by exporting your bank statement as a PDF from net banking. Sign in to StatementSync, upload the PDF, and pick Tally XML as the output format. The converter auto-detects whether it is an HDFC, SBI, ICICI, Axis, or Kotak layout and extracts date, narration, debit, credit, and running balance for every row. Review the preview, then download the XML.

In TallyPrime, open the company you want to post the vouchers into. From Gateway of Tally press Alt+O for Import, choose Vouchers, and point Tally at the downloaded XML file. Tally walks through any missing ledgers and creates the vouchers. Confirm the opening and closing balances against the statement before you call the period closed — StatementSync surfaces both at the top of the preview specifically so this check takes seconds rather than minutes.

Common TallyPrime import errors and how to fix them

The single most common import error is the message Invalid Format, and it is almost always a date issue. TallyPrime accepts DD-MMM-YYYY (for example 15-Aug-2026) inside voucher XML. If your converter is exporting 15/08/2026 or 2026-08-15, Tally refuses the file. Re-export with Tally-compatible dates and the import succeeds.

The second most common issue is missing ledgers. If the XML references a ledger that does not exist in the company, Tally either prompts you to create it on the fly or skips the voucher depending on your settings. Create the bank ledger before you import, and let Tally handle the contra ledgers afterwards through the standard voucher edit screen.