• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download GST TRAN-1 Return Excel Template

Download GST TRAN-1 Return Excel Template

GST TRAN-1 form is used to claim the credit of input of taxes (VAT, Excise, etc) paid under the pre-GST regime issued by the Central Board of Excise and Customs.

We all are concerned about the input credit of taxes that we have paid while purchasing, inputs, raw materials, semi-finished goods, etc under the old regime. These taxes are available as an input credit on 30th July.

CBEC has released 2 transition forms GST TRAN-1 and GST TRAN-2, to help businesses carry forward their input tax credit.

We have created an Excel Template for the GST TRAN-1 form to simplify the filing of this return. This form is filled online on GSTN Portal.

GST TRAN-1

Click Here to Download GST TRAN-1 Return Excel Template

Click here to Download All GST Excel Templates for ₹299.

You can also download other GST templates like GST Bill of Supply, GST Payment Voucher, and GST Export Invoice from here.

Let us discuss the contents of this template in detail.

Contents of GST TRAN-1 Excel Template

This form GST TRAN-1 consists of a total of 12 points which are explained below:

1. GSTIN: Your GSTIN number. It is auto-populated.

2. Legal Name of Registered Person: Your registered legal name in full. Auto populated.

3. Trade Name: Name of your company if you are using any Trade Name.

4. Confirm that you have submitted ALL the returns required under existing law for the past 6 months: Here you need to select Yes or No from the drop-down.

Closing Balance of CENVAT or VAT can be taken as a credit in your current our GST electronic ledger if and only if returns of the previous six months are already filed under the old regime.

GST TRAN-1

5. Amount of tax credit carried forward in the return filed under existing laws:

a) Amount of cenvat credit carried forward to the electronic credit ledger as the central tax ( Central Excise and Service Tax) Section 140(1) and Section 140(4)(a).

You need to enter the amount of CENVAT in rupees, if you are registered as a manufacturer or service provider and have the closing balance of CENVAT in the return filed period ending June 30th, 2017.

GST TRAN-1

(b) Details of statutory forms received for which credit is being carried forward

Enter the details of C-Form, F-Form and H/I-Form like a TIN of issuer, Name of Issuer, Serial number of Form, amount and applicable VAT rate.

GST TRAN-1

(c) Amount of tax credit carried forward to electronic credit ledger as State/UT Tax(For all registrations on the same PAN and in the same State)

Persons registered under any State VAT having pending C-Form, F-Form, H-form or I-Form are required to pay the differential tax.

This differential tax is deducted from your input credit available in the last return under the old regime. The balance will be transferred to the GST ledger.

Enter details of such pending forms in this section.

GST TRAN-1

6. Details of capital goods for which un-availed credit has not been carried forward under existing law (section140 (2)).

Here you need to provide details un-availed input credit on capital goods.

By any chance, if you haven’t been able to fully claim input credit of such taxes till 30th June, then such can be claimed by reporting here.

(a) Amount of duties and taxes on inputs claimed as credit excluding the credit claimed under Table 5(a)

Record the amount of un-availed credit of CENVAT on capital goods which need to be carried forward to the electronic ledger as the central tax.

GST TRAN-1

(b) Amount of vat and entry Tax paid on inputs supported by invoices/documents evidencing payment of tax carried forward to electronic credit ledger as SGST/UTGST

Enter the amount of un-availed input credit. It is the one that you want to carry forward to electronic credit ledger as State/UT tax.

7. Details of the inputs held in stock in terms of sections 140(3), 140(4)(b) and 140(6).

This portion applies to businesses currently registered under GST but unregistered under the old regime, manufacturing exempted goods, providing exempted services, providing works contract service, a first/second stage dealer, a registered importer or depot of a manufacturer.

(a) Amount of duties and taxes on inputs claimed as credit excluding the credit claimed under Table 5(a) 

In this section fill the details of duty paid invoices or other documents for inputs. You can also add inputs contained in semi-finished and finished goods by a manufacturer or a service provider.

The credit of excise duty or service tax will be an input tax credit of CGST.

GST TRAN-1

(b)Amount of vat and entry Tax paid on inputs supported by invoices/documents evidencing payment of tax carried forward to electronic credit ledger as SGST/UTGST

To be filled only by those who are not manufacturer or service provider and unregistered in the old regime, which means to be filled by dealers or traders. Such a person has to file a TRAN-2 return also.

GST TRAN-1

(c) The stock of goods not supported by invoices/documents evidencing payment of tax (credit in terms of rule 1 (4)) (To be there only in States having VAT at a single point)

GST TRAN-1

8. Details of transfer of cenvat credit for registered person having centralized registration under existing law (Section 140(8))

GST TRAN-1

9.Details of goods sent to job-worker and held in his stock on behalf of principal under section 141

(a) Details of goods sent as principal to the job worker under section 141

The principal who has sent the goods to the job worker has to fill this section.

GST TRAN-1

(b) Details of goods held in stock as a job worker on behalf of the principal under section 141

This section must be filled by you if you are a job worker and have goods pertaining to the principal.

10. Details of goods held in stock as an agent on behalf of the principal under section 142 (14) of the SGST Act

According to section 142 subsection 14 says, “If any goods or capital goods belonging to the principal are lying at the premises of the agent on the appointed day, the agent can take credit of the tax paid on such goods or capital goods.”

(a) Details of goods held as an agent on behalf of the principal

If you are an agent and holding stock on behalf of the principal must give details of unsold stock available with you as on 30th June 2017.

GST TRAN-1

(b) Details of goods held by the agent

If you are a principal then you need to provide details of unsold stock with your agents as on 30th June 2017.

11. Details of credit availed in terms of Section 142 (11 (c ))

In this section, if you are a works contractor then you are entitled to take credit for VAT & Service Tax previously paid under the old regime until 30th June 2017.

GST TRAN-1

12. Details of goods sent on approval basis six months prior to the appointed day (section 142(12))

Enter details of goods sent for approval basis within 6 months prior to 1st July 2017.

GST TRAN-1

In the end, sign the declaration as to testify that the details are correct.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. We will be more than happy to assist you.

« Download GST Sales Register Excel Template
Download GST TRAN-2 Return Excel Template »

Filed Under: GST Templates in Excel

You are Here: Home / Excel Templates / GST Templates in Excel / Download GST TRAN-1 Return Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

GST Templates in Excel

  • GST Receipt Voucher Excel Template For Advance Payments Under GST
  • GST Refund Voucher Excel Template For Refunding Advance Under GST
  • GST Payment Voucher Excel Template for Payments Under Reverse Charge
  • GST Debit Note Format In Excel Under GST 2017
  • GST Credit Note Format In Excel Issued Against Goods Return Or Over Billing
  • GST Delivery Challan Format in Excel For Transportation Of Goods Without The Tax Invoice
  • GST Compliant Voucher Formats In Excel
  • Simplified GST Invoicing and Effortless GSTR Filing
  • GST Purchase Register Excel Template
  • GST Sales Register Excel Template
  • GST TRAN-1 Return Excel Template
  • GST TRAN-2 Return Excel Template
  • Monthly GST Input Output Tax Report Excel Template
  • Pre GST and Post GST Price Comparison Template in Excel
  • Performa LUT (Letter of Undertaking) in MS Word
  • 10 GST Invoice Templates in Excel

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT