How to Create a Simple Invoice in Excel

Katherine Jul 11, 2026

Creating an invoice is a crucial step in managing your business finances. While there are numerous software solutions available, Microsoft Excel remains a popular choice due to its versatility and widespread use. Here's a step-by-step guide on how to create a simple invoice in Excel.

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

Before we dive into the process, ensure you have Microsoft Excel installed on your computer. If you're using an older version, the steps might vary slightly, but the basic principles remain the same.

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

Setting Up Your Invoice Template

To start, open a new or existing Excel workbook. The first step is to set up your invoice template, which will include the necessary fields for your invoice details.

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

In the first row, enter the following headers: Invoice Number, Date, Due Date, Bill To, Address, City, State, Zip, Phone, Email, Item, Description, Quantity, Rate, and Total. You can adjust these headers to fit your specific needs.

Formatting Your Invoice

Cost Tracking Spreadsheet - how to create an invoice in excel Hindi
Cost Tracking Spreadsheet - how to create an invoice in excel Hindi

Next, format your invoice to make it visually appealing and easy to read. You can merge cells, add borders, and change the font size and style to achieve this.

To merge cells, select the cells you want to merge, right-click, and select 'Merge & Center'. To add borders, select the cells you want to outline, click on 'Border' in the 'Home' tab, and choose the style you prefer.

Adding Your Business Information

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

At the top of your invoice, include your business name, address, phone number, and email address. You can also add your logo if you have one.

To make this a reusable template, you can place this information in the header or footer of your Excel workbook. This way, it will appear on every page of your invoice.

Populating Your Invoice with Data

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 that your template is set up, it's time to populate it with the relevant data for your invoice.

Start by entering the invoice number, date, and due date in the respective fields. Then, enter the customer's information, including their name, address, city, state, zip code, phone number, and email address.

40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
16 Free Invoice Templates - Editable Excel & PDF
16 Free Invoice Templates - Editable Excel & PDF
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
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
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
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Small Business Invoice Template for Home Office | Download Now
Small Business Invoice Template for Home Office | Download Now
Free Invoice Template for Excel
Free Invoice Template for Excel
How to Customize Invoices in QuickBooks
How to Customize Invoices in QuickBooks
Free Invoice Template using Excel - Download today - Create, print or save PDF invoices instantly using this
Free Invoice Template using Excel - Download today - Create, print or save PDF invoices instantly using this
Invoice Templates Made Simple with Google Sheets
Invoice Templates Made Simple with Google Sheets
Sales Invoice Excel | Templates at allbusinesstemplates.com
Sales Invoice Excel | Templates at allbusinesstemplates.com
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
Free Invoice Template - Printable Editable Spreadsheet
Free Invoice Template - Printable Editable Spreadsheet
Step-by-Step Guide: Create a Professional Invoice in Google Sheets Easily!
Step-by-Step Guide: Create a Professional Invoice in Google Sheets Easily!
Excel Invoice Templates and Payment Trackers
Excel Invoice Templates and Payment Trackers
Free Excel Invoice Templates
Free Excel Invoice Templates
Finance Templates “Simple Invoice Template (Google Sheets)”
Finance Templates “Simple Invoice Template (Google Sheets)”

Adding Invoice Items

Next, enter the details of the items or services you're invoicing for. In the 'Item' column, enter a unique identifier or code for each item. In the 'Description' column, provide a brief description of the item or service.

In the 'Quantity' column, enter the quantity of each item or the number of hours worked for each service. In the 'Rate' column, enter the price per item or the hourly rate. The 'Total' column will automatically calculate the total cost for each item or service based on the quantity and rate.

Calculating Subtotals and Tax

Below your list of items, you can add subtotals and tax calculations. In a new row, enter 'Subtotal' in the 'Description' column and use the SUM function to add up the totals from your items.

To calculate tax, enter 'Tax' in the 'Description' column and use the formula '=Subtotal * Tax Rate' (replace 'Tax Rate' with your applicable tax rate). The 'Total' column will automatically calculate the final amount due.

Customizing Your Invoice

Excel offers numerous ways to customize your invoice to match your business's branding. You can change the color scheme, add a background image, or use conditional formatting to highlight important information.

To change the color scheme, select the cells you want to format, click on 'Fill' in the 'Home' tab, and choose the color you prefer. To add a background image, right-click on the worksheet, select 'Page Layout', click on 'Background', and choose the image you want to use.

Using Conditional Formatting

Conditional formatting allows you to apply different formatting based on the value of a cell. For example, you can highlight cells in red if the due date has passed or if the total amount is overdue.

To use conditional formatting, select the cells you want to format, click on 'Conditional Formatting' in the 'Home' tab, and choose the rule you want to apply. You can then customize the formatting and the conditions for the rule.

Once you've finished customizing your invoice, save it as an Excel template (.xltx) for future use. You can then open the template, populate it with the relevant data, and save it as a new invoice (.xlsx) for each customer.

Creating a simple invoice in Excel is a straightforward process that can be streamlined with the right template and formatting. By following this guide, you'll be able to create professional-looking invoices that help you manage your business finances effectively.