How to Create GST Tax Invoices in Excel

Katherine Jul 11, 2026

Creating a GST tax invoice in Excel can be a straightforward process once you understand the required elements and structure. GST, or Goods and Services Tax, is a comprehensive, multi-stage tax levied on every value addition. As a business owner, generating accurate GST invoices is crucial for tracking taxes and complying with government regulations. Let's dive into the step-by-step process of creating a GST tax invoice in Excel.

GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 20)
GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 20)

Before we begin, ensure you have Microsoft Excel installed on your computer. You'll also need to gather some essential information, such as your business's GSTIN (GST Identification Number), the recipient's GSTIN (if registered), the invoice date, and the details of the goods or services being sold, including their HSN/SAC codes, quantities, rates, and tax amounts.

Invoice Templates for Freelancers 2025 Guide and Free Downloads
Invoice Templates for Freelancers 2025 Guide and Free Downloads

Setting Up the Excel Workbook

To start, open a new or existing Excel workbook. You'll want to create a new sheet for your GST invoices, so click on the "+" icon at the bottom of the sheet list to add a new one. Rename this sheet to "GST Invoices" for easy reference.

One Click Save & Print GST Invoice Software in MS-Excel full Automatic
One Click Save & Print GST Invoice Software in MS-Excel full Automatic

Now, let's set up the headers for our GST invoice. In the first row (A1 to L1), enter the following headers in bold text, using the following columns:

  • A1: Invoice Number
  • B1: Date
  • C1: GSTIN of Supplier
  • D1: Name and Address of Supplier
  • E1: GSTIN of Recipient
  • F1: Name and Address of Recipient
  • G1: Invoice Date
  • H1: Due Date
  • I1: Place of Supply
  • J1: HSN/SAC Code
  • K1: Description of Goods/Services
  • L1: Rate, Quantity, Tax Amount, Total Amount
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file

Filling in the GST Invoice Details

Now that we have our headers in place, let's fill in the details of our GST invoice. Starting from row 2, enter the relevant information for each column:

For example, in cell A2, enter the invoice number. In cell B2, enter the invoice date. In cells C2 and D2, enter your business's GSTIN and address, respectively. If the recipient is also registered under GST, enter their GSTIN and address in cells E2 and F2. If not, leave these cells blank.

an invoice form is shown with yellow accents
an invoice form is shown with yellow accents

Adding the Goods/Services Table

In the next available row (e.g., row 3), enter the following headers for the goods/services table in columns J to L:

  • J3: HSN/SAC Code
  • K3: Description of Goods/Services
  • L3: Rate, Quantity, Tax Amount, Total Amount
Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel

Below these headers, enter the details of the goods or services being sold. For each item, enter the HSN/SAC code, description, rate, and quantity in columns J, K, and L, respectively. You can use the SUMIF function to automatically calculate the total amount for each item.

Calculating Tax and Total Amount

Download 10 GST Invoice Templates in Excel - ExcelDataPro
Download 10 GST Invoice Templates in Excel - ExcelDataPro
Calculation of GST TAX | Gst calculation in Excel | Excel Tutorials |excel 2023 #exceltips2023#excel
Calculation of GST TAX | Gst calculation in Excel | Excel Tutorials |excel 2023 #exceltips2023#excel
Free Excel Invoice Template Gst
Free Excel Invoice Template Gst
Automatic Free GST Invoice Format in Excel (Download .xlsx file)
Automatic Free GST Invoice Format in Excel (Download .xlsx file)
GST Invoice Format in Excel, Word (Format No. 21) .xls, .doc file
GST Invoice Format in Excel, Word (Format No. 21) .xls, .doc file
Download 10 GST Invoice Templates in Excel - ExcelDataPro
Download 10 GST Invoice Templates in Excel - ExcelDataPro
Very Useful GST Invoice Format in Excel (Download .xlsx file)
Very Useful GST Invoice Format in Excel (Download .xlsx file)
Tax Invoice Template | Free Word Templates
Tax Invoice Template | Free Word Templates
How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial
an invoice form with the company's name and number on it, which is
an invoice form with the company's name and number on it, which is
Build your customer GST Tax Invoice easily with Spreadsheet
Build your customer GST Tax Invoice easily with Spreadsheet
Download Monthly GST Input Output Tax Report Excel Template - ExcelDataPro
Download Monthly GST Input Output Tax Report Excel Template - ExcelDataPro
Tally Invoice Customization TDL - (Company Name and GST No. Customize)
Tally Invoice Customization TDL - (Company Name and GST No. Customize)
Easy to Use of GST Invoice Format in Excel (Download .xlsx file)
Easy to Use of GST Invoice Format in Excel (Download .xlsx file)
Download 10 GST Invoice Templates in Excel - ExcelDataPro
Download 10 GST Invoice Templates in Excel - ExcelDataPro
Latest Design GST Format Download in .xlsx (Excel File)
Latest Design GST Format Download in .xlsx (Excel File)
Top Best Design of GST Invoice Format in Excel (Download .xlsx file)
Top Best Design of GST Invoice Format in Excel (Download .xlsx file)
Automatic Tax Calculation GST Invoice Format in Excel (Download .xlsx file)
Automatic Tax Calculation GST Invoice Format in Excel (Download .xlsx file)
Raja welding Enterprises
Raja welding Enterprises
New GST Invoice Format in Excel (Download .xlsx file)
New GST Invoice Format in Excel (Download .xlsx file)

To calculate the tax amount, you'll need to know the applicable GST rates. In a new row (e.g., row 5), enter the following headers in columns J to L:

  • J5: Tax Rate
  • K5: Taxable Value
  • L5: Tax Amount

Enter the applicable GST rates in column J, and use the SUMIF function in column K to calculate the taxable value for each rate. Then, use the formula "=K5*J5/100" in column L to calculate the tax amount for each rate.

Finally, in a new row (e.g., row 6), enter the following headers in columns J to L:

  • J6: Grand Total
  • K6: Total Tax Amount
  • L6: Grand Total Amount

Use the SUM function to calculate the grand total and total tax amount, and then use the formula "=J6+K6" to calculate the grand total amount.

Formatting the GST Invoice

To make your GST invoice more presentable, you can apply some basic formatting. Merge cells for the headers, increase the font size for better readability, and use borders to separate sections. You can also add your business logo and contact information to the invoice.

Saving and Printing the GST Invoice

Once you've filled in all the details and applied the necessary formatting, save your workbook as an Excel file. To print the GST invoice, select the range of cells containing the invoice details (e.g., A1 to L6), and click on "File" > "Print." Make sure to choose the appropriate paper size and orientation, and adjust the margins if necessary. Preview the invoice before printing to ensure it looks as expected.

Creating GST tax invoices in Excel can save you time and help you maintain accurate records. By following this step-by-step guide, you'll be able to generate professional-looking invoices that comply with GST regulations. As your business grows, consider using accounting software that can automate the invoice generation process and provide additional features for managing your finances. Happy invoicing!