Free Google Sheets invoice template

What’s on the google sheets invoice template

Extra fields on this template: PO number.

Example prices in US dollars. Replace them with your own; in the generator, any currency works.

How to open it in Google Sheets

1. Download the spreadsheet (.xlsx) above.
2. In Google Sheets, choose File → Import → Upload and pick the file, then “Replace spreadsheet” or “Insert new sheet”. Or upload it to Drive and open it with Google Sheets.
3. Save it as a Google Sheet (File → Save as Google Sheets) if Drive shows an .XLSX label.
4. Keep this copy as your master and use File → Make a copy for each invoice.

What calculates automatically

• Each line amount = quantity × rate.
• Subtotal = the sum of the line amounts.
• Tax = subtotal × the tax rate you type in the tax-rate cell (leave it at 0% if you don’t charge tax).
• Total = subtotal + tax.

To add a line, insert a row inside the line-item block (right-click a row number → Insert 1 row above), so the subtotal formula includes it. Copy the amount formula down into the new row.

Sending the invoice

Choose File → Download → PDF, set it to fit the width of the page, and attach the PDF to an email. Don’t send the sheet itself: the client could change it, and a shared Sheet exposes any other tabs you keep in it. If you don’t want to fiddle with print settings, fill the invoice in online and download a ready-made PDF.