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 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).
If any Other Inputs you can contact me on Rajatsolanki1@yahoo.com