"Create Tax Invoices in Excel: Step-by-Step Guide"

Katherine Jul 11, 2026

Creating a tax invoice bill in Excel can be a straightforward process once you understand the basic structure and features of the software. This guide will walk you through the steps to create a professional and accurate tax invoice bill using Excel.

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

Before we dive into the details, ensure you have Microsoft Excel installed on your computer. If not, you can download a free trial or use the online version of Excel through Microsoft 365.

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

Setting Up Your Excel Workbook

Start by opening a new workbook in Excel. You'll see a blank spreadsheet with several sheets. For simplicity, let's work on Sheet1 for this invoice.

Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel

Next, rename the sheet to something more descriptive, like "Tax Invoice Bill". To do this, right-click on the sheet tab at the bottom, select "Rename", and enter the new name.

Defining the Invoice Structure

Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel

Now, let's define the basic structure of your invoice. In Row 1, enter the following headings: "Invoice No.", "Date", "Bill To", "Address", "Phone", "Email", "Subtotal", "Tax", and "Total".

Format these headings by merging the cells, applying bold text, and adjusting the font size for better readability. You can also add some color or border to make the headings stand out.

Adding Client Information

Tax Invoice Template | Free Word Templates
Tax Invoice Template | Free Word Templates

In Row 2, enter the client's information under the corresponding headings. You can use the Merge & Center feature to center the text in the cells. For example, if the client's name is "John Doe", enter it in the "Bill To" cell and merge it with the "Address" cell.

For the "Address", "Phone", and "Email" fields, enter the relevant information in their respective cells. You can use the AutoFit Column feature (right-click on the column header and select "AutoFit Column Width") to adjust the column width for better presentation.

Creating the Invoice Items Table

How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial

Below the client information, starting from Row 6, create a table for the invoice items. In Row 6, enter the following headings: "Item", "Description", "Quantity", "Unit Price", and "Total".

Format these headings by applying bold text, filling the cells with a light color, and adding borders. You can also adjust the column width for better readability.

Free Invoice Template  | Download for free
Free Invoice Template | Download for free
How enter bill in excel | Billing in ms excel | How to prepare tax bill in excel in Tamil
How enter bill in excel | Billing in ms excel | How to prepare tax bill in excel in Tamil
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Excel Invoice Templates and Payment Trackers
Excel Invoice Templates and Payment Trackers
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
an invoice form is shown with yellow accents
an invoice form is shown with yellow accents
One Click Save & Print GST Invoice Software in MS-Excel full Automatic
One Click Save & Print GST Invoice Software in MS-Excel full Automatic
16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
Simple Invoice Template for Fast Business Billing | Download Free Now
Simple Invoice Template for Fast Business Billing | Download Free Now
two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel
Computer Bill Format Template in Excel, Apple Numbers, Pages, Word, Google Docs, Google Sheets - Download | Template.net
Computer Bill Format Template in Excel, Apple Numbers, Pages, Word, Google Docs, Google Sheets - Download | Template.net
Tally Invoice Customization TDL - (Company Name and GST No. Customize)
Tally Invoice Customization TDL - (Company Name and GST No. Customize)
an invoice form is shown with the name and number
an invoice form is shown with the name and number
Finance Templates “Simple Invoice Template (Google Sheets)”
Finance Templates “Simple Invoice Template (Google Sheets)”
GST Invoice Format in Excel, Word (Format No. 21) .xls, .doc file
GST Invoice Format in Excel, Word (Format No. 21) .xls, .doc file
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
Raja welding Enterprises
Raja welding Enterprises
Invoice Template for Google, Excel and Word
Invoice Template for Google, Excel and Word
an invoice form is shown with the name and number on it, as well as
an invoice form is shown with the name and number on it, as well as

Populating the Invoice Items

Starting from Row 7, enter the details of the items you're billing for. In the "Item" column, you can use simple numbers (1, 2, 3, etc.) or enter SKU numbers if you have them. In the "Description" column, provide a brief description of the item or service.

In the "Quantity" and "Unit Price" columns, enter the quantity of the item provided and the price per unit. Excel will automatically calculate the "Total" for each item by multiplying the quantity and unit price.

Calculating Subtotal, Tax, and Total

In Row 11, enter the following formulas to calculate the subtotal, tax, and total:

  • Subtotal: `=SUM(Table1[Total])`
  • Tax: `=Subtotal*0.1` (assuming a 10% tax rate)
  • Total: `=Subtotal+Tax`

Note that you'll need to replace "Table1" with the actual name of your table. To name your table, select any cell in the table, click on the "Home" tab in the ribbon, and click on "Format as Table". In the dialog box that appears, check "My table has headers" and click "OK". Then, right-click on the table and select "Table Name", and enter a name for your table.

Finally, add some branding to your invoice by inserting your company logo, name, and any relevant tagslines or disclaimers. You can also adjust the font, color scheme, and overall design to match your company's branding.

Creating a tax invoice bill in Excel is a simple and efficient way to manage your billing needs. With this guide, you should now be able to create professional and accurate invoices tailored to your business. Happy invoicing!