Word, Excel and Sheets as invoice tools, the one field each of them gets wrong, and which of the three is worth your evening.
Microsoft’s templates and Google’s are free and there are thousands of them, which is the problem: most online invoices are built by people copying a file they did not read. Here is what each tool is actually good at, and where it will cost you.
Word: the quickest, the most fragile
Word wins on appearance. You can lay out a proper invoice in fifteen minutes and it prints well. The fragility is arithmetic: Word has no real sum function in a table that survives editing. Add a line item and you will find yourself recalculating tax by hand, and hand calculations on invoices get disputed.
Two settings worth using before you send anything. Turn on gridlines and a fixed table layout so the totals row cannot creep onto page two. And save as PDF with the “best for electronic distribution” option, not “best for printing”, or your file will be 6MB and slow to open on a phone.
Excel: the one that adds up
Excel is the right tool if you want one file that tracks several invoices. Build a column for invoice number, client, issue date, due date, amount and status, then a second sheet as the printed invoice that pulls from row one. Totals recalculate, tax is a formula, and the status column answers the question Word and Docs cannot: who owes me money.
The trap is version control. Two copies of an invoice spreadsheet, both edited, means two different totals and an argument you lose. Keep one master file, on one machine or one drive, and never email the spreadsheet itself to a client.
Sheets: the same, with sharing
Google Sheets gives you Excel’s formulas and better sharing, which is a benefit for a business partner and a risk for invoicing. A shared sheet with client data in it is one accidental link away from disclosure. Build the invoice in Sheets, export a PDF, send the PDF, and keep access restricted to you.
Sheets is also the best of the three on a phone, which matters if you invoice from a van or a job site rather than a desk.
The field each one gets wrong
Not the totals. The due date. Templates universally leave it out or leave it as a placeholder nobody replaces, so the invoice arrives with an issue date and no deadline. A client with no deadline has no obligation to hurry, and you have lost the moral high ground before the first reminder.
The second most common failure is the number series. Every tool lets you type a number, and people restart at 1 each January or after a bad month. Keep one series forever, or per client if your accountant insists, and never reuse a number.
The reusable prompt
This one builds the line items and terms; you paste them into whichever tool you chose.
Write the content for an invoice, given the job details below. I will paste the output into a spreadsheet or document template myself. JOB DETAILS - Trade: [plumbing / cleaning / design / other] - Client: [name] - Work items in the order performed: [list] - Hours by item: [numbers] - Materials with costs: [list or none] - Agreed variations during the job: [list or none] - Terms: [days] Output three blocks: 1. Line items: description, quantity, unit, rate, amount. One line per distinct piece of work. 2. Totals: subtotal, tax line labelled with the correct local name, amount due. 3. Terms: due date rule, late payment sentence, bank detail instruction, one line about quoting the invoice number. Rules: no item described as "works" or "labour" without saying what the work was. No rounding up without saying so. Flag any item that looks unbillable.
A worked comparison
Four invoices a month, sole trader, no staff: Docs or Word, both free, both fine. Around ten to twenty invoices a month with repeat clients: Excel or Sheets, because the status column is the whole point. Anything above that, or any invoice that needs a payment link: a generator, because the manual work has become a tax on your week.
The invoice generator here covers the third case, and the Google Docs version covers the first if you would rather build your own. If numbering is the thing that keeps going wrong, the chasing guide explains what a clean series buys you later.
Building the tracking sheet
The status column is the reason to use a spreadsheet at all. Get the layout and formulas right once.
Design a simple invoice tracker I can build in Excel or Google Sheets. CONTEXT - Invoices per month: [number] - Typical payment terms: [days] - Currency and tax: [currency, tax name and rate] - Do I invoice repeat clients: [yes/no] Give me: 1. A column list, in order, with the data type for each. 2. The formulas for: days overdue, status (paid / due / overdue), and a running total outstanding. 3. A conditional formatting rule that flags anything more than 7 days overdue. 4. One sentence on how to keep the sheet from being edited by accident. Rules: no macros, no add-ons. Assume I am competent but not a spreadsheet expert.
Choosing between the three tools
A decision prompt, useful when you are about to spend an evening rebuilding something you already have.
Help me choose the right invoicing setup. MY SITUATION - Invoices per month: [number] - Repeat clients: [number] - Do I need a payment link: [yes/no] - Do I work from a phone: [yes/no] - Time I am willing to spend setting this up: [hours] Compare three options: a document template (Docs/Word), a spreadsheet (Sheets/Excel), and a dedicated generator. For each, give: what it does well, where it breaks at my volume, and the monthly time cost. Finish with a single recommendation and the one thing that would change it. Under 200 words.
Frequently asked questions
Can I invoice from a spreadsheet and stay organised?
Yes, and it is better than a folder of documents. One sheet per year, one row per invoice, plus a status column for sent, part paid and paid. The moment you have two files, you have a reconciliation problem.
Does a spreadsheet invoice look unprofessional?
Only if it is badly laid out. Clients judge clarity, not software. A clean PDF with a clear total, a due date and a description they can match to the job reads better than a branded template with vague line items.
What about the tax columns?
Whatever your registration requires: a single tax line is enough in most places, with the rate and the registration number stated. Never bury tax inside the line item rates without showing it separately, or a client’s bookkeeper will query the invoice.
How do I stop editing an old invoice by accident?
Treat the template file as read-only and copy it for each send. Name exports with the invoice number and client, and keep the year in the file name so a search six months later works.
Last reviewed and updated on November 11, 2026.
