Excel invoicing is the default path for anyone whose first reaction to "I need to invoice someone" is "open a spreadsheet." It works. It has the advantage of total control over layout and the disadvantage of needing you to actually know a bit of Excel. Here's the minimum-viable recipe — not the prettiest invoice you'll ever see, but the one that'll get paid.
The six-section layout
Most invoice disasters come from making the layout too clever. Six sections, in order. Nothing fancy.
┌──────────────────────────────────────────────────┐ │ 1. HEADER (rows 1-6) │ │ Your business info (left) + INVOICE # and │ │ dates (right) │ ├──────────────────────────────────────────────────┤ │ 2. BILL TO (rows 8-11) │ │ Client's legal billing entity │ ├──────────────────────────────────────────────────┤ │ 3. LINE ITEMS (rows 13-24) │ │ Description · Qty · Rate · Amount │ ├──────────────────────────────────────────────────┤ │ 4. TOTALS (rows 25-28) │ │ Subtotal · Tax · Total │ ├──────────────────────────────────────────────────┤ │ 5. NOTES (rows 30-32) │ │ Payment methods, Net terms, thank you │ ├──────────────────────────────────────────────────┤ │ 6. FOOTER (row 34) │ │ Invoice number repeated, page info │ └──────────────────────────────────────────────────┘
Columns: A (Description), B (Quantity), C (Rate), D (Amount). Set column widths to ~35, ~12, ~12, ~15 characters respectively.
The three formulas you actually need
- Line amount. In cell D14:
=B14*C14. Fill down through D24. Every row calculates Qty × Rate. - Subtotal. In cell D25:
=SUM(D14:D24). Sums the Amount column. - Tax and total. Put your tax rate in cell F3 (e.g., 0.085 for 8.5% or 0.13 for 13% HST). Then: Tax cell (D26) =
=D25*F3. Total cell (D27) ==D25+D26.
Format D column as currency: select D14:D27, Ctrl+Shift+$ (Windows) or ⌘+Shift+$ (Mac). Set decimals to 2. Bold row 27 (Total).
The one button that matters: print area
Excel's default behavior is to print whatever fits on a page, which rarely matches where your invoice actually ends. Set the print area manually to avoid surprises:
- Select the range covering your whole invoice — usually A1:F34 or similar.
- Page Layout → Print Area → Set Print Area.
- Page Layout → Orientation: Portrait.
- Page Layout → Size: Letter (US) or A4 (rest of the world).
- Page Layout → Scale to Fit: Width 1 page, Height 1 page.
Then File → Print → Preview. What you see is what the PDF looks like. Adjust column widths if the right edge is cutting off.
Export to PDF (the non-optional step)
Send the .pdf, never the .xlsx. Two reasons: your formulas can break if the client opens it in a different version of Excel, and half of AP systems reject editable file attachments.
- Windows Excel: File → Save As → change file format to PDF.
- Mac Excel: File → Export → PDF.
- Excel Online: File → Print → Save as PDF (via browser dialog).
- Google Sheets: File → Download → PDF. Works identically.
Name the file predictably: `INV-2026-001-ClientName.pdf`. Clients sort by name; your bookkeeping sorts by date. Consistent naming saves both.
Five things people usually get wrong
- Sending the .xlsx. Covered above — always PDF.
- Missing invoice number. Client AP systems use this as the primary key. Missing or duplicate numbers delay payment by 2-4 weeks. Keep a running log in a separate sheet so you never reuse a number.
- Unsegmented line items. "Website work — $5,000" is a rejection trigger. One line per deliverable. The more detail, the less back-and-forth.
- Wrong tax math. Check your formula. If your tax rate is 13% and D25 is $1,000, D26 should be $130 and D27 should be $1,130. Double-check with a calculator before sending.
- Page-2 orphans. If your invoice runs onto a second page with just the Total on it, shrink rows or widen the print area so everything fits on one page. Pay attention in print preview.
When to skip Excel
If you invoice more than ~5 clients/month, the per-invoice friction in Excel adds up fast. Things a dedicated tool handles that Excel doesn't:
- Automatic sequential invoice numbering
- Client database (don't re-enter addresses every time)
- Sent / paid / overdue tracking
- Payment links via Stripe, PayPal, etc.
- Multi-currency with automatic FX
- Recurring invoices (for retainer clients)
- Reminder emails sent automatically
Our free invoice generator covers most of these without a signup and without sending anything to a server. It takes about 30 seconds per invoice once you've entered your business info, vs. the 10-minute Excel edit cycle. For sub-pages specific to formats: Excel invoice template, Google Sheets invoice template, Word invoice template.
FAQ
What's the easiest way to make an invoice in Excel?
Start with a blank workbook, lay out the six sections (header, billing, line items, totals, notes, footer) across rows 1-30, and use simple formulas for the math: quantity × rate per line, SUM for subtotal, then tax as a percentage of subtotal. Under 15 rows total. Save as .xlsx for editing, export as PDF for sending. The whole thing takes about 10 minutes the first time; 2 minutes once you have the template saved.
What formulas do I need for an invoice in Excel?
Three formulas cover everything. Line amount: =B14*C14 (quantity in B times rate in C). Subtotal: =SUM(D14:D24) summing the Amount column. Tax: =D25*0.085 (or whatever your rate is — better: =D25*F3 where F3 holds the tax rate). Total: =D25+D26. Format cells as currency (Ctrl+Shift+$ on Windows) and you're done.
How do I add my logo to an Excel invoice?
Insert → Pictures → pick your logo PNG. Drag to the top-left of the page (above your business name typically). Right-click the image → Size and Properties → set a fixed size (typically 120px wide) and 'move and size with cells' off so it doesn't shift when you edit. Save a copy of the file without the logo as a template, since most clients don't need the original xlsx back.
How do I save an Excel invoice as PDF?
File → Save As → change the file format dropdown to PDF. On a Mac it's File → Export → PDF. Set the print area first (select the invoice rows, Page Layout → Print Area → Set Print Area) so the PDF is one page without extra white space. Always preview before sending — Excel's PDF export sometimes cuts off the right edge if the columns are too wide.
Should I use Excel or a dedicated invoice tool?
Excel is fine for small volumes (under ~5 invoices/month) and for one-off situations where you already have client data in a spreadsheet. It gets painful at volume because there's no automatic numbering, no sent-invoice tracking, no payment-status tracking, and no way to automate follow-ups. For regular freelancing, a dedicated tool saves real time. For a one-time invoice, Excel is the fastest path.
What if I don't have Excel?
Google Sheets works identically — all the formulas transfer, you can export to PDF via File → Download → PDF. Apple Numbers does too, though its PDF export is slightly fussier. LibreOffice Calc is the free equivalent if you want desktop software. Or skip spreadsheets entirely and use our free browser-based invoice generator, which handles the formatting, PDF export, and 10 currencies automatically.
Can I make an invoice in Excel Online / Microsoft 365 web version?
Yes, with one limitation: direct PDF export is more reliable in desktop Excel than in the web version. In Excel Online, File → Print → Save as PDF usually works but may need the browser's print dialog. If you need guaranteed single-page output with a logo that doesn't shift, desktop Excel or Google Sheets is safer.
What's the most common mistake people make with Excel invoices?
Sending the .xlsx file instead of a PDF. The client can edit it, the formulas can break, and half of AP systems reject .xlsx attachments or flag them as editable. Always export to PDF first, attach the PDF to the email. The .xlsx stays on your computer for your records.
Related
- · How to make an invoice (general) — the tool-agnostic version.
- · How to invoice as a freelancer — freelance-specific: scope, late payers, tax handling.
- · Excel invoice template — if you want the template ready to go.
- · Free invoice generator — the faster path without Excel at all.