Google Sheets Invoice Template: How to Build a Free One Step by Step (2026)

People search for a Google Sheets invoice template for good reasons. It costs nothing, you probably already have a Google account, the file lives in your Drive instead of on one laptop, and you can share it or export it from any device. For a freelancer or a small business sending a few invoices a month, a spreadsheet is a perfectly reasonable place to start.

It also has honest limits. A sheet does not number your invoices for you, it does not remind a client who forgot to pay, one inserted row can quietly break a formula, and the PDF it exports only looks polished if you set the page up carefully. None of that makes it a bad choice. It means you should build it once, build it properly, and know what you are signing up for. This guide walks through the whole build, then compares it with the alternatives and tells you when it is time to move on.

Does Google Sheets Have a Built-In Invoice Template?

Yes. Open Google Sheets, go to the Template gallery on the home screen (or File, New, From template gallery), and look for the Invoice template under the Work section. It gives you a ready layout with your details at the top, a bill-to block, a line item table and a totals area. Google Docs has a similar one in its own gallery, and there are many third-party templates you can copy from the web.

The built-in one is a fine starting point, but most people end up changing it: the columns do not match how they bill, the tax handling is hard-coded, or the style does not look like their business. If that is you, building your own takes about twenty minutes and you will understand every formula in it, which matters when something breaks later. The rest of this guide builds one from a blank sheet.

Step 1: Lay Out the Sheet

Open a new blank spreadsheet and name it something like 'Invoice TEMPLATE'. You are going to keep this file clean and copy it for each invoice, so the name matters. Then lay out the cells like this. The exact positions below are the ones the formulas in the next step use, so follow them or adjust the formulas to match.

Row 1 to 2, the header. Put your business name in A1 and make it large. Put your address, email and phone in A2, using Ctrl+Enter (Cmd+Enter on Mac) for line breaks inside the cell. Put the word INVOICE in E1. If you have a logo, see the logo note below.

Rows 3 to 6, the invoice details (right side). In D3 type 'Invoice #' and put the number in E3. In D4 type 'Date' and put the date in E4. In D5 type 'Due date' and put the due date in E5. In D6 type 'Terms' and put your payment terms in E6, for example 'Net 14'.

Row 3, the tax rate (left side). In A3 type 'Tax rate' and in B3 enter the rate, for example 0% if you do not charge tax or your local rate if you do. Keeping the rate in one cell means every formula points to it and you never type the rate into a formula by hand.

Rows 5 to 6, the bill-to block. In A5 type 'Bill to'. In A6 put the client name, company, address and email in one cell, again using Ctrl+Enter for line breaks.

Row 7 onward, the line item table. Row 7 is the header row. Column A is Description, B is a Date or Reference column (optional), C is Unit (hours, items, flat fee), D is Quantity, E is Rate and F is Amount. Put those labels in A7 to F7 and give the row a fill color and bold text. Rows 8 to 17 are the ten line item rows. Ten is enough for most freelancers, and you can add more later.

Rows 18 to 21, the totals. In E18 type 'Subtotal', in E19 type 'Tax', in E20 type 'Total due' and in E21 type 'Amount paid' if you accept deposits. The numbers go in column F, directly under the amounts.

Rows 23 to 26, the footer. Put your payment instructions, such as how to pay by bank transfer, the name to make checks out to, or a payment link, and a short thank-you line. If you charge a late fee, write it here in plain words.

A note on what to put on the invoice itself: the fields that make an invoice usable are covered in what to include on an invoice. Make sure your sheet has all of them, in particular a unique invoice number, your contact details, the client's details, a clear description of each item, the due date and payment instructions.

Step 2: Add the Formulas

This is the part that makes a sheet better than a typed document. You only need four formulas.

Line total. In F8 type `=D8E8`. That multiplies quantity by rate. Drag it down to F17 so every line item row has it. If you want empty rows to show nothing instead of 0, use `=IF(D8="","",D8E8)` and drag that down instead.

Subtotal. In F18 type `=SUM(F8:F17)`. This adds every line total. Empty cells and blank text from the IF version are ignored by SUM, so it keeps working whether you use two lines or ten.

Tax. In F19 type `=F18*$B$3`. The dollar signs lock the reference to B3 so it does not shift if you copy the formula. Because the rate lives in one cell, changing it once updates every invoice you make from this template.

Total. In F20 type `=F18+F19`. If you take deposits, put the amount already paid in F21 and use `=F20-F21` for the balance due instead, labeled 'Balance due'.

If you charge tax on only some items, add a column for it, mark taxable lines with a Y, and use `=SUMIF(G8:G17,"Y",F8:F17)*$B$3` for the tax. Whether you need to charge tax at all depends on where you and your client are and what you sell, so check your own rules. The general idea is covered in sales tax on invoices.

If you bill by the hour, put hours in the quantity column and your hourly rate in the rate column, and the same formulas work with no changes. For a flat fee, use a quantity of 1.

Step 3: Format Currency, Dates and Percentages

Select E8 to F21 and choose Format, Number, Currency. If the symbol or the decimals are wrong, use Format, Number, Custom currency and pick yours. Do the same for the subtotal, tax and total cells so everything shows two decimals. Without this, a total of 1250 shows as 1250 instead of $1,250.00 and looks unfinished.

Select B3 and choose Format, Number, Percent so that typing 8.25 shows as 8.25% rather than 825%. Select E4 and E5 and choose Format, Number, Date so the dates display consistently. For the due date you can make the sheet do the work: if the terms are a fixed number of days, type `=E4+14` in E5 for net 14 and the due date updates whenever you change the invoice date.

Then make it look like a document. Turn off gridlines under View, Show, Gridlines, so the sheet looks like a page instead of a spreadsheet. Widen column A so descriptions fit, and turn on text wrapping for column A (Format, Wrapping, Wrap) so long descriptions do not spill across the numbers. Use one font, one accent color for the table header, and plenty of white space.

Adding a logo. Click a cell near the top, then Insert, Image, Image over cells (or Image in cell). Resize it so it fits above your business name without covering the invoice number. Keep the file small so the PDF stays small.

Step 4: Lock the Cells That Should Not Change

The most common way a spreadsheet invoice goes wrong is that someone types over a formula. The fix takes two minutes. Select the cells that hold formulas and fixed text, meaning F8 to F21, the labels, and the footer. Then choose Data, Protect sheets and ranges, and click Add a sheet or range.

Pick the range, click Set permissions, and choose either 'Show a warning when editing this range' or 'Restrict who can edit this range' and set it to only you. The warning option is gentler and good enough if you are the only editor. Leave unlocked the cells you fill in for each invoice: the invoice number, date, bill-to block, and the description, quantity and rate columns.

If several people use the file, restrict the formula range to yourself so that a helpful colleague cannot overwrite the total. Protection stops accidents. It is not a security feature, so do not rely on it to keep data private.

Step 5: Save It as a Reusable Template

The golden rule of a sheet-based invoice is that you never edit the master. You copy it. Once the layout and formulas work, enter a test invoice and check the math by hand. Then clear the sample values and leave the file empty and ready.

Move the file into a Drive folder called something like 'Invoices' and keep it named 'Invoice TEMPLATE'. For each new invoice, open the template, choose File, Make a copy, and name the copy with the client and number, for example 'INV-2026-014 Acme'. Save the copy into a folder for that year or client. Fill in the copy and leave the master alone.

Another common pattern is a single workbook with a hidden or locked tab called 'Template'. For each invoice you right-click that tab and choose Duplicate, rename the copy and fill it in. This keeps every invoice in one file, which makes it easy to search, but it also makes a single mistake more costly and the file slower as it grows. Separate files are safer. A single workbook is more convenient. Pick one and stick with it.

If you want to offer a template to other people, File, Share, Publish to web is not the way. Instead, share a link with 'Make a copy' behavior by replacing /edit at the end of the share URL with /copy. Anyone who opens that link is asked to make their own copy, and your original is never touched.

Step 6: Number Your Invoices Without Collisions

Spreadsheets will not number invoices for you, so this is the step where discipline matters. The two things that go wrong are duplicate numbers and gaps you cannot explain. Both look bad to a client and to an accountant.

The simplest reliable approach is a separate tab called 'Log' with one row per invoice: number, date, client, amount, status (sent, paid, overdue). Before you issue an invoice, look at the last row of the log and use the next number. After you send it, add the row. The log doubles as your list of who owes you money.

For the format, a year plus a running count such as INV-2026-014 is easy to read and sorts correctly. You can make the sheet suggest the next number: if the numbers in the log are in column A, `="INV-2026-"&TEXT(COUNTA(Log!A2:A)+1,"000")` produces the next one. Treat it as a suggestion, since it breaks if you delete a row. The reasoning behind formats, prefixes and what to do about corrections is in invoice number format best practices.

Never reuse a number, even for an invoice you voided. If you need to correct one, issue a new invoice or a credit note and keep the old number in the log marked void.

Step 7: Export It as a PDF

Send a PDF, not a link to the sheet. A PDF cannot be edited by accident and looks the same on every device. Before you export, check the page setup, because this is where spreadsheet invoices usually look bad.

Choose File, Print (or press Ctrl or Cmd plus P). In the print settings, set the paper size, choose Portrait, set the scale to Fit to width, and set Margins to Normal or Narrow. Under Formatting, turn off gridlines and notes and choose to hide the sheet name and page numbers if you do not want them in the header. Then set the print range: choose Selected cells and select A1 to F26, or whatever range holds the invoice, so you do not print empty columns or a second page.

Look at the preview. If the table is cut off on the right, reduce the scale or narrow a column. If a blank second page appears, the print range is too long. When it looks right, you can click Next and save as PDF from the print dialog, or close it and use File, Download, PDF (.pdf). The download dialog has the same layout settings.

Name the file clearly, for example 'INV-2026-014 Acme.pdf', and attach it to your email. Some corporate accounts payable teams are strict about PDFs, so it is worth reading the invoice template download guide for what each format is good at.

A Quick Google Docs Version

You can also build an invoice in Google Docs, and a lot of people search for a Google Docs invoice template for that reason. The layout is simpler to style, since you are writing in a normal document, and it prints well. The trade-off is the math: a Docs table has no formulas, so you calculate each line, the subtotal, the tax and the total by hand or with a calculator.

If you go this way, use a table for the line items and a second small table for the totals, and double-check the arithmetic every time. A middle path is to keep a sheet for the numbers and paste the results into a Docs layout, but at that point you are doing the work twice. Docs is fine for a fixed-price job with two or three lines. For anything with quantities, hours or tax, Sheets is the better tool.

Google Sheets vs Word or Excel vs an Online Generator

Here is how the three common routes compare on the things that matter day to day. It is written as a list rather than a table so it reads the same everywhere.

Google Sheets template. Setup time: about twenty minutes to build well, or a few minutes to copy a ready template. Auto-numbering: no, you keep a log yourself. PDF output: yes, through File, Download, PDF, with some page setup. Totals and tax math: yes, through formulas you write and protect. Reusability: good, you copy the master each time. Cost: free with a Google account.

Word or Excel download. Setup time: a few minutes to download and edit. Auto-numbering: no. PDF output: yes, by saving or printing as PDF, and the layout can shift between machines and Office versions. Totals and tax math: Excel yes through formulas, Word no. Reusability: good if you save a clean master, risky if you edit last month's invoice. Cost: usually free to download, but Word and Excel themselves need a license or the free web versions.

An online invoice generator such as InvoiceQuick. Setup time: about a minute, since the layout and the math are already built. Auto-numbering: handled for you in the editor. PDF output: built in, with a clean layout. Totals and tax math: automatic. Reusability: you can start from a trade template and change the lines. Cost: the InvoiceQuick generator is free and needs no sign-up.

The honest summary is that Sheets wins on control and cost if you enjoy tinkering, and a generator wins on speed and fewer ways to make a mistake. Word wins on nothing in particular except familiarity. A fuller comparison of the file formats is in invoice template download: PDF, Word, Excel and Google Docs, and the freelancer-specific angle is in free invoice template for freelancers.

Common Mistakes With Google Sheets Invoices

Overwriting the last invoice. You open last month's invoice, change the client and the numbers, and send it. A week later you realize you need the old one and it no longer exists. Always File, Make a copy first, and keep every sent invoice as its own file or tab.

A broken SUM after inserting rows. If you add a row below the last line item, the SUM range F8:F17 does not include it, and the new line is silently left out of the total. Insert new rows in the middle of the range instead, for example by right-clicking row 12 and choosing Insert row above. That stretches the range automatically. After any structural change, add up the lines by hand once to confirm.

Typing over a formula. One stray number in F20 and the total is now wrong forever. This is why you protect the formula cells.

Forgetting the due date and payment terms. A sheet has no prompts, so it is easy to send an invoice with no due date and no instructions for how to pay. Clients pay late when they do not know when to pay or how. Put the terms in the template so they are always there, and see how to write payment terms on an invoice.

Sharing an editable link instead of a PDF. If you send a client the Google Sheets link with edit access, they can change the amounts, and even with view access they see the other tabs, including your log and other clients if you keep everything in one workbook. Send a PDF. If you must share a sheet, use view-only and share a file that contains only that one invoice.

Duplicate or skipped numbers. Without a log, two invoices end up with the same number. Keep the log and check it before you issue each one.

Different currencies and rounding. If you bill in more than one currency, label it on the invoice and format the cells for the right currency. If you charge tax, wrap the tax cell in `=ROUND(F18*$B$3,2)` so cents round the way your accountant expects.

When to Move Off a Spreadsheet

A Google Sheets invoice is a good fit when you send a handful of invoices a month, your work is simple and you are happy to be the system. It starts to cost you time when:

You send more than about five invoices a month. Copying, renaming, filling in, exporting, emailing and logging each one adds up, and every manual step is a place for a mistake.

You have recurring clients. The same client, same lines, every month is exactly what a spreadsheet does badly, because you re-enter or re-copy it each time.

You need reminders. A sheet will not tell you that an invoice is two weeks overdue or send a polite nudge. You end up checking the log by hand, and the invoices you forget are the ones that go unpaid.

You want it to look consistently professional. Page setup, fonts and logos can drift between copies.

If that sounds like you, an online generator saves the setup. The free invoice generator builds the layout, the math and the PDF for you, with no sign-up and no cost. Or browse the invoice template hub and free invoice generator page to see the trade-specific starting points. If your Google Sheets setup is working, there is no rush to change it. Keep the sheet, and use the generator when you want a quick one-off or a clean PDF without opening a file.

A Short Checklist Before You Hit Send

Before you send any invoice built in a sheet, check these things: the invoice number is new and recorded in your log, the client details are correct, every line has a clear description with a quantity and rate, the subtotal matches your own quick addition, tax is shown only if it applies, the due date and payment terms are on the page, your payment instructions are present, and you are sending a PDF rather than a link. Doing this takes under a minute and prevents almost every problem people run into with spreadsheet invoices.