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 [email protected]

Download Gstr 3B Auto-calculate offset liability ,Tax payable & Json File

Author Bio

Qualification: Student - CA/CS/CMA
Company: MGIRT & Co
Location: Bangalore, Karnataka, IN
Member Since: 05 Sep 2017 | Total Posts: 10
I am Rajat Solanki and Currently Studying CA and I am working at MGIRT & Co. Bangalore View Full Profile

My Published Posts

More Under Goods and Services Tax


  1. Nilesh H Gajjar says:

    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

  3. Venkata Krishna says:

    Excellent extension to the utility.

    This avoids confusion in the challan amount to be paid, especially when there are payables under RCM

  4. Siva Rongali says:

    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.

    1. Venkata Krishna says:

      As of my knowledge, only RCM which is payable on inward supply from unregistered person is suspended till March 31, 2018.

      But the RCM payable by the receiver according to the nature of service being received is not suspended and is continuing. e.g: Legal services etc.

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

January 2021