Functionality of Tool
- You can match GSTR-2B and GSTR-2 (Purchases, Credit & Debit Notes)
- It first matches on basis of exact invoice number and then also do partial matching of invoice number. For example, if for same GSTIN, an invoice in GSTR-2B is VCRPL/23-24/326 while in GSTR-2 it is only 326, then it also gets matched.
- All matched data is shown in green color, while unmatched data is shown in red color.
How to Use Tool
- Upload JSON file in GSTR-2B section. You can also upload more than one file.
- Upload JSON or XLSX file(s) in GSTR-2 section. You can also upload more than one file.
- A dropdown will be shown with 5 options.
1. All Entries - Shows all entries from both GSTR-2B and GSTR-2. For entries which are in both GSTR-2B and GSTR-2, it will be shown as single entry.
2. Present in both - Shows entries which are present in both GSTR-2B and GSTR-2
3. Probable Matches - Shows entries which are probable matches
4. Only in GSTR-2 - Shows entries which are only in GSTR-2
5. Only in GSTR-2B - Shows entries which are only in GSTR-2B - You can group on basis of Supplier GSTIN or can see a total summary.
- You can also filter on basis of party from dropdown on right side. Or by clicking on any GSTIN in supplier wise view.
- You can also search for any invoice number or GSTIN or amount or any other field.
- Click on download Excel button to download Excel file.
How to Download GSTR-2B JSON files from GST Portal
- Login in GST portal.
- Click on Return Dashboard.
- Select financial year, quarter and then month. If you want to download JSON for the whole quarter, then select last month of quarter.
- Click on download button in GSTR-2B section. If you have selected last month of quarter, then section for month and quarter will come. Click on required section.
- Click on "Generate JSON file to Download" button. It will generate JSON file and will be available for download in up to 20 minutes.
- If you want to download multiple JSON files, then you can use chrome extension like this - TaxTribute GST Assistant or XLSDeal.