Overview of GSTR 2B Reconciliation in Marg ERP Software

Process to Enable API Access in GST Portal

Process of GSTR 2B Reconciliation through Marg ERP Software

OVERVIEW OF GSTR 2B RECONCILIATION IN MARG ERP SOFTWARE

• The GSTR-2B is an auto-drafted statement of the input tax credit through which the taxpayers know about their ITC, i.e., how much eligible and ineligible ITC can be availed on a monthly basis.

• In Marg ERP Software, the user can easily reconcile the GSTR-2B entries and view the detailed information of all the invoices, i.e., matched, mismatched, not uploaded, and absent in Marg.

PROCESS TO ENABLE API ACCESS IN GST PORTAL

• Firstly, the user needs to enable API Access in GST Portal.

• Go to www.gst.gov.in and click on Login.

Fig. 1 Path to Visit GST Portal 

• Mention the ‘Username’ and ‘Password’.

• Then type the characters as displayed in the image and then click on ‘Login’.

• Click on ‘My Profile’ by visiting on the top right side of GST Portal.

• A ‘My Profile’ window will appear in which the user will click on ‘Manage API Access’ from the ‘Quick Links’ Tab.

• A ‘Manage API Access’ window will appear. Select ‘Yes’ in ‘Enable API Request’ field.

• Then select ‘Duration’.

• Suppose, if the user selects 6 hours and click on ‘Confirm’. Then while reconciling GSTR 2B, an OTP will be received on the registered mobile number which will be valid for only 6 hours i.e. the user can download as many JSON files in 6 hours.

• And after 6 hours, when the user visits again to reconcile then OTP needs to be provided again in order to download JSON file.

• Similarly, if the user selects 30 days then the user can download as many JSON files in 30 days.

• And again after 30 days, the user needs to provide an OTP again in order to download JSON file.

• For now, the user will select the duration (30 Days) as per the requirement and then click on ‘Confirm’.

PROCESS OF GSTR 2B RECONCILIATION THROUGH MARG ERP SOFTWARE

• Either go to GST >> GSTR Settings.

• A ‘GSTR Settings’ window will appear with different options.

• Select ‘A. Common GSTR Settings’ option.

A ‘GSTR Settings’ window will appear with different fields:

a. GSTN User Name: Mention the same username which is being registered on the GST Portal. Then click on ‘Okay’.

• Now go to GST >> GSTR 2A-2B Reconciliation.

• Then click on ‘GSTR 2B’.

• A ‘GSTR -2 Reconciliation’ window will appear.

• Select the Period i.e. from which month till which month the user needs to reconcile GSTR 2B.

• Then click on ‘Show’.

• If the user needs to change the period, then can click on ‘Change’.

• The user can view that in this way GSTR-2B Reconciliation window will appear.

• Now, the user will click on that particular month of which GSTR-2B needs to be reconciled.

• Suppose click on ‘October’.

• A ‘pop-up’ will appear with different options.

• If the user already has JSON File, then select ‘Manual’ and click on ‘Okay’.

• Then the user will select the JSON File and reconcile it.

• An alert of 'File Saved' will appear, select 'Ok'.

• If the user will click on ‘Download’ and internet connectivity is there in the system, then JSON will automatically get downloaded from GST Portal and then reconciliation can be done.

• So, select ‘Download’ and then click on ‘Okay’.

• If 6 hours or 30 days is being selected on GST Portal, then whenever the user will click on ‘Download’ for the first time the software will ask for an OTP.

• After entering the OTP, click on ‘Verify’.

• The software will give an alert to download the JSON file for the month of October.

• Click on ‘Ok’.

• Now the software is asking to download the JSON file for the month of October 2022.

• Click on ‘Yes’.

• As the user will click on ‘Yes’, all the data that exists in the JSON File will get displayed.

• The user can view ‘Total number of entries, Taxable amount, CGST, SGST, IGST, CESS and Total Tax’.

• The entries in Green indicates that the invoices are matched.

• Similarly, the entries in Red indicates that those invoices are mis-matched i.e. that the invoice value on the GST Portal is different and the value in the invoice created in Marg Software is different.

• And the entries in Purple indicates that those invoices are not been uploaded on the GST Portal.

• And the entries in Blue indicates that those invoices are not been created in Marg Software.

• If the user needs to view the details of any entry like to view the details of matched invoices, then the user will either double click on Matched or click on ‘Detailed’ from here.

• So, in this way the details of all the matched invoices will be displayed to the user i.e. the user can view Name of the Customer, Invoice Number, Invoice Date, GSTIN, Invoice Value.

• After this the Taxable Amount, Tax Rate and Tax Amount that is displayed to the user under Auto Populated are those amounts which the seller has uploaded on GST Portal while filling GSTR 1.

• And the Taxable Amount, Tax Rate and Tax Amount displayed under ‘Marg GSTR2 Data’ are those amount of the invoices which the user has created in Marg Software.

• Now if the user needs to save the status of the reconciled entries then click on ‘Save’.

Note: In GSTR 3B, there is an option in which the user can get the figures of GSTR-2B from the reconciled entries otherwise the software will pick those figures from the Accounting Books.

• Here, only matched entries will be shown to the user.

• After this, if the user needs to export an entry in ‘Excel’ or ‘GUI’ then click on ‘Report’ and select the entry as per the requirement.

Fig 2. Select 'Report'.

Fig 3. Select 'GUI/Excel'.

Also, if the user needs to view its summary, then click on ‘Summary’ from here.

• Now, if the user needs to view total invoices then simply click on ‘Total’ invoices and then click on ‘Detailed’.

• So, in this way the details of all the matched, mismatched, not uploaded and absent in Marg will be displayed.

• Suppose click on ‘Summary’.

• Then the user can select from the ‘Invoice Type’ that whether the user needs to view B2B invoice or Debit/Credit Notes.

• Then from the ‘Invoice Status’, the user can view that how many invoices are matched along with the total number of matched invoices.

• Similarly, the total number of invoices which are not been uploaded will be displayed to the user.

• So, in this way the user can view the invoice status.

• Then is ‘Mismatch Amount’. If an invoice costs Rs. 15005.

• And if any invoice is getting mismatched with Rs.5 and want that the software should ignore this then by mentioning 5 in mismatch amount, the user will tick on the checkbox of ‘Ignore Invoice Amount’.

• And if the user needs that the software should ignore the invoice date then tick on the checkbox of ‘Ignore Dates’ box. 

So, in this way the user can reconcile GSTR-2B in Marg ERP Software.