Purchase Register vs GSTR-2B Reconciliation
Upload your books and GSTR-2B data, run invoice-level reconciliation in your browser and download a structured Excel report with matched and unmatched records.
Start Reconciliation
Before uploading, please follow the two mandatory data rules highlighted below.
The Invoice Type / Document Type entered in Purchase Register and GSTR-2B must be the same. If GSTR-2B shows a Credit Note, the Purchase Register must also show Credit Note. The same rule applies to Debit Notes and Invoices. Reconciliation will be blocked if the same GSTIN + invoice reference is found with different document types.
Do not enter negative numbers in Taxable Value, IGST, CGST or SGST. For Credit Notes and Debit Notes, enter the amounts as positive values and identify the document through the Document Type field. Use 0 only where a tax component is genuinely not applicable.
Purchase Register — Books
GSTR-2B — Portal Data
The tool will validate your files first, including negative values and document-type consistency.
| Category | Vendor Name | GSTIN | Document Type | Invoice No (PR) | Invoice No (2B) | Date (PR) | Date (2B) | Taxable (PR) | Taxable (2B) | IGST (PR) | IGST (2B) | CGST (PR) | CGST (2B) | SGST (PR) | SGST (2B) |
|---|
How to Use
Follow these steps every time you perform a reconciliation.
1. Download the Master Excel Template
Use the Download Excel Template button. The workbook contains separate Purchase Register and GSTR-2B sheets plus an instruction sheet.
2. Mandatory: Keep Document Type identical
If an invoice is shown as Credit Note in GSTR-2B, it must also be entered as Credit Note in the Purchase Register. Do not classify the same document as Invoice in one file and Credit Note in the other.
3. Mandatory: No negative values
Enter Taxable Value, IGST, CGST and SGST as positive/non-negative amounts only. For Credit Notes or Debit Notes, enter positive amounts and use the Document Type field to identify the document. Do not use minus signs.
4. Upload the Purchase Register
Upload .xlsx, .xls or .csv. If an Excel file contains multiple sheets, select the correct Purchase Register sheet after upload.
5. Upload GSTR-2B
Upload the GSTR-2B workbook/CSV and select the correct sheet. The tool reads the columns from the selected sheet.
6. Check mandatory fields
Use consistent GSTIN, Invoice Number, Document Type, Invoice Date, Taxable Value, IGST, CGST and SGST. Do not change column meanings between the two files.
7. Run Reconciliation
The tool validates the data and then compares records using GSTIN, document type, invoice number and tax values. Close invoice-number variations can be considered in the second matching pass.
8. Review before relying on the result
Matched records should still be reviewed against the source documents and your accounting/tax records. A reconciliation result is a working tool output and does not itself constitute a GST filing decision.
What this tool checks
- GSTIN-level invoice comparison
- Document Type / Invoice Type consistency
- Invoice number normalization and close matching
- Taxable value comparison
- IGST, CGST and SGST comparison
- Matched invoice allocation without duplicate use
- Purchase Register records not found in 2B
- 2B records not found in Purchase Register
GST 2B Reconciliation Guide
Understand the basic process of reconciling your Purchase Register with GSTR-2B before deciding the eligible input tax credit (ITC) for your working papers.
What is GSTR-2B reconciliation?
GSTR-2B reconciliation is the process of comparing purchase invoices recorded in your books with the documents appearing in GSTR-2B. The comparison helps identify invoices that match, invoices with differences, and purchase records that are not appearing in GSTR-2B.
Why reconcile Purchase Register with GSTR-2B?
A reconciliation can help the accounts and tax team identify missing supplier invoices, duplicate records, invoice-number differences and tax-value differences before preparing GST workings. The output should be reviewed with the underlying invoices and GST records.
What does this tool compare?
The tool uses supplier GSTIN, document type, invoice number and tax-related values to compare records. It reports matched invoices, partial/value differences, Purchase Register records not found in 2B and 2B records not found in the Purchase Register.
How to use the reconciliation result
Review exceptions against your books, supplier invoices and GST portal data. The downloaded Excel report is a reconciliation working paper; it should not by itself be treated as a GST return or as conclusive evidence of ITC eligibility.
GST Reconciliation FAQ
Common questions about Purchase Register and GSTR-2B reconciliation.
Contact
For questions or feedback about the GST Reconciliation Tool.
uday@gstreconciliation.in
+91 90521 60079