Google Sheets Invoice Template: Free Download + How to Set It Up

Google Sheets is free, works on any device, and saves automatically to Drive — which makes it a reasonable place to build an invoice when you are just getting started. This guide gives you a template you can use immediately, walks through how to set it up, and covers the point where Sheets starts to slow you down so you know when to move on.

What a Google Sheets invoice needs to include

Before you open Sheets, get clear on the required fields. An invoice that is missing any of these will slow down payment or create a dispute later.

• Your name or business name, address, phone, and email
• Your client's name and billing address (the company name and the person who approves invoices, not just the general email)
• A unique invoice number — start at 1001 or use a format like 2026-06-001 so they sort correctly
• Invoice date and due date — both, explicitly; "Net 30" without a date is an argument waiting to happen
• Itemized line items — description, quantity, rate, and line total for each service or product
• Subtotal, any tax, and the total amount due
• How to pay — bank account details, PayPal, or a payment link; this is the most skipped field and the one that most directly delays payment

The fastest way to get a Google Sheets invoice template

The quickest path is to use WaffleInvoice's free invoice generator: fill in your details online, preview the layout instantly, and click Download for Google Sheets to get a CSV file. In Google Sheets, choose File → Import → Upload, select the CSV, and your invoice appears as a clean grid ready to use. No formatting work required.

You can find the template at waffleinvoice.com/invoice-template/google-sheets. It is free and requires no account.

If you want to build from scratch instead, read on.

How to build a Google Sheets invoice template from scratch

Open a new Google Sheets document and set it up in the following sections. Row numbers are approximate — adjust to suit your layout.

Header block (rows 1–8)

Put your business name in cell A1, large and bold. Below it, add your address, phone, and email. On the right side (columns E–G), add the word "INVOICE" in large text, and below it the invoice number, invoice date, and due date as labeled fields. This gives you the standard two-column invoice header in about eight rows.

Bill To block (rows 10–15)

Label cell A10 "Bill To:" in bold. Add the client name in A11, company in A12, and address in A13–A14. Keep it simple.

Line items table (rows 17–30)

Set up a table with these column headers: Description (A), Quantity (B), Rate (C), Amount (D). Bold the headers and add a background color. For the Amount column, put a formula in D18: =B18*C18. Copy that formula down for as many rows as you need.

Totals block (rows 31–34)

Label E31 "Subtotal" and put =SUM(D18:D30) in F31. Add a tax row if needed: =F31*0.08 for 8% tax, adjusting the rate as required. For the total, =F31+F32. Make the total row bold with a border.

Payment instructions (row 36 onward)

Add a "Payment Instructions" section below the totals. Write out exactly how to pay you: bank name and account details for ACH, PayPal email, Venmo handle, or a link to your payment page. Leave a space for notes ("Please reference invoice number on payment"). This section gets skipped constantly — do not skip it.

Automating totals: the three formulas you need

Google Sheets handles math cleanly once the formulas are in place. Here are the three you actually need:

• Line total: =B18*C18 — multiplies quantity by rate. Copy this down for every line item row.
• Subtotal: =SUM(D18:D30) — sums all line amounts. Adjust the range to match your line item rows.
• Total with tax: =F31+(F31*tax_rate) where tax_rate is a decimal like 0.085. Or put the rate in a dedicated cell and reference it so you can change it without editing the formula.

Format the Amount and Total columns as currency: select the column, choose Format → Number → Currency. This stops Sheets from showing bare decimals.

Saving a clean copy for reuse

Once your template is set up, protect it so you do not accidentally overwrite the formulas. Go to Data → Protect sheets and ranges and lock the formula cells. Then for each new invoice, duplicate the tab (right-click the tab → Duplicate), rename it with the invoice number, and fill in the client details and line items on the copy. The template stays clean.

Alternatively, use File → Make a copy each time. Either approach works for a handful of invoices per month.

Sending a Google Sheets invoice as a PDF

Clients prefer PDF: it looks the same on every device and cannot be accidentally edited. To export, go to File → Download → PDF. In the print dialog, set the page orientation to portrait and scale to fit on one page. Check the preview before downloading — sometimes the right side gets cut off and you need to adjust column widths or margins.

One small detail: before exporting, make sure the "How to pay" section is on the same page as the totals. A PDF that hides the payment instructions on page two delays payment just as much as leaving them out entirely.

When Google Sheets starts to slow you down

A Sheets template works well for one to three invoices a month. Once volume grows, the manual steps compound: duplicating the tab, updating the date and number, reformatting the PDF export, emailing it, then checking back later to see if it was paid. None of those steps is hard, but they add up.

Dedicated invoicing software handles the repetitive parts automatically: invoice numbers increment on their own, payment reminders go out when invoices are overdue, and you can see at a glance what has been paid and what has not. WaffleInvoice is free to start, sends invoices directly from the platform, and does not require a credit card to sign up. The Sheets template is a reasonable starting point; software is the right tool once you are sending more than a few invoices a month.

Related resources: Google Sheets invoice template (download) · Google Docs invoice template · Excel invoice template · How to write an invoice