FAQs and User Manual – Matching Offline Tool
GST
Dated:- 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) About Matching Offline Tool
(B) FAQS > Download and Install Matching Offline Tool
B.1. Download Matching Offline Tool…………….
B.2. Manage Profile
(C) FAQS > View Form GSTR-2B Files in Matching Tool …..
C.1. Download Form GSTR-2B JSON files from GST Portal.
C.2. Open JSON Files in the Matching Tool
(D) FAQs > Import Purchase Register in the Matching Tool ……
(E) FAQs > Match Results
(F) Download and Install Matching Offline Tool …….
F.1. Create Profile……….
(G) View Form GSTR-2B Files in Matching Tool……………
G.1. Download Form GSTR-2B JSON Files From GST Portal..
G.2. Open JSON Files in the Matching
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
sults using features provided in the tool. The tool enables the
taxpayer to download the matching results in a csv format.
The key features of Matching Offline Tool is that the setails can be matched offline with no
connection to Internet.
Designed and Developed by GSTN
Page 3 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
(B) FAQS > Download and Install Matching
Offline Tool
B.1. Download Matching Offline Tool
1. From where can I download and use the Matching Offline Tool in my
system?
To download and open the Matching Tool in your system from the GST Portal, perform following
steps:
1. Access the GST Portal: www.gst.gov.in.
2. Go to Downloads > Offline Tools > Matching Offline Tool option and click on it.
3. Select Download.
4. Click Proceed.
5. Unzip the downloaded Zip file which contain Matching Offline Tool.exe.
6. Open the Matching Offline Tool.exe by double clicking on it.
7. Select the folder where you intend to install the Matching Offline Tool.
8. Click Next.
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
can only be used on
desktop/laptops.
6. What does downloaded zip folder for Matching Offline Tool contains?
The Zip folder downloaded from the GST portal will consist of the following:
•
•
Installation file for the offline tool .exe format (Set up file)
'Read me' explaining in detail the prerequisites with respect to system requirements
and steps for installation of the offline tool
• Offline tool taxpayer manual
•
Change history text file
•
Purchase register template
B.2. Manage Profile
7. Does the Matching Offline Tool contain any Help for each page?
Once you open the tool, you will notice detailed instructions (Contextual to that page) to use the
tool, using HELP link on the top-right corner of the tool at each page.
8. Can I access Matching Offline tool without creating profile in Offline
tool?
No, you cannot access Matching Offline tool without creating a profile in it.
9. How can I add my profile in Matching Offline Tool?
To add your profile in Matc
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
ete button
available on the Modify Profile page.
(C) FAQS > View Form GSTR-2B Files
Matching Tool
C.1. Download Form GSTR-2B JSON files from GST Portal
14. Do I need to login to GST Portal to download Form GSTR-2B JSON
file?
Yes, you must login in to the GST Portal to download GSTR-2B JSON file.
in
15. From where can I download the Form GSTR-2B JSON file?
You can download the Form GSTR-2B JSON file from Services → Returns → Returns Dashboard
→ Select the FY and Return period → GSTR-2B tile (Download) → Download JSON
Designed and Developed by GSTN
Page 6 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
16. Where can I find the downloaded JSON files from the GST Portal?
The JSON files downloaded from the GST Portal gets saved in the Downloads folder on your
machine.
C.2. Open JSON Files in the Matching Tool
17. Do I need to open the Matching Offline Tool to open the JSON files
downloaded from the GST Portal?
Yes, you need to click the Matc
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
rchase Register section.
21. Can I maintain my Purchase Register in a format other than provided
on GST portal?
Purchase register maintained in a format other than the template provided as part of Matching
offline tool will not get imported into the tool.
22. What will happen once the Purchase Register is imported in the Offline
Tool?
Once the Purchase Register is imported in the Offline Tool, you can:
View the details as imported from the Purchase Register
Remove all the entries imported from the Purchase Register
Compare/Match the entries of imported Purchase Register with the entries of Form
GSTR-2B
(E) FAQS > Match Results
23. What are different categories of matching results?
There are six categories of matching results available in the tool, as explained in table below:
Categories of matching results
Exact match (All 7 parameters
match)
Matching Parameters
1.
GSTIN
2.
Document type
3.
Document number
4.
Document date
5.
Total taxable value
6. Total tax amount
7. Tax amount head
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
nt type
Document number
Document date
BUT there is a mismatch on one or more of following
parameters, beyond the tolerance limit set:
Total taxable value
Total tax amount
Tax amount head wise
Integrated tax
.
•
Central tax
•
•
CESS
State/UT tax
All documents that exist in Form GSTR-2B, but could not
be found in PR, (i.e. not classified in any of the
Categories of matching results above), will be
classified in this category.
All documents that exist in PR, but could not be found in
Form GSTR-2B, (i.e. not classified in any of the
Page 9 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Categories of matching results
Matching Parameters
Matching Offline Tool
Categories of matching results above), will be
classified in this category.
24. What is the function of the Refine Matching Result option on the
Matching Tool?
The REFINE MATCHING RESULT option enables you to refine the match results by altering the
tolerance value for Integrated, Central, State/UT tax or Cess.
You may als
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
ine Tool option.
Dashboard
Services â–¼
GST Law
Downloads â–¼ Search Taxpayer-
Help and Taxpayer Facilities E-Invoice
Offline Tools
Accounting and Billing Software
Returns Offline Tool
Tran-1 Offline Tools
GSTR3B Offline Utility
ITC03 Offline Tool
Matching Offline Tool
Tran-2 Offline Tools
ITC01 Offline Tool
ITC04 Offline Tool
GSTR 4 Offline Tool
GST ARA 01 – Application for Advance Ruling
GSTR 6 Offline Tool With Amendments
Refunds Offline Tools
GSTR8 Offline Tool
GSTR-9 Offline Tool
GSTR-9C Offline Tool
Reap Returns Offline Tool
GSTR 11 Offline Tool
GSTR7 Offline Utility
GSTR10 Offline Tool
GSTR-9A Offline Tool
GSTR-4 (Annual) offline tool
Reap GSTR 6 Offline Tool With Amendments
16
You can download the Matching Offline Tool from the Portal without logging in to the
GST Portal (using the Downloads option).
3. The Matching Tool page is displayed. Click the Download hyperlink.
Make sure you carefully read the Important message and System Requirement
details displayed on the pag
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
Import of GSTR 2B JSON for IMPG, IMPGSEZ, ISD, ISDA tables.
• IMPG, IMPGSEZ, ISD, ISDA tables data view with sorting, filter and pagination.
• Export as CSV option in IMPG, IMPGSEZ, ISD, ISDA table.
• Providing matching summary as match category wise on post refinement with export as excel & CSV download for each match bucket.
GSTR-2B view summary with navigation for each table from summary table.
• Data deletion option at landing page to remove return period wise data on limit exceed.
GSTR-2B tables CSV download with filter enabled data.
System Requirement
To use the tool efficiently, ensure that you have the following installed on your system:
1. Operating system → Windows 7 or above. The tool does not work
on Linux and Mac.
2. Browser: You need one of these browsers installed on your
system.
• Internet Explorer 10+
• Google Chrome 7+
3. Microsoft Excel 2007 & above
4. Alternatively, for any below version the tool will open in a default
bro
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
rvices Tax
Home Services â–¾
GST Law
Downloads
Search Taxpayer-
Help and Taxpayer Facilities
e-Invoice
Matching Offline Tool
Skip
Main Content O
Matching Offline T…ap
Home Downloads Return
Matching Offline Tool v1.01
The Matching Offline Tool can be used in offline mode to:
1. View GSTR-ZD
2. Match GSTR-28 with Purchase Register
To install the tool, please download, extract the zip file and run the Download
Your downloaded (Matching Offline Tool) zip file contains:
MatchingOffineToolLv1.0 (Application)
Purchase Register Excel Template
Readme
. User Manual
Change History
Important!
Before 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
more.
Go through the Readme document before you begin installation.
âš« Double-click on Matching Offline Tool to install the offline tool.
What's new with Matching Offline Tool v1.0 (Released on 27/08/2020)
Opening the GSTR-28 JSON in offline tool.
Impor
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
TAX NETWORK
Name
GSTR2B_Offline Matching_Tool_Offline_…
PurchaseRegister Template V1.0
Date modified
Type
Size
8/17/2020 4:39 PM
8/17/2020 4:39 PM
Application
Microsoft Excel W…
23,512 KB
24 KB
Setup – GSTR2B_Offline_Matching_Tool_Offline_Tool_v…
Select Destination Location
Where should GSTR 2B_Offline Matching_Tool be installed?
Setup will install GSTR 2B_Offline Matching_Tool into the following folder.
To continue, click Next. If you would like to select a different folder, click Browse.
C:\GSTR2B_Offline Matching Tool
Browse…
At least 71.1 MB of free disk space is required.
Next >
Cancel
Matching Offline Tool
9. Select Create a desktop shortcut checkbox to create a shortcut for the Matching Tool on
your desktop.
10. Click Next.
Name
Date modified
GSTR2B_Offline_Matching_Tool_Offline_…
PurchaseRegister_Template V1.0
8/17/2020 4:39 PM
8/17/2020 4:39 PM
Туре
Application
Microsoft Excel W…
Size
23,512 KB
24 KB
Setup – GSTR2B_Offline_Matching_Tool_Offline_Tool_v.
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
created a profile in Offline tool, then enter your GSTIN or Trade/legal name in GSTIN field.
2. Trade/Legal name shall be auto filled based on the GSTIN or Trade/legal name entered in 'GSTIN field'.
3. Select Financial year and Tax period from the drop down.
4. Click on Proceed (Proceed button shall be enabled only after filling up all mandatory fields)
i No profile added. Please create profile of a taxpayer by clicking on 'Manage profile' option.
GSTINâš«
Trade/Legal name:
Financial Yearâ¤
Tax Periodâ‘:
Select
Select
The Matching Tool installation is a one-time activity.
Manage Profile eâ–¾
Delete File(s)
Designed and Developed by GSTN
Page 17 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
F.1. Create Profile
Use the links provided on the Matching Offline Tool (Form GSTR-2B with purchase order) page
to create your profile.
To create a profile in the Matching tool, perform the following steps:
1. On the Goods and Services Tax Matching Tool (Form GSTR-2B
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
details in the Matching tool.
OX
Good and Services Tax Matching Tool
Add Profile
34BOGPS8935H6ZB
GSTIN of Taxpayerâš«
GSTN
Trade/Legal nameâš«
No
HELP
• Indicates mandatory fields
SEZ Unit/Developerâš«
BACK
SAVE
8. Details get added in the Matching tool and another blank row appears to add more details. If
required, you can delete the row using the
icon.
Good and Services Tax Matching Tool
Add Profile
34BOGPS8935H6ZB
9. Click SAVE.
GSTIN of Taxpayerâš«
GSTN
Trade/Legal name.
No
Select
HELP
Indicates mandatory fields
SEZ Unit/Developerâš«
+
BACK SAVE
Designed and Developed by GSTN
Page 19 of 46
GIN
GOODS AND SERVICES TAX NETWORK
BO
Good and Services Tax Matching Tool
Add Profile
â— Profile(s) saved successfully!
GSTIN of Taxpayerâš«
Trade/Legal nameâš«
Select
Matching Offline Tool
HELP
• Indicates mandatory fields
SEZ Unit/Developerâš«
10. A confirmation message, “Profile is saved successfully” is displayed.
11. Click BACK to go back to the
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
n.
Designed and Developed by GSTN
Page 21 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
(G) View Form GSTR-2B Files in Matching
Tool
G.1. Download Form GSTR-2B JSON Files From GST Portal
To view Form GSTR-2B in the Matching Tool, perform the following steps.
1. To download Form GSTR-2B JSON files from GST portal, access the GST portal using the
URL: https://www.gst.gov.in/. The GST Home page is displayed.
2.
Goods and Services Tax
Home
Services â–¾
GST Law
Downloads â–¼
Search Taxpayer â–¼
Help and Taxpayer Facilities
E-Invoice
Home > Login
Login
Username*
Enter Username
Password*
Enter Password
LOGIN
âš« indicates mandatory fields
Forgot Username
Forgot Password
First time login: If you are logging in for the first time, click here to
log in.
Skip to Main Content
A+ A-
→ Login
Log in to the GST portal using valid credentials and go to Services > Returns > Returns
Dashboard.
Designed and Developed by GSTN
Page 22 of 46
GIN
GOODS AND SERVICES TAX N
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
earch Taxpayer â–¼ Help and Taxpayer Facilities
E-Invoice
Dashboard Returns
→ English
File Returns
Financial Year*
Return Filing Period
2020-21
July
Designed and Developed by GSTN
GSTR-2A can now be downloaded in excel/CSV format for you
• Indicates Mandatory Fields
SEARCH
Page 23 of 46
16
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
4. To download the Form GSTR-2B JSON files, click the Download button on the Auto – drafted
ITC Statement – GSTR -2B tile.
Details of outward supplies of goods
Details of auto drafted supplies
Table 6A of FORM GSTR1
or services
GSTR1
GSTR1A
Due Date 31/08/2020
Due Date 31/08/2020
PREPARE ONLINE
PREPARE OFFLINE
PREPARE ONLINE
PREPARE OFFLINE
PREPARE ONLINE
PREPARE OFFLINE
Inward supplies received by
taxpayer (For taking action)
GSTR2
Due Date 31/08/2020
Auto Drafted details (For view only)
Auto – drafted ITC Statement
GSTR2A
GSTR2B
VIEW
DOWNLOAD
PREPARE ONLINE
PREPARE OFFLINE
5. The Offline Download for Form GSTR-2B page is disp
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
rd > Returns > GSTR-2B
Offline Download for GSTR-2B
Help
saravana bhavan
34BOGPS8935H7ZA
→ English
FORM 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
information 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
file.
Download data for GSTR-2B
Note: Please refer help section for more details.
072020 34BOGPS….xlsx
GENERATE JSON FILE TO DOWNLOAD
GENERATE EXCEL FILE TO DOWNLOAD
You can find the JSON file under Downloads folder on your machine.
G.2. Open JSON Files in the Matching Tool
BACK
The next step is to open the Matching Tool and view Form GSTR-2B JSON files in the tool.
8. On the Home screen of the Matching Offline Tool, select the relevant GSTIN from the drop-
down list.
The drop-down list contains the profiles that are added by you in the Matching Tool.
Trade/Legal Name field gets auto
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
ble for Viewing
Select Table
VIEW SUMMARY OF GSTR-2B â–¼
Matching Offline Tool
Regular
2020-21
Jul
HELP
i
×
INFORMATION
☑
GSTR-2B json imported successfully. You can match the
GSTR-2B with your purchase register. Matching can be
initiated by selecting 'Matching Tool' option on the page.
XPORT TO EXCEL
OK
13. Click VIEW SUMMARY of Form GSTR-2B to view the summary.
Select Table for Viewing
Select Table for Viewing
VIEW SUMMARY OF GSTR-2B ^
BACK
ITC available
ITC not available
S.No.
Heading [Expand All ✓]
GSTR-3B table Integrated tax (*)
Central tax (*)
State/UT tax (*)
Cess (7)
Part A
ITC Available – Credit may be claimed in relevant headings in GSTR-3B
All other ITC – Supplies from registered persons other than reverse charge
4(A)(5)
0.00
0.00
0.00
0.00
||
III
Inward Supplies from ISD â–¼
4(A)(4)
0.00
0.00
0.00
0.00
3.1(d)
Inward Supplies liable for reverse charge ✓
0.00
0.00
0.00
0.00
4(A)(3)
IV
Import of Goods ✓
4(A)(1)
61,09,94,654.85
13,764.24
Par
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
D Credits received – ISDA
Import of goods from Overseas – IMPG
Import of goods from SEZ-IMPGSEZ
Once a table is selected, the respective table summary is displayed.
Select Table for Viewing
Taxable inward supplies received from registered persons – B2B
Taxable inward supplies received from registered persons – B2B
Table Summary ^
GSTIN of supplier
Trade/Legal name
No. of records
Total taxable value (*)
Total tax amount (*)
34BOGPS8935H6ZB
GSTN
7
39,000.00
7,605.00
Supplier wise summary
Document details
Display rate wise details
Search:
Q Search
BACK
Records
10
Per Page:
Select Columns To
Display/Hide:
+12â–¼
GSTIN of supplier
Trade/Legal name
Invoice number
Invoice type
â–¼
Invoice date T
Invoice value (*) ▲ Place of Supply →
Taxable value (*)
–
Integrat
tax (*)
34BOGPS8935H6ZB GSTN
3b4
Regular
04/02/2019
4,500.00
Puducherry
10,000.00
0.
34BOGPS8935H6ZB GSTN
3b3
Deemed Exports
03/02/2019
3,500.00
Puducherry
8,000.00
0.
34BOGPS8935H6ZB GSTN
3b2
Deemed Exports
02/02/
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
le % of tax
rate
Invoice number Invoice date
Τ
GSTIN of supplier Trade/Legal name Invoice number
Invoice type
Invoice date
Cess
☑ GSTR-1/5 Filing Date
3b2
02/02/2019
34BOGPS8935H6ZB GSTN
3bup2
Deemed Exports
03/02/2019
3b1
01/02/2019
34BOGPS8935H6ZB GSTN
3bup1
Deemed Exports
✔ GSTR-1/5 Period
☑ ITC Availability
02/02/2019
2b1
02/12/2018
34BOGPS8935H6ZB GSTN
2bup1
Regular
07/12/2018
2,000.00
Pudu
2b2
03/12/2018
34BOGPS8935H6ZB GSTN
2bup2 ✓
Regular
03/12/2018
3,000.00
Pudu
>
16. Click Display rate wise details to display the record details on the basis of rate.
Designed and Developed by GSTN
Page 29 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Supplier wise summary Document details
Hide rate wise details
Original Details
Matching Offline Tool
Records
Search Search
10
Per Page:
Select Columns To
Display/Hide:
+14
Invoice number
Invoice date
Τ
GSTIN of supplier
Trade/Legal name
Invoice number
Invoice type T
Invoice date
Τ
Invoice value (*)
Place of
3b2
02/02/20
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
gs in GSTR-3B
All other ITC – Supplies from registered persons other than reverse charge ^
4(A)(5)
B2B-Invoices
B2B – Debit notes
B2B
Do you want to open or save Jul 2020-21_34BOGPS8935H7ZA_GSTR2B_Offline.xlsx (26.6 KB) from localhost?
Designed and Developed by GSTN
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Open
Save
Cancel
×
Page 30 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Save and open the file from the local drive of your machine.
A1
fx
Goods and Services Tax – GSTR-2B
A
B
234567890
Matching Offline Tool
E
Goods and Services Tax – GSTR-2B
Financial Year 2020-21
Tax Period Jul
GSTIN 34BOGPS8935H7ZA
Trade/Legal name |GSTN
Date of generation 27/08/2020
10
Worksheet GSTR-2B Table Reference
11
Name
Field Name
GSTR-2B Data Entry Instructions
Instructions
12345670
18
GSTIN of Supplier
Trade/Legal name
Invoice number
Invoice type
Invoice date
Invoice value
Place of supply
GSTIN of supplier
Trade name of the supplier will be displayed. If trade name is not av
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
IMPORT EXCEL/CSV
2
3
GSTR-2B
PURCHASE REGISTER
MATCHING RESULT
(PR)
Note: Purchase register should be maintained as per the template provided on GST portal and the same can be downloaded therefrom.
Purchase register maintained in a format other than the template shall not be imported into the tool.
Matching Offline Tool
BACK
In case there appears some error in downloading Purchase Register, an error file is
generated, which can be downloaded by clicking the DOWNLOAD ERROR FILE.
By default, the error file gets downloaded in the Downloads folder of your machine. Open
the file to check the error.
The errors are displayed in the following format in an excel.
AutoSave Off
Jul 2020-2021_34BOGPS8935H7ZA_PR_Errorfile – Excel
Manika Bhardwaj MB
F
File
Home
Insert
Page Layout
Formulas
Data
Review View Help
Search
Share
Comments
Insert v
X
Σ
Calibri
• 11 – Α' Α'
===
ab Wrap Text
General
4
LGâ–¾
Paste
BIU
AA
Protect
Merge & Center
$ % 500-00
Conditional Format as Cell
Formatt
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
2000
0
0
0
20 Selected
3/12/2018
3000
0
Selected
1/2/2019
4000
259 Selected
2/2/2019
6000
550 Selected
Invoice
/000-3b3
3/2/2019
8000
340 Selected
SEZWOP
Invoice
3b4
4/2/2019
100001
610 Selected
11 34BOGPS8935H6ZB GSTN
SEZWP
Invoice
2bup1/0000
7/12/2018
12000
100
30 Selected
12 34BOGPS8935H6ZB GSTN
SEZWP
Invoice
2bup2aaa
3/12/2018
13000
0
0
0
65 Selected
13 34BOGPS8935H6Za GSTN
SEZWP
Invoice
3bup1
2/2/2019
4600
270 Selected
14 34BOGPS8935H6Zb GSTN
SEZWP
Debit Note
3bup2
3/2/2019
8100
620 Selected
15 34BOGPS8935H6aB GSTN
SEZWOP
Debit Note
2bcn1
5/12/2018
4000
16 34BOGPS8935H6ZB GSTN
SEZWP
Credit Note
3bcn1
17/02/2019
3300
17 34BOGPS8935H6ZB GSTN
SEZWP
Credit Note
3bcn2
18 34BOGPS8935H6ZB
GSTN
SEZWP
Debit Note
19 34BOGPS8935H6ZB GSTN
SEZWP
Debit Note
3bdb1
3bdb2
19/02/2019
18/02/2019
20/02/2019
7700
5510
9900
Selected
145 Selected
496 Selected
320 Selected
610 Selected
Fix the errors displayed in the excel and click IMPORT EXCEL/CSV again to import the
excel.
Designed and Developed by GS
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
urchase register.
Click VIEW PURCHASE REGISTER to view purchase register details. Detail view
of purchase register is displayed.
Detail view of Purchase Register
Supplier wise
Document wise
Search Q Search
GSTIN of
supplier ÷
+ 37APWCD7391FGZO
Records
Per Page:
10
Select Columns To
Display/Hide:
+10â–¼
Type of inward
supply
Taxable
value (*)
÷
Total
tax (*) =
Integrated
tax (*) ✰
Central
tax (*)
State/ UT
tax (*)
Cess
(Rs.) =
B2B
5,000.00
1,580.00
0.00
540.00
540.00
500.00
+ 34BOGPS8935H6ZB
B2B
-30,500.00
471.00
0.00
164.50
164.50
142.00
+ 34BOGPS8935H6ZB
DE
28,905.00
6.470.50
0.00
2,239.75
2,239.75
1,991.00
Designed and Developed by GSTN
BACK
Page 33 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
18. Click the Supplier wise tab to view purchase register records on the basis of suppliers.
19. Click the Document wise tab to view purchase register records on the basis of documents.
Supplier wise
Document wise
Search
Q Search
Records
Per Page:
10
Select Colu
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
.00
1,093.00
0.00
379.50
379.50
334.00
34BOGPS8935H6ZB
DE
Debit Note
3bdb2
20/02/2019
9,800.00
1,938.00
0.00
669.00
669.00
600.00
« Previous
1 2 Next >>
BACK
20. Click the Next and Back buttons to navigate through document wise details of the
purchase register.
The sorting and filter buttons are available along with each column header to sort
and filter table data. Use the buttons to display records in ascending or descending
order or filter details in a column.
(I) Match Results
21. To match results of Form GSTR-2B details with the purchase register, click the MATCH
button.
The summary and details of the match result is displayed in different sections.
Designed and Developed by GSTN
Page 34 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Details of matching result
Supplies from registered persons (B2B)
Matching result
Match type
No. of documents
M1 Exact match
M2 Partial match
Match
M3 Probable match
1
1
0
Taxable value (*)
Matching Offline Tool
Export to CSV
Total tax amount (*)
4,500.00
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
cument type
â– Document number
â–
â–
Document date
Taxable value
Total tax amount
Integrated tax
•
•
Central tax
Designed and Developed by GSTN
State/UT tax
BACK
Page 35 of 46
GIN
GOODS AND SERVICES TAX NETWORK
• Cess
Matching Offline Tool
Ο
Partial match: Records match partially
O Probable match: Mismatch in between GSTIN and Document type and
complete match in all other parameters
â—‹ Mismatch (Few parameters do not match or record does not exist in Form
GSTR-2B or Purchase register
Unmatched: Two or more parameters do not match
â—‹
â—‹
In GSTR-2B not in Purchaser register
O
In Purchase register not in GSTR-2B
•
No. of documents: Displays the number of documents matched or mismatched.
•
Total taxable value: Displays the value of tax on match or mismatch of respective
tables
Below the summary, details of the matching result are displayed as per the matches made
for example: Supplies from registered person (B2B), Deemed exp
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
Invoice
2bup1
07/12/2018
2,000.00
120.00
0.00
50.00
50.00
20.00
2
No
34BOGPS8935H6ZB
Invoice
2bup1
07/12/2018
2,000.00
120.00
0.00
50.00
50.00
20.00
34BOGPS8935H6ZB
Invoice
2bup2
03/12/2018
3,000.00
215.00
0.00
75.00
75.00
65.00
No
34BOGPS8935H6ZB
Invoice
2bup2
03/12/2018
3,000.00
215.00
0.00
75.00
75.00
65.00
You can download the details of matching results in CSV/ Excel format using Export to CSV
option.
Designed and Developed by GSTN
Page 36 of 46
GIN
GOODS AND SERVICES TAX NETWORK
Matching Offline Tool
23. Select the option from the Export to CSV drop-down to download the results in an excel file.
Matching result – Details
Select Table Supplies from registered persons (B2B) â–¼
Matching Result Match
Match Type All
Search
Q Search
Records
Per Page:
10
Select Columns To
Display/Hide:
+12
GSTIN: GSTR-2B records GSTIN: Purchase Register(PR) records
Export to CSV: Select
GSTIN of
supplier =
Document
type ÷ T
Document
number ✰
Document
Taxable
date T
value (*) ✰
Total
ta
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
ult Match
Match Type All
Records
Per Page:
Select Columns To
10
Display/Hide:
+12â–¼
GSTIN: GSTR-2B records
GSTIN: Purchase Register(PR) records
Export to CSV Select
GSTIN of
supplier ÷
Document
type T
Document Document
number + date
T
Taxable
value (*) *
Total
tax (*) ✰
Integrated
tax (*) ✰
Central
tax (*)
State/ UT
tax (Rs.) ✰
ITC
Cess (*)
Availability
34BOGPS8935H6ZB
Credit Note
2bcn1
05/12/2018
4,000.00
510.00
0.00
187.50
187.50
135.00
No
34BOGPS8935H6ZB
Credit Note
2bcn1
05/12/2018
4,000.00
510.00
0.00
187.50
187.50
135.00
34BOGPS8935H6ZB
Debit Note
2bcnup1
10/12/2018
4,500.00
570.00
0.00
200.00
200.00
170.00
No
34BOGPS8935H6ZB Debit Note
2bcnup1
10/12/2018
4,500.00
570.00
0.00
200.00
200.00
170.00
34BOGPS8935H6ZB
Invoice
2bup1
07/12/2018
2,000.00
120.00
0.00
50.00
50.00
20.00
No
34BOGPS8935H6ZB
Invoice
2bup1
07/12/2018
2,000.00
120.00
0.00
50.00
500
Save
Save as
Do you want to save Jul 2020-21 34BOGPS8935H7ZA_All.csv (1.41 KB) from localhost?
Save
Save and o
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
T Cess (*) ITC availal Supply att Amended Match typ Reason
No
No
Remarks Type of inward supply
GSTR-2B Record
187.5
135 No
Exact match
6 34BOGPS GSTN
7 34BOGPS GSTN
8 34BOGPSE GSTN
9 34BOGPSE GSTN
10 34BOGPS GSTN
11 34BOGPS GSTN
12 34BOGPS GSTN
Credit Not 2bcn1
Debit Not 2bcnup1
Debit Not 2bcnup1
Invoice 2bup1
Invoice 2bup1 07/12/201
Invoice 2bup2 03/12/201
Invoice 2bup2 03/12/201
05/12/201 4000
510
0
187.5
187.5
135
Exact match
Purchase | B2B
10/12/201
10/12/201
4500
570
0
200
200
170 No
No
Yes
4500
570
0
200
200
170
Exact match
Exact match
07/12/201
2000
120
0
50
50
20 No
No
Yes
Exact match
2000
120
0
50
50
20
3000
3000
215
0
75
75
65 No
No
Yes
215
0
75
75
65
Exact match
Exact match
Exact match
GSTR-2B Record
Purchase | B2B
GSTR-2B Record
Purchase (B2B
GSTR-2B Record
Purchase B2B
13
25. To view details of match present In GSTR-2B not in PR and In PR not in GSTR-2B, click
the options available in blue text under the Details of matching results section.
âš«In PR not in GSTR-2B
TOTAL
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
M4(2) In GSTR-2B not in PR
Records
Per Page
10
Select Columns To
Display/Hide:
Export to CSV : Select
+10 â–¼
GSTIN of
supplier = type
Document
T
Document
number →
Document
date ÷ T
Taxable
value (*) *
Total
tax (*)
Integrated
tax (*) ✰
Central
tax (*)
State/ UT
tax (*) ✰
ITC
Cess (*) ✰
Availability
34BOGPS8935H6ZB
Invoice
1000
01/12/2018
6,000.00
1,650.00
0.00
565.00
565.00
520.00
34BOGPS8935H6ZB
Invoice
2b1
02/12/2018
2,000.00
120.00
0.00
50.00
50.00
20.00
221
No
No
34BOGPS8935H6ZB
Invoice
2b2
03/12/2018
3,000.00
220.00
0.00
75.00
75.00
70.00
No
34BOGPS8935H6ZB
Debit Note
2bdb1
06/12/2018
2,500.00
277.50
0.00
93.75
93.75
90.00
No
34BOGPS8935H6ZB
Invoice
3b4
04/02/2019
10,000.00
1,927.50
0.00
663.75
663.75
600.00
No
26. To view records, present In PR not in GSTR-2B, click the Match Type drop-down and
select the option.
Matching result – Details
Select Table Supplies from registered persons (B2B)
Search Search
Matching Result Mismatch
Match Type M4(2) In G
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
m registered persons (B2B)
Search Search
(PR)
Matching Result Mismatch
GSTIN: GSTR-2B records GSTIN: Purchase Register(PR) records
Matching Offline Tool
Match Type M4(3) In PR not in GSTR-2B
Records
Per Page:
Select Columns To
10
Display/Hide:
Export to CSV : Select
+9â–¾
GSTIN of
supplier ÷
Document
type T
Document
number
Document
Taxable
date
T
value (*) ✰
Total
tax (3) ✰
Integrated
tax (*) ✰
Central
tax (*)
State/ UT
tax (Rs.)
Cess (*)
34BOGPS8935H6ZB
Invoice
1000
01/07/2020
1,000.00
70.00
0.00
25.00
25.00
37APWCD7391FGZO
Invoice
1000
01/12/2018
3,000.00
1,240.00
0.00
420.00
420.00
4
37APWCD7391FGZO
Invoice
1000
01/07/2020
2,000.00
340.00
0.00
120.00
120.00
1
BACK
The Export to CSV option enables you to download details of Matching result and Purchase
Register in separate excel sheets.
Matching result – Details
Select Table Supplies from registered persons (B2B)
Matching Result Mismatch
Match Type M4(2) In GSTR-2B not in PR
Search Search
Records
Per Page:
10
Se
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
Internal\Companywide usage
Sensitivity:
A
B
Ñ
D
E
F
Public
Internal
Confidential
Highly Confidential
G
H
|
J
K
L
M
N
O
1 GSTIN of Trade/Leg Financial Tax period Table Nan Matching Match Type
34BOGPSÆ GSTN 2020-21 Jul-20 Supplies f Mismatch 2) In GSTR-2B not in PR
GSTIN of s Trade/Leg Document Document Document Taxable va Total tax (Integrated Central ta State/ UT Cess (*) Match typ Remarks
5 34BOGPS GSTN
6 34BOGPS GSTN
7 34BOGPSE GSTN
8 34BOGPS GSTN
9 34BOGPS GSTN
Invoice
Invoice 2b1
Invoice 2b2
Debit Not 2bdb1
Invoice 3b4
1000 01/12/201 6000
1650
0
565
565
02/12/201 2000
03/12/201 3000
120
0
50
50
220
0
75
06/12/201 2500 277.5
04/02/201 10000 1927.5
0
93.75
75
93.75
0 663.75 663.75
520 In GSTR-21 GSTR-2B record
20 In GSTR-2 GSTR-2B record
70 In GSTR-21 GSTR-2B record
90 In GSTR-21 GSTR-2B record
600 In GSTR-21 GSTR-2B record
10
The screenshot below displays Details of Purchase Register in an excel format.
Sensitivity: Internal \ Companywide usage
Public
Internal
Confidential
A
B
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
into
Export to CSV
Taxable value (*)
Total tax amount (*)
5,500.00
395.00
0.00
0.00
Match
M3 Probable match
0
0.00
0.00
Sub-total
4
5,500.00
395.00
M4(1) Unmatched
0
0.00
0.00
Mismatch
M4(2) In GSTR-2B not in PR
M4(3) In PR not in GSTR-2B
5
23,500.00
4,195.00
3
6,000.00
1,650.00
Sub-total
8
29,500.00
5,845.00
TOTAL
12
35,000.00
6,240.00
Deemed Exports (DE)
28. Save and open the excel file from the local drive of your machine.
Insert
Delete
â–¾
Conditional Format as Cell
Formatting
√
Table Styles
Styles
Format
Cells
File
Home Insert Page Layout
Formulas
Data Review View Help
Search
X
Calibri
• 11 – Α' Α ==
Wrap Text
General
Paste
BIU
Protect
A
Merge & Center
$ % 950000
Clipboard 5
Font
Б
Alignment
Protection
Number
A1
X
fx
GSTIN of Recipient
WŻÓ
Share
Comments
Sort & Find &
Filter Select
Ideas
Editing
Ideas
Sensitivity: Internal\Companywide usage /
Public
Internal
Confidential
Highly Confidential â–¼
A
C
D
E
F
G
H
I
J
K
L
M
GSTIN of Recipient
2 34B
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
. To refine match results, click the REFINE MATCHING RESULTS button on the match result
page. The REFINE MATCHING RESULTS window is displayed.
Designed and Developed by GSTN
Page 42 of 46
GIN
GOODS AND SERVICES TAX NETWORK
REFINE MATCHING RESULT
Set tolerance for individual tax amount (Integrated tax, Central tax,
State/UT tax and Cess)
Apply approximation for matching on document number :
Summary of GSTR-2B an
Exact match (All 7 parameters match)
APPLY & RE-MATCH
GSTR-2B
2
Matching Offline Tool
select
REFINE MATCHING RESULT
select
1
Purchase regis
9
10
e value ()
Total tax amount (*)
1,500.00
245.00
Partial match
1
1
-4,000.00
-510.00
Probable match
0
0
0.00
0.00
Mismatch (Few parameters do not match or record do not exist in GSTR-2B/PR)
17
10
86,805.00
17,428.50
• Unmatched (2 or more parameters not match) 0
2
2
15,400.00
3,009.00
• In GSTR-2B not in PR
• In PR not in GSTR-2B
15
0
43,700.00
8,664.00
0
8
27,705.00
5,755.50
TOTAL
20
13
84,305.00
17,163.50
2. Click sel
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =
cord do not exist in GSTR-2B/PR)
14
7
68,805.00
15,125.50
• Unmatched (2 or more parameters not match) →
2
2
15,400.00
3,009.00
•In GSTR-2B not in PR
12
0
34,700.00
7,516.50
• In PR not in GSTR-2B
0
5
18,705.00
4,600.00
TOTAL
20
13
75,305.00
16,008.00
Details of matching result
Supplies from registered persons (B2B)
Matching result
Match type
No. of documents
M1(1) Exact match
1
M1(2) Match with tolerance
0
Export to CSV ☑
Taxable value (*)
Total tax amount (*)
4,500.00
570.00
0.00
0.00
M1(3) Match with approximation
0
0.00
0.00
Sub-total
1
4,500.00
570.00
M2(1) Partial match
1
-4,000.00
-510.00
M2(2) Partial match with tolerance
Match
M2(3) Partial match with approximation
Sub-total
3
1,000.00
0
0.00
2
5,000.00
335.00
0
0.00
0.00
-175.00
0.00
M3(1) Probable match
M3(2) Probable match with tolerance
0
0.00
0.00
M3(3) Probable match with approximation
0
0.00
0.00
Sub-total
0
0.00
0.00
M4(1) Unmatched
0
0.00
0.00
M4(2) In GSTR-2B not in PR
Mismatch
M4(3) In
= = = = = = = =
Plain text (Extract) only
For full text:-Visit the Source
= = = = = = = =