Freelance Invoice Template Guide: Set It Up Once, Get Paid

By Cedar & Ledger · Updated October 31, 2026

Most freelancers don't lose money because their invoice looks plain. They lose it because the invoice went out late, left out something the client's accounts team needed, or nobody tracked whether it was paid. A good invoice template fixes all three: you set it up once, fill in a few fields per job, and keep a simple log of what's still owed.

This guide walks through building that system in Google Sheets or Excel, from the blank layout to sending and tracking. It covers the template itself, numbering, payment terms, PDF export and a log that flags overdue invoices. Plan on about an hour for the first setup.

Step 1: Decide what every invoice must show

Before you lay anything out, list the fields. A freelance invoice usually includes:

• The word "Invoice" and a unique invoice number
• Your details: business name (or your name if you trade under it), email, and an address if your clients or local rules require one
• The client's details: company name, contact person, billing email and address
• Issue date and due date
• Line items: description, quantity or hours, rate, line total
• Subtotal, tax (if you charge it), and total due
• How to pay: the methods you accept and the details the client needs
• Payment terms and any late-fee policy you agreed on in your contract
• A PO number or project reference if the client gave you one

Requirements differ by country and by client. If you're registered for VAT or sales tax, or work with large companies, check what your invoices must legally show. What to put on a freelance invoice goes through each field in more detail.

Step 2: Lay out the template

Open a new spreadsheet and name the tab Invoice. A layout that prints well on one page:

1. Rows 1 to 6: your business name in large text on the left; "INVOICE", the invoice number, issue date and due date on the right.
2. Rows 8 to 12: "Bill to" with the client's details.
3. Row 14: line-item headers: Description (merge a few columns so it's wide), Qty/Hours, Rate, Amount.
4. Rows 15 to 29: 15 blank line-item rows.
5. Rows 31 to 34: Subtotal, Tax, Total due, right-aligned.
6. Rows 36 onward: payment methods, terms and a short thank-you or note.

Keep it simple: one font, one accent color, light borders. Clients care that it's clear, not decorative.

Step 3: Add the formulas

Assuming quantity is in column E, rate in F and amount in G:

Line amount (G15):  =IF(OR(E15="", F15=""), "", E15 * F15)
Subtotal (G31):     =SUM(G15:G29)
Tax (G32):          =ROUND(G31 * tax_rate, 2)
Total due (G33):    =G31 + G32
Due date:           =issue_date + 30

The IF in the line amount keeps empty rows blank instead of showing $0.00. Put your tax rate in its own cell (for example on a Settings tab) and refer to it, so you only ever change it in one place. If you don't charge tax, set the rate to 0 or delete the row.

For the due date, replace 30 with your terms: 14 for Net 14, 0 for due on receipt. To check a date quickly, or to count only business days, use the free invoice due date calculator.

Step 4: Pick a numbering system and stick to it

Every invoice needs a unique number, and the numbers should run in order. Two easy patterns:

• Year plus sequence: 2026-001, 2026-002, 2026-003. Easy to read and resets each year.
• Client code plus sequence: ACME-001, ACME-002. Useful when you have a few long-term clients.

Never reuse a number, even if you cancel an invoice. Mark the cancelled one "void" in your log instead. How to number your invoices has more examples.

Step 5: Set payment terms that match how you work

The terms tell the client when to pay. Common choices are due on receipt, Net 7, Net 14 and Net 30. Shorter terms usually mean faster payment, but large companies often have fixed payment cycles you can't change, so ask during onboarding. Invoice payment terms explained compares the options.

Whatever you choose, put the same terms in your contract or proposal and on the invoice. If your contract includes a late fee, state it on the invoice in plain words, for example "A late fee of 1.5% per month applies to balances unpaid after the due date", and only if that's what you agreed. The late fee calculator shows what a given rate works out to. Check local rules, since some places limit late fees.

For bigger projects, ask for a deposit up front. How to ask for a client deposit covers how much and how to invoice it.

Step 6: Make a fresh invoice each time

There are two simple ways to reuse the template:

• One file per invoice: keep a master template file, and for each new job choose File > Make a copy, named with the invoice number and client ("2026-014 Acme"). Clean and easy to find.
• One tab per invoice: right-click the Invoice tab, choose Duplicate, and rename the copy with the invoice number. Fine for a small number of clients; it gets crowded after a year.

Either way, never edit an invoice after you've sent it. If something was wrong, send a corrected invoice with a new number, or a credit note, and log both.

Step 7: Export to PDF and send

Always send a PDF rather than a link to your spreadsheet. In Google Sheets, choose File > Download > PDF, set the scale to "Fit to width", turn off gridlines, and set the print area to the current sheet. In Excel, use File > Save As (or Export) > PDF after setting the print area. Check the preview: everything should fit on one page with no cut-off columns.

In the email, keep it short: what the invoice is for, the total, the due date and how to pay. Name the file clearly, for example "Invoice 2026-014 - Your Business - Acme.pdf", so it's easy for the client's accounts team to find.

Step 8: Keep an invoice log

This is the step most people skip, and it's the one that gets you paid. Add a tab called Log with these headers: Invoice #, Client, Issue date, Due date, Amount, Amount paid, Date paid, Balance, Status, Days overdue.

Balance (H2):       =E2 - F2
Status (I2):        =IF(E2="", "", IF(H2 <= 0, "Paid",
                      IF(TODAY() > D2, "Overdue",
                      IF(F2 > 0, "Partial", "Open"))))
Days overdue (J2):  =IF(I2 = "Overdue", TODAY() - D2, "")

Add conditional formatting so "Overdue" turns red. Once a week, sort or filter by Status and follow up on anything overdue. How to follow up on a late invoice has wording for a friendly first reminder and firmer later ones.

At the end of the month, a quick SUMIFS gives you what you invoiced and what you were actually paid, which feeds straight into your bookkeeping. If you also track hours, how to track billable hours shows how to turn a time log into line items.

A quick checklist before you hit send

• New, unique invoice number, entered in the log
• Client name, contact and billing email correct; PO number included if they gave one
• Line items match the quote or contract
• Totals and tax checked
• Due date and payment methods shown
• PDF fits on one page and opens cleanly

Prefer a ready-made template?

If you'd rather not build the layout and log yourself, the Freelancer Invoice + Client Tracker ($9, Excel and Google Sheets) has a printable invoice where client details fill in from a dropdown, an invoice log with one row per invoice, and a Clients tab with billed, paid and outstanding totals for each client. It's optional; the steps above are enough to run your invoicing.

This is general information, not tax, legal or accounting advice.

Try the free invoice due date calculator →

Related template: read about the Freelancer Invoice + Client Tracker

See all Cedar & Ledger templates