Google Sheets might be the most underrated budgeting tool on the planet.
It’s free. It’s flexible. It works on every device. And unlike most budgeting apps, you own your data completely — no subscriptions, no lock-in, no company going out of business and taking your financial history with it.
But here’s the thing: most people who try budgeting with Google Sheets give up within a month. Not because spreadsheets are bad, but because they set them up wrong.
This guide will show you how to build a budget in Google Sheets that you’ll actually stick with — and a trick at the end that solves the biggest problem with spreadsheet budgeting.
Why Google Sheets Works for Budgeting
Before we get into the how, let’s talk about why:
It’s genuinely free. Not “free trial” free. Not “free with ads” free. Actually free, forever, with a Google account.
You own your data. Your budget lives in your Google Drive. You can export it, share it, back it up, or analyze it however you want. No app can lock you out of it.
It’s infinitely customizable. Want to track spending by store? Add a column. Want a chart of your grocery spending over time? Build one. Want to share it with your partner? Click “Share.” Try doing that with most budgeting apps without paying extra.
It works on every device. Phone, tablet, laptop, work computer — anywhere you have a browser, you have your budget.
Step 1: Choose Your Budgeting Method
Before you open a blank spreadsheet, decide how you want to budget. The two most popular methods are:
Zero-based budgeting: Every dollar of income gets assigned to a category. Income minus all allocations equals zero. This is what YNAB popularized — you’re giving every dollar a job.
Envelope budgeting: You divide your money into “envelopes” (categories) and spend from each envelope until it’s empty. When the grocery envelope runs out, you stop spending on groceries or move money from another envelope.
These are actually very similar — envelope budgeting is essentially zero-based budgeting with a visual metaphor. Pick whichever framing makes more sense to your brain.
For this guide, we’ll use the envelope method since it translates well to spreadsheet columns.
Step 2: Set Up Your Budget Sheet
Create a new Google Sheet and name it something you’ll recognize — “2026 Budget” works fine.
Tab 1: Monthly Budget
Create these columns:
- Category — Your envelope names (Rent, Groceries, Gas, Entertainment, etc.)
- Budgeted — How much you plan to spend this month
- Spent — Running total of what you’ve actually spent
- Remaining — Formula:
=Budgeted - Spent
Start with 10–15 categories. Common ones include:
- Housing (rent/mortgage)
- Utilities
- Groceries
- Transportation (gas, transit, car payment)
- Insurance
- Dining out
- Entertainment/subscriptions
- Clothing
- Personal care
- Savings
- Emergency fund
- Debt payments
At the bottom, add a row that sums each column. Your total “Budgeted” should equal your monthly income. If it doesn’t, adjust until it does — that’s the zero-based part.
Tab 2: Transactions
This is where you log every purchase. Columns:
- Date
- Description (store name or what you bought)
- Category (must match your budget categories exactly)
- Amount
Then use SUMIF formulas on your Budget tab to automatically pull spending totals from your Transactions tab:
=SUMIF(Transactions!C:C, A2, Transactions!D:D)
This formula says: “Look at all categories in the Transactions sheet, find ones matching this budget category, and sum up the amounts.”
Step 3: Add Some Quality-of-Life Features
Once the basics work, add these upgrades:
Conditional formatting on the “Remaining” column — green when positive, red when negative. Instant visual feedback on which envelopes are running low.
Data validation on the Category column in Transactions — create a dropdown that pulls from your budget categories. This prevents typos that break your SUMIF formulas.
A dashboard tab with charts. A simple pie chart of spending by category and a bar chart comparing budgeted vs. actual gives you a quick monthly overview.
Monthly rollover tracking. Add a “Carried Over” column to your budget. At the end of each month, duplicate the budget tab, rename it (March 2026, April 2026, etc.), and carry forward any remaining balances.
Step 4: Make It a Daily Habit
The spreadsheet is useless if you don’t log transactions. Here’s how to make it stick:
Log transactions immediately. Don’t wait until the end of the day. When you buy something, open your phone and log it. This takes 15 seconds.
Do a weekly check-in. Every Sunday, spend 5 minutes reviewing your budget. Are any envelopes running low? Do you need to move money between categories?
Monthly close-out. At the end of each month, review your totals, carry over balances, and set up next month’s budget.
The Biggest Problem with Spreadsheet Budgeting
Here’s what nobody tells you about budgeting with Google Sheets: it’s terrible on a phone.
Opening Google Sheets on mobile, zooming into tiny cells, carefully tapping the right row, typing a number without accidentally editing a formula — it’s miserable. And since you need to log transactions the moment they happen (which is usually when you’re out with your phone), this is a real problem.
This is why most people who budget with spreadsheets eventually give up. The desktop experience is great. The mobile experience is painful. And budgeting only works if you do it consistently.
The Solution: A Mobile UI for Your Spreadsheet
This is where tools like Okane come in. Okane is a mobile budgeting app where your Google Sheet is your budget. You get a clean, tap-friendly interface for logging transactions, checking envelope balances, and moving money between categories — but behind the scenes, everything syncs to a Google Sheet on your Drive.
You keep all the benefits of spreadsheet budgeting — data ownership, flexibility, free sharing with your partner — without the pain of actually using a spreadsheet on your phone.
It’s not the only option (you could also build a Google Form that feeds into your sheet), but it’s the smoothest experience I’ve found for people who want the power of spreadsheets with the convenience of an app.
Tips for Long-Term Success
Start simple. You can always add complexity later. Begin with 10 categories and a basic transaction log. Don’t build a 15-tab masterpiece before you’ve budgeted for a single month.
Don’t budget what you wish you spent. Budget what you actually spend, then gradually adjust. If you spend $600 on groceries, don’t budget $300 and feel like a failure. Budget $600, then try to bring it down to $550 next month.
Review your categories every quarter. Life changes. Your budget should too. Categories that made sense in January might not make sense in June.
Share it with your partner. If you budget as a couple, share the Google Sheet. Both of you can log transactions, and you always see the same numbers. No “my budget says X, yours says Y” confusion.
Back it up. Google Drive is reliable, but download a copy of your sheet every few months. File → Download → Microsoft Excel. Keep it somewhere safe.
Getting Started
You don’t need to buy anything. You don’t need to sign up for a free trial. You don’t need to give anyone your bank login.
Open Google Sheets. Build a simple budget. Start tracking.
If you want a mobile-friendly experience on top of your spreadsheet, give Okane a try — it’s free, and your data stays in your Google Sheet where it belongs.
The best budgeting system is the one you actually use. For a lot of people, that’s a spreadsheet. And there’s nothing wrong with that.
Yuna writes about personal finance and budgeting tools. You can find more budgeting guides at okane.finance/blog.