E-Invoice IRN Reconciliation Template

Match Invoice Reference Numbers between your books and the IRP portal. Identify mismatched, missing, and pending IRNs before filing your GST returns.

No signup required No watermarks Ready-to-use template
ARSP
50K+ downloads by Accountants & Finance Controllers
IRN Reconciliation Summary
INV-2024-001Matched
INV-2024-002Matched
INV-2024-003Mismatch
INV-2024-004Pending
2 Matched
1 Mismatch
1 Pending

Build your e-invoice IRN reconciliation

Enter invoice details and IRN numbers from your books and the IRP portal to see the matching status in real time.

1

Company details

2

Invoice & IRN details

2
Matched
0
Mismatch
1
Pending
Live preview

Set up your IRN reconciliation in four steps

1

Download

Pick Excel, Word, or PDF. Each format has columns for invoice details, book-side IRN, portal-side IRN, and a status column.

2

Enter company details

Fill in your company name, GSTIN, financial year, and the month you are reconciling.

3

List invoices

Enter each invoice with its number, date, taxable value, GST amount, and the IRN from your books and the IRP portal.

4

Review and resolve

The template flags matched, mismatched, and pending invoices. Generate missing IRNs and fix mismatches before your GSTR-1 filing.

Download a ready-to-use template

Grab a blank template in the format that fits your workflow.

Excel (.xlsx)

Spreadsheet with formulas. Best for bulk IRN reconciliation with auto-matching.

Word (.docx)

Pre-formatted document. Best for sharing with auditors and compliance teams.

PDF

Print-ready layout. Best for audit workpapers and compliance documentation.

Future-proof your finance operations, today

Stop reconciling e-invoices manually. Let automation match IRNs, flag mismatches, and sync with your GSTR-1 in real time.

Book a demo →

How e-invoice IRN reconciliation works

E-invoice reconciliation ensures every B2B invoice that should carry an IRN actually has one, and the details on the IRP portal match your accounting records.

1

Extract invoice data

Pull all B2B invoices from your ERP or accounting system for the reconciliation period, including invoice number, date, and taxable amounts.

2

Download portal data

Export the list of IRNs generated on the IRP portal for the same period. The portal export includes the IRN, invoice reference, and generation timestamp.

3

Match invoice to IRN

Map each invoice in your books to its corresponding IRN on the portal. Flag invoices with no IRN (pending) or a different IRN (mismatch).

4

Investigate exceptions

Common causes: IRN not generated within the 30-day window, cancelled IRN without a replacement, or data entry errors in the invoice JSON payload.

5

Resolve and file

Generate missing IRNs, correct mismatched data, and confirm all eligible invoices are covered before your GSTR-1 filing deadline.

Do this, avoid that

E-invoice compliance is mandatory for eligible businesses. These practices keep your IRN reconciliation clean and penalty-free.

✓ Do
Generate IRNs within 30 days of invoice dateThe IRP portal rejects IRN generation requests after the 30-day window. Late generation means an invalid invoice and ITC denial for the buyer.
Reconcile IRNs before GSTR-1 filingSince e-invoice data auto-populates GSTR-1, catching mismatches before the filing deadline prevents amendments and interest charges.
Validate JSON payload before submissionRun the NIC-provided schema validation on your e-invoice JSON before pushing to the IRP. This catches field-level errors (wrong HSN codes, missing mandatory fields) early.
Keep a log of cancelled IRNsEvery cancelled IRN must have a corresponding credit note with its own IRN. Track cancellations and replacements to avoid orphaned records.
Automate IRN generation from your ERPManual generation through the portal interface does not scale. API-based generation from your ERP ensures every eligible invoice gets an IRN without human intervention.
✗ Avoid
Skipping IRN for invoices just below the thresholdThe turnover threshold applies to aggregate turnover, not individual invoice value. Every B2B invoice from an eligible business must carry an IRN.
Relying solely on GSTR-1 auto-populationAuto-population transfers the data, but it does not verify it against your books. Always reconcile the auto-populated GSTR-1 against your sales register.
Cancelling IRNs after 24 hoursThe IRP portal allows cancellation only within 24 hours of generation. After that, you must issue a credit note against the original and generate a new IRN for it.
Using incorrect HSN codes in the e-invoiceHSN code errors cause the IRN to be generated with wrong data. This creates mismatches in GSTR-1 and can trigger scrutiny notices from the tax department.
Ignoring IRN generation failuresWhen the IRP returns an error, the invoice has no IRN. Track all failed requests, fix the underlying data issue, and retry. A missing IRN means an invalid invoice under GST law.

E-invoice and IRN terms, explained

IRN (Invoice Reference Number)
A unique 64-character hash generated by the IRP portal for every e-invoice. It serves as the invoice's digital identity under the GST e-invoicing framework.
IRP (Invoice Registration Portal)
The government portal that receives e-invoice JSON payloads, validates them against the schema, generates the IRN and QR code, and digitally signs the invoice.
QR Code
A machine-readable code generated alongside the IRN. It contains key invoice parameters (GSTIN, invoice number, date, value, IRN) and allows offline verification of the e-invoice.
E-Invoice Schema
The standardized JSON format defined by GSTN/NIC for submitting invoice data to the IRP. It includes mandatory and optional fields covering supplier, buyer, item, and tax details.
GSTIN
The 15-digit Goods and Services Tax Identification Number assigned to every GST-registered business in India. It is a mandatory field in every e-invoice JSON payload.
HSN Code
The Harmonized System of Nomenclature code that classifies goods for tax purposes. E-invoices require HSN codes at the line-item level to determine the applicable GST rate.
E-Way Bill
A document required for the movement of goods above ₹50,000 in value. When an e-invoice is generated, Part A of the e-way bill is auto-populated from the IRN data.
JSON Payload
The structured data packet sent to the IRP portal for IRN generation. It follows the NIC schema and includes supplier details, buyer details, item details, and tax breakup.
Digital Signature
The cryptographic signature applied by the IRP portal to the e-invoice after validation. It certifies that the invoice data has been registered and has not been tampered with.

Frequently asked questions

E-invoice IRN reconciliation is the process of matching the Invoice Reference Numbers generated on the IRP portal against the invoices recorded in your accounting system. It ensures every invoice that should have been reported was reported, and the details match what your books show.

Yes. There is no cost, no account creation, and no watermark on any format. The interactive tool runs entirely in your browser and the downloadable files are yours to keep and reuse.

As of 2024, businesses with an aggregate annual turnover exceeding ₹5 crore must generate e-invoices through the IRP portal for all B2B supplies. The threshold has been progressively lowered from ₹500 crore when the mandate started in October 2020.

The invoice is considered invalid under GST law. The buyer cannot claim ITC on it, and penalties may apply for non-compliance. The supplier must generate the IRN within 30 days of the invoice date.

Yes, but only within 24 hours of IRN generation on the IRP portal. After 24 hours, you must issue a credit note against the original invoice and generate a new IRN for the credit note.

When you generate an IRN on the IRP portal, the invoice details are automatically populated in your GSTR-1 return. Reconciling IRNs ensures your GSTR-1 is accurate and complete, reducing manual data entry errors.

Templates work when you process a few dozen invoices per month. Once volumes grow into hundreds or thousands of invoices, automation handles bulk IRN generation, real-time status tracking, and auto-reconciliation against your ERP far more reliably.

Browse all finance templates

View all templates →