How to import bank statement in Tally from Excel

There are many ways to import bank statements in Tally. Also there are different banks having different statement formats. You have to use third party tool utility to import Bank statements in Tally from Excel or PDF.

You can use this Free Utility to import unlimited bank statement in Tally.

Free Import Bank Statement in Tally Click - www.xltally.in  |  www.xltool.in

For anyone landing here now, this is how it works in current TallyPrime:

1. If the bank lets you download Excel or CSV from net banking: use TallyPrime's own Bank Statement import (Alt+O > Import > Bank Statement, choose the bank ledger and the file, preview, import). Tally supports 145+ banks for this. It is mainly for reconciliation and creating vouchers from the imported bank data.

2. If you only have a PDF: Tally's help page says that import does not accept PDFs, and it also rejects Excel or CSV files converted from a PDF. The route that works is to create the vouchers yourself and import them as XML: Alt+O > Import > Transactions (Import of Data > Vouchers in Tally.ERP 9). Debits become Payment vouchers, credits become Receipt vouchers, and cash or own-account transfers become Contra.

Three things that prevent most failed imports:

- The bank ledger and every counter ledger must already exist with the exact same name, or Tally says "Ledger does not exist". Import a masters file first and choose Ignore Duplicates so existing ledgers keep their groups.

- Every voucher date must fall inside the company's books.

- Before importing, check opening + credits - debits = closing and every running balance. A misread row is a 1-minute fix before import and a reconciliation hunt after.

Take a backup first and compare the bank ledger's closing balance with the statement afterwards.

Disclosure: we build KhataSheet, a free tool that does step 2. It reads the PDF in your browser (nothing is uploaded), runs the balance check on every row, and gives Tally XML (vouchers + ledger masters, tested by importing into TallyPrime 7.2) or Excel/CSV. Guide: https://khatasheet.com/guides/import-bank-statement-into-tallyprime?utm_source=caclubindia&utm_medium=community&utm_campaign=2026-w43-launch - the steps above work with any tool.