Free template
Free Invoice Template for Google Sheets (Auto-Calculating)
By PDF Invoice Pro · Published
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
- XLSX
Opens in Excel and Google Sheets. Line amounts, subtotal, tax, total and balance due are formulas, so they update as you type.
Invoice template (Excel .xlsx) - DOCX
Opens in Microsoft Word, Google Docs, LibreOffice and Pages. Type over the placeholder text; Word does not recalculate the totals.
Invoice template (Word .docx) - PDF
A blank, print-ready A4 invoice to fill in by hand.
Printable invoice template (PDF)
How to open the template in Google Sheets
- Download invoice-template.xlsx above.
- In Google Drive, choose New → File upload and pick the file.
- Double-click it in Drive to open it in Google Sheets (Google Docs Editors Help).
- 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:
| Cell | Formula (in words) |
|---|---|
| Amount (each line) | Quantity × Rate |
| Subtotal | Sum of every line amount |
| Tax | Subtotal × the tax rate you enter |
| Total | Subtotal + Tax + Shipping |
| Balance due | Total − 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
- Enter your business details and the client’s at the top.
- 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.
- Type each line: description, quantity, rate. The amount fills itself in.
- Enter your tax rate, any shipping and any amount already paid.
- 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
| Google Sheets template | PDF Invoice Pro generator | |
|---|---|---|
| Account needed | A Google account | None |
| Totals and tax | Formulas in the sheet | Calculated as you type |
| Looks | A spreadsheet layout | 33 designs and 160 industry templates |
| Logo, signature, payment QR code | Insert by hand | Built-in fields |
| Track many invoices in one file | Yes — a sheet per invoice | One invoice at a time; your draft is kept in your browser |
| Output | PDF via File → Download | PDF 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 generatorKeep going
Sources
- Work with Office files in Google Drive — Google Docs Editors Help
- Recordkeeping — IRS
General information, not legal, tax or financial advice. Rules differ by country.