Free Invoice Template for Freelancers (Excel and Google Sheets)

By the JAJPO team · How we build our tools

A free invoice template you can fill in on your computer: your details, your client, the work and your rate. Line totals, sales tax and the balance due work themselves out. It's a standard Excel file, so it also opens in Google Sheets, Numbers and LibreOffice.

Free template

Free Invoice Template (Excel)

Excel file (.xlsx) · opens in Excel, Google Sheets, Apple Numbers and LibreOffice · 2 sheets · formulas included

Or use the online Invoice Generator

Shaded cells are for you to fill in; the totals work themselves out.

Preview: the Invoice sheet
Preview of the Invoice sheet
Your business nameINVOICE
Street, city, state, ZIPInvoice numberINV-0001
you@example.com · phoneInvoice date
Payment terms (days)30
Due dateauto
Bill to
Client name
Client address and email
DescriptionQty or hoursRateAmount
Example: logo design, 3 concepts1$500.00auto
auto
auto
auto
auto

How to use the invoice template

  1. Download and open it. In Google Sheets, upload the file to Google Drive and open it with Sheets.
  2. Fill in the shaded cells at the top: your business name, address and contact details, the invoice number and date. The due date works itself out from the payment terms.
  3. Add your client under "Bill to".
  4. List the work: a clear description, the quantity or hours, and your rate. Delete the example line.
  5. Add any discount, sales tax rate or deposit already paid. The total and the balance due update as you type.
  6. Save it as a PDF and send it. Keep the spreadsheet as your copy, and save a new one for each invoice.

What's in the template

  • An invoice sheet with 15 item lines, automatic amounts, subtotal, discount, sales tax, total, amount paid and balance due.
  • Invoice number, date, payment terms and an automatic due date.
  • A notes box for how to pay you.
  • A "How to use" sheet with these steps.

Template or online invoice generator?

The template suits you if you like keeping invoices in a spreadsheet. If you'd rather not touch formulas, the free Invoice Generator makes a PDF invoice with your logo in a couple of minutes, remembers your details on your device, and numbers your invoices for you. You can also start from a quote and turn it into an invoice in one click.

Frequently asked questions

Do I need to charge sales tax on my invoice?

It depends on your state and what you sell. Many services aren't taxed, but some states tax certain services, and most tax physical goods. The template leaves the rate at 0% until you change it; check with your state's tax agency.

What should a freelance invoice include?

The word "Invoice", a unique number, the date and due date, your details and your client's, each item with its quantity, rate and amount, the total due, and how to pay. The template has a place for each.

Is the template really free?

Yes. It's free to download and use for as many invoices as you like. We ask for your email so we can send you tax-deadline reminders and new templates; you can unsubscribe at any time.

Related