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:
- Auto Setoff of GST Liability as per GST provisions
- Late fees Calculator
- Base data for GST Return Filling
You may provide your feedback at camayur2@gmail.com or you may also visit our website www.camtc.in
Author Bio
Sir i want to send a computation sheet …
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
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
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
download is not working, ”