Free Excel Invoice Template
A clean, professional invoice you can send today. Auto-calculating line items and tax, Net-30 due-date logic, a client database, and an invoice log with paid/unpaid status. Works for freelancers, contractors, and small businesses. Free forever — no signup, no email, no watermark.
Invoice Template 2026 — full workbook
Six sheets: printable invoice, business info, client database, invoice log with payment tracking, terms library, setup guide. Ready to send in under three minutes.
↓ Download invoice-template-2026.xlsxPreview: what your invoice will look like
The Invoice sheet is designed to look professional out of the box — clean typography, a subtle green accent, plenty of white space, and print-ready A4 and Letter layouts. Replace the placeholder business name with your own and you're ready to send.
Northline Consulting
| Description | Qty | Rate | Amount |
|---|---|---|---|
| Q1 market landscape research — deliverable report | 1 | $4,500.00 | $4,500.00 |
| Advisory sessions (hourly) | 6 | $225.00 | $1,350.00 |
| Competitor analysis — supplementary brief | 1 | $800.00 | $800.00 |
| Expenses reimbursement (travel + subscriptions) | 1 | $247.60 | $247.60 |
Late payments accrue 1.5% interest per month after due date.
Please reference invoice number on transfer.
The Invoice Log sheet tracks every invoice you've sent, with paid/unpaid status highlighted so you can see outstanding balances at a glance. Payment reminders become easy — just filter by "Overdue".
| Invoice # | Client | Date | Due | Amount | Status |
|---|---|---|---|---|---|
| INV-2026-0042 | Willow & Ash Media | Jan 15 | Feb 14 | $7,242.48 | Pending |
| INV-2026-0041 | Redwood Analytics | Jan 8 | Feb 7 | $2,400.00 | Paid |
| INV-2026-0040 | Harbor Legal | Jan 3 | Feb 2 | $3,850.00 | Paid |
| INV-2025-0039 | Ember & Co | Dec 12 | Jan 11 | $1,275.00 | Overdue |
| INV-2025-0038 | Beacon Studios | Dec 4 | Jan 3 | $5,600.00 | Paid |
What's inside the workbook
Six sheets, all pre-formatted and cross-linked. Nothing to wire up:
- Setup Guide — 3-minute walkthrough on the first sheet. Customize once, use forever.
- Business Info — Your name, address, tax ID, bank details, logo placeholder. Enter once — flows into every invoice.
- Invoice — The main sheet. Clean design, auto-totals, print-ready. This is what your client sees.
- Client Database — Rolodex of your clients. Pick from a dropdown on the Invoice sheet and their details auto-fill.
- Invoice Log — Track every invoice you send. Paid/Pending/Overdue status auto-color-codes. YTD totals at the top.
- Terms Library — Pre-written payment terms, late-fee clauses, and notes you can copy-paste. Time-saver for repeat clients.
Features that make this different from other invoice templates
Auto-calculating totals
Enter quantity and rate — line amounts, subtotal, tax, and grand total update instantly. No manual math, no calculator errors.
Smart due-date logic
Pick your payment terms (Net 15, Net 30, Net 60, or custom) and the due date calculates automatically from the invoice date.
Client dropdown auto-fill
Select a client name from the dropdown and their billing address, contact, and default terms populate automatically. Save on repeat typing.
Overdue alerts
The Invoice Log turns any pending invoice red the moment its due date passes. Follow-ups become obvious instead of forgotten.
Any currency, any tax rate
Change the currency symbol in one cell — it updates everywhere. Set your local tax (VAT, GST, HST, sales tax) on the Business Info sheet.
Print & PDF ready
Print settings pre-configured for A4 and US Letter. Save-as-PDF from Excel gives you a professional invoice attachment for email.
Who this invoice template is for
Freelancers & consultants
Send professional invoices without paying $15/month for FreshBooks or Wave. Your data, your file, one workbook.
Small business owners
Sub-50-invoice/year businesses that don't need full accounting software but still want tracking and follow-up.
Contractors & agencies
Bill hourly or project-based work with line-item detail. Reuse client info and terms across every invoice.
Payment terms explained (Net 15, Net 30, Net 60)
"Net" followed by a number is the standard shorthand for how many days after the invoice date payment is due. The template supports every common variation:
The template's Terms dropdown lets you pick — the Due Date field calculates automatically using =EOMONTH or =DATE+N depending on your terms. Custom terms (e.g., "50% upfront, 50% on delivery") go in the Notes field.
Invoice numbering: best practices
Every invoice needs a unique identifier. The specific format matters less than consistency — but here's what works for most businesses:
The recommended format: INV-YYYY-####
Example: INV-2026-0042 — "Invoice, 2026, 42nd of the year."
This format is sortable, obvious at a glance, and doesn't reveal how few invoices you've sent (nobody wants to be a new client's "Invoice #001"). Reset the sequential counter each January or continue year-over-year — both work. The template uses the reset-each-year approach.
Client-prefixed format: ACME-2026-042
If you invoice many clients regularly, prefixing with the client's short code makes lookups faster: "ACME-2026-042" is instantly identifiable as Acme Corp's 42nd invoice of 2026. Great for consultants managing 10+ active accounts.
What to avoid
Don't use random-looking IDs (UUIDs, timestamps) — they're impossible to reference in a phone call. Don't use just sequential numbers (1, 2, 3...) — no context, and reveals volume. Don't reset without documentation — you'll end up with two invoices sharing the same number, which is a nightmare when a client disputes.
How to use it — 4-step setup
Enter your business info once
Open the Business Info sheet. Fill in your business name, address, tax ID, contact email, and default payment terms.
- Bank details go in the Payment Instructions field — appears on every invoice.
- Default tax rate is set here — the invoice pulls it automatically.
- Logo goes in the placeholder image slot — Insert → Picture from File.
Add your clients to the database
Open the Client Database sheet. One row per client: company name, contact person, billing address, email, default payment terms.
- Once added, clients appear in the dropdown on the Invoice sheet.
- Selecting a client auto-fills their billing details.
- Add clients anytime — the dropdown updates automatically.
Create the invoice
Open the Invoice sheet. Update the invoice number, pick the client from the dropdown, set the invoice date, choose payment terms.
- Line items: enter description, quantity, and rate. Amount computes automatically.
- Tax rate defaults to your Business Info setting — override for this invoice if needed.
- Save-as PDF (File → Save As → PDF) to attach to email.
Log it and track payment
After sending, add a row to the Invoice Log: invoice number, client, amount, sent date, due date, status = Pending.
- When paid, change status to Paid. Row turns green.
- Overdue invoices auto-highlight red past the due date.
- YTD totals at the top show revenue, outstanding balance, average days-to-pay.
Customizing the template
Add your logo
On the Invoice sheet, delete the "LOGO" placeholder text and go to Insert → Picture → From File. Select your logo image (PNG or JPG, ideally under 500 KB). Resize by dragging corners. The template's header area is designed for a logo up to 200 × 80 pixels — larger logos may push the layout.
Change the accent color
The template uses a soft green (#7C9F5C) as the primary accent. To change: select the header bar and totals row → Home → Fill Color → pick your brand color. Apply the same color to text elements marked with the accent. Takes 30 seconds.
Change the currency
Select all money cells (Amount column, subtotal, tax, total) → Right-click → Format Cells → Currency → pick your symbol. The workbook uses USD by default; every other currency (€ £ ¥ ₹ ₨ ₺ R$ CHF) works identically. For multi-currency invoicing, keep separate copies of the template per currency.
Change payment terms options
Payment terms dropdown lives on the Terms Library sheet — edit the list there and the dropdown updates automatically. Add "50% upfront, 50% on delivery" or any custom text. For custom terms, override the due date field manually (auto-calculation only handles Net-X patterns).
Add tax breakdown (GST/PST, CGST/SGST, etc.)
Some jurisdictions require split tax lines. On the Invoice sheet, insert extra rows below the Tax line. Reference the subtotal (=Subtotal*rate1, =Subtotal*rate2) and update the Total formula to include both. Detailed walkthrough in our multi-tax invoice guide.
Excel functions used inside this template
Curious how it works, or want to customize? These are the key functions the workbook uses:
Frequently asked questions
Is this invoice template really free?
Yes — free for personal and commercial use, including invoicing your paying clients. No signup, no email, no watermark, no attribution required. We appreciate a link back to this page if you feature the template elsewhere, but it's not a condition of use.
What information legally has to be on an invoice?
Requirements vary by country, but almost universally: your business name and address, your tax ID (if you have one), a unique invoice number, the invoice date, the client's name and address, a description of goods or services, the amount owed (with tax broken out), and payment terms. Some jurisdictions add specific requirements — VAT registration numbers in the EU, GST/HST details in Canada, PAN/GST in India. Check your local rules; the template includes all common fields.
Can I use this for international clients?
Yes. The template works for cross-border invoicing — just change the currency symbol to match the currency you're billing in, and add any required international details (VAT registration if you're EU-based, W-8BEN reference if you're billing a US client from abroad, etc.). Some countries require invoices in specific languages; you may need to translate the field labels.
How do I add my logo?
Delete the "LOGO" placeholder text on the Invoice sheet. Then Insert → Picture → From File and pick your logo. Resize by dragging corners. Recommended size: 200 × 80 pixels (or thereabouts). Save the workbook — the logo now appears on every invoice you generate from this template.
How do I export the invoice as a PDF?
In Excel: File → Save As (or Export in newer versions) → choose PDF as the file type → make sure "Selection" or the Invoice sheet is selected (not the entire workbook, which would export all six sheets). The resulting PDF is professionally formatted, single-page, and safe to email. Google Sheets: File → Download → PDF.
Can I use it in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open with Google Sheets. All formulas and formatting transfer. Print settings may need light re-configuration since Google Sheets handles page layout differently from Excel. Save as Google Sheets format to work in Sheets natively, or keep as .xlsx to open back in Excel.
How do I handle late payments and late fees?
Add a Late Fee Clause to the Terms Library sheet — the template includes a starter one you can customize: "Late payments accrue 1.5% interest per month after the due date." When an invoice goes overdue, you can either send a reminder with the original terms, or issue a follow-up invoice adding the accrued interest as a separate line item. Most freelancers charge late fees only for clients who become chronic latepayers.
How do I handle partial payments?
On the Invoice Log, add columns for "Amount Paid" and "Balance Due" (or use the ones the template already includes — they're on the right side of the log). When a client pays partially, log the amount received; the balance updates automatically. Change status from Pending to Partial. Send a follow-up invoice for the outstanding balance or wait for full payment before changing status to Paid.
What's VAT vs sales tax vs GST — which does the template use?
The template uses a generic "Tax" line that can represent any tax type — you configure the rate on the Business Info sheet. VAT (Value Added Tax, Europe/UK), GST (Goods and Services Tax, Australia/Canada/India), HST (Harmonized Sales Tax, Canada), and US sales tax are all just percentages applied to the subtotal. If your jurisdiction requires multiple tax lines (e.g., India's CGST + SGST), see the customization section above for how to add split tax rows.
How long do I have to keep invoice records?
Varies by country. US: 3-7 years depending on the type of return and IRS rules. UK: 6 years (HMRC). EU: 10 years in most countries. Canada: 6 years. India: 8 years. When in doubt, keep them for 7-10 years. Cloud backup (Google Drive, Dropbox, OneDrive) plus a local copy on your computer is the recommended setup.
What if a client disputes the invoice?
Respond professionally and in writing (email counts). Reference the invoice number and the exact line items in question. If there's a scope disagreement, quote your original contract or engagement letter. Keep a copy of the disputed invoice unchanged — never delete or modify a sent invoice. If needed, issue a credit note (a separate invoice with negative amount) rather than editing the original.
Should I invoice with or without tax?
You're required to charge tax if you're tax-registered in your jurisdiction and your services or goods are taxable. If you're under the small-business threshold (varies: US ~$400 in some states for sales tax, UK ~£90k VAT threshold, Canada ~$30k GST, Australia ~$75k GST), you may not need to charge tax — but check with a local accountant. When in doubt, set the tax rate to 0% on the Business Info sheet; the template still works fine.
Can I use this for hourly billing vs project billing?
Yes — both. For hourly work, describe the task in the Description column, enter hours in Qty, and hourly rate in Rate. For project work, enter the deliverable in Description, "1" in Qty, and the flat project fee in Rate. Mixed invoices (both hourly and project) work naturally — one row per work type.
The Invoice Log seems to only track one year — how do I keep older invoices?
The log tracks unlimited invoices — it's just a table you keep adding rows to. For long-term storage, copy the completed workbook once a year (e.g., save "invoices-2025.xlsx" at year-end) and start fresh. Or keep everything in one workbook indefinitely; Excel handles tens of thousands of rows without slowing down.
Related templates
Automate invoice-writing with the Sheets & Cells AI Add-in
Describe what you need — "invoice for 6 hours of consulting at $225/hour plus 5% tax" — and the Add-in fills the template automatically. Change client names or line items in plain English. All inside Excel.
Learn about the Add-in →