GST RECON RELEASE 4.3

Friends,   

                   Now more automisation has been done,  Import of B2B portal  file downloaded from portal is able to upload through button. Duplicate or Double file can not be uploaded.  In case any amendment in B2B or CDNR is avaiable, utility will inform that the amendment data is available  for manual action. 

In master sheet,  GSTNo option is also available to protect wrong file upload. 

Download

GST GSTR2B RECON RELEASE 4.2

Friends,  GSTR2A / GSTR2B Recon has been updated with new rules.   Now a single menu has been generated for all Excel Sheets.  Specifically, GSTR3B sheet has been updated with Automatic Creation.  Now there is no need to remember data of Reclaim which was reversed in earlier month. 

Main features of this Utility is given below :-

• To define Month of Portal ITC Data, user have to Enter manully number of month in the last column of  Portal Data in B2B (Portal Data) sheet named GSTR2B (Portal Data) of Menu. 
• Sales Data Invoice wise will be entered and outward liablity will be captured in GSTR3B automatically. 
• RCM data invoice wise will be entered and outward liablity will be captured in GSTR3B automatically. 
• Exempted Sales data invoice wise will be entered and outward liablity will be captured in GSTR3B automatically. 
• Nil rated data invoice wise will be entered and outward liablity will be captured in GSTR3B automatically. 
• Carried forward or Reclaim ITC will be auto captured in GSTR3B on the basis of Portal Data and Books ITC.

Download

Contact at uniquesolutionrtk@gmail.com through email  for any query or its futher improvment. 

GSTR2B RECON RELEASE 4.1

Friends,  As everyone knows that the GST Department has updated GSTR3b for the Month Jan 2023.  Now amount of Debit or Credit Notes will be reflected in All Other ITC Column. Earlier it was shown in Others Column of ITC Reversed. 

           Keeping in view of the above, Excel Recon Release 4.1 in excel has been updated accordingly. Now data will be automatically shown in All Other ITC Column.  Screen shot of the screen as also given below :-

Download

GSTR2B RECON RELEASE 4

Friends,  New GSTR3B format has been added in the new Release 4. Lot of data will  be auto captured in GSTR3B.  Two  actions required manually for this. 

1. In last column of B2B (Portal) sheet , Number of Month will have to enter for the data related to the month. 

2. In the top of GSTR3B sheet , number of month will have to enter manually. 

Download Latest GSTR2B Recon Release 4 (Click Here) 24.01.2023

GSTR2B Recon Release 3 THROUGH EXCEL ,

Friends,    GSTR2b Recon Release 3 has been updated with major issues.  Now no need to press "Data Refresh All " etc with following updates. 

1. File size has been reduced to 86 Kb from 2398 Kb. 

2. VBA codes have been applied in  Excel Utility. 

3. Just copy and paste data of GSTR2b  alongwith  Books Data  Sheet. 

Download Excel Based GSTR2b Recon Release 3