How to make an invoice in Excel

Route one: use Excel’s built-in template

Excel ships with invoice templates. They are free, they already contain the formulas, and using one skips most of the work.

1. Open the template gallery. File → New, then type “invoice” in the search box and press Enter. You will get a few dozen options — service invoices, sales invoices, billing statements.
2. Pick a plain one. Prefer a plain layout over a decorative one. The colourful ones look worse in print and worse as a PDF attachment, and a client’s accounts department is going to print it.
3. Replace every placeholder. Work top to bottom so you do not miss one: your business name and address, your tax number if you have one, the client’s legal name and billing address, the invoice number and date, the due date, and how to pay you.
4. Fill in the line items. One row per thing you are charging for — description, quantity, unit price. The template’s formulas calculate the row total and the subtotal for you.
5. Check the total is a formula, not a number. Click the total cell. If the formula bar shows =SUM(…) you are fine. If it shows a plain number, someone typed over the formula and it will not update. Retype it as a SUM.
6. Save as PDF. File → Save As, then choose PDF from the format dropdown.

Never send the .xlsx. A spreadsheet is editable, and an editable invoice is one an unhappy client can change before forwarding it to their accountant. Four minutes, once you have done it a first time.

If Excel's own gallery has nothing plain enough, our free invoice templates download as .xlsx with the totals column already summed.

Route two: build an invoice in Excel from scratch

Worth it if you invoice regularly and want a layout that is yours. Twenty minutes, once.

1. Open a blank workbook. File → New → Blank workbook.
2. Turn off the gridlines. Page Layout → Sheet Options, and under Gridlines uncheck View. This is the single change that makes a spreadsheet stop looking like a spreadsheet.
3. Set the column widths. Widen column A for descriptions and keep the quantity, rate and amount columns narrow. Drag the boundaries in the column header until the shape looks like an invoice rather than a table.
4. Add the header block. Top left, your business name in a larger bold font with your address underneath. Top right, the word INVOICE, and under it three lines: invoice number, invoice date, due date.
5. Add the client block. Below your header, on the left, “Bill to:” and the client’s legal name and address.
6. Build the line-item table. Four column headings — Description, Quantity, Rate, Amount — and about eight empty rows underneath. In the first Amount cell enter =B12*C12, then drag it down all eight rows so every row calculates itself.
7. Total it with AutoSum. Under the last Amount cell press Alt + = , or use Home → Editing → AutoSum. Check the range it picked actually covers all your rows; AutoSum guesses, and it guesses wrong when there are blank rows in the way.
8. Add tax, if you charge it. One row for the tax and one for the grand total: =D20*0.2 for 20%, then =D20+D21. Never hardcode the tax figure — reference the subtotal cell, so changing a line item changes the tax too.
9. Format the money columns as currency. Select them, press Ctrl + 1, choose Currency and set two decimal places. Without this, 1050 and 1050.00 and 1,050 will all appear somewhere on the same invoice.
10. Add payment terms. Below the total: how long they have to pay, how to pay you, and your bank details or payment link. Be specific — “Net 30” means nothing to a client who has not seen it before, so write “Payment due within 30 days”.
11. Save it as a template. File → Save As → Excel Template (.xltx). Opening a template creates a copy, so you cannot accidentally overwrite last month’s invoice with this month’s.
12. Save each finished invoice as PDF and send that, not the workbook.

Writing your first invoice at all? how to invoice as a freelancer walks the whole document: your rate, your payment terms, and who you are billing.

What every invoice has to contain

The layout is up to you. These fields are not:

1. The word Invoice, so it is not mistaken for a quote or a receipt
2. A unique invoice number
3. The invoice date
4. Your full business name and address
5. Your tax registration number, where you have one
6. The client’s legal name and address
7. A description of what you supplied
8. The amount due, with the tax charged shown separately
9. The payment due date and how to pay

Two of those get skipped and cause the most trouble. Showing tax separately is a requirement in most VAT jurisdictions, not a formatting preference — a client cannot reclaim tax that is not stated as its own line. And the client’s legal name has to match their registration: “Acme” and “Acme Holdings GmbH” are not interchangeable to their finance team. The exact list varies by country, and some jurisdictions add to it.

Invoice numbering, and why Excel is bad at it

Every invoice needs its own number and the sequence needs to be unbroken — not as a convention, but because most tax authorities require sequential numbering so that a missing number is visible as a missing number. Excel has no built-in “next invoice number”. You have three options and none of them is good.

• Type it manually. Works until the day you duplicate one. A duplicated invoice number is the most common error in spreadsheet invoicing, and it usually surfaces months later when two payments cannot be reconciled.
• Keep a log sheet and a formula. Add a second sheet listing every invoice you have sent, and reference it with =MAX(Log!A:A)+1. Better — but it only increments when you remember to add the row, and it recalculates every time you open the file, so yesterday’s saved invoice can quietly show tomorrow’s number.
• Use a VBA macro. Save as a macro-enabled template (.xltm) and write a macro that increments a stored counter on open. This genuinely works. It also means your invoicing depends on a macro, which some Excel installs block by default, which does not run in Excel on the web, and which nobody else in your business will be able to fix.

There is no fourth option. If you are invoicing more than a few times a month, this is usually the thing that ends the spreadsheet.

The rule the spreadsheet has to satisfy is not a spreadsheet rule: how to number invoices sets out the sequence, the separate series, and what a gap costs you.

Excel or Word for invoices?

Excel, if there is any arithmetic at all. Word has no formulas, so every total is typed by hand — which means every change to a line item is a chance to get the total wrong. That failure is silent: the invoice looks completely normal and the number is simply incorrect.

Word wins on one thing only, which is layout control for a single-page document you never recalculate. If you charge one flat fee and nothing else, Word is fine. Anything with quantities, rates or tax belongs in Excel.

Where the spreadsheet stops working

Four failure points, in the order people usually hit them.

• Copy-paste errors. You duplicate last month’s file, change the client and the amounts, and miss one field. Last month’s due date, or last month’s invoice number, ships to a new client. Nothing warns you.
• Broken formulas. Somebody types a number over a SUM cell. The invoice still renders perfectly and the total is wrong. A glance does not catch this — you have to read the formula bar.
• No record of what happened. A spreadsheet knows what you charged. It does not know whether the invoice was sent, opened, paid, or is forty days late. That record ends up in your head or in a second spreadsheet, and the second spreadsheet is the one that goes stale.
• Tax rates that move. If you hardcode 20% and the rate changes, every old invoice you reopen recalculates at the new rate. An invoice is a record of what was true on the day it was issued, and a spreadsheet has no concept of that.

The rule with a date on it

This is the part the other guides do not mention. Several countries are making structured electronic invoicing mandatory for business-to-business invoices. Structured means machine-readable — an XML file built to a standard, not a PDF. A PDF exported from Excel is not an e-invoice, however professional it looks, because there is no structured data inside it for the recipient’s system to read. Germany’s timetable is the clearest example.

Accepted formats have to satisfy the EN 16931 European standard. XRechnung and ZUGFeRD from version 2.0.1 qualify; the ZUGFeRD MINIMUM and BASIC-WL profiles do not. The obligation covers domestic B2B — invoices to consumers are not affected.

Other EU countries are on their own timetables and the direction is the same everywhere. If you invoice businesses, the Excel-to-PDF route has a shelf life, and in some places it has already expired. Check the rule for your own country and your own turnover.

If your clients are German, the mandatory fields and the small-business exemption are set out in the guide to invoice requirements in Germany. If your clients are Austrian, the same ground is covered by the guide to invoice requirements in Austria and the guide to invoicing in Switzerland.

When to stop using a spreadsheet

Excel is a reasonable place to start and a bad place to stay. Some honest markers that you have outgrown it:

• More than about five invoices a month
• You have duplicated an invoice number, or you are not certain you haven’t
• You cannot say from memory which invoices are unpaid right now
• You charge more than one tax rate
• You invoice businesses in a country with an e-invoicing mandate

Frequently asked questions