"Create Invoice Template in Excel: A Step-by-Step Guide"

Walter Jul 15, 2026

Creating an invoice template in Excel is a practical skill that streamlines your billing process. With an efficient template, you can save time, reduce errors, and maintain a professional image. Let's delve into step-by-step instructions to create your own invoice template in Excel.

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

Before we dive in, ensure you have a basic understanding of Excel. Familiarize yourself with cells, formulas, and basic functions. Also, have your business and invoice details ready, such as your business name, address, phone number, and payment terms.

an invoice form with the words invoice written on it
an invoice form with the words invoice written on it

Setting Up Your Invoice Template

First, let's configure your Excel workbook for invoicing.

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

Create a new workbook and name it "Invoice Template." At the top, input your business details like name, address, and contact information. You may also include your logo or any branding elements you wish to showcase.

Setting the Layout

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

Excel is widely used for its grid-like layout. It's essential to utilize this feature effectively. Set a clear outline for your invoice with sections like 'Invoice Details', 'Bill To', 'Invoice Summary', and 'Payment Terms'.

Remember, your layout should be clean, organized, and easy to read. Use clear font styles and sizes, and don't hesitate to add some color or shadows to differentiate sections.

Using Merge and Center for Headers

How to Create an Invoice in Excel
How to Create an Invoice in Excel

The 'Merge and Center' function is handy for creating headers. It allows you to stretch a cell's contents across multiple cells. Use this to create a professional-looking header with your business information.

To do this, select the cells you want to merge, then click on 'Merge & Center' in the 'Home' tab. Type in your business name, address, and other relevant details.

Adding Invoice Details

two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel

Now, let's insert the specific invoice details.

Create a table with rows and columns to include invoice number, date, bill to name, address, and other relevant fields. Use 'AutoFit Column Width' to ensure your text fits well in the cells.

How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC
an invoice form with two arrows on it
an invoice form with two arrows on it
How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial
16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
Free Invoice Template - Printable Editable Spreadsheet
Free Invoice Template - Printable Editable Spreadsheet
Small Business Invoice Template for Home Office | Download Now
Small Business Invoice Template for Home Office | Download Now
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
Sales Invoice Excel | Templates at allbusinesstemplates.com
Sales Invoice Excel | Templates at allbusinesstemplates.com

Invoice Number and Date

For the invoice number, you could use a simple incrementing formula like '=A2+1' (assuming A1 is your first invoice number). For the date, use the 'TODAY()' function, an inbuilt Excel function that gives the current date.

Bill To Details

For 'Bill To' details, use the 'Logout' function to create a dropdown menu for your clients. This function prevents typos and ensures all client details remain organized.

Begin by listing your clients in a separate sheet or section. Then, use the 'Logout' function to create a dropdown list with those entries.

Creating the Invoice Summary

The invoice summary is the heart of your invoice, displaying products/services, quantities, costs, taxes, discounts, and total amounts.

Use the 'Insert Table' function to create a table that fits your needs. The first column could contain your products/services, the second the quantity, the third the rate, and so on. Use mathematical formulas to calculate the total for each line item.

Adding Taxes

Taxes can be added as separate line items or included in the rate. Excel offers various tax calculation methods. To add taxes, use the '=' symbol followed by your tax rate (e.g., '=B2*0.08' for an 8% tax rate).

Calculation of Totals

Subtotal, tax, discount, and total amounts can be calculated using Excel's built-in functions. Use 'SUMIFS' to add up values based on certain criteria. For discounts, use a formula like '=C2*D2*E2/100', where C2, D2, and E2 are the units, rate, and discount rate, respectively.

Payment Terms and Notes

The final sections of your invoice template should include your payment terms and notes. Keep them clear and concise.

To add a note, insert a text box or use cells to create a note section. For payment terms, use a similar approach, ensuring your terms are clear and easy to understand.

Congratulations, you've created a comprehensive invoice template in Excel! Regularly review and update your template as your business grows and changes. Happy invoicing!