Free Invoice Template for Freelancers (Excel and Google Sheets)
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)
Shaded cells are for you to fill in; the totals work themselves out.
| Your business name | INVOICE | ||
| Street, city, state, ZIP | Invoice number | INV-0001 | |
| you@example.com · phone | Invoice date | ||
| Payment terms (days) | 30 | ||
| Due date | auto | ||
| Bill to | |||
| Client name | |||
| Client address and email | |||
| Description | Qty or hours | Rate | Amount |
| Example: logo design, 3 concepts | 1 | $500.00 | auto |
| auto | |||
| auto | |||
| auto | |||
| auto |
How to use the invoice template
- Download and open it. In Google Sheets, upload the file to Google Drive and open it with Sheets.
- 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.
- Add your client under "Bill to".
- List the work: a clear description, the quantity or hours, and your rate. Delete the example line.
- Add any discount, sales tax rate or deposit already paid. The total and the balance due update as you type.
- 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
- Free quote and estimate template: agree the price before you start.
- Free income and expense spreadsheet: record each payment when it arrives.
- 1099 Tax Calculator: how much tax to set aside from what you invoice.