How to Build a Monthly Budget in Google Sheets You'll Actually Keep
Looking for a tool?
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.
Quick FAQ
How do I make a monthly budget in Google Sheets?
List your income at the top, then your expenses grouped into categories below, and use =SUM() to total each and subtract expenses from income for what's left. Add a column for "budgeted" vs. "actual" so you can see where you drifted and adjust next month.
What budgeting method should I use?
A popular starting framework is 50/30/20 — roughly 50% of take-home to needs, 30% to wants, 20% to savings and debt. It's a guideline, not a rule; the best method is the one you'll actually keep updating.
How do I actually stick to a budget?
Make it low-friction and visible: check it briefly each week rather than perfectly once a month, and track spending as it happens so the numbers stay real. A budget you glance at often beats a detailed one you abandon.