Excel has been freelancers’ default invoicing tool for decades. It handles the math, exports to PDF, and costs nothing if you already have it. Here’s how to set up a template that works and where to find one ready-made.
What makes an Excel invoice template work
The advantage of Excel over a word processor for invoicing is the calculation layer. Formulas handle arithmetic for you, which removes transcription errors—the most common and embarrassing invoice mistake.
A well-structured Excel invoice template uses:
Line total formula:
=C10*D10 (Quantity × Unit Price)
Subtotal formula:
=SUM(E10:E20) (Sum of all line totals)
Tax formula:
=$B$25*E21 where B25 is your tax rate cell (e.g., 0.10 for 10%)
Total formula:
=E21+E22 (Subtotal + Tax)
Setting up named ranges for the tax rate cell (e.g., naming it TaxRate) makes the formula more readable and easier to update.
The essential sections of a freelance invoice
Header: Your name or business name, address, email, phone, and logo (optional but professional).
Invoice metadata:
- Invoice Number (Q-INV-2026-001 or similar)
- Invoice Date (date of issue)
- Payment Due Date (not “30 days”—calculate the actual date)
Bill To: Client name, company name, billing address, and email.
Line items table:
| Description | Hours / Qty | Rate | Amount |
|---|---|---|---|
| Brand identity design | 1 | $2,400 | $2,400 |
| Logo revisions (Round 2) | 1 | $300 | $300 |
Totals: Subtotal, Tax, Total Due
Payment instructions: Bank transfer details, PayPal email, or payment portal link. Don’t make clients hunt for how to pay you.
Notes (optional): “Thank you for your business.” or a reference to the project, contract number, or purchase order.
How to set up the template
Open a blank Excel workbook. Set the page layout to portrait, Letter size (or A4 for international), with 1-inch margins.
Merge the top several rows to create a clean header area. Insert your logo as an image. Add your business details in a text block.
Create the line items table starting around row 15–20. Use four columns: Description (wide), Quantity, Rate, Amount. Format the Quantity and Rate columns as Number; the Amount column as Currency.
Add your formulas in the Amount column. Below the table, add the totals block. Set the tax rate in a clearly labeled cell so you can change it in one place.
Protect the formula cells in your master template before you start using it. One accidental overwrite of a subtotal formula and your invoice total is wrong—the kind of error that undermines client trust.
Where to download a free Excel invoice template
Microsoft Office template gallery (templates.office.com): The official source for Excel templates. Search “invoice” and filter by Excel. The built-in designs are functional but visually basic—easy to customize.
Vertex42 (vertex42.com): One of the best maintained spreadsheet template libraries. Their freelancer invoice template is clean, well-structured, and includes all the essential formulas. Free download.
Bonsai: Bonsai’s free template library includes Excel and Google Sheets invoice templates designed specifically for freelancers. Download doesn’t require an account.
Invoice Simple: Free invoice templates in Excel and Word format, with a preview before download.
Google Sheets template gallery: If you prefer browser-based work, Google Sheets has invoice templates in its built-in gallery that function identically to Excel—same formulas, shareable links, and PDF export.
Google Sheets vs. Excel: which is better for freelancers?
| Feature | Excel | Google Sheets |
|---|---|---|
| Cost | Included with Office 365 or one-time purchase | Free |
| Formulas | Identical | Identical |
| Access | Desktop only (or online with OneDrive) | Any browser, any device |
| Collaboration | Harder to share | Easy share links |
| Offline use | Yes | Limited (with offline mode enabled) |
| PDF export | File → Save As → PDF | File → Download → PDF |
For most freelancers without a Microsoft 365 subscription, Google Sheets is the practical choice—it’s free, accessible from any device, and produces the same output.
When to move beyond Excel invoicing
Excel works until it doesn’t. The inflection point is usually when:
- You have more than 10–15 outstanding invoices to track at once
- Clients are paying late and you need reminders or overdue notices
- You want to know when clients have opened your invoices
- You need recurring invoices for retainer clients
- Your accountant asks for cleaner financial records
At that point, even a free-tier invoicing tool like Wave or an entry-level SaaS app will save more time per month than the Excel workflow costs. The pivot is usually later than it should be—most freelancers wait until the spreadsheet is causing real problems before switching.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
