Skip to content
26 Excel templatesShop Templates
AutoExcel

How to Make an Invoice in Excel

Published 2026-11-18

You can build a clear, professional invoice in Excel in about half an hour. This guide shows the layout, the formulas that do the maths for you, and how to send the result as a PDF.

1. Set up the layout

Open a blank workbook. At the top, leave space for your business name, address and contact details, and for the client's name and address. Below that, add the invoice number, invoice date and payment terms.

Under those, create a table with four column headings: Description, Quantity, Unit price and Amount.

2. Add the formulas

Suppose your line items run from row 15 to row 24, with Quantity in column B, Unit price in column C and Amount in column D. These formulas do the work:

Amount for each line (copy down the column)
=B15*C15
Subtotal
=SUM(D15:D24)
Tax (with the tax rate typed in a cell such as D27)
=ROUND(D26*D27,2)
Total due
=D26+D28
Due date (invoice date in D8, terms in days in D9)
=D8+D9

3. Format it so it looks professional

  1. Format the Amount column as currency: select the cells, then choose Home, Number Format, Currency.
  2. Format the date cells as dates, so they do not show as plain numbers.
  3. Add a bold header row with a fill colour, and keep borders light.
  4. Use Page Layout, Print Area to set the area that prints, and Fit to 1 page wide.

4. Handle tax correctly

Whether you charge sales tax, and at what rate, depends on your location and your registration. Enter the rate in its own cell instead of typing it into formulas, so you can change it without editing every invoice. If you are unsure what applies to you, check with the tax authority or an accountant.

5. Number your invoices and save as PDF

Give every invoice a unique number and keep a list of what you have issued. To send an invoice, choose File, Export, Create PDF/XPS (or Save As and choose PDF). Send the PDF rather than the Excel file, so the client cannot change it.

Common mistakes

  1. Typing totals by hand instead of using formulas.
  2. Overwriting a formula by accident. Protecting the sheet (Review, Protect Sheet) and unlocking only the cells you fill in prevents this.
  3. Reusing the same invoice number.

More guides

Templates for this job

Ready-made Excel workbooks. No macros, instant download.

Document ControlPremium

Document Control System

A complete document control system: numbering, revisions, approvals, transmittals and a live dashboard.

$99.00
Details