How to Create Tax Invoice Bills in MS Excel

Katherine Jul 11, 2026

Creating a tax invoice bill in Microsoft Excel can be a straightforward process, especially with the built-in tools and features Excel offers. A well-structured invoice not only helps in maintaining financial records but also ensures timely payments from your clients. Let's dive into the step-by-step guide on how to create a tax invoice bill in Excel.

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

Before we start, ensure you have a basic understanding of Excel's interface and functions. If you're new to Excel, don't worry; we'll keep the instructions simple and easy to follow.

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 Workbook

First, let's set up your workbook for creating tax invoice bills. Open a new Excel workbook and save it with a relevant name, such as 'TaxInvoiceTemplate'.

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

Next, create headers for your invoice in Row 1. Some common headers include 'Invoice Number', 'Date', 'Client Name', 'Address', 'Phone Number', 'Email', 'Tax ID', 'Items', 'Quantity', 'Rate', 'Tax', 'Total', and 'Due Date'.

Creating the Invoice Number

how to create Bill invoice Entry  in excel with formula
how to create Bill invoice Entry in excel with formula

For the 'Invoice Number' column, you can use the 'AutoFill' feature to generate sequential invoice numbers. In cell A2, enter the first invoice number (e.g., 001). Then, drag the small square in the bottom-right corner of the cell down to copy this value into the cells below.

To make this a series, right-click on the filled cells, select 'Format Cells', go to the 'Number' tab, and under 'Category', choose 'Custom'. In the 'Type' field, enter '000' and click 'OK'. This will format your invoice numbers with leading zeros.

Formatting Dates

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

For date columns, select the cells and right-click to format them as dates. This will ensure your dates display correctly and can be sorted easily.

To insert the current date automatically, use the 'TODAY()' function. In the 'Date' cell, enter '=TODAY()' and press Enter. The cell will display the current date, which updates automatically each time you open the workbook.

Adding Client Information

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

Now, let's add a table for client information. In Row 3, enter the client's name, address, phone number, email, and tax ID. You can use the 'Merge & Center' function to combine cells for the client's name and address.

To make adding new clients easier, you can use the 'VLOOKUP' function to pull client information from another sheet or database. This way, you don't have to re-enter the same information each time you create an invoice.

16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
GST Invoice Format in Excel, Word (Free Download) .xls, .doc file
How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Invoice Templates for Freelancers 2025 Guide and Free Downloads
Invoice Templates for Freelancers 2025 Guide and Free Downloads
How To Create an Invoice in Excel + Free Invoice Template Download
How To Create an Invoice in Excel + Free Invoice Template Download
Simple Invoice Template for Fast Business Billing | Download Free Now
Simple Invoice Template for Fast Business Billing | Download Free Now
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 is shown on the computer screen, and it appears to be filled
an invoice form is shown on the computer screen, and it appears to be filled
Invoice Template for Google, Excel and Word
Invoice Template for Google, Excel and Word
Effortless Business Invoices Template – Download Now!
Effortless Business Invoices Template – Download Now!
Invoice Template (Excel, Editable, Printable)
Invoice Template (Excel, Editable, Printable)
Professional Business Invoice Template Excel | Editable Tax Invoice | A4 Print Ready
Professional Business Invoice Template Excel | Editable Tax Invoice | A4 Print Ready
an invoice form is shown with the words tax written on it, and there are
an invoice form is shown with the words tax written on it, and there are
Tally Invoice Format Excel Download
Tally Invoice Format Excel Download
Free Excel Invoice Template Gst
Free Excel Invoice Template Gst
Download UK VAT Multiple Tax Invoice Excel Template
Download UK VAT Multiple Tax Invoice Excel Template
FREE Tally Bill Format (Word, Excel and PDF)
FREE Tally Bill Format (Word, Excel and PDF)
Billing of GST Tax Invoice Format in Excel (Download .xlsx file)
Billing of GST Tax Invoice Format in Excel (Download .xlsx file)

Creating the Invoice Table

Below the client information, create a table for the items, quantities, rates, taxes, and totals. In the first row, enter headers like 'Items', 'Quantity', 'Rate', 'Tax', and 'Total'.

To calculate the total for each item, use the 'SUM' function. In the 'Total' cell for each item, enter the formula '=B2*C2' (assuming 'Quantity' is in Column B and 'Rate' is in Column C). This will multiply the quantity by the rate to give the total for each item.

Adding Taxes

To add taxes to your invoice, use the 'VLOOKUP' function to pull the tax rate from a separate sheet or database. In the 'Tax' cell for each item, enter the formula '=VLOOKUP(C2, TaxRates, 2, FALSE)' (assuming your tax rates are in a sheet called 'TaxRates' and the tax rate is in the second column).

Then, create a new cell for the 'Subtotal' by entering the formula '=SUM(D2:D6)' (assuming your item totals are in Column D, and the last item is in Row 6). In the 'Tax' cell, enter the formula '=Subtotal*TaxRate' to calculate the total tax.

Finalizing Your Invoice

Below the invoice table, add a 'Total' cell and enter the formula '=Subtotal+Tax' to calculate the grand total of the invoice.

Finally, add a 'Due Date' cell and enter the formula '=Date+30' to set the due date for the invoice. You can adjust this value as needed.

Customizing Your Invoice

To make your invoice more professional, you can add a logo, change the font, and adjust the colors. You can also use conditional formatting to highlight overdue invoices or add a watermark to indicate paid invoices.

To print your invoice, select the range you want to print (including the client information and invoice table), click the 'File' tab, and select 'Print'. You can also save your invoice as a PDF for easy sharing.

With this comprehensive guide, you're now equipped to create professional tax invoice bills in Microsoft Excel. Happy invoicing!