Free Google Sheets Invoice Template

Step by step

How to make an invoice in Google Sheets

1. 1

   Download the template above, then in Google Drive click New → File upload (or in Sheets choose File → Import → Upload).

2. 2

   Open the uploaded file with Google Sheets - the .xlsx converts into an editable Sheet with its formulas intact.

3. 3

   Fill in the bracketed placeholders with your business details, your client’s details, an invoice number, and the dates.

4. 4

   Add each line item with its quantity and rate; the Amount, Subtotal, and Total cells recalculate automatically.

5. 5

   When you’re done, use File → Download → PDF to send a clean copy, or share a view-only link with your client.

What to include

What goes on a Google Sheets invoice?

Pro tips

Google Sheets invoicing tips that get you paid faster

• Use File → Make a copy for each new invoice so your master template stays clean.

• Edit only the quantity and rate cells and let the Amount and Total formulas recalculate.

• Download as PDF before sending so the client gets a fixed, professional-looking copy they can’t edit.

• Name each file clearly (Client - Invoice 0001) so your Drive stays organized.

• If you’re sending invoices regularly, a dedicated tool tracks who has paid and sends reminders - something a Sheet won’t do on its own.

FAQs

Common questions about google sheets invoices