Purchase Vs GSTR-2B Reconciliation

3 min read

The Purchase vs GSTR-2B reconciliation process involves comparing the purchase data recorded in your books with the details available in GSTR-2B, a form provided by the GST system in that contains details of input tax credit (ITC) based on suppliers’ GSTR-1 and GSTR-5 filings

Here are the steps for performing a Purchase vs GSTR-2B reconciliation.

How to Access the Purchase vs GSTR-2B Reconciliation Feature:

Select “Purchase vs GSTR-2B reconciliation” from the Reports button on the My Company page.

Begin the reconciliation process:

On the reconciliation page, you will see two sections named GSTR-2B and Purchase Data.
Select the return period range from the top right month and year section fields.

After selecting the return period, click on the Reload button to view the selected range for reconciliation.

Download GSTR-2B data from the portal:

In the GSTR-2B section, click Download Data from GSTN option to fetch the data of suppliers from the GST portal.
Fill required GSTN credentials to fetch data of GSTR-2B from the portal.

Upload Purchase Data:

In the Purchase Data section, You have to upload your Purchase Register data through Excel data.
Click the Upload Purchase Data button to upload your Purchase Data Excel file.

Continue to Data Overview:

Once all data is prepared, You can click on the Let’s Match button to Set an acceptable Difference value by adding a mismatch value.
Once set, You can click on the Continue to Overview option available in the pop-up to check the Matching summary page.

Matching Summary page:

Here on the Matching summary page, you can select Type of Document from the top left dropdown menu.
Here you will see data filter boxes named All, Exact Match, Suggested Match, Mismatched, Missing in 2B and Missing in PR.
You can click the View Result in Details button at the end to see the detailed version of the data.

View Result in Details page:

Here you can select Table view as Supplier View or Document view. Let’s check Supplier View first.
- In this view, you will get data by using the supplier name list.
- Also, you can change the Document type and Summary type for filtering purposes.
- You can also download this report by clicking the Download Reports option located at the top right corner.

Let’s check Document View now.
- In this view, you will get data by using the Document number list.
- Also, you can select the Document type and Summary type for filtering purposes.
- Here you can change the status of a particular Document by selecting any available options:
  - Accept supplier value: This status means we have accepted the value from the Supplier.
  - Accept my value: This status means we have accepted our value rather than Supplier.
  - Pending: This status means this Document is pending to be filed from the Supplier.
  - Remove Pending: This option is used to remove a Document from pending status once supplier has filed it.
  - Add Remark: You can add any remark in a particular Document for future reference.
- You can also download this report by clicking the Download Reports option located at the top right corner.