How to Build a Monthly Budget in Google Sheets You'll Actually Keep
The best monthly budget is the one you'll still be using in March. In Google Sheets that means a simple structure: your income at the top, a short list of categories with a planned and an actual amount, and one number that always shows what's left to spend. No app, no subscription. Here's the method that survives contact with real life.
Start with income, then give every dollar a job
This is zero-based budgeting: income minus everything you assign = zero. You're not spending to zero — you're assigning to zero, and "savings" is a job like any other. When every dollar has a purpose, you stop wondering where it went.
Keep categories short — 10 to 12, not 40
Over-categorizing is why budgets die. Start here and cut what doesn't apply: Housing, Utilities, Groceries, Transportation, Insurance, Debt payments, Savings, Subscriptions, Personal, Eating out, Kids/pets, Misc. One "Misc." line is healthier than ten categories you'll never fill in honestly.
The three formulas that run it
- Total planned:
=SUM(Planned column) - Total spent:
=SUM(Actual column) - Left to spend:
=Income - SUM(Actual column)— pin this at the very top.
Add a per-category remaining column (=Planned - Actual) and conditional formatting
that turns a category red when you overspend it. That red cell is the entire early-warning system.
The habit, not the template, is what works
- Log spending twice a week — a two-minute glance at your bank feed beats a monthly catch-up you'll dread and skip.
- Reset on the 1st — copy the tab, update planned amounts, start clean. A month is a short enough loop to stay motivated.
Running a whole household? The Home & Family Life Toolkit bundles the budget with a meal planner, cleaning schedule and more. And keep the house side on track with a cleaning schedule that actually sticks.