Published · Updated · sheetfolk guides
Tips for Making a Google Sheet to Track Budget and Savings
Build a simple Google Sheet with one budget tab and one savings tab, use clear columns for planned vs. actual spending, add basic SUMIFS and IF formulas for totals and variance, and keep savings goals in a separate bucket section so the sheet stays readable and easy to update weekly.
TL;DR: Build a simple Google Sheet with one budget tab and one savings tab, use clear columns for planned vs. actual spending, add basic SUMIFS and IF formulas for totals and variance, and keep savings goals in a separate bucket section so the sheet stays readable and easy to update weekly.
Choose the simplest budget structure that still covers your goals
Start with one budget tab and one savings tab. If you try to model every snack, subscription, and emotional purchase in separate tabs, the sheet turns into a tiny administrative empire, which is fun for about 14 minutes.
A simple structure looks like this:
- Budget tab for monthly spending categories
- Savings Goals tab for longer-term goals and sinking funds
- Transactions tab only if you want to log every purchase individually
If you want the lightest possible setup, skip the transactions tab and just track monthly totals in the budget tab. If you want more detail, add the log later. Resist the urge to build a spreadsheet that requires a spreadsheet to maintain the spreadsheet.
For categories, start small:
- Housing
- Food
- Transport
- Utilities
- Personal
- Fun
- Savings
That covers spending and saving without turning the sheet into a category museum. If you need a broader planning framework, three practical tips for budget planning is a good companion read, because it keeps the whole process from getting weirdly elaborate.
Set up the core columns first
A clean layout makes the sheet usable later, which is the whole point. In the main log or budget table, use these columns:
- Date
- Category
- Planned
- Actual
- Savings Goal
- Saved
- Notes
Keep the meaning of each column boring and consistent:
- Date is when the transaction or savings action happened.
- Category is the spending bucket, like Groceries or Rent.
- Planned is what you expected to spend.
- Actual is what you really spent.
- Savings Goal is the goal name or target bucket.
- Saved is the amount you moved into that goal.
- Notes is for the messy human stuff, like "car repair, because of course."
If you use a transaction log, each row should describe one event. That way, formulas can sum the rows without guessing what you meant. Google Sheets is good, but it is not a mind reader. Yet.
Separate monthly spending from saving goals
Monthly spending and savings goals are related, but they should not live in the same totals pile. Otherwise, your budget summary gets muddy fast.
A practical setup is:
- Monthly spending section for regular categories like groceries, rent, gas, and utilities
- Savings goals section for sinking funds and longer-term goals like a vacation, car repairs, or emergency savings
This keeps your spending total readable. It also helps you avoid treating savings like leftover money, which is how savings plans quietly disappear into takeout.
Use a separate savings-goals area rather than mixing those numbers into the everyday budget.
Use formulas for totals, variance, and progress
Once the sheet structure is in place, formulas do the annoying math for you.
Useful basics:
- SUM for total planned spending, actual spending, or saved amounts
- SUMIFS for totals by category and month
- IF for variance flags or progress status
Example formulas, assuming:
- Column A = Date
- Column B = Category
- Column C = Planned
- Column D = Actual
- Column G = Saved
Monthly totals
=SUM(C2:C100)
This adds the planned amounts.
=SUM(D2:D100)
This adds actual spending.
Category total for a month
=SUMIFS(D:D, B:B, "Groceries", A:A, ">="&DATE(2026,6,1), A:A, "<"&DATE(2026,7,1))
This totals Groceries for June 2026.
Variance
=IF(D2>C2, D2-C2, 0)
That shows overspending only. If you want under-budget amounts too, subtract actual from planned.
Savings progress
=IF(E2>0, F2/E2, 0)
If E2 is the goal amount and F2 is the amount saved, this returns progress as a decimal. Format it as a percentage if you want the nicer human version.
If you want a progress bar, you can use a simple visual formula like:
=REPT("▓",ROUND(F2/E2*20,0))&REPT("░",20-ROUND(F2/E2*20,0))
That gives you a quick visual check without needing a chart.
Add a savings bucket section for goals with deadlines
A savings bucket section helps when you have goals that are not just vague hopes with good lighting.
For each goal, list:
- Goal name
- Target amount
- Current balance
- Remaining amount
- Deadline
Example formulas:
=TargetAmount-CurrentBalance
for the remaining amount.
=IF(TargetAmount>0, CurrentBalance/TargetAmount, 0)
for progress.
If you also track deadlines, you can add a simple status column, such as:
=IF(CurrentBalance>=TargetAmount,"Funded",IF(TODAY()>Deadline,"Overdue","In progress"))
That gives you a quick read on whether the goal is funded, still moving, or late to the party.
A dedicated setup can be the right next step once the goals list starts acting like a second budget.
Worked example: one month budget plus two savings goals
Here is a small example that shows how spending and savings can flow through the sheet.
Monthly budget
| Date | Category | Planned | Actual | Variance |
|---|---|---|---|---|
| 2026-06-01 | Rent | 1200 | 1200 | 0 |
| 2026-06-03 | Groceries | 350 | 392 | 42 |
| 2026-06-05 | Transport | 120 | 98 | 0 |
| 2026-06-10 | Utilities | 160 | 154 | 0 |
| 2026-06-15 | Dining Out | 100 | 135 | 35 |
| 2026-06-22 | Personal | 80 | 64 | 0 |
Totals:
- Planned spending = 2010
- Actual spending = 2043
- Overspending = 33
Savings goals
| Goal | Target Amount | Current Balance | Remaining | Deadline | Progress |
|---|---|---|---|---|---|
| Car repairs | 900 | 540 | 360 | 2026-10-01 | 60% |
| Weekend trip | 600 | 150 | 450 | 2026-08-15 | 25% |
Example formulas behind that table:
=TargetAmount-CurrentBalance
for Remaining.
=IF(TargetAmount>0, CurrentBalance/TargetAmount, 0)
for Progress.
That is the whole trick. Spending stays in the monthly budget. Goals stay in the savings section. Nobody has to guess where the money went, which is a nice change.
Make the sheet easy to update every week
A budget sheet only works if updating it does not feel like a punishment from the spreadsheet gods.
Use a simple weekly routine:
- Enter transactions from the last few days.
- Reconcile balances against bank or account totals.
- Check overspending in any category with a variance formula.
- Move money into savings based on the week’s plan.
A good rhythm is to update once a week, on the same day every time. That keeps the sheet from turning into a month-end archaeology project. If you wait too long, the log gets fuzzy, receipts go missing, and suddenly you are trying to remember whether that coffee was work-related or just "strategic caffeine."
Keep the design simple enough to keep using
The best budget sheet is the one you still open next month.
A few small design choices help:
- Use clear names for tabs and columns, like Budget, Savings, and Transactions.
- Color-code lightly, maybe one color for input cells and one for formulas.
- Freeze panes so headers stay visible while you scroll.
- Protect formulas so you do not accidentally break totals while editing entries.
Keep fonts, borders, and colors calm. If every cell is shouting, the sheet gets harder to use. A budget file should feel like a tool, not a carnival.
Also, mark input cells clearly and leave formulas alone. That way, your future self does not have to debug a broken SUMIFS at 11 p.m. because one cell got dragged sideways.
When to add sinking funds or a fuller template
Add sinking funds when your savings goals start having specific deadlines, recurring annual costs, or separate categories that need their own funding plan. At that point, the simple savings bucket section is still fine, but you may want a more structured setup.
If you need a more complete system, a dedicated goal-tracking setup can explain that kind of goal tracking in more detail. If you want to step back and rethink the whole planning approach, a broader framework is the next step.
The short version: start simple, use formulas for the boring parts, keep savings separate enough to see them clearly, and do not build yourself a museum exhibit of financial efficiency. A budget sheet should help you spend with intention and save on purpose, not become a side hustle in formatting.
Template for this guide
2026 Ultimate Budget Bundle
Monthly budget, paycheck planner, debt payoff, net worth and a yearly dashboard in one Google Sheets and Excel workbook. Browse every tab before you buy. One-time price, no subscription, free updates to the current-year edition.