Building a budget in Google Sheets is one of the most effective things you can do for your financial life — and it costs nothing. Unlike paid budgeting apps, a Google Sheets budget gives you complete control over how it looks, what categories it tracks, and how the numbers are calculated. Once you build it, it's yours forever.
This guide walks you through the entire process of creating a personal budget in Google Sheets from scratch, even if you've never used a spreadsheet before.
Why Google Sheets Is One of the Best Budgeting Tools
Google Sheets has several advantages over dedicated budgeting apps that most people overlook. It's completely free, it works on any device, it syncs automatically across your phone and computer, and you can share it with a partner in real time. Most importantly, you can customize it exactly to your life — no app developer decided what categories you get or how the interface looks.
The only downside is the upfront setup time. This guide eliminates that barrier by walking you through every step.
Step 1: Open Google Sheets and Create Your Budget File
Go to sheets.google.com and create a new blank spreadsheet. Name it "My Budget 2026." You'll be building two main sections: an Income section and an Expense section, all on one tab to start.
Step 2: Set Up Your Income Section
Start in cell A1 and type "INCOME" in bold. Below that, list every source of income you have. Always use your take-home pay (after taxes and deductions), not your gross salary. Your budget only works with money that actually hits your bank account.
| Row | Label | Amount |
|---|---|---|
| 1 | INCOME | |
| 2 | Primary Job (take-home) | $4,200 |
| 3 | Side Hustle | $600 |
| 4 | Other Income | $0 |
| 5 | Total Income | =SUM(B2:B4) |
Step 3: Set Up Your Expense Categories
Below your income section, create your expense categories. Group them into three types for clarity: Fixed Expenses (same every month), Variable Expenses (change month to month), and Savings & Debt (money going toward your future).
Fixed Expenses are the easiest to budget because they never change:
| Category | Monthly Amount |
|---|---|
| Rent / Mortgage | $1,450 |
| Car Payment | $380 |
| Insurance (car + health) | $290 |
| Phone Bill | $85 |
| Internet | $60 |
| Subscriptions | $45 |
Variable Expenses require estimates based on your past spending patterns:
| Category | Monthly Budget |
|---|---|
| Groceries | $400 |
| Dining Out | $150 |
| Gas | $120 |
| Personal Care | $80 |
| Entertainment | $100 |
| Clothing | $75 |
| Miscellaneous | $100 |
Savings & Debt should be treated as non-negotiable expenses, not optional leftovers:
| Category | Monthly Amount |
|---|---|
| Emergency Fund | $200 |
| Retirement (401k/IRA) | $300 |
| Extra Debt Payoff | $150 |
| Sinking Funds | $200 |
Step 4: Calculate Your Budget Balance
At the bottom of your expense list, add a Total Expenses row using a SUM formula. Then create a Budget Balance row:
=Total Income - Total Expenses
If this number is positive, you have unallocated money — decide intentionally where it goes. If it's negative, your budget doesn't balance and you need to either increase income or reduce expenses before the month starts. A balanced budget where every dollar has a job is the goal.
Step 5: Add an "Actual" Column to Track Real Spending
Your budget is a plan. Reality is what actually happens. To track the difference, add a third column called "Actual" next to your budget amounts. At the end of each month, fill in what you actually spent in each category.
Then add a fourth column called "Difference" with a formula that subtracts Actual from Budget:
| Category | Budget | Actual | Difference |
|---|---|---|---|
| Groceries | $400 | $423 | -$23 |
| Dining Out | $150 | $97 | +$53 |
| Gas | $120 | $134 | -$14 |
This Budget vs. Actual comparison is the most valuable part of your entire spreadsheet. It shows you exactly where your plan broke down and where you have room to breathe.
Step 6: Use SUMIF to Pull Actual Spending Automatically
If you also maintain an expense log (a separate tab where you record every transaction), you can use SUMIF formulas to automatically pull your actual spending into your budget comparison — no manual entry needed.
On your budget tab, in the Actual column, instead of typing a number, use:
=SUMIF(Transactions!C:C,"Groceries",Transactions!D:D)
This formula looks at your Transactions tab, finds every row where the category is "Groceries," and sums the amounts. Now your Budget vs. Actual comparison updates automatically as you log new transactions throughout the month.
Step 7: Create a New Tab for Each Month
Right-click on your budget tab and duplicate it. Rename the new tab with the next month's name. Update your income amounts if they changed, reset your Actual column to zero, and you're ready for a new month. Over time, you'll build a full year of budget history in one file.
Step 8: Set Up a Simple Dashboard (Optional but Powerful)
Create a separate "Dashboard" tab that pulls key numbers from all your monthly tabs. A simple dashboard might show total income year-to-date, total spent by category year-to-date, your savings rate, and which month had the highest spending. This turns your budget from a monthly tracking tool into a full picture of your annual financial health.
The Most Important Step: Actually Logging Your Expenses
A budget is only as good as the data behind it. If you're not tracking what you actually spend, your Actual column stays empty and the whole system breaks down. The most sustainable way to keep your expense data current is to scan your receipts as you go — rather than trying to reconstruct a month of spending from memory at the end of the month.
ReceiptSync lets you scan paper and digital receipts with your phone, automatically extracts the merchant, date, and amount, and exports the data to Google Sheets. This means your budget's Actual column stays accurate without the manual data entry that causes most people to give up on their spreadsheet. Start tracking your spending free with ReceiptSync →
Budgeting Formats Worth Knowing
The budget structure above is a traditional monthly budget. If you get paid biweekly, you might find it easier to budget by paycheck rather than by month — assigning specific bills to each paycheck rather than thinking in monthly totals. If you want a more structured approach, the zero-based budget method (where income minus all expenses equals exactly zero) is covered in detail in a separate post.
Related posts: