E-Invoice › Excel ꯗꯒꯤ ꯕꯂꯛ ꯏ-ꯏꯟꯚꯣꯏꯁ
Excel ꯗꯒꯤ ꯕꯂꯛ ꯏ-ꯏꯟꯚꯣꯏꯁ: ꯏꯟꯚꯣꯏꯁ ꯀꯌꯥꯒꯤꯗꯃꯛ ꯐꯥꯏꯜ ꯑꯃ
IRP ꯒꯤ bulk upload ꯅꯥ ꯏꯟꯚꯣꯏꯁ ꯀꯌꯥ ꯂꯩꯕ JSON ꯐꯥꯏꯜ ꯑꯃ ꯂꯧꯏ꯫ ꯏꯟꯚꯣꯏꯁ ꯈꯨꯗꯤꯡꯃꯛ ꯏꯔꯕꯒꯤ ꯃꯍꯨꯠꯇ, Excel ꯁꯤꯠ ꯑꯃ ꯃꯄꯨꯡ ꯐꯥꯍꯟꯃꯨ ꯑꯃꯁꯨꯡ ꯃꯦꯀꯔꯅ ꯏꯟꯚꯣꯏꯁ ꯈꯨꯗꯤꯡꯃꯛ ꯑꯍꯥꯅꯕꯗ ꯆꯦꯛ ꯇꯧꯗꯨꯅ ꯐꯥꯏꯜ ꯑꯗꯨ ꯑꯣꯏꯍꯅꯕꯤꯌꯨ꯫
ꯈꯣꯡꯊꯥꯡ ꯈꯣꯡꯊꯥꯡ
- "Many invoices at once from Excel" ꯒꯤ ꯈꯣꯡꯊꯥꯡ 1 ꯗ ꯅꯍꯥꯛꯀꯤ ꯕꯤꯖꯅꯦꯁ ꯈꯟꯕꯤꯌꯨ꯫ ꯃꯁꯤ ꯅꯍꯥꯛꯅ ꯁꯦꯚ ꯇꯧꯈꯤꯕ ꯕꯤꯖꯅꯦꯁꯁꯤꯡꯗꯒꯤ ꯂꯥꯛꯀꯅꯤ (ꯂꯤꯁ꯭ꯠ ꯑꯁꯤ ꯈꯥꯎꯔꯕꯗꯤ ꯑꯩꯒꯤ ꯗꯦꯇꯥ ꯗ ꯑꯃ ꯍꯥꯄꯆꯤꯟꯕꯤꯌꯨ)꯫ ꯃꯗꯨꯒꯤ GSTIN, ꯑꯦꯗ꯭ꯔꯦꯁ, ꯁꯍꯔ, PIN ꯑꯃꯁꯨꯡ ꯁ꯭ꯇꯦꯠ ꯏꯟꯚꯣꯏꯁ ꯈꯨꯗꯤꯡꯃꯛꯇ ꯍꯥꯄꯆꯤꯅꯒꯅꯤ꯫ ꯅꯍꯥꯛꯀꯤ ꯇꯔꯅꯑꯣꯚꯔ ꯁꯨ ꯈꯟꯕꯤꯌꯨ꯫
- "Download the Excel template" ꯗ ꯇꯥꯎ ꯇꯧꯕꯤꯌꯨ꯫ ꯃꯁꯤ Excel, Google Sheets ꯅꯠꯇ꯭ꯔꯒꯥ LibreOffice ꯗ ꯍꯥꯡꯗꯣꯛꯀꯅꯤ꯫ ꯑꯍꯥꯅꯕ ꯁꯤꯠꯇ ꯈꯨꯗꯝ ꯔꯣ ꯑꯅꯤ ꯂꯩ; ꯑꯅꯤꯁꯨꯕ ꯁꯤꯠ How to fill ꯅꯥ ꯀꯣꯂꯝ ꯈꯨꯗꯤꯡꯃꯛ ꯈꯟꯗꯨꯅ ꯉꯥꯡꯏ꯫
- ꯑꯥꯏꯇꯦꯝ ꯑꯃꯗ ꯔꯣ ꯑꯃ ꯃꯄꯨꯡ ꯐꯥꯍꯟꯕꯤꯌꯨ꯫ Invoice No ꯃꯥꯟꯅꯕ ꯔꯣꯁꯤꯡꯅ ꯏꯟꯚꯣꯏꯁ ꯑꯃꯥ ꯑꯣꯏꯒꯅꯤ; ꯕꯥꯌꯔꯒꯤ ꯗꯤꯇꯦꯜ ꯃꯗꯨꯒꯤ ꯑꯍꯥꯅꯕ ꯔꯣꯗꯒꯤ ꯄꯥꯒꯅꯤ꯫ ꯈꯨꯗꯝꯁꯤꯡ ꯂꯧꯊꯣꯛꯎ꯫
- ꯐꯥꯏꯜ ꯁꯦꯚ ꯇꯧꯕꯤꯌꯨ Excel (.xlsx) ꯑꯣꯏꯅ, ꯅꯠꯇ꯭ꯔꯒꯥ CSV UTF-8 ꯑꯣꯏꯅ, ꯑꯗꯨꯒꯥ "Choose your Excel or CSV file" ꯗ ꯇꯥꯎ ꯇꯧꯕꯤꯌꯨ꯫
- ꯂꯤꯁ꯭ꯠ ꯄꯥꯕꯤꯌꯨ꯫ ꯏꯟꯚꯣꯏꯁ ꯈꯨꯗꯤꯡꯃꯛꯇ Ready ꯅꯠꯇ꯭ꯔꯒꯥ ꯀꯔꯤ ꯆꯨꯃꯊꯣꯛꯀꯗꯒꯦ ꯍꯥꯌꯕ ꯔꯣ ꯅꯝꯕꯔꯒꯥ ꯂꯣꯌꯅꯅ ꯎꯠꯀꯅꯤ꯫ ꯔꯣ ꯑꯗꯨꯁꯤꯡ Excel ꯗ ꯆꯨꯃꯊꯣꯛꯇꯨꯅ, ꯁꯦꯚ ꯇꯧꯗꯨꯅ, ꯐꯥꯏꯜ ꯑꯗꯨ ꯑꯃꯨꯛ ꯈꯟꯕꯤꯌꯨ꯫ ꯆꯨꯃꯒꯗꯕ ꯂꯩꯔꯤꯕ ꯏꯟꯚꯣꯏꯁꯁꯤꯡ ꯐꯥꯏꯜꯗꯒꯤ ꯊꯥꯗꯣꯛꯀꯅꯤ꯫
- "Download e-invoice file" ꯗ ꯇꯥꯎ ꯇꯧꯕꯤꯌꯨ꯫ ꯃꯇꯨꯡꯗ IRN ꯂꯣꯌꯅꯅ ꯃꯐꯝ ꯑꯁꯤꯗ ꯄ꯭ꯔꯤꯟꯠ ꯇꯧꯅꯕ ꯄꯥꯃꯔꯕꯗꯤ Also save these invoices in My data ꯇꯤꯛ ꯇꯧꯗꯨꯅ ꯊꯝꯃꯨ꯫
- einvoice1.gst.gov.in › e-Invoice › Bulk Upload ꯗ ꯑꯞꯂꯣꯗ ꯇꯧꯕꯤꯌꯨ꯫
- ꯈꯣꯡꯊꯥꯡ 3 ꯗ ꯄꯣꯔꯇꯦꯂꯒꯤ ꯄꯥꯎꯈꯨꯝ ꯂꯣꯗ ꯇꯧꯕꯤꯌꯨ: ꯑꯞꯂꯣꯗ ꯇꯧꯔꯕ ꯃꯇꯨꯡꯗ ꯄꯣꯔꯇꯦꯂꯗꯒꯤ ꯗꯥꯎꯅꯂꯣꯗ ꯇꯧꯈꯤꯕ ꯃꯍꯩ ꯐꯥꯏꯜ (JSON, ꯅꯠꯇ꯭ꯔꯒꯥ Excel ꯃꯍꯩ ꯁꯤꯠ)꯫ ꯃꯥꯟꯅꯕ ꯁꯦꯚ ꯇꯧꯔꯕ ꯏꯟꯚꯣꯏꯁ ꯈꯨꯗꯤꯡꯃꯛꯅ IRN, Ack ꯅꯝꯕꯔ ꯑꯃꯁꯨꯡ ꯁꯥꯏꯟ ꯇꯧꯔꯕ QR ꯀꯣꯗ ꯐꯪꯒꯅꯤ꯫ ꯏꯟꯚꯣꯏꯁ ꯑꯃ ꯄ꯭ꯔꯤꯟꯠ ꯇꯧꯅꯕ ꯃꯗꯨꯒꯤ ꯃꯅꯥꯛꯇ Open and print ꯗ ꯇꯥꯎ ꯇꯧꯕꯤꯌꯨ꯫
ꯀꯣꯂꯝꯁꯤꯡ
| ꯀꯣꯂꯝ | ꯀꯔꯤ ꯏꯒꯗꯒꯦ | ꯈꯨꯗꯝ |
|---|---|---|
| ꯏꯟꯚꯣꯏꯁ ꯅꯝꯕꯔ | ꯃꯁꯤꯡ 16 ꯐꯥꯑꯣꯕ: ꯃꯌꯦꯛ, ꯃꯁꯤꯡ, / ꯑꯃꯁꯨꯡ -꯫ 0, / ꯅꯠꯇ꯭ꯔꯒꯥ - ꯅꯥ ꯍꯧꯔꯣꯏ꯫ | INV/26-27/101 |
| ꯏꯟꯚꯣꯏꯁ ꯇꯥꯡ | DD/MM/YYYY, ꯃꯇꯨꯡꯒꯤ ꯇꯥꯡ ꯅꯠꯇꯦ | 05/11/2026 |
| ꯁꯞꯂꯥꯏꯒꯤ ꯃꯈꯜ | B2B, SEZWP, SEZWOP, EXPWP, EXPWOP or DEXP | B2B |
| Reverse Charge | Y or N | N |
| Buyer GSTIN, Name, Address, City, PIN, State Code | ꯔꯦꯖꯤꯁ꯭ꯇꯔ ꯇꯧꯔꯕ ꯃꯇꯧ꯫ ꯁ꯭ꯇꯦꯠ 2 ꯃꯁꯤꯡꯒꯤ GST ꯀꯣꯗ (03 ꯄꯤꯟꯖꯥꯕ, 27 ꯃꯍꯥꯔꯥꯁ꯭ꯇꯔ) ꯅꯠꯇ꯭ꯔꯒꯥ ꯃꯗꯨꯒꯤ ꯃꯤꯡ | 27AAPFU0939F1ZV |
| ꯄ꯭ꯂꯦꯁ ꯑꯣꯐ ꯁꯞꯂꯥꯏ | ꯁ꯭ꯇꯦꯠ ꯀꯣꯗ; ꯈꯥꯎꯔꯕꯗꯤ = ꯕꯥꯌꯔꯒꯤ ꯁ꯭ꯇꯦꯠ | 27 |
| ꯑꯥꯏꯇꯦꯝꯒꯤ ꯗꯤꯁ꯭ꯛꯔꯤꯞꯁꯟ, HSN/SAC | ꯃꯁꯤꯡ 6 ꯅꯠꯇ꯭ꯔꯒꯥ 8 ꯒꯤ HSN ꯅꯠꯇ꯭ꯔꯒꯥ SAC | 52051200 |
| ꯀꯟꯇꯤꯇꯤ, ꯌꯨꯅꯤꯠ, ꯔꯦꯠ, ꯗꯤꯁ꯭ꯀꯥꯎꯟꯠ %, GST % | ꯌꯨꯅꯤꯠ GST ꯀꯣꯗ ꯑꯣꯏꯅ (NOS, KGS, PCS, BOX…); ꯔꯦꯠ GST ꯒꯤ ꯃꯃꯥꯡꯒꯤ | 100 · KGS · 250 · 0 · 5 |
ꯅꯍꯥꯛꯀꯤ ꯃꯁꯥꯒꯤ ꯁꯤꯠꯁꯨ ꯆꯠꯀꯅꯤ, ꯃꯗꯨꯒꯤ ꯍꯦꯗꯤꯡꯁꯤꯡ ꯃꯁꯤꯒꯥ ꯀꯥꯟꯅꯕ ꯑꯣꯏꯔꯕꯗꯤ (ꯈꯨꯗꯝ "Customer GSTIN" ꯅꯠꯇ꯭ꯔꯒꯥ "HSN Code")꯫ Excel ꯗ HSN ꯀꯣꯗ ꯑꯃꯁꯨꯡ ꯁ꯭ꯇꯦꯠ ꯀꯣꯗ ꯇꯦꯛꯁ꯭ꯠ ꯑꯣꯏꯅ ꯏꯕꯤꯌꯨ, ꯃꯔꯝ ꯑꯗꯨꯅ ꯍꯧꯔꯀꯄꯥ ꯖꯤꯔꯣ (0401, 03) ꯂꯣꯏꯗꯕ꯫ ꯑꯩꯈꯣꯌꯒꯤ ꯇꯦꯝꯞꯂꯦꯠꯅ ꯃꯗꯨ ꯍꯧꯖꯤꯛꯇ ꯇꯧꯔꯦ꯫
ꯈꯨꯗꯝ ꯑꯃ
ꯂꯨꯗꯤꯌꯥꯅꯥꯒꯤ ꯌꯥꯔꯟ ꯂꯩꯐꯝ ꯑꯃꯅ (ꯁ꯭ꯇꯦꯠ 03) 5 ꯅꯣꯚꯦꯝꯕꯔ 2026 ꯗ ꯕꯥꯌꯔ ꯑꯅꯤꯒꯤꯗꯃꯛ ꯕꯤꯜ ꯁꯦꯝꯃꯤ:
| ꯏꯟꯚꯣꯏꯁ ꯅꯝꯕꯔ | ꯕꯥꯌꯔ ꯁ꯭ꯇꯦꯠ | ꯑꯥꯏꯇꯦꯝ | ꯀꯟꯇꯤꯇꯤ × ꯔꯦꯠ | GST | Tax |
|---|---|---|---|---|---|
| INV/26-27/101 | 27 ꯃꯍꯥꯔꯥꯁ꯭ꯇꯔ | ꯌꯥꯔꯟ, HSN 52051200 | 100 × ₹250 | 5% | IGST ₹1,250 |
| INV/26-27/101 | (ꯏꯟꯚꯣꯏꯁ ꯑꯗꯨꯃꯛ) | ꯌꯥꯔꯟ, HSN 52052400 | 40 × ₹310 | 5% | IGST ₹620 |
| INV/26-27/102 | 03 ꯄꯤꯟꯖꯥꯕ | ꯌꯥꯔꯟ, HSN 52051200 | 60 × ₹250 | 5% | CGST ₹375 + SGST ₹375 |
ꯔꯣ ꯑꯍꯨꯃꯅ ꯏꯟꯚꯣꯏꯁ ꯑꯅꯤ ꯑꯣꯏꯒꯅꯤ꯫ ꯏꯟꯚꯣꯏꯁ 101 ꯑꯁꯤ ꯁ꯭ꯇꯦꯠ ꯑꯅꯤꯒꯤ ꯃꯔꯛꯇ (₹37,400 + IGST ₹1,870 = ₹39,270); ꯏꯟꯚꯣꯏꯁ 102 ꯑꯁꯤ ꯄꯤꯟꯖꯥꯕꯀꯤ ꯃꯅꯨꯡꯗ ꯂꯩ (₹15,000 + ₹750 = ₹15,750)꯫ ꯐꯥꯏꯜ ꯑꯃꯅ ꯑꯅꯤꯃꯛ ꯄꯨꯒꯅꯤ꯫
ꯐꯥꯏꯜ ꯌꯥꯗꯕ ꯍꯧꯔꯀꯄꯥ ꯑꯔꯥꯅꯕꯁꯤꯡ
- ꯏꯟꯚꯣꯏꯁ ꯅꯝꯕꯔ ꯑꯁꯤ ꯍꯥꯟꯅꯕꯗꯒꯤ ꯔꯦꯖꯤꯁ꯭ꯇꯔ ꯇꯧꯔꯦ (ꯅꯝꯕꯔ ꯈꯨꯗꯤꯡꯃꯛꯅ IRN ꯑꯃꯈꯛ ꯐꯪꯒꯅꯤ, ꯀꯦꯟꯁꯦꯜ ꯇꯧꯔꯕꯁꯨ)꯫
- ꯃꯁꯤꯡ 4 ꯒꯤ HSN ꯀꯣꯗꯁꯤꯡ, ꯅꯠꯇ꯭ꯔꯒꯥ GST HSN ꯂꯤꯁ꯭ꯠꯇ ꯂꯩꯇꯕ ꯀꯣꯗꯁꯤꯡ꯫
- ꯈꯟꯂꯕ ꯁ꯭ꯇꯦꯠꯀꯥ ꯃꯥꯟꯅꯗꯕ PIN ꯀꯣꯗ꯫
- ꯑꯔꯥꯅꯕ GSTIN, ꯅꯠꯇ꯭ꯔꯒꯥ ꯀꯦꯟꯁꯦꯜ ꯇꯧꯔꯕ ꯕꯥꯌꯔ GSTIN꯫
- ₹10 ꯀ꯭ꯔꯣꯔ ꯅꯠꯇ꯭ꯔꯒꯥ ꯍꯦꯟꯅ ꯂꯩꯕ ꯕꯤꯖꯅꯦꯁꯁꯤꯡꯒꯤꯗꯃꯛ ꯅꯨꯃꯤꯠ 30 ꯗꯒꯤ ꯑꯔꯤꯕ ꯏꯟꯚꯣꯏꯁꯁꯤꯡ꯫
ꯑꯍꯥꯅꯕꯗ ꯐꯥꯏꯜ ꯆꯥꯎꯗꯕ ꯑꯃ ꯇꯧꯕꯤꯌꯨ꯫ ꯊꯥ ꯑꯃ ꯃꯄꯨꯡ ꯐꯥꯕꯒꯤ ꯃꯃꯥꯡꯗ ꯏꯟꯚꯣꯏꯁ ꯑꯅꯤ ꯅꯠꯇ꯭ꯔꯒꯥ ꯑꯍꯨꯝ ꯑꯞꯂꯣꯗ ꯇꯧꯕꯤꯌꯨ꯫ ꯄꯣꯔꯇꯦꯂꯅ ꯑꯃ ꯌꯥꯗꯔꯕꯗꯤ ꯃꯗꯨꯒꯤ ꯑꯔꯥꯅꯕꯅ ꯐꯤꯂꯗꯀꯤ ꯃꯤꯡ ꯍꯥꯌꯒꯅꯤ: ꯔꯣ ꯑꯗꯨ ꯆꯨꯃꯊꯣꯛꯇꯨꯅ ꯐꯥꯏꯜ ꯑꯃꯨꯛ ꯁꯦꯝꯃꯨ꯫ IRP ꯅꯥ ꯃꯁꯥꯒꯤ Excel ꯅꯤꯡꯇꯥ bulk ꯇꯨꯜ ꯁꯨ ꯄꯤꯔꯤ; ꯀꯅꯥꯅꯨꯡ ꯌꯥꯕ ꯑꯗꯨ ꯁꯤꯖꯤꯟꯅꯧ꯫
ꯍꯧꯖꯤꯛ ꯅꯍꯥꯛꯀꯤ ꯏ-ꯏꯟꯚꯣꯏꯁ ꯐꯥꯏꯜ ꯁꯦꯝꯃꯨ꯫ ꯏꯟꯚꯣꯏꯁ ꯑꯃ ꯅꯠꯇ꯭ꯔꯒꯥ ꯁꯤꯠ ꯃꯄꯨꯡ꯫ꯃꯦꯀꯔ ꯍꯥꯡꯗꯣꯛꯎ