How to Export ITC-04 Data in Excel Format in SwilERP Software

Export ITC-04 Data in Excel Format

How to Export ITC-04 Data in Excel Format in SwilERP


What is ITC-04 under GST

Form GST ITC-04 is a declaration form to be furnished by registered persons (principals), showing the details of inputs or capital goods dispatched to or received from a job working in an applicable tax period. Form GST ITC-04 must be submitted by every quarter. It must include the details of challans in respect of the following-
  1. Goods dispatched to a job worker
  2. Received from a job worker or
  3. Sent from one job worker to another
Through SwilERP, users can easily export the excel file and upload it to an offline utility. You can find this option under the GST section in GST (Offline tool) forms. Do follow the below-given steps to learn the process.

First, start with login into SwilERP dashboard to initiate the process

  1. Go to the GST> GST Forms (For Offline Tool)> Export ITC-04 (Excel)
Reference image:

Export ITC 04SwilERP Dashboard Window

How to Export the Excel File

A new pop-up window will appear in the next slide. Follow the below-given steps to convert data into excel format:
  1. Select the Date Range "From" to "To" which data you want to convert into excel. (For example, you selected date range between the 1st of April to 30th of September)
  2. Press "OK" to continue.
Reference image:

Export the Excel FileExport ITC04 Window


  1. While clicking on ok, a new window will appear to choose the path.
  2. Select the file path where you want to save the Exported File.
  3. Enter the File Name & click on the Save button.
Reference image:

Save buttonFile Export Window

  1. After saving the file destination a Excel File will open in your system.
  2. In the Excel File, you'll see the details of Mfg_to JW and JW_to Mfg in the respective columns of excel sheet.
  3. You can check the details on the Excel sheet before uploading into Offline Utility.
Note: Now, users can easily import this excel file into the offline utility at their convenience.

      • Related Articles

      • Export GSTR-3B Data in Excel Layout

        What is the process of exporting GSTR 3B data into excel in SwilERP (RetailGraph) What is GSTR-3B? The GSTR-3B is a consolidated summary return of inward and outward suppliers that the government of India has introduced to relax the requirements for ...

      • Export GSTR9 Data In Excel File

        How to Export GSTR-9 Data in Excel File Through SwilERP Software What is GSTR 9? GSTR-9 is the annual return that all registered, taxable people must file. Businesses are required to file this return annually by 31st December of the coming financial ...

      • Export GSTR-2 Excel File

        How to Export GSTR2 Excel File Through SwilERP Software What is GSTR-2? The GSTR-2 is a monthly tax return showing the purchases you’ve made for that month. When you make purchases from registered vendors, the information from their sales returns ...

      • Export or Import Resources Data

        How to Export or Import Resources Data in SwilERP Basic Information An employee is someone who gets paid to work for a person or company. Workers don't need to work full-time to be considered employees. Similarly, the person who works for a business ...

      • Generate and Export Tran-2 Data in Excel

        How to Generate and Export Tran-2 Data in Excel in SwilERP What is Tran-2 Data? Form TRAN – 2 can be filed by a dealer/trader who has registered for GST but was unregistered under the old regime. Such a dealer who does not have a VAT or excise ...