The GSTR 3B Computation Sheet in excel format has been updated with latest Amendment in Section 49A of CGST Act, 2017 as amended by CGST (Amendment) Act, 2018 with effect from 1.02.2019. Section 49A  deals with Utilization of Input Tax Credit.

As per the amendment The input tax credit on account of central tax, State tax or Union territory tax shall be utilised towards payment of integrated tax, central tax, State tax or Union territory tax, as the case may be, only after the input tax credit available on account of integrated tax has first been utilised fully towards such payment. Thus, it is necessary to exhaust credit of IGST to pay IGST, before credit of Central tax, State tax or Union territory tax can be used to pay IGST. Explanation in Section 49 has been added providing that firstly credit of Central tax shall be used to pay IGST before credit of State/Union territory tax can be used.

GSTR 3B Computation Sheet in excel format contains following:

  1. Auto Setoff of GST Liability as per GST provisions
  2. Late fees Calculator
  3. Base data for GST Return Filling

You may provide your feedback at [email protected] or you may also visit our website

Access Denied! Only Regstered Users Can Download The File "GSTR 3B Computation Sheet in Excel as applicable from 01.02.2019". Register Here or Login

Author Bio

More Under Goods and Services Tax


  1. aabidhashmi says:

    GSTR 3B Computation Sheet
    Late fees calculation is wrong.
    Late fee can’t be more than Rs. 10000 (5K+5K). its showing more than 36K for Oct. 2017, having taxable bills.
    plz check

  2. GIDWANI SUNIL says:

    Respected Sir / Madam
    I want to know about the calculation of 20% as per Section 36(4) while filing GSTR 3B
    Kindly let me know about the above subject
    With Warm Regards

  3. snjy1991 says:

    Sir, your GSTR-3B-Computation-UPdated-Copy sheet is great but i found your sheet not add opening balance ( CGST and UT/SGST ) and not setoff my IGST liabilities.

    Please check mail dated 09.082019

    Actual my tax Liability as below:-

    IGST 7142.00 + RCM IGST 249.00

    CGST 0.00 + RCM CGST 530.00

    SGST 0.00 + RCM SGST 530.00

Leave a Comment

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

Search Posts by Date

March 2021