2A/2B Reconciliation / ITC Maximize

GSTR2A-2B Reconciliation


How to do GSTR2A-2B Reconciliation?

STEP-1

Login to  www.expressgst.com >>> Select  Company Name  for which Reco is to be done

Company’s GSTIN Dashboard will appear.


STEP- 2

On  GSTIN Dashboard >>>click on   F.Y. &   Select Year >>>click on View Annual Reco



STEP-3 Import Books Data

At this step, your data is already synced with portal; you just need to import books data by the Import books data button from the left side of screen.



Click on  Import Books Data >>> Select  Month>>> Browse the data file>>> Click on  Import Now .

Select the month for which you want Reco

Note: 1. If you want to import Annual data then import the data In the month of March.

2. If you do not have any accounting software then you can use our template.



Now Browse the file and Click on Import Now
 


After Import, It will show the count of Invoices successfully Imported under the import status.

You can re-import if you want to otherwise you can click on Okay.


STEP- 4 

How to reconcile the imported books data and 2A/2B data automatically synced from portal?

We have 3 types of Reco:  1. Supplier Wise

                2. Invoice Wise

                3. Month Wise

Step – 4.1 – Supplier Wise Reco

This Type of reco is useful when you want to check the Supplier wise Difference in Tax or taxable value. 

It is done by sorting Invoices by supplier’s name and checking if the Invoices of particular Supplier present in 2A/2B are also present in Books or not. Matching of Invoices is categorized into 4 types of statuses as explained below:-


Matched: Invoices which were found in books as well as on portal and amount is matched.

Partially matched: Invoices were found in books as well as on portal but there is difference in amount.

In 2B only: Invoices are found on portal in 2B only.

In Books OnlyInvoices are found in books only, no corresponding invoices found on portal.



In the above example, it can be understood that 1 Invoice of Supplier imatched and 1 is in 2B onlyAlso it can be seen that there is Tax diff of ₹139.08 as per books and as per 2B which could be due to 1 invoice that was missed to be accounted in books and is appearing 2B only.

For details, you should click on supplier name and you will get the detailed bill to bill reco of the supplier as shown below.


How can we sort or filter the data in reco?

You can Sort the reco with excel like filter & Sorting options given at the column heads.

You can Sort Supplier Name Alphabetically in increasing or decreasing order by Clicking on Supplier name column head. 

GSTN number can be searched by using Filter like button and similarly other columns can be filtered also.




STEP 4.2- Invoice wise Reco

Click on Invoice-wise Reco to view invoice wise data reconciliation.

Here you can do reco by selecting any of the Statuses vis-à-vis Matched, Partially Matched, in 2B only, in books only

 


Matched StatusSelect the Matched status (put a tick)  it will show you the invoices of your books totally matched with the portal data.

Partially Matched Status: Select the partially matched status to check the invoices matched partially 

And similarly you can check the In books only and In 2B only by selecting the respective statuses.


How can we sort or filter the data in reco?

You can Sort and filter the data as discussed in Step 4.1 above


Step 4.3 – Month Wise Reco

Click on Month Wise Reco to get the reconciliation done by month wise.

You will get the graphical view. You can get the taxable and tax figures if you click on Flip Button here.


This is the Month wise Reco where you get to reconcile data by 2A, 2B and Books.







  1. How to view Reco by 2A?


You can simply Click on the By 2A tag in the Supplier Wise Reco.


  1. How to view Annual, Quarterly or Monthly Reco?

You can simply click on Annual Tag or Quarterly Tag or Monthly tag to view the required type of reco. You can select Multi-Month, Multi –Quarter in this Page.



  1. How to email the Complete Reco data?

Click on Complete Data           Enter the email         Click on Send Button

You can email the complete Reco report Containing Supplierwise 2A-2B Reco and Invoice wise 2A-2B Reco. You can Click on Email Complete Data Button on right side of Page and enter any email id and get the complete reco report on the email within few seconds.






    • Related Articles

    • GSTR-2A Reconciliation

      GST reconciliation primarily involves matching the data uploaded by the suppliers with those of the recipient's purchase data. This basically includes comparing the GSTR-2A auto-populated from suppliers data and the purchase data recorded by the ...
    • Invoice & other data upload for creation of GSTR 2 in Express GST | GST Filing

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. b2b B2B Supplies - ...
    • How to Export GSTR-2 data in MS Excel?

      To export GSTR-2 returns Data in the MS Excel follow the steps below : Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2 Make sure that there are no items under the section Not included in returns due to incomplete information     ...
    • GST Software > GSTR-9 > Proceed to file option not working

      In case you are not able to file GSTR-9, Please Check as the GSTR-9 for FY 2020-2021 is valid only if all GSTR's (GSTR-1 and GSTR-3B) for FY 2020-2021 are filled. According to the screenshot, Once you filled Feb-21 and Mar-21 returns GSTR-1 and ...
    • GST Software > GSTR-9C > Error Occurred, please close the browser, close the Utility and try again.

      Solution: All of us know that we need to first download GSTR 9C utility from GST portal’s Download section and Import our JSON file in this through " Open GSTR-9C JSON File Downloaded from GST Portal" option, still after this our job is not over. ...