Skip to content
QuoteToPaid
Save & syncProCreate an invoice
Menu
TemplatesBy industryHow it worksFAQSave & syncProCreate an invoice

Free Invoice Template for Google Sheets

Copy this spreadsheet invoice into your Google Drive in one click. Type quantities and rates and the line amounts, subtotal, tax and total calculate themselves. Download it as a PDF when you're done.

Make a copy in Google SheetsFill it in online first

No Google account? instead.

Free. No sign-up, no email, no watermark.

Choose a design

The one-click Google Sheets copy uses the Classic Blue design. Other designs download as .xlsx files.

Northline Studio
214 Market St, Austin, TX 78701
(512) 555-0142 · hello@northline.co
INVOICE
No. INV-001
ISSUE DATEOct 5, 2026
DUE DATEOct 19, 2026
TERMSNet 14
AMOUNT DUE$1,353.13
BILLED TODana WhitfieldWhitfield Coffee Co.88 Lamar Blvd, Austin, TX 78704dana@whitfieldcoffee.com
PROJECTSpring menu launchCopywriting and social posts for the new seasonal menu.
DESCRIPTIONQTYRATEAMOUNT
Menu copywriting12 drinks, 6 pastries
1650.00650.00
Social media posts8 posts with captions
845.00360.00
Product photo editingColor and crop, 20 images
2012.00240.00
PAYMENT DETAILSBank: First Texas BankAccount name: Northline Studio LLCAccount: 004812337Reference: INV-001
Subtotal$1,250.00
Tax (8.25%)$103.13
Total due$1,353.13
TERMSPayment is due by the due date shown. Thank you for your business.
Thank you for your business.Payment is due within 14 days. A 1.5% monthly fee applies to late payments.

Preview with example details. The download is blank, ready for yours.

What's in the Google Sheets file

  • Line amounts are formulas: quantity × rate, rounded to the cent.
  • Subtotal, tax and total are formulas too. Change the tax rate cell and the tax updates.
  • Invoice number, invoice date and due date at the top.
  • Your business and customer details, payment instructions and terms.
  • Your copy lives in your own Google Drive. We can't see or change it.

How to use it in Google Sheets

  1. 1

    Make your copy

    Click Make a copy. Google asks you to confirm, then opens your own copy in Google Sheets.

  2. 2

    Fill in the details

    Add your business details, your customer's details, an invoice number and the dates.

  3. 3

    Add your line items

    Type a description, quantity and rate on each line. Amounts and the total fill in by themselves.

  4. 4

    Set the tax rate

    Type your sales tax rate in the tax rate cell, or leave it at 0%.

  5. 5

    Download as PDF and send

    Choose File > Download > PDF, pick Fit to width, and email the PDF.

Last updated · By Yasir Arfat

Google Sheets template or the online builder?

The Google Sheets template

  • Works offline in Google Sheets
  • Totals calculate with formulas
  • You number each invoice and save the PDF yourself

The free online builder

  • Totals, tax and numbering done for you
  • Remembers your business details and logo
  • Download as PDF, Word and Excel in one click
Fill it in online free

Questions about the Google Sheets invoice template

Is it really free?

Yes. The download is free, with no sign-up, no email and no watermark. The online builder is free too.

Do I need a Google account?

Yes, to copy it into Google Sheets. Without one, download the Excel version, which works the same way.

Will the formulas keep working?

Yes. The sheet only uses simple formulas like SUM and ROUND, which Google Sheets supports fully.

How do I add more lines?

Right-click a row inside the item table, choose Insert 1 row above, and copy the amount formula from the row above.

Can I track which invoices are paid?

Keep each invoice as its own copy and add the status to the file name, for example INV-004 PAID. A simple list of numbers, amounts and dates paid in another sheet works well.

Invoice templates by trade

Other formats