GST E-Invoice: Generate IRN Directly from Excel

GST e-invoicing has become a fact of life for Indian businesses. What started as a mandate for large enterprises with turnover above Rs 500 crore has steadily expanded, and today businesses with turnover exceeding Rs 5 crore must generate e-invoices for every B2B transaction. The process involves submitting invoice details to the Invoice Registration Portal (IRP), receiving a unique Invoice Reference Number (IRN) and a signed QR code, and including both on the printed invoice.

For businesses issuing dozens or hundreds of invoices daily, generating each IRN individually on the GST portal is painfully slow. TallyConnects offers a faster path: prepare your invoices in Excel, validate the data, and generate IRNs in bulk — all from a single interface.

Understanding E-Invoice and IRN

An e-invoice is not a separate type of invoice. It is your regular tax invoice that has been registered on the government’s IRP system. When you submit invoice data to the IRP, it returns:

• IRN (Invoice Reference Number) — a 64-character unique hash derived from the supplier GSTIN, invoice number, and financial year.
• Signed QR Code — a digitally signed QR code that can be scanned to verify the invoice authenticity.
• Acknowledgement Number and Date — a confirmation that the IRP has accepted the invoice.

Both the IRN and QR code must appear on the printed invoice. The buyer can use the QR code to verify the invoice on the GST portal.

Who Needs to Generate E-Invoices?

The e-invoice mandate applies based on aggregate annual turnover in any financial year from 2017-18 onwards:

E-invoicing applies to B2B supply invoices, credit notes, and debit notes. It does not apply to B2C transactions, imports, or supplies by SEZ units.

Step 1: Prepare Invoice Data in Excel

Your Excel file needs to contain all the fields required by the e-invoice schema. The key fields include:

• Supplier GSTIN, legal name, and address
• Buyer GSTIN, legal name, and address
• Invoice number and date
• HSN code for each line item
• Quantity, unit, rate, and taxable value
• CGST, SGST, or IGST amounts
• Total invoice value

TallyConnects provides an e-invoice-ready template with all required columns pre-configured. You can paste data from your billing system or ERP export directly into this template.

Step 2: Validate Against E-Invoice Schema

Before submitting to the IRP, TallyConnects validates every row against the government’s e-invoice schema. The validation checks include:

• GSTIN format — verifies the 15-character structure and checksum digit for both supplier and buyer.
• HSN code validity — checks that the HSN code exists in the official HSN master list and has the correct number of digits.
• Tax calculation — recalculates CGST, SGST, and IGST based on the taxable value and GST rate to ensure amounts match.
• Mandatory fields — ensures no required field is blank.
• Invoice number format — checks length (max 16 characters) and allowed characters.

Errors are flagged with specific messages so you know exactly what to fix. This pre-validation saves significant time by catching issues before they hit the IRP, where errors mean wasted API calls and confusing government-side error codes.

Step 3: Generate IRNs in Bulk

Once all rows pass validation, click Generate E-Invoices. TallyConnects submits each invoice to the IRP via the official API and retrieves the IRN, signed QR code, and acknowledgement details.

The process runs in batch mode. For 100 invoices, it typically takes 2 to 3 minutes depending on IRP server response times. A progress indicator shows the current status.

After completion, you get a results summary showing successful and failed invoices. The IRN, QR code, and acknowledgement number are stored alongside each invoice row.

Step 4: Handle Errors and Resubmit

If some invoices fail at the IRP, TallyConnects shows the exact error code and description returned by the government system. Common errors include:

• Duplicate IRN — the invoice number already has an IRN generated for the same financial year. This usually means the invoice was submitted previously.
• Invalid GSTIN — the buyer or supplier GSTIN is inactive or does not exist.
• HSN mismatch — the HSN code does not match the expected category for the GST rate applied.

Fix the errors in your Excel data and click Resubmit Failed. Only the failed rows are reprocessed.

Step 5: Print E-Invoices with IRN and QR Code

After successful IRN generation, you can print the invoices with the IRN and QR code embedded. TallyConnects provides a print template that places the QR code in the top-right corner and the IRN at the bottom of the invoice, following the standard format recommended by GSTN.

You can also export the IRN data back to Excel for your records or to import into other systems.

Benefits of Bulk E-Invoice Generation

• Speed — generate IRNs for 100 invoices in minutes instead of spending hours on the GST portal.
• Accuracy — pre-validation catches errors before submission, reducing failed requests.
• Convenience — work in Excel, the tool accountants already know. No need to learn the GST portal interface.
• Record keeping — all IRNs, QR codes, and acknowledgement details are saved and exportable.

Frequently Asked Questions