Matching Offline Tool By GSTN

Team Masters India
Team Masters India at March 15, 2022
Matching Offline Tool By GSTN
On 13 September 2020, the Government had released the GST Matching Offline 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. Step 1: Vist 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 and run the GSTR2B_Matching_Tool_v1.0.exe. Matching Offline Tool GSTN Step 2: Select a folder to setup GSTR2B_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

Search Your interest

You can also get latest updates on Whatsapp!

Browse other topics

Check out other Similar Posts
No Data found
No articles found