What an Invoice Actually Needs on It
Okay. New module.
We spent the last chunk of this course inside the inventory tracker, getting your product list built, your counts tracking, your lookups pulling prices, your colors doing something useful. That sheet lives in the background. It's the engine.
This module is different. We're building the thing your customer actually sees: the invoice. One page. Something you can send or hand over that says clearly, here's what you got, here's what you owe, here's where to send the money.
Sooo let's talk about what actually has to be on it. Not what looks impressive. What's actually required for this piece of paper (or PDF, or email) to do its job.
The non-negotiables
Every invoice, no matter how simple your business is, needs these things:
- Your business name and contact info. Even if it's just you. Even if "your business" is you fixing bikes out of your garage. People need to know who to pay and how to reach you if something's wrong.
- An invoice number. Doesn't need to be fancy. 001, 002, 003 is fine. This matters more than you think, because the day someone says "I already paid that one" you need a way to know which one they mean.
- The date. Both the invoice date and, if it's different, the date the work happened.
- Who it's for. Customer name, at minimum. Their contact info if you're going to need to follow up.
- What they're being charged for. Item or service, quantity, price per unit, and the line total. This is the part people want to get clever with and you really don't need to. A row per item, a column for quantity, a column for price, a column that multiplies them. That's it.
- The total. Obviously. But make sure it's actually adding up your line items and not something you typed in by hand, because typed-in numbers don't update when you fix something above them.
- Payment terms. Due on receipt, due in 15 days, whatever you actually mean. If you don't say it, people will assume whatever's convenient for them.
That's the whole list. Seven things. Everything else is decoration.
What you don't need
You do not need a logo before you have a working invoice. You do not need three fonts. You do not need a background color on every cell. I know it's tempting, I know it feels like it makes you look legit, but here's my honest opinion on this: build it ugly first, make it pretty last. People spend an hour picking colors before their formulas even work, and that's backwards. Get the math right. Get the total pulling correctly. Then, if you want, go make it look nice. Not before.
Building the frame
Open a new sheet, or a new tab if you're keeping it inside your existing workbook, and label it something obvious like "Invoice." Not "Sheet14." Future-you will thank you.
Put your business info at the top. A few rows for invoice number and date, off to the side. Then your line-item table starting a few rows down, with headers: Item, Quantity, Price, Total. That Total column is going to be quantity times price, a simple multiplication formula, nothing exotic.
Below your last line item, a Grand Total row that sums the Total column. This is the number your customer actually cares about, so double check it. Actually count your line items against what's on the screen before you send anything out the door. I've said this before in this class and I'll keep saying it: a spreadsheet will happily give you a confident wrong answer. It doesn't know it's wrong. You have to know.
A quick confession about naming things
I'll tell you why I'm so insistent about labeling columns clearly. A while back I was building a lookup formula for something completely unrelated to invoices, and it would not pull the right price no matter what I did. It was late. I mean late, like 11pm late. I got so convinced the problem was somewhere in how I'd organized my ingredients that I got up and reorganized my entire spice cabinet, alphabetical first, then by how often I actually use them, thinking somehow that would help me think clearer about the structure of the thing. My husband came downstairs, found me surrounded by jars of cumin at 11pm, said nothing useful, and went back to bed.
The actual problem? A typo in one column header. The formula was looking for "Price" and the column said "Prcie." One letter. That's it.
So when I tell you to label your columns clearly and double check the spelling before you build formulas off of them, that's not me being fussy. That's me speaking from a cabinet full of misplaced cumin.
Keep it to one page
Whatever business you're running, resist the urge to make this invoice do everything. It's not your inventory tracker, it's not your tax records, it's not a place to leave yourself notes about the customer's dog. One page. The seven things above. If you need more detail than that, that's a different sheet, linked or referenced, not crammed onto the invoice itself.
---
Before next time: get your frame built, business info at top, line-item table in the middle, total at the bottom. Don't worry about a single number in it being real yet. We'll fill it with actual numbers next lesson.