Excel Business Template for Invoice: How to Use

How-to basics · Updated November 22, 2026

The best Excel business template for an invoice is a pre-built spreadsheet that automatically calculates totals, applies tax, and numbers invoices sequentially, and you can get one free from Microsoft Office’s template gallery or build your own in minutes. Below, we cover what these templates include, how to customize them, common pitfalls, and when to switch to dedicated invoicing software.

What an Excel Invoice Template Actually Does

An invoice template in Excel is a structured worksheet with labeled cells for the seller’s and buyer’s details, line items, quantities, unit prices, and a totals section. The core value is automation: formulas in the totals area multiply quantity by unit price and sum the results, so you never hand-add a column. Most templates also include a tax rate cell and a shipping cell, and some have a running invoice number that increments when you save a copy.

For example, a typical template has:

  • Your business name, address, phone, email, and logo area at the top.
  • Customer name, billing address, and invoice date.
  • A line-item table with columns: Description, Quantity, Unit Price, and Amount (where Amount = Quantity × Unit Price).
  • A subtotal row, a tax row (often a percentage of subtotal), a shipping row, and a Total Due row.
  • Payment terms (e.g., Net 30), due date, and payment instructions.

How to Get a Free Excel Invoice Template

Microsoft provides dozens of free invoice templates directly in Excel. Open Excel and go to File > New, then type “invoice” in the search box. You’ll see options like “Service Invoice,” “Sales Invoice,” “Time Billing Invoice,” and “Simple Invoice.” These are fully editable and work in Excel 2016 and later, including Microsoft 365. Download one, and it opens as a normal .xlsx file.

Alternatively, you can download templates from reputable sites like Vertex42 or Smartsheet, but be cautious: some third-party templates contain macros or broken formulas. Stick with the Microsoft gallery unless you know how to inspect formulas.

Anatomy of a Good Invoice Template

A reliable template should have the following features, which you can verify before using:

  • Formulas, not hard-coded numbers: The Amount column should contain formulas like =C2*D2 (assuming Quantity in C and Unit Price in D). The Subtotal should be =SUM(E2:E10) or =SUBTOTAL(9,E2:E10).
  • Tax calculation: A tax rate cell (e.g., B12) and a tax amount formula like =ROUND(E11*B12,2) where E11 is the subtotal.
  • Invoice number and date: Cells for invoice # and date, often with a formula to auto-fill the date: =TODAY().
  • Print-friendly layout: The template should have page setup with margins and a print area defined so it prints on one page.

If you build your own, set up a simple layout: put your company info in A1:C3, customer info in A5:C7, and the line-item table starting at row 9. In cell E9, enter =C9*D9 (Quantity × Price). Drag that formula down. For subtotal, use =SUM(E9:E20). For tax, assume tax rate in a cell, say G2, and use =ROUND(E21*G2,2). Total is =E21+E22+E23 (subtotal + tax + shipping).

How to Customize Your Invoice Template

Once you have a template, you’ll want to add your logo and adjust colors. To insert a logo, go to Insert > Pictures and choose your file. Resize it and position it in the top-right corner. To change colors, select the header row and go to Home > Fill Color. You can also add a border to the line-item table by selecting the range and using Home > Borders.

To set up automatic invoice numbering, you can use a formula that references a cell where you type the starting number. For example, put =A1 in the invoice number cell, and each time you copy the template for a new invoice, change A1. Or use a simple macro (see below) to increment automatically.

Common Problems and How to Fix Them

Many users run into the same issues with Excel invoice templates:

  • Formulas break when copying: If you copy a row and the formulas don’t adjust, check that the cell references are relative (no $ signs) unless you intend absolute. For the tax rate, you want an absolute reference like $B$12 so it doesn’t shift.
  • Printing cuts off columns: Go to Page Layout > Print Area > Set Print Area and adjust scaling to fit one page wide. Use View > Page Break Preview to see where pages break.
  • Currency formatting missing: Select the monetary cells and press Ctrl+Shift+4 (Windows) or Cmd+Shift+4 (Mac) to apply currency format.
  • Invoice numbers not sequential: If you manually type each number, you risk duplicates. Use a simple macro to auto-increment.

Excel vs. Dedicated Invoicing Software

Excel is great for freelancers or small businesses with low invoice volume (under ~50 per month). It’s free (if you have Excel), fully customizable, and you control the data. However, it lacks automation: you must manually send invoices, track payments, and handle overdue reminders. Dedicated tools like QuickBooks, FreshBooks, or Wave automate recurring invoices, send payment links, and sync with your bank. They also store customer records and generate reports.

If you only need a simple invoice and don’t mind manual tracking, Excel is sufficient. If you’re growing and need to track accounts receivable, consider switching. A good middle ground is to use an Excel template with a PDF export and a separate spreadsheet to track payments.

Safety and Accuracy Tips

Because invoices are financial documents, accuracy is critical. Always double-check that the formulas reference the correct cells. Use Data Validation to ensure quantities are positive numbers: select the Quantity column, go to Data > Data Validation, choose “Whole number” and set minimum to 1. This prevents accidental negative values.

When you save an invoice, use a clear file naming convention like Invoice_2024-001.xlsx. Keep a backup of your template and your invoice history. If you use a macro to auto-number, save a copy of the workbook before running it, because macros cannot be undone with Ctrl+Z.

Frequently Asked Questions

Can I use an Excel invoice template for free? Yes, Microsoft provides free templates in Excel’s New screen. They are fully functional and don’t require a subscription beyond Excel itself.

How do I make the invoice number increment automatically? You can use a simple VBA macro. Press Alt+F11 to open the VBA editor, insert a module, and paste this code:

Sub IncrementInvoiceNumber()
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets(

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.