How to Generate and Export Tran-1 Data in Excel in SwilERP Software

Generate and Export Tran-1 Data in Excel

How to Generate and Export Tran-1 Data in Excel in SwilERP


What is Tran-1 data?

The GST TRAN 1 is a transition form for the already registered taxpayers in old schemes who are filing the GST TRAN -1 form for availing their previous input tax credit accumulated from earlier purchased stock before the implementation of the GST. Many registered entities are under GST in the current time period, which is stuffed with their old tax credits and benefits, which is a concerning part of the transition. There are various taxes paid in the previous tax scheme, ranging from raw materials, semi-furnished goods, or the items and materials given to the job working process.
 
In SwilERP, there is an option to generate and export the Tran-1 data to upload into GSTIN. In this, users have to do stock valuation first, and after completing stock valuation, they can generate Tran-1 data.

Now, login into SwilERP dashboard to initiate the process

Step 1: Create stock valuation entry.
  1. Go to the Queries> Stock Valuation> Stock Valuation Entry
Reference image:

Stock Valuation EntrySwilERP Dashboard WIndow

  1. After that, a window of Calculate Stock Value will appear in the next slide.
  2. Enter the Date Range in which you want to evaluate your stock.
  3. Select Actual in Basis of column.
  4. Select the Value By as Purchase Rate from the drop-down list.
  5. After that, click on the Create Data option.
  6. And, Save the window with the given option.

As shown in the below-given image:


Calculate Stock ValueCalculate Stock Value Window

How to Generate Tran-1 Data

Step 2: Generate Tran-1 Data.
  1. Go to the GST Section> Generate Tran-1 Data
Reference image:

Generate Tran 1 DataSwilERP Dashboard Window

  1. After that, a window of Generate Tran-1 Data will appear in the next slide.
  2. Here you can view option to select stock valuation Entry Number.
  3. Select the Entry Number in the column from the drop-down list.
  4. Press OK to continue.
As shown in the below-given image:

Entry NumberSelect Series Window

  1. After clicking on OK button, you will get a "Tran-1 Data Generated Successfully" message.
Reference image:

Tran 1 Data Generated SuccessfullySuccess Message Window

How to Export Tran-1 Data in Excel File

Step 3: Export Tran-1 Data in Excel file.
  1. Go to the GST Section> Export Tran-1(Excel)
Reference image:

Export Tran 1 Data in Excel fileSwilERP Dashboard Window

  1. After that, a window for selecting the File Path in your system will appear in the next slide.
  2. Select the path and enter the file name to Export Tran-1 Data in excel format.
  3. Then, click on the Save option.
As shown in the below-given image:

Save optionExported File Window

  1. After saving this window, an excel file will automatically open in your system.
  2. There you'll see all details related to your stock in the format of Tran-1.
Reference image:

 format of Tran 1Excel File Wind


      • Related Articles

      • 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 ...
      • 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 ...
      • GST Summary Data

        How to view GST Summary Data in SwilERP (RetailGraph) What is GST summary data? GST stands for Goods and Services Tax. It is an Indirect tax that replaced a host of other Indirect taxes such as value-added tax, service tax, purchase tax, excise duty, ...
      • 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 ...
      • GST Summary Data

        How to View GST Summary Data in SwilERP Introduction of GST in SwilERP A GST Summary Data is an option in SwilERP, if users want to view their Sales and Purchase transaction data in summary then they can view it from the GST section. SwilERP also ...