What?

GSTR-2A vs Purchase Books reconciliation primarily involves matching the data uploaded by the suppliers in their GSTR-1, reflected in recipient’s GSTR-2A with those of the recipient’s purchase data.

Why?

It is very important to reconcile GST returns data because :

a. Under GST returns, the taxpayers will only be able to claim ITC if the particular invoice is present in the GSTR-2A or supplier’s data. This requirement forces the businesses to reconcile and claim ITC correctly.

b. Sometimes, it happens that vendor has declared his GST liability and credit has not been availed by the purchaser in his GST returns. So, not to lose the claim of ITC, the data should be reconciled on a regular basis. This reconciliation process will ensure no ITC loss on any invoices.

c. To avoid any duplication, taxpayers must consolidate and reconcile the values. This will ensure correct declaration and maximise the credit of input taxes.

 GST Health Check

Downloading and Arrangement of GSTR-2A

  • Downloading GSTR 2A – of each month can take up a lot of time, usually it takes 20 minutes to download file for one month.
  • Arranging Files – Once downloaded, arranging these files one below the other and eliminating blank rows and rows containing totals requires a huge processing power.
  • Maintaining Numerical Accuracy – While arranging the files and combining them, maintaining totals can be a challenge. Missing one row can make all the invested time useless. These manual errors are inevitable when dealing in volumes.
  • Converting books in same format as GSTR-2A – Before we look into this topic, it is important to understand how to identify a unique line in GSTR- 2A.
  • In GSTR-2A a unique line is formed by combination of GST NUMBER, INVOICE NUMBER and RATE.
  • Consolidate all the entries in books in the format where a unique entry is formed for a “GST NUMBER && INVOICE NUMBER && RATE”. It is possible that multiple entries of same rate be appearing for a single invoice number, those need to be consolidated before the mapping process begins.
  • Non-uniform Invoice numbers – Most of the times while passing entries in books, invoice numbers are not entered completely and this can cause a lot of problem as it becomes impossible to match with Vlookup.
  • For eg. Invoice number appearing as GST0019 in GSTR-2A and 0019 in books won’t match.
  • Inherent limitation in GSTR 2A – GSTR-2A for any particular month may contain invoices from any previous month and monthly consolidation can be challenging as you would have to keep track of all the invoices that appeared in different months for proper reconciliation. Thus each GSTR-2A will affect each previous months reconciliation.
  • Mapping – Mapping can be done on 3 levels
  • Vlookup match – exact match of invoices
  • Probable match – matching invoices on approximate basis using advance logics (www.gsthealth.com)
  • Manual match – Manually editing invoices to match them

Taxable Value Summary

  • Party wise summary – making a party wise summary is essential to identify the parties who are responsible for this difference.
Party wise summary

Credit of Financial year could be taken upto 30.9.2018 but government has extended the due date to 30.3.2019.

A lot of entities are unaware of requirement of such mapping, and many face problem in making and gaining control over such reconciliations.

You can make and maintain these reconciliations in minutes with www.gsthealth.com.

One of the best product for performing independent reconciliation

Further 12 different kind of classification can be done for invoices:

1) Invoice appearing in books, not in GSTR-2A — (Having tax amount)

2) Invoice appearing in books, not in GSTR-2A- (Not having tax amount)

3) Invoice appearing in GSTR-2A, not in books- (Having IGST)

4) Invoice appearing in GSTR-2A, not in books- (Having Other GST)

5) Common invoice, Category match, Taxable value mismatch, tax mismatch

6) Common invoice, Tax match, Taxable value mismatch, Category mismatch

7) Common invoice, Category mismatch, Taxable value mismatch, tax mismatch

8) Common Invoice, Category Match, Taxable value mismatch, tax match

9) Common Invoice, Tax mismatch, Taxable value match, Category match

10) Common Invoice, Taxable value match, Tax match, Category mismatch

11) Common Invoice, Category Match, Taxable value match, tax match

12) Anomalies

Contact for more info admin@firmsap.com

Author Bio

Qualification: CA in Job / Business
Company: Firmsap Ventures Private Limited
Location: Delhi, New Delhi, IN
Member Since: 21 Jun 2017 | Total Posts: 3

My Published Posts

More Under Goods and Services Tax

2 Comments

  1. g m devendran says:

    audit how rectify and how to uploaded invoices and also some suppliers wrong GST IN WRONG GST IN ENTERED AT THAT RECEIVER ENTERED AND WITH TALLY ERP 9 MIGRATE THRO JSON FILE AFTER REPORT ERROR AGAIN WE MODIFY BUT WITH SHORT TIME SUPPLIERS NOT PROPERLY UPLOADED HOW ACCEPT PLEASE GIVE SOME ANOTHER TIME

  2. vswami says:

    OFFHAND

    Such Issues , as is readily imagined, might be far more grave and insurrmountable, with no scope for ready reconciliation or in the short run of 2or vore years. ; particularly so, in the case of Realtors . Pehaps, that seems to provide some clues as to why they are mostly unable to comply with the expected one-to-one matching. And in the result, the benefit of IPC is, so far as known, not pbeing passed on to the comminity of Buyers in almost every ‘ongoing’ building complexes – thai is, ‘under constriction propoerties ‘ ; regardless of whether or not coming within the mandatory requirements under the RERA Code.
    Over to the author of the write-up, or any other professional in practice for enlightenment.

    May have MORE to ADD !

Leave a Comment

Your email address will not be published. Required fields are marked *