Business
Excel / CSV to Tally Converter
Turn a spreadsheet of sales, purchases, receipts and payments into Tally import XML — vouchers, party ledgers and stock items — and bring Tally’s exported XML back into Excel. Runs in your browser; nothing is uploaded.
Privacy
Your file never leaves your device. It is read and converted by your own browser, so nothing is uploaded, queued or logged — which is what makes this safe for a client’s books.
Tips
- Column names are matched automatically — “Invoice No”, “Vch No” and “Voucher Number” all land on Voucher No — and you can correct any match before converting. Save a mapping once and it is remembered on this device.
- One row per voucher is the simplest layout: date, type, number, party, amount, and the tax columns you use. The tool debits and credits the right ledgers for Sales, Purchase, Receipt, Payment, Journal and Contra.
- One row per ledger line suits exports from other software: a voucher number to group by, a ledger, and Debit and Credit columns. Every voucher is checked to balance before anything is written.
- Tick “Create missing party ledgers” and the download includes a second file of ledger masters — import that first, then the vouchers, and Tally will not stop on an unknown party.
- Import into a test company first. The XML is built to Tally’s documented structure and checked for balance, but Tally’s own validation — ledger names, GST classifications, voucher numbering rules — runs only when it imports.
- Bringing data out: export from Tally with Gateway of Tally → Display → Day Book (or Ledger), Alt+E, format XML. Drop that file here and download it as Excel or CSV, one row per voucher or per ledger line.
Frequently asked questions
Is my accounting data uploaded anywhere?
No. The spreadsheet is unzipped and read by your own browser, the XML is written by your own browser, and the download comes from memory. Nothing is transmitted — which is why this works with the network off and why it is safe for a client’s books.
How do I import the XML into Tally?
Tally Prime: Gateway of Tally → Import → Vouchers (or Masters), choose the file, keep “Combine opening balances” for masters, and import. Tally ERP 9: Gateway of Tally → Import Data → Vouchers. Open the company you want the entries in first: the file carries no company name unless you type one in the options.
Tally says a ledger does not exist. What now?
Every ledger named in a voucher must already exist in the company — the party, the sales or purchase account, the tax ledgers, the bank. Tick “Create missing party ledgers” to get a masters file for the parties, import it first, and make sure your account and tax ledgers are spelled exactly as they are in Tally, including capitals.
Why does a voucher fail the balance check?
In Tally every voucher’s debits equal its credits. In one-row-per-voucher mode the tool works that out for you from the amount and taxes. In one-row-per-line mode it adds up your Debit and Credit columns for each voucher number and stops if they differ by more than a paisa — usually a missing line, a typo in a voucher number, or a rounding difference that needs a Round Off line.
Does it handle GST?
Sales and purchase vouchers carry CGST, SGST and IGST as separate ledger lines when you map those columns, so the amounts land on your tax ledgers exactly as typed. It does not calculate tax for you, and it does not write the GST classification details a stock item needs for Tally’s returns beyond HSN and rate — check those in Tally after import.
Which Tally versions?
The XML follows the Import Data envelope that Tally ERP 9 and Tally Prime both read. It has been checked for structure and balance, not imported into every release of Tally, so the first run should go into a test company.