How to Create Tax Invoices in Excel

Katherine Jul 11, 2026

Creating a tax invoice in Excel can be a straightforward process once you understand the key elements and structure required. This guide will walk you through the steps to create a professional and accurate tax invoice using Microsoft 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 a basic understanding of Excel, including how to create and format cells, and how to use formulas for calculations. With that in mind, let's get started.

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

Setting Up Your Tax Invoice Template

To begin, open a new or existing Excel workbook. The first step is to set up the basic structure of your tax invoice, which typically includes the following sections:

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

1. **Header**: Company name, logo, address, and contact information. You can use the 'Merge & Center' function to center your header across multiple cells.

Formatting Your Invoice

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

Excel offers various formatting options to make your invoice visually appealing and professional. Here are some tips:

1. **Use Styles**: Excel's built-in styles can help you maintain a consistent look throughout your invoice. You can find these in the 'Home' tab under 'Styles'.

2. **Apply Borders and Shading**: To separate sections and make your invoice easier to read, apply borders and shading to relevant cells. You can find these options in the 'Home' tab under 'Borders' and 'Fill Color'.

Commercial Tax Invoice Template Excel
Commercial Tax Invoice Template Excel

Adding Your Invoice Details

Next, include the following details in your invoice:

1. **Invoice Number**: A unique identifier for each invoice. You can use the 'AutoFill' feature to generate consecutive numbers.

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

2. **Date**: The date the invoice was issued. You can use the 'TODAY()' function for automatic updates.

3. **Bill To**: The recipient's name, address, and contact information.

Easy to use invoice template for Excel
Easy to use invoice template for Excel
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Free Invoice Template  | Download for free
Free Invoice Template | Download for free
How To Create an Invoice in Excel + Free Invoice Template Download
How To Create an Invoice in Excel + Free Invoice Template Download
Small Business Invoice Template for Home Office | Download Now
Small Business Invoice Template for Home Office | Download Now
Auto-Calculating Excel Invoice Template for Small Business (Digital Download)
Auto-Calculating Excel Invoice Template for Small Business (Digital Download)
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
Tax Invoice
Finance Templates “Simple Invoice Template (Google Sheets)”
Finance Templates “Simple Invoice Template (Google Sheets)”
Download UK VAT Multiple Tax Invoice Excel Template
Download UK VAT Multiple Tax Invoice Excel Template
Doing Your Taxes? 5 Microsoft Excel Formulas You Must Know
Doing Your Taxes? 5 Microsoft Excel Formulas You Must Know
an invoice form is shown with the name and number
an invoice form is shown with the name and number
Blank Tax Invoice Template
Blank Tax Invoice Template
Tally Invoice Format Excel Download
Tally Invoice Format Excel Download
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
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
Professional Business Invoice Template Excel | Editable Tax Invoice | A4 Print Ready
Professional Business Invoice Template Excel | Editable Tax Invoice | A4 Print Ready
Tax Invoice Templates | Quickly Create Free Tax Invoices
Tax Invoice Templates | Quickly Create Free Tax Invoices
Professional Invoice Template | Customizable Excel Billing Sheet
Professional Invoice Template | Customizable Excel Billing Sheet
Invoicing Made Easy! 100+ Free Invoicing Templates!
Invoicing Made Easy! 100+ Free Invoicing Templates!

Entering Your Sales Information

Now that you have the basic structure in place, it's time to add the sales information that makes up the bulk of your tax invoice.

1. **Item/Description**: A brief description of the goods or services provided.

Using Tables for Better Organization

To keep your sales information organized, consider converting your data range into a table. This will allow you to apply formatting, sort, and filter your data easily. To convert your data into a table, select the range and click on 'Format as Table' in the 'Home' tab.

Calculating Tax and Total Amount

To calculate the tax and total amount, use the following formulas:

1. **Tax**: `= Quantity * Price * Tax Rate`. Assuming your tax rate is 10%, the formula would look like this: `= B2 * C2 * 0.10`.

2. **Total**: `= Quantity * Price`. The formula would look like this: `= B2 * C2`.

Adding Final Touches

Before finalizing your invoice, add the following sections:

1. **Subtotal**: The total amount before tax. You can use the 'SUBTOTAL' function to calculate this.

2. **Tax**: The total tax amount calculated earlier.

3. **Total**: The final amount due. This can be calculated as `= Subtotal + Tax`.

Creating a Summary Table

For a clear overview, create a summary table at the bottom of your invoice, including the subtotal, tax, and total. You can use the 'SUM' function to calculate these totals.

Adding Payment Terms and Notes

Include your payment terms and any additional notes at the bottom of your invoice. This could include your preferred payment method, due date, and any special instructions.

Congratulations! You've now created a professional tax invoice in Excel. Regularly review and update your invoice template to ensure it remains accurate and up-to-date. Happy invoicing!