Free tools › CSV/Excel to Tally XML
CSV / Excel to Tally-compatible XML
Turn a spreadsheet of bank entries into vouchers you can import. Works with exports from KhataSheet, other converters or your own sheets.
Voucher settings
Questions
What format should my sheet be in?
One row per bank entry with a date and either separate Debit and Credit columns, or one Amount column plus a Dr/Cr column. A Narration, Ref and Ledger column are optional. Dates can be dd/mm/yyyy, dd-mm-yy, 01-Apr-2024 or real Excel dates.
Which vouchers are created?
Money out of the bank becomes a Payment voucher (Dr ledger, Cr bank). Money in becomes a Receipt voucher (Dr bank, Cr ledger). Rows whose ledger is in your Contra list (for example Cash) become Contra vouchers.
How do I import the XML?
In TallyPrime: Gateway → Import → Transactions (and Import → Masters for the ledger file). In Tally.ERP 9: Gateway → Import of Data → Vouchers / Masters. Import masters first so that every ledger exists, and choose "Ignore Duplicates" as the behaviour for masters that already exist, so your existing ledgers keep their groups. Re-importing the same file updates its vouchers instead of duplicating them. The voucher dates must fall inside the company's financial year.
What if a ledger name is blank?
The row is posted to the default ledger you choose, typically a suspense ledger, so you can reclassify it later in your books.