Matching gstr2 a data with your input availed data is simplified (for gstr 9)

 

Hi All,

GST Taxpayers Struggling to match GSTR 2A Online Generated data with Their Input Availed data. While Reconciliation of these data's Mismatch arrives due to following factors,  

* Which Supplier is filed GSTR 1 Correctly?

* Which tax payer not filed GSTR 1 for Concerned month or Year?

* A  Supplier GSTR 1 Filed With shortage of Input. (For Instance, GST Invoice Issued GST Value Rs. 10000, But GST Filed as Rs. 1000) So, we have Input Shortage of Rs. 9000/- )

* A Supplier is Filed GSTR 1 but we have not Availed Input. (for Instance, We lost to file a GST Input Invoice GST Value Rs. 10000)

* GSTR 1 Not Submitted Suppliers. In GSTR 9 Auto Populate Input Data from GSTR2 A. They clearly said, Not Submitted Status of Suppliers Inputs is Not populated in GSTR 9. So, need to find the Not Submitted Suppliers.

 

** The main thing is we should remember, every time GSTR 2 A changed based on Suppliers GSTR2 A Filing. 

Here I introduce GSTR 2A Advanced Excel Format (Free of Cost) for GSTR2 A Online data with your GST Input availed data. Above said Questionnairy, this Excel Utility full filled with Fraction of Seconds.

Please Click below to download the GSTR2 A Reconciliation Advanced Excel Utility.

https://drive.google.com/…/10I91BoSVkpwfWf1CZjThLQT8g3rIRPE- 

Thank You.,

 

 

Replies (1)
This Excel tool is very useful. Thanks.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details