Excel utility for GSTR-2A Reconciliation and Reconciliation’s importance in GST.
Today reconciliation has become the most Important task to file accurate returns and later to compile GSTR 9 and GSTR 9C
There are Five types of reconciliation expected of us for the most accurate filing of GSTR 9 and 9C
1. GSTR 3B with books
it’ll provide differences in Output and Input which has to be reversed in future GSTR 3B with can be made using reconciliation sheet
2. GSTR 3B with GSTR 1
Now GST portal is Giving details of such differences some of such differences may be compensating differences due to errors in 3B
3. GSTR 1 with books
If Differences are observed here then we have to find out exactly in which invoice the difference occurred and amend the same in Further months Gstr 1 thus Requiring an Invoice wise reconciliation
4. GSTR 3B with GSTR 2A
Nowadays many clients are receiving notices for claiming Inputs higher in 3B than what is represented in GSTR 2A thus it’s prudent to make such reconciliation
5. GSTR 2A with books
This is the most humongous task as it requires Invoice wise reconciliation of all invoices and it’s difficult as the ERP doesn’t match all the invoices due to mistakes in the invoice number thus we need a probable matching excel sheet and gives differences about Invoices not available in Portal or Books or Differences in Values etc Thus providing an excel below.
In the end, each of reconciliation has to be reported in GSTR 9 or 9C Wheather in DRC 03 or 8C or Part v of GSTR 9 etc
Thus making a self-assessment rather than an Authority induced assessment of Returns and New Returns are making mandatory for such reconciliation.
Excel utility for GSTR-2A Reconciliation format
please send all format in this mail id
While reconcil, there was a message as There is already data here, Do you want replace it?,
I put yes, after that there was in Run time error 1004,
Pivot table field name is not valid,
Sir
How to rectify the error
Sir very good utility work good previously but from last one day an error message “run time error-2147417846 (80010108) method ‘paste of object’_worksheet failed appear on screen and utility end kindly suggest
Thank you very much for sharing this template.
really helpful and saved lot of time
Sir, please tell me where i have to put debit note and credit note details.
Great Efforts. Really nice utility.
Pls add Active Row highlight feature to reconciliation sheet
it will be more effective and easy to see or use
Thanks of the Excel utility
Problem are i am reconciled our data and show are Invoice not available on Govt Portal
This is a much-needed tool. However, with excel we faced certain limitations.
Invoice number/ GSTIN mismatches where not reconciled. Also excel has failed to perform where the volume of data was large.
We have recently engaged with Firmway. Their GSTR 2A Reco software has provide excellent results. You can reach them at 9769599848.
Sir/Mam
Thank you very much for this excel utility for GSTR-2A Reconciliation.
excelent utility
i need your contact no to understand more
Hi All.,
Many GST Taxpayers Struggling (While Filing GST Annual Return -GSTR 9) to GST Inputs Reconciliation GSTR 2A. Here Introduce GSTR 2A Reconciliation Excel format for Simplifying the Reconciliation of GSTR2 A Data(Online Generated) with Your GST input Data.
Just Copy & pasting Data’s From GSTR 2A (Online Imported data) and Your GSTR (Input) Workings in this Excel Sheet and you file GET the Following Results,
1. GSTR Not Filed Tax Payers (With GST Value)
2. GSTR Filed by Suppliers but We not Taken Input
3. GSTR Filed by Suppliers With Shortage of GST(For Instance, 11 Months GST Filed but not Filed 1 Month, Invoice Value Rs. 10,000 But return Filed as Rs. 1,000, Etc.,)
4. GSTR Filed By Suppliers With Excess (For Instance, if We have lost any Input invoice for not taken input credit – Supplier A Issued 3 Nos(Inv No. 1,2,3) invoices for Apr 17 but we have taken input only 2(Inv No. 1,2) Nos of invoice)
5. Overall The summary sheet explains the difference between Your GST Input taken(Workings) & GSTR 2A Online Data for Take steps to Rectification.
Would you like to get This GSTR2-A Reconciliation (Free of cost) Excel format, Kindly send a mail to Below Mail ID
madhan300493@gmail.com
Thank You.,
Hi.,
Many GST Taxpayers Struggling (While Filing GST Annual Return -GSTR 9) to GST Inputs Reconciliation GSTR 2A. Here Introduce GSTR 2A Reconciliation Excel format for Simplifying the Reconciliation of GSTR2 A Data(Online Generated) with Your GST input Data.
Just Copy & pasting Data’s From GSTR 2A (Online Imported data) and Your GSTR (Input) Workings in this Excel Sheet and you file GET the Following Results,
1. GSTR Not Filed Tax Payers (With GST Value)
2. GSTR Filed by Suppliers but We not Taken Input
3. GSTR Filed by Suppliers With Shortage of GST(For Instance, 11 Months GST Filed but not Filed 1 Month, Invoice Value Rs. 10,000 But return Filed as Rs. 1,000, Etc.,)
4. GSTR Filed By Suppliers With Excess (For Instance, if We have lost any Input invoice for not taken input credit – Supplier A Issued 3 Nos(Inv No. 1,2,3) invoices for Apr 17 but we have taken input only 2(Inv No. 1,2) Nos of invoice)
5. Overall The summary sheet explains the difference between Your GST Input taken(Workings) & GSTR 2A Online Data for Take steps to Rectification.
Would you like to get This GSTR2-A Reconciliation (Free of cost) Excel format, Kindly send a mail to Below Mail ID
madhan300493@gmail.com
Thank You.,
kindly share the utility VBA code password?????
Excellent excell ..
can you share how you created this excell with formulas it will more helpful
Excellent use of excel for this type of Reco.
Thank you very much for this wonderful utility
Thank you very much for this wonderful utility
how can we do easily reco for GSTR1
how can we do reco of GSTR 2
Excellent use of excel for this type of Reco.
Sincere thanks from my side Rajat.