Free Google Docs & Google Sheets Invoice Templates (How to Use Them)

If you live in a browser, Google Docs and Google Sheets are an easy, free way to invoice. There is nothing to install, your files sync everywhere, and you can edit from a phone or a laptop. With a few formulas, Sheets will even do your totals and GST for you.

This guide shows how to set up an invoice in both tools, automate the maths in Sheets, export a clean PDF, and share it without exposing your whole spreadsheet. We will also be honest about where these tools stop being the right choice. You can download ready-made Google Docs and Google Sheets versions from our free invoice template library so you are not starting from a blank page.

Google Docs vs Google Sheets: which one?

• Google Docs suits simple, service-style invoices with a few line items and custom wording. It is the easier of the two to make look tidy.
• Google Sheets suits itemised invoices where you want totals and tax calculated automatically. It looks more spreadsheet-like, but the maths is done for you.

The rule of thumb: if you are doing arithmetic, use Sheets. If you are writing, use Docs. This mirrors the wider Word-versus-Excel trade-off we cover in Word vs Excel vs PDF invoice templates.

One advantage both share over their Microsoft equivalents: nothing to install, automatic saving, and access from any device with a browser. That makes them ideal if you invoice on the move, or switch between a desktop at the office and a laptop at home. The trade-off is that you are tied to having a Google account and an internet connection, though offline editing is available if you set it up in advance.

Setting up an invoice in Google Docs

1. Open a new document and add your logo at the top, then your business name, ABN, address and contact details.
2. Insert a table for line items with columns for description, quantity, unit price and amount.
3. Add your client's details, an invoice number, the issue date and the due date.
4. Below the table, add subtotal, GST and total rows — you will type these figures in manually, as Docs does not calculate.
5. Finish with your payment details: account name, BSB, account number and a request to use the invoice number as the reference.

For the full list of fields every invoice needs, see what to include on an invoice.

Setting up totals and GST in Google Sheets

This is where Sheets earns its place. A few formulas remove the arithmetic and the errors that come with it.

Line totals

If quantity is in column C and unit price in column D, your line total in column E is:

• =C2*D2 — multiply quantity by unit price for each row. Copy it down for every line.

Subtotal

Sum all your line totals:

• =SUM(E2:E20) — adjust the range to cover your rows.

GST

For Australian GST at 10 percent, if your subtotal is in cell E21:

• =E21*0.1 — calculates the GST amount.
• =E21*1.1 — gives the total including GST.

Set these up once and every future invoice inherits the logic. If you are registered for GST, your invoice must be labelled as a tax invoice and show the GST clearly — our tax invoice template and free Australian tax invoice template have the required structure built in.

Exporting to PDF

Never send the live Google file. Export a PDF so the layout is locked and the client cannot edit it.

• In Docs: File, then Download, then PDF Document.
• In Sheets: File, then Download, then PDF — and crucially, in the export dialog set it to fit to one page, hide gridlines, and check the print area so columns do not spill onto a second page.

Getting a Sheets invoice to export cleanly takes a little fiddling the first time. Once your print settings are right, save the file as your master and reuse it. For why PDF is the format to send, see our format comparison.

Sharing safely

It is tempting to share the Google link, but that exposes your spreadsheet — including any other clients' data on nearby tabs, and your formulas. Two safer options:

• Send the PDF as an email attachment. This is the standard, safe approach.
• If you must share the live file, make a copy containing only that one invoice, set sharing to view-only, and double-check no other data is visible.

Where Google Docs and Sheets fall short

For occasional invoicing, these tools are genuinely good and genuinely free. But as your volume grows, the cracks show:

• Manual everything. Each invoice means copying the master, updating the client, the number and the dates by hand. Easy to forget a step.
• No tracking. Google will not tell you which invoices are paid, overdue or outstanding. You track that separately or not at all.
• Layout fragility. One stray edit to a formula or a merged cell and your invoice is silently wrong or visually broken.
• No reminders. Chasing late payment is entirely on you.

If those limits start to bite, a dedicated tool is the natural upgrade. It keeps the free-and-browser-based feel while adding numbering, tracking and reminders. Compare the approaches in invoice template vs invoice generator and invoice generator vs invoicing software, or jump straight to the free invoice generator. Our best free invoice generators for 2026 roundup is a useful shortlist if you want options.

FAQs

Are Google Docs and Sheets invoice templates really free?

Yes. Both tools are free with a Google account, and the invoice templates are free to download and use. You only ever pay if you outgrow them and move to a paid invoicing tool. Our Google Docs and Sheets templates are free as well.

How do I calculate GST automatically in Google Sheets?

Add a formula that multiplies your subtotal by 0.1 for the GST amount, and by 1.1 for the GST-inclusive total. For example, if your subtotal sits in cell E21, use =E21*0.1 for the tax and =E21*1.1 for the total. Set it up once and reuse the sheet.

Can I send a Google Sheets invoice directly to a client?

You can, but it is better to export a PDF and attach that instead. Sharing the live sheet can expose other data and lets the recipient edit figures. A PDF locks the invoice and looks more professional.

When should I move on from Google Docs or Sheets?

When manual copying, missing invoice numbers, or untracked payments start costing you time. At that point a generator that stores your details, numbers invoices automatically and tracks what is paid will save more time than it costs. The InvoiceSonic generator is free to try.