GSTR2B Recon Release 2.11
1 What is New in Release 2.11
1) Gstr9 Data sheet has also been prepared which is requied while filing annual GSTR9 if Unmatched data is not available in B2B or Books Sheet
2) Utility will inform Wrong GST Number in Books Sheet.
2 Action to Run this Utility
1) Download GSTR2B Release 2.11 Excel Based Utility from www.TdsTaxIndia.blogspot.com
2) Set Financial Year in Master Sheet.
3) Paste GSTR2B data in B2B Sheet and CDNR data will also be pased in B2B sheet in Minus values after download from Gst.gov.in
4) Paste Books Data in Books Sheet. In case tally user data can be exported from All Other ITC of GSTR3B
5) Portal Status and Books Status sheets are Ready for users.
6) B2B Data :-
a) In case ITC Availability Yes or Y data will be MATCHED OR UNMATCHED
b) ITC Availability Column can be changed as INELIGIBLE or ITC NOT CLAIMED with the help of Pull Down Menu manually.
3 Precautions :-
1) Don't try to edit,delete or Move in B2B or Books Sheet. Yellow Columns are already protected .
2) Portal Status and Books Status are available as MATCHED, UNMATCHED , B/f Last Year, C/f Next Year
3) B2B entry will also be converted as RCM, if Supply Attract Reverse Charge is Yes
4) Command to copy Data from Excel is Ctrl+Shift+End
5) Number of Enteries in Portal as well as in Books can be Checked from Master Sheet.
6) In case Data is not Correct in Portal Status or Books Status , Please follow :- Data Tab >Refresh All
7) Maximum 6000 entries can be pasted in B2B or in Books Sheets