GST INPUT RECONCILIATION ON MONTHLY BASIS
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 ,
- then 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