Laptop showing a pink monthly budget spreadsheet in Google Sheets with charts on a tidy desk

How to Create a Monthly Budget Using Google Sheets (Step-by-Step, 2026)

Reviewed & updated: July 2026

To create a monthly budget in Google Sheets, list your monthly income at the top of a new sheet, list your expenses by category below it, and use a simple SUM formula to compare the two — the difference is what's left to save or spend. The whole setup takes about 20–30 minutes, and you don't need any spreadsheet experience.

This guide walks you through every step, from a blank sheet to a working budget — even if you've never opened Google Sheets before. And if you'd rather skip the building part entirely, we'll show you the shortcut at the end.

What you need before you start

Just three things:

  1. A free Google account — if you have Gmail, you already have one.
  2. Your income numbers — what actually lands in your account each month, after taxes.
  3. Last month's spending — open your bank app and skim last month's transactions. Rough numbers are fine; you'll refine them as you go.

That's it. No software to buy, no formulas to memorize.

Step 1: Create a new Google Sheet

  1. Go to sheets.google.com and sign in.
  2. Click the blank spreadsheet (the big plus tile).
  3. Name it something you'll recognize — click "Untitled spreadsheet" at the top left and type "My Monthly Budget".

Google Sheets saves automatically, so you never have to worry about losing your work.

Step 2: Set up your income section

  1. In cell A1, type INCOME.
  2. Below it, list each income source in column A — salary, side hustle, anything regular.
  3. Enter the monthly amount for each in column B.
  4. In the cell below your last income amount, type this formula: =SUM(B2:B4) (adjust B4 to match your last income row). This is your total monthly income.

Use your after-tax numbers — the money that actually arrives, not your gross salary.

Step 3: List your expense categories

Skip a row, then:

  1. Type EXPENSES in column A.
  2. List your categories below it. A beginner-friendly set that covers most lives:
    • Housing (rent/mortgage)
    • Utilities (electric, water, internet, phone)
    • Groceries
    • Transportation (gas, transit, insurance)
    • Debt payments
    • Subscriptions
    • Dining out & fun
    • Personal (clothes, self-care)
    • Savings
  3. Enter what you spent last month next to each category in column B.

Don't aim for perfect categories — aim for categories you'll actually recognize when logging expenses. You can always adjust later.

Step 4: Add the formulas that do the math

Only two formulas matter in a beginner budget:

  1. Total expenses: below your last expense, type =SUM(...) covering all your expense amounts — for example =SUM(B8:B16).
  2. Left to spend: in a new cell, subtract total expenses from total income — for example =B5-B17.

That "left to spend" number is your whole budget in one cell. Positive means you're living within your income. Negative means the categories above need trimming.

Step 5: Make it visual (optional but powerful)

Numbers inform; visuals motivate. To see where your money goes:

  1. Select your expense category names and their amounts.
  2. Click Insert → Chart.
  3. Google Sheets usually suggests a pie chart automatically — perfect for spending breakdowns.

Seeing that dining out is a quarter of your spending changes behavior faster than any resolution.

Step 6: Use it for a full month (this is the step everyone skips)

A budget isn't a document — it's a habit. For the next 30 days:

  • Log expenses weekly (Sunday evening works well — it takes five minutes with your bank app open).
  • Don't judge, just record. The first month is about seeing your money, not fixing it.
  • At month's end, compare plan vs. reality, adjust the categories, and copy the sheet for next month (right-click the tab → Duplicate).

Most budgets fail not because the spreadsheet was wrong, but because it was abandoned in week two. Weekly logging is the entire game.

Common beginner mistakes to avoid

  • Budgeting gross income instead of what actually hits your account.
  • Too many categories — 25 categories feels thorough but guarantees abandonment. Start with 8–10.
  • Forgetting irregular expenses — car registration, annual subscriptions, gifts. Add a "yearly costs" category and set aside a twelfth each month.
  • Treating savings as leftovers — put Savings in the expense list so it gets funded first, not with whatever remains.

The shortcut: start with a pre-built template

Building your own sheet teaches you a lot — but if you'd rather start budgeting today with the formulas, protected cells, monthly tabs, and charts already done, a pre-built template gets you there in minutes.

Our Ultimate Budget Planner is exactly this guide, professionally built: pre-built formulas you never touch, automatic charts, a tab for every month, and it works in both Google Sheets and Excel. Instant download, lifetime access, and a 30-day guarantee.

Frequently asked questions

Is Google Sheets good enough for budgeting, or do I need an app?

For most people, Google Sheets is more than enough — and better in one key way: you own and control the layout, unlike budgeting apps that force their categories on you. Apps shine at automatic bank syncing; spreadsheets shine at flexibility and privacy.

How do I access my Google Sheets budget on my phone?

Download the free Google Sheets app (iPhone or Android), sign in with the same Google account, and your budget is there. Logging an expense from your phone takes seconds.

Should I make a new spreadsheet every month?

Keep one spreadsheet and duplicate the tab each month (right-click the month's tab → Duplicate). One file, twelve tabs — you'll see your whole year in one place.

How is a monthly budget different from an expense tracker?

An expense tracker records what happened; a budget plans what should happen and then compares. The comparison — plan vs. reality — is where the insight lives. A good monthly budget spreadsheet does both.

What if my income changes every month?

Budget on your lowest typical month. Anything above it becomes a bonus you assign deliberately — extra savings, debt payments, or fun — instead of money that silently disappears.

Written by the SereneSheets team. Every template we sell is designed in-house and tested in both Google Sheets and Excel before release, with beginners as our first users in mind.

Back to blog