How to make an invoice in Excel (with a faster way)

Step 1: Set up the header and client block

Open a blank sheet. The top third of the page is all identity: who's billing, who's being billed, and the three dates and numbers that make the invoice official. Get this part right and the rest is just typing.

Start in the top-left. Merge a few cells across the top (highlight them, then Merge and Center) to make room for your business name in a large, bold font. Underneath it, in smaller text, put your address, phone number, and email, one per line. If you have a logo, use Insert then Picture and drop it into the top-right corner so it sits opposite your name. If you have a tax ID (an ABN in Australia, an EIN in the United States, a GST/HST number in Canada, a VAT number in the UK), add a line for it here too.

Drop down a few rows and build the client block on the left side:

• Bill To. The legal name of the business you're invoicing, not a contact person or a trading name. Add their full address underneath. That address is what gets your invoice through the other side's accounts payable.
• Attention. Optional, but useful. The name of the person expecting the invoice, so it lands on the right desk.

On the right side, opposite the client block, put three labelled cells. Label in one column, value in the next:

• Invoice number. A unique number that never repeats. More on this in Step 4.
• Invoice date. The day you're sending it, not the day the work happened.
• Due date. The invoice date plus your terms. For Net 30, that's the invoice date plus 30 days. You can even let the sheet do it: if your invoice date is in cell G2, put =G2+30 in the due date cell and it updates itself.

Two minutes on this block saves you three rounds of email later asking the client for a missing address or PO number. Set it up once, then save the file as a template you copy for every future invoice.

Step 2: Build the line-item table with real formulas

This is the part a spreadsheet is genuinely good at: the math. Build the table once with formulas and it totals itself every time you change a number.

Set up four column headers in a row, say row 12. Column A: Description. Column B: Quantity. Column C: Rate. Column D: Line total. Bold that header row and give it a background colour so it reads as the top of a table.

Now the first formula. In the line-total cell on the first item row (D13), the amount is quantity times rate:

• =B13*C13

Grab the little square at the bottom-right corner of that cell and drag it down as many rows as you need. Excel fills in =B14*C14, =B15*C15, and so on automatically. Now type your line items in plain language, one per distinct thing you're billing for:

• Description: "Website redesign, fixed fee". Quantity: 1. Rate: 4500. The line total cell shows 4500.
• Description: "Consulting (per hour)". Quantity: 12. Rate: 150. The line total cell shows 1800.

Under the last item row, build the totals stack in the line-total column. Say your items run from row 13 to row 22. The subtotal adds them all up:

• Subtotal: =SUM(D13:D22)

The tax row multiplies the subtotal by your rate. If the subtotal is in D23 and you charge 10% tax:

• Tax (10%): =D23*0.1

And the grand total adds the subtotal and the tax together. With tax in D24:

• Total due: =D23+D24

If you've already taken a deposit, add one more row under the total: Less deposit paid as a positive number in D26, then a final Balance due cell of =D25-D26 so the client sees exactly what's left to pay. Format every money cell as currency (highlight them, then Format Cells, then Currency) so the sheet shows $4,500.00 instead of 4500.

Change any quantity or rate now and watch the whole stack recalculate. That's the payoff for setting the formulas up once.

Step 3: Format it and save as a PDF

A working invoice and a professional-looking invoice are two different things, and the gap is about five minutes of formatting. Do this once on your template and every future invoice inherits it.

• Pick one font and two sizes. A large bold size for your business name and the word "Invoice", a normal size for everything else. Mixing three fonts makes it look like a ransom note.
• Add borders to the line-item table only. Highlight the table, then apply "All Borders". Leave the header and client blocks border-free so they don't fight the table for attention.
• Right-align the money columns. Numbers line up on the decimal point and are far easier to scan.
• Turn off the gridlines. On the View tab, untick Gridlines. Without them the page looks like a document instead of a spreadsheet.
• Set the print area. Highlight everything from your business name down to the total, then Page Layout, Print Area, Set Print Area. This stops half-empty extra columns from spilling onto a second page.

Now the single most important step: save it as a PDF, and send the PDF, never the spreadsheet. In Excel it's File, then Export, then Create PDF/XPS. In Google Sheets it's File, then Download, then PDF Document. There are three good reasons the raw .xlsx or Google Sheets link should never leave your computer:

• The layout stays put. A spreadsheet reflows depending on the reader's screen, their column widths, and their version of Excel. A PDF looks identical everywhere.
• Nobody can change your numbers. An editable spreadsheet invites a client to "adjust" a quantity or a rate. A PDF is final.
• Your formulas stay hidden. Send the live file and the client can click any total and see the formula behind it, along with any other tab or note you left in the workbook. A PDF shows only the finished page.

Name the file something the client can find later, like Invoice-2026-0042-YourBusiness.pdf, and that's the file you attach to the email.

Step 4: Number your invoices properly

Every invoice needs its own number, and no two invoices should ever share one. This isn't red tape. The number is how you, your client, and both of your tax filings refer to a specific bill months later. "Did you pay invoice 2026-0042?" is a clear question. "Did you pay that invoice from March?" is not.

The simplest scheme is plain sequential: 0001, 0002, 0003. Many people prefix the year so the count resets cleanly each January and you can see at a glance when an invoice was raised: 2026-0001, 2026-0002. Whatever you pick, follow two rules:

• Never reuse a number, even for a client who cancelled or an invoice you voided. Skip it and move on. Gaps are fine. Duplicates are the thing that makes your records unclear at tax time.
• Keep a master list of every number you've used so you always know the next one. In a spreadsheet workflow this usually means a separate tab, which is exactly the kind of manual tracking that starts to slip once the volume climbs.

Pick a format on your very first invoice and stick with it, because changing schemes midway is where numbering gets messy. For the full set of options, including per-client and date-based formats, see invoice numbering best practices.

Common spreadsheet invoice mistakes

A spreadsheet gives you all the rope you need. These are the four ways invoices go wrong in Excel, and how to head each one off.

• Overwriting last month's invoice. The most common one by far. You open last month's file, change the client and the amounts, and save. Now last month's invoice is gone, and if that client ever queries what you billed, you have nothing to show them. Always start from a blank copy of your template and Save As a new, uniquely named file. One invoice, one file, forever.
• Broken formulas. Insert a row in the wrong place, or paste over a cell, and your =SUM() range quietly stops including a line. The total still shows a number, so nothing looks off, but it's undercounting. Before you export the PDF, glance at the subtotal and sanity-check it against the line items by hand. Locking the formula cells (Format Cells, Protection, then protect the sheet) stops you from typing over them by accident.
• No backup. If your invoices live in one folder on one laptop, they're one spilled coffee away from being gone, and with them your record of who owes you what. Keep the folder in something that syncs to the cloud, or copy it somewhere safe on a schedule you'll actually keep.
• No record of what's paid. This is the big one, and it's the reason the next section exists. The invoice file tells you what you billed. It says nothing about whether the money arrived. Unless you keep a separate master list and update the status every time a payment lands, you're relying on memory to know who still owes you, and memory is where invoices go to be forgotten.

Every one of these is avoidable with discipline. The catch is that the discipline is entirely on you, every single invoice, and it's the paid or unpaid tracking that gets skipped first when you're busy.

When a spreadsheet stops keeping up

Here's the honest turn. A spreadsheet invoice is genuinely fine if you send one or two a month. You can hold "the Henderson job is still unpaid" in your head when there's only one of them. The tool does the math, you send the PDF, and it works.

The wall you hit isn't making the invoices. It's tracking them. Once you're sending five or ten a month, the question that matters stops being "can I make an invoice?" and becomes "who hasn't paid me yet?" A spreadsheet has no answer to that unless you build and maintain a whole separate tracking sheet by hand, marking each one paid the day the money lands, sorting by due date, and never forgetting a single update. Miss a few updates during a busy week and you've lost the one thing the system was supposed to give you: a reliable picture of what you're owed.

That's the point where a proper invoicing tool earns its keep, and it's worth knowing exactly what you get for switching. If you'd rather skip the formula-building entirely even for a one-off, the free invoice generator on this site fills in the same fields and hands you a clean PDF, no spreadsheet required.

For the tracking side, Argo Books is a desktop app that does the part the spreadsheet can't. It keeps every invoice with a live status badge (Draft, Sent, Viewed, Partial, Paid, Overdue), so "who hasn't paid me?" is a glance, not a memory test. It handles the things that get fiddly in a spreadsheet:

• Payment tracking. Mark an invoice paid, or record a partial payment, and the outstanding balance updates itself. An Outstanding Invoices figure shows exactly what you're still owed across every client.
• Deposits. Take a deposit up front, and the balance due reflects it automatically, no manual "less deposit" row to maintain.
• Payment links. Send an invoice with an online payment link so the client can pay it directly, and it marks itself paid when they do.
• Paid and unpaid at a glance. Statuses run all the way through to Overdue, so an invoice that's slipped past its due date flags itself instead of waiting for you to notice.

The app runs on your own computer, your data stays local, and there's a free tier that covers up to 25 invoices. Premium is $15/month if you outgrow it. The way to think about it: a spreadsheet is a fine place to make an invoice, but a poor place to keep track of one. Once the tracking is what's costing you time, that's the signal to switch.