Google Docs invoice template
Google Docs makes a good invoice and cannot add up, cannot number them, and will let you send the wrong copy. How to build one that survives all three.
Google Docs is a reasonable place to keep an invoice template. It is free, it is already open, it syncs, and the document looks like whatever you make it look like. Plenty of people run a business on one and never need anything else.
It also has three specific gaps that cause specific, repeatable mistakes, and none of them is obvious until it has happened to you. Worth knowing which they are before you build the template rather than after.
The three things it cannot do
1. It cannot add up
This is the big one. A Google Doc has no formulas — the table in it is a layout grid, not a spreadsheet. Every subtotal, every tax line and every total is a number you typed, and it stays whatever you typed even after you change a line item above it.
The failure is quiet and specific: you duplicate last month's invoice, change two days to three, and forget the total. The invoice goes out internally inconsistent — the lines say one thing, the total says another — and whoever processes it either queries it or, worse, pays the total.
If you are set on Docs, the mitigation is to do the arithmetic somewhere that does arithmetic and paste the answers in. A Google Sheet invoice is strictly safer for this one reason, and it is why Excel and Sheets templates exist alongside document ones.
2. It cannot number them
Every invoice needs a unique number running in sequence with no gaps — in most countries that is law rather than a convention, because a gap looks to an auditor exactly like a deleted invoice. Docs will not do this for you, and duplicating a file copies the number along with everything else.
So you need a register: one sheet, two columns, the number and who it went to. It sounds like overkill for a document you are already keeping. It is the only thing standing between you and two invoices called INV-014, which is worse than a gap and much harder to explain. Invoice numbers covers the rules and three schemes that work.
3. It has no idea which copy is real
The template and the invoices made from it live in the same drive, look identical in a list, and are all called something like "Invoice". Six months in there are forty of them and the one you need is identified by its modified date.
Two habits fix it, and both have to be decided at the start: name every file
so it sorts and reads —
2026-08-INV-014-Acme.pdf — and keep the template in a different
folder from the invoices, with TEMPLATE in its name. The version that goes to
the client is a PDF, always, never the document.
What a Google Docs invoice has to contain
The same eight things any invoice needs, laid out in the order a reader expects them. This is the shape to build:
Bank transfer · GE00TB0000000000000000 · reference INV-014
Top left, who is billing — your legal name, address and tax number if you have one. Top right, the word Invoice, the number, and the two dates: issued and due. Then the client's legal entity, not their brand. Then a table of what you are charging for, one row per thing. Then subtotal, tax as its own line, and the total. At the bottom, how to pay and what reference to use. What an invoice must contain covers all eight and why each one is there.
Two Docs-specific layout notes. Put the table borders on bottom edges only rather than full boxes — full grids read as a spreadsheet and make the document look homemade. And leave the tax line visible even when it is zero, with a note saying why; a missing tax line reads as an omission and gets queried, where "Not VAT registered" reads as an answer.
A register, in two columns
If you take one thing from this page, take this. Keep a second file — a Sheet is ideal — with a row per invoice:
| Number | Date | Client | Amount | Paid |
|---|---|---|---|---|
| INV-012 | 12 Aug 2026 | Marani Co. | 860 | 19 Aug |
| INV-013 | 18 Aug 2026 | Studio North | 2,040 | — |
| INV-014 | 21 Aug 2026 | Acme Ltd | 1,416 | — |
Five columns, thirty seconds an invoice, and it answers every question a document-based system cannot: what number comes next, what is outstanding, what did I bill that client last year, and — the one that arrives without warning — what did I invoice in total for the tax year.
Add a sixth column for the void ones. An invoice you cancelled keeps its number and gets marked void rather than deleted, because deleting it leaves a gap in the sequence and a gap is the thing auditors ask about.
The duplicate-and-edit trap
Nearly every Docs invoice is made by copying the last one, which is efficient and is also where the errors come from. Four fields survive a duplicate and should not:
- The invoice number. Now shared with a real invoice you already sent.
- Both dates. Issued and due, still last month's — and payment terms run from the issue date, so a stale date makes an invoice retrospectively overdue or quietly extends it.
- The client. Occasionally the whole client, which is how a competitor learns what you charge somebody else.
- The totals. Because Docs did not recalculate them.
The habit that prevents all four: after duplicating, change the number first, before anything else. It is the field you cannot recover from getting wrong, and doing it first means the rest of the pass is spent on a document that is already uniquely identified.
Sharing, and the mistake everybody makes once
Do not send the client a Google Docs link. Three reasons, in order of how much they cost:
- Anyone with edit access can change the amount, and the document has no memory of what it said when you sent it.
- Link sharing is easy to get wrong in the direction of too open, and an invoice carries your address and bank details.
- It is not a fixed document. A PDF is the same file forever; a Doc is whatever it is today. Accounts departments want the first thing.
File → Download → PDF, every time, and send that. How to send an invoice covers what to write in the mail it goes with.
When Google Docs is genuinely the right answer
It is not always a compromise. Use it when:
- You send a handful of invoices a year and a tool would be more overhead than the job.
- You need an unusual layout — a bilingual invoice, a specific client format, something with a signature block — and want full control of it.
- Your client wants an editable file rather than a PDF, which happens in some procurement processes.
- You are somewhere with no reliable internet and Docs is already offline on your machine.
What it is not good for is volume. The manual arithmetic and the manual numbering are both fine at two invoices a month and both become the thing that goes wrong at twenty.
If you would rather not maintain a register
The two gaps that cause real damage — arithmetic and numbering — are exactly what software exists to remove. Our free generator writes the invoice from a sentence, computes every total on the server rather than guessing, and keeps the sequence unbroken; three a month, no watermark, and it emails the client rather than handing you a file.
If you want the file rather than the service, Wise exports invoice templates in Google Docs format specifically, which is the closest thing to what this search usually wants. The full comparison covers what each of the ten actually costs.