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
Contact
For questions or feedback about the GST Reconciliation Tool.
uday@gstreconciliation.in
+91 90521 60079