Google Sheets Invoice Template
Google Sheets is where a lot of small businesses actually run their invoicing: free, shared with the bookkeeper, and available from any phone. This template copies straight into your Drive with the formulas in place — line totals, subtotal, tax and grand total all calculate as you type, and one tab per invoice keeps the year in a single file.
The sharing is the point. A sheet your accountant can open beats a folder of attachments at tax time, and duplicating last month's invoice tab is faster than starting over. The caution is the same as any spreadsheet: export to PDF (File → Download → PDF) before a client sees it, because an editable link is not an invoice, it's a draft.
And if you only need one invoice right now, the generator below skips the spreadsheet entirely — type, download the PDF, send.
Opens a 'Make a copy' prompt — the template lands in your own Drive.
Common questions
How do I use the Google Sheets invoice template?
Open the link and choose 'Make a copy' — the template is added to your own Google Drive, where you can edit it freely. Fill in your details once, then duplicate the tab for each new invoice so your records stay in one spreadsheet.
Do the totals calculate automatically?
Yes. Quantity times rate per line, plus subtotal, tax and grand total, are all formulas in the template. You enter descriptions, quantities, rates and a tax rate; everything else recalculates.
Can I send clients a link to the sheet?
Don't. A shared sheet is editable and shows your working. Export the invoice as a PDF (File → Download → PDF) and send that — or use the generator on this page, which produces a clean PDF in one step.
Google Sheets or the online generator — which is better?
Sheets if you want a running ledger of every invoice in one place, shared with your accountant. The generator if you just want a polished PDF fast, with no spreadsheet to maintain. Many businesses use the generator for clients and keep their own records wherever they like.