GST Invoice Template

Template Overview

A GST invoice is the document a registered business issues for a taxable sale in India — and under GST law it must contain specific details, or your buyer can be denied input tax credit. This template gives you a compliant format that does the tax maths for you. It is built for intra-state sales, where GST splits into CGST and SGST at half the rate each (an 18% item carries 9% + 9%). Enter the quantity, rate, and GST rate for each item, and the sheet calculates the taxable value, both taxes, and the grand total automatically. For inter-state sales you would instead charge a single IGST at the full rate.

Features

• Auto-calculates CGST, SGST and totals
• Includes every GST-mandatory field (CGST Rule 46)
• Works in Excel, Google Sheets and LibreOffice
• Editable, printable and save-as-PDF ready
• Sample items included to follow

Instructions

1. Download the file and open it in Excel, Google Sheets, or LibreOffice.
2. Fill in your business details — replace every [ ] placeholder (name, address, GSTIN, state).
3. Add the invoice number, date, and place of supply in the box on the right.
4. Enter the customer's details in the Bill To (and Ship To if different) box.
5. Add each item's description, HSN/SAC, quantity, rate, and GST rate — taxes fill in automatically.
6. Check the Grand Total, write the amount in words, add bank details, and sign.
7. Save as PDF before sending so the figures cannot be changed.

FAQ