What is New in Release 2.12
1) In case any reverse entry in Books, Vch Type in Books Sheet can be Changed as "Reversed Entry", after that no need to Delete Extra Entries in Books Sheet
2) Blank Invoice Date in Books Sheet will be treated as UNMATCHED, earliter it was in B/f Last Year
3) To Refresh All & Save Worksheet, Macro has been created at Portal Stauts and Books Status
4) Option to type Name of Firm has also been added in Master Sheet which is also available in Portal Status and Books Status
5) Only 15 digits can be entered in the field of GST Number in B2B Sheet as well as in Books Sheet.
Release 2.11 features
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.
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.
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