Excel to Tally Purchase XML Converter — Free Online Tool
Import multiple supplier invoices into Tally Prime without manual entry. Upload your Excel purchase 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 purchase 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 Purchase XML Converter
Follow these steps to convert your purchase register Excel to Tally XML:
-
1
Download and fill the Excel template
Click "Download Purchase Template" above. Open it in Excel or Google Sheets. Replace the sample rows with your actual supplier invoice data. Each row = one line item in a purchase invoice.
-
2
For multi-line invoices, use the same Voucher No + Party Name
If an invoice has multiple line items (e.g., Purchase @ 5% and Purchase @ 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 purchases (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 Purchase 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.,
Purchase_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 Purchase 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 Purchase 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 (case-insensitive is fine). |
| Voucher No | Required | PUR/101 | Supplier invoice number. Rows with same Voucher No + Party Name are merged into one voucher. |
| Party Name | Required | SUPPLIER A & CO | Ledger name of the supplier as in Tally. Special chars (&, ') are auto-escaped. |
| Purchase Ledger | Required | Purchase @ 18% | The purchase ledger name in Tally (e.g., "Purchase @ 5%", "Purchase @ 18%"). |
| Taxable Amount | Required | 1000.00 | The base/taxable value of the purchase (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. |
Purchase Tool — FAQ
Does this tool work for both inter-state (IGST) and intra-state (CGST+SGST) purchases?
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 purchases from different suppliers.
What does "Party Grouping" mean and why is it important?
Party Grouping means multiple Excel rows that belong to the same voucher are combined into one Tally voucher. The grouping key is Voucher No + Party Name. This is critical because two different suppliers may use the same invoice number — using Voucher No alone would wrongly merge them into one entry in Tally.
My Purchase ledger names in Tally are different from the sample. How do I change them?
Simply type your actual Tally ledger names in the "Purchase Ledger" column. For example, if your ledger is called "Purchases-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 happens if my Excel file has extra blank rows or header rows?
Rows with a blank or missing Voucher No are automatically skipped and listed in the validation summary as "skipped rows". Extra header rows below row 1 may cause issues — keep only one header row (row 1) in your Excel file. Blank rows in the middle of data are safe to have; they'll be skipped without affecting other vouchers.
Will this work for RCM (Reverse Charge Mechanism) purchases?
The current version generates standard purchase vouchers with the ledger names you specify. For RCM entries, you can use separate tax ledger names (e.g., "IGST RCM", "CGST RCM Payable") and enter the amounts accordingly. The voucher structure will be the same; the ledger names will reflect the RCM treatment as you set up in Tally.