In my previous article , I have mentioned a method to reconcile GST Input of Books with GSTR 2A. But there are some limitation of that method.

First of all I would like to discuss about previous method . In previous method the Data of 2A and Books has to keep in on sheet and that make Pivot and find mismatch.

Limitation of Previous method;

  • 2A and Tally Data are in separate so Invoice number are in different format in both sheet .
  • Each Invoice number has to make in same format

due to heavy data base it is difficult task to do the line item row wise.

New Method to reconcile the GSTR 2A and Tally without any modification;

We will discuss here, how we can reconcile 2A with Tally data and identified the difference on specific party.

kindly adopt below process flow …………..

  1. Download 2A
  2. Remove blank line and make in Format
  3. Reconcile the amount with shown in ITC details amount.
  4. Download Tally Data in same format as 2A downloaded.
  5. know we use PIVOT wizard on both sheet.
  6. press Alt +D
  7. select on sheet , give the name ,
  8. than select other sheet and give the name
  9. prepare GST wise report and Keep 2A and Tally data in Column
  10. make difference on each separate data .
  11. on monthly basis you will find data month wise , year wise and
  12. find the difference on specific GSTN.
  13. Take appropriate action to reduce the working

Author Bio

Qualification: Other
Company: DBRRM & ASSOCIATES (GST Practitioner)
Location: noida, Uttar Pradesh, IN
Member Since: 03 Jun 2019 | Total Posts: 4
My Self working as GST Practitioner under GST Law provision. I have 15 year of rich experience with big corporate. View Full Profile

My Published Posts

More Under Goods and Services Tax


  1. jay kumar tailor says:

    We Have A Customized Utility For Tally.
    Automatic/Manual of GSTR 2A using Json Files.Our Utility Able To Match Invoices By Removing Prefix And Suffixes in most Conditions.

Leave a Comment

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

Search Posts by Date

May 2021