Invoice Template for Google Docs and Sheets (Free)
To make an invoice in Google Docs, either start from a template (Google Sheets has an invoice template in its gallery, and you can open any Word invoice template in Docs), or build one yourself with a simple table. Fill in your details, line items, and totals, then export with File > Download > PDF Document (.pdf) and send it.
Below are the three practical routes: the built-in galleries, a Docs invoice you build yourself, and a Google Sheets invoice with formulas that do the math. There is also a shortcut using Zenvoi's free Word and Excel templates, which open in Google Docs and Sheets without any conversion fuss.
Does Google Docs Have a Built-in Invoice Template?
Google Docs has a template gallery, but invoices are hit and miss there. The selection depends on your account and changes over time. Google Sheets is the more dependable place to look: its template gallery includes an invoice.
How to open the Google Docs template gallery
- Open a document in Google Docs.
- Go to File > New > From template.
- The template gallery opens. Browse the categories for an invoice or anything close, like a proposal you can adapt.
You can also reach it from the Docs home screen at docs.google.com by clicking Template gallery above the row of new document options. If you use a Google Workspace account, your organization may have added its own templates in a separate tab.
How to open the Google Sheets invoice template
- Go to sheets.google.com.
- Click Template gallery at the top of the page, next to the blank spreadsheet options.
- Look under the Work section for Invoice and click it.
Google creates a copy in your Drive. Replace the placeholder company details, client info, and line items, and the totals update. If you are already inside a spreadsheet, File > New > From template gallery gets you there too.
The gallery templates are a fine starting point. They are also the same templates everyone else uses, so expect your invoice to look like a lot of other invoices.
How Do I Make an Invoice in Google Docs From Scratch?
Building your own takes about ten minutes and gives you a layout you control. Here is a structure that works.
Step 1: Set up the page
Start a blank document (typing docs.new in your browser's address bar is the fastest way). Go to File > Page setup and choose your paper size, Letter or A4, and margins. 2 cm or 0.75 inch margins look tidy.
Step 2: Add the header
At the top, add your logo with Insert > Image > Upload from computer. Below it, add your business name, address, email, and tax ID if you have one. On the right, or just underneath, put the word Invoice in a larger style.
A neat trick: insert a 2-column, 1-row table (Insert > Table) and put your details in the left cell and the invoice details in the right. Then hide the borders so it just looks like a two-column layout.
Step 3: Add the invoice details
You need:
- A unique invoice number, such as INV-2026-014
- The invoice date
- The due date and your payment terms
- A Bill to block with the client's name, company, and address
Step 4: Insert the line items table
Go to Insert > Table and choose 4 columns. Label the header row Description, Qty, Rate, and Amount. Add one row per line item, then three rows at the bottom for Subtotal, Tax, and Total.
To style it, right-click the table and choose Table properties. There you can change border width and color, cell padding, and column widths. Bold the header row and the Total row, and right-align the number columns so the decimals line up.
Step 5: Add payment instructions and notes
Under the table, spell out how to pay: bank transfer details, a payment link, or both. Add a short line about late fees if you charge them, and a thank-you if that is your style.
Step 6: Check the math
This is the weak spot. Google Docs tables cannot calculate, so every amount, the subtotal, the tax, and the total have to be worked out by hand. Double-check them before sending. If that sounds tedious, use Sheets instead.
How Do I Make an Invoice Template in Google Sheets With Formulas?
Sheets is the better tool if you send invoices regularly, because formulas handle the arithmetic. Here is a layout with exact formulas you can paste in.
The layout
- Rows 1 to 4: your business details and logo.
- A6: Invoice number, with the value in B6.
- A7: Invoice date, with the date in B7.
- A8: Due date, with a formula in B8.
- Rows 10 to 13: Bill to details.
- Row 15: headers. A15 Description, B15 Qty, C15 Rate, D15 Amount.
- Rows 16 to 25: line items.
- Rows 27 to 29: Subtotal, Tax, Total.
The formulas
| Cell | Purpose | Formula |
|---|---|---|
| B8 | Due date, 30 days after the invoice date | =B7+30 |
| D16 | Line amount (copy down to D25) | =IF(B16="","",B16*C16) |
| D27 | Subtotal | =SUM(D16:D25) |
| C28 | Tax rate, typed as a percentage | 8% |
| D28 | Tax amount | =ROUND(D27*C28,2) |
| D29 | Total due | =D27+D28 |
A few notes on why they are written this way:
- The IF in D16 leaves the cell blank when there is no quantity, so empty rows do not show $0.00 all the way down.
- SUM ignores those blank text results, so the subtotal still works.
- ROUND keeps the tax at two decimals, so the total matches what a client gets with a calculator.
- Change the 30 in B8 to 15 or 60 to match Net 15, Net 30, or Net 60 terms. Format B8 as a date with Format > Number > Date.
If you offer a discount, add a row above Tax with the discount as a negative amount, and change the subtotal or total formula to include it. If you do not charge tax, set C28 to 0% rather than deleting the row, so the formulas keep working.
Formatting tips
- Select C16:D29 and apply Format > Number > Currency. For other currencies, use Format > Number > Custom currency.
- Add your logo with Insert > Image > Insert image over cells, or use Insert image in cell if you want it locked to a cell.
- Hide gridlines with View > Show > Gridlines so the invoice looks like a document, not a spreadsheet.
- Protect the formula cells with Data > Protect sheets and ranges if other people will fill in the invoice.
How Do I Export a Google Docs or Sheets Invoice as a PDF?
Always send invoices as PDFs. They look the same on every device and are harder to edit by accident.
- Google Docs: File > Download > PDF Document (.pdf).
- Google Sheets: File > Download > PDF. A settings panel opens where you can choose to export the current sheet, set Fit to width, pick portrait orientation, and adjust margins. Use the preview to make sure the invoice fits on one page.
Docs also has File > Email > Email this file, which can attach the document as a PDF. It is quick, but many people prefer to download the PDF and send it from their normal email so the conversation stays in one thread.
Can I Use Zenvoi's Free Templates in Google Docs and Sheets?
Yes. Zenvoi offers a free Word invoice template and a free Excel invoice template. Both open in Google's apps:
- Download the file you want.
- Go to drive.google.com and click New > File upload, then pick the file.
- Right-click the uploaded file and choose Open with > Google Docs (for the .docx) or Open with > Google Sheets (for the .xlsx).
- Optional: use File > Save as Google Docs or File > Save as Google Sheets to create a native Google copy, which is easier to edit and share.
Converted files usually come through well, but fonts and spacing can shift slightly, so give the layout a quick look before using it. If you prefer to stay in Microsoft Office, the Word template guide and the Excel template guide cover those versions.
How Do I Keep Google Docs Invoices Organized?
Templates are easy. Keeping track of fifty invoices six months later is the hard part.
- Keep a master template. Never edit it directly. Use File > Make a copy for every new invoice.
- Name files consistently. Something like INV-2026-014 Bluebell Bakery sorts by number and is easy to search. The invoice number format guide has more options.
- Use one Drive folder per year. Save the PDF next to the editable version.
- Track status somewhere. A simple sheet with invoice number, client, amount, due date, and paid date tells you who owes what.
What Are the Limits of Google Docs Invoices?
Google Docs and Sheets work, and they are free. But they have trade-offs:
- Docs cannot calculate totals, so errors creep in.
- Invoice numbers are manual, which makes duplicates easy.
- Formatting can break when you add rows or paste text from elsewhere.
- There is no client list, so you retype addresses each time.
If you mostly want a clean PDF fast, Zenvoi's free invoice generator is quicker. It runs in your browser with no signup, calculates totals as you type, supports 150+ currencies and your logo, shows a live preview, and downloads a PDF. The free plan includes unlimited invoices with one template and a small "Created with Zenvoi" line. Pro adds all 18 templates, removes that line, and saves clients and products if you invoice often. Not sure what to put on the page? The invoice examples show complete samples for eight kinds of work.
Frequently asked questions
Does Google Docs have an invoice template?
Google Docs' built-in template gallery does not reliably include an invoice, but Google Sheets' gallery does. You can also build a simple invoice in Docs with a table, or upload a Word invoice template to Drive and open it with Google Docs.
Is Google Docs or Google Sheets better for invoices?
Sheets is better if you want totals calculated automatically, because formulas update as you type. Docs is fine for short invoices where you are happy to add up the numbers yourself.
How do I save a Google Docs invoice as a PDF?
Open the invoice and go to File > Download > PDF Document (.pdf). In Google Sheets the path is File > Download > PDF, which also lets you set scale, margins, and orientation before exporting.
Can I open a Word invoice template in Google Docs?
Yes. Upload the .docx file to Google Drive, right-click it, and choose Open with > Google Docs. Use File > Save as Google Docs if you want a fully editable Google copy, and check the layout since some formatting can shift.
How do I reuse a Google Docs invoice template?
Keep one clean master copy and use File > Make a copy for each new invoice. Name each copy with the invoice number and client so you can find it later.