Compact Gray
For consultants and professional services
Free Google Sheets invoice templates
Free Google Sheets invoice templates with built-in formulas. Open a template above, click Make a copy, and fill in the line items. The subtotal, tax, and total update as you type. For more control over fonts and layout, use the Google Docs version of the same design.
- Compact Gray invoice template for Google Sheets
Modern Black invoice template for Google SheetsModern Black
For freelancers and online services
Professional Navy invoice template for Google SheetsProfessional Navy
For lawyers and advisors
Vibrant Base invoice template for Google SheetsVibrant Base
For marketing and event management
Bauhaus Special invoice template for Google SheetsBauhaus Special
For designers and art directors
Minimal White invoice template for Google SheetsMinimal White
For digital products and creative work
Mono Style invoice template for Google SheetsMono Style
For coaches and educators
Classic Blue invoice template for Google SheetsClassic Blue
For trades and service jobs
Bold Green invoice template for Google SheetsBold Green
For shops and landscaping
Two Tables invoice template for Google SheetsTwo Tables
For mechanics and plumbers
Signature Studio invoice template for Google SheetsSignature Studio
For photographers and web designers
Modern Boutique invoice template for Google SheetsModern Boutique
For writers and creators
Browse by format
Same designs, different format. Pick whichever fits your workflow.
- Google DocsOpen and customize in Google Docs
- Google SheetsAuto-calculating invoices in Google SheetsYou are here
- Microsoft WordDownload .docx and edit in Word
- Microsoft ExcelDownload .xlsx with built-in formulas
Why use a Google Sheets invoice template?
Google Sheets is the right choice when you want the totals calculated for you without installing Excel. Every template above has formulas for the line totals, subtotal, tax, and total. You get less control over the typography than in Google Docs, but no arithmetic to check.
- Built-in formulas
Subtotal, discount, tax, and total update as you fill in the line items.
- Reads like an invoice
Gridlines are hidden and borders sit only where an invoice needs them.
- Open in any browser
Works on any device, without an Excel license. Share the sheet if someone needs to review it first.
- Duplicate per client
Make a copy of the file in Drive, or duplicate the tab to keep all invoices in one file.
- Clean PDF export
File > Download > PDF with Fit to width selected gives you a one-page invoice.
What's inside each template
Your details and your client's
Business name, address, and contact details for both parties.
Invoice number, issue date, due date
A sequential number, the issue date, and a due date, for example 14 or 30 days later.
Line items
Description, quantity, unit price, and amount per item.
Subtotal, discounts, tax, and grand total
Calculated automatically in the Excel and Google Sheets versions, by hand in Word and Google Docs.
Payment details and terms
Bank details such as IBAN and BIC, accepted payment methods, and payment terms.
Notes and optional fields
PO number, project name, and any custom terms or thank-you note.
How to use the invoice template in Google Sheets
Open the template in Google Sheets
Click Open in Google Sheets on any template card above. Google asks you to make a copy in your own Drive. Confirm, and you edit your own copy, not the original.
Add your business details
Replace the sample business name, address, and contact details at the top. Use Insert > Image > Insert image over cells to replace the sample logo.
Fill in the line items
Enter a description, quantity, and unit price for each line. The amount column multiplies them. To add a line, insert a row between two item rows and copy the amount formula from the row above. The subtotal includes the new row automatically.
Set the tax rate
The rate sits in the label of the tax line, for example VAT (20%). Change the number in the brackets and the tax and total recalculate. Some designs have a tax column instead, where you enter the rate per line.
Export as PDF and send
Go to File > Download > PDF. Choose Fit to width and Portrait, then export. Email the PDF to your client.
Let Claude or ChatGPT fill in a template
The free invoice skill fills any of these 12 designs from a short description. It asks for the details an EU invoice needs, such as the service date and VAT IDs, and can turn the PDF into a ZUGFeRD e-invoice.
Google Sheets vs Excel for invoicing
Google Sheets and Excel both calculate invoice totals for you. The difference is where the file lives and how you work on it with others.
| Feature | Sheets | Excel |
|---|---|---|
| Where it lives | In your Google Drive | An .xlsx file on your device |
| Works offline | With Drive offline mode | Yes |
| Real-time collaboration | Built in, free | Limited (needs OneDrive) |
| Cost | Free with a Google account | Needs Microsoft Office |
| Formula library | Most Excel functions plus Apps Script | All Excel functions plus macros |
| Best for | Teams that work in the browser | Existing Excel workflows |
Frequently asked questions
Does Google Sheets have a free invoice template?
Google's template gallery has a basic invoice. The free templates above come in 12 designs with all the standard fields and formulas for the subtotal, tax, and total. Click Open in Google Sheets to copy a design to your Drive.
How do I add VAT or sales tax to a Google Sheets invoice?
Most designs read the rate from the label of the tax line, for example VAT (20%) or Tax (10%). Change the number and the tax amount and total update. Designs with a tax column take the rate per line.
How do I add my logo to a Google Sheets invoice?
Click the sample logo and delete it. Then go to Insert > Image > Insert image over cells, upload your file, and drag the corners to size it.
How do I send a Google Sheets invoice to my client?
Go to File > Download > PDF, select Fit to width, and attach the PDF to your email. You can also share the sheet with view-only access, but a PDF is the safer choice. Your client gets a clean invoice without the formulas.
Are these templates also available for Excel?
Yes. Every design also comes as an Excel file (.xlsx) with the same layout and formulas for the same totals.
How do I duplicate a Google Sheets invoice for each client?
There are two ways. In Drive, right-click the file, choose Make a copy, and rename it with the client and invoice number. Or right-click the tab at the bottom and choose Duplicate. The first gives you one file per invoice, the second keeps all invoices in one file, one tab each.
What's the difference between Google Sheets and Google Docs invoice templates?
Google Sheets calculates the totals for you, Google Docs doesn't. Use Sheets when you want the arithmetic done, and Docs when you want a document-style invoice with more control over fonts and layout.
What if I send dozens of invoices a month?
Sheets handles the arithmetic at any volume. For the invoices and receipts you receive, there's Billpal. It imports them from your email, takes photos of paper receipts via WhatsApp, and exports everything for your accounting software.
Collect invoices for your books.
Billpal collects invoices and receipts from where they already arrive and turns them into structured, categorized data for your accountant.
- 7-day free trial, 50 documents
- No credit card required
- Cancel anytime