How to Create an Invoice in Excel

Katherine Jul 11, 2026

Creating an invoice or bill in Excel is a straightforward process that can save you time and ensure consistency in your financial records. With its robust features and user-friendly interface, Excel is an excellent tool for managing and tracking invoices. In this guide, we'll walk you through the steps to create an invoice template in Excel, populate it with your business details, and customize it to suit your needs.

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 step-by-step process, let's briefly discuss why using Excel for invoices is beneficial. Excel allows you to:

Invoice Templates for Freelancers 2025 Guide and Free Downloads
Invoice Templates for Freelancers 2025 Guide and Free Downloads

Setting Up Your Invoice Template

To get started, open a new or existing workbook in Excel and navigate to the sheet where you want to create your invoice template. For better organization, you can name this sheet "Invoice Template".

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

Now, let's design the layout of your invoice. You can use tables for better organization and to make it easy to add or remove rows as needed. Here's a basic structure to start with:

Header Customer Information Invoice Details
Your Business Name
Your Address
City, State, ZIP
Phone Number
Email Address
Customer Name
Customer Address
City, State, ZIP
Phone Number
Email Address
Invoice Number
Date
Due Date
Payment Terms
Item Description
Quantity
Rate
Total
Subtotal
Tax
Total
Paid By
Payment Date
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel
Fully 🔥 Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel

Adding Your Business Information

In the "Header" section, enter your business name, address, phone number, and email address. You can use the Merge & Center option to center your business name across the top.

To make your invoice look more professional, you can add a logo or use different fonts and colors. Excel offers various formatting options to help you achieve the desired look.

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

Customizing the Invoice Details

In the "Invoice Details" section, you can add placeholders for the invoice number, date, due date, and payment terms. You can also use Excel's built-in functions to automatically generate these details. For example, you can use the TODAY function to insert the current date and adjust the due date accordingly.

To create a unique invoice number each time, you can use the IF function with a counter. Here's an example formula to enter in the invoice number cell: =IF(A1="", 1, A1+1). This formula will increment the invoice number each time you create a new invoice.

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

Populating Your Invoice Template

Once you've set up your invoice template, you can start populating it with your business details and customer information. You can also create a simple database to store your customers' information and use it to auto-fill the invoice template.

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
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
Automated Invoice in Excel
Automated Invoice in Excel
an invoice form with the words invoice written on it
an invoice form with the words invoice written on it
GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 20)
GST Invoice Format in Excel, Word, PDF and JPEG (Format No. 20)
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
40 Free Invoice Templates In Microsoft Excel And DOCX Formats
two invoices with the words how to create an invoice in excel
two invoices with the words how to create an invoice in excel
Creative with Colourful GST Invoice Format in Excel (Download .xlsx file)
Creative with Colourful GST Invoice Format in Excel (Download .xlsx file)
Invoice Template for Google, Excel and Word
Invoice Template for Google, Excel and Word
Free Excel Invoice Templates
Free Excel Invoice Templates
How to Create Invoice Bill Software in excel with VBA Code by learning center
How to Create Invoice Bill Software in excel with VBA Code by learning center
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
How to Make an Invoice: Step-by-Step Guide (& Free Templates)
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
Blank Invoice Templates | 15+ Free Word, Excel & PDF Formats, Samples, Examples, Forms,
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
How enter bill in excel | Billing in ms excel | How to prepare tax bill in excel in Tamil
How enter bill in excel | Billing in ms excel | How to prepare tax bill in excel in Tamil
Finance Templates “Simple Invoice Template (Google Sheets)”
Finance Templates “Simple Invoice Template (Google Sheets)”
Simple Invoice Template for Fast Business Billing | Download Free Now
Simple Invoice Template for Fast Business Billing | Download Free Now
487 Free Invoice Templates in Excel Format
487 Free Invoice Templates in Excel Format
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

To auto-fill customer information, you can use the VLOOKUP or XLOOKUP functions to retrieve data from your customer database. This way, you can quickly generate invoices without manually entering the same information each time.

Adding Invoice Items

In the "Item Description" section, you can list the products or services you're invoicing for. You can also add columns for quantity, rate, and total to calculate the subtotal automatically. To do this, you can use the SUM function or create a simple formula to multiply quantity by rate.

Here's an example formula to calculate the total for each item: =B2*C2, where B2 is the quantity and C2 is the rate. You can then use the SUM function to calculate the subtotal, tax, and total.

Adding Tax and Finalizing the Invoice

In the "Subtotal" section, you can add a row for tax. You can use a simple formula to calculate the tax based on the subtotal and your tax rate. For example, if your tax rate is 7%, you can use the following formula: =D2*0.07, where D2 is the subtotal.

Finally, you can add a row for the total, which should be the sum of the subtotal and tax. You can also add a "Paid By" and "Payment Date" section to track payments.

Now that you've created your invoice template and populated it with your business details and customer information, you can save it as a template to use for future invoices. To do this, right-click on the sheet tab and select "Move or Copy". Then, choose "Create a copy" and click "OK". Rename the new sheet to "Invoice Template" and save the workbook with a .xltx extension.

Using Excel to create invoices can save you time and ensure consistency in your financial records. By following this guide, you can create a professional-looking invoice template that suits your business needs. So, start creating your invoices today and watch your business grow!