Friends , Every time man feels that there is no futher need for updates. But after use the same new ideas or requirments arise for better result.
As per requirements , some major changes has been done in Excel Based Utility which is available free of cost. Simply copy portal and books data and paste in respective Excel Sheets in utility. Books status and Portal Status will be automatically prepared alongwith 8 number Table of GSTR9.
What is New in Release 2.13
1) Monthwise Totals of Books are available in GSTR9 sheet
2) Auto Filter, Format Cells and Format Columns are enabled in Books and (B2B)Portal Sheet
3) Auto "B/f Last Year" option is enbled in B2B (Portal) sheet as the same entries are available in sytem 2B sheet.
4) In "GSTR9 Data" Sheet, RCM data has been removed from Data as per Portal GSTR9 for 8A Column
5) "ITC Reversed in Next Year " option is enbled in Books Sheet
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.
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.
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