Five categories is plenty: setting up income and spending
Okay sooo. New module. We've done the mechanics, typing, fixing typos, formulas that copy down without breaking, the whole foundation. Now we get to build something you'll actually use every week, a real household budget.
First thing I want to say, before we even open a sheet, is a real opinion of mine and I'll die on this hill a little. You do not need forty categories. I see people try to build a budget with a line for "coffee," a separate line for "coffee when I'm out with friends," a separate line for "work coffee." Stop. You will maintain that for eleven days and then abandon the whole sheet out of guilt. Five or six categories is plenty. Food can just be food.
What we're actually building
One tab. Two big sections stacked on top of each other, income up top, spending below it. That's it. That's the whole architecture for now.
Set it up like this:
- Row 1: a title, "Household Budget" or whatever you want to call it
- Row 3: header "Income"
- Rows 4 through however many: your income sources, one per row. Paycheck, side gig, whatever applies. Most households only have one or two lines here and that's normal
- Leave a blank row
- Header "Spending"
- Then your five or six categories. Something like Housing, Food, Transportation, Fun/Personal, Savings, Everything Else
That last one, Everything Else, is doing a lot of work and I mean that as a compliment. It's your pressure valve. Insurance renewal, a kid's field trip fee, the weird one-off Costco run where you bought a patio umbrella you didn't plan for, it all goes in there. You do not need a category for patio umbrellas.
Adding the numbers
For each category, put your planned or actual amount in the column next to it. Then two rows at the bottom: Total Income, using SUM on your income rows, and Total Spending, using SUM on your spending rows. We already know how to do this. It's the same SUM you've been doing, just pointed at a different chunk of cells.
Below both totals, one more row: Difference, which is just Total Income minus Total Spending. Point at the two cells, subtract, done. If that number's negative, you've got information you didn't have yesterday. That's the sheet working, even when what it's telling you isn't fun.
A story about being wrong and it not mattering
Not gonna lie, this lesson makes me think about the first real spreadsheet I ever built at a job, way before kids, way before any of this. I had a formula pointing at the wrong column. Just one column off. It sat there wrong for two full weeks and nobody caught it, including me, and I was the one who built it.
When I finally found it I went cold for a second. That specific stomach-drop feeling. Then I actually looked at what the wrong formula had been doing, and it turned out the numbers had been wrong in a way that didn't change any decision anybody made off that sheet. I laughed out loud, alone, at my desk, like an idiot.
I tell you that because when you build your budget this week and something looks off, and it will, you are not the first person to build a sheet with a mistake sitting in it quietly. Check your ranges. Make sure your SUM for Spending isn't accidentally including a header row or grabbing an extra blank cell. But also, don't panic if you catch something wrong three weeks in. Fix it, see what it actually changes, and move on.
A caution worth saying plainly
If you're bringing in real numbers from bank statements or a budgeting app, be careful copying and pasting income and expenses into the same column by accident, especially if your bank exports spending as negative numbers. A SUM formula doesn't know the difference between a mistake and a genuine number, it just adds what you point it at. Glance at your total and ask "does that feel right" before you trust it completely.
Before next time
Build your Income and Spending sections at home with your real numbers, five or six spending categories max, no cheating into eight. Bring it next time even if it feels rough, half-finished budgets are exactly what we're going to clean up together.
- C