Word and Excel invoice templates

These are the two most common places an invoice gets made, and they fail in opposite directions. Word will let you write any total you like under a set of lines that say something else. Excel will compute the total correctly and then show you a different number.

Both are fixable once you know which one you are dealing with.

Word: it cannot add up, and looks like it can

A Word table is a layout grid. It has no formulas, so every subtotal, tax line and total is text you typed and stays exactly as typed after you change the row above it.

The failure is always the same: you open last month's invoice, change two days to three, and the total is still last month's. The document goes out internally inconsistent, and whoever processes it either queries it — a week — or pays the number in the total box, which may be less than you are owed.

This is the same gap Google Docs has, and the same fixes apply. The Google Docs page covers them, including the two habits that matter most: change the invoice number first after duplicating, and keep a register so the sequence stays unbroken.

Word does have one real advantage over a spreadsheet: it produces a document that looks like a document. Nobody has ever received a Word invoice and thought it was a working file.

Excel: it can add up, and here is how it still goes wrong

Excel fixes the arithmetic and introduces three problems that are harder to see.

It shows a rounded number and stores an unrounded one

The one worth knowing about. Formatting a cell to two decimal places changes what is displayed, not what is held. A line that computes to 399.996 displays as 400.00 and is still 399.996 to every formula that references it.

Do that across several lines and the total can be a cent or two away from the sum of the numbers your client can see. They add up your visible lines, get a different answer, and query an invoice that is arithmetically correct and visibly wrong.

The fix is to round the value rather than the display — =ROUND(qty*rate, 2) in the line itself, so the stored number and the shown number are the same one. Doing it in the total only pushes the discrepancy somewhere else.

Formulas break when you insert a row

A subtotal written as =SUM(B5:B9) does not always follow when you add a tenth line — depending on where you insert it, the new row falls outside the range and the total silently excludes it. An invoice missing a line item is worse than one with a wrong total, because nothing about it looks wrong.

Use a range with room in it, keep the total well below the last possible row, and check the subtotal after adding lines. Every time.

Sending the spreadsheet sends more than the invoice

This one has consequences beyond the invoice. An .xlsx file carries every sheet in the workbook, not the one you were looking at. If the same file holds your rate card, your other clients, or the tab where you worked out the discount, all of it travels with the invoice.

It is also editable, and it shows your formulas — including the one where a day rate was multiplied by something you would rather not explain.

Always send a PDF. Export, check it, attach that. The spreadsheet is a tool for producing the invoice, not the invoice.

The shape either one should produce

Whichever you build in, the output has to be this — the same eight elements in the order a reader expects:

AS Aria Studio 10 Betlemi St · VAT GE1234567

INVOICE INV-014

Billed toAcme Ltd · London Issued21 Aug 2026 Due5 Sep 2026

DescriptionAmount

Brand identity — 2 days × 6001,200.00

Subtotal1,200.00

VAT 18%216.00

Total due1,416.00

Bank transfer · GE00TB0000000000000000 · reference INV-014

What an invoice must contain covers all eight. The two that get invoices rejected are a unique number and the client's correct legal entity, and neither is a formatting decision.

One layout note specific to Excel: turn the gridlines off before exporting. An invoice with every cell outlined reads as a spreadsheet somebody forgot to finish, and the borders you actually want are bottom edges under the line items and above the total.

The numbering problem neither of them solves

Everything above is about getting one invoice right. This is about the hundredth, and it is the reason people eventually leave both.

Neither Word nor Excel knows what your last invoice number was. Every invoice is made by opening the previous one, which means the number arrives already used and has to be changed by hand — and the one time it is not, two different documents in your business carry the same reference. That is worse than a gap, because a gap raises a question and a duplicate produces two answers.

The register is the whole fix and it is five columns:

In Excel this can be the same workbook — a second sheet, never sent, which is another reason the thing you attach is a PDF. It answers what a file-based system otherwise cannot: what number comes next, what is outstanding, and what you invoiced in total for a tax year.

Add a row for anything you voided. A cancelled invoice keeps its number and gets marked void rather than deleted, because deleting it leaves the gap. Invoice numbers covers why both bother an auditor.

A five-minute check before any of these goes out

1. Does the total equal the lines? Add them yourself once. In Word because nothing did; in Excel because of the rounding above.
2. Is the invoice number new? Against the register, not against memory.
3. Are both dates this month? Issued and due. Terms run from the issue date, so a stale one either backdates the debt or quietly extends it.
4. Is the client the right legal entity? Especially after a duplicate.
5. Are you attaching a PDF? Not the .docx, and never the .xlsx.

Which to use

The hybrid most people end up with

Compute in Excel, present in Word or a PDF from Excel, and keep a register in a third sheet. It works, and it is three files per invoice with three chances to use the wrong version of one.

If that describes your setup and it is starting to cost you time, the thing software actually removes is not the typing — it is the arithmetic, the numbering and knowing who has not paid. Our free generator does all three from a sentence: three invoices a month, no watermark, and it emails the client rather than handing you a file to forward.

If you want to stay in files, Wise exports invoice templates in Word and Excel format specifically, which is the closest thing to what this search usually wants. The comparison covers what the other tools cost.