GSTR 2B Reconciliation with GSTZen

GSTR 2B reconciliation has never been easier. With options to reconcile, GSTZen will compare and reconcile your Books with the Invoices your Suppliers upload to the GST Government Portal. GSTR 2B is a progressive auto-drafted statement that provides input tax credit (ITC) details to every recipient of supplies, based on the suppliers’ data. It is dynamic, as it changes from day to day, as and when a supplier uploads the documents.

Through GSTZen, you can reconcile GSTR 2B in 4 simple steps:

1. Download Supplier Invoice GSTR 2B from the government portal
2. Upload Purchase Invoice through Excel (OR) Tally
3. Run GSTZen Intelligent matcher
4. Download the report

Login to GSTZen account and select the GSTIN in the Dashboard for which you want to perform the reconciliation.

 Click on Reconcile Books vs Govt. Portal Data, then select “Purchase Register vs GSTR-2B” and the relevant period.

Step 1: Log in to the GST Portal, either through OTP or Username and Password.

Click on the check boxes for the data you want to download, and click on “Download data from the Government Portal”.

Here is how you may determine the download status. Once you see that all data points have a Green Tick mark, you may proceed to the next step.

Step 2: Upload your Purchases Invoices and Credit/Debit Notes through Excel/Tally

Note:

• You may either choose GSTZen’s Excel sample to upload the invoices or use your Excel file with invoice and credit/debit note data.
• Once you upload the Excel file, choose the appropriate XLS data format and click on Upload Purchase Invoice XLS File.
• If the Excel file has multiple sheets, you will be prompted to choose the sheet with the data. Click on Use this Sheet against the sheet with invoice data.
• You will now be required to map columns in your Excel sheet into GSTZen. All mandatory fields are marked with a red asterisk. Click on Process file upload once the column mapping is complete.
• GSTZen will process the invoices and provide a summary. Click on Confirm and Save entries once you verify the summary. Once the invoices are uploaded, you will be able to view them in your GSTZen Purchase Register.
• Alternatively, you may also upload Purchase Invoices through Tally. Please refer to the article https://gstzen.in/a/choose-tally-company.html
  

Step 3: Run GSTZen Reconciliation Matcher

GSTZen Reconciliation Matcher will match fields such as Invoice Number, Invoice Date, GST Number, Invoice Amount, etc, to make the best possible match. GSTZen gives you results relevant to each field or basis of matching.

Click on Run Purchase Details Matcher and choose the Maximum Days Difference and Maximum Tax Amount Difference according to your business. Click on Run Intelligent Matcher.

Once the software gives you a notification that the matcher has run, you will see an option to download the reports. Click on Download Reports.

Step 4: Download the Reconciliation report

You may now scroll down to the Step 4 section and download the Excel report. You get to choose the reconciliation report based on the Invoice Date, Record Date, and Filing Period.

To know more about the difference between these reports, please read – Difference between Invoice Date, Record Date, and Filing period

Review the Excel Report (Sheets Available)

The Excel file contains multiple sheets:

1. Overview: Overview of Books vs GSTR 2B based on different Matching Status.
2. GSTR-2B Summary: Summary of ITC calculations of taxes
3. GSTR-2B Invoice Reconciliation: Transaction-level reconciliation report of all the parameters of an Invoice.
4. GSTR 2B Amendment vs Original: Provide an overview of Original fields and Amended fields.
5. GSTR-2B by Vendor: Purchases, Debit Notes & Credit Notes by vendor, month-wise.
   
   Steps to update your preferred action using an XLS file
   

A. Download the XLS file from GSTZen.

B. Open the XLS file, go to GSTR-2B Invoice Reconciliation sheet, and choose your preferred action from the dropdown menu in column AN to AS.

C. Go to the GSTZen tab in the XLS file.

D. Click on Login and provide your GSTZen account login credentials.

E. Once you click on the Invoice upload, your actions will automatically save in GSTZen.

Please refer to the following article to the steps:

Email to Supplier- https://gstzen.in/reconciliation/reco/sending-emails-to-suppliers-from-gstzen.html