Making It Look Decent Last, Not First
Okay. Last lesson we got your invoice actually totaling things correctly, line items, tax, the whole math part working. This lesson is the fun one, but I want you to notice something first.
We waited.
We built the boring, working, correct version of this invoice for two full lessons before we touched a single color or font. That's not an accident. That's the whole opinion I keep coming back to in this class: build it ugly first, make it pretty last. People spend an hour picking fonts and colors before their formulas even work, and then the formulas break and they have to redo the pretty part anyway. Backwards. So we did it in the right order. You're welcome, future you.
Now we get to fuss with the look. Sooo, here's how I'd do it.
Start with what actually needs to stand out
Before you touch anything, ask yourself: when my client opens this, what's the one number they need to see in about two seconds? For most invoices it's the total due. Maybe the due date too, if you're chasing payment.
Everything else, the line items, your business name, the little "thank you" note at the bottom, is supporting cast. Don't let it compete with the star.
Bold and size, not rainbow
Make your total bigger. Bold it. Maybe bump the font size up two or three points from everything else on the page. That's it. That's most of what "making it look decent" actually needs.
I see people go straight for five different colors, three fonts, a logo they spent an hour resizing. Your client doesn't need a poster. They need to know what they owe and when. Clean beats fancy every time on something this simple.
Add a border where the invoice "ends"
Highlight your line-items section and add a border around it. Same for your totals box at the bottom. This does something sneaky and useful: it visually tells the eye "this section is done, move to the next one." You don't need gridlines everywhere. In fact, turn most of them off. Go to View, uncheck Gridlines, and suddenly your plain spreadsheet looks like an actual document instead of a spreadsheet wearing a costume.
One color, used on purpose
If you want a color accent, pick one. One. Maybe it's your business's color if you have a logo, maybe it's just a blue you like. Use it on your header row and your total line, and nowhere else. Consistency reads as professional. A different color on every section reads as "I found the paint bucket tool and got excited."
And look, I need to tell you a story here because it's relevant and also because I still think about it.
First time I ever demoed conditional formatting live in front of a room, I set up a rule to highlight cells over a certain amount. Except I typed the rule backwards. Instead of highlighting the big numbers, the whole sheet turned red. Every cell. Like the spreadsheet was yelling at everyone. I just stood there for a second, then laughed and said "sooo, that's what NOT to do," and fixed it right there while everyone watched.
That mess-up got a bigger laugh than anything I'd planned for that lesson. And here's the actual lesson in it for you: when you're setting up your invoice's look, you will get a rule backwards, or pick a color that makes text unreadable, or bold the wrong row. It's going to look goofy for a second. That's fine. Fix it, keep going. Nobody's grading your first draft of the formatting.
The part where I tell you a true story from my own kitchen table
Daniel, my husband, fixes up bikes on the side. Refused to track any of it for a year, which drove me a little crazy honestly. When I finally built him an invoice sheet, I kept it dead simple. One page. No fancy stuff, no color themes, nothing that needed explaining. Just his logo-ish header, a line-items box, and a bold total.
He uses it now. Every time. Won't admit I was right about keeping it simple, but he uses it, so.
The point is: the fanciest version isn't the point. I spent a full Saturday once building a gorgeous dashboard for a garage-sale fundraiser and not one person looked at it. Learned that lesson the hard way. The invoice that gets used is the one that's clear enough your client understands it in two seconds, not the one that took you three hours to make beautiful.
Quick checklist before you call it done
- Total is bold and bigger than everything else
- Gridlines turned off, borders added where sections end
- One accent color, used consistently, not five
- You've actually looked at it the way your client will, on a phone screen if that's how they'll open it
That last one matters more than people think. What looks great on your laptop can turn into a squished mess on a phone. Pull it up on your phone before you send your first real one out.
Before next time
Take the invoice you built last lesson and do the "decent last" pass on it, just bold, borders, one color. Don't spend more than fifteen minutes on it. If you're still fussing after fifteen minutes, you've made my point for me.