Select & Preview Free Excel Template
Click any tab below to review the sheet columns, sample rows, and built-in formulas before downloading.
GST Tax Invoice Template
Compliant with Rule 46 of CGST Rules 2017. Pre-configured with automatic taxable value, 9% CGST + 9% SGST intra-state splitting, and 18% IGST inter-state logic.
| S.No | Item Description | HSN/SAC | Qty | Unit | Rate (₹) | Taxable (₹) | GST % | CGST (₹) | SGST (₹) | IGST (₹) | Total (₹) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Lenovo Wireless Optical Mouse N100 | 8471 | 5 | PCS | ₹450 | ₹2,250 | 18% | ₹202.5 | ₹202.5 | ₹0 | ₹2,655 |
| 2 | HP A4 Copier Paper 75 GSM (500 Sheets) | 4802 | 10 | RIM | ₹280 | ₹2,800 | 12% | ₹168 | ₹168 | ₹0 | ₹3,136 |
| 3 | SanDisk Ultra 64GB MicroSD Card Class 10 | 8523 | 8 | PCS | ₹390 | ₹3,120 | 18% | ₹280.8 | ₹280.8 | ₹0 | ₹3,681.6 |
Built-in Excel Formulas Used in This Sheet
=D2*F2Multiplies Quantity (Col D) by Unit Rate (Col F).
=IF(PlaceOfSupply="Local", ROUND(G2*(H2/2)/100, 2), 0)Applies half of total GST percentage for intra-state supply, rounded to 2 decimals.
=IF(PlaceOfSupply="Local", ROUND(G2*(H2/2)/100, 2), 0)Mirrors CGST amount for state tax.
=IF(PlaceOfSupply="Interstate", ROUND(G2*H2/100, 2), 0)Applies full GST rate for supplies made outside the home state.
=G2+I2+J2+K2Sums Taxable Value plus CGST, SGST, and IGST components.
Live Excel Formula Simulator (Test Your Tax Split)
Change numbers below to see how Excel formulas evaluate CGST, SGST, IGST, and rounding in real time.
₹2,000.00
=Rate * Qty₹180.00
=Taxable * 9%₹180.00
=Taxable * 9%₹0.00
Local sale₹2,360.00
Why Indian Merchants Start with Excel (And When It Breaks)
Real advice from Indian retail counter owners and chartered accountants on managing invoices with spreadsheets.
Why Excel Billing Works at Day 1
When you first open a retail counter, hardware shop, or wholesale godown, Microsoft Excel or Google Sheets feels like the simplest solution. It is virtually free, requires no recurring software subscription, and you can customize columns with total freedom. You can easily email a spreadsheet invoice or print it out on an office A4 laser printer.
- Zero initial software licensing cost
- Freedom to add custom remarks or payment links
- Familiar interface for bookkeepers and CAs
Where Excel Sheets Fail at Scale
Once your daily counter hits 20+ invoices, spreadsheets quickly become a liability. A counter boy accidentally pastes over a cell and deletes the `=SUM` formula. Stock balances don’t auto-deduct. Connecting a high-speed 80mm thermal roll printer requires tricky page-setup margins, and there is no way to generate mandatory GST e-Invoices or e-Way bills.
- ✕Formula corruption: One typed rate breaks the entire tax total
- ✕No live inventory tracking: Sold items stay in godown sheets
- ✕Thermal roll printing nightmare: Excel cannot cut 80mm paper cleanly
Feature Comparison: Excel Sheets vs SuperBiller Free POS
| Billing Capability | Standard Excel / Google Sheets | SuperBiller Cloud & Offline App |
|---|---|---|
| Tax Calculation Accuracy | Depends on formulas (Risk of deletion) | 100% Automated GST Engine |
| 80mm & 58mm Thermal Printing | Very difficult, misaligned text | 1-Click USB & Bluetooth Print |
| Barcode Scanning | Needs manual cell selection each time | Continuous High-Speed POS Scan |
| Dynamic UPI QR on Receipt | Static image only, no dynamic amounts | Instant Exact-Rupee QR on Every Bill |
| Multi-Device Access & Staff Roles | Staff can see entire purchase cost & profit | Role-based Staff & Cashier Locks |
| Monthly Cost | Free (or MS Office subscription) | Free Forever Starter Tier |
Rule 46 Check: 16 Mandatory Particulars in a GST Tax Invoice
Ensure your customized Excel sheet contains every field mandated by the Central Goods and Services Tax Act.
Frequently Asked Questions
Everything you need to know about Excel billing templates and GST compliance.
Is an Excel-generated bill valid as a legal GST invoice in India?
Yes! Under Rule 46 of the CGST Rules 2017, the law does not mandate any specific proprietary software. As long as your printed or PDF invoice features all 16 statutory details (GSTIN, consecutive serial number, HSN code, tax split, and authorized signature), it is 100% legally valid for tax deductions and customer ITC claims.
Can I open and use these templates on Google Sheets or Apple Numbers?
Absolutely. The downloaded templates are standard CSV spreadsheets that open natively in Microsoft Excel (all desktop versions), Google Sheets on web and Android/iOS, WPS Office, Apple Numbers, and LibreOffice Calc without formula errors.
How do I automatically calculate CGST and SGST versus IGST in Excel?
Use an IF conditional formula based on the State Code: =IF(PlaceOfSupply = "Local", TaxableValue * 9%, 0) for CGST and SGST, and =IF(PlaceOfSupply <> "Local", TaxableValue * 18%, 0) for IGST. All our downloadable templates have these formulas pre-configured.
When does a business need to switch from Excel to dedicated billing software?
Most retail and wholesale businesses outgrow Excel once they cross 20–30 bills daily, require barcode scanner support at the counter, want to print fast 80mm thermal receipts, or need automated multi-godown stock alerts to prevent overselling.
More Free Online Business Tools
Boost your store productivity with our suite of free, ungated utility tools built for Indian retailers, traders, and MSMEs.
Free Online Receipt Maker & Generator
Create cash receipts, HRA rent slips with landlord PAN, donation receipts & 80mm thermal slips.
Free SKU Generator & Product Code Maker
Standardized alphanumeric SKU product codes with variant matrix & 1-click CSV and barcode sticker export.
Free Purchase Order (PO) Generator
Create legal B2B purchase orders with GSTIN, HSN codes, custom delivery milestones & WhatsApp dispatch.
Free Salary Slip & Payslip Maker
Monthly employee salary slips with automated Basic, HRA, PF (12%), ESIC (0.75%), PT & in-hand wage calculation.
Village Byaj Calculator (देसी ब्याज)
Calculate traditional rural interest at ₹2, ₹1.5 saikda per month with instant WhatsApp hisaab slips.
Shop Counter UPI Standee Generator
Print-ready NPCI verified UPI payment standees & table tents with GPay, PhonePe, Paytm logos.
Pin to Pin Distance Calculator (E-Way Bill)
Calculate road distance & CGST Rule 138(10) validity days between any two Indian pincodes with 10% buffer.
CTS-2010 Bank Cheque Printer Online
Print error-free bank cheques for SBI, HDFC, ICICI, PNB with Indian words and boxed dates.
GST Credit Note & Debit Note Generator
Rule 53 compliant credit & debit notes for sales returns, post-sale discounts, & GSTR-1 Table 9B.
Free Quotation & Estimate Maker
Create, download & print professional business quotations and estimates with GST.
GST Delivery Challan Generator
Rule 55 compliant delivery challans for Job-Work, Godown Transfer, & Transit goods.
Proforma Invoice Maker
Create professional proforma bills for advance payments and purchase order confirmations.
Retail Cash Counter Calculator
Daily cash tally calculator for shops: ₹500, ₹200, ₹100 note counts with WhatsApp export.
Profit Margin & Markup Calculator
Calculate cost, selling price, gross profit margin %, and markup with GST inclusion.
Free GST Invoice Generator
Create, download & print legal GST tax invoices with 80mm thermal support.
GST Search by PAN
Verify 15-digit GST numbers and 10-digit PAN cards, check active taxpayer status & legal firm names.
Online GST Calculator
Calculate GST inclusive & exclusive prices with instant CGST, SGST & IGST split.
GST Late Fee & Interest Calculator
Compute Section 47 daily late fees and Sec 50 (18% p.a.) interest with turnover caps.
Business Loan EMI Calculator
Plan MSME loans, machinery credit, and Mudra financing with amortization tables.
HSN & SAC Code Finder
Lookup 10,000+ official Indian GST HSN product & SAC service codes with tax slabs.
Free Barcode & QR Generator
Generate Code 128 barcodes and UPI payment QR stickers for retail item labelling.