You don’t have to enter the amounts here as this field is also linked to previous month’s payment of the reverse charge. Once it is paid in the current month, you will get the ITC of the same in the preceding month. ITC Reverse Charge of Previous Month: As we all know reverse charge has to be paid in cash. ITC from TRAN-1/TRAN-2: As you might have files TRAN-1/TRAN-2 form, you will be eligible for availing the ITC on the sale of previous stocks. They are linked to previous sheets Balance Carried forward cells for SGST, CGST, IGST and GST total. Previous Month Balance and ITC section consist of following subheadings:īalance Brought Forward: Here the cells take data from the previous sheet. Previous Month Balance and ITCĪs mentioned above the taxable value, SGST, CGST, IGST and GST total column are applicable to all the subheadings.

Header section consists of your Company name, address, logo, and GSTIN.

GST Payment and Balance Carried Forward.

It consists of column headings of SGST, SGST Thus, all such fields that are not applicable are marked with N/A. Reason for this difference is that in the first month you will not have prior data. There is a minor difference in the first file which is for the month of July 2017. This template consists of 6 files, one for each month from July 2017 to Dec 2017.Īll 6 sheets have similar columns and rows and headings. Contents of Monthly GST Input Output Tax Report Let us discuss the contents of the template in detail.

You can download GST templates like GST TRAN-1, GST Input Output Tax Report, and GST Export Invoice from here. Click here to Download All GST Excel Templates for ₹299. Once you download and fill the data in the above-mentioned template, you will have to download the new Monthly GST Input Output Tax Report.Ĭopy the data from individual sheet to this new template and paste it into respective columns.Ĭlick here Download Monthly GST Input Output Tax Report in Excel. You first need to download our previous template to maintain your single month GST computations. Previously we have created a template GST Input Output Tax Report for maintaining your GST sales, purchase, credit note, debit note and reverse charge etc of one month.

How to calculate gst in excel