If you’ve ever opened your bank app, felt a small wave of dread, and closed it again, a budget in Google Sheets might be the least intimidating place to start. It’s free, it works on your phone and your laptop, and you don’t have to hand your bank login to another app to use it.
You don’t need to be good at spreadsheets. You need about 20 minutes and a rough idea of what you earn and spend. This guide walks through building a working budget from a blank sheet, the formulas that do the math for you, and how to decide if a ready-made template might save you the trouble. If you’re weighing a spreadsheet against an app, our comparison of the best budgeting apps in 2026 covers what the paid options actually add.
Why Google Sheets Still Works for Budgeting in 2026
Budgeting apps come and go (Mint shut down, and its replacements now charge monthly fees that can add up over a year). A Google Sheet doesn’t expire, doesn’t get acquired, and doesn’t change its pricing on you. It’s also private: your numbers stay in your own Google account instead of syncing to a third-party server.
The tradeoff is that nothing updates automatically. You’ll need to enter transactions yourself or copy them from your bank’s export, at least until you’re comfortable linking a paid add-on. For a lot of people, that manual step is actually the point: typing in what you spent is what makes it stick.
Step 1: Set Up Two Tabs (Summary and Transactions)
Open a blank spreadsheet at sheets.google.com and rename the file something you’ll recognize later, like “Household Budget 2026.” Then create two tabs at the bottom:
- Summary: where you’ll see your budgeted amount, actual spending, and the difference for each category
- Transactions: a running log of every purchase, one row per transaction
Keeping these separate matters. The Transactions tab is where the detail lives; the Summary tab is where the formulas pull that detail into totals you can actually read at a glance.
Step 2: Build Your Categories
On the Summary tab, list your income sources at the top (paycheck, side income, anything recurring), then your expense categories below: rent or mortgage, groceries, utilities, transportation, subscriptions, debt payments, and savings.
Keep the list short enough to actually maintain. Ten to fifteen categories is usually plenty. You can always split “shopping” into more specific categories later once you see where the money is actually going.
| Column | What goes here |
|---|---|
| A | Category name (Rent, Groceries, Utilities…) |
| B | Budgeted amount for the month |
| C | Actual amount spent (pulled from Transactions) |
| D | Difference (Budgeted minus Actual) |
Step 3: Log Transactions and Pull Totals With SUMIF
On the Transactions tab, create columns for Date, Description, Category, and Amount. Every time you spend money, add a row. It sounds tedious, but most people can catch up in five minutes at the end of the day, or once a week if daily logging feels like too much.
Back on the Summary tab, the SUMIF function is what turns that log into a total. If your Transactions tab has categories in column C and amounts in column D, and your Summary tab lists “Groceries” in cell A5, the formula in column C (Actual) would look like this:
=SUMIF(Transactions!C:C, A5, Transactions!D:D)
That pulls every transaction tagged “Groceries” and adds up the amounts automatically. Copy the formula down the column and update the category reference for each row, and your Summary tab updates itself every time you log a new purchase.
Step 4: Add Conditional Formatting to Flag Overspending
Select your Difference column (D), then go to Format, then Conditional formatting. Set a rule so any negative number (meaning you spent more than budgeted) turns red, and anything positive turns green. It’s a small touch, but it’s the difference between scanning a wall of numbers and immediately seeing which categories need attention this month.
You can layer on a simple progress bar too, using the SPARKLINE function, if you want a visual sense of how close you are to a category’s limit without doing the math in your head.
Step 5: Pick a Budgeting Method (or Skip It)
A blank spreadsheet doesn’t tell you how to split your money. That’s where a method helps. Three common approaches:
- 50/30/20: 50% of take-home pay to needs, 30% to wants, 20% to savings and debt payoff. Simple starting point if you’ve never budgeted before.
- Zero-based budgeting: every dollar gets assigned a job (spending, saving, or debt) until your budget totals zero. More work, more control.
- No fixed method: just tracking what comes in and out, categorized, without a strict formula. Useful if you mainly want visibility before you commit to rules.
None of these percentages are rules handed down from anywhere official. They’re starting points. Your actual split depends on your income, where you live, and what you’re trying to pay off or save for. If credit card interest is eating into your budget, it’s worth reviewing our list of common credit card mistakes that get expensive when APRs top 21% alongside whatever method you pick.
Step 6: Or Start From a Free Template Instead
Building from scratch teaches you how the spreadsheet works, but it’s not required. If you’d rather copy something and adjust it, Google Sheets has a built-in option: open Sheets, click Template gallery in the top right, and look under Personal for Monthly Budget or Annual Budget. Several finance sites also publish free downloadable templates built around a specific method.
| Template type | Best for | Setup time |
|---|---|---|
| Google’s built-in Monthly Budget | Fastest start, minimal customization | Under 5 minutes |
| 50/30/20 spreadsheet | First-time budgeters who want a simple rule | 10 to 15 minutes |
| Zero-based budget template | People with variable income or heavy debt payoff goals | 20 to 30 minutes |
| Build-your-own (Steps 1 to 5 above) | Full control over categories and formulas | 30 to 45 minutes |
Either path gets you to the same place: a spreadsheet that shows you where your money is going. Pick based on how much you enjoy tinkering with formulas versus just wanting the answer.
Common Mistakes That Make a Budget Sheet Fall Apart
A few things quietly kill most homemade budgets within a month or two:
- Too many categories. Twenty-five line items is exhausting to maintain. Consolidate anything you don’t check separately in real life.
- Forgetting irregular expenses. Car registration, annual subscriptions, and holiday spending don’t show up every month, but they still need a line item, even a rough one.
- No regular check-in. A spreadsheet you update once and never open again isn’t a budget, it’s a snapshot. A weekly five-minute review keeps it useful.
- Copying someone else’s percentages exactly. A 50/30/20 split that works in a low cost-of-living area may not work where rent alone eats 40% of take-home pay. Adjust the framework to your numbers, not the other way around.
Making It a Habit, Not a One-Time Project
The mid-year point is a genuinely useful moment to start or reset a budget. You’ve got six months of spending behind you as a rough guide, and six months ahead to see whether the numbers actually change. Set a recurring reminder, weekly or every payday, to update your Transactions tab and glance at the Summary. That’s really the whole system. The formulas do the arithmetic; you just have to show up and enter the numbers. For a broader checklist of what else to review right now, see our 7 mid-year money moves to make before the end of summer, and if bank fees are quietly working against your budget, our guide to sneaky bank fees and how to avoid them is worth a look too.
This article is for general educational purposes and isn’t financial advice. Your ideal budget structure depends on your income, expenses, and goals, and may vary widely from the examples above. For guidance specific to your situation, consider speaking with a qualified financial professional. The Consumer Financial Protection Bureau (CFPB) also publishes free budgeting worksheets and tools at consumerfinance.gov.
Frequently Asked Questions
Is there a budget template in Google Sheets?
Yes. Google Sheets includes a built-in Monthly Budget and Annual Budget template under Template gallery, in the Personal section. They come with pre-filled income and expense sections and calculate totals automatically, so you can start without building anything from scratch.
Is it better to budget in Excel or Google Sheets?
Both handle budgeting well, and the formulas (SUM, SUMIF) work almost identically in either one. Google Sheets tends to be easier for updating on your phone and sharing with a partner in real time, since changes save automatically and there’s nothing to install. Excel may feel more familiar if you already use it for work, and it works fully offline. The better choice usually comes down to which one you’ll actually open every week.
Does Google have a free budget tool besides Sheets?
Google doesn’t offer a dedicated standalone budgeting app the way some banks or fintech apps do. The Sheets templates are the closest built-in option. If you want something that connects to your bank automatically, that typically means a separate budgeting app, usually with a monthly or annual fee.
What’s the difference between a 50/30/20 budget and a zero-based budget?
A 50/30/20 budget splits your take-home pay into three broad buckets: needs, wants, and savings or debt payoff. A zero-based budget assigns every single dollar a specific job until your income minus your planned spending equals zero. The 50/30/20 approach is simpler to maintain; zero-based budgeting takes more setup time but gives you tighter control, which can help if you’re paying down debt or working with a tight or irregular income.
How often should I update my Google Sheets budget?
Weekly works well for most people, or right after each payday if your income is irregular. Waiting until the end of the month to enter everything makes it much harder to remember what you actually bought, and you lose the chance to adjust spending while the month is still happening.
Can I share a Google Sheets budget with my partner or family?
Yes. Click Share in the top right corner and add their email address with edit access. Both of you can update the Transactions tab from your own devices, and the Summary tab reflects changes instantly since it’s the same live file, not a copy.
