In this article, we shall understand “HOW TO FILE TRANS-1 USING OFFLINE UTILITY”. To facilitate the furnishing of records in short-time, an easy to use TRAN-1 Offline Tool has been made available for the preparation of TRAN-1 in download section of GST portal. All the details can be added in offline mode and later uploaded on GST portal to furnish the TRAN-1. The period for submitting the declaration in FORM GST TRAN-1 has been extended till 27th December 2017 vide ORDER NO.9/CGST dated 15th November 2017 and the period for revising the declaration in FORM GST TRAN-1 has also been extended till 27th December 2017 vide ORDER NO.10/CGST dated 15th November 2017. So 27th December 2017 is not far now and in order to claim the transitional benefit, filing of TRANS-1 becomes of utmost importance.
Step by Step guide to FILE TRAN-1 USING OFFLINE UTILITY is given below:
- Download the latest version of TRAN-1 Offline Tool from the GST portal.
- TRAN-1 Offline Tool has 6 downloadable templates. Details can be uploaded using the Excel and CSV Template.
- So, Let us take an example where we need to upload the data using the Tran-1 5(b) Statutory Form CSV template.
- Launch the Tran-1 5(b) Statutory Form CSV template and navigate to Excel worksheet.
- Enter the details in the excel sheet under respective columns.
- After entering the details, click the SAVE button
- Access the https://gst.gov.in/ URL. The GST Home page is displayed.
- Click on the Services > Returns > Transition Forms command.
- Click the 5(a), 5(b), 5(c) - Amount of tax credit carried forward tile.
- Click the Statutory Forms Tab.
- Browse and navigate the CSV file to be uploaded from the computer. Click the Open button.
- A success message is displayed. The uploaded CSV file would be validated and processed. In case of validation failure upon processing; errors if any would be shown on the GST Portal.
Similarly, we can upload data for
- Tran-1 9(a) Details of Goods - Sent as Principal CSV template and
- Tran-1 9(b) Details of Goods - Held in Stock CSV template.
Let us take an example where we need to upload the data using the Tran-1 6(a) Capital Goods - Central Tax EXCEL template.
- Launch the Tran-1 6(a) Capital Goods - Central Tax EXCEL template and navigate to worksheet.
- Navigate to worksheet GST_TRANS1_6a.
- In the GSTIN field, enter the GSTIN.
- Enter the details in the respective columns in the excel tool.
- Once all details are entered, click the Validate & Calculate Sheet button to validate the worksheet. (Total Unavailed Credit = Total Available Credit - Total Availed Credit) is calculated on click of 'Validate & Calculate' Button and the value should not be less than zero and greater than the calculated value.
- In case of successful validation: A message is displayed with count of records to be added and deleted in GST Portal. Click the OK button.
- In case of unsuccessful validation: Errors are shown in the Error Column. Once all errors are rectified, click the Validate & Calculate Sheet button to validate the worksheet.
- Click the Generate File to Upload button to generate JSON for upload on GST Portal.
- Navigate to the folder where we want to save the JSON file. Enter the file name and click the SAVE button.
- A confirmation message is displayed that JSON file is created. Click the OK button.
- Access the https://gst.gov.in/ URL. The GST Home page is displayed.
- Click the Services > Returns > Transition Forms command.
- Click 6(a), 6(b) - Details of capitals goods for which unavailed credit has not been carried forward tile.
- Click the Central Tax Tab
- Click the Choose File button.
- Browse and navigate the JSON file to be uploaded from the computer. Click the Open button.
- The uploaded CSV file would be validated and processed. In case of validation failure upon processing; errors if any can be downloaded from the GST Portal.
- The error is shown after downloading the error file. Rectify the errors in the JSON file and upload again on the GST Portal.
Similarly, we can upload data for
- Tran-1 6(b) Capital Goods - State/UT Tax EXCEL template and
- Tran-1 7(b) Details of the inputs held in stock - Eligible Duties and taxes/VAT/[ET] EXCEL template.
How useful was this post?
Click on a star to rate it!
Average rating 4.47 / 5. Vote count: 155