Aspire Budgeting

How to Budget in Google Sheets (Beginner's Guide for 2026)

Published on May 18, 2026

Google Sheets is one of the best places to manage a budget. It’s free, accessible from any device, shareable with a partner, and flexible enough to grow with you. No app subscription, no vendor lock-in — just a spreadsheet in your Google Drive.

This guide walks through setting up a working budget from scratch, whether you want to build something yourself or start from a template.

Why Google Sheets for budgeting?

  • Free forever — no subscription that might increase or get discontinued
  • Works everywhere — laptop, phone, tablet via the Google Sheets app
  • Shareable — budget with a partner without both needing paid accounts
  • You own it — data lives in your Drive, not on a company’s servers
  • Private — no third-party sees your financial data
  • Flexible — add formulas, charts, or automations whenever you want

The main tradeoff vs. dedicated apps: no automatic bank transaction importing. You enter spending manually (or import via CSV). Most people who stick with spreadsheet budgeting find this actually helps — the act of logging a purchase keeps spending top of mind.

The two approaches

Approach 1: Build from scratch

You can create a budget in a blank Google Sheet. Here’s the minimum structure you need:

Sheet 1 — Budget overview:

  • Column A: Category names (Rent, Groceries, Transportation, etc.)
  • Column B: Budgeted amount (what you plan to spend)
  • Column C: Actual amount (what you actually spent)
  • Column D: Difference (=B2-C2, shows over/under)

Sheet 2 — Transactions:

  • Date, Description, Amount, Category, Account
  • One row per purchase

Formulas you’ll need:

  • =SUM(range) — total a column
  • =SUMIF(Transactions!D:D, A2, Transactions!C:C) — sum all transactions matching a category
  • =B2-C2 — calculate budget vs. actual difference

This works for basic tracking. Where it breaks down: multi-month tracking, rolling balances, category transfers, and reports over time. These require significantly more formula work.

Approach 2: Start from a template

Pre-built templates handle the formula work for you. Options range from Google’s basic built-in template to full budgeting systems:

  • Google’s built-in Monthly Budget — File → New → From template gallery → Monthly Budget. Minimal but functional.
  • Aspire Budgeting — Free zero-based envelope budget with dashboard, reports, category transfers, and multi-account support. Copy to your Drive and start.
  • Vertex42 templates — Excel-first but importable to Sheets. Various styles.
  • Community templates on Reddit — Quality varies but some are excellent.

For most people, starting from a template and customizing it beats building from scratch. You can always modify a template later — it’s just a spreadsheet.

Setting up your budget (step by step)

Regardless of approach, here’s the process:

Step 1: List your income

Write down every source of money that comes in monthly:

  • Salary (after tax)
  • Side income / freelance
  • Interest, dividends
  • Any recurring payments you receive

If your income is irregular, use the lowest typical month as your baseline.

Step 2: List your expenses

Start broad. You can refine later.

Fixed expenses (same every month):

  • Rent/mortgage
  • Car payment
  • Insurance
  • Subscriptions (streaming, gym, etc.)

Variable expenses (change monthly):

  • Groceries
  • Dining out
  • Gas/transportation
  • Entertainment
  • Clothing
  • Personal care

Periodic expenses (not monthly but predictable):

  • Car maintenance
  • Medical copays
  • Gifts/holidays
  • Annual subscriptions

For periodic expenses, divide the annual cost by 12 and budget that amount monthly. This prevents “surprise” large bills.

Step 3: Assign amounts

For each category, decide how much you want to spend. Start with fixed expenses (they’re non-negotiable), then allocate the remainder across variable categories.

If you’re doing zero-based budgeting, keep going until every dollar is assigned somewhere — including savings and debt payments. Income minus all budgeted amounts = zero.

If you’re doing simple tracking, just set rough targets and see how actuals compare.

Step 4: Track spending

As you spend money, log it. Options:

  • Manual entry — open the sheet on your phone and type it in (10 seconds per transaction)
  • Daily batch — sit down each evening and enter the day’s purchases from your bank app
  • Weekly CSV import — download a statement from your bank and paste/import transactions

The key: do it consistently. A budget you don’t update is just a wishlist.

Step 5: Review weekly

Spend 5 minutes each week checking:

  • Which categories are getting close to their limits?
  • Are there any surprises?
  • Do you need to adjust anything?

At month-end, compare budgeted vs. actual for each category. Adjust next month’s targets based on what you learned.

Tips for making it stick

Start with fewer categories. 10-15 is plenty. You can always split “Food” into “Groceries” and “Dining out” later. Too many categories upfront makes logging tedious.

Budget for fun. If you don’t allocate money for things you enjoy, the budget will feel restrictive and you’ll abandon it. “Entertainment: $100” is a feature, not a weakness.

Don’t aim for perfection month one. Your first month’s estimates will be off. That’s data, not failure. Adjust and keep going.

Use your phone. The Google Sheets mobile app makes it easy to log transactions as they happen. Pin the sheet to your home screen.

Automate what you can. If you use Aspire Budgeting with Turbo, you can import your bank’s CSV and auto-categorize transactions — getting the benefits of manual awareness without the full data-entry burden.

When to graduate from basic to advanced

You’ll know you’ve outgrown a basic spreadsheet when:

  • You want to see trends over multiple months
  • You need to track more than one bank account
  • You want to move money between categories without breaking things
  • You want automated reports (spending by category, income vs. expenses)

At that point, a purpose-built template like Aspire Budgeting fills the gap without needing to switch to a paid app. It handles multi-month history, multiple accounts, category transfers, and built-in reports — all free, all inside Google Sheets.

Getting started today

  1. Decide: build from scratch or use a template?
  2. If template: copy the free Aspire spreadsheet or open Google’s built-in template
  3. Add your income sources and expense categories
  4. Set amounts for the current month
  5. Start logging transactions

You’ll have more clarity about your finances after one week of tracking than most people get in a year of “I should probably budget.”