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

Download Gstr 3B Excel utility 4.0 Auto-calculate offset liability & Tax payable

Author Bio

Qualification: Student - CA/CS/CMA
Company: N/A
Location: Bangalore, Karnataka, IN
Member Since: 05 Sep 2017 | Total Posts: 3

My Published Posts

More Under Goods and Services Tax

Posted Under

Category : Goods and Services Tax (5326)
Type : Downloads (250)
Tags : Calculator (85) goods and services tax (3873) GST (3465)

5 responses to “Gstr 3B Excel utility 4.0 Auto-calculate offset liability & Tax payable”

  1. Satya says:

    Great yar, Rajat ji,
    your work in GSTR3B is more appreciable.
    keep it

  2. Satya says:

    RCM of rule 9(4) CGST suspended, RCM rule 9(3) will continue(earlier in ST laws)

  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.

    • 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 Reply

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