Google Sheets is the strongest of the free DIY invoicing options. It calculates like Excel, is accessible from anywhere like Docs, and — with one extra tab — can double as a basic record of what you have billed and what you have been paid.

Here is how to build it, including the formulas that make it hold together.

Two tabs, not one

This is what turns a template into something useful:

• Tab 1 — Invoice. The document you export and send.
• Tab 2 — Log. One row per invoice: number, client, date, due date, amount, status, date paid.

The Log tab is where you get the thing no template gives you — an answer to “what am I owed right now?”

Formulas for the invoice tab

That last formula is the useful one. It reads the highest invoice number from your Log tab and increments it, which eliminates the duplicate-number problem that plagues Word and Excel invoicing.

Formulas for the log tab

Exporting a Sheets invoice to PDF

Sheets exports badly by default. Fix it once:

1. Select your invoice range → File → Print
2. Print → Selected cells
3. Scale → Fit to width
4. Margins → Narrow
5. Formatting → uncheck Show gridlines and Show notes
6. Headers & footers → uncheck everything
7. Export as PDF

Those settings persist per sheet, so you only do this once.

Protect your formulas

Data → Protect sheets and ranges → protect the formula cells (E column, totals block) while leaving description, quantity and rate editable. Without this, the first time you paste a client address into the wrong cell you will overwrite a formula and not notice for three invoices.

Where Sheets still falls short

• No client database. You are still retyping or copying client details.
• No sending or reminders. You export and email manually, and chase manually.
• Design ceiling. A Sheets invoice can look tidy; it rarely looks designed.
• Multi-currency is painful. Handling exchange rates in a spreadsheet is possible and rarely worth it.

For most people the honest answer is that Sheets is the right tool for the first year, and the log tab is what tells you when you have outgrown it — when reconciling it starts taking longer than the invoicing did. See invoice generator vs invoicing software.

Frequently asked questions

Is Google Sheets good for invoicing?

For a small volume, yes — it is the strongest free DIY option because it calculates, is accessible anywhere, and can track receivables on a second tab. It stops being adequate when reconciling the log takes longer than producing the invoices.

How do I automatically number invoices in Google Sheets?

Keep a log tab with invoice numbers in column A, then use =”INV-“&TEXT(YEAR(TODAY()),”0000″)&”-“&TEXT(MAX(Log!A:A)+1,”000”) on the invoice tab. It reads the highest existing number and increments it.

How do I export a Google Sheets invoice as a PDF?

Select the invoice range, File → Print, choose Selected cells, fit to width, turn off gridlines and notes, then export. The settings save per sheet so you only configure it once.

Can I track paid and unpaid invoices in Google Sheets?

Yes — a log tab with a status column plus SUMIF formulas gives you total outstanding and total overdue. Conditional formatting on days-overdue makes late invoices visible at a glance.

Related guides

• Invoice template for Excel
• Invoice template for Google Docs
• Invoice numbering formats
• Invoice generator vs invoicing software
• Accounts receivable basics