Functionality of Tool
- You can reconcile GSTR-2 and IMS (Purchase, 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-2 is VCRPL/23-24/326 while in IMS it is only 326, then it also gets matched.
- All reconciled data is shown in green color, while un-reconciled data is shown in red color.
How to Use Tool
- Upload JSON or XLSX file in GSTR-2 section. You can also upload more than one file.
- Upload XLSX file(s) in IMS 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-2 and IMS. For entries which are in both GSTR-2 and IMS, it will be shown as single entry.
2. Present in both - Shows entries which are present in both GSTR-2 and IMS
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 IMS - Shows entries which are only in IMS - 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-2 JSON or Excel Files
GSTR-2 file can be downloaded from your accounting software. All major accounting software gives this option to download in Excel or JSON or both.