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

ABCD
1DescriptionQtyUnit priceAmount
2Website design11,2001,200
3Hosting (12 months)1215180
4Content updates (hours)660360
5Subtotal1,740
6Tax0.08139.2
7Total due1,879.2
Tab: Invoice. Teal cells are live formulas; hover one to see it.

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. 1.Download the CSV and import it into Google Sheets.
  2. 2.Insert rows above Subtotal for more line items and extend SUM(D2:D4).
  3. 3.Set your tax rate in C6 (0.08 = 8%). Use 0 if you don't charge tax.
  4. 4.Add your business name, client details, invoice number and due date in rows above the table.
  5. 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