How to Create Tax Invoices in Excel

Walter Jul 15, 2026

Nobody likes completing taxes, but it's a necessary part of running a business or managing finances. It's crucial to keep accurate records of your transactions, including income and expenses. One way to do this is by creating a tax invoice bill in Excel. This not only helps in tracking your financial transactions but also comes in handy when filing taxes.

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

Microsoft Excel, a popular spreadsheet program, offers numerous features to simplify this task. In this guide, we'll walk you through the steps to create a tax invoice bill template using Excel. We'll cover essential elements like date, invoice number, description of goods or services, quantities, prices, taxes, and subtotals. Let's dive in!

Excel Invoice Templates and Payment Trackers
Excel Invoice Templates and Payment Trackers

Setting Up Your Excel Workbook for Tax Invoice Bills

Before you start creating your invoice template, it's essential to set up your Excel workbook correctly. Here's how:

Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel

1. Open a new Excel workbook. You can use a blank workbook or create a new worksheet in an existing one.

Defining Invoice Number

GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file

As you'll be creating multiple invoices, it's crucial to have a unique invoice number for each. You can set up this feature using Excel's auto-increment feature:

1. In cell A1, type 'Invoice Number' as the header. 2. In cell A2, type the starting invoice number, e.g., 'INV-001'. 3. In cell A3, type '=A2+1'. This creates an auto-increment formula that will add 1 to the previous invoice number each time you copy it down.

Adding Essential Invoice Details

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

Next, include other essential details like date, client name, and your business information:

1. In cell B1, type 'Date' and in cell B2, insert the current date using the '=TODAY()' function. 2. In cell C1, type 'Client Name', and in cell C2, type the recipient's name or leave it blank if you'll fill this in manually for each invoice. 3. Below these headers, add rows for your business information, such as name, address, phone number, and email.

Designing Your Invoice Table

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

Now, let's set up the table where you'll list the goods or services, quantities, prices, and taxes.

1. In the first row, starting from cell D1, type 'Description', 'Quantity', 'Price', 'Tax Rate', and 'Amount'. The 'Amount' column will automatically calculate the total for each line item using the 'Quantity' and 'Price' columns.

two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel
Free Invoice Template  | Download for free
Free Invoice Template | Download for free
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Tax Invoice Template | Free Word Templates
Tax Invoice Template | Free Word Templates
16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
Invoice Template for Google, Excel and Word
Invoice Template for Google, Excel and Word
Simple Invoice Template for Fast Business Billing | Download Free Now
Simple Invoice Template for Fast Business Billing | Download Free Now
How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC
Free Excel Invoice Template Gst
Free Excel Invoice Template Gst

Quantity and Price Columns

In the second row:

1. In cell D2, type or copy-paste the description of the first item or service. 2. In cell E2, type the quantity provided. 3. In cell F2, type the price per unit. 4. To ensure accurate calculations, format these cells as Number with zero decimal places.

Tax Rate and Amount Columns

In the third row:

1. In cell G2, set up a drop-down list for tax rates. This allows you to select the applicable tax rate for each item (e.g., 5%, 10%, 15%). 2. In cell H2, enter the formula '=E2*F2*G2' to calculate the amount for each line item. 3. Format cell H2 as Currency. This formats the amount in the currency you've set in Excel's regional settings.

Copy these four rows down to the number of rows you expect to use, then enter line items as needed.

Subtotal, Tax, and Total Rows

At the bottom of your invoice table:

1. In cell Hxx (where xx is the last row of your invoice table), type '=SUM(H2:Hxx)' to calculate the subtotal. 2. In a new row below, type 'Tax' and in the next cell, use the formula '=Subtotal*G2' to calculate the total tax based on the tax rate. 3. In the row below, type 'Total' and in the next cell, use the formula '=Subtotal+Hxx' to calculate the grand total including tax.

Formatting Your Invoice

Finally, format your invoice to make it visually appealing:

1. Use the 'Merge & Center' feature to combine cells for headers and totals. 2. Apply styling like bold text, different font sizes, and fill colors to make essential elements stand out. 3. Consider adding a logo or other graphics to make your invoice look more professional.

That's it! Now you have an Excel invoice template you can use for your taxes or any other required billing. It's essential to maintain this template, keeping it up-to-date with the latest tax rates and formatting adjustments as needed. Happy billing, and remember, staying organized is key to successful financial management.