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
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
22 September 2026
Account Assistant

Chirag P Shah & Co. Chartered Accountant

Pune

B.Com

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details