Classic Freelancer Invoice Template
A classic freelancer invoice template ideal for freelancers. The invoice you send when the work speaks for itself. Download in Excel or PDF.
Preview
Some invoices need columns for quantity, unit price, discount and tax. Most freelance invoices do not. You did a piece of work, it had a price, and both of you already agreed what that price was.
This template is built for that: a wide description column, an amount column, and nothing in between to fill in for the sake of it.
The result is simple and readable. A big INVOICE at the top, your name under it, the client's details on the right, the project named in bold across the middle, and then the work.
Get a working Excel file
Answer the questions, generate, and you download a real .xlsx with live formulas, or a .pdf if you want the raw numbers. Change an amount later and the subtotal, tax and total all follow.
What is on the invoice
A masthead with your business name and contact details
The invoice date, number and bill-to block on the right
A project title in large type across the page, so the invoice announces what it is for
A description and amount table with room for twelve lines
A totals block: subtotal, tax rate, sales tax, an "other" line, and the total
Two note areas beside the totals, for payment instructions and a contact line
A thank you at the foot
How to describe your lines
The description column is very wide, you should be specific when writing the description. For example, instead of writing just "Design work" write "Logo design, three routes plus two revision rounds". It reminds the client of what they agreed to and what they received.
Breaking a project into its parts also protects you. If a client later disputes one deliverable, you want it priced separately on the invoice rather than buried in a single number.
The tax rate is a plain number
Enter 20 for 20 percent, not 0.2. The cell shows 20.00% and the sales tax line divides by a hundred behind the scenes. Many freelancers are not registered for sales tax or VAT at all, in which case leave it at zero and the line shows nothing.
The "other" line
Use it for anything that is not one of your work items: expenses you are passing on, a rush surcharge, or a deposit the client already paid, entered as a negative number so it comes off the total. It is added after tax, so it suits items you are not charging tax on.
Getting paid, not just invoiced
The two note areas beside the totals are the most useful part of this template and the most often wasted. Put your actual bank details in the first one. Put a named person, a phone number and an email in the second, along with your payment terms.
An invoice that makes someone hunt for how to pay it is not optimal.
How to create your invoice
Open the template and click Generate.
Enter your business details and the invoice date and number.
Add the client's details in the bill-to block.
Name the project.
Add one line per piece of work, with its amount.
Set your tax rate, or leave it at zero.
Write your payment instructions and contact line, then generate and download.
One limit worth knowing
The items table holds twelve rows. The totals sit directly beneath it, so a thirteenth line would land on top of them. If a project genuinely needs more, group related deliverables onto one line or download the excel sheet and edit as you want.
Who is this for
Freelancers and independent contractors billing by the project rather than the hour. Designers, writers, developers, photographers, consultants. Small studios sending a handful of invoices a month who want them to look considered without buying invoicing software.
Note: This template is provided for convenience and general information only and is not legal, tax or accounting advice. What an invoice must show, which tax you must charge and how long you must keep records depend on where you and your client are based. Check your local rules or ask your accountant. An invoice must reflect work that was genuinely done.
- Professional formatting and layout
- Easy customization with guided questions
- Multiple export formats: pdf, xlsx
- Legally reviewed and compliant
- Instant download after generation
What file do I get, and can I edit it afterwards?
You get an Excel file (.xlsx), plus a .csv if you want the raw figures. The Excel file is fully editable, which is the point of choosing it over a PDF invoice. Open it, change an amount, and the subtotal, tax and total recalculate, because they are real formulas rather than numbers baked in at generation time. Print it to PDF when you are ready to send it.
There is no quantity or rate column. Is that a mistake?
No, it is the point of this template. Project work is usually agreed as a price for a deliverable, not a number of units, and inventing a quantity of 1 for every line just adds noise. If you bill by the hour, use the timesheet invoice template instead, which carries hours and a rate on every line and works out the arithmetic for you.
How do I enter the tax rate?
As a plain number. Type 20 for 20 percent, not 0.2. The cell displays it as 20.00% and the sales tax line divides by a hundred behind the scenes. Many freelancers are not registered to charge sales tax or VAT at all, in which case leave it at zero and the line shows nothing.
How many lines can I add?
Twelve. The totals sit directly beneath the items table, so a thirteenth line would overwrite them. The limit comes from the layout rather than being an arbitrary cap. Twelve is generous for project work. If you need more, grouping related deliverables onto a single line usually reads better anyway.
How do I show a deposit the client has already paid?
Put it on the Other line as a negative number, for example -500, and it comes off the total. It is worth naming it in your payment instruction as well, something like 'less deposit received 1 August', so the client can match it against their own records without calling you.
What should I write in the two note areas?
The first one is how to pay you: bank name, account name, account number, and any reference you want quoted. The second is who to ask and by when: a named person, a phone number, an email, and your payment terms. These two boxes are the most useful part of the invoice and the most commonly wasted. An invoice that makes someone hunt for how to pay it gets set aside.
How specific should my line descriptions be?
More specific than feels necessary. The description column is the widest on the sheet precisely so you can be. 'Design work' invites a query; 'Logo design, three routes plus two revision rounds' does not, because it reminds the client what they agreed to and what they received. Breaking a project into its parts also protects you if one deliverable is later disputed.
How do I show my currency?
Enter it as a symbol and it is applied to the number format of every money cell, so figures display as $1,400.00 without you typing the symbol into each one. That also keeps them as numbers rather than text, which is what lets the sums work. If you invoice clients abroad, use the symbol they will recognise and name the currency in your payment instruction too.
Can I add my logo?
Not on this one. It is a spreadsheet template and the generator fills cell values rather than placing images, so your business name is set large at the top as text instead. That is a deliberate look rather than a compromise, but if a logo matters to you, use one of the HTML invoice templates, which place your logo from your company profile and produce a PDF.
Can I use this for a quote or estimate?
You can, with two changes. Retitle the project line so it reads as a quote, and replace the payment instruction with how long the price holds for and what happens next. Be careful not to leave the word Invoice on a document you intend as a quote, because in many places an invoice is treated as a demand for payment and a client's accounts system may well pay it.
Premium plan required to use this template