Google Sheets invoice template with working formulas
Download the free .xlsx, upload it to your Google Drive and save it as a Google Sheet. Line amounts, tax, balance due, due date and the overdue log keep calculating.
Download the Google Sheets invoice template
Every format below is free and needs no account. The files are editable and start from the same lines as the online maker.
The same .xlsx file, opened in Google Sheets. The formulas, the Example sheet and the invoice log keep working after import.
General service invoice
One line per service or deliverable, plus tax, amount paid and balance due. Works for most service businesses.
Itemized invoice with category subtotals
Each line has a category (for example Labor, Materials, Expenses). The invoice shows a subtotal per category before tax.
Hourly time billing
Hours x rate per task or week, with decimal hours (for example 2.5) and approved extra hours on their own line.
How to use the Google Sheets version
- Download the .xlsx.
- In Google Drive choose New > File upload and pick the file. Open it, then choose File > Save as Google Sheets. (Or, in Sheets, use File > Import > Upload.)
- Fill in the Invoice sheet. Keep the original as a master and use File > Make a copy for each new invoice.
- Send the client a PDF (File > Download > PDF), not an edit link.
We do not offer a "make a copy" link to a Sheet in our Drive. You import the file into your own Drive, so it stays private to you.
INVOICE
Hypothetical amounts, not market rates
| Description | Qty | Amount |
|---|---|---|
| Strategy workshop (half day) | 1 | $1,200.00 |
| Design work: landing page | 12 | $1,140.00 |
| Stock photo licences, at cost | 3 | $45.00 |
Fill in your Google Sheets invoice
Edit any line, set your tax rate (0% is fine) and download a PDF. Line amounts, tax and the balance due calculate as you type. Version: General service invoice.
Tax starts at 0%. Enter the rate that applies to you, or leave it at 0 if you do not charge sales tax or VAT.
For example a deposit. The PDF then shows the balance due.
- Nothing is saved on our side. Download the PDF before you leave the page.
- Amounts print with a $ sign. If you bill in another currency, say so in the notes.
- Prefer to edit offline? Download this starting point as Excel (.xlsx) or Word (.docx).
A Google Sheets invoice gives you formulas and cloud access without Excel. Keep one master Sheet, make a copy for each invoice, protect the formula cells, and send the client a PDF rather than a link. The sections below cover the layout, formulas and a simple paid/unpaid log.
What the Google Sheets invoice covers
What you can do with this template, and what it does not do.
Formulas that survive import
Line amounts, subtotal, tax from one rate cell, total, amount paid, balance due and the due date all calculate in Google Sheets after upload.
Invoice log with overdue flag
A log tab with one row per invoice, a Paid Yes/No dropdown, an OVERDUE status and red highlighting once the due date passes.
Example tab
The same invoice filled in with hypothetical amounts, so you can see how each formula behaves.
Your own private copy
Upload the .xlsx to your Drive and use File > Save as Google Sheets. We do not share a Sheet from our account.
Make-a-copy workflow
Keep the imported Sheet as a master and use File > Make a copy for each invoice, so old invoices are never overwritten.
Send a PDF, not a link
Download the invoice with File > Download > PDF and send the PDF. A shared Sheet can be edited and shows your other tabs.
How to fill in your Google Sheets invoice
- Header Section: Business name, logo (as image), address, phone, email, and website.
- Invoice details: Invoice number, date, and due date in clearly labeled cells.
- Client information: Client name, company, address, and contact details.
- Line Items Table: Columns for description, quantity, rate, and amount.
- Formulas: Automatic calculations for line totals, subtotals, tax, and grand total.
- Payment terms: Due date, accepted methods, and payment instructions.
- Notes Section: Thank you message, terms, or additional information.
- Conditional Formatting: Visual cues for totals, due dates, or important fields.
- Use Formulas: Use built-in formulas (=A*B, =SUM, etc.) for automatic calculations.
- Protect Cells: Lock formula cells to prevent accidental edits. Protect > Protect sheets and ranges.
- Create a Template: Make a master template and copy it for each new invoice.
- Use Named Ranges: Name key cells (SubTotal, TaxRate) for clearer formulas.
- Share Carefully: Share as "View only" or download as PDF for clients.
- Version History: Use File > Version history to track changes.
- Download as PDF: Export to PDF before sending for a professional, uneditable format.
- Link Payment Options: Add clickable payment links in cells.
- Backup Regularly: While Google auto-saves, maintain organized folder structure.
- Use Data Validation: Dropdown lists for payment terms, tax rates, or service types.
Master these formulas for professional invoices:
Essential Formulas:
- Line Total: =C3*D3 (Quantity × Rate)
- Subtotal: =SUM(E3:E10)
- Tax: =Subtotal*TaxRate
- Total: =Subtotal+Tax
- Amount Due: =Total-Payments
Useful Functions:
- =TODAY(): Auto-insert today's date
- =DATE(...): Calculate due dates
- =TEXT(A1,"$#,##0.00"): Currency formatting
- =IF(Due<TODAY(),"OVERDUE",""): Status flags
Cell Formatting:
- Format > Number > Currency
- Conditional formatting for totals
- Bold headers and totals
- Borders for tables
Tips:
- Use absolute references ($A$1) for tax rates
- Named ranges make formulas readable
- Protect cells with formulas
Include clear payment details:
Payment Cells to Include:
- Due date (formula from invoice date)
- Accepted payment methods
- Bank account details
- Payment link (clickable)
Setting Up Payment Links:
- Insert > Link
- Add PayPal, Stripe, or payment URL
- Format cell as clickable button
Tracking Payments:
- Create a "Paid" column
- Use checkboxes (Insert > Checkbox)
- Conditional formatting for paid invoices
- Link to payment tracking sheet
Due Date Automation:
- =InvoiceDate+30 for Net 30
- Conditional format if overdue
- =IF(TODAY()>DueDate,"PAST DUE","")
Before Sharing:
- Check all formulas work
- Remove edit access for clients
- Consider PDF export
- Broken Formulas: Test all formulas before sending. Broken calculations look unprofessional.
- Sharing Edit Access: Share as "View only" or download as PDF. Don't let clients edit your invoice.
- Unprotected Cells: Protect formula cells from accidental edits.
- No Template System: Don't start from scratch each time. Create a master template.
- Missing Invoice Numbers: Always include unique, sequential invoice numbers.
- Complex Formulas: Keep formulas simple and documented. Future you will thank you.
- No PDF Backup: Export to PDF before sending. Sheets can change; PDFs don't.
- Inconsistent Formatting: Use consistent fonts, colors, and number formats throughout.
- Missing Contact Info: Include your contact information so clients can reach you.
- No Due Date Formula: Automate due date calculation from invoice date.
Google Sheets invoice: frequently asked questions
Related resources
Guides and articles
Related invoice templates
Explore more professional invoice templates for different industries
Excel invoice template
Free Excel invoice template (.xlsx) with working formulas for line amounts, subtotal, tax, amount paid, balance due and due date, plus a filled-in example sheet and an invoice log.
Google Docs invoice template
Google Docs invoice template: download the free .docx, upload it to your own Google Drive and save it as a Google Doc. Includes setup steps and what Docs cannot calculate.
PDF invoice template
Free PDF invoice template: fill in the invoice online and download a PDF on US Letter or A4, or print a blank invoice with a remittance slip. Itemized, Net 30 and blank versions.
Hourly invoice template
Hourly invoice template for time-based billing: one line per task or time block, hours as the quantity, your hourly rate, and the billing period in the notes.
Replace the invoice log spreadsheet
AgencyPro tracks each invoice from Draft to Paid, sends it with a Stripe or PayPal payment link and sends reminders when it is overdue. Invoicing is included on every plan, starting with Basic at $39/mo.