Invoice Template for Google Sheets

The same invoice layout with the arithmetic already wired in. Enter quantity and rate on each line and the line total, subtotal, tax and grand total update themselves.

Open it in your own Google Sheets

SHEETSMake a copy in Google Sheets (opens in Google)Confirm the copy prompt and the spreadsheet lands in your own Drive with the formulas intact. The original is view-only and stays that way.

Free to download and use. No sign-up, no email, no watermark.

How to use this invoice template google sheets

Click the button above and confirm the "Make a copy" prompt. The copy arrives in your Drive with every formula working.
Fill your business details and the client's billing contact at the top. Use the client's accounts payable address if they gave you one — invoices sent to your day-to-day contact often sit in an inbox for a week before being forwarded.
Enter each line: description, quantity, rate. Leave the line total column alone — it is a formula, and typing over it is the one action that breaks the sheet.
Set the tax rate if you charge sales tax. Enter it as a decimal — 0.0825 for 8.25%, not 8.25. Entering the whole number is the single most common way people end up with a tax figure larger than the invoice.
Check the grand total against your own expectation, then File → Download → PDF Document and send that. Print settings are already set to one page.

What the formulas do, and the one cell you must not type into

Each line multiplies quantity by rate. The subtotal sums those line totals across the whole table, including the empty rows, so you can add lines without rewriting anything. Tax multiplies the subtotal by whatever rate you set, and the grand total adds the two together and subtracts any deposit already paid. That is the entire model, and it means the only numbers you actually type are quantity, rate and the tax rate.

The column that must be left alone is the line total. It looks like a number and behaves like a number, but it is a formula — and typing a value over it replaces the formula permanently in that row. The symptom is subtle and nasty: everything looks right until the day you change a rate and one line stops updating. If you have done it, undo, or copy the formula down from the row above.

The tax rate is the other trap, and it catches people who have used spreadsheets for years. Sheets treats 8.25 as the number eight and a quarter, not as a percentage, so a $2,000 invoice acquires $16,500 of tax. Enter 0.0825. If your cell is formatted as a percentage you may type 8.25% with the symbol, but the decimal form is the one that always works.

Rows are safe to add, with one condition: insert them inside the existing table rather than below the last line. Inserting inside means the subtotal range stretches to include the new row automatically. Adding a row underneath the table leaves it outside the sum, and the invoice quietly under-bills — which is a worse outcome than a formula error, because nobody complains about being charged too little.

Sheets also gives you something the Docs version cannot: a running record. Copy the sheet for each invoice and you have a folder of files with consistent structure, which is a starting point for a simple income log. It is not bookkeeping, but for a first year of freelancing it is considerably better than a folder of PDFs and a memory.

Example

A freelance photographer invoices a restaurant for a menu shoot: a day rate, a half-day of retouching, and travel. She charges sales tax at 8.25% and the client paid a booking deposit when the date was held.

Shoot day — 1 × $1,400.00	$1,400.00
Retouching — 4 hrs × $95.00	$380.00
Travel — 120 mi × $0.725	$87.00
Subtotal	$1,867.00
Sales tax @ 0.0825	$154.03
Booking deposit paid	−$400.00

Grand total: $1,621.03 — every figure calculated by the sheet, none typed by hand.

Three lines, three different units — a day, an hour, a mile — and the same formula handles all of them because quantity times rate does not care what the unit is. The travel line uses the 2026 IRS standard mileage rate of 72.5 cents, which is a defensible number to bill at because it is the number the tax code itself uses.

The tax rate is entered as 0.0825 and produces $154.03. Typed as 8.25 it would produce $15,402.75 on the same subtotal, and the invoice would be obviously absurd — which is the lucky case. The dangerous version of this error is a rate like 0.5 entered as 5, where the result is wrong but not wrong enough to notice.

The deposit comes off after tax, because the tax is owed on the full value of the work regardless of when it was paid. Subtracting the deposit before tax would under-collect, and it is the kind of small structural error that only surfaces when someone reconciles a year of invoices.

Nothing in the subtotal, tax or total line was typed. That is the whole argument for this version over the Docs one: on a three-line invoice hand arithmetic is survivable, but it is exactly the kind of task humans are worse at than they believe, and the failure is public — it lands in front of the person about to pay you.

Before sending she downloads it as a PDF. The sheet stays in her Drive as the working copy; the client gets a fixed document. Next job, she copies the template again rather than overwriting this one.

Limits and things to watch for

A Google account is needed to make the copy. Viewing the template does not require one.
The line total column is a formula. Typing a value into it replaces the formula for that row permanently, and the damage is not obvious until you change a rate later.
The tax rate must be a decimal — 0.0825, not 8.25. This calculates one flat rate on the subtotal and does not handle line-level tax, mixed rates, or exemptions.
Add rows inside the existing table, not underneath it. A row added below the last line falls outside the subtotal range and is silently excluded.
US layout — dollar amounts, US date conventions, sales tax rather than VAT. There is no field for a VAT registration number or a reverse-charge note.
It is a template, not accounting software. It tracks nothing between invoices and will not tell you what is unpaid.

Frequently asked questions

Why is my tax number enormous?: You entered the rate as a whole number. Sheets reads 8.25 as eight and a quarter, so it multiplies your subtotal by 8.25 rather than by 8.25%. Enter 0.0825 instead. This is by far the most common problem with any spreadsheet invoice template and it takes two seconds to fix.
Can I add more line items?: Yes — insert rows inside the existing table, not below the last one. Inserting inside makes the subtotal range grow with them. A row added underneath the table sits outside the sum and gets silently left out of the total, which means you under-bill and nobody tells you.
One of my line totals stopped updating. What happened?: Something was typed directly into that cell, which replaced the formula. Undo if it just happened; otherwise copy the cell from the row above and paste it into the broken row. It is worth checking the whole column before you send an invoice you have edited heavily.
Should I send the spreadsheet or a PDF?: A PDF. File → Download → PDF Document. Sending the live sheet means the client sees your formulas, can change numbers, and may ask for edit access. It also means the document they hold can differ from the one you sent, which defeats the purpose of an invoice as a record.
Can I use this in Excel instead?: You can download it as .xlsx and the formulas carry over, but if Excel is where you work then take the Excel version directly — it is built for it and the formatting is set up for Excel's print engine rather than converted into it.
Does it track which invoices are paid?: No. Each copy is a standalone document. If you need to know what is outstanding without opening files one at a time, that is the point at which invoicing software starts paying for itself — usually somewhere around ten open invoices.