Invoice Template for Google Sheets: Free + How to Use It
Google Sheets is great for tracking invoices but not ideal for creating them. Here's everything you need — a free template, setup steps, and an honest look at when to switch to something better.
Google Sheets Invoice Template — What's in It
A well-built Google Sheets invoice template includes these columns and sections:
| Section | What to include |
|---|---|
| Header | Your name, company name, address, email, phone, logo |
| Client info | Client name, company, billing address |
| Invoice details | Invoice number, date, due date, payment terms |
| Line items | Description, quantity, unit price, line total (=B×C formula) |
| Tax column | VAT/GST % per line or as a total (=subtotal×tax_rate) |
| Totals | Subtotal, tax amount, grand total |
| Payment status | Paid / Unpaid / Overdue (manual update) |
| Notes | Bank details, payment instructions, thank you note |
The big advantage of Sheets over a Word template: you can track all your invoices in one spreadsheet. One row per invoice, filter by client or status, and get a total of outstanding amounts with a simple =SUMIF.
How to Create an Invoice in Google Sheets (Step by Step)
- 1Find a template. In Google Sheets, go to File → New → From template gallery → search "Invoice". Google offers a basic one for free. Copy it to use as your base.
- 2Customize the headers. Replace the placeholder name and address with your own. Add your logo via Insert → Image → Image in cell. Update brand colors if you like.
- 3Add line item formulas. In the total column, enter =B2*C2 where B = quantity and C = unit price. In the subtotal cell: =SUM(D2:D20). For VAT: =subtotal*0.21 (or your rate). Grand total: =subtotal+vat.
- 4Export as PDF to send. File → Download → PDF document. Important: set the print area to only include the invoice cells, not the whole spreadsheet. Otherwise it looks messy.
- 5Manually track payment status. On a second tab, keep a tracker: invoice number, client, amount, sent date, due date, status (Sent/Paid/Overdue). Update it when money arrives.
The 3 Big Problems with Google Sheets Invoices
1. No automatic reminders
When an invoice goes overdue, Sheets does nothing. You have to manually notice it, compose a reminder, and send it yourself. Most freelancers forget — or hate the awkwardness — and just don't follow up. That costs real money.
2. Manual PDF export every single time
Every invoice requires: open Sheets → update values → export PDF → attach to email → write the email → send. That's 5+ minutes per invoice. For 10 invoices a month, that's nearly an hour of admin.
3. No payment tracking
You have no idea if the client even opened the invoice. Did it land in spam? Are they ignoring it? Sheets can't tell you. You're flying blind until payment arrives — or doesn't.
When to Graduate from Google Sheets
Time to move on when any of these apply:
- →You send more than 5 invoices per month — the manual overhead adds up fast
- →You have any overdue invoices — you need automatic reminders, not mental notes
- →You want to know when clients view invoices — open tracking changes your follow-up timing
- →You want automated follow-ups — so you don't write the awkward "just checking in" email
- →You're losing track of what's paid vs outstanding — dedicated tools give you a real dashboard
Free Online Invoice Generator (Better Than Sheets)
If you don't want to set up formulas manually, our free online invoice generator creates a professional invoice in 60 seconds. No spreadsheet setup, no formula errors, download as PDF instantly.
The difference with dedicated invoicing software like Chaser: the generator gives you the PDF. Chaser takes it further — it also chases the invoice with automated reminders at day 3, 7, 14, and 30.
Stop chasing invoices manually 🐕
Chaser sends automated payment reminders at day 3, 7, 14, and 30. You focus on the work — we chase the payment.
Try Chaser Free →Frequently Asked Questions
Is there a free invoice template for Google Sheets?
Yes — Google has a built-in invoice template in the template gallery (File → New → From template gallery). It's basic but functional. You can also create a custom one with =B2*C2 formulas for line totals.
What formulas do I need for a Google Sheets invoice?
Key formulas: =B2*C2 for line total (quantity × rate), =SUM(D2:D10) for subtotal, =subtotal*tax_rate for VAT/tax, =subtotal+tax for grand total. That covers 90% of invoice math.
Can I send invoices directly from Google Sheets?
Not natively. You export as PDF (File → Download → PDF) and attach to an email. Some Google Workspace add-ons allow direct sending, but dedicated invoicing tools are smoother.
Is Google Sheets good enough for invoicing?
For 1-3 invoices a month with reliable clients: yes. For more volume or any chasing needed, dedicated tools like Chaser save significant time and reduce late payments.