How to track a budget in Google Sheets: a step-by-step guide
A budget in Google Sheets is one sheet for entries, one settings sheet and a dashboard sheet: you log every expense as a row, while formulas and pivot tables calculate the remaining budget per category. Below is a step-by-step guide to building such a budget in 20 minutes — or grab the ready-made free template.
Why keep a budget in a spreadsheet at all
A spreadsheet beats an app for one reason: you can see how your money is counted. In an app, categories are a black box; in a sheet every formula is open and the logic can be adapted to you. Personal-finance research keeps showing the same thing: regularly writing expenses down reduces impulsive spending, because the purchase becomes visible the same day instead of at month end.
Step 1. Structure: three sheets and nothing else
A minimal working budget:
| Sheet | Purpose |
|---|---|
| Data | The single input point: date, amount, category, note |
| Settings | Categories, limits, month name |
| Dashboard | Summaries, charts, progress bars |
Do not spread entries across several sheets — pivot tables will break and the budget turns into bookkeeping.
Step 2. Categories: no more than 12
The sweet spot is 8–12 categories: groceries, transport, housing, utilities, fun, health, clothing, phone and internet, subscriptions, misc. Finer slicing kills discipline: within a month you will no longer remember where to file “coffee to go”.
Step 3. Recurring payments get their own list
Keep subscriptions and auto-charges in a separate block with the charge date. A simple =IF(DAY(TODAY())>=DAY(date);"charged";"upcoming") turns the list into a charge calendar and stops the monthly surprises.
Step 4. Dashboard: three charts are enough
- Spending by category for the month — a bar chart.
- Weekly trend — a line chart.
- Savings-goal progress — a filled bar.
More than three charts at the start is the road to a nobody-looks dashboard.
Step 5. A weekly ritual, 10 minutes
Sunday, ten minutes: reconcile the entries, check overruns, update the goal. The weekly rhythm matters more than a perfect system: a budget reconciled once a quarter does not work.
A ready template instead of building from scratch
Everything described above is already set up in the Budget Tracker template: sheets, formulas, conditional formatting on limits, bank CSV import and a dashboard with 30 days of demo data. Download the .xlsx or make a Google Sheets copy — free and without sign-up.
If the article helped, you can support it with a donation — but it is optional.