One row per entry: date, voucher type, debit ledger, credit ledger, amount. Rows with the same date, type and voucher number are merged into one multi-line voucher. . Ledger names must match Tally exactly, or Tally will reject those vouchers.
Your entries
Excel or CSV. Dates are read day-first (DD/MM/YYYY).
IN SHORT
Filingo's Excel to Tally converter turns rows of date, voucher type, debit ledger, credit ledger and amount into XML that TallyPrime and Tally.ERP 9 import directly. It merges rows into multi-line vouchers, lists rows it could not use, and can create missing ledgers. It is free, unlimited and runs in the browser.
STEP BY STEP
How it works
- Download the template: date, voucher type, voucher number, debit ledger, credit ledger, amount, narration.
- Fill it in or paste from your working. Rows that share a date, type and voucher number become one multi-line voucher.
- Download the XML and import it in Tally: Import → Transactions.
GOOD TO KNOW
Common questions
- Why did Tally reject some vouchers?
- Almost always a ledger name that does not exist in Tally exactly as typed. The tool lists every ledger used so you can compare, and can create the missing ones under a group you choose.
- Which voucher types are supported?
- Payment, Receipt, Journal, Contra, Sales, Purchase, Debit Note and Credit Note, in accounting-voucher mode without inventory.