How to reconcile and file GSTR 2 with purchase data ?

How to reconcile and file GSTR 2 with purchase data ?






Please download last patch (Release 31 or later) for Unisolve/Cross version 16.2 We have provided offline reconciliation option for GSTR 2 in this release. This is another first of its kind - solution from SWIL Team. You will be able to import JSON file for GSTR 2 (downloaded from GSTN after login there) and reconcile the same with your data. From GST Menu - Select GSTR Forms (JSON for GSTN) submenu and Import GSTR 2 JSON option. It will ask you to select JSON file, you have to select the file downloaded from GSTN. Please generate GST summary for that month before checking GST reports.

After that GST Menu - Select GSTR Forms (JSON for GSTN) submenu and Reconcile GSTR 2 JSON option. It will show you a screen like this. First of all supplier list with no. of invoices, invoice value and tax value. It shows you one more column whether the supplier has filed GSTR 1 or not. You can reconcile a puirchase invoice only after the supplier has filed GSTR 1 else he may change the same before final submission.

Next table shows you invoice list and two columns are available for editing - Status and Invoice No. At the time of import we try to match all purchase invoices with entered purchase invoice data, so it will show your purchase invoice entry against purchase invoice downloaded from GSTN. You will be able to select invoice no. if not already shown or wrongly shown. You can press ENTER or select any other column to view tax rate wise amounts. 

Status field will show as per following at the time of import:-

Accept - if amounts are matching with tolerance limit for Rs. 10 
Pending - if amounts are not matching.

You can select any of following status:
 
Accept - If you want to accept supplier invoice as is. If your data does not match, rectify purchase data manually to match data in future.
Overwrite - You can select overwrite if you want to submit your amounts to supplier.  If the supplier accepts in R1 A, effect of amount will appear in GSTR 3.
Pending - Do nothing, keep on hold
Missing - Supplier did not upload and you want to add the same. If the supplier accepts in R1 A, effect of amount will appear in GSTR 3.
Reject - The purchase invoice does not belong to you and you want to reject the same.
No Action - Nothing to do.

The display will be like following after selection of supplier, purchase invoice and tax rate wise details are displayed.
 


We shall provide you more details to help you file GSTR 2 easily. After reconciliation, you can export GSTR2 JSON using GST Menu - GST Forms (JSON for GSTN) submenu. Then you can login to GSTN and import this GSTR 2 file there. This facility is provided for B2B invoices, rest of the details can be entered online. You can use GSTN offline tool to import GSTR 2 using GST Menu -> GST Forms (Excel for Offline Tool) - Export GSTR2 Excel. This file provides you B2C data and HSN summary. Using this detail, you can login to GSTN and file GSTR 2.

We are sure that with our innovative ideas, we shall be able to help you in handling GST workload.