Make an Excel Invoice Look Professional

An invoice is the only spreadsheet you send that someone reads with their card, or their accounts payable queue, already in mind.

A professional Excel invoice is five blocks in a fixed order: an identity block naming both parties, a dated reference block with a unique invoice number, a line-item table with right-aligned money columns at two decimals, a totals stack sitting directly under the last money column so the eye falls into it, and a payment block that states the due date and exactly how to pay. Money cells use #,##0.00 for line items and a currency or accounting format for the totals so the decimal points line up. Then you export to PDF rather than sending the .xlsx, because a PDF cannot reflow, cannot be edited, and cannot open on someone else's default font. Everything that makes an invoice look amateur is one of those five blocks being incomplete, or the total being somewhere the reader has to hunt for.

Nearly everything written about invoicing in Excel hands you a file. Download a template, fill the yellow cells, done. That works right up to the first time a client's bookkeeper asks which purchase order this relates to, or your tax line lands in the wrong place, or the layout collapses when you add a sixth line item. Then you are editing someone else's design decisions without knowing what any of them were for.

So this is the other version. Not a template, the decisions inside one. Every choice below has a reason attached, and the reason is almost always the same: an invoice is read by a person deciding whether to pay it, and every second they spend confused is a second closer to it sitting in a pile.

What does the person paying look for first?

Three things, in this order: how much, by when, and is this even ours.

That third one surprises people. If you invoice a company of any size, your file does not go to the person you talked to. It goes to a shared inbox, and someone who has never heard of you opens it alongside forty others. Their first job is not paying you, it is working out which cost centre this belongs to and whether it was approved. If they cannot answer that from the top third of the page, your invoice gets set aside for the person who can, and that is where invoices go to age.

So the visual hierarchy is fixed by the reader, not by taste. Amount due needs to be the largest number on the page. The due date needs to be near it, written as an actual date rather than "Net 30", because "Net 30" makes the reader do arithmetic and they will do it wrong or not at all. And the identifying details, your name, their name, the invoice number, the purchase order or project reference, need to be findable in one glance rather than scattered.

The UK government's guidance on what an invoice must include is a useful floor even if you invoice elsewhere, because it is a short list written by people who care only about whether the document works: a unique identification number, your business name and address, the customer's name and address, a clear description of what you are charging for, the supply date, the invoice date, the amounts, any tax, and the total owed. Sole traders are told to add their own name and an address where legal documents can be served. Nothing on that list is decorative.

The IRS takes the same practical view from the other side of the transaction. Its guidance on what records a business should keep describes supporting documents as needing to show who was paid, the amount, the date, and a description of the item or service. Your client's accountant is holding your invoice up against that list. Make it easy and you get paid faster than the person whose invoice is a paragraph of prose.

The five-block spec

Here is the whole layout. Build it top down in a single tab. Column widths matter more than any colour choice you will make, so the widths are in here too.

Block	Where it sits	Required fields	Formatting rules
1. Identity	Rows 1 to 6, columns A to C for you, columns E to G for them	Your business name in A1 at 16 to 18pt. Your address, email and phone under it, 9 to 10pt. Their legal entity name in E1, their address under it, and the name of your contact if you have one. A logo, if you use one, sits top right or top left and nowhere else.	Left aligned throughout. Your block and their block are the same font size below the business name, so neither looks like the header of the other. No borders.
2. Reference	Rows 1 to 6, columns H to J, hard right	The word Invoice, large. Invoice number. Invoice date. Supply or service period. Due date. Purchase order or project reference if the client uses one.	Two columns: a label column right aligned, a value column right aligned, sitting flush to the right edge of the page. Dates as dd mmm yyyy or yyyy-mm-dd, never dd/mm/yy. The due date is bold.
3. Line items	Row 9 down, one header row, one table, no blank rows inside it	Description. Quantity. Unit. Unit price. Line total. A tax column only if lines are taxed differently from each other.	Header row bold with a single fill or a single bottom rule, not both. Description left aligned. Every numeric column right aligned. Unit price and line total at #,##0.00. No borders on every cell, one hairline rule under the header and one above the totals.
4. Totals	Directly under the line-item table, in the same columns as the money	Subtotal. Discount, if any. Tax, with the rate named. Anything else added, named. Amount due. Previously paid or credit applied, if relevant.	Labels right aligned in the column immediately left of the numbers. Numbers in the same column as the line totals so decimals stack. Subtotal and tax at #,##0.00, amount due in a currency format at 12 to 14pt bold with a rule above it.
5. Payment and terms	Two rows under the totals, spanning columns A to E	How to pay: bank name, account details or a payment link. Payment terms in words. Late fee policy if you have one. Tax registration number if you have one. A thank-you line if you want one.	9 to 10pt, left aligned, grey rather than black. Account numbers formatted as text so leading zeros survive. Nothing here is bold except the payment method heading.

Two things that table quietly enforces. The line-item table is a real table with one header row and no gaps, which means it can be sorted, filtered, summed and pasted into an accounting system without anyone re-typing it. And the reference block is hard right, opposite your identity block, which is the layout every accounts payable clerk has seen ten thousand times. Familiar is not boring here. Familiar is fast.

Where should the total sit on the page?

Bottom right, under the money column, with white space above it and nothing to its right.

The reason is mechanical. Numbers in a column are read down, and the eye follows the decimal points. If your amount due sits under the line totals, the reader's eye is already travelling toward it before they know they are looking for it. Move the total to the left, centre it, or float it in a box beside the line items, and you break that travel: the reader has to stop scanning, re-find the number, and re-establish which column it belongs to.

The second reason is that the bottom right of a page is where the eye rests. Everything above it has been scanned. Give the total the largest type on the page, a rule above it, and at least one blank row of clearance, and it reads as the conclusion of the document rather than one more figure in a list.

Three variations that do work:

A repeated headline amount at the top right. Some invoices put the amount due once in the reference block and again in the totals stack. This is genuinely useful for email previews and phone screens where only the top of the file is visible. Do it only if you can guarantee both cells reference the same calculation, so put = and the totals cell in the top one rather than typing the number twice.

A due date beside the total rather than above it. Amount and deadline are one thought. Putting them on the same line, "Amount due 14 Oct 2026", costs nothing and answers both of the reader's first two questions in one glance.

A single accent colour on the total row only. One fill, one row, and it must be the only fill on the page other than the header row. Two accent colours on an invoice look like a template that was edited by three people.

What does not work is a total in a merged block. Merging cells to centre a total is the single most common way a clean-looking invoice breaks the moment someone tries to copy the line items out of it. If you want the total to span visually, use Center Across Selection rather than Merge and Center. There is more on why in the merged cells guide.

Which number formats belong on line items versus totals?

Line items get a plain thousands format with two decimals. Totals get a currency or accounting format that carries the symbol. That split is deliberate and it is what separates an invoice that looks designed from one that looks typed.

Repeating the currency symbol on every line is visual noise. Twelve dollar signs down a column force the eye past the same character twelve times to reach the digits that actually differ. Put the symbol in the column header instead, as Unit price (USD), and let the money cells carry only numbers. Then bring the symbol back for the totals, where it marks the transition from detail to conclusion.

Here are the codes. Paste them into Format Cells, Number, Custom.

Cell	Format code	What it produces	Why
Quantity, whole units	#,##0	4	No trailing decimals on things you cannot have half of.
Quantity, hours or partial units	#,##0.00	7.50	Two decimals throughout so the column stays aligned.
Unit price	#,##0.00	1,250.00	Symbol lives in the header, not the cell.
Line total	#,##0.00	5,000.00	Same code as unit price so the two columns align on the decimal.
Subtotal	#,##0.00	12,480.00	Still detail, still no symbol.
Tax rate	0.0%	8.5%	One decimal covers almost every real rate.
Tax amount	#,##0.00	1,060.80	Matches the subtotal above it.
Discount	-#,##0.00;-#,##0.00	-500.00	Shown as a negative so the arithmetic reads down the column.
Amount due	$#,##0.00 or the built-in Accounting format	$13,540.80	The symbol returns exactly once, on the number that matters.
Bank account or reference number	Format Cells, Number, Text	00451782	Stops Excel eating leading zeros and stops long numbers turning into scientific notation.
Invoice number, if generated from a counter	"INV-"0000	INV-0042	Honest caveat: the underlying value is still 42, so anything that copies the value rather than the display gets 42. Type the full string as text if the number leaves the file.

The semicolons, the section order and the reasoning behind accounting alignment are all covered properly in the Excel number formatting guide. Microsoft's own reference on customizing a number format is worth a read before you invent a code of your own, particularly the note that custom formats are saved with the workbook and that your regional settings decide which currency symbol Excel offers by default. That last detail catches people who build an invoice on one machine and open it on another.

One rule that applies to every money column and gets broken constantly: the number of decimal places must be identical down the whole column. A column reading 1,250.00, 340, 99.5 is not a rounding preference, it is three different formats applied to three cells, and it is the fastest visual tell that a file was assembled by hand.

How should tax, discounts and currency be shown?

Each on its own row in the totals stack, named, with the rate visible.

Tax rules vary by country, by state, by product category and by who your customer is, and none of that is a formatting question. What is a formatting question is whether the reader can reconstruct your arithmetic. Show the subtotal, then the tax as its own line with the rate written in the label, Sales tax (8.5%), then the total. Never fold tax into the line-item prices with a note underneath saying the prices include tax, unless your jurisdiction requires tax-inclusive display, in which case say so on the same line rather than in a footnote.

Discounts follow the same rule and gain one. Show the discount as a negative number in the same column as everything else, so the column adds up visually. And name what the discount is for: Early payment discount, Agreed rate adjustment, Goodwill credit. An unnamed discount line invites a phone call, and if your client's finance team cannot categorise it, they will ask.

Currency is where invoices to overseas clients go wrong. Three things fix it:

Put the three-letter code somewhere unmissable. $ is at least six different currencies. Total due (USD) in the label, or 13,540.80 USD in the cell using the format #,##0.00" USD", removes an entire category of email.

Do not convert on the invoice unless you are the one bearing the risk. If you bill in your currency and they pay in theirs, the conversion happens at their bank on the day they pay, at a rate neither of you controls. Putting an approximate converted figure on the invoice creates a number that will be wrong by the time it is paid, and a reader who thinks it is the amount to send.

State who covers transfer fees. One line in the payment block. It is not glamorous and it settles roughly half of all international invoice disputes before they start.

Which fields prevent follow-up emails?

The ones that answer a question the reader would otherwise have to ask you. Five of them do most of the work.

A purchase order or project reference. If your client raises POs, an invoice without one is not an invoice yet, it is a document that will be returned. Ask for the number before you start work, not after you send the bill.

A named contact at their end. Not "Accounts Payable". The person who approved the spend, because the accounts team's first act is to forward it to them for sign-off. Naming them skips a step and a day.

An explicit due date. A real date, calculated from your terms, sitting next to the total. "Payment terms: 30 days" is a rule; "Due 10 October 2026" is an instruction.

A supply or service period. The dates the work covers, distinct from the invoice date. This is what lets a client match your invoice against their own records, and it is the field most often missing from invoices built out of a template's yellow cells.

Complete payment details in one block. Bank name, account name, account number, sort code or routing number, IBAN and SWIFT if the payment crosses a border, or the payment link if you take cards. Split across two places on the page, and someone will use half of them.

There is one more that is not a field but behaves like one: a notes row under the line items, left blank unless a line genuinely needs explaining. Blank is the signal there. If every row carries a note, nobody reads any of them. The same discipline runs through the client report layout, where a notes column earns its space the same way.

How do you export it so nothing shifts?

Set the page up first, then export. The page setup is what decides how the PDF looks, and it is set inside Excel before any export route runs.

The order that avoids redoing work:

1. Set a print area covering exactly the invoice, so stray cells and old drafts to the right of it never appear.
2. Set scaling to fit one page wide. An invoice that spills onto a second page horizontally is the fastest way to lose the totals block.
3. Check the page break preview and confirm the totals stack is not sitting alone on page two.
4. Set margins deliberately, normally 0.5 to 0.75 inch, so the reference block does not touch the paper edge.
5. Turn gridlines off for printing. An invoice with gridlines looks like a spreadsheet; an invoice without them looks like a document.

Then export. On Windows desktop it is File, then Save As, with PDF (*.pdf) chosen from the file type list, or File, then Export, then Create PDF/XPS. In that dialog the Options button lets you publish the selection, the active sheets, the entire workbook, or just the print area, and Standard versus Minimum size controls print quality against file weight. Microsoft's page on saving or converting to PDF covers both routes. On Mac it is File, then Save As, with PDF chosen from the Format menu. In Excel for the web the route runs through File and Print, and the resulting PDF lands in your downloads folder without asking you where to put it or what to call it, so rename it before you attach it.

If the PDF still comes out looking different from the screen, the cause is almost always page setup rather than the export, and the full diagnosis is here.

Send the PDF, not the .xlsx. Three reasons, all practical: an .xlsx renders differently on a machine that does not have your fonts, an .xlsx can be edited by the recipient whether or not they mean to, and an .xlsx opens showing row and column headers, which makes a bill look like a work in progress. Keep the .xlsx as your working copy and your record.

Frequently asked questions

Should I send invoices as Excel or PDF?

PDF, in almost every case. A PDF preserves fonts, spacing, colours and page breaks on any machine, cannot be casually altered, and does not display gridlines or sheet tabs. Send the .xlsx only if the client has specifically asked for it, usually because their system imports line items automatically. If you do send both, name them identically apart from the extension so nobody has to work out whether they match.

How do I show tax on an Excel invoice?

As its own row in the totals stack, between the subtotal and the amount due, with the rate written into the label so the arithmetic is checkable. Calculate it with a formula referencing the subtotal cell rather than typing the figure, and format the amount with the same code as the subtotal above it so the decimals align. If different line items carry different rates, add a tax column to the line-item table and total that column instead of applying a single rate at the bottom. Which rate applies to your work is a question for your jurisdiction, not for your spreadsheet.

What should an invoice number look like?

Unique, sequential, and readable out loud over the phone. A short prefix plus a zero-padded counter, INV-0042, works for most people. Adding the year, 2026-0042, helps once you have a few years of records. Two things to avoid: restarting the counter each month, which produces duplicate numbers across years, and embedding the client name, which turns your invoice number into a leak if two clients ever compare notes. If you generate the number from a counter cell using a custom format, remember the underlying value is still a plain number, so type it as text in any file that leaves your machine.

How do I stop the invoice reflowing when I add a line?

Build the line items as a real contiguous table with no blank rows inside it, and make every total a formula over a range rather than a list of individual cells. Then insert new rows inside the range, not below it: click on an existing line-item row and insert above it, and both your formats and your SUM range extend automatically. Totals written as =B10+B11+B12 break the moment you insert a row; =SUM(B10:B14) does not. Keep the payment block anchored below the totals rather than in a floating text box, so it moves down with everything else instead of landing on top of your new line.

Does a spreadsheet formatting tool help with an invoice?

Partly, and it is worth being straight about where the line falls. An invoice tab is not one clean table, it is a canvas with several blocks on it, and SuperSheet deliberately does not restructure a tab like that, because guessing where one block ends and another begins produces a worse file than the one you started with. What it does handle well is the part that carries the numbers: paste your line items in as their own sheet, get real number formats, aligned decimals, a header row and a totals row back, then drop the formatted table into your invoice canvas. The same applies to the billing log the invoice is drawn from, which is usually the messier file of the two.

Build the canvas once and it lasts for years. The line items and totals are the part you redo every month, so run those through the Excel formatter and let it apply the number formats, the alignment and the totals row in one pass. Nothing is uploaded, the original file on your machine is untouched, and you download a formatted copy to paste into the invoice you already built.