Excel template to export bank statement to tally.

In tally  we do bank reconcilaltion by just changing that bank date on which cheque is cleared.

Also you can Auto import Bank Statements Entries in Tally with cheque data by SMAART Excel Utility.

Try - https://www.xltally.in  |  https://www.nikash.in

There is a free route that needs no TDL or paid utility, because Tally.ERP 9 can import vouchers directly from an XML file: Gateway of Tally > Import of Data > Vouchers (in TallyPrime: Alt+O > Import > Transactions).

The Excel side is simple. Keep one row per bank entry with these columns: Date, Narration, Withdrawal (debit), Deposit (credit), Cheque/Ref no., and the counter ledger (party, expense or Suspense). Withdrawals become Payment vouchers, deposits become Receipt vouchers, and cash or own-account transfers become Contra. That sheet then has to be turned into Tally's voucher XML.

Things that make the import go through first time:
- Every ledger in the file, including the bank ledger, must already exist in the company with exactly the same spelling, otherwise Tally reports "Ledger does not exist". If you need new ledgers, import them first (Import of Data > Masters) and choose Ignore Duplicates so existing ledgers keep their groups.
- All voucher dates must fall inside the company's financial year.
- Before converting, check opening balance + deposits - withdrawals = closing balance, so no row has been missed.
- Take a backup before importing, and afterwards compare the bank ledger's closing balance with the statement.

Disclosure: we build KhataSheet (khatasheet.com). Its free CSV/Excel to Tally XML converter does the conversion step in your browser, with nothing uploaded. Honest note: we have tested its output by importing into TallyPrime 7.2; Tally.ERP 9 uses the same import format but we haven't tested ERP 9 ourselves. https://khatasheet.com/tools/csv-to-tally-X M L?utm_source=caclubindia&utm_medium=community&utm_campaign=2026-w44-forum

One tip that saves the XML route from failing: every ledger name in your Excel must match an existing Tally master exactly (spelling, spaces), or that voucher is rejected — so create a 'Bank Suspense' ledger, map every row you can't identify to it, import, and then clear Suspense by altering those vouchers.

An important note to mention here is that whilst Alt+B will allow you to import bank statements for reconciliations, using the XML import will allow you to create accounting vouchers from the converted Excel data. You should decide which option to use based on if you want to reconcile your transactions or post as vouchers. As always, you should test your import in a back-up company.

Quick fix on my earlier reply: the forum broke the tool link. Use this instead (homepage, then Tools → CSV / Excel to Tally): https://khatasheet.com/?utm_source=caclubindia&utm_medium=community&utm_campaign=2026-w44-forum