How to Create an Invoice in Excel (Free Template Included)

Excel is one of the easiest tools for creating invoices, especially if you want something simple, editable, and professional. You do not need advanced accounting software to send a clean invoice. With a basic Excel invoice template, you can add your details, list the work completed, calculate totals, and send the invoice to your client as a PDF.

This method works well for freelancers, contractors, consultants, small business owners, and service providers who want more control over their invoice layout.

In this guide, you will learn how to create an invoice in Excel step by step, what to include, which formulas to use, and how to make your invoice look professional.

Why Use Excel for Invoices?

Excel is useful because it gives you flexibility. You can create your own invoice layout, add formulas, save client copies, and reuse the same template again and again.

For example, if you are a freelance web designer in Austin, Texas, you can create one invoice template and use it for different clients each month. You only need to update the invoice number, client details, service description, price, and due date.

Excel is a good choice if you want to:

• Create invoices without starting from scratch every time
• Use formulas to calculate totals
• Customize your invoice layout
• Save invoices as PDF files
• Keep invoice records on your computer
• Build a reusable template for future clients

The main benefit is control. You decide how the invoice looks and what details it includes.

Free Excel Invoice Template

You can copy this structure into Excel and use it as a simple invoice template.

INVOICE

From:
Brightline Creative Studio
Austin, Texas
hello@brightlinecreative.com
www.brightlinecreative.com

Bill To:
Oak & Pine Marketing
New York, NY
accounts@oakpinemarketing.com

Invoice Number: INV-2026-001
Invoice Date: June 18, 2026
Due Date: July 2, 2026

Description                         Quantity     Rate       Amount
--------------------------------------------------------------------
Landing Page Design                  1            $500       $500
Mobile Responsive Fixes              1            $200       $200
Website Speed Optimization           1            $150       $150

Subtotal:                                                   $850
Discount:                                                   $50
Tax:                                                        $0

Total Amount Due:                                           $800

Payment Method:
Bank Transfer

Payment Terms:
Payment is due within 14 days of the invoice date.

Note:
Thank you for your business.

You can create this layout in Excel using rows and columns. Keep the design clean and make the final total easy to find.

How to Create an Invoice in Excel

Start by opening Microsoft Excel and creating a blank workbook. You can also use an existing invoice template, but building your own simple version gives you more control.

At the top of the sheet, write Invoice in a large, clear font. This makes the purpose of the document obvious.

Next, add your business or personal details. If you have a company, use your business name. If you are an individual freelancer, use your full name.

Example:

Brightline Creative Studio
Austin, Texas
hello@brightlinecreative.com
www.brightlinecreative.com

Then add your client’s details on the right side or below your own details.

Example:

Bill To:
Oak & Pine Marketing
New York, NY
accounts@oakpinemarketing.com

After that, add the invoice number, invoice date, and due date. These details help both you and your client track the invoice properly.

Add Invoice Details

Every invoice should have a unique invoice number. You can keep it simple:

INV-001
INV-002
INV-003

Or use a year-based format:

INV-2026-001
INV-2026-002

Add the invoice date and payment due date clearly.

Example:

Invoice Date: June 18, 2026
Due Date: July 2, 2026

A due date is important because it tells the client when payment is expected. Without a due date, payment can easily be delayed.

Add Products or Services

The main part of the invoice is the service or product table. In Excel, create columns like this:

Description | Quantity | Rate | Amount

For example:

Landing Page Design | 1 | $500 | $500
Mobile Responsive Fixes | 1 | $200 | $200
Website Speed Optimization | 1 | $150 | $150

Use clear descriptions. Instead of writing “freelance work,” write exactly what you completed. Clear service descriptions make the invoice easier to approve.

Use Excel Formulas

Excel becomes useful when you add formulas. Instead of calculating totals manually, let Excel do the work.

If your table starts on row 15, and quantity is in column B, rate is in column C, and amount is in column D, use this formula in the amount column:

=B15*C15

Then drag the formula down for the other rows.

For subtotal, use:

=SUM(D15:D20)

For total after discount and tax, you can use:

=Subtotal-Discount+Tax

If your subtotal is in D22, discount is in D23, and tax is in D24, the total formula can be:

=D22-D23+D24

These formulas help reduce mistakes and make the invoice faster to update.

Add Payment Terms and Method

After the total amount, add your payment method. The client should immediately understand how to pay you.

You can include:

• Bank transfer
• Credit card
• PayPal
• Stripe
• Wise
• Check
• Zelle

Example:

Payment Method:
Bank Transfer

Account Name: Brightline Creative Studio
Bank Name: First National Bank
Account Number: 123456789

Then add simple payment terms.

Example:

Payment is due within 14 days of the invoice date.

You can also add a short note:

Please include the invoice number when making payment.

This helps you match the payment with the correct invoice.

Format the Invoice Professionally

A professional invoice should be easy to read. You do not need a complex design, but the layout should be clean.

Use bold text for important labels like Invoice Number, Due Date, and Total Amount Due. Add borders around the service table. Use enough spacing so the invoice does not feel crowded.

Make the total amount stand out. This is the number your client will look for first.

Also, avoid too many colors. A simple black, white, and light gray layout is usually enough.

Save the Invoice as a Template

Once your Excel invoice looks good, save it as a template. This way, you do not need to rebuild the invoice every time.

You can save one blank version as:

Invoice_Template.xlsx

Then for each client, save a new copy:

INV-2026-001-Oak-Pine-Marketing.xlsx

This helps you keep your files organized.

Export the Invoice as a PDF

Before sending the invoice to your client, export it as a PDF. A PDF keeps the formatting clean and prevents accidental edits.

In Excel, you can usually do this by going to:

File → Save As → PDF

Or:

File → Export → Create PDF

Name the PDF clearly:

INV-2026-001-Oak-Pine-Marketing.pdf

Then attach it to your email and send it to the client.

Example Invoice Email

Here is a simple email you can send with your Excel invoice PDF:

Subject: Invoice INV-2026-001

Hi Sarah,

I’ve attached the invoice for the landing page design, mobile responsive fixes, and website speed optimization work.

Payment is due by July 2, 2026. Please let me know if you have any questions.

Thank you,
Michael Carter

Keep the email short and clear. The invoice PDF should contain the full details.

Common Excel Invoice Mistakes

One common mistake is forgetting to update the invoice number. If two invoices have the same number, it can create confusion later.

Another mistake is sending the Excel file instead of a PDF. Unless the client specifically asks for the Excel file, send a PDF version.

Some people also forget to check formulas. If a formula is wrong, the total amount may be incorrect. Always review the final total before sending.

You should also avoid vague service descriptions. Clients approve invoices faster when they understand exactly what they are paying for.

Excel Invoice vs Invoice Generator

Excel is a good option if you want control and do not mind editing the invoice manually. It is flexible and easy to customize.

However, an invoice generator can be faster if you send invoices often. It can help you avoid manual formatting, save client details, track invoices, and create professional invoices more quickly.

Use Excel if you want a simple editable file.

Use an invoice generator if you want a faster and more organized invoicing workflow.

Related Guides

You may also find these helpful:

• What Should an Invoice Include?
• How to Write an Invoice for Freelance Work
• How to Make an Invoice Without a Company
• Freelance Invoice Template

Final Thoughts

Creating an invoice in Excel is simple when you have the right structure. Start with your details, add your client information, include the invoice number and dates, list your services, calculate the total, and export the invoice as a PDF.

Excel is a good choice if you want a free and editable invoice template. It gives you control over the layout and lets you reuse the same file for different clients.

If you want to create professional invoices faster without managing formulas or formatting manually, DoranPay can help you generate clean and organized invoices in less time.

Whether you use Excel or an invoice generator, the goal is the same: send a clear invoice, make payment easy, and get paid with less confusion.