A sloppy invoice costs you money. Clients read it as a signal of how you’ll handle their project — and a manual total that’s wrong by $40 costs you an embarrassing “corrected invoice” email and a week of payment delay.
Here’s how to build a clean, calculating invoice in Excel or Google Sheets from scratch, in about ten minutes.
The anatomy of a good invoice
Before the formulas, the layout. Every professional invoice has eight blocks:
- Your business block — name, logo, address, contact.
- Invoice number and dates — issue date, due date.
- Client block — who’s being billed (name, company, address, VAT/Tax ID if applicable).
- Line items — description, quantity, unit price, amount.
- Subtotal, discount, tax, total — calculated, never typed.
- Payment details — bank transfer or card instructions.
- Terms — when payment is due, late-fee policy.
- A thank-you line — yes, it measurably speeds up payment.
Step 1 — Set up the grid
Open a blank sheet. Use columns B through F:
| B | C | D | E | F |
|---|---|---|---|---|
| Item | Description | Qty | Unit price | Amount |
In the top-left, type your business name (big and bold). Top-right, type “INVOICE” — even bigger. Under it, three label/value pairs: Invoice #, Issue date, Due date.
Step 2 — The line items table
Start at row 14 (leaves breathing room above). Add a header row with the five column names, bold, with a fill color. Below it, 8–10 empty rows for items.
In the Amount column (F15), the only formula you need:
=IFERROR(D15*E15,0)Quantity times unit price. IFERROR keeps the sheet clean while rows are empty.
Copy this down every item row.
Step 3 — Totals that calculate themselves
Below the last item row, add four rows. If your items end at row 22:
- Subtotal (row 24):
=SUM(F15:F22) - Discount (row 25): a plain number you type — enter it as a positive value
- Tax rate (row 26): enter
0.08for 8% (format as percent) - Tax (row 27):
=(F24-F25)*F26 - TOTAL DUE (row 28):
=F24-F25+F27
Two details that matter:
- Discount before tax.
(Subtotal − Discount) × Rateis how EU invoicing works. Taxing the pre-discount amount is a compliance problem, not a rounding quirk. - Make the total row unmissable. Bold, larger font, filled background. It’s the number your client’s accountant looks for first.
Step 4 — Payment details and terms
Two text blocks at the bottom:
- NOTES: “Thank you for your business! Payment by bank transfer or card. Late payments may incur a 2% monthly fee.”
- PAYMENT DETAILS: “Bank: [name] · Account: [IBAN] · SWIFT: [code]”
Invoices with explicit bank details get paid measurably faster than ones that just say “payable on receipt” — the client doesn’t have to email you for the account number.
Step 5 — Make it print-ready and PDF-friendly
This is where most homemade invoices fall apart: they look great on screen and terrible on paper.
- Page Layout → Print Area — select your invoice area so nothing extra prints.
- Page Setup → Fit to 1 page wide (and 1 page tall for a one-pager).
- Margins → Narrow — gives the layout room to breathe.
- Hide gridlines (View → Gridlines off) for a clean document look.
To send it: File → Download → PDF (Google Sheets) or File → Export → PDF (Excel). The PDF preserves your fonts exactly — no “your invoice looks different on my computer”.
Step 6 — Track who has paid (the part everyone forgets)
An invoice you can’t track is just a PDF. Keep a second sheet:
| Invoice # | Client | Amount | Paid | Balance | Status |
|---|
- Balance:
=C2-D2 - Status:
=IF(E2<=0,"Paid",IF(F2<TODAY(),"Overdue","Pending"))(where F2 is the due date)
Conditional formatting on the status column — green Paid, amber Pending, red Overdue — turns this into a one-glance “who owes me money” board. Add partial payments by typing the amount received into the Paid column; the balance handles the rest.
Skip the build
Everything above — five print-ready layouts, the discount-before-tax math, the client database, the payment tracker with automatic status — ships pre-built in our Small Business Invoice Kit. Duplicate a design tab per invoice, fill in your details, export the PDF. Ten minutes of setup instead of an afternoon of cell formatting.
Your invoice is the last thing a client sees before paying. Make the total impossible to miss and the payment impossible to delay.
Related reading: