Free Freelance Invoice Template for Google Sheets

The freelance invoice template is a free Google Sheet you copy once and duplicate for every client bill. Enter your business details, the client, the line items, and a due date. Formulas fill subtotal, discount, tax, and balance due. Paid work then belongs in the same books as your expenses — keep using the sheet for free, and create or send the invoice in Avery when email-and-PDF is the part you want to drop.

Who it's for

• Freelancers and independent contractors who invoice clients and want a Google Sheets layout, without a heavy billing subscription.
• Designers, writers, developers, and other 1099s who need a PDF or a shareable sheet their client can actually read.
• Anyone whose payments sit in an inbox while expenses sit in a different file.

Consultants who bill retainers, day rates, or milestone engagements should use the consulting invoice template. Same kind of sheet, different examples.

What's inside

• Header — your details, the client, invoice number, invoice date, and due date.
• Line items — description, quantity, rate, and amount. Hourly, daily, and flat project fees all fit on a line.
• Totals — subtotal, discount, tax, and balance due, calculated from the lines.
• Payment instructions — where the client sends USD, written in plain language.
• Late-fee note — optional, and only when your agreement already allows it.
• One invoice per copy — duplicate the tab or the whole file so a sent invoice stays frozen.

Rates, tax lines, and late fees

Write the rate on the line and name the unit: an hour, a day, or a project fee. State USD, and say whether the figure already includes tax.

Sales tax or VAT, when the job requires it, is its own line. The client sees the add-on, and you can match what you collected. A late fee is the same kind of explicit line: the policy sits in the payment block, and you apply it after the due date if the contract allows it.

This sheet stores those amounts. It does not decide your tax rate, whether the work is taxable, or whether a late fee is enforceable. This is general information, not tax or legal advice — confirm rates, exemptions, and contract terms with a qualified tax professional or attorney.

From the invoice into your books

A collected invoice is income. Put it on a profit and loss statement so the month shows what you earned, not only what you spent. Use the profit and loss statement template or the self-employed profit and loss template. Client-billable costs can be their own invoice lines. Costs you do not bill through belong on an expense log: the freelancer expense tracker, the self-employed expense tracker, or the Schedule C expenses template.

A simple combined log also works while the year is still small: the income and expense tracker.

When to add Avery

A spreadsheet invoice only works if you fill it in and send it. Copy this template and use it by hand for free — that path stays open, with no Avery account required.

Avery Pro brings accounts, expenses, invoices and reports together in the mobile and web apps. Business adds recurring invoices, payment reminders and advanced bookkeeping tools. If you prefer a spreadsheet workflow, Avery for Google Sheets imports transactions from supported accounts, with categories and rules for you to review. Compare the plans. The free template also works with manual entry.

Keep going

Rates, late fees, tax lines, and how an invoice meets your books are answered on the freelance invoice questions page.

Pair the invoice with the rest of the freelancer stack:

• Consulting invoice template — retainers, milestones, day rates, and pass-through expenses.
• Profit and loss statement template and self-employed profit and loss, plus the Schedule C profit and loss guide.
• Freelancer expense tracker and Schedule C expenses.
• 1099 write-offs and deductions.
• Cash to hold back after you get paid: how much to set aside for 1099 taxes, quarterly taxes for the self-employed, and the sinking funds tracker.
• Client travel that belongs with the job: mileage log for taxes.

Build a regular review around your invoices with our freelance bookkeeping guide.