FAQs and User Manual – Matching Offline Tool
GST
Dated:- 17-9-2020
=============
\nDocument 1GIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\nFAQs and User Manual – Matching Offline Tool
\nGoods and Services Tax Network
\nDesigned and Developed by GSTN
\nPage 1 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\nTable of Contents
\n(A) About Matching Offline Tool
\n(B) FAQS > Download and Install Matching Offline Tool
\nB.1. Download Matching Offline Tool\u2026………….
\nB.2. Manage Profile
\n(C) FAQS > View Form GSTR-2B Files in Matching Tool …..
\nC.1. Download Form GSTR-2B JSON files from GST Portal.
\nC.2. Open JSON Files in the Matching Tool
\n(D) FAQs > Import Purchase Register in the Matching Tool ……
\n(E) FAQs > Match Results
\n(F) Download and Install Matching Offline Tool …….
\nF.1. Create Profile……….
\n(G) View Form GSTR-2B Files in Matching Tool……………
\nG.1. Download Form GSTR-2B JSON Files From GST Portal..
\nG.2. Open JSON Files in the Matching<\/p>\n
= = = = = = = =<\/p>\n
Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n sults using features provided in the tool. The tool enables the = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n can only be used on = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n ete button = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n rchase Register section. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n nt type = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n ine Tool option. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n Import of GSTR 2B JSON for IMPG, IMPGSEZ, ISD, ISDA tables. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n rvices Tax = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n TAX NETWORK = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n created a profile in Offline tool, then enter your GSTIN or Trade\/legal name in GSTIN field. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n details in the Matching tool. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n n. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n earch Taxpayer \u00e2\u2013\u00bc Help and Taxpayer Facilities = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n rd > Returns > GSTR-2B = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n ble for Viewing = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n D Credits received – ISDA = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n le % of tax = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n gs in GSTR-3B = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n \nIMPORT EXCEL\/CSV = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n 2000 = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n urchase register. = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n .00 = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n cument type = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n Invoice = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n ult Match = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n T Cess (*) ITC availal Supply att Amended Match typ Reason = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n M4(2) In GSTR-2B not in PR = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n m registered persons (B2B) = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n Internal\\Companywide usage = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n into = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n . To refine match results, click the REFINE MATCHING RESULTS button on the match result = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n cord do not exist in GSTR-2B\/PR) = = = = = = = =<\/p>\n Plain text (Extract) only<\/strong> = = = = = = = =<\/p>\n","protected":false},"excerpt":{"rendered":" FAQs and User Manual – Matching Offline Tool GSTDated:- 17-9-2020============= Document 1GIN GOODS AND SERVICES TAX NETWORK Matching Offline Tool FAQs and User Manual – Matching Offline Tool Goods and Services Tax Network Designed and Developed by GSTN Page 1 of 46 GIN GOODS AND SERVICES TAX NETWORK Matching Offline Tool Table of Contents (A) … Continue reading “FAQs and User Manual – Matching Offline Tool”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-68987","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=\/wp\/v2\/posts\/68987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=68987"}],"version-history":[{"count":0,"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=\/wp\/v2\/posts\/68987\/revisions"}],"wp:attachment":[{"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodsandservicetax.in\/GST\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
For full text:-Visit the Source <\/a><\/p>\n
\ntaxpayer to download the matching results in a csv format.
\nThe key features of Matching Offline Tool is that the setails can be matched offline with no
\nconnection to Internet.
\nDesigned and Developed by GSTN
\nPage 3 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\n(B) FAQS > Download and Install Matching
\nOffline Tool
\nB.1. Download Matching Offline Tool
\n1. From where can I download and use the Matching Offline Tool in my
\nsystem?
\nTo download and open the Matching Tool in your system from the GST Portal, perform following
\nsteps:
\n1. Access the GST Portal: www.gst.gov.in.
\n2. Go to Downloads > Offline Tools > Matching Offline Tool option and click on it.
\n3. Select Download.
\n4. Click Proceed.
\n5. Unzip the downloaded Zip file which contain Matching Offline Tool.exe.
\n6. Open the Matching Offline Tool.exe by double clicking on it.
\n7. Select the folder where you intend to install the Matching Offline Tool.
\n8. Click Next.\n<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\ndesktop\/laptops.
\n6. What does downloaded zip folder for Matching Offline Tool contains?
\nThe Zip folder downloaded from the GST portal will consist of the following:
\n\u2022
\n\u2022
\nInstallation file for the offline tool .exe format (Set up file)
\n'Read me' explaining in detail the prerequisites with respect to system requirements
\nand steps for installation of the offline tool
\n\u2022 Offline tool taxpayer manual
\n\u2022
\nChange history text file
\n\u2022
\nPurchase register template
\nB.2. Manage Profile
\n7. Does the Matching Offline Tool contain any Help for each page?
\nOnce you open the tool, you will notice detailed instructions (Contextual to that page) to use the
\ntool, using HELP link on the top-right corner of the tool at each page.
\n8. Can I access Matching Offline tool without creating profile in Offline
\ntool?
\nNo, you cannot access Matching Offline tool without creating a profile in it.
\n9. How can I add my profile in Matching Offline Tool?
\nTo add your profile in Matc<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\navailable on the Modify Profile page.
\n(C) FAQS > View Form GSTR-2B Files
\nMatching Tool
\nC.1. Download Form GSTR-2B JSON files from GST Portal
\n14. Do I need to login to GST Portal to download Form GSTR-2B JSON
\nfile?
\nYes, you must login in to the GST Portal to download GSTR-2B JSON file.
\nin
\n15. From where can I download the Form GSTR-2B JSON file?
\nYou can download the Form GSTR-2B JSON file from Services \u00e2\u2020\u2019 Returns \u00e2\u2020\u2019 Returns Dashboard
\n\u00e2\u2020\u2019 Select the FY and Return period \u00e2\u2020\u2019 GSTR-2B tile (Download) \u00e2\u2020\u2019 Download JSON
\nDesigned and Developed by GSTN
\nPage 6 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\n16. Where can I find the downloaded JSON files from the GST Portal?
\nThe JSON files downloaded from the GST Portal gets saved in the Downloads folder on your
\nmachine.
\nC.2. Open JSON Files in the Matching Tool
\n17. Do I need to open the Matching Offline Tool to open the JSON files
\ndownloaded from the GST Portal?
\nYes, you need to click the Matc<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n21. Can I maintain my Purchase Register in a format other than provided
\non GST portal?
\nPurchase register maintained in a format other than the template provided as part of Matching
\noffline tool will not get imported into the tool.
\n22. What will happen once the Purchase Register is imported in the Offline
\nTool?
\nOnce the Purchase Register is imported in the Offline Tool, you can:
\nView the details as imported from the Purchase Register
\nRemove all the entries imported from the Purchase Register
\nCompare\/Match the entries of imported Purchase Register with the entries of Form
\nGSTR-2B
\n(E) FAQS > Match Results
\n23. What are different categories of matching results?
\nThere are six categories of matching results available in the tool, as explained in table below:
\nCategories of matching results
\nExact match (All 7 parameters
\nmatch)
\nMatching Parameters
\n1.
\nGSTIN
\n2.
\nDocument type
\n3.
\nDocument number
\n4.
\nDocument date
\n5.
\nTotal taxable value
\n6. Total tax amount
\n7. Tax amount head <\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nDocument number
\nDocument date
\nBUT there is a mismatch on one or more of following
\nparameters, beyond the tolerance limit set:
\nTotal taxable value
\nTotal tax amount
\nTax amount head wise
\nIntegrated tax
\n.
\n\u2022
\nCentral tax
\n\u2022
\n\u2022
\nCESS
\nState\/UT tax
\nAll documents that exist in Form GSTR-2B, but could not
\nbe found in PR, (i.e. not classified in any of the
\nCategories of matching results above), will be
\nclassified in this category.
\nAll documents that exist in PR, but could not be found in
\nForm GSTR-2B, (i.e. not classified in any of the
\nPage 9 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nCategories of matching results
\nMatching Parameters
\nMatching Offline Tool
\nCategories of matching results above), will be
\nclassified in this category.
\n24. What is the function of the Refine Matching Result option on the
\nMatching Tool?
\nThe REFINE MATCHING RESULT option enables you to refine the match results by altering the
\ntolerance value for Integrated, Central, State\/UT tax or Cess.
\nYou may als<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nDashboard
\nServices \u00e2\u2013\u00bc
\nGST Law
\nDownloads \u00e2\u2013\u00bc Search Taxpayer-
\nHelp and Taxpayer Facilities E-Invoice
\nOffline Tools
\nAccounting and Billing Software
\nReturns Offline Tool
\nTran-1 Offline Tools
\nGSTR3B Offline Utility
\nITC03 Offline Tool
\nMatching Offline Tool
\nTran-2 Offline Tools
\nITC01 Offline Tool
\nITC04 Offline Tool
\nGSTR 4 Offline Tool
\nGST ARA 01 – Application for Advance Ruling
\nGSTR 6 Offline Tool With Amendments
\nRefunds Offline Tools
\nGSTR8 Offline Tool
\nGSTR-9 Offline Tool
\nGSTR-9C Offline Tool
\nReap Returns Offline Tool
\nGSTR 11 Offline Tool
\nGSTR7 Offline Utility
\nGSTR10 Offline Tool
\nGSTR-9A Offline Tool
\nGSTR-4 (Annual) offline tool
\nReap GSTR 6 Offline Tool With Amendments
\n16
\nYou can download the Matching Offline Tool from the Portal without logging in to the
\nGST Portal (using the Downloads option).
\n3. The Matching Tool page is displayed. Click the Download hyperlink.
\nMake sure you carefully read the Important message and System Requirement
\ndetails displayed on the pag<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n\u2022 IMPG, IMPGSEZ, ISD, ISDA tables data view with sorting, filter and pagination.
\n\u2022 Export as CSV option in IMPG, IMPGSEZ, ISD, ISDA table.
\n\u2022 Providing matching summary as match category wise on post refinement with export as excel & CSV download for each match bucket.
\nGSTR-2B view summary with navigation for each table from summary table.
\n\u2022 Data deletion option at landing page to remove return period wise data on limit exceed.
\nGSTR-2B tables CSV download with filter enabled data.
\nSystem Requirement
\nTo use the tool efficiently, ensure that you have the following installed on your system:
\n1. Operating system \u00e2\u2020\u2019 Windows 7 or above. The tool does not work
\non Linux and Mac.
\n2. Browser: You need one of these browsers installed on your
\nsystem.
\n\u2022 Internet Explorer 10+
\n\u2022 Google Chrome 7+
\n3. Microsoft Excel 2007 & above
\n4. Alternatively, for any below version the tool will open in a default
\nbro<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nHome Services \u00e2\u2013\u00be
\nGST Law
\nDownloads
\nSearch Taxpayer-
\nHelp and Taxpayer Facilities
\ne-Invoice
\nMatching Offline Tool
\nSkip
\nMain Content O
\nMatching Offline T…ap
\nHome Downloads Return
\nMatching Offline Tool v1.01
\nThe Matching Offline Tool can be used in offline mode to:
\n1. View GSTR-ZD
\n2. Match GSTR-28 with Purchase Register
\nTo install the tool, please download, extract the zip file and run the Download
\nYour downloaded (Matching Offline Tool) zip file contains:
\nMatchingOffineToolLv1.0 (Application)
\nPurchase Register Excel Template
\nReadme
\n. User Manual
\nChange History
\nImportant!
\nBefore you extract and run the downloaded file, ensure that the file is not corrupted. How do I know that my file is not corrupt? Click here to know
\nmore.
\nGo through the Readme document before you begin installation.
\n\u00e2\u0161\u00ab Double-click on Matching Offline Tool to install the offline tool.
\nWhat's new with Matching Offline Tool v1.0 (Released on 27\/08\/2020)
\nOpening the GSTR-28 JSON in offline tool.
\nImpor<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nName
\nGSTR2B_Offline Matching_Tool_Offline_…
\nPurchaseRegister Template V1.0
\nDate modified
\nType
\nSize
\n8\/17\/2020 4:39 PM
\n8\/17\/2020 4:39 PM
\nApplication
\nMicrosoft Excel W…
\n23,512 KB
\n24 KB
\nSetup – GSTR2B_Offline_Matching_Tool_Offline_Tool_v…
\nSelect Destination Location
\nWhere should GSTR 2B_Offline Matching_Tool be installed?
\nSetup will install GSTR 2B_Offline Matching_Tool into the following folder.
\nTo continue, click Next. If you would like to select a different folder, click Browse.
\nC:\\GSTR2B_Offline Matching Tool
\nBrowse…
\nAt least 71.1 MB of free disk space is required.
\nNext >
\nCancel
\nMatching Offline Tool
\n9. Select Create a desktop shortcut checkbox to create a shortcut for the Matching Tool on
\nyour desktop.
\n10. Click Next.
\nName
\nDate modified
\nGSTR2B_Offline_Matching_Tool_Offline_…
\nPurchaseRegister_Template V1.0
\n8\/17\/2020 4:39 PM
\n8\/17\/2020 4:39 PM
\n\u00d0\u00a2\u00d1\u0192\u00d1\u20ac\u00d0\u00b5
\nApplication
\nMicrosoft Excel W…
\nSize
\n23,512 KB
\n24 KB
\nSetup – GSTR2B_Offline_Matching_Tool_Offline_Tool_v.<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n2. Trade\/Legal name shall be auto filled based on the GSTIN or Trade\/legal name entered in 'GSTIN field'.
\n3. Select Financial year and Tax period from the drop down.
\n4. Click on Proceed (Proceed button shall be enabled only after filling up all mandatory fields)
\ni No profile added. Please create profile of a taxpayer by clicking on 'Manage profile' option.
\nGSTIN\u00e2\u0161\u00ab
\nTrade\/Legal name:
\nFinancial Year\u00e2\u009d\u00a4
\nTax Period\u00e2\u00ad\u2018:
\nSelect
\nSelect
\nThe Matching Tool installation is a one-time activity.
\nManage Profile e\u00e2\u2013\u00be
\nDelete File(s)
\nDesigned and Developed by GSTN
\nPage 17 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\nF.1. Create Profile
\nUse the links provided on the Matching Offline Tool (Form GSTR-2B with purchase order) page
\nto create your profile.
\nTo create a profile in the Matching tool, perform the following steps:
\n1. On the Goods and Services Tax Matching Tool (Form GSTR-2B<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nOX
\nGood and Services Tax Matching Tool
\nAdd Profile
\n34BOGPS8935H6ZB
\nGSTIN of Taxpayer\u00e2\u0161\u00ab
\nGSTN
\nTrade\/Legal name\u00e2\u0161\u00ab
\nNo
\nHELP
\n\u2022 Indicates mandatory fields
\nSEZ Unit\/Developer\u00e2\u0161\u00ab
\nBACK
\nSAVE
\n8. Details get added in the Matching tool and another blank row appears to add more details. If
\nrequired, you can delete the row using the
\nicon.
\nGood and Services Tax Matching Tool
\nAdd Profile
\n34BOGPS8935H6ZB
\n9. Click SAVE.
\nGSTIN of Taxpayer\u00e2\u0161\u00ab
\nGSTN
\nTrade\/Legal name.
\nNo
\nSelect
\nHELP
\nIndicates mandatory fields
\nSEZ Unit\/Developer\u00e2\u0161\u00ab
\n+
\nBACK SAVE
\nDesigned and Developed by GSTN
\nPage 19 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nBO
\nGood and Services Tax Matching Tool
\nAdd Profile
\n\u00e2\u2014\u008f Profile(s) saved successfully!
\nGSTIN of Taxpayer\u00e2\u0161\u00ab
\nTrade\/Legal name\u00e2\u0161\u00ab
\nSelect
\nMatching Offline Tool
\nHELP
\n\u2022 Indicates mandatory fields
\nSEZ Unit\/Developer\u00e2\u0161\u00ab
\n10. A confirmation message, \u201cProfile is saved successfully” is displayed.
\n11. Click BACK to go back to the<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nDesigned and Developed by GSTN
\nPage 21 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\n(G) View Form GSTR-2B Files in Matching
\nTool
\nG.1. Download Form GSTR-2B JSON Files From GST Portal
\nTo view Form GSTR-2B in the Matching Tool, perform the following steps.
\n1. To download Form GSTR-2B JSON files from GST portal, access the GST portal using the
\nURL: https:\/\/www.gst.gov.in\/. The GST Home page is displayed.
\n2.
\nGoods and Services Tax
\nHome
\nServices \u00e2\u2013\u00be
\nGST Law
\nDownloads \u00e2\u2013\u00bc
\nSearch Taxpayer \u00e2\u2013\u00bc
\nHelp and Taxpayer Facilities
\nE-Invoice
\nHome > Login
\nLogin
\nUsername*
\nEnter Username
\nPassword*
\nEnter Password
\nLOGIN
\n\u00e2\u0161\u00ab indicates mandatory fields
\nForgot Username
\nForgot Password
\nFirst time login: If you are logging in for the first time, click here to
\nlog in.
\nSkip to Main Content
\nA+ A-
\n\u00e2\u2020\u2019 Login
\nLog in to the GST portal using valid credentials and go to Services > Returns > Returns
\nDashboard.
\nDesigned and Developed by GSTN
\nPage 22 of 46
\nGIN
\nGOODS AND SERVICES TAX N<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nE-Invoice
\nDashboard Returns
\n\u00e2\u2020\u2019 English
\nFile Returns
\nFinancial Year*
\nReturn Filing Period
\n2020-21
\nJuly
\nDesigned and Developed by GSTN
\nGSTR-2A can now be downloaded in excel\/CSV format for you
\n\u2022 Indicates Mandatory Fields
\nSEARCH
\nPage 23 of 46
\n16
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\n4. To download the Form GSTR-2B JSON files, click the Download button on the Auto – drafted
\nITC Statement – GSTR -2B tile.
\nDetails of outward supplies of goods
\nDetails of auto drafted supplies
\nTable 6A of FORM GSTR1
\nor services
\nGSTR1
\nGSTR1A
\nDue Date 31\/08\/2020
\nDue Date 31\/08\/2020
\nPREPARE ONLINE
\nPREPARE OFFLINE
\nPREPARE ONLINE
\nPREPARE OFFLINE
\nPREPARE ONLINE
\nPREPARE OFFLINE
\nInward supplies received by
\ntaxpayer (For taking action)
\nGSTR2
\nDue Date 31\/08\/2020
\nAuto Drafted details (For view only)
\nAuto – drafted ITC Statement
\nGSTR2A
\nGSTR2B
\nVIEW
\nDOWNLOAD
\nPREPARE ONLINE
\nPREPARE OFFLINE
\n5. The Offline Download for Form GSTR-2B page is disp<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nOffline Download for GSTR-2B
\nHelp
\nsaravana bhavan
\n34BOGPS8935H7ZA
\n\u00e2\u2020\u2019 English
\nFORM GSTR-2B has been generated on the basis of the information furnished by the suppliers in their respective FORMS GSTR-1,5 and 6. It also contains
\ninformation on imports of goods from the ICEGATE system. It can be downloaded as either JSON file to view in offline tool or can be downloaded as Excel
\nfile.
\nDownload data for GSTR-2B
\nNote: Please refer help section for more details.
\n072020 34BOGPS….xlsx
\nGENERATE JSON FILE TO DOWNLOAD
\nGENERATE EXCEL FILE TO DOWNLOAD
\nYou can find the JSON file under Downloads folder on your machine.
\nG.2. Open JSON Files in the Matching Tool
\nBACK
\nThe next step is to open the Matching Tool and view Form GSTR-2B JSON files in the tool.
\n8. On the Home screen of the Matching Offline Tool, select the relevant GSTIN from the drop-
\ndown list.
\nThe drop-down list contains the profiles that are added by you in the Matching Tool.
\nTrade\/Legal Name field gets auto<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nSelect Table
\nVIEW SUMMARY OF GSTR-2B \u00e2\u2013\u00bc
\nMatching Offline Tool
\nRegular
\n2020-21
\nJul
\nHELP
\ni
\n\u00c3\u2014
\nINFORMATION
\n\u00e2\u02dc\u2018
\nGSTR-2B json imported successfully. You can match the
\nGSTR-2B with your purchase register. Matching can be
\ninitiated by selecting 'Matching Tool' option on the page.
\nXPORT TO EXCEL
\nOK
\n13. Click VIEW SUMMARY of Form GSTR-2B to view the summary.
\nSelect Table for Viewing
\nSelect Table for Viewing
\nVIEW SUMMARY OF GSTR-2B ^
\nBACK
\nITC available
\nITC not available
\nS.No.
\nHeading [Expand All \u00e2\u0153\u201c]
\nGSTR-3B table Integrated tax (*)
\nCentral tax (*)
\nState\/UT tax (*)
\nCess (7)
\nPart A
\nITC Available – Credit may be claimed in relevant headings in GSTR-3B
\nAll other ITC – Supplies from registered persons other than reverse charge
\n4(A)(5)
\n0.00
\n0.00
\n0.00
\n0.00
\n||
\nIII
\nInward Supplies from ISD \u00e2\u2013\u00bc
\n4(A)(4)
\n0.00
\n0.00
\n0.00
\n0.00
\n3.1(d)
\nInward Supplies liable for reverse charge \u00e2\u0153\u201c
\n0.00
\n0.00
\n0.00
\n0.00
\n4(A)(3)
\nIV
\nImport of Goods \u00e2\u0153\u201c
\n4(A)(1)
\n61,09,94,654.85
\n13,764.24
\nPar<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nImport of goods from Overseas – IMPG
\nImport of goods from SEZ-IMPGSEZ
\nOnce a table is selected, the respective table summary is displayed.
\nSelect Table for Viewing
\nTaxable inward supplies received from registered persons – B2B
\nTaxable inward supplies received from registered persons – B2B
\nTable Summary ^
\nGSTIN of supplier
\nTrade\/Legal name
\nNo. of records
\nTotal taxable value (*)
\nTotal tax amount (*)
\n34BOGPS8935H6ZB
\nGSTN
\n7
\n39,000.00
\n7,605.00
\nSupplier wise summary
\nDocument details
\nDisplay rate wise details
\nSearch:
\nQ Search
\nBACK
\nRecords
\n10
\nPer Page:
\nSelect Columns To
\nDisplay\/Hide:
\n+12\u00e2\u2013\u00bc
\nGSTIN of supplier
\nTrade\/Legal name
\nInvoice number
\nInvoice type
\n\u00e2\u2013\u00bc
\nInvoice date T
\nInvoice value (*) \u00e2\u2013\u00b2 Place of Supply \u00e2\u2020\u2019
\nTaxable value (*)
\n–
\nIntegrat
\ntax (*)
\n34BOGPS8935H6ZB GSTN
\n3b4
\nRegular
\n04\/02\/2019
\n4,500.00
\nPuducherry
\n10,000.00
\n0.
\n34BOGPS8935H6ZB GSTN
\n3b3
\nDeemed Exports
\n03\/02\/2019
\n3,500.00
\nPuducherry
\n8,000.00
\n0.
\n34BOGPS8935H6ZB GSTN
\n3b2
\nDeemed Exports
\n02\/02\/<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nrate
\nInvoice number Invoice date
\n\u00ce\u00a4
\nGSTIN of supplier Trade\/Legal name Invoice number
\nInvoice type
\nInvoice date
\nCess
\n\u00e2\u02dc\u2018 GSTR-1\/5 Filing Date
\n3b2
\n02\/02\/2019
\n34BOGPS8935H6ZB GSTN
\n3bup2
\nDeemed Exports
\n03\/02\/2019
\n3b1
\n01\/02\/2019
\n34BOGPS8935H6ZB GSTN
\n3bup1
\nDeemed Exports
\n\u00e2\u0153\u201d GSTR-1\/5 Period
\n\u00e2\u02dc\u2018 ITC Availability
\n02\/02\/2019
\n2b1
\n02\/12\/2018
\n34BOGPS8935H6ZB GSTN
\n2bup1
\nRegular
\n07\/12\/2018
\n2,000.00
\nPudu
\n2b2
\n03\/12\/2018
\n34BOGPS8935H6ZB GSTN
\n2bup2 \u00e2\u0153\u201c
\nRegular
\n03\/12\/2018
\n3,000.00
\nPudu
\n>
\n16. Click Display rate wise details to display the record details on the basis of rate.
\nDesigned and Developed by GSTN
\nPage 29 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nSupplier wise summary Document details
\nHide rate wise details
\nOriginal Details
\nMatching Offline Tool
\nRecords
\nSearch Search
\n10
\nPer Page:
\nSelect Columns To
\nDisplay\/Hide:
\n+14
\nInvoice number
\nInvoice date
\n\u00ce\u00a4
\nGSTIN of supplier
\nTrade\/Legal name
\nInvoice number
\nInvoice type T
\nInvoice date
\n\u00ce\u00a4
\nInvoice value (*)
\nPlace of
\n3b2
\n02\/02\/20<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nAll other ITC – Supplies from registered persons other than reverse charge ^
\n4(A)(5)
\nB2B-Invoices
\nB2B – Debit notes
\nB2B
\nDo you want to open or save Jul 2020-21_34BOGPS8935H7ZA_GSTR2B_Offline.xlsx (26.6 KB) from localhost?
\nDesigned and Developed by GSTN
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\n0.00
\nOpen
\nSave
\nCancel
\n\u00c3\u2014
\nPage 30 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nSave and open the file from the local drive of your machine.
\nA1
\nfx
\nGoods and Services Tax – GSTR-2B
\nA
\nB
\n234567890
\nMatching Offline Tool
\nE
\nGoods and Services Tax – GSTR-2B
\nFinancial Year 2020-21
\nTax Period Jul
\nGSTIN 34BOGPS8935H7ZA
\nTrade\/Legal name |GSTN
\nDate of generation 27\/08\/2020
\n10
\nWorksheet GSTR-2B Table Reference
\n11
\nName
\nField Name
\nGSTR-2B Data Entry Instructions
\nInstructions
\n12345670
\n18
\nGSTIN of Supplier
\nTrade\/Legal name
\nInvoice number
\nInvoice type
\nInvoice date
\nInvoice value
\nPlace of supply
\nGSTIN of supplier
\nTrade name of the supplier will be displayed. If trade name is not av<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n2
\n3
\nGSTR-2B
\nPURCHASE REGISTER
\nMATCHING RESULT
\n(PR)
\nNote: Purchase register should be maintained as per the template provided on GST portal and the same can be downloaded therefrom.
\nPurchase register maintained in a format other than the template shall not be imported into the tool.
\nMatching Offline Tool
\nBACK
\nIn case there appears some error in downloading Purchase Register, an error file is
\ngenerated, which can be downloaded by clicking the DOWNLOAD ERROR FILE.
\nBy default, the error file gets downloaded in the Downloads folder of your machine. Open
\nthe file to check the error.
\nThe errors are displayed in the following format in an excel.
\nAutoSave Off
\nJul 2020-2021_34BOGPS8935H7ZA_PR_Errorfile – Excel
\nManika Bhardwaj MB
\nF
\nFile
\nHome
\nInsert
\nPage Layout
\nFormulas
\nData
\nReview View Help
\nSearch
\nShare
\nComments
\nInsert v
\nX
\n\u00ce\u00a3
\nCalibri
\n\u2022 11 – \u00ce\u2018' \u00ce\u2018'
\n===
\nab Wrap Text
\nGeneral
\n4
\nLG\u00e2\u2013\u00be
\nPaste
\nBIU
\nAA
\nProtect
\nMerge & Center
\n$ % 500-00
\nConditional Format as Cell
\nFormatt<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n0
\n0
\n0
\n20 Selected
\n3\/12\/2018
\n3000
\n0
\nSelected
\n1\/2\/2019
\n4000
\n259 Selected
\n2\/2\/2019
\n6000
\n550 Selected
\nInvoice
\n\/000-3b3
\n3\/2\/2019
\n8000
\n340 Selected
\nSEZWOP
\nInvoice
\n3b4
\n4\/2\/2019
\n100001
\n610 Selected
\n11 34BOGPS8935H6ZB GSTN
\nSEZWP
\nInvoice
\n2bup1\/0000
\n7\/12\/2018
\n12000
\n100
\n30 Selected
\n12 34BOGPS8935H6ZB GSTN
\nSEZWP
\nInvoice
\n2bup2aaa
\n3\/12\/2018
\n13000
\n0
\n0
\n0
\n65 Selected
\n13 34BOGPS8935H6Za GSTN
\nSEZWP
\nInvoice
\n3bup1
\n2\/2\/2019
\n4600
\n270 Selected
\n14 34BOGPS8935H6Zb GSTN
\nSEZWP
\nDebit Note
\n3bup2
\n3\/2\/2019
\n8100
\n620 Selected
\n15 34BOGPS8935H6aB GSTN
\nSEZWOP
\nDebit Note
\n2bcn1
\n5\/12\/2018
\n4000
\n16 34BOGPS8935H6ZB GSTN
\nSEZWP
\nCredit Note
\n3bcn1
\n17\/02\/2019
\n3300
\n17 34BOGPS8935H6ZB GSTN
\nSEZWP
\nCredit Note
\n3bcn2
\n18 34BOGPS8935H6ZB
\nGSTN
\nSEZWP
\nDebit Note
\n19 34BOGPS8935H6ZB GSTN
\nSEZWP
\nDebit Note
\n3bdb1
\n3bdb2
\n19\/02\/2019
\n18\/02\/2019
\n20\/02\/2019
\n7700
\n5510
\n9900
\nSelected
\n145 Selected
\n496 Selected
\n320 Selected
\n610 Selected
\nFix the errors displayed in the excel and click IMPORT EXCEL\/CSV again to import the
\nexcel.
\nDesigned and Developed by GS<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nClick VIEW PURCHASE REGISTER to view purchase register details. Detail view
\nof purchase register is displayed.
\nDetail view of Purchase Register
\nSupplier wise
\nDocument wise
\nSearch Q Search
\nGSTIN of
\nsupplier \u00c3\u00b7
\n+ 37APWCD7391FGZO
\nRecords
\nPer Page:
\n10
\nSelect Columns To
\nDisplay\/Hide:
\n+10\u00e2\u2013\u00bc
\nType of inward
\nsupply
\nTaxable
\nvalue (*)
\n\u00c3\u00b7
\nTotal
\ntax (*) =
\nIntegrated
\ntax (*) \u00e2\u0153\u00b0
\nCentral
\ntax (*)
\nState\/ UT
\ntax (*)
\nCess
\n(Rs.) =
\nB2B
\n5,000.00
\n1,580.00
\n0.00
\n540.00
\n540.00
\n500.00
\n+ 34BOGPS8935H6ZB
\nB2B
\n-30,500.00
\n471.00
\n0.00
\n164.50
\n164.50
\n142.00
\n+ 34BOGPS8935H6ZB
\nDE
\n28,905.00
\n6.470.50
\n0.00
\n2,239.75
\n2,239.75
\n1,991.00
\nDesigned and Developed by GSTN
\nBACK
\nPage 33 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\n18. Click the Supplier wise tab to view purchase register records on the basis of suppliers.
\n19. Click the Document wise tab to view purchase register records on the basis of documents.
\nSupplier wise
\nDocument wise
\nSearch
\nQ Search
\nRecords
\nPer Page:
\n10
\nSelect Colu<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n1,093.00
\n0.00
\n379.50
\n379.50
\n334.00
\n34BOGPS8935H6ZB
\nDE
\nDebit Note
\n3bdb2
\n20\/02\/2019
\n9,800.00
\n1,938.00
\n0.00
\n669.00
\n669.00
\n600.00
\n\u00c2\u00ab Previous
\n1 2 Next >>
\nBACK
\n20. Click the Next and Back buttons to navigate through document wise details of the
\npurchase register.
\nThe sorting and filter buttons are available along with each column header to sort
\nand filter table data. Use the buttons to display records in ascending or descending
\norder or filter details in a column.
\n(I) Match Results
\n21. To match results of Form GSTR-2B details with the purchase register, click the MATCH
\nbutton.
\nThe summary and details of the match result is displayed in different sections.
\nDesigned and Developed by GSTN
\nPage 34 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nDetails of matching result
\nSupplies from registered persons (B2B)
\nMatching result
\nMatch type
\nNo. of documents
\nM1 Exact match
\nM2 Partial match
\nMatch
\nM3 Probable match
\n1
\n1
\n0
\nTaxable value (*)
\nMatching Offline Tool
\nExport to CSV
\nTotal tax amount (*)
\n4,500.00<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n\u00e2\u2013\u00a0 Document number
\n\u00e2\u2013\u00a0
\n\u00e2\u2013\u00a0
\nDocument date
\nTaxable value
\nTotal tax amount
\nIntegrated tax
\n\u2022
\n\u2022
\nCentral tax
\nDesigned and Developed by GSTN
\nState\/UT tax
\nBACK
\nPage 35 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\n\u2022 Cess
\nMatching Offline Tool
\n\u00ce\u0178
\nPartial match: Records match partially
\nO Probable match: Mismatch in between GSTIN and Document type and
\ncomplete match in all other parameters
\n\u00e2\u2014\u2039 Mismatch (Few parameters do not match or record does not exist in Form
\nGSTR-2B or Purchase register
\nUnmatched: Two or more parameters do not match
\n\u00e2\u2014\u2039
\n\u00e2\u2014\u2039
\nIn GSTR-2B not in Purchaser register
\nO
\nIn Purchase register not in GSTR-2B
\n\u2022
\nNo. of documents: Displays the number of documents matched or mismatched.
\n\u2022
\nTotal taxable value: Displays the value of tax on match or mismatch of respective
\ntables
\nBelow the summary, details of the matching result are displayed as per the matches made
\nfor example: Supplies from registered person (B2B), Deemed exp<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n2bup1
\n07\/12\/2018
\n2,000.00
\n120.00
\n0.00
\n50.00
\n50.00
\n20.00
\n2
\nNo
\n34BOGPS8935H6ZB
\nInvoice
\n2bup1
\n07\/12\/2018
\n2,000.00
\n120.00
\n0.00
\n50.00
\n50.00
\n20.00
\n34BOGPS8935H6ZB
\nInvoice
\n2bup2
\n03\/12\/2018
\n3,000.00
\n215.00
\n0.00
\n75.00
\n75.00
\n65.00
\nNo
\n34BOGPS8935H6ZB
\nInvoice
\n2bup2
\n03\/12\/2018
\n3,000.00
\n215.00
\n0.00
\n75.00
\n75.00
\n65.00
\nYou can download the details of matching results in CSV\/ Excel format using Export to CSV
\noption.
\nDesigned and Developed by GSTN
\nPage 36 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nMatching Offline Tool
\n23. Select the option from the Export to CSV drop-down to download the results in an excel file.
\nMatching result – Details
\nSelect Table Supplies from registered persons (B2B) \u00e2\u2013\u00bc
\nMatching Result Match
\nMatch Type All
\nSearch
\nQ Search
\nRecords
\nPer Page:
\n10
\nSelect Columns To
\nDisplay\/Hide:
\n+12
\nGSTIN: GSTR-2B records GSTIN: Purchase Register(PR) records
\nExport to CSV: Select
\nGSTIN of
\nsupplier =
\nDocument
\ntype \u00c3\u00b7 T
\nDocument
\nnumber \u00e2\u0153\u00b0
\nDocument
\nTaxable
\ndate T
\nvalue (*) \u00e2\u0153\u00b0
\nTotal
\nta<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nMatch Type All
\nRecords
\nPer Page:
\nSelect Columns To
\n10
\nDisplay\/Hide:
\n+12\u00e2\u2013\u00bc
\nGSTIN: GSTR-2B records
\nGSTIN: Purchase Register(PR) records
\nExport to CSV Select
\nGSTIN of
\nsupplier \u00c3\u00b7
\nDocument
\ntype T
\nDocument Document
\nnumber + date
\nT
\nTaxable
\nvalue (*) *
\nTotal
\ntax (*) \u00e2\u0153\u00b0
\nIntegrated
\ntax (*) \u00e2\u0153\u00b0
\nCentral
\ntax (*)
\nState\/ UT
\ntax (Rs.) \u00e2\u0153\u00b0
\nITC
\nCess (*)
\nAvailability
\n34BOGPS8935H6ZB
\nCredit Note
\n2bcn1
\n05\/12\/2018
\n4,000.00
\n510.00
\n0.00
\n187.50
\n187.50
\n135.00
\nNo
\n34BOGPS8935H6ZB
\nCredit Note
\n2bcn1
\n05\/12\/2018
\n4,000.00
\n510.00
\n0.00
\n187.50
\n187.50
\n135.00
\n34BOGPS8935H6ZB
\nDebit Note
\n2bcnup1
\n10\/12\/2018
\n4,500.00
\n570.00
\n0.00
\n200.00
\n200.00
\n170.00
\nNo
\n34BOGPS8935H6ZB Debit Note
\n2bcnup1
\n10\/12\/2018
\n4,500.00
\n570.00
\n0.00
\n200.00
\n200.00
\n170.00
\n34BOGPS8935H6ZB
\nInvoice
\n2bup1
\n07\/12\/2018
\n2,000.00
\n120.00
\n0.00
\n50.00
\n50.00
\n20.00
\nNo
\n34BOGPS8935H6ZB
\nInvoice
\n2bup1
\n07\/12\/2018
\n2,000.00
\n120.00
\n0.00
\n50.00
\n500
\nSave
\nSave as
\nDo you want to save Jul 2020-21 34BOGPS8935H7ZA_All.csv (1.41 KB) from localhost?
\nSave
\nSave and o<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nNo
\nNo
\nRemarks Type of inward supply
\nGSTR-2B Record
\n187.5
\n135 No
\nExact match
\n6 34BOGPS GSTN
\n7 34BOGPS GSTN
\n8 34BOGPSE GSTN
\n9 34BOGPSE GSTN
\n10 34BOGPS GSTN
\n11 34BOGPS GSTN
\n12 34BOGPS GSTN
\nCredit Not 2bcn1
\nDebit Not 2bcnup1
\nDebit Not 2bcnup1
\nInvoice 2bup1
\nInvoice 2bup1 07\/12\/201
\nInvoice 2bup2 03\/12\/201
\nInvoice 2bup2 03\/12\/201
\n05\/12\/201 4000
\n510
\n0
\n187.5
\n187.5
\n135
\nExact match
\nPurchase | B2B
\n10\/12\/201
\n10\/12\/201
\n4500
\n570
\n0
\n200
\n200
\n170 No
\nNo
\nYes
\n4500
\n570
\n0
\n200
\n200
\n170
\nExact match
\nExact match
\n07\/12\/201
\n2000
\n120
\n0
\n50
\n50
\n20 No
\nNo
\nYes
\nExact match
\n2000
\n120
\n0
\n50
\n50
\n20
\n3000
\n3000
\n215
\n0
\n75
\n75
\n65 No
\nNo
\nYes
\n215
\n0
\n75
\n75
\n65
\nExact match
\nExact match
\nExact match
\nGSTR-2B Record
\nPurchase | B2B
\nGSTR-2B Record
\nPurchase (B2B
\nGSTR-2B Record
\nPurchase B2B
\n13
\n25. To view details of match present In GSTR-2B not in PR and In PR not in GSTR-2B, click
\nthe options available in blue text under the Details of matching results section.
\n\u00e2\u0161\u00abIn PR not in GSTR-2B
\nTOTAL<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nRecords
\nPer Page
\n10
\nSelect Columns To
\nDisplay\/Hide:
\nExport to CSV : Select
\n+10 \u00e2\u2013\u00bc
\nGSTIN of
\nsupplier = type
\nDocument
\nT
\nDocument
\nnumber \u00e2\u2020\u2019
\nDocument
\ndate \u00c3\u00b7 T
\nTaxable
\nvalue (*) *
\nTotal
\ntax (*)
\nIntegrated
\ntax (*) \u00e2\u0153\u00b0
\nCentral
\ntax (*)
\nState\/ UT
\ntax (*) \u00e2\u0153\u00b0
\nITC
\nCess (*) \u00e2\u0153\u00b0
\nAvailability
\n34BOGPS8935H6ZB
\nInvoice
\n1000
\n01\/12\/2018
\n6,000.00
\n1,650.00
\n0.00
\n565.00
\n565.00
\n520.00
\n34BOGPS8935H6ZB
\nInvoice
\n2b1
\n02\/12\/2018
\n2,000.00
\n120.00
\n0.00
\n50.00
\n50.00
\n20.00
\n221
\nNo
\nNo
\n34BOGPS8935H6ZB
\nInvoice
\n2b2
\n03\/12\/2018
\n3,000.00
\n220.00
\n0.00
\n75.00
\n75.00
\n70.00
\nNo
\n34BOGPS8935H6ZB
\nDebit Note
\n2bdb1
\n06\/12\/2018
\n2,500.00
\n277.50
\n0.00
\n93.75
\n93.75
\n90.00
\nNo
\n34BOGPS8935H6ZB
\nInvoice
\n3b4
\n04\/02\/2019
\n10,000.00
\n1,927.50
\n0.00
\n663.75
\n663.75
\n600.00
\nNo
\n26. To view records, present In PR not in GSTR-2B, click the Match Type drop-down and
\nselect the option.
\nMatching result – Details
\nSelect Table Supplies from registered persons (B2B)
\nSearch Search
\nMatching Result Mismatch
\nMatch Type M4(2) In G<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nSearch Search
\n(PR)
\nMatching Result Mismatch
\nGSTIN: GSTR-2B records GSTIN: Purchase Register(PR) records
\nMatching Offline Tool
\nMatch Type M4(3) In PR not in GSTR-2B
\nRecords
\nPer Page:
\nSelect Columns To
\n10
\nDisplay\/Hide:
\nExport to CSV : Select
\n+9\u00e2\u2013\u00be
\nGSTIN of
\nsupplier \u00c3\u00b7
\nDocument
\ntype T
\nDocument
\nnumber
\nDocument
\nTaxable
\ndate
\nT
\nvalue (*) \u00e2\u0153\u00b0
\nTotal
\ntax (3) \u00e2\u0153\u00b0
\nIntegrated
\ntax (*) \u00e2\u0153\u00b0
\nCentral
\ntax (*)
\nState\/ UT
\ntax (Rs.)
\nCess (*)
\n34BOGPS8935H6ZB
\nInvoice
\n1000
\n01\/07\/2020
\n1,000.00
\n70.00
\n0.00
\n25.00
\n25.00
\n37APWCD7391FGZO
\nInvoice
\n1000
\n01\/12\/2018
\n3,000.00
\n1,240.00
\n0.00
\n420.00
\n420.00
\n4
\n37APWCD7391FGZO
\nInvoice
\n1000
\n01\/07\/2020
\n2,000.00
\n340.00
\n0.00
\n120.00
\n120.00
\n1
\nBACK
\nThe Export to CSV option enables you to download details of Matching result and Purchase
\nRegister in separate excel sheets.
\nMatching result – Details
\nSelect Table Supplies from registered persons (B2B)
\nMatching Result Mismatch
\nMatch Type M4(2) In GSTR-2B not in PR
\nSearch Search
\nRecords
\nPer Page:
\n10
\nSe<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nSensitivity:
\nA
\nB
\n\u00d1\u0081
\nD
\nE
\nF
\nPublic
\nInternal
\nConfidential
\nHighly Confidential
\nG
\nH
\n|
\nJ
\nK
\nL
\nM
\nN
\nO
\n1 GSTIN of Trade\/Leg Financial Tax period Table Nan Matching Match Type
\n34BOGPS\u00c6\u0090 GSTN 2020-21 Jul-20 Supplies f Mismatch 2) In GSTR-2B not in PR
\nGSTIN of s Trade\/Leg Document Document Document Taxable va Total tax (Integrated Central ta State\/ UT Cess (*) Match typ Remarks
\n5 34BOGPS GSTN
\n6 34BOGPS GSTN
\n7 34BOGPSE GSTN
\n8 34BOGPS GSTN
\n9 34BOGPS GSTN
\nInvoice
\nInvoice 2b1
\nInvoice 2b2
\nDebit Not 2bdb1
\nInvoice 3b4
\n1000 01\/12\/201 6000
\n1650
\n0
\n565
\n565
\n02\/12\/201 2000
\n03\/12\/201 3000
\n120
\n0
\n50
\n50
\n220
\n0
\n75
\n06\/12\/201 2500 277.5
\n04\/02\/201 10000 1927.5
\n0
\n93.75
\n75
\n93.75
\n0 663.75 663.75
\n520 In GSTR-21 GSTR-2B record
\n20 In GSTR-2 GSTR-2B record
\n70 In GSTR-21 GSTR-2B record
\n90 In GSTR-21 GSTR-2B record
\n600 In GSTR-21 GSTR-2B record
\n10
\nThe screenshot below displays Details of Purchase Register in an excel format.
\nSensitivity: Internal \\ Companywide usage
\nPublic
\nInternal
\nConfidential
\nA
\nB<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\nExport to CSV
\nTaxable value (*)
\nTotal tax amount (*)
\n5,500.00
\n395.00
\n0.00
\n0.00
\nMatch
\nM3 Probable match
\n0
\n0.00
\n0.00
\nSub-total
\n4
\n5,500.00
\n395.00
\nM4(1) Unmatched
\n0
\n0.00
\n0.00
\nMismatch
\nM4(2) In GSTR-2B not in PR
\nM4(3) In PR not in GSTR-2B
\n5
\n23,500.00
\n4,195.00
\n3
\n6,000.00
\n1,650.00
\nSub-total
\n8
\n29,500.00
\n5,845.00
\nTOTAL
\n12
\n35,000.00
\n6,240.00
\nDeemed Exports (DE)
\n28. Save and open the excel file from the local drive of your machine.
\nInsert
\nDelete
\n\u00e2\u2013\u00be
\nConditional Format as Cell
\nFormatting
\n\u00e2\u02c6\u0161
\nTable Styles
\nStyles
\nFormat
\nCells
\nFile
\nHome Insert Page Layout
\nFormulas
\nData Review View Help
\nSearch
\nX
\nCalibri
\n\u2022 11 – \u00ce\u2018' \u00ce\u2018 ==
\nWrap Text
\nGeneral
\nPaste
\nBIU
\nProtect
\nA
\nMerge & Center
\n$ % 950000
\nClipboard 5
\nFont
\n\u00d0\u2018
\nAlignment
\nProtection
\nNumber
\nA1
\nX
\nfx
\nGSTIN of Recipient
\nW\u00c5\u00bb\u00c3\u201c
\nShare
\nComments
\nSort & Find &
\nFilter Select
\nIdeas
\nEditing
\nIdeas
\nSensitivity: Internal\\Companywide usage \/
\nPublic
\nInternal
\nConfidential
\nHighly Confidential \u00e2\u2013\u00bc
\nA
\nC
\nD
\nE
\nF
\nG
\nH
\nI
\nJ
\nK
\nL
\nM
\nGSTIN of Recipient
\n2 34B<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\npage. The REFINE MATCHING RESULTS window is displayed.
\nDesigned and Developed by GSTN
\nPage 42 of 46
\nGIN
\nGOODS AND SERVICES TAX NETWORK
\nREFINE MATCHING RESULT
\nSet tolerance for individual tax amount (Integrated tax, Central tax,
\nState\/UT tax and Cess)
\nApply approximation for matching on document number :
\nSummary of GSTR-2B an
\nExact match (All 7 parameters match)
\nAPPLY & RE-MATCH
\nGSTR-2B
\n2
\nMatching Offline Tool
\nselect
\nREFINE MATCHING RESULT
\nselect
\n1
\nPurchase regis
\n9
\n10
\ne value ()
\nTotal tax amount (*)
\n1,500.00
\n245.00
\nPartial match
\n1
\n1
\n-4,000.00
\n-510.00
\nProbable match
\n0
\n0
\n0.00
\n0.00
\nMismatch (Few parameters do not match or record do not exist in GSTR-2B\/PR)
\n17
\n10
\n86,805.00
\n17,428.50
\n\u2022 Unmatched (2 or more parameters not match) 0
\n2
\n2
\n15,400.00
\n3,009.00
\n\u2022 In GSTR-2B not in PR
\n\u2022 In PR not in GSTR-2B
\n15
\n0
\n43,700.00
\n8,664.00
\n0
\n8
\n27,705.00
\n5,755.50
\nTOTAL
\n20
\n13
\n84,305.00
\n17,163.50
\n2. Click sel<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n
\n14
\n7
\n68,805.00
\n15,125.50
\n\u2022 Unmatched (2 or more parameters not match) \u00e2\u2020\u2019
\n2
\n2
\n15,400.00
\n3,009.00
\n\u2022In GSTR-2B not in PR
\n12
\n0
\n34,700.00
\n7,516.50
\n\u2022 In PR not in GSTR-2B
\n0
\n5
\n18,705.00
\n4,600.00
\nTOTAL
\n20
\n13
\n75,305.00
\n16,008.00
\nDetails of matching result
\nSupplies from registered persons (B2B)
\nMatching result
\nMatch type
\nNo. of documents
\nM1(1) Exact match
\n1
\nM1(2) Match with tolerance
\n0
\nExport to CSV \u00e2\u02dc\u2018
\nTaxable value (*)
\nTotal tax amount (*)
\n4,500.00
\n570.00
\n0.00
\n0.00
\nM1(3) Match with approximation
\n0
\n0.00
\n0.00
\nSub-total
\n1
\n4,500.00
\n570.00
\nM2(1) Partial match
\n1
\n-4,000.00
\n-510.00
\nM2(2) Partial match with tolerance
\nMatch
\nM2(3) Partial match with approximation
\nSub-total
\n3
\n1,000.00
\n0
\n0.00
\n2
\n5,000.00
\n335.00
\n0
\n0.00
\n0.00
\n-175.00
\n0.00
\nM3(1) Probable match
\nM3(2) Probable match with tolerance
\n0
\n0.00
\n0.00
\nM3(3) Probable match with approximation
\n0
\n0.00
\n0.00
\nSub-total
\n0
\n0.00
\n0.00
\nM4(1) Unmatched
\n0
\n0.00
\n0.00
\nM4(2) In GSTR-2B not in PR
\nMismatch
\nM4(3) In<\/p>\n
For full text:-Visit the Source <\/a><\/p>\n