Creating a Custom Invoice Template in Google Sheets: A How-To

An Excel invoice is a file you fill in and email. A Google Sheets invoice is a living template you copy for each job, fill in from anywhere, and send as a shared link or a clean PDF — no software to install, nothing to lose on a dead laptop. The build itself (line totals, subtotal, tax) is the same spreadsheet math covered in the invoice template build guide; what’s different in Sheets is the workflow around it. This walks that workflow — starting from a template, locking it against mistakes, spinning up one invoice per client, and getting it out the door.

Start from a template, not a blank sheet

You don’t have to draw an invoice from scratch. Google Sheets ships with one, and copying it is faster than designing your own grid.

1. Open sheets.google.com, click Template gallery, and pick the Invoice template.
2. Replace the placeholder business name, address, and logo (Insert → Image → in cell).
3. Or take any invoice you like and File → Make a copy to make it your master.

The point of starting from a template is that the structure — header, client block, line items, totals — is already laid out and aligned, so you spend your time on your details rather than on borders and column widths. Whichever you start from, the goal is one polished master file you’ll copy for every future invoice. Brand it once: your colors, your logo, your payment terms in the footer, and you never touch the layout again.

Build the one part worth doing yourself

The line-items table is the engine, and it’s worth understanding even in a template. Each row multiplies quantity by unit price to get a line total:

Enter =A2*C2 in the Total column, then drag the small blue fill handle down to copy it to every row — the references shift automatically so each line calculates itself. Below the table, =SUM(D2:D20) gives the subtotal, and the tax and grand-total lines build from there. That’s the whole calculation engine; the full build guide covers discounts and multiple tax rates if you need them.

One formatting step makes the difference between a draft and a document: select the money columns and set Format → Number → Currency so every figure shows two decimals and a currency symbol. A column of raw numbers reads as a worksheet; the same numbers formatted as currency read as an invoice. While you’re there, right-align those columns and give the totals row a bold weight — small touches, but they’re the difference between something a client trusts and something that looks half-finished.

Lock it down with dropdowns

Dropdowns turn a blank template into a guided form. A client-name dropdown, a service-description dropdown, maybe a payment-terms one, and filling an invoice becomes a few clicks rather than a typing exercise. It also keeps your records clean: “Consulting” and “consulting svcs” won’t both show up when every entry comes from the same controlled list, which matters the moment you try to total your income by service later.

One master, one invoice per client

The reusable part is the discipline of never typing over last month’s invoice. Each new invoice is a fresh copy, so the old one stays intact as a record.

1. From your master file, File → Make a copy and name it “Invoice 1042 — Acme.”
2. Or duplicate the tab within one workbook (right-click the tab → Duplicate) to keep a year’s invoices together.
3. Bump the invoice number each time — it must be unique for your records and theirs.

Keeping every invoice as its own copy means you never overwrite a sent invoice, which is exactly the mistake that causes payment disputes. The invoice number is the thread that ties an invoice to a payment, so increment it religiously and never reuse one. A simple convention — year plus a running count, like 2026-014 — keeps them sorted and unmistakable.

Let the dates fill themselves

Every invoice carries two dates — the day it’s issued and the day payment is due — and both can populate from a formula so you never type or miscount them.

Invoice date:  =TODAY()
Due date:      =TODAY()+30

TODAY() stamps the current date, and adding 30 sets net-30 terms automatically — change the number to match your terms. There’s one catch worth knowing: TODAY() recalculates every time the sheet opens, so on an invoice you’ve already sent it would silently drift forward. The fix is to freeze it once the invoice is final — copy the date cell and Edit → Paste special → Values only (Ctrl+Shift+V) — which converts the formula to a fixed date. Use the live formula while drafting, freeze it when you send.

Send a link or a clean PDF

This is where Sheets pulls ahead of a desktop file. You can hand the client a live link or a fixed PDF, whichever they prefer.

A PDF is the right call for a final invoice — it can’t be altered and it prints predictably. A shared view-only link suits ongoing or draft billing where the client might want to watch it update. Either way there’s no attachment to misplace and no “which version is current?” confusion, because the source of truth lives in one place you control.

Name the exported file the way your client will want to file it — something like Invoice-2026-014-Acme.pdf rather than the default “Sheet1.pdf.” A clear filename with the invoice number and your business name in it saves the client digging and makes your own records searchable later. It’s a five-second habit that quietly marks the difference between an invoice that looks improvised and one that looks like it came from a system — which, by this point, yours has.

Keep a running log of what you’ve billed

The invoices themselves aren’t a record you can total — for that, keep a simple log tab listing every invoice, client, amount, and paid status.

One row per invoice — number, date, client, total, paid yes/no — turns a folder of separate invoices into something you can actually analyze: outstanding balances, monthly income, who pays late. It’s the same idea as a sales tracker, applied to billing, and a conditional-formatting rule that reddens unpaid rows past their due date makes overdue invoices impossible to miss. Build the master template once, copy it per client, and log each one — that’s a complete invoicing system in Google Sheets, no subscription required, and entirely yours to change.