Free GST Templates for Excel & Google Sheets
GST invoice, RCM bill format (supplier does not collect GST), RCM self invoice for unregistered suppliers, and an RCM payment voucher — Excel and Google Sheets files with live CGST, SGST, and IGST formulas.
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. Use the RCM bill format when a registered GTA must not collect the tax. Use the RCM tax invoice format when another registered supplier — the sample is a firm of advocates billing legal services — must show GST without collecting it. Use the RCM invoice format (self invoice) only when the supplier is unregistered and GST is payable by you. Use the URD purchase bill when that supplier simply bills you and no GST is charged. Use the RCM payment voucher on the day you pay a reverse-charge supply. All templates work in Excel, Google Sheets, and LibreOffice.
Templates in this category
Free unregistered dealer invoice format in Excel. The URD purchase bill a supplier with no GSTIN issues. No GST is added.
Free invoice for free sample under GST in Excel. It is a Rule 55 delivery challan for goods sent without consideration. Sample value ₹5,790. GST is not charged.
Free RCM tax invoice format under GST in Excel. A registered supplier issues it and does not collect the tax. Sample: a firm of advocates bills ₹40,000, CGST ₹3,600 + SGST ₹3,600.
Free RCM bill format in Excel for a registered supplier. GST is shown for the recipient and is not added to the amount you collect. Sample GTA freight of ₹18,500 at 5%.
Free GST payment voucher for Reverse Charge in Excel. Record payment to an unregistered supplier, link the self invoice number, and see RCM GST payable to government. Works in Google Sheets.
Free RCM invoice format in Excel. Self invoice for unregistered dealer purchases under GST. Auto-calculates CGST, SGST, and totals.
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?+
Raise a self invoice when you are the recipient, the supplier is not registered, and GST is payable by you under reverse charge (Section 31(3)(f)). Use the RCM invoice format for that. If the supplier is registered and issues the bill — a registered GTA that has not opted for forward charge is the common case — they use the RCM bill format, and you do not also self-invoice. Either way, raise a payment voucher when you pay.