Tally Sales Invoice Importer

1 Upload Data File

📂

Click to browse or drag & drop here

Supports .csv, .xlsx, .xls

2 Column Mapping & Settings

Column Mapping

Column index (0 = first column). Adjust if your file layout differs.

Import Mode

Non-GST With GST (5% inclusive)

5% GST inclusive mode Base = Total ÷ 1.05 · CGST = 2.5% of base · SGST = 2.5% of base

Ledger Names & Defaults

Sales Ledger

Unit of Measurement

Voucher Type

Output CGST Ledger

Output SGST Ledger

Godown / Location

Batch Name

Company Name
blank = active company

Header Row?

Party ledgers are bill-wise (adds New Ref bill reference)

Leave unchecked for cash sales (Sales-Cash) — matches how your existing vouchers are recorded.

Auto-create Masters (if not present in Tally)

Auto-create Party Ledgers

Auto-create Stock Items

Voucher Numbering

If voucher number 1 already exists in your company, importing with the same number will fail with a misleading "voucher date is missing" error. Use Auto or Start-from to avoid conflicts.

Use voucher number from CSV column Recommended Auto — Tally assigns the next available number Start sequence from:

3 Preview

4 Download

▸ View generated XML (preview)

How to import in Tally Prime:
1. Make sure target Company is open
2. Gateway of Tally → Import → Data → Select the downloaded .xml
3. If you get errors, try Masters Only first, then Vouchers Only
4. After import, check Day Book for the new vouchers