GST Invoice & Bill Format in Excel, Word and PDF – Free Download

Download free GST invoice formats in Excel, Word and PDF for creating professional bills for goods and services. Customise business details, customer information, HSN/SAC, GST rates, pricing and totals before sharing the invoice.
Choose GST invoice format in Excel for editable calculations, Word for flexible editing, or PDF for printing and sharing. If you create invoices regularly, GimBooks helps you move from manual templates to online GST billing.
‍
Editable templates • GST-ready fields • Instant download • Suitable for all businesses

GET A FREE subscription
for 7 days!!

Get a 7-day free trial to manage all your billing with Gimbooks

Get Started
GST Invoice Basics

What Is a GST Invoice Format?

A GST invoice format is a structured template used by a GST-registered business to record the details of a taxable supply of goods or services.

A good GST bill format keeps transaction details organised and makes invoices easier to review and maintain for GST-related records.
What a GST Invoice Includes Invoice Checklist
  • Supplier name, address and GSTIN
  • Buyer details and GSTIN, where applicable
  • Unique invoice number and date
  • Product or service description
  • HSN or SAC
  • Quantity and unit, where applicable
  • Rate and taxable value
  • Applicable GST rate
  • CGST, SGST or IGST
  • Total invoice value
  • Other applicable transaction details

invoice template Excel

An Excel GST invoice template provides an editable structure for entering products or services, quantities, prices, GST rates and invoice totals. It is useful for small businesses that prefer spreadsheet-based billing and want to customise the invoice for their own requirements.Before sharing an Excel invoice, verify the invoice number, customer details, HSN/SAC where applicable, taxable value, GST calculation and final amount.

The template is suitable for businesses that create a limited number of invoices and want to maintain billing records in a spreadsheet.

invoice template Pdf

An invoice template PDF is a pre-designed document for creating invoices. It contains all information for billing like, item descriptions, prices, quantities, totals, tax charges, discount given, signature and payment terms. Try this invoice template pdf, it can be downloaded for free and customized to fit your business needs.

Free invoice template word

Use the Word format when you want to customise the invoice layout, add your company logo or adjust the wording and terms.
Word templates are useful for service providers, consultants and small businesses that need a professional, editable invoice document.
Unlike Excel, Word does not automatically calculate GST unless formulas or linked fields have been specifically configured. Verify all taxable values and tax amounts before issuing the invoice.

BUSINESS INVOICE FORMATS

GST Invoice Formats for Different Businesses

01

Retail Businesses

Use a GST invoice format to record products, quantities, pricing, GST and customer details for everyday sales.

02

Wholesalers & Distributors

Invoice multiple products with item-level quantities, pricing, GST and customer information while maintaining organised sales records.

03

Service Businesses

Use a GST invoice format to clearly present service descriptions, fees, applicable taxes and payment information.

04

Small Businesses & Freelancers

Excel and Word formats can be useful for businesses that create invoices occasionally and need an editable document.

GST INVOICE IN EXCEL

GST Invoice Format in Excel: What Should It Include?

A GST invoice format in Excel should make it easy to enter business details, customer information, product or service details and applicable GST. Before using an Excel invoice for an actual transaction, review the applicable GST requirements and verify all calculations.

What Your Excel Invoice Should Cover

A well-structured Excel invoice keeps essential business, customer, product, pricing and GST information organised in one editable document.

  • Business name, address and GSTIN
  • Customer name and address
  • Customer GSTIN, where applicable
  • Invoice number and date
  • Product or service description
  • HSN/SAC, where applicable
  • Quantity and unit
  • Rate and taxable value
  • Discount, where applicable
  • Applicable GST rate
  • CGST and SGST or IGST, as applicable
  • Total invoice value
  • Payment and other applicable transaction details
When to use Excel: Excel is useful for businesses that create a limited number of invoices and want an editable billing document. For frequent billing, software can reduce repetitive data entry and calculation work.
Invoice Format Comparison

Excel, Word or PDF: Which Format Should You Choose?

Compare common invoice formats and choose the right option based on editing needs, calculations, sharing, and regular GST billing requirements.

GST Billing Ready
Format Best for Editable Automatic calculations Recommended use
📊 Excel Small businesses and spreadsheet users ✓ Yes ✓ Yes, when formulas are configured Creating and calculating invoices
📝 Word Consultants and service businesses ✓ Yes ✕ No Customising invoice design and text
📄 PDF Printing, sharing and reference Limited ✕ No Sending a final non-editable invoice
✅ GST billing software Businesses creating invoices regularly ✓ Yes ✓ Yes Billing, inventory, payments and GST reports

For regular invoicing, GST billing software is the better choice because it reduces manual edits, calculation errors, and repeated invoice formatting work.

Try GimBooks
GST Invoice Checklist

Mandatory Fields in a GST Invoice

A GST tax invoice should contain the applicable particulars prescribed under Rule 46. These fields help record the transaction correctly, calculate GST, support return filing and help the recipient reconcile Input Tax Credit.

🏢

Supplier Details

  • Supplier’s legal name
  • Registered address
  • GSTIN
🧾

Invoice Details

  • Unique and consecutive invoice number
  • Invoice date
  • Due date, where applicable
👤

Recipient Details

  • Buyer’s name
  • Billing and delivery address
  • GSTIN or UIN where the buyer is registered
  • State and state code where applicable
📦

Goods or Service Details

  • Description
  • HSN or SAC
  • Quantity and UQC for goods
  • Unit price
  • Discount
  • Taxable value
₹

GST Details

  • GST rate
  • CGST and SGST for eligible intrastate supplies
  • IGST for eligible interstate supplies
  • Cess where applicable
  • Total tax
  • Final invoice amount
✅

Conditional Details

  • Place of supply for interstate transactions
  • Delivery address where different
  • Reverse-charge status
  • Export or SEZ endorsement where applicable
  • IRN-linked signed QR code where e-invoicing applies
  • Supplier’s signature or applicable digital authentication
GST INVOICE IN EXCEL

How to Create a GST Invoice in Excel

Follow these steps to create a GST invoice in Excel with the right business details, customer information, product or service data, GST calculation and final invoice review.

1

Enter Your Business Details

Add your business information, including:

  • Business name and registered address
  • GSTIN
  • Contact information
  • Bank details, where applicable
2

Add Invoice Details

Enter a unique invoice number and the correct invoice date.

Use a consistent invoice numbering sequence so invoices can be identified and tracked properly.
3

Add Customer Information

Enter the customer's:

  • Legal or trade name
  • Billing address
  • Delivery address
  • GSTIN, where applicable
  • State and state code
4

Add Products or Services

For each invoice line, include:

  • Description
  • HSN or SAC
  • Quantity and UQC
  • Rate and discount
  • Taxable value
5

Select the Correct Tax Type

For a standard intrastate transaction, apply CGST and SGST. For a standard interstate transaction, apply IGST.

Verify the applicable place-of-supply treatment before selecting the tax type.
6

Check GST Calculations

Confirm that:

  • Taxable value is correct
  • Applicable GST rate is correct
  • CGST/SGST or IGST is calculated correctly
  • Discounts are reflected correctly
  • Item totals match the invoice total
7

Review and Share the Invoice

Check customer, GST, product, payment and total details before saving or sharing the final invoice.

Save the completed invoice as PDF when you need to send a non-editable copy to the customer.

GST Invoice Excel Checklist Before Sharing

Before sending a GST invoice created in Excel, check the following details to reduce billing and calculation errors:

  • Invoice number is unique and correctly sequenced
  • Seller GSTIN is correct
  • Customer GSTIN is correct, where applicable
  • HSN/SAC is appropriate
  • Taxable value is accurate
  • GST rate is correct
  • CGST/SGST or IGST treatment is correct
  • Invoice total matches the line-item calculations
  • Customer and delivery details are correct
  • Applicable invoice particulars are included

GST Calculation Example for Intrastate and Interstate Sales

See how GST is calculated when the taxable value is ₹10,000 and the applicable GST rate is 18%. The total tax amount remains the same, but the GST type changes based on the nature and place of supply.

CGST + SGST

Intrastate Sale

Suppose a Maharashtra business sells goods worth ₹10,000 to a customer in Maharashtra at 18% GST.

Particular Amount
Taxable value ₹10,000
CGST at 9% ₹900
SGST at 9% ₹900
Total invoice value ₹11,800
IGST

Interstate Sale

Suppose the same Maharashtra business sells the goods to a registered customer in Gujarat.

Particular Amount
Taxable value ₹10,000
IGST at 18% ₹1,800
Total invoice value ₹11,800
Key takeaway: The tax amount is the same in both examples, but the type of GST changes according to the nature and place of supply.

GST Invoice Format vs GST Billing Software

A downloadable template is useful for occasional billing. Businesses creating invoices regularly may need a system that connects billing with inventory, customer balances and GST reports.

Feature Excel or Word Template GimBooks GST Billing Software
Create GST invoices ✓ Yes ✓ Yes
Automatic GST calculation Limited to configured formulas ✓ Yes
Customer and item records Entered manually Saved for reuse
Invoice numbering Manually controlled Automatically managed
Inventory updates Separate process Connected with transactions
Payment reminders ✕ No Available
E-invoice generation Separate process Available
E-way bill workflow Separate process Available
GST reports Manual consolidation Available
Mobile and web access File dependent Available
Use the downloadable formats for simple invoice creation, or use GimBooks when you need to create, track and manage invoices as part of a complete billing workflow.

Ready to move beyond manual invoice templates? Create GST invoices, track payments, manage inventory and access GST reports with GimBooks.

Start a 7-Day Free Trial
INVOICE FORMAT GUIDE

GST Invoice Format vs Regular Invoice Format

GST Invoice Format Regular Invoice Format
Used where applicable for taxable supplies by GST-registered businesses Used where GST tax particulars are not applicable
Includes applicable GST details Does not show GST tax breakup where GST is not applicable
May include GSTIN and HSN/SAC where applicable Includes basic product or service and pricing information
Shows applicable CGST/SGST or IGST Does not include a GST tax breakup where GST is not applicable
Supports GST-related record keeping Used for general commercial billing
Important: The exact document requirements depend on the nature of the supply and the taxpayer's GST position. Businesses should verify the applicable GST rules before issuing an invoice.

More Free Business Document Formats

Choose from other useful business templates for quotations, proforma invoices, delivery challans, purchase orders, credit notes, debit notes, e-invoices and e-way bills.

Custom GST Invoice Format

Create Custom GST Invoice Formats with GimBooks

Downloadable invoice formats are useful for simple billing, but growing businesses need more control over branding, GST details, customer records and invoice sharing. GimBooks helps you create professional GST invoices that can be customised for your business and shared with customers in a cleaner, faster way.

  • Customise invoice formats with your business details and branding.
  • Create GST-compliant invoices for goods and services.
  • Manage customers, suppliers, distributors and billing records from one place.
  • Share invoices digitally instead of editing and sending manual files every time.
Cloud Billing

What GimBooks helps you manage

  • GST invoices
  • Custom invoice formats
  • Customer records
  • Payment tracking
  • Inventory workflows
  • GST reports

Use free invoice formats for occasional billing, or use GimBooks GST billing software when you want to create, manage and share invoices as part of a complete billing workflow.

GST Invoice FAQs

Frequently Asked Questions

Get quick answers about GST invoice formats, Excel invoices, GST bills, invoice requirements and choosing between templates and billing software.

What is a GST invoice format?

A GST invoice format is a structured document used to record the applicable details of a taxable supply, including supplier and customer information, invoice details, goods or services, taxable value, GST and total amount.

Can I download a GST invoice format in Excel?

Yes. You can download an editable GST invoice format in Excel and customise it with your business, customer, product, pricing and applicable GST details.

Can I download a GST bill format in PDF?

Yes. A GST bill format in PDF provides a fixed document that can be printed, shared with customers or retained for business records.

What should a GST invoice contain?

A GST invoice should contain the applicable supplier, recipient, invoice, product or service, HSN/SAC, taxable value, GST and total-value particulars required for the transaction.

Is a GST invoice format in Excel valid?

An invoice prepared in Excel can be used when it contains the applicable invoice particulars and complies with relevant GST requirements. Businesses should verify the information and calculations before issuing it.

What is the difference between a GST invoice and a GST bill?

“GST bill” is commonly used to refer to a GST invoice. For a taxable supply where a tax invoice is required, the document should contain the applicable GST particulars.

Can Excel calculate GST automatically?

Yes. Excel can calculate GST when appropriate formulas are configured. The GST rate, taxable value, tax split and final invoice amount should always be checked before issuing the invoice.

Which is better: GST invoice format in Excel or billing software?

Excel can work for occasional billing, while billing software is more suitable for businesses that create invoices regularly and need connected customer, inventory, payment and GST workflows.

Create GST Invoices With GimBooks

Use a free invoice format for occasional billing or manage regular GST invoicing through an online billing workflow.

Create GST Invoice Online

Access the best invoice format for your small business!