Tally Accounting
Posted by Asok K Nadhani on

GST Inward Invoice Reconciliation for Regular Dealer in Tally

GSTR-2A Report

GSTR-2A is an auto-populated statement viewed by Recipient, showing all the inward supplies reported by counterpart supplier in their GSTR-1 (and also in GSTR-5, GSTR-7& GSTR-8).

The details may be directly viewed in the GST Portal, or GSTR-2A downloaded and viewed in the offline utility tool. Invoices / records up to 500 can be viewed online for a table / section in Form GSTR-2A. In case, if invoices are more than 500, generate the GSTR-2A file and use the offline utility tool (GST Portal > Services > Return > Prepare Offline > Download Tab > Generate File) available on the portal for viewing the invoice details.

GSTR-2 Report

GSTR-2 is a statement in which a regular dealer needs to capture all the inward supplies made during the month. Broadly, all the inward supplies from registered businesses (B2B), including the supplies on which tax needs to be paid on reverse charge are required to be captured at the invoice level. In addition to inward supplies, you also need to declare the details of advances paid on supplies liable for reverse charge, and the advance amount on which tax was paid in the earlier return period but the invoice has been received in the current reporting period. The last date to submit the GSTR-2 for the month of July 2017 is 31st October, 2017.

Based on the details submitted in GSTR-2, the eligible ITC will be determined and accordingly it will be credited to your e-credit ledger on a provisional basis.

GSTR2 vis-à-vis GSTR2A Comparison

There is no need to enter all inward invoices details in GSTR-2. Most of the details in GSTR-2 is auto-populated, based on the outward supplies declared by counter party suppliers in their returns. The auto-populated details of inward supplies shown in GSTR-2A, are also shown in GSTR-2. In other words, GSTR-2A will be an exact replica of GSTR-2 containing only the details declared by your counter party suppliers in their GSTR-1.

Therefore, you need to reconcile the details of inward supplies available in GSTR-2A, with your books of accounts and accordingly figure out the additions, modifications and deletion of invoices shown in GSTR-2A.

The form GSTR-2A is just a read-onlydocument. Therefore, any action on inward supplies shown in GSTR-2A, is to be done in GSTR-2 only.

So, any omission or correction not actioned as per the statement in GSTR-2A with inward supplies register (in the books), will impact input tax credit eligibility, as reflected in GSTR-3B.

Identifying Mismatch in GSTR-2 / GSTR-2A reports

  • Download JSON form Portal : Download GSTR-2A JSON file of the required tax period from the GST portal .
  • Load JSON File into Tally for Comparison : GoT> Display > Statutory Reports > GST > GSTR-2 .Select the period as per the GSTR-2A JSON file. At GSTR-2 report screen, click L : Load File button and load the GSTR-2A JSON file (for comparison only). Successful File Loading message appears. Type No (not to update as you have loaded only for Comparison)

JSON file Loading for comparison of GSTR2 & GSTR2A

Compare Data : Now compare the data recorded in your Book (in Tally) and uploaded in GST Portal

  • Records in Blue show details as per the downloaded GSTR-2A JSON file. This includes the details of invoices submitted by the supplier, and the invoices that you have manually uploaded on the portal.
  • Records in Black show details of invoices As per Books.

Click A:View Statuswise button to show the records according to Status of the Invoice. It shows records classified as:

  • Fully Matched : Invoices recorded in Books (in Tally) match with the records in Portal. No action is needed
  • Partially Matched: Some info not matched between invoices available in the books with invoices available on the GST portal.
  • Available only in Books: Inward Invoices recorded in books (Tally) by you, but supplier has not uploaded the invoices.
  • Available only in Portal: If you have not recorded the transaction in your books but your supplier has uploaded the same

Resolving Mismatch records of GSTR2 & GSTR-2A in Tally

Drill down through Partially Matched item in the report (Click F1:Detailed) to list the Invoices and note down the differences. If any amendment done by the counterparty in GSTR-1, it is also reflected in your GSTR-2A. These invoices may not be available in your books. Check your book information across return periods for further action.

Similarly, Drill down through Available in Portal item. Based on the differences observed, you or your counterparty should record appropriate entries in the current return period, to correct the books.

To avoid mismatches in input tax credit as per books and GSTR-2A, you may download and compare GSTR-2A to match the details of input tax credit for the previous and upcoming return periods. This helps to ensure correctness of input tax credit claimed.

Mismatch between GSTR-3B & GSTR-2A

Consolidated value of inward supplies are filed in GSTR-3B returns. The suppliers have uploaded their sales invoices in GSTR-1, based on which counter party inward supplies get auto populated in GSTR-2A.

Any difference in values between inwards supply details (furnished in GSTR-3B) and outwards supply details uploaded by respective counter party suppliers (available on GST portal as GSTR-2A) may lead to loss in the claimed Input Tax Credit (ITC).

Possible Reasons of Mismatch

  • Supplier has not uploaded the invoices for which you have already claimed Input Tax Credit.
  • Values in the supplier’s invoices are not matching with values available in your books.
  • You might have missed out recording any Purchases or Debit Notes (Purchase Returns) which resulting reduced Input Tax Credit.

Resolving Mismatch between GSTR-3B & GSTR-2A in Tally

  • Compare purchases recorded in books (in Tally) with GSTR-2A (available on GST Portal) of the respective return period and identify the mismatch invoices.
  • Having identified mismatch / missing invoices, contact the respective supplier asking him to either upload the related invoice in his latest return which is yet to be filed, or amend the invoice details at the time of filing his returns.
  • On the other hand, you check the physical copies of respective purchase invoices and correct your purchase data (in Tally), and accordingly make corrections in your latest GST returns which are yet to be filed (you may need to reverse ITC)

View PDF