Free GST invoice format

GST Invoice Format

GST invoice format in Excel for Indian businesses

Use this GST invoice format as an invoice register for tracking tax invoice details, GST values and payment follow-up. It is not a final printable invoice layout by itself.

Download free XLSXBrowse formats

No login required. XLSX download includes a WorkbookWise About sheet.

Workbook screenshot

GST Invoice Format

12 columns in the XLSX download.

Free XLSX
Invoice NoInvoice DateCustomerGSTINPlace of SupplyTaxable ValueGST Rate
INV-10101/10/2026Aarav Traders27ABCDE1234F1Z5Maharashtra4250018%
INV-10203/10/2026City Foods33ABCDE1234F1Z2Tamil Nadu1820012%
INV-10305/10/2026Metro Stores-Maharashtra3100018%
Screenshot-style preview of sample rows. 5 more columns are listed below.

Best for

  • Small businesses issuing GST invoices
  • Accountants reviewing sales registers
  • Teams tracking payment status with invoice tax values

India notes

  • Use CGST/SGST for intra-state supplies and IGST for inter-state supplies.
  • Keep invoice numbers unique and sequential for easier audit review.
  • Separate taxable value from tax amount so GSTR review is easier later.

Workbook columns

A clean structure before formulas or workflow.

These fields are visible in the free download and in the page HTML so users, Google and answer engines can inspect what the format contains.

Invoice NoINV-101
Invoice Date01/10/2026
CustomerAarav Traders
GSTIN27ABCDE1234F1Z5
Place of SupplyMaharashtra
Taxable Value42500
GST Rate18%
CGST3825
SGST3825
IGST0
Invoice Total50150
Payment StatusDue

Ready to use this workbook structure?

Download the XLSX now, then return to the notes below only if you need review guidance.

Download free XLSX

What the GST invoice format in Excel is for

This format is for shops, traders, service firms and accounting teams that want one row per GST invoice with customer identity, GSTIN, taxable value, tax breakup and payment status visible. Use it as an invoice tracker or source data for a printable tax invoice, not as a finished invoice design. The page is meant for users who search for a usable format, not a generic article. That is why the preview, columns, sample rows and download button are visible before the longer guidance. The downloaded workbook is intentionally simple: it gives a clean structure that can be opened, inspected and adapted in Excel before moving into custom generation, forms, apps or document output.

  • Small businesses issuing GST invoices
  • Accountants reviewing sales registers
  • Teams tracking payment status with invoice tax values

Columns included in the free workbook

The free XLSX includes these practical columns: Invoice No, Invoice Date, Customer, GSTIN, Place of Supply, Taxable Value, GST Rate, CGST, SGST, IGST, Invoice Total, Payment Status. The columns are separated so users can filter, sort, add formulas and review the workbook with an accountant, owner or operations lead. Avoid putting multiple business facts into one notes column; clear columns make the file easier to import into WorkbookWise later if the team wants Use My Data, Apps, Forms or Rows to Documents.

  • Invoice No: example value INV-101
  • Invoice Date: example value 01/10/2026
  • Customer: example value Aarav Traders
  • GSTIN: example value 27ABCDE1234F1Z5
  • Place of Supply: example value Maharashtra
  • Taxable Value: example value 42500

India-specific notes before using the format

Use CGST/SGST for intra-state supplies and IGST for inter-state supplies. Keep invoice numbers unique and sequential for easier audit review. Separate taxable value from tax amount so GSTR review is easier later. WorkbookWise keeps these notes on the landing page because Indian business Excel files often become operating records, not just rough drafts. A free format is useful when it makes the daily workflow cleaner, but tax, payroll, rent, school, stock and customer records may still need human review before they are treated as final business evidence.

  • Use CGST/SGST for intra-state supplies and IGST for inter-state supplies.
  • Keep invoice numbers unique and sequential for easier audit review.
  • Separate taxable value from tax amount so GSTR review is easier later.

How to use the download

Keep invoice number, date, customer, GSTIN, place of supply, taxable value, GST rate, CGST, SGST, IGST and total in separate columns. Use the correct tax columns based on intra-state or inter-state supply. Download the workbook, keep the sample rows until the structure is clear, then replace them with real rows. Add only the extra columns your team will actually maintain. If an old Excel or CSV file already exists, clean the headers first and then copy rows into this format so formulas, filters and future imports have predictable column names.

  • Open the XLSX in Excel and inspect the sample rows.
  • Replace sample rows with real business data after checking column meaning.
  • Keep one business record per row so filters and summaries work.
  • Use WorkbookWise paid workflows later only when the free format is no longer enough.

Review before sharing or filing

Confirm GST rate, place of supply, invoice numbering, HSN/SAC and mandatory invoice wording with your accountant before sending or filing. This free workbook is an operating register and editable starting point. The workbook includes WorkbookWise source details and a UTM-marked page link in the About sheet so teams can trace where the file came from. Before sharing, remove sample rows, check personal or customer information, confirm formulas you add yourself, and keep a dated copy of the final version if it supports payroll, GST, stock, rent or collection decisions.

  • Remove sample rows before sending to staff, clients or accountants.
  • Check sensitive personal, salary, tenant, student or customer data.
  • Confirm any formulas or compliance assumptions added after download.

FAQ

Questions before downloading.

Is this GST invoice format legally sufficient?

It is an editable Excel starting point. Final invoice wording, tax rate and compliance treatment should be reviewed by the business owner or accountant.

Can I use it without logging in?

Yes. The free format download is available without login and includes a WorkbookWise About sheet.

Does it calculate GST automatically?

This free format keeps the fields clear for review. You can add formulas or use a prepared WorkbookWise template if you need more automation.

Can I open it in Google Sheets?

Most basic workbook fields open in Google Sheets, but the file is provided as an Excel XLSX download.

What should I check before using this GST invoice format in Excel?

Remove sample rows, confirm the columns match your workflow, and review tax, payroll, legal, customer or employee details with the right person before using the workbook as final business evidence.

Related pages

Related formats and guides.

GST invoice template

Open the prepared template page.

Open

GST invoice guide

Read the invoice tracking workflow.

Open

Import old invoice rows

Move old Excel or CSV rows into a cleaner structure.

Open

GST Sales Register Format

Use this GST sales register format when monthly invoice rows need to be reviewed together for sales, tax and payment follow-up.

Open

Rent Receipt Format

Use this rent receipt format when monthly rent records need a clear Excel structure for receipt tracking, payment confirmation or document preparation.

Open

Stock Register Format

Use this stock register format when inventory needs to stay in Excel but the team needs clearer item, supplier, stock and reorder fields.

Open

Download the free Excel format.

Start with the XLSX file, then use WorkbookWise custom workflows only when this simple format is no longer enough.

Download free XLSX