Add to Favourites

Reconcile GSTR-2A Data in TallyPrime

GSTR-2A is a reconciliation report automatically generated based on the supplier’s GSTR-1 data available on the portal. It helps you compare the purchase details available on the portal with the transactions recorded in your books. In TallyPrime, you can directly download or manually import GSTR-2A data from the portal and reconcile it with your books.

Directly Download GSTR-2A Data from Portal into TallyPrime

1. Press Alt+Z (Exchange) > All GST Options > Download GST Returns.
   The Download GST Returns screen displays all return types selected by default.
   For TallyPrime 4.1 or earlier, press Alt+Z (Exchange) > Download GST Returns.
   
   You can also set default return types and GST registrations for download.
2. Press C (Configure).
   
3. Set Return Type as GSTR-2A and set the Return Period.
4. Press D (Download).
   
5. If not already logged in, enter your GST Username and the OTP received on your registered mobile number.
   
   The session will be valid for six hours, which will ensure the safety and security of your activities.

Once the download is complete, the GSTR-2A data will be available in the GSTR-2A Reconciliation report.

You can also redownload any previously downloaded returns. The latest download will replace the existing versions.

Manually Import GSTR-2A Data into TallyPrime

1. Press Alt+O (Import) > GST Returns.
2. On the Import GST Returns screen,
   1. GST Registration: It will be selected by default.
      In case of multiple GST registrations, select the required one.
   2. Return Type: Select GSTR-2A.
   3. File Path: Select the path where the downloaded GSTR-2A file from GST portal is located.
   4. File to Import: Select the GSTR-2B file to be imported.
      
3. Press Ctrl+A to accept. 
   The Import Summary screen displays the number of transactions processed, imported, and failed.
   
   The imported data is reflected in the Reconciled and Unreconciled sections of the report.
   

Reconcile GSTR-2A

Open the GSTR-2A Reconciliation report to view your transactions categorised by reconciliation status. You can also view and reconcile transactions under Potential Matches, where the Taxable Amount and Tax Amount match, but one detail, such as the Section, GSTIN, or Document Number, differs.

• Press Alt+G (Go To) > type and select GSTR-2A Reconciliation.

All the pending activities will be highlighted in amber colour, while the values from the portal will be presented in blue colour for easy identification.

You can drill down from any of the above sections for a more detailed view of the status of reconciliation for your transactions.

You can further drill down from a party and reconcile the transactions for that particular party.

Step 1: Configure your GTSR-2A as needed before Reconciliation

• If you have multiple GST registrations, the report shows consolidated data for all registrations by default. Press F3 (Company/Tax Registration) > select the required company or registration.
• Press Ctrl+B (Basis of Values) > and set the option Show report details based on as required, to view transactions based on the reconciliation status.
  
• Press Ctrl+H (Change View) to view the report as per the Reconciliation Statistics or Voucher Statistics view.
• To view the potential matches in the GSTR-2A Reconciliation report, press F12 (Configure) > enable Show potential matches between Books and Portal.

Step 2: Drill down from any of the Unreconciled party

You can view transactions as per the following categories:

• Mismatched
• Mismatch in Return Period
• Available only on Portal

Step 3: Reconcile transactions

Reconcile Mismatched transactions

This section displays transactions where GST details such as Tax Amount or voucher number differ between your books and the portal.

1. Drill down from the Mismatched section to view the transactions.
2. Press F12 (Configure) to enable additional columns such as Invoice Type or Reverse Charge, if needed.
3. For minor differences such as rounding off, press Alt+S (Set GST Status) > set status as Reconciled.
   You can also review the differences and update your books manually, if required.
   

The transaction will move to the Reconciled section.

Reconcile transactions with Mismatch in Return Period

1. Drill down from the Mismatch in Return Period section.
2. Select the transaction and press Alt+L (Set Effective Date).
3. Update the GST Return Effective Date to match your supplier’s return period.
   

The transaction will move to to the Reconciled section.

Reconcile transactions Available only on Portal

This section displays transactions present in your supplier’s GSTR-2A on the portal but not recorded in your books.

1. Drill down from the Available Only on Portal section.
2. Select the transaction and press Alt+R (GST Portal View) to view the full details.
   
3. Note the necessary invoice details and record the corresponding entry in your books using these details.

The transaction will move to to the Reconciled section.

Resolve Potential matches (Excluding Section)

This section displays transactions with matching detail, except the Section. For example, a transaction appearing as B2B in your books but as CDNR on the portal.

1. Under Potential matches (Excluding Section), drill down from the required transaction.
2. Press Alt+F10 (Other Vouchers) > select the correct voucher type, for example, Credit Note.
3. Enable Provide GST Details > enter the Reason for Issuing Note, Supplier’s Debit/Credit Note No., and Date.
4. Press Ctrl+A to save the voucher.

The transaction will move to the Reconciled section.

Resolve Potential matches (Excluding Party GSTIN/UIN)

This section displays transactions with matching details, except the party’s GSTIN/UIN. For example, a typing error where O is used instead of 0.

1. Under Potential matches (Excluding Party GSTIN/UIN), drill down from the required transaction.
2. Press Ctrl+Enter on the party name to open the party master.
3. Update the GSTIN/UIN in the Party Details of the transaction.
4. Press Ctrl+A to save the voucher.

The transaction will move to the Reconciled section.

Resolve Potential matches (Excluding Doc No.)

This section displays transactions with matching details, except the Doc No. or Vch No.. For example, MC/233 in your books versus MC/2333 on the portal.

1. Under Potential Matches (Excluding Doc No.), drill down from the required transaction.
2. Correct the voucher number to match the portal.
3. Press Ctrl+A to save the voucher.

The transaction will move to the Reconciled section.

Questions & Answers

Can I reconcile GSTR-2A data for multiple GST registrations at once?

Yes. The GSTR-2A Reconciliation report displays combined data for all GST registrations by default. So, you can reconcile the report together for all registrations at once.

Can I ignore minor differences in transactions between books and portal and reconcile?

Yes. For minor differences, such as rounding-off variations, you can set the GST status to Reconciled without altering the transaction details.

Why is a transaction appearing under Potential Matches instead of Reconciled?

A transaction appears under Potential Matches when most details match between your books and the GST portal, but there is a difference in a key field such as the Section, Party GSTIN/UIN, or Document Number.