How to Create a Custom Excel Invoice Template

Katherine Jul 11, 2026

Creating an invoice template in Excel can save you time and ensure consistency in your billing process. Whether you're a small business owner, a freelancer, or an individual who needs to invoice clients, having a well-structured invoice template is essential. Let's guide you through the process of creating an Excel invoice template step-by-step.

Invoice Format in Excel | Free Download
Invoice Format in Excel | Free Download

Before we dive into the details, ensure you have Microsoft Excel installed on your computer. For this guide, we'll be using Excel 2016, but the process is similar in other versions. Let's get started!

How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC

Setting Up Your Invoice Template

To begin, open a new Excel workbook and click on the 'File' tab. Select 'Save As' and choose a location to save your new invoice template. Name it 'Invoice Template' or something similar that you'll easily recognize.

Free Invoice Template  | Download for free
Free Invoice Template | Download for free

Now, let's set up the basic structure of your invoice template. In the first row, type the following headers: 'Invoice Number', 'Date', 'Client Name', 'Client Address', 'Item Description', 'Quantity', 'Unit Price', 'Tax Rate', and 'Total'. Format these headers as you like, using bold text and fill colors for better readability.

Invoice Header

How To Create an Invoice in Excel + Free Invoice Template Download
How To Create an Invoice in Excel + Free Invoice Template Download

In the second row, start entering the fixed information that will appear on every invoice. This includes your business name, address, phone number, and email address. You can also add a logo by inserting a picture and resizing it as needed.

To make this information dynamic, you can use Excel's built-in features like text wrapping and merging cells. For instance, you can merge cells for your business name and address, and wrap text to fit the content within the cell.

Invoice Number and Date

16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF

In the 'Invoice Number' and 'Date' columns, you'll want to insert unique values for each invoice. To do this, use Excel's auto-increment feature for the invoice number and a date function for the current date.

For the invoice number, click on the cell where you want the number to start (e.g., A3), then click on the 'Home' tab in the ribbon. In the 'Editing' group, click on 'AutoFill', then select 'Fill Series'. In the dialog box that appears, choose 'Linear' and enter the starting number (e.g., 1). Click 'OK' to create an auto-incrementing series.

Invoice Details

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

Now that you have the header and basic information set up, it's time to add the details of the items or services you're invoicing. You can use Excel's tables feature to make this process more manageable.

To create a table, select the range of cells that will contain your invoice details (e.g., A4:I100). Click on the 'Home' tab in the ribbon, then click on 'Format as Table'. Choose a table style and click 'OK'. In the dialog box that appears, ensure 'My table has headers' is checked, and click 'OK'.

Cost Tracking Spreadsheet - how to create an invoice in excel Hindi
Cost Tracking Spreadsheet - how to create an invoice in excel Hindi
Invoice Templates for Freelancers 2025 Guide and Free Downloads
Invoice Templates for Freelancers 2025 Guide and Free Downloads
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial
Small Business Invoice Template for Home Office | Download Now
Small Business Invoice Template for Home Office | Download Now
Sales Invoice Excel | Templates at allbusinesstemplates.com
Sales Invoice Excel | Templates at allbusinesstemplates.com
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Free Invoice Template -  How To Create an Invoice Using Google Docs Invoice Template
Free Invoice Template - How To Create an Invoice Using Google Docs Invoice Template
Automated Invoice in Excel
Automated Invoice in Excel
Simple Invoice Template for Fast Business Billing | Download Free Now
Simple Invoice Template for Fast Business Billing | Download Free Now
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
Finance Templates “Simple Invoice Template (Google Sheets)”
Finance Templates “Simple Invoice Template (Google Sheets)”
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
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
Invoicing Made Easy! 100+ Free Invoicing Templates!
Invoicing Made Easy! 100+ Free Invoicing Templates!
Step-by-Step Guide: Create a Professional Invoice in Google Sheets Easily!
Step-by-Step Guide: Create a Professional Invoice in Google Sheets Easily!
an invoice form is shown with the company's name and address on it
an invoice form is shown with the company's name and address on it
50+ Free Excel Templates to Make Your Life Easier - Updated June 2026
50+ Free Excel Templates to Make Your Life Easier - Updated June 2026

Table Columns

Your table should now have the headers you created earlier. You can add or remove columns as needed, but ensure the 'Total' column is the last one. This is where Excel will automatically calculate the subtotal for each item based on the 'Quantity' and 'Unit Price'.

To add a new column, right-click on the table and select 'Insert'. To remove a column, right-click on the column header and select 'Delete'.

Table Rows

To add a new row for an item or service, click on the last cell in the 'Item Description' column and press 'Tab'. This will insert a new row below the last one. You can then enter the item description, quantity, and unit price for each row.

To delete a row, select the entire row (click on the row number at the left of the screen) and press 'Delete'.

Calculating Tax and Total

With your invoice details in place, it's time to calculate the tax and total amounts. You can use Excel's built-in functions to do this automatically.

In the 'Tax Rate' column, enter the tax rate as a decimal (e.g., 0.07 for 7%). In the 'Total' column, use the following formula: `= Quantity * Unit Price * (1 + Tax Rate)`. This will calculate the total amount for each item, including tax.

Subtotal and Grand Total

To calculate the subtotal and grand total, insert new rows below your table and use the 'SUBTOTAL' function. In the first new row, enter the label 'Subtotal'. In the 'Total' column, enter the following formula: `=SUBTOTAL(9, Table1[Total])`. This will calculate the subtotal of all items in the table.

In the next row, enter the label 'Tax'. In the 'Total' column, enter the following formula: `=SUBTOTAL(9, Table1[Total]) * Tax Rate`. This will calculate the total tax amount.

Finally, in the last row, enter the label 'Grand Total'. In the 'Total' column, enter the following formula: `=Subtotal + Tax`. This will calculate the grand total of the invoice.

Congratulations! You've now created a comprehensive Excel invoice template that will save you time and ensure consistency in your billing process. You can customize the template further by adding payment terms, due dates, or other relevant information. Once you're satisfied with your template, save it as an Excel macro-enabled workbook (.xlsm) to preserve the auto-increment feature for invoice numbers. Happy invoicing!