GSTR 3B Reconciliation

Tallysolutions
  1. GSTR 3B reconciliation – A study
  2. Why is GSTR 3B reconciliation required?
  3. System based GSTR 3B reconciliation
  4. Conclusion

GSTR 3B reconciliation – A study

Under Goods and Services tax Act we know one thing that each registered taxable person furnishes details of outward supplies made in a month in FORM GSTR - 1. Based on this, the details are auto-populated inward supplies FORM GSTR – 2A  and GSTR-2B. 

What promotes GSTR 3B reconciliation process:

  • Differences between the amount of credit shown in GSTR- 3B and the GSTR 2A/2B
  • Difference between GSTR-3B and GSTR-1
  • Reconcile the statement to avoid the wrong claim of ITC

Coming Soon

TallyPrime Release 5.0 with Connected GST Experience

Why is GSTR 3B reconciliation required?

  • To match with GSTR 2A/2B Data: Under Goods and Services Tax Act, the taxpayers will be able to claim ITC only if the invoice is present as a part of their GSTR 2A data or vendor data. Owing to this, taxpayers will now need to do a reconciliation wherever the ITC as per their data furnished for GSTR 3B on the GST portal for the corresponding month and GSTR 2A/2B data does not match.

  • To be prepared for Annual Return: GST returnsare filed monthly or quarterly basis. Finally, after the financial year gets over, annual returns must be filed before the 31st December of the subsequent financial year. This would need consolidation of the data reported over the financial year
    In order to ensure the correctness of the declaration made and to avoid duplications, the taxpayer must reconcile the data, then consolidate the values and make the declaration.

  • Data reconciliation of GSTR 3B and GSTR 1:While the reconciliation between GSTR-2A and GSTR-3B is to ensure that credits claimed by businesses only pertain to taxes actually paid by the suppliers, the reconciliation between GSTR - 1 and GSTR - 3B is to essentially verify payment of taxes for all outward supplies made.

  • To cope with the deadlines: As per CGST Act, the following actions must be taken at the earlier of the due date of the September, 2018 GST returns or Annual returns:

    • Claim eligible ITC against any invoice raised in FY 2017-18.

    • Any apportionment of ITC belonging to FY 2017-18, as eligible and ineligible not made earlier must be affected before the deadline.

    • Declare Credit Notes issued against any Invoices raised in FY 2017-18.

    • File Amendments to information reported in the GST Returns filed between July 2017 to March 2018.

    • Taxpayers who opted into Composition scheme or the vice versa current year 2018-19, may make amendments to the information reported in the GST returns filed in FY 2017-18 prior to conversion.

System based GSTR 3B reconciliation

In the technology-enabled GST Regime, the Government is already talking about applying data analytics to compare GSTR - 1 Sales returns and GSTR - 2A Purchase returns with data reported in GSTR - 3B Returns.

The system-based reconciliation can be done in the following manner:

Step 1

Download GSTR - 2A of the corresponding period on the common portal

Step 2

Open TallyPrime  -> Go to GSTR - 2 Report. Upload GSTR- 2A into TallyPrime

 

TallyPrime will show you the details of invoices which are either –

  • Fully Matched
  • Partially Matched: This may be due to partial match between invoices available in the books with invoices available on the GST portal.
  • Available only in Books: This can happen if your supplier has not uploaded some invoices.
  • Available only in Portal: This can happen if you have not recorded the transaction in your books but your supplier has uploaded the same.

Step 4

Take action against invoices which are mismatched, available only in books and available only in the portal by checking with the suppliers or correcting/recording respective purchase invoices in the books.

Step 3

Download and compare GSTR - 2A of previous periods with the books for all the GST returns filed for the previous periods to ensure that the Input Tax Credit has been claimed correctly and to identify mismatch if any of GSTR - 2A with GSTR - 3B.

Conclusion

Thereby, there is a dire need of a reconciliation or revision of GSTR - 3B mechanism whereby a taxpayer can reconcile and explain the differences in his GSTR - 1 and GSTR - 3B returns and pay the differential tax (if short paid) or claim the same as refund/ carry forward (if excess paid). And all this is possible with TallyPrime's latest version.

Coming Soon - TallyPrime Release 5.0

The upcoming TallyPrime Release 5.0 introduces a connected GST experience, enabling businesses to handle a wide range of GST activities directly within TallyPrime. From uploading invoices to filing returns and reconciling data, this new release streamlines the entire process. Here's a quick preview of the features you can expect from the new TallyPrime release:

  • Auto Download GST Data: Automatically download GSTR-2A/2B, GSTR-1, and GSTR-3B data for seamless reconciliation.
  • Connected Services for GST Invoices and Returns: Upload GST invoices and returns effortlessly via connected services.
  • Direct Filing and Signing of GSTR-1: File and sign the GSTR-1 return directly from TallyPrime, simplifying compliance.
  • Enhanced Outstanding Reports: Gain insights on ITC at-risk with improved outstanding reports.
  • GSTN Integration: Fetch, validate, and create ledgers using GSTN, ensuring accuracy and compliance.
  • Stripe-View in Reports: Analyze reports more easily with the new Stripe-View feature in all reports.
  • And Much More

Stay tuned for more updates on the upcoming TallyPrime Release 5.0!

left-icon
1

of

4
right-icon

India’s choice for business brilliance

TallyPrime is a complete business management software to manage your business easily, faster, and efficiently. Access to complete features, from billing to insightful reports.

Accounting and Billing | Inventory Management | Insightful Business reports | GST Returns and reconciliation | Connected e-invoice & e-way bill solution | Cash and Credit Management| Security and user management.

Get 7-days FREE Trial!

I have read and accepted the T&C
Submit