Meta Pixel
LIMITED OFFERSave upto 65% today on SuperBiller Pro EditionExplore Now
100% Free Excel Downloads • No Sign-up or Phone OTP Required

Free Billing Software in Excel & GST Invoice Templates

Download pre-formatted, CA-verified Excel billing spreadsheets for Indian shops and MSMEs. Features automatic CGST, SGST, IGST tax calculation formulas, GSTR-1 sales formats, and 2B purchase reconciliation sheets.

Works with MS Excel 2010–365100% Google Sheets CompatibleOfficial GST Rule 46 Compliant

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.

Or Create Online
Live Spreadsheet Grid Preview:Scroll horizontally on mobile →
S.NoItem DescriptionHSN/SACQtyUnitRate (₹)Taxable (₹)GST %CGST (₹)SGST (₹)IGST (₹)Total (₹)
1Lenovo Wireless Optical Mouse N10084715PCS₹450₹2,25018%₹202.5₹202.5₹0₹2,655
2HP A4 Copier Paper 75 GSM (500 Sheets)480210RIM₹280₹2,80012%₹168₹168₹0₹3,136
3SanDisk Ultra 64GB MicroSD Card Class 1085238PCS₹390₹3,12018%₹280.8₹280.8₹0₹3,681.6

Built-in Excel Formulas Used in This Sheet

Taxable Amount
=D2*F2

Multiplies Quantity (Col D) by Unit Rate (Col F).

CGST Amount
=IF(PlaceOfSupply="Local", ROUND(G2*(H2/2)/100, 2), 0)

Applies half of total GST percentage for intra-state supply, rounded to 2 decimals.

SGST Amount
=IF(PlaceOfSupply="Local", ROUND(G2*(H2/2)/100, 2), 0)

Mirrors CGST amount for state tax.

IGST Amount
=IF(PlaceOfSupply="Interstate", ROUND(G2*H2/100, 2), 0)

Applies full GST rate for supplies made outside the home state.

Line Total
=G2+I2+J2+K2

Sums Taxable Value plus CGST, SGST, and IGST components.

Interactive Tool

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.

Taxable Value

₹2,000.00

=Rate * Qty
CGST (9%)

₹180.00

=Taxable * 9%
SGST (9%)

₹180.00

=Taxable * 9%
IGST (0%)

₹0.00

Local sale
Total Invoice Payable Amount

₹2,360.00

Print This as 80mm Bill

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 CapabilityStandard Excel / Google SheetsSuperBiller Cloud & Offline App
Tax Calculation AccuracyDepends on formulas (Risk of deletion)100% Automated GST Engine
80mm & 58mm Thermal PrintingVery difficult, misaligned text1-Click USB & Bluetooth Print
Barcode ScanningNeeds manual cell selection each timeContinuous High-Speed POS Scan
Dynamic UPI QR on ReceiptStatic image only, no dynamic amountsInstant Exact-Rupee QR on Every Bill
Multi-Device Access & Staff RolesStaff can see entire purchase cost & profitRole-based Staff & Cashier Locks
Monthly CostFree (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.

1. Supplier Legal Name & Address
2. 15-Digit Supplier GSTIN
3. Consecutive Serial Number (Max 16 chars)
4. Date of Invoice Issuance
5. Recipient Name & Address
6. Recipient GSTIN / UIN (if registered)
7. Delivery Address (for consignee)
8. HSN Code / SAC Code
9. Item Description of Goods/Services
10. Quantity & Unit of Measure
11. Total Value of Supply
12. Taxable Value (after trade discount)
13. Rate of Tax (CGST, SGST, IGST)
14. Total Tax Amount segregated by slab
15. Place of Supply + State Code
16. Signature or Digital Stamp

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.

100% Free Forever • No Sign-up or Login Required

More Free Online Business Tools

Boost your store productivity with our suite of free, ungated utility tools built for Indian retailers, traders, and MSMEs.

100% Free

Free Online Receipt Maker & Generator

Create cash receipts, HRA rent slips with landlord PAN, donation receipts & 80mm thermal slips.

Open Free Tool
Retail SKU

Free SKU Generator & Product Code Maker

Standardized alphanumeric SKU product codes with variant matrix & 1-click CSV and barcode sticker export.

Open Free Tool
B2B PO

Free Purchase Order (PO) Generator

Create legal B2B purchase orders with GSTIN, HSN codes, custom delivery milestones & WhatsApp dispatch.

Open Free Tool
Payroll

Free Salary Slip & Payslip Maker

Monthly employee salary slips with automated Basic, HRA, PF (12%), ESIC (0.75%), PT & in-hand wage calculation.

Open Free Tool
₹ सैकड़ा हिसाब

Village Byaj Calculator (देसी ब्याज)

Calculate traditional rural interest at ₹2, ₹1.5 saikda per month with instant WhatsApp hisaab slips.

Open Free Tool
Counter Standee

Shop Counter UPI Standee Generator

Print-ready NPCI verified UPI payment standees & table tents with GPay, PhonePe, Paytm logos.

Open Free Tool
Rule 138(10)

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.

Open Free Tool
CTS-2010

CTS-2010 Bank Cheque Printer Online

Print error-free bank cheques for SBI, HDFC, ICICI, PNB with Indian words and boxed dates.

Open Free Tool
Rule 53

GST Credit Note & Debit Note Generator

Rule 53 compliant credit & debit notes for sales returns, post-sale discounts, & GSTR-1 Table 9B.

Open Free Tool
Popular

Free Quotation & Estimate Maker

Create, download & print professional business quotations and estimates with GST.

Open Free Tool
Rule 55

GST Delivery Challan Generator

Rule 55 compliant delivery challans for Job-Work, Godown Transfer, & Transit goods.

Open Free Tool
B2B Advance

Proforma Invoice Maker

Create professional proforma bills for advance payments and purchase order confirmations.

Open Free Tool
Retail POS

Retail Cash Counter Calculator

Daily cash tally calculator for shops: ₹500, ₹200, ₹100 note counts with WhatsApp export.

Open Free Tool
Pricing

Profit Margin & Markup Calculator

Calculate cost, selling price, gross profit margin %, and markup with GST inclusion.

Open Free Tool
Essential

Free GST Invoice Generator

Create, download & print legal GST tax invoices with 80mm thermal support.

Open Free Tool
Verification

GST Search by PAN

Verify 15-digit GST numbers and 10-digit PAN cards, check active taxpayer status & legal firm names.

Open Free Tool
Free Tool

Online GST Calculator

Calculate GST inclusive & exclusive prices with instant CGST, SGST & IGST split.

Open Free Tool
Statutory

GST Late Fee & Interest Calculator

Compute Section 47 daily late fees and Sec 50 (18% p.a.) interest with turnover caps.

Open Free Tool
Finance

Business Loan EMI Calculator

Plan MSME loans, machinery credit, and Mudra financing with amortization tables.

Open Free Tool
GST Council

HSN & SAC Code Finder

Lookup 10,000+ official Indian GST HSN product & SAC service codes with tax slabs.

Open Free Tool
Retail POS

Free Barcode & QR Generator

Generate Code 128 barcodes and UPI payment QR stickers for retail item labelling.

Open Free Tool