GSTZen Force Match – GSTR 2A Reconciliation

 

Introducing GSTZen Force Match – Reconciliation made easier. GSTZen’s Intelligent Matcher will automatically compare your purchase invoices with GSTR 2A/2B data and match the invoices in your Books with Portal. Using Force Match, you now have the option to change the auto-match and manually match an invoice from books with the portal in the excel report.

How to Force Match an Invoice

  1. Download the Reconciliation report from GSTZen
  2. Choose the Books invoice you want to be matched with the Portal invoice
  3. Enter Row Number of the Portal invoice in the column AX

 

Example 1 – Books invoice does not have a portal invoice match

In cases where an invoice in your books has not matched with a portal invoice, you may manually choose a portal invoice and force match.

Download the Reconciliation Report from GSTZen

  • Choose the GSTIN and click on Reconcile Books vs Govt. Portal Data
  • Click on Reconcile Purchase Register vs GSTR 2A and choose the Financial Year

GSTR 2A reco

 

GSTR 2A reco report

Choose the Books invoice you want to be matched with the Portal invoice

  • In the reconciliation report, locate the invoice you want to force match. In this example, we are matching row 480 with row number 481

Before Force match

Enter Row Number of the Portal invoice in the column AX

  • On row number 480, scroll to column AX. Enter the force match portal invoice row number. In this example, enter 481

Force match row number

Once you enter the value, click on the GSTZen tab in excel and click on Upload.

Once the invoices are uploaded into GSTZen, you may download the reconciliation report again. You will now notice that the values of row 481 are moved to row 480.

After force match

 

Example 2 – Books invoice already matched to a portal invoice by GSTZen matcher

In cases where the books invoice has already matched with a portal invoice, you may choose to force match the book invoice with a different portal invoice. The existing auto-match will be unmatched in this scenario.

Download the Reconciliation Report from GSTZen

  • Choose the GSTIN and click on Reconcile Books vs Govt. Portal Data
  • Click on Reconcile Purchase Register vs GSTR 2A and choose the Financial Year

GSTR 2A reco

 

GSTR 2A reco report

Choose the Books invoice you want to be matched with the Portal invoice

  • In this example, I’m matching row number 15 with 20

Before Force match

Once you enter the value, click on the GSTZen tab in excel and click on Upload.

Once the invoices are uploaded into GSTZen, you may download the reconciliation report again. You will now notice that the values of row 20 are moved to row 15.

After force match

 

Note:

  1. Force match will be possible only if the invoice is present in the GSTZen purchase register
  2. Force match will only be successful if matched with a different invoice from the same supplier. If the portal invoice has a different supplier, the force match will be unsuccessful