Free Excel Invoice Template (2026) — Professional & Printable | Sheets & Cells
BUSINESS TEMPLATE

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.xlsx
File size~120 KB
Format.xlsx (Excel 2016+)
LicenseFree personal & commercial use
Last updatedJanuary 2026
No signupDirect download
Print & PDFReady as-is
Any currencyUSD, EUR, GBP, INR, PKR…
Fully editableEvery cell unlocked

Preview: 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.

📄 Invoice sheet — print & PDF-ready Sheet 3 of 6

Northline Consulting

Independent strategy & research
INVOICE
#INV-2026-0042
Bill To
Willow & Ash Media Ltd
Attn: Sarah Chen, Head of Marketing
205 Regent Street, London W1B 4HB
accounts@willowandash.com
From
Northline Consulting
Alex Morgan, Principal
14 Harbour Lane, Vancouver BC V6B 5R3
hello@northline.co · Tax ID: 987-65-4321
Invoice Date
Jan 15, 2026
Payment Terms
Net 30
Due Date
Feb 14, 2026
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
Payment Details
Bank transfer preferred. Account details on request.
Late payments accrue 1.5% interest per month after due date.
Please reference invoice number on transfer.
Subtotal $6,897.60
Tax (5%) $344.88
Total Due $7,242.48

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 Log — payment tracking Sheet 5 of 6
Invoice #ClientDateDueAmountStatus
INV-2026-0042Willow & Ash MediaJan 15Feb 14$7,242.48Pending
INV-2026-0041Redwood AnalyticsJan 8Feb 7$2,400.00
INV-2026-0040Harbor LegalJan 3Feb 2$3,850.00
INV-2025-0039Ember & CoDec 12Jan 11$1,275.00Overdue
INV-2025-0038Beacon StudiosDec 4Jan 3$5,600.00
Skip ahead and grab the file — send your first invoice today.
Download .xlsx

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:

Due on Receipt
Payment expected immediately. Common for small amounts or new clients you haven't built trust with yet.
Net 7
Payment due 7 days from invoice date. Common in retainer arrangements or with clients you invoice frequently.
Net 14
Two-week window. A middle ground between weekly cadence and monthly billing cycles.
Net 15
Popular for freelancers — long enough for clients to process, short enough to protect your cash flow.
Net 30
The default in most B2B relationships. Standard for professional services, agencies, and consultants.
Net 45 / Net 60
Common with enterprise clients whose accounts-payable cycles are slow. Negotiate for early-payment discounts if using these.

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.

Legal note: Some jurisdictions (UK, EU, Australia, India, and others) require invoices to have unique, sequential numbers with no gaps. Check your local rules. Sequential-by-year (INV-2026-0001, 0002, 0003...) satisfies this requirement in every jurisdiction we know of.

How to use it — 4-step setup

1

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.
2

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.
3

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.
4

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:

Ready to send your next invoice looking polished?
Download .xlsx

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 →