Free Google Sheets Invoice Template
For a small service business that wants clean numbered invoices with discounts, tax, amount paid and balance due, without paying for invoicing software yet.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Invoices, Line Items and Price List, no typing needed. |
| Invoice | Totals and views built from Invoices, Line Items and Price List, no typing needed. |
| Invoices | Columns Invoice number, Issue date, Customer, Phone, Email, Billing address, Job or description, Terms, Due date override (optional) and 9 more. |
| Line Items | Columns Line ID, Invoice number, Service, Quantity, Description override (optional), Unit override (optional), Rate override (optional), Taxable override (optional) and Notes. |
| Price List | Columns Service, Description, Unit, Rate and Taxable. |
| Settings | Your own dropdown lists (payment terms, days and discount type), so the choices match how you work. |
How to fill it in
- Put your services and rates on Price List.
- Add the invoice on Invoices with customer, terms and any discount.
- Add lines on Line Items, then pick the number on the Invoice tab to print or save as PDF.
- Update Amount paid when the customer pays.
A tip from the field
Leave the override columns blank unless one invoice needs its own due date, tax rate or thank-you note.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Invoices (2 sample rows)
- Line Items (3 sample rows)
- Price List (4 sample rows)
Related templates
- Free Google Docs Invoice Template
- Free Google Sheets Invoice Tracker
- Free Google Sheets Payment Tracker
When you outgrow it
Smarfle invoices carry a pay link for card or bank payment and mark themselves paid. See how it works on smarfle.com.