Tally XML Format

Excel to Tally XML Converter for Bank Statements (Free)

Every other Excel to Tally tool hands you a template to fill in first. This one reads the spreadsheet your bank actually produced, in whatever column order it arrived. What comes back is Tally XML that imports on the first attempt — the five failures that fill a tally.imp log, from a missing ledger to stock items mixed with accounting entries, are all structurally impossible in this file. A free Excel to Tally converter, with nothing to install.

Bank-grade security - Files processed securely and deleted immediately
Trouble converting a file? Tell us — we fix issues fast. Report it

Not the file you need?

Saved it as CSV?
The CSV route to the same vouchers
On QuickBooks instead?
The same sheet, written as a .qbo
Still a PDF?
Read the original document instead

Why Use Our Excel to Tally XML Converter Tool?

No template, no import utility

The usual Excel to Tally template makes you retype Date, Ledger Name, Transaction Type and Amount into its own columns — which is the data entry you were trying to avoid. This reads the sheet your bank produced, in whatever column order it arrived, with nothing to install first.

Five import errors it cannot produce

Tally logs its import failures to tally.imp, and the five that dominate that file are all structural: a missing ledger, a date out of range, an unknown voucher type, debits that do not match credits, and stock items mixed with accounting entries. This XML declares its ledgers, writes YYYYMMDD dates, uses only built-in voucher types and balances every entry to zero.

Your spreadsheet stays on your machine

The .xls or .xlsx file is read in the browser and never uploaded anywhere. The transaction rows alone are sent out so the columns can be identified, and the Tally XML is assembled back on your machine.

How to convert Excel to Tally XML in three steps

1

Start with your bank's spreadsheet

An .xls or .xlsx exactly as it arrived from net banking, a card issuer or a payment gateway — formulas, formatting and all. Dates are taken as the cell displays them, so a column Excel is storing internally as the number 45790 still reads as 13/05/2025.

2

Upload the spreadsheet

Use the box above to upload Excel to Tally, up to 10MB. A title block sitting above the table is stepped over to find the real header row, so there is no need to tidy the sheet first. If the workbook holds several sheets, put the statement one first.

3

Import the .xml into Tally

No options appear because none are needed. Withdrawals arrive as Payment vouchers and deposits as Receipts, each numbered from its own contents so a repeat of the same sheet is recognised instead of duplicated.

Why the import stops before it starts

Tally does not read spreadsheets

Import Data expects XML. TallyPrime does have a native bank statement import at Gateway of Tally → Alt+O → Bank Statement that accepts CSV and Excel, but only from banks whose layout it already knows, and never from a file produced out of a PDF — which is the file most people are actually holding.

The import utilities are Windows-only, and paid

The established tools are desktop installs or an Excel to Tally TDL add-on, several charging around ₹99 a month for bank statement imports specifically. Compare that to the price of the software it feeds and it is a small line, but it is a recurring one for a task most people consider basic data entry — which is why pirated builds of these utilities are so widely searched for.

A typed ledger name has to match exactly

Template-driven tools have you type ledger names into a column, and Tally compares them character for character — one stray space and that entry is rejected while the rest of the file carries on. Turning on "Ignore errors during data import" pushes the refusals into the tally.imp log rather than halting, but every ledger it named still has to be created by hand afterwards.

Debit and credit arrive in one column

Plenty of bank exports put both directions in a single Amount column and signal the difference with a Dr/Cr marker, a sign, or a separate type column. A converter that assumes two columns reads every withdrawal as a deposit, which balances to nothing and reverses the entire statement.

Who turns a spreadsheet into Tally vouchers

Accountants on TallyPrime

Bank entries for a month of clients, typed one voucher at a time, is the job nobody costs properly. An Excel to Tally bank statement import turns each sheet into every Payment and Receipt voucher in a single pass.

Banks Tally cannot read

Tally's built-in bank import recognises a fixed roster of bank layouts. A workbook from a regional bank, a card issuer or a payment gateway outside that roster is refused outright, whereas the voucher XML route consults no such list.

Statements already in Excel

Net banking hands out .xls and .xlsx far more often than anything Tally accepts directly, so Excel data import in Tally usually means re-keying a sheet that already holds every figure.

Tally users on a Mac

Almost every Excel to Tally import utility is a Windows install. An online converter produces the same XML on macOS, which is then imported from any Tally machine.

Tally ERP 9 and Tally 9

The voucher format predates TallyPrime, so Excel to Tally ERP 9 and Tally 9 are the same conversion and the same file. Nothing here is specific to TallyPrime 6.0.

Re-importing every month

Voucher numbers are derived from row content rather than a counter, so next month's statement cannot collide with this month's and a genuine re-import is still caught.

Frequently Asked Questions — Excel to Tally XML Converter

QHow do I import Excel to Tally Prime?

Convert the workbook here, then open Gateway of Tally, choose Import Data and point it at the .xml. That is all there is to how to import Excel to Tally — the entries are already complete when the file reaches Tally, so nothing needs preparing on the Tally side and no add-on has to be installed. The same route works unchanged on TallyPrime 2.1, 4.0, Tally Prime 6.0 and 6.1.

QDoes Tally import an Excel file directly?

Only in one narrow case. TallyPrime's native bank statement import at Gateway of Tally → Alt+O → Bank Statement reads CSV and Excel downloaded straight from a bank whose layout it recognises. It refuses unrecognised layouts and anything produced from a PDF, and it does not exist at all for general voucher data — which is why the XML route is the general answer.

QIs there an offline Excel to Tally converter?

Searches for an Excel to Tally XML converter offline mostly lead to Windows utilities and TDL add-ons that install and run without a connection. This is not one of them — it is an Excel to Tally XML converter online, running in the browser. What it does do is keep the spreadsheet itself on your machine: the file is parsed locally and never uploaded, and only the transaction rows are sent out so the columns can be identified. If nothing at all may leave the machine, an installed utility is the honest recommendation.

QDoes Tally create new ledgers automatically?

Not on its own — an XML naming a ledger the company does not contain fails with "Referenced master does not exist". The file written here sidesteps that by declaring its ledgers first, under the correct parents, so they are created as part of the same import.

QWhich ledgers do the vouchers post to?

Three: Bank Account, Expenses and Income. Every withdrawal is debited to Expenses and every deposit credited to Income, because a bank statement does not say which expense head a payment belongs to. Rename or reallocate them inside Tally afterwards — that is a reclassification on three ledgers rather than data entry on hundreds of rows. A converter that named a different ledger per row would be more precise, and would also reintroduce the exact-match problem that stops most imports dead.

QWhat if my bank statement has combined debit/credit in one column?

It is read correctly. A single Amount column with a Dr/Cr marker, a signed value, or a separate transaction-type column all resolve to the right direction, and the running balance is used as a check where the statement prints one.

QWhich Tally versions can import this file?

TallyPrime — including 2.1, 4.0, 6.0 and 6.1 — plus Tally ERP 9 and Tally 9. The voucher XML format predates TallyPrime, so older installations read exactly the same file. Only the menu wording differs between them.

QCan I import several bank statements at once?

Convert them one at a time and import each .xml in turn. Voucher numbers are hashed out of the transaction itself instead of being counted per file, so two months from one account — or the same month from two accounts — cannot land on the same number.

QCan I undo a Tally import?

There is no single undo. Vouchers imported into Tally are ordinary vouchers, so they are removed by deleting them — filter the Day Book to the imported date range and delete from there. Taking a backup of the company before a large import is the standard precaution.

QHow do I convert Excel to XML for Tally Prime?

Upload the spreadsheet above and download the .xml. This is an Excel to XML converter for Tally rather than a general one — the result is a Tally voucher document, an ENVELOPE containing IMPORTDATA with a TALLYMESSAGE per ledger and per voucher, dates written YYYYMMDD and special characters escaped, since a bare ampersand in a narration invalidates the whole file. As an Excel to XML converter for Tally Prime and ERP 9 the output is identical; only the menu wording differs.

QWhat is the best Excel to Tally converter?

It depends on what you are importing. For sales and purchase vouchers with inventory, the paid utilities do more than this does — Excel4Tally runs about ₹99 a month, and Quick2Tally, Janani and Mehta Business Solutions all sell comparable Windows tools. For a bank statement to Tally XML specifically, the work is column detection and clean voucher numbering, both of which happen here. As a free Excel to Tally XML converter online with no signup, it costs nothing to test against whatever you are using now. The installed import utilities are the right answer when you need inventory-bearing sales and purchase vouchers; this is aimed at the bank statement.

QDo I need the Excel to Tally import utility or a TDL file?

No. TDL add-ons extend Tally itself and the import utilities are separate Windows programs; both are alternative routes to the same XML. This produces that XML directly, so Tally's own built-in Import Data menu is all you need on the Tally side.

QIs there a limit on how many rows I can convert?

No voucher cap and no trial ceiling on the file. The practical limits are the 10MB upload size and 50,000 rows from a single sheet, and a bank statement reaches neither — even a busy current account runs to a few thousand lines across a full year.

Other Conversion Formats

PDF to QIF Converter

Convert to QIF

CSV to QIF Converter

Convert to QIF

CSV to QBO Converter

Convert to QBO

CSV to OFX Converter

Convert to OFX

CSV to QFX Converter

Convert to QFX

CSV to IIF Converter

Convert to IIF

Import the spreadsheet you already have

Your bank sends a workbook. TallyPrime wants vouchers. Convert Excel to XML for Tally in about ten seconds, then hand the .xml to Tally's own Import Data menu and let it post the entries. No account, no install, no template to fill in first, and no cap on how many rows the sheet holds.