Free template

Free Invoice Template for Google Sheets (Auto-Calculating)

By PDF Invoice Pro · Published

Free Google Sheets invoice template cover with an example invoice

The short answer

Download the free .xlsx invoice template below, upload it to Google Drive and double-click it to open it in Google Sheets. Enter quantities and rates and the line amounts, subtotal, tax, total and balance due calculate automatically. Export it with File → Download → PDF.

Download the Google Sheets invoice template

How to open the template in Google Sheets

  1. Download invoice-template.xlsx above.
  2. In Google Drive, choose New → File upload and pick the file.
  3. Double-click it in Drive to open it in Google Sheets (Google Docs Editors Help).
  4. To work on a native Sheets copy, choose File → Save as Google Sheets.

How the formulas work

Only the white input cells need typing. The shaded cells are formulas, so they stay right as you add or change lines:

Calculated cells in the template
CellFormula (in words)
Amount (each line)Quantity × Rate
SubtotalSum of every line amount
TaxSubtotal × the tax rate you enter
TotalSubtotal + Tax + Shipping
Balance dueTotal − Amount paid

Want to check a tax figure? The VAT calculator and the sales tax calculator show the working, including how to take tax back out of a tax-inclusive price.

How to fill in and send the invoice

  1. Enter your business details and the client’s at the top.
  2. Set the invoice number, invoice date and due date. On Net 30, the due date is 30 days after the invoice date — the invoice due date calculator works it out.
  3. Type each line: description, quantity, rate. The amount fills itself in.
  4. Enter your tax rate, any shipping and any amount already paid.
  5. Add payment details and notes, then File → Download → PDF and send the PDF.

Keep one master copy. Make a copy of the sheet for each new invoice (File → Make a copy) and change the invoice number every time. Overwriting last month’s invoice is the most common way numbers get reused.

Google Sheets template vs. an invoice generator

Choosing between the Sheets template and the generator
Google Sheets templatePDF Invoice Pro generator
Account neededA Google accountNone
Totals and taxFormulas in the sheetCalculated as you type
LooksA spreadsheet layout33 designs and 160 industry templates
Logo, signature, payment QR codeInsert by handBuilt-in fields
Track many invoices in one fileYes — a sheet per invoiceOne invoice at a time; your draft is kept in your browser
OutputPDF via File → DownloadPDF download or print

Sheets is a good fit if you already keep your records in a spreadsheet. If you want a designed invoice without fiddling with print margins, the free invoice generator produces one with no sign-up and no watermark — or start from an industry template.

Frequently asked questions

Does Google Sheets have an invoice template?

Google’s template gallery has offered invoice layouts, but the selection changes. The template above is a free .xlsx file with working formulas that opens directly in Google Sheets.

Will the formulas work in Google Sheets?

Yes. The template uses ordinary multiplication and SUM formulas, which Google Sheets supports when it opens an Excel file.

How do I turn the sheet into a PDF invoice?

Choose File → Download → PDF. In the export options you can fit the sheet to the page width and hide gridlines so it looks like a printed invoice.

What is the best free program to create invoices?

It depends on how you work. A spreadsheet suits people who already track income in Sheets or Excel. A free invoice generator suits people who want a designed PDF with totals calculated and no setup. Both are free.

Can I use the same template for every client?

Yes — make a copy for each invoice and change the number, date, client and lines. Keep each sent invoice as its own file or PDF for your records.

Make your invoice now

Free invoice generator: no sign-up, no watermark. Add your logo and tax, then download a PDF.

Open the invoice generator

Keep going

Sources

General information, not legal, tax or financial advice. Rules differ by country.