How to Make a Professional Invoice in Excel: A Step-by-Step Template Guide

The short version: open a free Excel invoice template, replace the placeholder details with your business info and a clear invoice number, add your line items with a SUM formula for the total, and save it as a PDF before you send it. The template does the formatting for you. What gets you paid on time has nothing to do with the template and everything to do with what you put on it and how quickly you chase it.

Why Excel is still worth using in 2026

I get asked this a lot: why bother with Excel when there are dozens of invoicing apps that do it automatically? Fair question. Here’s my honest answer after fifteen years of running my own business. If you send fewer than about ten invoices a month, Excel is faster and cheaper than setting up an app account, learning its interface, and paying a monthly fee for something you barely use. Once you’re past that, the maths flips. But for a lot of freelancers, consultants, and small business owners just starting out, a well-built Excel invoice template does the job perfectly well and costs nothing.

I still use Excel for one-off invoices and quotes when a client asks for something bespoke that my usual system can’t spit out fast enough. It’s not old-fashioned. It’s just the right tool for a specific job.

A quick story about why the template matters less than you think

Back when I was rebuilding my business after a run of hard years, I spent an entire afternoon building what I thought was the perfect invoice in Excel. Merged cells, a logo dropped in the corner, a lovely shade of navy for the header. It looked brilliant. Then I sent it to a client and the merged cells shifted the second they opened it on their machine, because their column widths defaulted differently to mine. The invoice number had wrapped onto two lines and looked like a typo. It took me another hour to fix and resend.

The lesson wasn’t “get better at Excel.” It was that I’d spent three hours on formatting and about four minutes deciding when the invoice was due and what happened if it wasn’t paid. That’s backwards. Nobody has ever paid me faster because my invoice looked pretty. They’ve paid me faster because the due date was unmissable and I followed up on day one after it passed.

What makes an invoice look professional

Strip away the design opinions and a professional invoice has the same core ingredients every time:

• Your business name, address, and contact details at the top
• The client’s name and billing address
• A unique invoice number (sequential, not “Invoice 1” every time)
• The invoice date and a clear payment due date
• An itemised list of what you’re charging for, with quantity, rate, and line total
• The subtotal, any VAT or tax, and the final total, clearly bolded
• Your payment details: bank account, sort code, or payment link
• Your payment terms, written out in words, not assumed

That’s it. Eight things. Everything else, the logo colour, the font, the little border around the total, is decoration. Useful decoration, because it signals you run a real business rather than a hobby, but decoration all the same.

Step-by-step: building the invoice in Excel

Here’s exactly how I’d do this if I were starting from scratch today.

1. Open Excel and search the template gallery for “invoice.” Microsoft has around a dozen built-in invoice templates, free, already formatted, and reasonably good looking. Pick a simple one, not the fanciest, because simple templates break less often when a client’s Excel version renders things slightly differently to yours.
2. Replace the placeholder business details. Swap in your name, address, phone number, and email. Add your logo as an image, not a background fill, since backgrounds sometimes don’t print or export to PDF.
3. Set up your invoice numbering system. I use a simple format: year, then a running number, so 2026-014 is the fourteenth invoice I’ve sent this year. This matters more than people realise, especially once your accountant or bookkeeper starts asking for records, or if you ever get VAT registered and need to keep a clean audit trail.
4. Build your line items table. Columns for description, quantity, rate, and total. In the total column, use a simple formula: =quantity cell times rate cell. So if your quantity is in C5 and your rate is in D5, your formula in E5 is =C5*D5.
5. Add a SUM formula for the subtotal. Something like =SUM(E5:E10) to add up every line item automatically. Change one line item and the total updates itself. No mental maths, no mistakes.
6. Add VAT if it applies to you. A simple line: =Subtotal*0.2 for 20% UK VAT, then a final total that adds the subtotal and the VAT line together.
7. Set the due date with a formula instead of typing it manually. If your invoice date is in cell B2 and your terms are 30 days, put =B2+30 in the due date cell. Now every invoice you create from this template calculates its own due date, and you never have to do the maths in your head at 11pm.
8. Save it, then export it as a PDF before sending. Never send the raw Excel file. Clients can accidentally edit it, formulas can break on their end, and it just looks less finished. In Excel, File, then Export, then Create PDF/XPS. Takes ten seconds.

If you’d rather start from a template built for this exact purpose, I’ve written a full breakdown of the best free option in the best free Excel template for price quotations, which works just as well as a starting point for invoices since the layout is nearly identical, you’re just swapping “quote” for “invoice” in the header.

The formula that chases payment for you

Here’s the part most Excel invoice guides skip entirely: conditional formatting. It sounds technical but it’s one of the most useful things you can add.

Select your due date column, go to Home, then Conditional Formatting, then New Rule. Set it to highlight the cell red if the due date is in the past and the invoice hasn’t been marked paid. Practically, this means every time you open your invoice tracker, overdue invoices jump out at you in red instead of quietly hiding in a spreadsheet you haven’t scrolled through in three weeks. I run a separate tracking sheet alongside my invoice template for exactly this reason, one tab per client, one column that flags anything overdue.

This one small addition has probably recovered more late payments for me than any amount of invoice design ever has.

The uncomfortable bit nobody wants to say out loud

Here’s my honest opinion after doing this for a long time: spending hours perfecting your Excel invoice template is, for a lot of people, a very sophisticated form of procrastination. It feels productive. You’re doing something. But it delays the uncomfortable task, which is sending the invoice on time, chasing it the day it’s overdue, and having the slightly awkward conversation with a client who’s three weeks late without pretending it’s fine.

I’ve watched clients spend an entire Sunday redesigning their invoice header while a £3,000 invoice sat unpaid for six weeks because nobody wanted to send the “just checking in” email. The template was gorgeous. The bank balance didn’t care.

If you take one thing from this post, take this: build a decent template once, in under an hour, and then spend your energy on the follow-up process instead. That’s where the money gets collected.

When Excel stops being enough

There’s a point where Excel invoicing becomes a liability rather than a convenience. In my experience that point is roughly when you’re sending more than fifteen or twenty invoices a month, or when you’re VAT registered under the UK’s Making Tax Digital rules, which currently require digital record-keeping and digital VAT returns once your taxable turnover passes £90,000. At that stage, a manually built Excel sheet becomes a compliance risk, not just an admin headache, because HMRC wants a proper digital trail, and copying numbers between spreadsheets by hand is exactly where mistakes creep in.

It’s also the point where it’s worth handing invoicing over to someone else entirely. A part-time virtual assistant can manage your invoice numbering, chase overdue payments, and update your tracker for a few pounds an hour, and I’ve written a full guide to what that costs and how to find one in virtual assistant jobs: the complete beginner’s guide, which covers the client side of hiring one as well as the job-seeker side.

If you’re curious about which tools replace Excel invoicing once you outgrow it, most of them plug into the same tool stack that’s already running your business, I go through the realistic options in the AI tool stack for business owners in 2026.

A quick checklist before you hit send

• Invoice number is unique and follows your numbering system
• Client name and address are spelled correctly, this sounds obvious and it’s the single most common reason invoices bounce back with “can you resend this”
• Due date is calculated, not guessed
• Payment terms are written in plain words, not just implied
• Total is bolded and impossible to miss
• Bank details or payment link are current, especially if you’ve switched accounts recently
• Saved and sent as a PDF, not the editable Excel file

Seven checks, thirty seconds, and it catches almost every mistake that leads to a delayed payment.

Frequently asked questions

Is Excel good enough for a professional invoice, or do I need proper invoicing software?

Excel is good enough for most small businesses and freelancers sending under ten to fifteen invoices a month. It only becomes a problem once you’re VAT registered under Making Tax Digital rules, sending high volumes, or juggling recurring subscriptions, where dedicated software starts saving real time.

What should I name my Excel invoice file before sending it to a client?

Use a clear, searchable format like “YourBusinessName_Invoice_2026-014.pdf” rather than “Invoice.pdf.” Clients often forward invoices to accounts departments, and a vague filename gets lost or ignored far more often than a specific one.

How do I add VAT to my Excel invoice template correctly?

Add a subtotal row, then a separate VAT row calculated as subtotal multiplied by your VAT rate (0.2 for 20% in the UK), then a final total row that adds the two together. Keep VAT as its own visible line rather than folding it into the total, since clients and accountants both need to see it broken out.

Why do my clients pay other people faster than they pay me, even with the same invoice terms?

It’s rarely the invoice itself. It’s usually the follow-up. Businesses that chase overdue invoices within a day or two of the due date consistently get paid faster than those who wait weeks to send a reminder, regardless of how the invoice looks.

Primary sources

• Microsoft’s own Excel documentation

Related reading: What Makes a Good Excel Checklist Template for Daily Tasks and How Do You Create An Invoice Template That Gets You Paid Faster.

If you would rather pitch your own version, you can write for us about finance.