Skip to the content.

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

  1. Put your services and rates on Price List.
  2. Add the invoice on Invoices with customer, terms and any discount.
  3. Add lines on Line Items, then pick the number on the Invoice tab to print or save as PDF.
  4. 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.

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.

All free templates