Excel earns its place over Word the moment your invoices have quantities and rates rather than a single flat fee. The spreadsheet totals the column, applies VAT and updates when you change a line, which removes the most common cause of invoice disputes: an arithmetic slip nobody noticed until the payment came in short.
It also gives you something Word cannot: one workbook can hold both the invoice and the log. A second sheet listing every invoice number, client, amount and payment date is a serviceable receivables ledger for a small business.
The risks are different rather than absent. Formulas break silently when rows are inserted, and rounding applied at the wrong point produces totals that are a penny out, which looks careless on a document asking for money.
Line total as a formula, never typed. Typing it defeats the point of using a spreadsheet.
SUM across the line totals only. Anchor the range so inserting a row does not leave it behind.
Calculated from the subtotal, not from each line, or rounding differences accumulate.
Subtotal plus VAT, formatted to two decimal places.
Keep it as text, not a number, so leading zeros survive.
Number, date, client, net, VAT, total, date paid. This is what turns the file into a record.
Rounding each line then summing gives a different answer to summing then rounding. Round once, at the total, and the invoice will match what the client calculates.
A SUM(B2:B8) does not always grow when you insert at row 8. Use a table, or leave a blank spacer row inside the range.
Excel treats 0042 as 42. Format the cell as text before you type, or your sequence will look inconsistent across a year.
Multiply the subtotal cell by 0.2 for the standard 20% rate, so =B20*0.2, then total with =B20+B21. Apply it once to the subtotal rather than to each line: rounding every line individually can leave the invoice a penny or two out from what the client works out, which delays payment while someone queries it.
Not reliably on its own, because the number should only advance when you actually issue an invoice, not every time the file opens. The practical approach is a log sheet where each new row takes the previous number plus one, and you copy that value into the invoice sheet when you send it.
It holds up until you need two things at once: several people working on invoices, and a reliable answer to "what is outstanding right now". Both are where spreadsheets start costing more time than they save, because the file can only be edited by one person and the log depends on somebody updating it by hand.
The free generator fills in this structure, totals it and gives you a PDF, with no sign-up. If the same clients come round every month, Suitekore can send them without you opening anything.
Open the generator