Sunday, January 24, 2021

GSTR2B RECON Release 2.1

Friends,    After getting response through emails some minor changes have been done in the Excel Utility which are shared as under :-






GSTR2B Recon Release 2.1
1 Download GSTR2B Release 2.1 Excel Based Utility after email request at jain_heena1987@yahoo.co.in
2 Download GSTR2B data in Excel from Gst.gov.in website and paste all fileds in B2B sheet of Release 2.1 utility
3 Columns in yellow color are protected .
4 Portal Status and Books Status are available as MATCHED, UNMATCHED or B/f Last Year
5 Portal Status is also available as RCM, if Supply Attract Reverse Charge field in B2B is Yes 
6 B2B Data :-
                  In case ITC Availability Yes or Y data will be MATCHED OR UNMATCHED
                  User can change Data in ITC Availability as below:- INELIGIBLE, ITC NOT CLAIMED
7 Books Data can be pasted after Export Data in Excel  from All Other ITC of GSTR3B from Tally.
8 Command to Select Data from Excel is  Ctrl+Shift+End
9 Financial Year can be changed from Master Sheet
10 Number of Enteries of Portal as well as Books can be Checked from Master Sheet.
11 In case Data is not Correct in Portal Status or Books Status , Please follow :-  Data Tab >Refresh All

Intense Debate Comments