This sheet is now been Validated to include Rounding off liabilities after Submitting the sheet to make Payment of Tax tab Easy
Now You can offset liabilities of 1,000 Crore as I’ve Increased the width of column
This sheet is been Integrated in GSTR 3B utility to save the hassle of learning how to use the Sheet and enter the details in the sheet.
GSTR 3B Auto-calculate 5.0 offset liability ,Tax payable & Json File
———————–
GSTR 3B Excel utility 4.0 Auto-calculate offset liability & Tax payable (24.11.2017)
This file have been added in the 3b excel offline utility which also will help in calculating how to off liability and calculate Payment in specific heads and help keep maintaining records only you have to fill the details in GSTR 3B and it’ll calculate the offset liability & payment details thus reducing the time for understanding how much to pay and how to offset liability easily.
This file can also directly create a json file thus directly Uploading the GSTR 3B in Gstn Portal only Offset liability has to be entered by the taxpayer for filing the return.
This file the RCM Payable is taken from 3.1 Details of outward Supply and Rcm and RCM Input is taken from 4. Eligible itc ,So Please Enter carefully
You Can double click on green cells and check the references used (Yes I Know have ignored the ITC of Rcm in Green field but its included in Eg. D123 field and is hidden and you can cross verify weather Itc of rcm is taken by checking the totals of D132(inputs used) and D133(Inputs Carry forward).
Download GSTR 3B Excel utility 4.0
If any Other Inputs you can contact me on Rajatsolanki1@yahoo.com
Author Bio
HI Rajat
Did you prepare NEW ITC SET-OFF Calculator w.e.f. 01/02/2019 U/s. 49(A) than Pl share here so it will be helpful to All Professional
Offset the CGST tax Liability before cross utilization of CGST Credit against IGST liability aapne calculator sheet me calculation offset perfect dikha raha hai but gst portal me ye error aa rahi hai
Great yar, Rajat ji,
your work in GSTR3B is more appreciable.
keep it
RCM of rule 9(4) CGST suspended, RCM rule 9(3) will continue(earlier in ST laws)
Excellent extension to the utility.
This avoids confusion in the challan amount to be paid, especially when there are payables under RCM
Very nice article
I have a small query…as of my knowledge RCM is suspended till 31march 2018…irrespective of turnover
of the business…is it correct or not ?
If there is any mistake plz correct me and suggest me.
Thank you.