Matching Offline Tool By GSTN

Sakshi Jain
Sakshi Jain at March 07, 2023

Table of Contents

Automate your GST Compliances with Masters India

Request Callback

GSTN Matching Offline Tool 

On 13 September 2020, the Government had released the Offline GST Matching Tool v1.0 on the GST portal. This tool helps taxpayers to view Form GSTR-2B (Auto-drafted Input tax credit (ITC) statement) and match the details in this form with the purchase register offline. In this article, we will help you understand:

How Does The Matching Offline Tool Help Taxpayers?

GSTR-2B was recently introduced to support the process of availing Input Tax Credit (ITC). This is an auto-drafted static statement determining the ITC available to a taxpayer. Therefore, with the help of the Matching Offline Tool, taxpayers can:

  • Match the ITC as per the purchase register with the ITC shown in the auto-drafted GSTR-2B.
  • Based on the Matching Report, taxpayers can claim the correct ITC while filing Form GSTR-3B.

This matching tool once downloaded and installed, can be used offline without an active internet connection.

How To Download The Matching Tool?

This tool can be downloaded without logging in to the GST Portal. See the steps for GSTR-2B matching tool download.

Step 1: Vist http://www.gst.gov.in/ Step 2: Under ‘Downloads’, select ‘Offline Tools’ > ‘Matching Offline Tool’.

Matching Offline Tool GSTN

Step 3: Download the tool.

Matching Offline Tool GSTN   Matching Offline Tool GSTN

How To Install The Matching Tool?

Prerequisites before installation

  1. The windows operating systems should be 7.0 and above.
  2. The system should be of 32 bit or 64 bit.
  3. The Microsoft Excel version on the user’s computer system should be Microsoft Office Excel 2007 and above. If users chose to import data in CSV format from other accounting software, Excel is not necessary.
  4. User should have admin rights of the system.

Steps to install the Matching Tool

Step 1: Extract Matching_Offline_Tool.zip and run the GSTR2B_Matching_Tool_v1.0.exe.

Matching Offline Tool GSTN

Step 2: Select a folder to setup GSTR 2B Matching Tool. Check the ‘Create Desktop Icon’ checkbox and click ‘Next’.

Matching Offline Tool GSTN

Step 3: Install GSTR2B_Matching_Tool.

Matching Offline Tool GSTN

Keep both checkboxes checked and click on ‘Finish’ to complete the installation.

Matching Offline Tool GSTN

How To Use The Matching Tool?

Step 1: Download the GSTR-2B JSON file from the GST Portal and save it in the computer system. This file can be downloaded from the GST portal. On the user dashboard select - ‘Services’ > ‘Returns’ > ‘Returns Dashboard’ > Select the ‘Financial Year’ and ‘Return period’ > ‘Auto-drafted ITC Statement GSTR-2B (Download)’ > ‘Create JSON file to download’.

Step 2: Add the GST profile in the offline tool.

Matching Offline Tool GSTN Matching Offline Tool GSTN

Step 3: Select the ‘GSTIN’, ‘Financial Year’, ‘Tax Period’ and proceed.

Matching Offline Tool GSTN

Step 4: Import the saved JSON file of GSTR-2B.

Matching Offline Tool GSTN Matching Offline Tool GSTN

Step 5: Prepare the purchase register. Purchase register maintained in any format other than the format provided in the template available as part of the Matching Offline Tool will not get imported into the tool. To ensure the tool functions as designed:

  • Open the purchase register template from the downloaded zip file,
  • Enter GSTIN.
  • Select the applicable ‘Financial Year’ from the drop-down. It is a mandatory field.
  • Select the applicable return period from the drop-down. It is a mandatory field.
  • Add details.

Sample purchase register:

Matching Offline Tool GSTN

Step 6: Import the purchase register in Excel or .csv file and match the GSTR-2B with purchase register.

Matching Offline Tool GSTN   Matching Offline Tool GSTN  

Step 7: Refine match results as required.

Matching Offline Tool GSTN

Image source: GSTN The summary section gives a birds-eye view of the matching performed. To view the details of matching results, click the text that appears in blue.

Other Pointers

  • The Matching Report shows results based on the pre-set parameters that can csvbe filtered for a condensed view. The parameters include:
    • GSTIN
    • Document type
    • Document number
    • Document date
    • Taxable value
    • Total tax amount
      • Integrated tax
      • Central tax
      • State/UT tax
      • Matching Offline Tool
      • Designed and Developed by GSTN Page 36 of 46
      • Cess
    • This report will also show details of records that are not available in the purchase register but available in GSTR-2B or vice versa.
    • The other categories in the matching results are:
      • Exact match (All seven parameters match)
      • Partial/Probable match (6 out of 7 parameters match)
      • Unmatched
    • Users can download the details of matching results in CSV/Excel format using ‘Export to CSV’ option
How useful was this post?
Click on a star to rate it!
Average rating 4.43 / 5. Vote count: 106
GST Software
Best GST Software for Return Filing & Billing in India

Check out other Similar Posts

No Data found
No Blogs to show
Need Help in Getting Started?
Make smart decision to replace your manual work with modern solution and improve your business output
Request Callback
Continue Browsing
Subscribe Now!
Receive GST, E way bill, e-Invoice, Accounts payable and OCR updates from our experts.