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 …………..
- Download 2A
- Remove blank line and make in Format
- Reconcile the amount with shown in ITC details amount.
- Download Tally Data in same format as 2A downloaded.
- know we use PIVOT wizard on both sheet.
- press Alt +D
- select on sheet , give the name ,
- than select other sheet and give the name
- prepare GST wise report and Keep 2A and Tally data in Column
- make difference on each separate data .
- on monthly basis you will find data month wise , year wise and
- find the difference on specific GSTN.
- Take appropriate action to reduce the working