Free Google Sheets Invoice Template
An invoice is the document a seller sends a buyer to ask for payment: what was done, what it costs, and when it's due. This version of our free invoice template lives in Google Sheets — you open the shared sheet, make your own copy, and edit it in your browser like any other spreadsheet. Line totals and the subtotal are formulas; the tax figure is a cell you type in yourself. There's nothing to install and nothing to pay. You'll need a Google account to make a copy — that's Google's requirement, not ours.
Open the invoice template in Google Sheets
The link opens Google's Make a copy screen — one click, and the template is saved to your own Drive as a normal spreadsheet that's entirely yours. The original stays read-only, so it's always a clean copy. Free, with no watermark; you'll need to be signed in to a Google account, because the copy lives in your Drive, not ours.
If you'd rather have a file on your computer instead, the same invoice is available as an Excel download.
What goes on the invoice — and where it sits in the sheet
Every field below is already laid out in the sheet — you fill in the white cells and leave the shaded ones alone, because the shaded ones do the adding up.
- Invoice number and date — top right. Give every invoice its own number and keep the sequence in order.
- From — your business name and contact details. Yours, not the client's.
- Bill to — who owes the money: name, email, address.
- Line items — one row per item: description, quantity, rate. The Amount cell on each row is a formula (quantity × rate) — type into Description, Qty and Rate, and leave Amount alone.
- Subtotal — a formula that adds the Amount column. Don't type over it.
- Tax — a cell you fill in yourself, as an amount. Nothing in the sheet works out a tax rate for you; enter what applies to you, or leave it at zero.
- Total — subtotal plus tax, again a formula.
- Notes / payment details — how you want to be paid, and by when.
Editing your copy: formulas, rows and the tax cell
Three things worth knowing before you edit.
The formula cells. Each row's Amount, the Subtotal and the Total are live formulas. If you accidentally type over one, press Ctrl+Z (⌘Z on a Mac) — or delete the cell's contents and copy the same cell from a neighbouring row.
Adding rows. Right-click a row number _inside_ the item table and choose Insert 1 row above. Inserting inside the table keeps the new row's Amount formula and keeps the Subtotal range growing with it. Adding rows _below_ the last item leaves them outside the sum — the classic reason a total comes out short.
The tax cell. It's deliberately not a formula. Type the tax amount that applies to you, or leave it at zero — the sheet never decides a rate for you.
When the invoice is ready, use File › Download › PDF and send the PDF. Don't share the sheet itself with a client: a shared sheet shows every edit you make afterwards, and the client only needs the finished document.
Frequently asked questions
Do I need a Google account to use this template?
A Google account is needed at one moment only: making your copy — the copy is saved into your Google Drive, and that requires being signed in. That's how Google Sheets works, not a restriction we added. If you'd rather not use a Google account, the Excel invoice template is a straight file download.
Are the totals formulas — and does the sheet work out tax?
Line amounts, the subtotal and the total are live formulas: type a quantity and a rate, and the row adds itself up. The tax figure is different — it's a plain cell you type an amount into. Nothing in the sheet works tax out for you; what applies to your business is yours to enter.
How do I send the finished invoice to a client?
Send the invoice as a PDF — File › Download › PDF — and attach that. Avoid sharing the sheet itself: a live sheet shows every later edit, exposes your other invoices if you reuse the file, and your client only needs the finished document anyway.