Introduction

An invoice is a request for payment, and it is also a record. It tells a client exactly what they are paying for, how much they owe, and when the money is due. Done well, it gets paid faster and generates fewer questions. Done badly, it creates back-and-forth emails and delays.

Google Sheets is a good tool for this job: free with a Google account, in the browser, and it does the arithmetic once the formulas are in place. Start from Google’s built-in Invoice template or build your own layout. Either way, the real value is a reusable system: a master template you copy for each new job, a consistent numbering scheme, and a simple tracker showing which invoices are paid and which are outstanding.

This guide walks through the whole setup. It is general record-keeping guidance, not tax advice, and invoicing requirements — such as whether a tax ID must appear on the invoice — vary by location, so check your local rules before you send your first one.

Start with the built-in template, or build from scratch

Use the built-in Invoice template. Go to sheets.google.com, click Template gallery, and look under the Work section for Invoice. The template already has the main sections in place — business details, client details, a line-items table, and a totals area — so you can start by replacing the sample text with your own information. This is the fastest route if you want to send an invoice today.

Build from scratch. A blank sheet gives you full control over the layout, which matters because the formulas later in this guide depend on fixed cell positions.

Whichever route you take, save a clean master copy first. Name it “Invoice Template — Master” and never send that file to a client. For each new invoice, use File > Make a copy, rename the copy with the client and invoice number, and work in the copy.

The layout: every field your invoice needs

A professional invoice has five sections, working from the top down.

1. Your business details, at the top. Your business name, email address, phone number, and mailing address. If you have a logo, add it with Insert > Image > Insert image in cell, so it stays in place when the invoice is exported to PDF. Use an email clients can reply to; if you are still using a personal inbox, our guide on how to create a professional business email address explains how to set one up.

2. Invoice number, invoice date, and due date. Put these near the top, usually on the right-hand side. The invoice number is your reference for tracking, the invoice date is the day you send it, and the due date is the deadline for payment. Never leave the due date blank — an invoice with no due date can be ignored indefinitely.

3. Bill To — the client’s details. The client’s name or business name, a contact person if you have one, their email address, and their mailing address. Double-check the spelling of the business name and the email address before sending: a misspelled email means the invoice goes nowhere, and a wrong business name can cause a problem when the client’s accounts team tries to process it.

4. The line-items table. The heart of the invoice: four columns — Description, Qty (quantity), Rate, and Amount. Each row is one item, service, or block of time. Be specific in the Description column. “Design work” is vague; “Homepage redesign — 3 pages, includes 2 rounds of revisions” tells the client exactly what they are paying for. Vague descriptions are a common reason clients delay payment while they ask what a line means.

5. Totals, payment terms, and notes at the bottom. Below the line items: subtotal, tax (if applicable), and the total due. Under that, the footer holds your payment terms and notes — how to pay, your payment deadline wording, and any bank details or payment link the client needs.

Set up the formulas so totals calculate themselves

Formulas turn a spreadsheet into a real invoicing tool. Set them up once, and every copy calculates itself. The examples use this layout: line items start on row 16, quantity in column B, rate in column C, amount in column D, ten rows (16–25). Subtotal is D27, tax rate C28, tax amount D28, total due D29. Adjust the references if your layout differs.

Line amount. In the Amount cell of the first line item (D16), enter:

=IF(B16="","",B16*C16)

This multiplies quantity by rate — but only if the quantity cell is filled in, so blank rows stay blank instead of showing a zero. Copy this formula down the whole Amount column, from D16 to D25.

Subtotal. Below the line items, in cell D27, enter:

=SUM(D16:D25)

Tax. If you charge tax, put the tax rate as a percentage in cell C28 — for example, enter 8% as the rate. Then in D28 enter:

=ROUND(D27*C28,2)

This multiplies the subtotal by the tax rate and rounds the result to two decimal places, so you never end up with a total like $512.438. If you do not charge tax, leave the rate at 0% or remove the tax row entirely.

Total due. In D29, enter:

=D27+D28

Due date. If your invoice date is in cell B7 and your terms are net 30 (payment due 30 days after the invoice date), put this in the due date cell:

=B7+30

Change 30 to 7 or 14 to match your terms.

Invoice date. In the invoice date cell, =TODAY() inserts the current date. It updates each time the sheet is opened, so for a fixed record, type the date by hand or use Edit > Paste special > Paste values only after it is set.

Use a numbering system you can follow a year later

Give every invoice a unique number, and never reuse one. A simple system works best: INV-2026-001, then INV-2026-002, and so on, with the year in the middle so each year’s invoices start fresh. Put the number at the top of the invoice and in the file name of the copy, for example “INV-2026-001 — Acme Corp”. Record every number in the tracker tab described below, so you never issue the same number twice or skip one by accident.

Write payment terms that leave no room for doubt

Payment terms are the rules of the invoice, written in plain language in the footer. Say when payment is due, how the client can pay, and what happens if payment is late. A typical wording is:

“Payment is due within 30 days of the invoice date. Please pay by bank transfer to the account listed below, or by card using the payment link. A late fee of 1.5% per month may apply to overdue balances.”

Only promise a late fee if you will enforce it, and check local rules first. Keep terms consistent unless a client has agreed otherwise in writing. Include exactly what the client needs to pay you — bank details, a payment link, or both — because every extra step is a reason for payment to slip a week.

Send the invoice as a PDF

Do not send the Google Sheets link itself. A client with edit access could change a number; a client with view access still sees your other tabs. Export instead: File > Download > PDF. Preview the result to make sure nothing is cut off at the margins. Then attach the PDF to an email with a short message: the invoice number, the total due, the due date, and a thank-you.

Add a tracker tab so nothing goes unpaid

A template alone does not tell you who owes you money. Add a second tab to the master template, called Tracker, with one row per invoice and these columns: Invoice number, Client, Date sent, Due date, Amount, Status (Paid or Unpaid — use a dropdown via Data > Data validation), and Date paid.

Check it weekly: any invoice past its due date and still Unpaid gets a polite follow-up email. Two minutes a week beats discovering a forgotten invoice three months later.

Frequently asked questions

Is Google Sheets free for invoicing?
Yes — Google Sheets is free with a Google account, and the Invoice template, formulas, and PDF export cost nothing.

What should I put on an invoice as a freelancer?
Your business name and contact details, a unique invoice number, the invoice and due dates, the client’s details, itemised lines describing the work, the subtotal, any tax, the total due, and payment instructions. Local rules may require extra items such as a tax ID, so check what applies where you are.

The bottom line

A good Google Sheets invoice is a template, not a one-off document. Set up the layout once, add the formulas so the arithmetic is automatic, number every invoice in sequence, and track each one until it is paid. Send it as a PDF, follow up on anything overdue, and keep the master template clean so the next invoice takes five minutes instead of fifty.