How to Make an Invoice in Excel

A step-by-step guide to building an invoice in Microsoft Excel — including the exact formulas that add everything up for you — plus a faster way if you'd rather not wrangle a spreadsheet.

Excel is a solid choice for invoicing because it can do the math for you: enter quantities and rates once and the totals calculate automatically. The trick is setting up the formulas correctly. Here's how to build a clean, reliable invoice in Excel from scratch, the formulas to use, and how to export a professional PDF.

Set up the invoice layout

Before typing formulas, block out the page so it reads like a real invoice. From top to bottom you want:

• Your business name or your name and contact details at the top (add a logo if you have one)
• The word "INVOICE" and a unique invoice number
• The issue date and due date
• A "Bill to" block with your client's name and details
• A line-items table: Description, Quantity, Rate, Amount
• A totals area: subtotal, tax (if any), and total due
• Payment terms and methods at the bottom

Build an Excel invoice step by step

1. Open a blank workbook and widen column A (this becomes your Description column). Leave a couple of empty rows at the top for the header.
2. Add your header. In the top rows, type your business name, then your address, email, and phone in the cells below. Make the name bold and larger (16–18pt).
3. Add invoice details. A few rows down on the right, label cells Invoice #, Date, and Due date with their values beside them.
4. Add the "Bill to" block on the left with your client's name and contact details.
5. Create the table header. In one row, type the column titles: Description, Qty, Rate, Amount. Bold them and add a fill color.
6. Enter your line items under Description, Qty, and Rate. Leave the Amount column for a formula (next section).
7. Add the totals rows below the table: Subtotal, Tax, and Total due.
8. Format the money cells as currency (select them, press Ctrl+1 → Currency) and add borders around the table (Home → Borders → All Borders).
9. Save it as a template so next month you just change the numbers, then export to PDF to send.

The formulas that do the math

This is where Excel earns its keep. Assuming your first line item is in row 2 and the columns are B = Qty, C = Rate, D = Amount:

• Line amount (in D2, then copy down): =B2*C2 — multiplies quantity by rate.
• Subtotal (below the last line, say D11): =SUM(D2:D10) — adds every line amount.
• Tax (D12), e.g. for 10%: =D11*0.1 — or point it at a cell holding your rate, like =D11*E1.
• Total due (D13): =D11+D12 — subtotal plus tax.
• Optional discount or deposit: add a row and subtract it, e.g. =D11+D12-D14.

A worked example

Here's what the finished numbers look like for a small web project:

Every figure in that Amount column and the totals is a formula — change a quantity or rate and they update instantly. For a full breakdown of every field an invoice should contain, see how to write an invoice.

Save and send as PDF

Never send the raw .xlsx file — the client could see your formulas, edit the numbers, or open it in a program that breaks the layout. Export a PDF instead:

• Windows: File → Save As → choose PDF from the file-type dropdown. Or File → Export → Create PDF/XPS.
• Mac: File → Save As → Format: PDF, or File → Print → PDF → Save as PDF.
• Before exporting, check Page Layout → Print Area and the print preview so the invoice fits neatly on one page.

Where Excel invoicing falls short

Excel is capable, but it wasn't built for invoicing, and a few things stay manual:

• Invoice numbers don't auto-increment — you have to remember to change them each time.
• One broken formula = a wrong total. Insert a row in the wrong place and your SUM range can silently miss a line.
• Formatting drifts — columns, borders, and print areas need re-checking so the PDF looks right.
• No record of who owes what — you're managing files and folders by hand.

If you invoice regularly, a purpose-built generator removes those failure points: it does the math, formats the page, and exports a clean PDF every time.

FAQ