GSTR-1 vs E-Invoice Reconciliation
Match your GSTR-1 data against the e-invoice (IRP) portal, spot missing or extra entries, and export the result to Excel — instantly, right in your browser.
Updated June 2026
Import GSTR-1
Drag and drop files here, or click to select files
Only .json and .xlsx files are accepted
Import E-Invoice
Drag and drop files here, or click to select files
Only .xlsx files are accepted
What this reconciliation tool does
Match both sources
Reconcile GSTR-1 against e-invoice data — sales, credit and debit notes.
4 reconciliation views
See all entries, present in both, only in GSTR-1, or only in e-invoice.
Export to Excel
Download the matched and unmatched entries as a clean Excel workbook.
Runs in your browser
Files are processed locally and never uploaded to any server.
Functionality of the tool
Reconcile your GSTR-1 against e-invoice data in seconds. E-invoicing is mandatory for businesses with annual turnover above ₹5 crore, and every invoice carries an IRN from the official e-invoice portal. Download the GSTR-1 Excel format.
- Reconcile GSTR-1 and e-Invoice (Sales, Credit & Debit Notes).
- All reconciled data is shown in green color, while un-reconciled data is shown in red color.
How to use the tool
- 1Upload a JSON or Excel file in the GSTR-1 section. You can also upload more than one file.
- 2Upload the XLSX file(s) exported from the e-invoice (IRP) portal in the e-Invoice section. You can also upload more than one file.
- 3A dropdown will be shown with 4 options:All Entries — all entries from both GSTR-1 and e-Invoice (entries in both are shown as a single entry).
Present in both — entries present in both GSTR-1 and e-Invoice.
Only in GSTR-1 — entries only in GSTR-1.
Only in e-Invoice — entries only in e-Invoice. - 4Group by Supplier GSTIN or see a total summary. Filter by party using the dropdown on the right, or by clicking any GSTIN in the supplier-wise view.
- 5Search for any invoice number, GSTIN, amount or field, then click the Download Excel button to export the reconciled data.
Frequently asked questions
What is GSTR-1 vs e-invoice reconciliation and why does it matter?
It compares the sales, credit and debit notes reported in your GSTR-1 with the invoices reported on the e-invoice (IRP) portal. Matching the two ensures every e-invoice is reflected in GSTR-1 and there are no missing or extra entries before you file.
What files do I upload to reconcile GSTR-1 and e-invoice data?
Upload your GSTR-1 as a JSON or Excel file in the GSTR-1 section, and your e-invoice data as the XLSX file exported from the e-invoice (IRP) portal in the e-Invoice section. You can upload more than one file in each section.
How does the matching work?
The tool matches invoices across both sources and shows reconciled entries in green and un-reconciled entries in red. A dropdown lets you view All Entries, entries present in both, entries only in GSTR-1, or entries only in e-invoice.
Is my GSTR-1 and e-invoice data safe?
Yes. All reconciliation happens locally in your browser. Your GSTR-1 and e-invoice files are never uploaded to or stored on any server.
Can I export the reconciled data to Excel?
Yes. After reconciling, click the Download Excel button to export the matched and unmatched entries as an Excel workbook for review, sharing or your records.
Who is required to generate e-invoices?
E-invoicing is mandatory for businesses whose aggregate annual turnover exceeds ₹5 crore. Each B2B invoice must be reported to the e-invoice (IRP) portal, which returns an IRN and signed QR code — so reconciling GSTR-1 against e-invoice data confirms every reported invoice is also in your return.
Related GST tools
More free tools to speed up your GST compliance.
GSTR-2A and Purchases Reconciliation
Reconcile GSTR-2A with Purchases (GSTR-2)
GSTR-2B and Purchases Reconciliation
Reconcile GSTR-2B with Purchases (GSTR-2)
GSTR-1
Convert GSTR-1 Excel to JSON for uploading on GST portal or check GSTR-1 JSON data and download in Excel
GSTR-2
Convert JSON to Excel or Excel to JSON or view JSON data.
GSTR-3B
Convert Excel to JSON for uploading on GST portal or view JSON data.
GSTR-2A
Convert JSON to Excel or view JSON data.