AvoInvoice Template for Google Sheets (Free)
If you want the totals to add themselves, use a spreadsheet. This Google Sheets invoice template has formulas for each line amount (quantity × rate), the subtotal, tax at a rate you set, a deposit credit and the total due, laid out to print on one page. It is delivered as an .xlsx so it imports into Google Sheets and opens in Excel and Numbers unchanged.
Free, one page, US Letter. No email, no sign-up. The second tab is a simple invoice log: number, client, date, amount, paid, so the file is also your tracker.
Same layout in other formats: Fillable PDF · Word (.docx)
The layout: header, bill-to block, line table, totals, terms. Same in every format; the format changes how you fill it.
How to use the Google Sheets template
- Import into Google SheetsDownload the .xlsx. In Sheets: File → Import → Upload, choose “Replace spreadsheet” or “Insert new sheet”. Formulas and formatting carry over.
- Set up the master onceYour business details in the header, your tax rate in the tax cell (0 if you do not charge tax), your terms in the notes box. Rename the file “Invoice master”.
- Make a copy per invoiceFile → Make a copy, name it by invoice number. Type the client, dates, and for each line a description, quantity and rate; the amount, subtotal, tax and total calculate.
- Download as PDFFile → Download → PDF, set “Current sheet”, fit to width, portrait. Attach the PDF; log the invoice on the second tab.
Where Google Sheets is the right choice
Good
- Totals, tax and deposit math calculate
- Doubles as an invoice log
- Works in Sheets, Excel and Numbers
Watch out
- Print layout needs a check the first time
- Easy to overwrite a formula by typing in the wrong cell
- Looks like a spreadsheet unless you keep the formatting
Word vs PDF vs Google Docs vs Google Sheets
| Word | Google Docs | Google Sheets | ||
|---|---|---|---|---|
| Totals calculate | No | No | No | Yes |
| Edit the layout | Yes | No | Yes | Partly |
| Fill on a phone | Partly | Yes | Yes (app) | Partly |
| Needs an account | No | No | Google or Excel | |
| Sends as | Save as PDF | Download as PDF | Download as PDF | |
| Best for | Custom look | Fastest, any device | Shared Drive | Math and a log |
Fill it on your iPhone in a minute instead
Avo keeps your clients and your usual line items, so the next invoice is three taps. Your first three documents are free, full-quality PDF, no watermark. Premium from $59.99/year if you invoice often.
Scan the code with your iPhone camera to open Avo in the App Store, or email yourself the link.
Questions
Does Google Sheets have an invoice template?
Yes, in the template gallery under Work. It has basic formulas but no tax or deposit handling and no log. This template adds those and prints on one page.
How do I stop the formulas from breaking?
Type only in the description, quantity and rate cells; the amount column and the totals are formulas. If one breaks, re-download the template and copy your lines back.
Can I use this template in Excel?
Yes. The .xlsx opens in Excel and Numbers with the same formulas. Only the import step is specific to Google Sheets.
How do I add tax to some lines but not others?
Set the tax rate in the tax cell and mark taxable lines with a “Y” in the tax column; the formula taxes only those. Labor is tax-exempt in many states while materials are not, which is why the column exists.