Follow Us :

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.

Download Utility

Author Bio

I am Rajat Solanki and Currently Studying CA and I am working at MGIRT & Co. Bangalore View Full Profile

My Published Posts

Section 43B – Most Important or dangerous provision of Finance bill 2023 Unnecessary complication in MCA V3 Portal GSTR 3B Payment and Offset liability, Old Rule or New Rule? GSTR 3B Payment and Offset liability as per 49A W.e.f 1.2.2019 ,Effect working capital? Database & Authenciation issues & its dilemma to professionals View More Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

27 Comments

  1. P Ramesh says:

    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

  2. munish kumar says:

    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

  3. Riya Chetwani says:

    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.

  4. madhan.krishnan says:

    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.,

  5. MADHAN KRISHNAN says:

    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.,

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Post by Date
March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031