Free Google Sheets Invoice Template
Fill in quantity and unit price for each line; the amounts, tax and total due are formulas. Export it as a PDF from Google Sheets and send it to your client.
What it looks like
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Description | Qty | Unit price | Amount |
| 2 | Website design | 1 | 1,200 | 1,200 |
| 3 | Hosting (12 months) | 12 | 15 | 180 |
| 4 | Content updates (hours) | 6 | 60 | 360 |
| 5 | Subtotal | 1,740 | ||
| 6 | Tax | 0.08 | 139.2 | |
| 7 | Total due | 1,879.2 |
What's included
- Line amounts calculated from quantity × unit price
- Tax rate in one cell, applied to the subtotal
- Prints cleanly to PDF (File → Download → PDF)
How to set up the invoice template
- 1.Download the CSV and import it into Google Sheets.
- 2.Insert rows above Subtotal for more line items and extend SUM(D2:D4).
- 3.Set your tax rate in C6 (0.08 = 8%). Use 0 if you don't charge tax.
- 4.Add your business name, client details, invoice number and due date in rows above the table.
- 5.Format Amount as currency, then File → Download → PDF to send it.
Questions
- Can I use this invoice template for free?
- Yes, for personal and commercial invoices.
- How do I number invoices automatically?
- Keep one tab per invoice and put the number in a cell like B1. A simple pattern is ="INV-"&TEXT(ROW(),"0000") on a log tab.
More templates
CRM Template
A simple sales pipeline in Google Sheets with deal stages, probabilities and a weighted forecast.
Get the templateBudget Template
A free monthly budget for Google Sheets that compares what you planned with what you actually spent.
Get the templateExpense Tracker
Log every expense with a date and category, and see totals per category update instantly.
Get the template