Microsoft Excel Invoice Template: Find and Customize

How-to basics · Updated November 19, 2026

Yes—Microsoft provides invoice templates you can open in Excel: in Excel for Microsoft 365 on Windows, select File > New, search for “invoice,” choose a template, and select Create. You can also look for Excel invoice templates through Microsoft Create; the available designs may vary by account, region, and time.

What a Microsoft Excel invoice template does

An invoice template is a reusable workbook laid out to record a sale and present the amount a customer is being asked to pay. A typical version includes the seller’s business details, a customer or “bill to” block, an invoice number and date, a description of each product or service, quantities, prices, totals, and payment instructions. Some templates also include branding, terms, or a space for a tax amount.

Excel makes the template editable: you can change text, add rows, format cells, and use formulas to calculate line amounts and totals. The template is a starting point, not a payment service. It does not send the invoice, collect money, verify customer details, or determine which taxes or legal fields apply to your situation.

Find and open a template in Excel

In the Windows desktop app for Microsoft 365, open Excel and follow these steps:

  1. Select File > New.
  2. Enter invoice in the template search box.
  3. Review the results and select a design that suits the information you need to show.
  4. Select Create. Excel opens a new workbook based on the selected template.

Before entering customer information, save the new workbook with a useful filename and location. Use File > Save As to create a working copy. The precise template gallery and search results can change, so a particular design may not appear for every user.

You can also search Microsoft Create for invoice templates and choose an Excel-compatible option. Check the file type and follow the download or open instructions shown on the page. A template file may open in Excel as a new workbook or be downloaded for you to open. If a website asks you to enable macros for a basic invoice layout, pause and verify that the file and its source are trustworthy; a standard invoice does not normally need a macro to calculate totals.

Choose a layout that fits the job

Start with the information you need to communicate, rather than choosing a design only because it looks polished. A simple service invoice may need a few description lines and an hourly rate. A product invoice may need more rows, quantities, unit prices, and perhaps shipping. A recurring business may also want consistent branding and a clearly visible payment deadline.

  • Readable details: Make sure the seller, customer, invoice number, issue date, and amount due are easy to find.
  • Enough line items: Confirm that the layout has space for the descriptions and quantities you normally use.
  • Clear totals: Subtotal, any applicable adjustments, and the final amount should be distinguishable.
  • Practical printing: Check that the invoice fits on a sensible number of pages and does not cut off key fields.
  • Easy maintenance: Avoid intricate formatting that would make routine edits difficult.

Do not assume that a template’s labels or default tax fields are appropriate for every country or business. Review the fields and wording against your own requirements. A clean, plain layout is often easier for customers to read and for you to update than a crowded design.

Customize the workbook safely

Replace sample seller information with your own, then add customer details, invoice dates, and a unique invoice identifier according to your recordkeeping process. Delete placeholder examples so they cannot be mistaken for real charges. For a line item, use a description specific enough that the customer can understand what was supplied; avoid relying on a vague label such as “work” if a clearer description is available.

Keep labels and calculation cells distinct. For example, use one column for quantity, another for unit price, and a third for the calculated line amount. If you change the layout, check that each formula still refers to the correct cells. Formulas can silently produce misleading totals after rows or columns are moved, overwritten, or omitted.

When you want a clean reusable starting point, retain an untouched master copy and create a separate workbook for each invoice. This reduces the chance of sending a previous customer’s details or leaving old line items in a new invoice. A workbook can contain hidden sheets or extra tabs, so review the whole file before sharing it.

How invoice calculations work in Excel

Here is an illustrative layout: descriptions are in C14:C23, quantities in D14:D23, unit prices in E14:E23, and line amounts in F14:F23. For the first item, two units at $75 each should produce $150. With quantity in D14 and unit price in E14, enter =D14*E14 in F14. Copy the formula down the line-amount column, adjusting the row reference for each item.

Assume the ten line amounts are in F14:F23 and the subtotal is placed in F24. Enter =SUM(F14:F23) in F24. For an example with three charges—$150, $60, and $45—and the remaining rows blank, the subtotal is $255. The SUM formula adds the numeric amounts in the specified range.

If an illustrative tax rate is entered as 8% in B27, and the subtotal remains in F24, put =F24*B27 in F27 for the tax calculation. On a $255 subtotal, that result is $20.40. To display a total in F28 by adding the subtotal and the calculated amount in F27, enter =F24+F27; the example total is $275.40. These figures only demonstrate spreadsheet arithmetic. They do not establish which rate, tax treatment, or invoice wording applies to a real transaction.

Format price and total cells as currency using Home > Number Format in Excel for Windows, choosing an appropriate currency or accounting format. Check the currency symbol and decimal places, particularly if you work with customers in more than one currency. Number formatting changes how a value is displayed; it does not convert one currency into another.

Save, export, and send the invoice

Keep an editable Excel copy if you may need to revise the invoice or inspect its formulas later. Give each invoice a filename that helps you identify it, such as a customer name plus invoice number, while avoiding unnecessary personal information in filenames. Excel workbooks generally use the .xlsx format; template files may use a template format such as .xltx.

If the customer only needs a document to read or print, a PDF can preserve the page layout more consistently than sending a workbook. In Excel for Microsoft 365 on Windows, use File > Export > Create PDF/XPS Document, or use File > Save As and select PDF as the file type. Review the output before sending: use Print Preview to check page breaks, scaling, blank pages, and whether all columns are visible. Menu details can differ in Excel for Mac and Excel for the web, so use the export or download options available in that version.

A PDF is not automatically protected from copying or disclosure. Send invoices through a channel suitable for the information they contain, and confirm the recipient address before attaching a file. If the invoice includes bank or other sensitive payment details, take care not to expose them in a public link or to an unintended recipient.

Costs, limitations, and common mistakes

There is usually no separate charge for a built-in template itself, but using the desktop Excel app may require an eligible Microsoft 365 subscription or other Excel license. Template access and the features available can depend on the account and the version of Excel. Check Microsoft’s current product and account terms rather than assuming that every template is available to every user.

Common errors include replacing a formula with a typed number, forgetting to extend a formula to a new row, including a blank or unwanted line in a total, and leaving sample information behind. Another frequent misunderstanding is that an Excel invoice template guarantees compliance with tax rules or creates an official invoice in every jurisdiction. It does neither. Check applicable requirements with an appropriate professional or official source when needed.

Before sending, compare each line item with the agreed work or goods, recalculate the totals independently, and confirm the customer, dates, invoice identifier, and payment details. If a formula result looks wrong, select the cell and inspect the formula bar; also verify that the source values are numbers rather than text. Save a corrected copy rather than overwriting records if your process requires retaining earlier versions.

When Excel is—and is not—the right option

Excel can be a practical choice for occasional invoices, straightforward calculations, and businesses already comfortable with spreadsheets. It offers flexibility: you can adapt columns and formulas without learning a dedicated billing system. That flexibility also means you are responsible for checking formulas, maintaining invoice numbering, controlling access to files, and keeping records.

For frequent billing, multiple users, recurring charges, payment tracking, or links between invoices and accounting records, dedicated invoicing or accounting software may reduce manual work. Compare the actual features and costs before switching; capabilities vary between products and plans. Another spreadsheet app may open an Excel workbook, but formatting or formulas can behave differently, so inspect the finished document in the software used to create it.

Frequently Asked Questions

Does Microsoft have a free invoice template for Excel?
Microsoft offers invoice templates through Excel’s template gallery and Microsoft Create, though availability can vary. There is generally no separate fee for a template, but access to the Excel app itself can depend on your license or account.

How do I find invoice templates in Excel 365?
In the Windows desktop app, select File > New, search for invoice, choose a result, and select Create. If you do not see a suitable option, check Microsoft Create or search again later because the gallery can change.

Can Excel calculate an invoice total automatically?
Yes. A line amount can multiply quantity by unit price, and a SUM formula can add the line amounts. Confirm the cell references and any applicable adjustments before relying on the displayed total.

Can I send an Excel invoice as a PDF?
Yes. Excel for Windows offers PDF export through File > Export or File > Save As. Check the PDF’s page layout and figures before sending, since export settings can affect how the sheet appears.

Is a Microsoft Excel invoice template tax compliant?
Not automatically. A template is a general document layout, not confirmation that its fields, rates, or wording meet requirements for a particular business or location. Verify the rules that apply to the transaction.

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.