Friends,
To submit GSTR9 , three reconciliations are required.
1. GSTR1 Sales Recon
2. GSTR3b ITC recon
3. GSTR2a ITC recon
Two recon out of above three , can be done with the help of below excel based utility. Users have to enter some data in white cell in GSTR3b recon after entry of books sheet and GSTR3b and GSTR2a recon will be automatically prepared. After that there is no need to prepare different reports for submission of GSTR9.
What is New in Release 2.14
1) Name of Gstr9 sheet has been changed to Gstr2A Recon
2) Gstr3B Recon sheet as per GSTR9 has been inserted. Only white cells are editable.
3) State Codes for GST have also been added
(in case any problem in use of the below utility, stakeholder can contact at 9896124627)