gst2a reconciliation in excel


GSTR 2A RECONCILIATION is excel based utility to reconcile GSTR-2A with books of account and calculate ineligible itc as per rule-36(4).

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.

GSTR 2A with books reconciliation 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 utility and gives differences about Invoices not available in Portal or Books or Differences in Values etc Thus providing below.

2. How to Use?

Download from below mention link.You can download all month GSTR-2A using Taxes India Download Assistant.

You can also use Merge All GSTR-2A utility to get annual reconciliation or you can use month wise. For getting rule-36(4) calculation you have to reconcile month to month and same thing have to do with books and GSTR-2A. With brief details a youtube video mentioned below for reference.

Always remember to run file as administrator and check any firewall and antivirus not blocking the file. When you open file first time it will ask for activation code. For getting activation code you have to provide computer code on GSTR-2A Reconciliation’s license is valid for one year and does not re-provide activation code in any circumstances. Excel compatible version is 2010 or later. You will get activation code within 24 hours after providing computer code.

Get reliable, authentic and latest updates on taxation and other laws
in your inbox free.

Please check your inbox,spam or junk folder for confirmation

Something went wrong.


Please enter your comment!
Please enter your name here