7+ Free GST [India] Excel Templates for 2022
Lets discuss a bit on GST (Goods and Service Tax) of India and elegant and free Excel Templates for small and medium sized businesses in this article.
Goods and Services Tax (GST) is an indirect tax (or consumption tax) used in India on the supply of goods and services. It is a comprehensive, multistage, destination-based tax: comprehensive because it has subsumed almost all the indirect taxes except a few state taxes. Multi-staged as it is, the GST is imposed at every step in the production process, but is meant to be refunded to all parties in the various stages of production other than the final consumer and as a destination-based tax, it is collected from point of consumption and not point of origin like previous taxes.
Goods and services are divided into five different tax slabs for collection of tax: 0%, 5%, 12%, 18% and 28%. However, petroleum products, alcoholic drinks, and electricity are not taxed under GST and instead are taxed separately by the individual state governments, as per the previous tax system.[citation needed] There is a special rate of 0.25% on rough precious and semi-precious stones and 3% on gold. In addition a cess of 22% or other rates on top of 28% GST applies on few items like aerated drinks, luxury cars and tobacco products. Pre-GST, the statutory tax rate for most goods was about 26.5%, Post-GST, most goods are expected to be in the 18% tax range.
The tax came into effect from 1 July 2017 through the implementation of the One Hundred and First Amendment of the Constitution of India by the Indian government. The GST replaced existing multiple taxes levied by the central and state governments.
The tax rates, rules and regulations are governed by the GST Council which consists of the finance ministers of the central government and all the states. The GST is meant to replace a slew of indirect taxes with a federated tax and is therefore expected to reshape the country’s $2.4 trillion economy, but its implementation has received criticism. Positive outcomes of the GST includes the travel time in interstate movement, which dropped by 20%, because of disbanding of interstate check posts.
India GST Excel templates and formats
1. GST Sales Register format in Excel
Download GST Sales Register Format in Excel and Spreadsheet for your business and client. Use this GST Excel template to enhance the sales register quality in your business or client to comply with Goods and Services Tax (GST).
2. GST Refund Voucher format in Excel
Download GST Refund Voucher in Excel and Spreadsheet for your business and client. This GST Excel template helps you to efficiently and easily issue the voucher against refund of GST for goods or services. It is useful for Accounts Assistant, Accountants and Audit Assistants.
3. GST Receipt Voucher format in Excel
Download GST Receipt Voucher format in Excel and Spreadsheet for your business and client. Use this free GST Excel Template for issuing Receipt voucher for advances received during the course of business. GST Receipt Voucher is an mandatory after the implementation of Goods & Service Tax.
This template helps to efficiently and easily issue the receipt voucher against the receipt of an advance amount for goods or services to be supplied in future. It is useful for Accounts Assistant, Accountants, Audit Assistants.
4. GST Purchase Register Format in Excel
Download free GST Purchase Register format in Excel and Spreadsheet for your businesses and clients. This can be useful as Input tax register as well for Goods and Service Tax (GST). This GST Register format in excel can be printed and used as manual register in your business.
Input tax is tax you pay on goods or services you purchase to deliver output service or output goods or both. You will need a register to capture all the purchases wherein you have made payment of tax (GST) to claim Input tax credit (ITC).
5. GST Payment Voucher format in Excel
Download GST Payment Voucher Format in Excel and Spreadsheet for your business and clients. It is useful for Accounts Assistant, Accountants, Audit Assistants. Use this excel GST Format to create payment voucher for your business or client under Goods and Service Tax (GST).
6. GST Debit Note Format in Excel
Download GST Debit Note Format in Excel and Spreadsheet for your business and client. This GST Excel Template for debit note is useful for Traders, Wholesalers, Accounts Assistant, Accountants. This is a printable Debit note format in Excel.
GST implemented with effect from 1st July 2017. As a registered business will now have to issue GST Invoice for the supply of taxable goods or services. A GST Debit Note format whenever taxable value or tax charge in original invoice is found less than the actual amount.
7. GST Credit note format in Excel
Download this GST Credit Note Format in Excel and Spreadsheet for your Business. This template for GST India in Excel is useful for registered suppliers under GST regime. This is a printable credit note format in Excel.
8. GST Invoice format in Excel
With the implementation of Goods and Services Tax from 1st July 2017, as every registered business entity need to issue a GST invoice whenever the supply of taxable goods or services is made.
There are two types of invoices under Goods and Service Tax (GST), namely,
- Tax Invoice — For all taxable sales
- Bill of Supply — For all exempt sales and sales by Composite Dealer
GST is charged differently for local sales and for central sales, to understand it better –
- For Local Sales — CGST and SGST will be applicable.
- For Central Sales — IGST will be applicable
CGST — Central Goods and service tax
SGST — State Goods and Service tax
IGST — Integrated Goods and service tax
9. GST Bill of Supply format in Excel
Download this GST Bill of Supply format in Excel and Spreadsheet for businesses. Use this free GST Excel template to issue bill of supplies in your business wherein you do not have tax information. Download excel format for Bill of supply under Goods and Service Tax (GST).
10. GST Delivery Challan Format in Excel
Download GST Delivery Challan Format in Excel and Spreadsheet for businesses. In general business procedures, The consignor issues a GST Delivery Challan in lieu of GST Tax Invoice at the time of goods are removed for transportation for the purpose of job work, the supply of goods from primary office to branch etc.