Free GST Templates for Excel & Google Sheets
Fully-compliant GST invoice, RCM self-invoice, and Indian tax-compliance templates for Excel and Google Sheets — with CGST, SGST, IGST calculations built in.
Under Indian GST law, every registered business must issue invoices in a specific format — with your GSTIN, place of supply, HSN/SAC codes, and the correct CGST/SGST or IGST split. Get the format wrong and your customers can be denied Input Tax Credit; get it right and you stay audit-ready with no extra effort.
These GST templates give you compliant formats out of the box. Every field required by CGST Rule 46 is included, and the tax maths (CGST, SGST, IGST, totals) is done by live formulas — you enter the item, quantity, and rate and the invoice completes itself. Start with the GST Invoice Template for registered sales, or the Self Invoice Format Under GST (RCM) when you buy from an unregistered supplier. All templates work in Excel, Google Sheets, and LibreOffice.
Templates in this category
Free self invoice format under GST for Reverse Charge (RCM) in Excel and Google Sheets. Use this RCM invoice format when you buy from an unregistered supplier. Auto-calculates CGST, SGST, and totals. Free Excel download.
A free, ready-to-use GST tax invoice template for Excel and Google Sheets. CGST and SGST are calculated automatically — just enter quantity, rate, and GST rate. Includes every field required by Indian GST law.
What to look for in a gst template
- Includes all fields mandated by CGST Rule 46 (GSTIN, invoice number, place of supply, HSN/SAC)
- Auto-calculates CGST + SGST for intra-state and IGST for inter-state sales
- Supports Reverse Charge (RCM) flag for self-invoices from unregistered suppliers
- Editable line items with tax-rate column per row (5%, 12%, 18%, 28%)
- Amount-in-words field, bank details block, signature space, and clean print layout
- Works in Excel, Google Sheets, and LibreOffice without formula loss
Frequently asked questions
Are these GST templates free to use?+
Yes. Every template in this category is 100% free to download and use for personal or commercial purposes. No signup, no email, no watermark. You can also modify them for your business branding.
Is a hand-written or Excel GST invoice legal in India?+
Yes. GST law does not mandate any specific software — the invoice can be printed, hand-written, or generated from Excel, as long as it contains every mandatory field required by CGST Rule 46 (GSTIN, invoice number, HSN/SAC, taxable value, correct GST split). The format matters, not the tool.
Do these templates work for both intra-state (CGST + SGST) and inter-state (IGST) sales?+
The standard GST Invoice Template covers intra-state (CGST + SGST) out of the box. For inter-state IGST, you can either rename the tax column to IGST and use the full rate, or use a dedicated IGST-format variant. The templates are designed to be easy to adapt to either scenario.
When do I need to raise a self invoice under GST?+
You must raise a self invoice whenever GST is payable under Reverse Charge Mechanism — typically for purchases from unregistered suppliers, GTA freight, advocate fees, director's remuneration, sponsorship services, or import of services. Use the free Self Invoice Format Under GST (RCM) Excel template in this category.