Template

Invoice Template Excel — Free Microsoft Excel Invoice (2026)

6 min read

Excel is a spreadsheet tool, not an invoicing tool — but it can work in a pinch. Here's how to build a functional invoice in Excel, what to watch out for, and when you should switch to something better.

Skip Excel — create a proper PDF invoice in 60 seconds

No formatting headaches. No "the client edited the total." Free, no signup required.

Create free invoice

What an Excel invoice looks like

INVOICE
[Your Name / Business Name]
[your@email.com]
[yourwebsite.com]
Invoice #: INV-001
Date: [Date]
Due: =Date+30
Bill To
[Client Company]
[Contact Name / Email]
Description
Qty
Rate
Amount
[Service or item]
1
$0.00
=C*D
[Service or item]
1
$0.00
=C*D
Subtotal=SUM(E15:E25)
Tax (10%)=Sub*0.10
Total Due=Sub+Tax
Payment: [Bank / PayPal / Stripe]

Formula cells (=SUM, =C*D) auto-calculate totals — the main advantage of using Excel over Word.

How to set up your Excel invoice (12 fields)

Open a blank spreadsheet and configure these cells in order:

1
Your Name / Business Name
Cell A1 — make it large and bold
2
Your Address & Contact
Cells A2–A5
3
INVOICE header
Cell E1 — right-aligned, 24pt bold
4
Invoice Number
Cell E2 — use a formula like =CONCATENATE("INV-",E3)
5
Invoice Date
Cell E3 — format as Date
6
Due Date
Cell E4 — use =E3+30 for Net 30 auto-fill
7
Bill To section
Cells A8–A12 — client name, company, address
8
Line item table (Description, Qty, Rate, Amount)
Rows 15–25 — Amount = =C15*D15
9
Subtotal formula
=SUM(E15:E25)
10
Tax line
=Subtotal*0.10 (or 0 if not applicable)
11
Total Due
=Subtotal+Tax — make this stand out
12
Payment instructions
Footer row — bank details or PayPal email

6 reasons Excel invoices cause problems

Excel works — until it doesn't. Here's what breaks:

Clients can edit the file
Excel invoices can be opened and modified by anyone. A client could change the total before paying. PDFs cannot be edited.
Print-to-PDF formatting breaks
Excel cells shift when you print to PDF. Borders move, columns overflow, fonts render differently. Every print needs manual checking.
No invoice numbering system
You have to manually increment INV-001, INV-002. Forget once and you have duplicate invoice numbers — an accounting headache.
No client records
Every invoice starts from scratch. No saved client details, no history of what you've billed or what's been paid.
macOS / Google Sheets formatting
If your client opens your .xlsx in Numbers or Google Sheets, formatting breaks. The invoice they see may look completely different from what you sent.
No mobile-friendly view
Excel files don't open cleanly on phones. If a client opens your invoice on mobile, they may see a broken layout — or not open it at all.

When Excel invoices are fine

You invoice fewer than 5 clients total
Your invoices are always printed and handed over in person (no email delivery)
You're testing a business idea and not yet earning enough to justify a tool
Your client specifically requested an editable spreadsheet (e.g., for internal approval workflows)

Excel vs PDF invoice generator

FeatureExcelSwiftBill
Auto-calculate totals✓ (formulas)✓
Tamper-proof PDF output✗✓
Consistent formatting on all devices✗✓
Invoice number trackingManual✓ Auto
Save client details✗✓
Mobile-friendly for recipients✗✓
Free to use✓ (if you own Excel)✓

Excel invoice FAQ

Can I send an Excel invoice directly to a client?

You can, but it's not recommended. Send the invoice as a PDF (File → Save As → PDF or Print → Microsoft Print to PDF). This prevents the client from editing the amounts and ensures the formatting is preserved.

Are Excel invoices legal and accepted?

Yes, an Excel-derived PDF is a valid invoice. The format doesn't affect legality — what matters is the information it contains (your details, client details, itemized services, totals, and payment info).

What's the best Excel formula for invoice totals?

Use =C15*D15 for line item amounts (qty × rate), =SUM(E15:E25) for subtotal, =subtotal*0.10 for tax (adjust rate), and =subtotal+tax for total due. Lock your formula cells with Ctrl+1 → Protection → Locked.

Does Google Sheets work as an Excel invoice template?

Google Sheets works similarly to Excel for invoicing. The same setup steps apply. The main advantage is no software required — clients with a link can view it in their browser. The same limitations apply: editable, inconsistent printing.

When should I stop using Excel for invoices?

When you're sending more than 10 invoices a month, when you have recurring clients, or when you've had a payment dispute where invoice integrity mattered. At that point, a dedicated PDF generator saves you time and protects you legally.

Try a proper invoice generator

PDF, auto-calculated, tamper-proof. No signup, free for 5 invoices/month.

Try free — no signup Create free account

Related guides

Invoice Template WordInvoice Template Google DocsSimple Invoice TemplateFree Invoice Generator