Functionality of Tool
- You can reconcile GSTR-2A and GSTR-2 (Purchases, Credit & Debit Notes)
- It first reconcile 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-2A is VCRPL/23-24/326 while in GSTR-2 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 file in GSTR-2A 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-2A and GSTR-2. For entries which are in both GSTR-2A and GSTR-2, it will be shown as single entry.
2. Present in both - Shows entries which are present in both GSTR-2A 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-2A - Shows entries which are only in GSTR-2A - 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-2A JSON files from GST Portal
- Login in GST portal.
- Click on Return Dashboard.
- Select financial year, quarter and then month.
- Click on download button in GSTR-2A 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.