Learn to Create Tax Invoices in Excel: A Step-by-Step Guide

Walter Jul 15, 2026

In businesses, generating tax invoices is an integral part of the everyday process. While there are numerous tools available for this task, Microsoft Excel remains a popular choice due to its flexibility, accessibility, and widespread use. If you're wondering how to create a tax invoice bill in MS Excel, this guide will walk you through a simple, step-by-step process.

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

The process involves setting up a template with the necessary fields, populating it with appropriate values, and formatting it for professional presentation. Let's dive right in.

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

Setting Up the Template

The first step is to set up your Excel sheet with the necessary fields for a tax invoice. These typically include the sender's and recipient's information, invoice details, itemized services or products, taxes, and subtotals. To ensure consistency, you may want to create this template once and use it repeatedly, updating the values as needed.

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

To set this up, use the following columns in your spreadsheet: A, B, C, D, E, F, G, H, and I. Each of these columns will represent a different section of your invoice, from the header down to the total amount due.

Headers and Business Information

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

In Row 1, insert the headers for your invoice. These might include 'Invoice No.', 'Date of Invoice', 'Due Date', 'Bill To', 'Sent To', etc. In the subsequent rows (2-6), input your business's details, such as your business name, address, phone number, email, and VAT or tax ID, if applicable.

For instance, in cells A1:I1, you would enter the headers. Then, in Row 2, you would enter your business name in cell A2, and so on, following the column pattern.

Invoice Details and Bill To

Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel

In Row 7, enter 'Invoice No.' in cell A7 and input the invoice number in cell B7. In cell C7, enter 'Date of Invoice' and input the current date in cell D7. In cell E7, put 'Due Date' and input the date when the invoice is due in cell F7. Repeat this pattern for 'Bill To', 'Sent To', 'Payment Terms', and 'Currency' in the subsequent rows.

Remember, each row should have a label followed by a corresponding value, maintaining the structure from A to H.

Itemizing Services or Products

Simple Invoice Template for Fast Business Billing | Download Free Now
Simple Invoice Template for Fast Business Billing | Download Free Now

From Row 12 onwards, you'll start itemizing the services or products you've provided. In the first row, insert headers for 'Description', 'Quantity', 'Rate', and 'Total' in cells A12:D12. In the subsequent rows, fill in the details for each service or product.

For example, in cell A13, you would input a description (e.g., 'Website Design'), and in B13, C13, and D13, you would input the quantity, rate, and total for that service, respectively.

One Click Save & Print GST Invoice Software in MS-Excel full Automatic
One Click Save & Print GST Invoice Software in MS-Excel full Automatic
Tax Invoice Template | Free Word Templates
Tax Invoice Template | Free Word Templates
two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel
Download Excel Format of Tax Invoice in GST - GST Invoice Format
Download Excel Format of Tax Invoice in GST - GST Invoice Format
16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
Free Invoice Template  | Download for free
Free Invoice Template | Download for free
Invoice Template for Google, Excel and Word
Invoice Template for Google, Excel and Word
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Free Excel Invoice Template Gst
Free Excel Invoice Template Gst

Calculating Subtotals and Taxes

In Row 16, insert a new section for 'Subtotal' in cell A16. In cell B16, use the SUM function to automatically calculate the total of the 'Total' column (D12:D15). In cells C16 and D16, enter a label (e.g., 'VAT' or 'Tax') and the corresponding rate (e.g., 20% or 0.20). Use the percentage function to calculate the tax amount in cell E16.

You can add more tax lines if necessary, following the same pattern. Once you've accounted for all taxes, insert another row (e.g., Row 18) for 'Total Amount Due', with the label in cell A18 and the sum of subtotal and tax in cell B18.

Once you've filled in all the necessary information, you can format your invoice for a professional look, including adding borders, adjusting font styles, and including graphics, such as a logo at the top. Save this template for future use, updating the invoice number and dates each time you use it.

Tax compliance is a serious responsibility, and using a well-structured template like this can help ensure that you're covering all the essential areas. Whether you're a small business owner or a financial professional, mastering the art of creating tax invoices in Excel is an invaluable skill. Happy invoicing!