GSTN launches GST ITC-04 Excel-based offline tool

Today GSTN has launched GST ITC-04 Excel-based offline tool to furnish details of  input/capital goods sent and received back from job worker:-

As per GST Rule 45 details of input or capital goods sent to job worker and received back from them need to be furnished on a quarterly basis in ITC-04, which can be download from GST portal.

Also Read- How to Fill GST ITC-04 using Offline Tool

What action should I take when I get the security warning while opening the excel file?

Ans: If you see the below security warning while opening the excel

The following action needs to be taken: On the Message Bar, click Enable Content. The excel file will open in trust mode.

There are some points still need to clarify from GSTN:-

1. Offline tool issued by GST council but still ITC-04 uploading option is not available on GST portal.
2. Filing of ITC-04 date due yet not confirmed.

When should a Manufacturer  fill GST ITC-04 form?

Manufacturer need to declare the details in ITC-04 in either or all the situations:

a) If the manufacturer is sending any goods(capital or input type) to a Job Worker (JW)

b) JW sends back the goods to the manufacturer

c) JW sends goods to another JW

d) JW sends goods out from his business premises to end customer.

This offline tool helps manufacturer to:

• Prepare ITC-04 when offline (i.e. without Internet).
• Upload bulk invoices/other details to GST portal.
• Edit the generated file using import

Following steps need to process:-

1. Enter data in (sheet 3&4) or import and edit existing JSON file (in Sheet 1)

2. Generate output in .JSON file format (Sheet 2)

3. Upload this output file (.JSON file format) into the GST portal (www.gst.gov.in) ( Return> ITC>Forms>ITC-04).

4. After successfully uploading, use the other button ‘Initiate filing’ to sign and file the statement using DSC or EVC as applicable.

There are  3 important worksheets in offline tool:-

Worksheet 1. Import_Export_file – Import and edit existing JSON file or Generate JSON file from the data entered in Sheet 3 & 4

Worksheet 2. Mfg_to_JW – Enter details of inputs/capital goods sent for job-work

Worksheet 3. JW_to_Mfg – Enter details of inputs/capital goods received back from job worker or enter details of inputs/capital goods sent out from job workers premises

Following Points need to note while filling the Excel Sheet:

1) While Opening the Excel sheet, if you see error message box like: “Compilation error in module due to incompatiblity with the verion, platform or architecture” (figure 1 below) please ignore this message and see if it works or not. In case it does not work, you need latest MS Office for successful export of your data.

Figure:-1

2) Please start writing data from ROW 7 and DO NOT SKIP any row. JSON creation won’t read any data after any row skipped. So please fill your challan detail in continues manner.

3) The row is valid only if there is any challan number. File generation will not read the details after the row where, there is no challan number in that row.

4) Please note, uploading the file generated from this tool will replace the data from previous upload of same quarter. For any modification in already uploaded file, please modify the desired invoices in the excel and upload the entire excel data again.

5) While Exporting or validating any sheet, if it says “There is an error in sheet” in first time validation, try validating again. If the error persists, then there must be some error in the sheet.

6) Error message box shown in figure 2 below can also be ignored.

Figure:2

7) Please make sure to Empty the sheets before importing any file.