Bulk convert Excel sales registers or purchase registers into Tally invoice vouchers with item inventory allocations, automatic or manual GST calculation, round-off handling, and party ledger creation.
Select your Entry Type at the top of the form:
Sundry Debtors); Sales Ledger & Taxes are Credited.Sundry Creditors); Purchase Ledger & Taxes are Debited. Also embeds Supplier Invoice <REFERENCE> tags.When checked, you only need a GST Rate (%) column in your Excel (e.g. 3, 5, 12, 18). VinTax automatically computes 50% CGST and 50% SGST. When unchecked, it reads explicit CGST & SGST amount columns from your file.
Enable Auto Round Off to automatically calculate the fraction required to round each invoice to the nearest whole rupee, or supply a dedicated Round Off column from your billing sheet.
| Field | Default Header Name | Sample Value |
|---|---|---|
| Date | Date | 01-04-2026 |
| Invoice / Voucher No. | Invoice No. | INV-001 |
| Party / Customer Name | Party Name | Sharma Jewellers |
| Item / Product Name | Item Name | Gold Ring 22K |
| Quantity (Gram/Pcs) | Quantity (gram) | 12.50 |
| Taxable Value | Taxable Value | 85000.00 |
| GST Rate / CGST / SGST | GST Rate or CGST / SGST | 3.0 or 1275.00 |
| Round Off (optional) | Round Off | -0.50 |
Sales, CGST, SGST, Round Off).