# GST E-Invoice IRN Tracking Log Worksheet > Source: https://netray.co/tools/gst-e-invoice-irn-log-worksheet-india > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable register of e-invoices with IRN, acknowledgement number, status and the 24-hour cancellation window. ## Category regional ## Region India ## Audience - Accounts executive - ERP administrator - Tax manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** Rs **Columns:** #### Document no. **Key:** doc_no **Type:** text #### Document date **Key:** doc_date **Type:** date #### Type **Key:** doc_type **Type:** select **Options:** - INV - CRN - DBN #### Buyer GSTIN or name **Key:** buyer **Type:** text #### Taxable value (Rs) **Key:** taxable **Type:** number **Format:** currency #### Total tax (Rs) **Key:** tax **Type:** number **Format:** currency #### Invoice value (Rs) **Key:** total **Type:** number **Expr:** taxable + tax **Format:** currency #### IRN (first 12 chars) **Key:** irn **Type:** text #### Ack no. **Key:** ack **Type:** text #### Hours since IRN **Key:** hours **Type:** number **Unit:** hours **Help:** IRN cancellation on the portal is allowed within 24 hours. #### Cancel window open (1 = yes) **Key:** can_cancel **Type:** number **Expr:** if(lte(hours,24),1,0) **Format:** integer #### Status **Key:** status **Type:** select **Options:** - IRN generated - Failed, retry - Cancelled - Pending **Rows:** **Doc no:** INV/26-27/0412 **Doc date:** 2026-10-14 **Doc type:** INV **Buyer:** 29BBBBB1111B1Z6 **Taxable:** 125000 **Tax:** 22500 **Irn:** a7f3c91e04b2 **Ack:** 142611000451 **Hours:** 120 **Status:** IRN generated **Doc no:** INV/26-27/0413 **Doc date:** 2026-10-15 **Doc type:** INV **Buyer:** 27CCCCC2222C1Z7 **Taxable:** 84000 **Tax:** 15120 **Irn:** 5d02e8aa91c4 **Ack:** 142611000502 **Hours:** 96 **Status:** IRN generated **Doc no:** CRN/26-27/0021 **Doc date:** 2026-10-18 **Doc type:** CRN **Buyer:** 29BBBBB1111B1Z6 **Taxable:** 12000 **Tax:** 2160 **Irn:** 9bc4417de6f0 **Ack:** 142611000588 **Hours:** 20 **Status:** IRN generated **Doc no:** INV/26-27/0420 **Doc date:** 2026-10-18 **Doc type:** INV **Buyer:** 33DDDDD3333D1Z8 **Taxable:** 56000 **Tax:** 10080 **Hours:** 0 **Status:** Failed, retry **Doc no:** INV/26-27/0415 **Doc date:** 2026-10-16 **Doc type:** INV **Buyer:** 24EEEEE4444E1Z9 **Taxable:** 31000 **Tax:** 5580 **Irn:** c18a77d3e250 **Ack:** 142611000530 **Hours:** 70 **Status:** Cancelled **Totals:** #### Total taxable value **Key:** taxable **Agg:** sum **Format:** currency #### Total tax **Key:** tax **Agg:** sum **Format:** currency #### Total invoice value **Key:** total **Agg:** sum **Format:** currency #### Documents logged **Key:** doc_no **Agg:** count **Format:** integer **Summary:** #### Tax as share of taxable value **Key:** tax_share **Expr:** if(gt(sum_taxable,0), sum_tax / sum_taxable * 100, 0) **Format:** percent **Primary:** true #### Average invoice value **Key:** avg_inv **Expr:** if(gt(count,0), sum_total / count, 0) **Format:** currency **Notes:** Keep this log next to your ERP e-invoice interface so every failed or cancelled IRN has an owner. After 24 hours an IRN cannot be cancelled on the portal; the usual route is a credit note. The IRN is a 64-character hash, so store the full value in your ERP and only a short reference here. ## Content **Intro:** E-invoicing works only when every invoice gets an IRN, and failures often surface days later during a buyer query or a GSTR-1 mismatch. This log gives your accounts team one place to track each document, its IRN, its acknowledgement and whether it can still be cancelled. **Sections:** #### How to use the log **Body:** Add one row per e-invoice, credit note or debit note. Enter the taxable value, tax, the first characters of the IRN and the acknowledgement number returned by the invoice registration portal. Update the hours since IRN so you know if the 24-hour cancellation window is still open. Failed rows should be retried the same day, because the supply and the tax point are not affected by an IRN delay. **Bullets:** - Reconcile the log to your sales register weekly. - Do not reuse an invoice number after cancelling an IRN. - Archive the signed JSON and QR code with the invoice PDF. #### How e-invoicing works **Body:** The seller sends invoice data in the notified schema to the Invoice Registration Portal, which returns a unique 64-character Invoice Reference Number, an acknowledgement number and date, and a signed QR code. The details flow to GSTR-1 and to the buyer's GSTR-2B. Applicability depends on aggregate turnover, and the limit has been lowered over time, so check the current notification. Invoices without a valid IRN may not be treated as valid invoices for ITC by the buyer. #### Mistakes to avoid **Body:** Cancelled IRNs that are not reversed in the ERP cause duplicate numbers. Another is editing an invoice after the IRN is created, which makes the printed document differ from the registered one. Reporting time limits for older invoices have also been introduced for larger taxpayers, so do not let failed documents age. Keep a reason code for each cancellation, such as wrong GSTIN or wrong value. **Bullets:** - Editing the invoice after IRN generation. - Printing invoices before IRN is received. - No owner for failed e-invoice retries. **Cta:** If your IRN retries are manual, we can help you build a monitored e-invoice queue between your ERP and the portal. **Faq:** #### Can I cancel an IRN after 24 hours? **Answer:** No. The portal allows cancellation only within 24 hours of generation, and only if no e-way bill was generated and GSTR-1 was not filed with that invoice. After that, issue a credit note or amendment as the law allows. #### Is the IRN the same as the acknowledgement number? **Answer:** No. The IRN is a 64-character hash generated from the supplier GSTIN, document type, number and financial year. The acknowledgement number is a sequential reference issued by the portal along with the date. #### Who must use e-invoicing? **Answer:** Registered persons whose aggregate turnover crosses the notified threshold in any year since 2017-18, with some exceptions such as certain financial and insurance entities. The limit has been lowered several times, so confirm with the current notification. #### Does the e-invoice generate the e-way bill? **Answer:** The IRN data can be used to generate the e-way bill Part A, and many ERPs do both in one call. Keep the e-way bill number in your ERP against the invoice so that dispatch and tax records agree. ## Search terms e-invoice IRN log excel, IRN tracking sheet, e-invoice register format, IRN cancellation 24 hours, e-invoice reconciliation sheet, e-invoice failed IRN log, GST e-invoice register --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json