How to Create a Simple Invoice in Excel

Katherine Jul 11, 2026

Creating an invoice is a crucial step in tracking your business transactions. While there are numerous software solutions available, Microsoft Excel remains a popular choice due to its versatility and accessibility. Today, we'll guide you through creating a simple invoice in Excel, ensuring you have a professional and organized document to send to your clients.

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 steps, make sure you have Microsoft Excel installed on your computer. If you're using a Mac, you can find Excel in the Applications folder or by searching for it in Spotlight. For Windows users, you can access Excel through the Start menu or by searching for it in the search bar.

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

Setting Up Your Invoice Template

To create a simple invoice in Excel, we'll first need to set up a basic template. This template will serve as the foundation for your invoices, ensuring consistency and professionalism.

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

Open a new Excel workbook and save it as a template, for example, "Invoice Template". This will allow you to reuse the template for future invoices without having to set it up each time.

Header Information

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

In the first row, enter your business name, address, phone number, and email address. You can use the Merge & Center function to center the text and make it stand out. To do this, select the cells, click on the Home tab, and click on Merge & Center in the Alignment group.

For example, if your business is called "GreenLeaf Designs", your header information might look like this:

GreenLeaf Designs
123 Main Street
Anytown, USA 12345
(123) 456-7890
info@greenleafdesigns.com

Invoice Details

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, create headers for the invoice details. These will include Invoice Number, Date, Client Name, and Client Address. You can use the Merge & Center function again to center the text and make it stand out.

Your invoice details row might look like this:

Invoice Number	Date	Client Name	Client Address

Populating Your Invoice Template

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

Now that you have your template set up, it's time to populate it with the specific details of the invoice you want to create.

For each invoice, enter the relevant information in the corresponding cells. For example, if you're creating an invoice for "John Doe" with the invoice number "INV-001" and the date "01/15/2023", your second row would look like this:

Automated Invoice in Excel
Automated Invoice in Excel
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
Sales Invoice Excel | Templates at allbusinesstemplates.com
Sales Invoice Excel | Templates at allbusinesstemplates.com
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
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
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Create a Professional Invoice Template in Word — No Excel Needed!
Create a Professional Invoice Template in Word — No Excel Needed!
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 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
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
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
Excel CRM With Automated Invoices | Streamline Your Client Orders Today
Excel CRM With Automated Invoices | Streamline Your Client Orders Today
50+ Free Excel Templates to Make Your Life Easier - Updated June 2026
50+ Free Excel Templates to Make Your Life Easier - Updated June 2026
Beautiful Invoicing templates for Free
Beautiful Invoicing templates for Free
Invoicing Made Easy! 100+ Free Invoicing Templates!
Invoicing Made Easy! 100+ Free Invoicing Templates!
How to create professional invoice for freelance work
How to create professional invoice for freelance work
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

INV-001	01/15/2023	John Doe	123 Oak Street, Anytown, USA 12345

Service or Product List

Below the invoice details, create a table to list the services or products you're invoicing for. In the first row, enter headers such as "Item", "Description", "Quantity", "Rate", and "Total".

Your table might look like this:

ItemDescriptionQuantityRateTotal
1Web Design1$500$500
2Logo Design1$300$300

Calculations and Final Totals

Below the table, use Excel's built-in functions to calculate the subtotal, tax, and total amount due. You can use the SUM function to add up the totals from the table, and the MULTIPLY function to calculate tax (e.g., subtotal * 0.08 for 8% tax).

Your calculations might look like this:

Subtotal:	=SUM(D2:D3)	$800
Tax (8%):	=800*0.08	$64
Total:		=800+64	$864

Don't forget to format your currency values using the Currency format in the Number group on the Home tab. This will ensure that your totals are displayed in a clear and readable format.

Customizing Your Invoice

While our simple invoice template covers the basics, you may want to customize it further to better suit your business needs. Here are a few ideas:

Adding Payment Terms

You can add payment terms to your invoice, such as "Net 30" or "Payment due within 30 days". To do this, add a new row below your calculations and enter the payment terms in the cell.

Including Your Bank Information

If you want to encourage clients to pay via bank transfer, you can add your bank account information to the invoice. Create a new row below the payment terms and enter the relevant information, such as your bank name, account number, and routing number.

Adding a Personal Touch

To make your invoices more personal, you can add a thank-you message or a note about your business. Create a new row below the bank information and enter your message. You can also use different fonts, colors, and styles to make your invoice more visually appealing.

Creating a simple invoice in Excel is a straightforward process that can save you time and ensure consistency in your business transactions. By following this guide, you'll have a professional and organized invoice template that you can use for all your invoicing needs. Once you've created your first invoice, you can simply duplicate the template and update the details for each new invoice. Happy invoicing!