Free Excel Invoice Template for Freelancers (and the All-in-One Upgrade)

If you freelance, you need to send professional invoices without paying for bloated software. The good news: Excel already has everything required to build a clean, reusable invoice that calculates totals and tax for you. Below is a free DIY approach you can set up today, plus an honest look at when it makes sense to upgrade to an all-in-one system.

If you’d rather skip the building and start invoicing in the next five minutes, the Freelancer Invoice & Expense Tracker template is a ready-to-use workbook for $19. Otherwise, keep reading and build your own.

What a freelance invoice actually needs

A valid, professional invoice isn’t complicated. At minimum it should include:

• Your name or business name, address, and contact details
• The client’s name and billing address
• A unique invoice number and the invoice date plus a due date
• A line-item table: description, quantity, rate, and line total
• A subtotal, tax, and grand total
• Payment terms and how you want to be paid

That’s it. Everything else is polish. The two parts people get wrong are the math (totals that don’t update) and the formatting (an invoice that looks like a homework assignment). Excel handles both easily.

Build a free invoice template in Excel

1. Lay out the header

Put your business name in a large, bold cell at the top, then your contact details below it. Leave a block on the right for the invoice number, invoice date, and due date. To make dates appear cleanly, select those cells and use a short date format — here’s how to apply a short date format in Excel so “6/14/2026” displays consistently.

2. Build the line-item table

Create columns for Description, Quantity, Rate, and Amount. In the Amount column, multiply quantity by rate. If your first item row is row 12, the formula in the Amount cell is:

=B12*C12

Copy that down for as many rows as you need. Format the Rate and Amount columns as currency so values show with a dollar sign and two decimals.

3. Add the subtotal, tax, and total

Below the table, sum the Amount column. The cleanest tool here is SUM — see how to add a sum of a column in Excel if you want the exact steps. Your subtotal formula looks like:

=SUM(D12:D30)

For tax, multiply the subtotal by your rate (for example 8.5%):

=D31*0.085

Then add the subtotal and tax for the grand total. If you bill some clients with tax and others without, a small IF test keeps one template flexible. And because money math is unforgiving, round your tax line so you never email a client a total that’s a penny off — the ROUND function in Excel wrapped around your tax formula prevents those embarrassing rounding errors.

4. Use a drop-down for repeat clients

If you bill the same handful of clients, a drop-down list saves typing and prevents typos in names that later break your records. Set one up with our guide to adding a drop-down list in Excel, and when your roster changes you can edit the drop-down list without rebuilding anything.

5. Protect the formulas, then save as a template

Once your math works, lock the formula cells so a stray click doesn’t overwrite them while you fill in this month’s details. Follow protect formulas in Excel while allowing input to keep the description and quantity cells editable but the totals safe. Finally, save the file as an Excel Template (.xltx) so every new invoice starts from a clean copy instead of overwriting last month’s.

That free template will serve you well for sending individual invoices. Set a print area around the invoice block so it exports to PDF cleanly, and you’re ready to bill.

Where a free invoice template stops working

Here’s the honest part. A free invoice template does exactly one thing: it creates one invoice at a time. It does not tell you:

• How much you’ve actually been paid versus what’s still outstanding
• Which clients are most profitable and which are quietly costing you time
• What you’ve spent on expenses (software, contractors, gear) this quarter
• What your profit really is after costs
• How much to set aside for taxes before the bill arrives

Most freelancers solve this by duplicating their invoice file dozens of times, then building a fragile second spreadsheet to total everything up — and that second spreadsheet is where formula errors, broken references, and “wait, did I get paid for this?” panic live. You end up doing bookkeeping by hand at the worst possible time of year.

The all-in-one upgrade: Freelance Business Hub

When invoicing becomes a business and not a one-off, the Freelancer Invoice & Expense Tracker template ($19) does the whole job in a single connected workbook. It’s the same Excel you already know — no subscription, no login, no learning curve — but every sheet talks to the others.

What it does that a free invoice template can’t:

• Professional invoices that feed your books automatically. Fill in an invoice and the amount, client, and status flow straight into your records. No re-typing, no second spreadsheet.
• Built-in expense tracking. Log software, subcontractors, equipment, and mileage in one tab, categorized and ready for tax time.
• Per-client income view. Instantly see who your top clients are and how much each one has paid you year to date — the kind of SUMIF-style breakdown the workbook builds for you so you never write the formula.
• A profit & tax dashboard with charts. One screen shows income, expenses, net profit, and an estimated tax set-aside, with visual charts so trends jump out instead of hiding in rows of numbers.
• Zero formula errors, ready instantly. Every calculation is pre-built and tested, with totals already rounded correctly and input cells already protected. You open it and start working — no setup hour, no broken references.

If you value your billable hours, $19 to skip an afternoon of spreadsheet-building (and a lifetime of tax-season scrambling) is an easy call. Get the Freelance Business Hub and have invoicing, expenses, and your profit dashboard running in minutes.

Free vs. paid: which should you pick?

Choose the free DIY template if you send a handful of invoices a year, don’t need expense tracking, and enjoy building spreadsheets. It’s genuinely enough for a side gig.

Choose the Freelance Business Hub if freelancing is your income and you want invoices, expenses, per-client totals, and a profit-and-tax picture in one place — without becoming an Excel power user first. It pays for itself the first time it shows you a client who isn’t worth the work, or saves you a weekend in April.

Get the Freelancer Invoice & Expense Tracker →

FAQ

Does Excel have a built-in invoice template?

Yes. Go to File → New and search “invoice” in the template gallery to find Microsoft’s stock options. They’re a fine starting point, but they only create single invoices — they don’t track payments, expenses, or profit across clients.

How do I make my invoice totals update automatically?

Use formulas instead of typing numbers. Multiply quantity by rate for each line (=B12*C12), then use =SUM() over the amount column for the subtotal. Because the cells reference each other, changing a quantity updates every total instantly.

Can I protect my invoice so I don’t break the formulas?

Yes. Excel lets you lock specific cells while leaving others editable, so you can fill in descriptions and quantities but can’t accidentally overwrite the total formulas. See our guide on protecting formulas while allowing input.

What’s the difference between an .xlsx and an .xltx file?

An .xlsx is a normal workbook. An .xltx is a template: when you open it, Excel creates a fresh copy and leaves the original untouched. Saving your invoice as a template means every new invoice starts clean instead of overwriting last month’s.