Google Sheets is one of the best budgeting tools you can use, and it costs nothing. It works on any device, it saves automatically, you can share it with a partner, and nobody is selling your transaction data. The only downside is the blank grid. This guide walks you through building a working budget from scratch, one tab at a time.
Step 1: Create the file and three tabs
Open sheets.google.com, start a blank spreadsheet and name it something like "Budget 2027". At the bottom, create three tabs: Income, Expenses and Dashboard. Keeping these separate makes the formulas simpler and the sheet much easier to read later.
Step 2: Set up the Income tab
In row 1, add these headers: Date, Source, Planned, Actual. List every income source you expect this month: salary, side work, benefits, anything regular. Put what you expect in Planned and what actually arrives in Actual.
At the bottom of the Actual column, add a total. If your amounts are in D2 to D20, the formula is:
-
=SUM(D2:D20)for total actual income. -
=SUM(C2:C20)for total planned income.
Tip: select the money columns and use Format > Number > Currency so every value displays the same way, in your own currency.
Step 3: Set up the Expenses tab
Headers: Date, Description, Category, Type (Fixed or Variable), Planned, Actual. Fixed costs are the same every month (rent, insurance, phone). Variable costs change (groceries, fuel, eating out).
To keep categories consistent, select the Category column and use Data > Data validation > Dropdown, then type your categories: Housing, Utilities, Groceries, Transport, Debt, Subscriptions, Fun, Savings. Consistent categories are what make the dashboard work.
Step 4: Total each category with SUMIF
On the Dashboard tab, list your categories in column A. Next to each one, use SUMIF to add up the actual spending for that category:
=SUMIF(Expenses!C:C, A2, Expenses!F:F)
This reads: "look down the Category column on the Expenses tab, find every row that matches A2, and add up the Actual amounts". Drag the formula down for every category. Add a second column with the planned amounts using the same formula on column E, and a third column for the difference (planned minus actual).
Step 5: Add the one number that matters
At the top of the Dashboard, add three cells: total income, total expenses, and left to assign:
=Income!D21 - SUM(B2:B10)
If left to assign is positive, give that money a job: extra debt payment, a savings goal or a sinking fund. If it is negative, you can see exactly which category went over. This is the core of a zero-based budget.
Step 6: Add a chart and conditional formatting
Select your category names and actual totals, then Insert > Chart and choose a pie or bar chart. For the difference column, use Format > Conditional formatting to turn cells red when they are below zero. Now an overspent category jumps out at a glance.
Step 7: Keep it alive in five minutes a week
Most budgets fail because they are not updated, not because they are badly built. Pick one time each week, for example Sunday evening, and type in that week's spending from your bank app. Five minutes is enough. At the end of the month, duplicate the tab (right-click > Duplicate) for the next month.
Common mistakes to avoid
- Too many categories. Eight to twelve is plenty. You can always split one later.
- Forgetting irregular costs. Car repairs, gifts and annual renewals are not surprises. Plan for them with sinking funds.
- Budgeting with income you don't have yet. Budget last month's income, or your lowest typical month if your pay varies.
Want to skip the setup?
Building your own sheet is a great way to learn, but it takes an evening and the formulas are easy to break. If you would rather start with a finished file, our free Monthly Budget Starter has income, expenses, savings and a dashboard already set up, and opens in Google Sheets in about a minute. For more detail, the full template bundle covers paycheck budgets, debt payoff, bills, net worth and more.
Originally published on Smart Budget Sheets.
Top comments (0)