Google Sheets Invoice Template
A pre-filled spreadsheet invoice with the math already wired in — line totals, subtotal, tax, and grand total update as you type. Copy the workbook into your own Google Drive in one click, fill the rows, and export to PDF for the client send. Free with any Google account, no signup, no watermark.
Part of our free invoice template library — 80+ industry-specific templates in five formats.
- Best for
- Anyone who wants formulas to do the math — line totals, subtotals, tax, and a paid/unpaid log
- Math built in
- =SUM, =A*B line totals, =SUBTOTAL*tax, =SUMIF for paid YTD across a Client Log tab
- Send method
- File → Download → PDF for the client send, or share the workbook with a Viewer link
- Doesn't fit if
- You want page-perfect typography out of the box — use Google Docs; or you send 10+/month — use software
Get the workbook into your Drive
The button opens Google Sheets and prompts you to copy the workbook into your own Drive — the original stays untouched as the master template. From there, edit, share, or export like any spreadsheet you own. Formulas come pre-wired.
Step 1
Click the button — Sheets opens with a "Copy document" prompt.
Step 2
Confirm Make a copy. The workbook lands in your Drive, fully editable.
Step 3
Fill the rows — formulas update — then File → Download → PDF.
Want a pre-filled industry version instead?
These industry templates ship with the right line items and download in PDF, Word, Excel, Google Docs, and Google Sheets — no copy-to-Drive step needed:
Prefer a different format? You can also use the Google Docs version (better layout, no formulas), Microsoft Excel (same formulas, offline), or a flat PDF.
What to include on a Google Sheets invoice
Eleven items. The first nine are what every US invoice needs to clear AP. The last two — sharing permissions and the optional Client Log tab — are what make the Sheets version actually useful as an ongoing ledger, not just a one-off file. Formulas next to the relevant rows show what each cell should look like.
- 01
Your business details (header rows)
Legal business name, address, phone, email, EIN, and your logo. Use Insert → Image → Image in cell so the logo scales with the row height instead of floating loose over the grid.
- 02
Client / bill-to block
Bill-to name, billing address, AP email. Park it in cells E2:G6 (or wherever your template puts it) so it lines up next to the invoice number block on the printed page.
- 03
Unique invoice number
Sequential (INV-0042) or date-keyed (2026-04-25-01). Drag-fill the next number with the fill handle — Sheets increments INV-0042 → INV-0043 automatically.
- 04
Invoice date and due date
Use real date cells, not text. Set the due date with `=B5+30` (or `+15` for Net 15) so it always tracks 30 days after the invoice date.
- 05
Itemized line items (Description, Qty, Rate, Total)
Four columns. The Total column is a formula: `=B10*C10` (qty × rate). Drag down for every row. This is the single biggest reason to use Sheets over Docs for invoicing.
- 06
Subtotal — `=SUM(D10:D24)`
One formula across the line-item range. If you add or remove rows inside the range, the SUM updates automatically. Add rows above the SUM target row, not below, or the range stops including new lines.
- 07
Tax — `=D26*0.0825` (or your local rate)
Reference the subtotal cell and your tax rate. Park the rate in a named cell (e.g., `TaxRate` in B2) so you can change it once for every invoice copy: `=D26*TaxRate`.
- 08
Grand total — `=D26+D27`
Subtotal plus tax (plus any line for shipping, discount, or retainage). Format as Currency with the locale you bill in: Format → Number → Currency.
- 09
Payment terms and accepted methods
Plain-text cell merged across the bottom. Spell out ACH, check, card, and your bank or pay-link details. Include a late-fee clause — '1.5% monthly interest on overdue balances' is the typical legal cap in most US states.
- 10
Sharing permissions setting
Click Share, set link access to 'Anyone with the link — Viewer'. Never send Editor links to clients — they can change the figures after the fact. Comment access is fine for a bookkeeper review.
- 11
Optional: Client Log tab + Summary tab
Add a second tab listing every invoice you've sent (date, client, amount, status). A third tab can pull `=SUMIF(Log!C:C,"Paid",Log!D:D)` for paid YTD. One workbook becomes your full invoice ledger.
What Google Sheets actually does (and doesn't)
Before you commit to Sheets as your invoicing tool, the eight numbers and capabilities that decide whether it's the right fit:
| Capability | Reality in 2026 | Source |
|---|---|---|
| Cost & install base | Free with any Google account; 3+ billion Workspace users and 13M+ paying business customers | Google Workspace announcement, April 22 2026 (Cloud Next '26) |
| Max cells per file | 10 million cells (raised from 5M in 2022); effectively unlimited for invoicing | Google Docs Editors Help — File size limits (current 2026) |
| Max columns per sheet | 18,278 columns (column ZZZ) | Google Sheets specs |
| Storage included | 15 GB free, shared across Drive, Gmail, and Photos | Google One storage policy |
| Auto-save & version history | Saves to Drive every few seconds; free accounts retain 30 days or 100 versions, whichever comes first | Google Docs Editors Help — version history |
| Export formats | PDF, Excel (.xlsx), CSV, TSV, ODS, HTML — all from File → Download | File → Download menu, Google Sheets Help |
| Built-in formulas | Full spreadsheet engine — `=SUM`, `=ROUND`, `=A2*B2`, `=SUMIF`, `=IF`, named ranges, conditional formatting | Google Sheets function list (500+ functions) |
| PDF export controls | Paper size, orientation, scale-to-fit, gridlines on/off, custom margins, headers/footers | Sheets PDF export dialog (File → Download → PDF) |
The single advantage Sheets has over a Word or Docs invoice: the math can't drift. Type a new quantity and the line total, subtotal, tax, and grand total all recalculate. The single tradeoff: out of the box, a sheet looks like a sheet, not an invoice. Untick gridlines and set scaling to 'Fit to width' before exporting and the PDF cleans up to look professional.
How to make and send the invoice
The six-step copy → fill → formulas → tax → PDF → share workflow that takes about three minutes from open to client inbox.
- 1
Open the template and click File → Make a copy
Click the button above. Google Sheets opens the workbook in read-only mode and prompts you to copy it. Choose File → Make a copy, name it 'Invoice — {Client} — INV-0042', pick the Drive folder, and confirm. The copy is yours; the original stays untouched as the master template.
- 2
Fill in the header — your business, client, dates, invoice number
Type over the placeholder cells in the top block. Date cells (Format → Number → Date) keep the due-date formula `=B5+30` working. Drag-fill the invoice number from your last one and Sheets increments INV-0042 → INV-0043 automatically.
- 3
Enter line items — formulas auto-calculate every row
Type Description, Qty, and Rate in each row. The Total column is a formula (`=B10*C10`) that's already drag-filled down 15 rows. Insert more rows inside the line-item range with right-click → Insert 1 above so the SUM range expands; inserting below the SUM cell silently breaks it.
- 4
Set the tax rate cell once
Find the named cell at the top (we use `TaxRate` in B2 by convention) and type your local rate as a decimal — 0.0825 for an 8.25% combined rate, 0 for non-taxable services. The tax line uses `=D26*TaxRate`, so changing one cell updates every invoice copy you make from this template.
- 5
Export to PDF — File → Download → PDF
Open File → Download → PDF (.pdf). In the export dialog: set Paper size to Letter (or A4), Orientation to Portrait, Scale to 'Fit to width', and untick 'Show gridlines'. Headers/footers off. Click Export — the PDF renders the invoice cleanly with no spreadsheet cruft.
- 6
Share or email the PDF to the client
Attach the PDF to a normal email — that's what AP departments file. Or go straight from Sheets: File → Email → Email this file → attach as PDF, and Google sends it from your connected Gmail in one step. Optionally, share the workbook itself with a Viewer link so the client can verify line items but not change them.
Google Sheets vs Google Docs vs Excel: which one and when
All three are free or near-free, all three export to PDF, all three can hold an invoice. They split cleanly by use case:
| Format | Best for | Skip if |
|---|---|---|
| Google Sheets | Formula-driven invoicing — many line items, conditional math, a Client Log tab tracking paid/unpaid YTD | You want a one-page service invoice with a paragraph of context |
| Google Docs | Prose-style invoices — cover letter, scope notes, page-perfect typography, 1–6 line items you can total by hand | You need any auto-summing — Docs tables don't do math |
| Microsoft Excel | Same spreadsheet workflow as Sheets, but offline-first and accepted by corporate AP departments that require .xlsx | You don't have Excel installed and don't want to pay for Microsoft 365 |
Rule of thumb: open a calculator? Use Sheets. Writing a paragraph the client needs to read? Use Docs. Working offline on a flight? Use Excel.
The five formulas that run the whole invoice
You don't need to learn spreadsheet engineering to invoice in Sheets. These are the five cells that do the work. Copy them into your own template if you're building from scratch.
| Cell purpose | Formula | What it does |
|---|---|---|
| Line total (per row) | =B10*C10 | Quantity × rate. Drag-fill down 15 rows so every line item has it pre-wired. |
| Subtotal | =SUM(D10:D24) | Adds every line total in the range. Insert new rows inside the range so the SUM expands automatically. |
| Sales tax | =D26*TaxRate | Multiplies the subtotal by a named cell holding your tax rate (e.g., 0.0825 for 8.25%). Change one cell to update every copy. |
| Grand total | =D26+D27 | Subtotal plus tax. Add another `+D28` for shipping or `-D29` for a discount line. |
| Conditional discount | =IF(D26>1000, D26*0.1, 0) | 10% off when the subtotal crosses $1,000, otherwise zero. Useful for volume-discount line items. |
| Paid YTD (summary tab) | =SUMIF(Log!C:C,"Paid",Log!D:D) | Adds every row in the Client Log tab where status = "Paid". Drop it on a Summary tab for a running revenue figure. |
Sheets has 500+ functions; you'll never need most of them for invoicing. These six cover the math. If you outgrow them, the natural next step isn't more formulas — it's invoicing software that auto-numbers, tracks payment, and chases late accounts for you.
When Google Sheets is the wrong tool
- You need page-perfect typography out of the box. Sheets needs gridline-untick and print-area setup before the PDF looks like an invoice. Use Google Docs if your invoice is a one-pager and you care about how it looks more than how the math works.
- You work offline often (flights, job sites without wifi). Sheets has offline mode but it has to be pre-enabled per device. Use Microsoft Excel for true offline-first invoicing with the same formula engine.
- You send 10+ invoices a month or run recurring billing. A workbook can't auto-number, track payment status, or chase late accounts. Switch to invoicing software like Agiled — the auto-reminders alone pay for the subscription, and you stop juggling Drive folders.
- You don't have a Google account and don't want one. Use the Excel or PDF version — neither requires a Google sign-in.
Google Sheets invoice questions
How do I create an invoice in Google Sheets?
Open a pre-made template (like the one on this page), click File → Make a copy to put it in your Drive, fill in the header cells (your business, client, dates, invoice number), and type Description / Qty / Rate into each line-item row. The Total column, subtotal, tax, and grand total are already formulas — `=B10*C10` for line totals, `=SUM(D10:D24)` for the subtotal, `=D26*TaxRate` for tax — so the math updates as you type. When you're done, File → Download → PDF (.pdf), set 'Fit to width' and untick gridlines, and send the PDF to the client.
Does Google Sheets have invoice templates?
Yes. The Template Gallery at sheets.google.com (visible when you start a new sheet) has a few generic invoice layouts. They work, but they're plain — no late-fee clause, no payment-methods block, no Client Log tab. The template on this page is pre-filled with the eleven fields a US invoice actually needs to clear AP, plus formula cells for line totals, subtotal, tax, and grand total — and an optional second tab to log every invoice you send.
What formulas should I use in a Google Sheets invoice?
Five formulas cover almost every invoice. Line total per row: `=B10*C10` (qty × rate). Subtotal across the line items: `=SUM(D10:D24)`. Tax: `=D26*0.0825` for an 8.25% rate, or `=D26*TaxRate` if you've named a tax-rate cell. Grand total: `=D26+D27`. Conditional discount line: `=IF(D26>1000, D26*0.1, 0)`. If you also want a paid-YTD figure on a summary tab, `=SUMIF(Log!C:C,"Paid",Log!D:D)` totals every row in the Client Log marked Paid.
Google Sheets vs Google Docs for invoicing — which is better?
Sheets if you want the math done for you — line totals, subtotals, tax, multi-line discounts, or a Client Log tab that totals paid YTD. Docs if your invoice is a one-pager with two or three line items and you care more about the prose layout (cover letters, project notes, scope statements). Both are free with a Google account, both auto-save to Drive, and both export to PDF. The split: more than five line items or any conditional math, use Sheets; one-page service invoice with a paragraph of context, use Docs.
Can I email a Google Sheets invoice as a PDF?
Yes — two routes. Standard: File → Download → PDF (.pdf), then attach the file to a normal email. Faster: File → Email → Email this file, choose 'PDF' as the attachment type, and Google sends it from your connected Gmail in one step. Both produce a fixed PDF the client can print, sign, or forward to AP without accidentally changing the figures. Before you export, untick 'Show gridlines' and set scaling to 'Fit to width' so the PDF looks like an invoice and not a screenshot of a spreadsheet.
How big can a Google Sheets invoice workbook get?
Each Google Sheets file caps at 10 million cells, with up to 18,278 columns (column ZZZ); the limit was raised from 5 million to 10 million in 2022 and is still current as of 2026. For invoicing that's effectively unlimited — a workbook with one invoice tab, a Client Log tab, and a Summary tab uses a few hundred cells. Free Google accounts also keep 30 days of edit history (or 100 versions, whichever comes first); mark milestone versions as 'Keep Forever' under File → Version history if you want to retain a fiscal-year snapshot.
Can I edit a Google Sheets invoice on my phone?
Yes. The Google Sheets mobile app (free on iOS and Android) opens the same workbook with full editing — type into cells, the formulas keep working, and you can export to PDF directly from the app. This is genuinely useful for on-site jobs: finish the work, open the invoice on your phone, fill in hours and materials, and the line totals plus tax recalculate as you type. Export to PDF and email or text it before you've left the property.
Outgrown the workbook?
Agiled creates branded invoices in seconds, auto-numbers them, sends with a built-in pay button, and chases late payments automatically — so you stop maintaining a Client Log tab by hand. Free plan, no card required.