Invoice Template for Excel: The Formulas, the Print Trap, and a Working Layout

Excel is the only template format where the invoice does its own math. For hourly and per-unit billing — 34.5 hours × $85, 12 units at three different rates — that's the whole argument: quantities and rates go in, subtotal, tax, and total come out, and the arithmetic is never wrong.

The trade is that everything else about an Excel invoice is fragile: it looks like a spreadsheet, it prints like a spreadsheet, and one careless edit deletes a formula silently. This guide builds the layout properly — the formulas, the print setup, the reuse workflow — and is honest about where the format stops being worth it. For how Excel compares to every other format, see the invoice template guide.

The layout

One sheet, four working columns, everything else is header and footer:

A                          B        C          D
------------------------------------------------------
                        INVOICE

[Your name / business]           Invoice #:  2026-015
[Email · Phone]                  Date:       2026-08-14
                                 Due:        2026-08-28
BILL TO
[Client legal name]
[Client address or email]

------------------------------------------------------
DESCRIPTION                QTY      RATE       AMOUNT
------------------------------------------------------
Frontend development      34.5    $85.00    $2,932.50
Deploy & handoff call      1.0   $120.00      $120.00
------------------------------------------------------
                                 Subtotal   $3,052.50
                                 Tax (0%)       $0.00
                                 TOTAL DUE  $3,052.50
------------------------------------------------------
PAY BY: [bank details or payment link]
Payment due within 14 days of invoice date.

The fields themselves are the standard set — the reasoning behind each is in how to write an invoice. What Excel changes is column D: it's computed, not typed.

The formulas

Assume line items live in rows 14–20, with Qty in column B, Rate in column C, Amount in column D:

• Per-row amount — in D14: =IF(B14="","",ROUND(B14*C14,2)), filled down through D20. The IF keeps empty rows blank instead of showing $0.00; the ROUND keeps cents honest.
• Subtotal — =SUM(D14:D20). Sum the whole line-item range, including empty rows — that way adding an item never means fixing the formula.
• Tax — =ROUND(Subtotal_cell * 0.0875, 2) with your actual rate, or 0 if you don't collect tax. Keep the rate visible in the label ("Tax (8.75%)"), not buried in the formula.
• Total due — =Subtotal_cell + Tax_cell. Never retype the total by hand; the one time you do is the one time it won't match.

Format columns C and D as Currency, column B as Number with one decimal (hours) or zero (units). The ROUND calls matter more than they look: without them, 3 × $33.333 displays as $100.00 but sums as $99.999, and sharp-eyed AP teams do notice penny drift.

That's the entire win. If your billing is hours × rate, this sheet also doubles as the invoice-side of your time log — the workflow around it is in how to invoice for hours worked, and the heavier contract version (labor + materials + markup) is time and materials invoicing.

The print trap

More Excel invoices die at the printer than anywhere else. The sheet that looks fine on screen exports as a two-page PDF with the total orphaned on page two, gridlines showing, and column D cut off. Before the first send, once:

1. Set the print area — select the invoice range, Page Layout → Print Area → Set Print Area. Otherwise Excel prints every cell you've ever touched.
2. Fit to one page — Page Layout → Width: 1 page, Height: 1 page.
3. Kill the gridlines — View → uncheck Gridlines, and confirm Page Layout → Sheet Options → Print is unchecked. Add your own borders: one line under the header row, one above the totals.
4. Check margins in Print Preview — narrow margins, centered horizontally.

Then export with File → Save As → PDF. Like every editable format, the client gets the PDF, never the .xlsx — both because it renders identically everywhere and because a spreadsheet invoice is one mis-click from a changed rate. The same rule (and the other reasons behind it) applies to Word invoices.

Reusing the sheet without breaking it

The failure mode of Excel invoicing isn't the first invoice — it's the fifteenth. Rules that keep the system alive:

• Keep a master template sheet and duplicate it per invoice (right-click the tab → Move or Copy → Create a copy). Never edit last month's invoice into this month's — that's how a paid invoice's number gets reused and how yesterday's line items ghost into today's document.
• One workbook per year, one tab per invoice, tabs named by invoice number. This gives you what Word can't: a browsable history in one file.
• Add a tracker sheet — columns for number, client, date, amount, paid date. Excel's genuine advantage over every other template format is that your invoice numbering log and paid/unpaid tracker can live in the same workbook as the invoices.
• Protect the formula cells (Review → Protect Sheet, unlock only the input cells) if anyone else touches the file. The silent formula overwrite — a typed $2,932.50 on top of =B14*C14 — is Excel's most expensive failure because the sheet keeps looking computed.

When Excel is the wrong tool

Excel earns its place when quantities × rates are the invoice. It loses when:

• The invoice is one fixed-fee line. All the formula machinery for 1 × $1,800 is overhead; a simple template or Word layout is faster and looks better.
• Looks matter to the client. However carefully you style it, a spreadsheet invoice reads as a spreadsheet. Design-adjacent freelancers take the reputational hit.
• You're past a handful of invoices a month. The tab-per-invoice system works until the workbook is 40 tabs and "did 2026-019 get paid?" means scrolling. A free invoice generator does the same math, numbers sequentially, remembers your clients, and exports the PDF without a print-area ritual.

FAQ

Does Excel have built-in invoice templates?

Yes — File → New, search "invoice." They come with working formulas but also with dated styling and fields you'll delete. Building the four-column layout above takes fifteen minutes and you'll understand every formula in it, which matters the day one breaks.

How do I make Excel generate invoice numbers automatically?

Don't. Auto-increment tricks (=MAX(range)+1, macros) recalculate when you least expect and renumber old invoices. Type the number manually and log it on a tracker sheet in the same workbook. Sequential-with-a-log beats clever-and-fragile — numbering formats here.

Excel or Word for invoices?

Excel if the math is the invoice (hours, units, mixed rates). Word if it's fixed-fee lines and looks matter more than formulas. Both end as PDFs in the client's inbox.

Does this work the same in Google Sheets?

The formulas, yes — ROUND, SUM, and IF are identical. Printing differs (File → Download → PDF, with its own layout dialog) and sharing has its own trap: send an exported PDF, never a link to the live sheet. The Google-side version of all this is in the Google Docs invoice template guide.

How do I convert an Excel invoice to PDF?

File → Save As (or Export) → PDF — after setting the print area and fit-to-one-page, or the PDF inherits every layout problem. Check the result before sending; the PDF is what the client sees.

Can I track paid and unpaid invoices in the same file?

Yes — that's Excel's best feature as an invoicing tool. Add a tracker sheet with number, client, issue date, due date, amount, and paid date, and you have a receivables list the follow-up process can run from. When updating it stops happening reliably, that's the signal you've outgrown the spreadsheet.