What We're Building and Why (The Three Sheets)
Okay. Sooo, before we touch a single cell, I want to tell you what we're actually building over these six weeks, because I think people get overwhelmed when they don't know where the road ends.
Here's the destination. Three sheets. That's it.
- A sales/income tracker — what came in, when, from who
- An expense tracker — what went out, and on what
- A simple inventory or job list — whatever you sell or do, tracked in one place
That's the whole business, right there. Not fifteen tabs. Not a color-coded galaxy brain situation. Three sheets that talk to each other a little bit by the end.
Why three, and not one giant sheet
I know the instinct. Cram it all into one tab so you only have to look at one thing. I get it, I do. But that's how you end up with a spreadsheet where row 47 means something completely different than row 12, and only you know why, and if you get hit by a bus (sorry, dark) nobody else could run your business off that thing for a week.
Separate sheets, one job each. Sales sheet just tracks sales. Expense sheet just tracks expenses. Boring on purpose. Boring is good in a spreadsheet. Exciting is bad.
Why we're not starting with the pretty version
I'll say this now because you're gonna want to fight me on it later: we are building these ugly first.
No colors yet. No fancy formatting. Just columns, headers, numbers going in the right spot. I know it's tempting to pick your color scheme and get the fonts just right before you've even figured out if your SUM formula works. People do this constantly. They spend an hour on the look of a thing that doesn't function yet. Backwards way to build anything.
Get it working. Then make it pretty. Not the other way around.
A quick story on why "pretty" isn't the point
I built this really nice dashboard once for a garage-sale fundraiser I was helping with. Spent a whole Saturday on it. Colors, a little chart, everything lined up clean. I was proud of it, ngl.
Nobody looked at it. Not one person. They just wanted to know "did we make money or not" and honestly a sticky note could've told them that.
I was quiet the rest of that day, not gonna lie, it stung a little. But it taught me something I still tell people in week one of this class: the fancy version isn't the point. The person actually using the sheet is the point. If your sheet is gorgeous but nobody opens it, or it's so complicated you dread opening it yourself, it's not doing its job. A plain sheet that you actually update every week beats a beautiful one that scares you off.
So that's the standard for these three sheets. Not "does it look impressive." Just "will I actually use this on a Tuesday when I'm tired."
What this looks like in practice, week by week
We're building slow on purpose. Week one is just getting Google Sheets set up and comfortable, which is what we're doing today. Then one sheet at a time, we'll build income, then expenses, then your inventory or job list. By the end you'll have all three doing the basic stuff, and then in the last week or two we'll do the fun part, conditional formatting, a little bit of color that actually means something, maybe a chart if you want one.
Everybody with me so far? If the "three sheets" thing doesn't quite map onto your business yet, that's fine, we'll figure out your version together as we go. Somebody selling freezer meals needs a slightly different setup than somebody fixing bikes. The bones are the same though.
One thing I want you to let go of right now
You do not need to understand every function Google Sheets has. Not even close. I've been doing this for years and I use maybe five formulas, ever. SUM, a lookup, some basic IF statements, that's about 90% of running a small business on a spreadsheet. If a YouTube video starts throwing ARRAYFORMULA and nested this-and-that at you, close the tab. That's not for you right now, and honestly it might not be for you ever. You can run a solid business without it.
We're keeping this simple because simple is what you'll still understand in March when you haven't opened the sheet in three weeks. Trust me on that one.
---
Before next time: just open a Google account if you don't already have one, and don't worry about anything else. We'll build the actual first sheet together next lesson.