Home Resources How do I? GST Compliance – Matching Offline Tool

GST Compliance – Matching Offline Tool

0
386

Matching Offline Tool – Reconciliation of GSTR-2B with Purchase Register

Edition: September 2025
Disclaimer: This manual is prepared for educational and compliance facilitation purposes. It does not substitute the provisions of law, notifications, or circulars issued by the Government. Readers are advised to refer to the original statutory provisions wherever required.


✍️ Preface

The Matching Offline Tool is a utility provided by GSTN to enable taxpayers to reconcile auto-drafted Input Tax Credit (ITC) details from GSTR-2B with their own purchase register. The reconciliation process helps detect mismatches, partial matches, and ineligible credits before filing returns.

This manual consolidates the law provisions, purpose, stepwise tool usage, FAQs with statutory basis, and a compliance checklist for effective ITC reconciliation.


📑 Table of Contents

  1. The Law Governing ITC Reconciliation

  2. Purpose of the Matching Offline Tool

  3. System Requirements

  4. Step-by-Step Process (How Do I)

  5. Practical FAQs (with Basis)

  6. Compliance Checklist (Fillable Format)


⚖️ 1. The Law Governing ITC Reconciliation

  • Section 16, CGST Act, 2017 – Conditions for availing ITC.

  • Section 37 & 38, CGST Act – Furnishing outward and inward supplies.

  • Rule 36, CGST Rules, 2017 – Documentary requirements and restrictions on ITC.

  • Rule 60, CGST Rules, 2017 – Details in GSTR-2A/2B for ITC availability.

  • Circulars/Notifications – Prescribe tolerance and matching criteria for ITC availment.


📝 2. Purpose of the Matching Offline Tool

  • To import and view GSTR-2B JSON file downloaded from GST Portal.

  • To import Purchase Register maintained by taxpayer.

  • To auto-match supplier invoices from GSTR-2B with purchase register data.

  • To categorize results into:

    • Exact Match

    • Partial Match

    • Probable Match

    • Unmatched

  • To refine matching by setting tolerance limits and approximation rules.


💻 3. System Requirements

  • OS: Windows 7 & above (64-bit recommended).

  • Software: MS Excel 2007 & above, or Open Office.

  • Disk Space: 200 MB minimum.

  • Internet: Required only for downloading GSTR-2B JSON from GST Portal.


🛠️ 4. How Do I – Stepwise Process

Step 1: Download Tool

  • Visit www.gst.gov.in.

  • Navigate: Downloads > Offline Tools > Matching Offline Tool.

  • Install tool on system.

Step 2: Prepare GSTR-2B Data

  • Login GST Portal → Download GSTR-2B JSON file for period.

  • Save locally.

Step 3: Import GSTR-2B JSON into Tool

  • Open Matching Tool → Import JSON.

  • Data (invoices, suppliers, GSTINs, tax amounts) will be populated.

Step 4: Import Purchase Register

  • Import purchase register in Excel/CSV.

  • Ensure correct format (Invoice No., Date, GSTIN, Taxable Value, Tax Amount).

Step 5: Perform Matching

  • Tool auto-matches GSTR-2B with Purchase Register.

  • Results shown in categories (Exact/Partial/Probable/Unmatched).

Step 6: Refine Matching

  • Adjust tolerance limits (e.g., ₹1 or 2%).

  • Use approximation options (Invoice No. similarity, date differences).

Step 7: Review Results

  • Download matching summary reports.

  • Export results for record keeping.


❓ 5. Practical FAQs (with Basis)

Q1. What is GSTR-2B?
A static monthly auto-drafted ITC statement. (Rule 60, CGST Rules)

Q2. Why use the Matching Tool?
To reconcile supplier invoices with purchase register, detect mismatches before ITC claim. (Sec. 16, CGST Act)

Q3. Can tool be used without internet?
Yes, once GSTR-2B JSON is downloaded. (GSTN Manual)

Q4. What file formats are accepted?
Purchase register in Excel/CSV; GSTR-2B in JSON. (Tool Specs)

Q5. What are matching results?
Exact, Partial, Probable, and Unmatched invoices. (GSTN FAQ)

Q6. What is tolerance limit?
Allowed margin for mismatch in values (e.g., rounding difference). (Circular clarifications)

Q7. Can unmatched invoices still claim ITC?
No, ITC allowed only if reflected in GSTR-2B. (Rule 36(4), CGST Rules)

Q8. Can I save results?
Yes, results can be exported to Excel for record. (Tool Manual)

Q9. Is tool mandatory?
No, optional aid for reconciliation. (GSTN FAQ)

Q10. Does tool work for multiple GSTINs?
Yes, separate matching can be done GSTIN-wise. (Tool Manual)


✅ 6. Compliance Checklist (Fillable Format)

Step Particulars Status (✔)
1 Download Matching Tool ⬜
2 Download GSTR-2B JSON from Portal ⬜
3 Import GSTR-2B JSON into Tool ⬜
4 Import Purchase Register (Excel/CSV) ⬜
5 Run auto-match process ⬜
6 Review Exact/Partial/Probable/Unmatched results ⬜
7 Apply tolerance/approximation settings ⬜
8 Export reconciliation report ⬜
9 Adjust books/returns accordingly ⬜

LEAVE A REPLY