Excel to Tally Sales XML Converter — Free Online Tool
Bulk-import customer invoices into Tally Prime without manual entry. Upload your Excel sales register, preview the data, and download a ready-to-import XML file in seconds.
1 Download the Excel Template
Use this template as your starting point. Replace the sample rows with your actual sales data.
2 Upload Your Excel File
Supports .xlsx and .xls files. Your file never leaves your browser.
📋 Key Features of this Tool:
- • Strict Party Grouping: Same Voucher No. + Same Party → merged. Different party = separate voucher.
- • Manual Tax Mode: You enter IGST/CGST/SGST amounts directly — no auto-calculation guesswork.
- • Special Char Fix: &, quotes, <, > in party names are auto-escaped. No more Tally crashes.
- • Flexible Dates: DD/MM/YYYY, YYYY-MM-DD, Excel serial — all handled correctly.
3 Preview & Validate
Showing first 10 rows. All rows will be processed.
4 Generate & Download XML
Review the summary above, then click to generate your Tally-ready XML file.
How to Use the Sales XML Converter
Follow these steps to convert your sales register Excel to Tally XML:
-
1
Download and fill the Excel template
Click "Download Sales Template" above. Open it in Excel or Google Sheets. Replace the sample rows with your actual customer invoice data. Each row = one line item in a sales invoice.
-
2
For multi-line invoices, use the same Voucher No + Party Name
If an invoice has multiple line items (e.g., Sales @ 5% and Sales @ 18%), put both on separate rows with the same Voucher No and Party Name. The tool will group them into one voucher automatically.
-
3
Enter tax amounts manually
For inter-state sales (IGST), enter the IGST amount and IGST ledger name. For intra-state (CGST+SGST), leave IGST blank and fill CGST Amount and SGST Amount. The tool switches modes automatically per row.
-
4
Upload, preview, and download
Upload the filled Excel file. Review the first 10 rows in the preview table. Check the validation summary for any skipped rows. Then click "Generate Sales XML" to download your XML file.
How to Import This XML into Tally Prime
Once you've downloaded the XML file, follow these steps inside Tally Prime:
-
1
Open Tally Prime and select your Company. Make sure the company name in your Excel template matches exactly what's in Tally (column: "Company Name").
-
2
In Tally Prime, go to Import (Alt+O) → Transactions. (In older Tally ERP 9: Gateway of Tally → Import of Data → Vouchers)
-
3
In the file path field, browse to the downloaded XML file (e.g.,
Sales_Import_1234567890.xml) and press Enter. -
4
Tally will show an import progress screen. On success, it displays "Vouchers created: X". If you see errors, check the common error fixes guide.
-
5
Verify: Go to Sales Register to confirm all vouchers appear correctly with the right dates, party names, amounts, and tax ledgers.
Excel Template Column Guide
Every column in the Sales template explained:
| Column | Required? | Example | Notes |
|---|---|---|---|
| Date | Required | 01/03/2026 | Accepts DD/MM/YYYY, YYYY-MM-DD, or Excel date format. |
| Company Name | Required | M/S ANITA BHANDAR | Must match your Tally company name exactly. |
| Voucher No | Required | GST/001 | Your sales invoice number. Rows with same Voucher No + Party Name are merged into one voucher. |
| Party Name | Required | CASH or CUSTOMER A | Ledger name of the customer as in Tally. Use "CASH" for cash sales. |
| Sales Ledger | Required | Sales @ 18% | The sales ledger name in Tally (e.g., "Sales @ 5%", "Sales @ 18%"). |
| Taxable Amount | Required | 1000.00 | The base/taxable value of the sale (before GST). |
| IGST Ledger | Conditional | IGST | IGST ledger name in Tally. Required only if IGST Amount > 0. |
| IGST Amount | Conditional | 180.00 | Inter-state tax. If IGST > 0, CGST/SGST columns are ignored for that row. |
| CGST Amount | Conditional | 90.00 | Intra-state CGST. Used when IGST = 0. |
| SGST Amount | Conditional | 90.00 | Intra-state SGST. Equal to CGST in most cases. |
| Round Off | Optional | 0.40 | Round-off amount (positive or negative). Maps to "Round Off" ledger in Tally. |
Sales Tool — FAQ
Does this tool work for both IGST and CGST+SGST sales?
Yes. For each row in your Excel file, you can independently specify either IGST or CGST+SGST. If the IGST Amount column is greater than 0, the tool uses IGST mode for that row. If IGST Amount is 0 or blank, it uses CGST+SGST. This means a single Excel file can contain both inter-state and intra-state sales.
Can I use "CASH" as the party name for cash sales?
Yes. Enter "CASH" (or whatever your cash ledger is named in Tally) in the Party Name column. The tool uses whatever you enter as the party ledger name. Make sure the name matches your Tally ledger exactly.
My Sales ledger names in Tally are different from the sample. How do I change them?
Simply type your actual Tally ledger names in the "Sales Ledger" column. For example, if your ledger is called "Sales-Local 18%", type exactly that. The tool uses whatever you enter — it doesn't have a fixed list. Just make sure the spelling matches your Tally ledger exactly.
What is the difference between this tool and the Purchase XML Converter?
The Sales tool generates Sales vouchers where the party (customer) ledger is on the debit side (positive amount) and the sales/tax ledgers are on the credit side. The Purchase tool is the reverse — supplier is credited and purchase/tax ledgers are debited. The XML polarity (ISDEEMEDPOSITIVE) is set correctly for each type.
Will this work for B2B and B2C sales both?
Yes. For B2B sales, enter the customer's ledger name (as in Tally) in the Party Name column. For B2C (cash) sales, use "CASH" or your cash ledger name. There is no restriction on the party type — any ledger name that exists in Tally will work.