Skip to main content

Simple Budget Template for Google Sheets (Free, 2026)

A free, bare-minimum budget template for Google Sheets — income in, expenses out, money left over. No advanced tabs, plus a step-by-step guide for absolute beginners.

9 min read

Most budget templates fail beginners for the same reason: they're too much. Dozens of tabs, formulas you don't understand, and a wall of categories you'll never touch. You open it once, feel overwhelmed, and never go back. A simple budget template for Google Sheets does the opposite — it shows you the only thing that matters when you're starting out: your income, your expenses, and the money you have left over.

This guide is the bare-minimum approach. No advanced features, no jargon. Just enough structure to answer "how much money do I have left this month?" and a way to keep that number honest without a data-entry chore.

What a simple budget actually is

Strip a budget down to its core and you're left with three things:

  1. Income — the money coming in this month.
  2. Expenses — the money going out.
  3. Money left over — income minus expenses.

That's the whole model. Everything else a fancy template adds — charts, budget-vs-actual columns, quarterly views, savings goal trackers — is presentation on top of those three numbers. Useful later, but not what you need on day one.

The reason "simple" matters isn't aesthetics. It's survival. A budget only works if you keep using it, and the single biggest predictor of whether you'll keep using one is how much effort it asks for. A template with one number to enter and one number to read survives. A template with fifteen tabs gets abandoned in a week. Start with the version you won't quit.

Who a simple budget is for

You want the simplest possible budget if you are:

  • Budgeting for the first time and don't want a tutorial before you can start.
  • Someone who tried a complicated template — or a budgeting app — and bounced off it.
  • Living paycheck to paycheck and just need to see what's safe to spend before the next one.
  • Short on time, able to give a budget five minutes a week and no more.

If you already track spending in detail and want category-level trends, you'll outgrow this fast — and that's fine. The Budget Spreadsheet template and Monthly Budget template are waiting for when you're ready. But almost nobody should start there.

Why Google Sheets is the right home for it

You could budget on paper, in a notes app, or in a dedicated budgeting app. Google Sheets is the sweet spot for a simple budget for four reasons:

  • It's free. No license, no subscription to track your own money.
  • It auto-saves to the cloud. You can't lose it, and it's on every device you own.
  • It opens on your phone. The Sheets app shows the full template, so a five-second check from the couch is realistic.
  • It can update itself. Sheets connects to Avery, which imports and categorizes your bank transactions automatically — so even a simple budget can stay current without manual entry.

That last point is what separates a budget you use for one week from one you keep for a year. More on it below.

How to make a simple budget in Google Sheets (step by step)

You can build this from a blank sheet, but starting from the template means the one formula you need already works. Here's the full process either way.

Step 1: Put your income at the top

Add a single line for your monthly income — your take-home pay after tax. If you have a steady side income, add it on a second line. Use monthly figures: if you're paid every two weeks, multiply a paycheck by 2.17 to get a true monthly number instead of assuming exactly two paychecks land each month.

If your income changes from month to month, budget against your lowest recent month. Build the plan on money you can count on, and treat anything above that as a bonus to save. A simple budget has one income field, so you just update it as your situation changes.

Step 2: List a handful of expense categories

This is where most templates go wrong by giving you forty categories. Keep it to five or six broad buckets:

  • Housing (rent or mortgage)
  • Food (groceries and eating out together)
  • Transport (gas, transit, car)
  • Bills (utilities, phone, subscriptions)
  • Fun money (everything you spend on yourself)
  • Other / catch-all

That's enough to see where your money goes without the maintenance of a detailed system. You can always rename a bucket or split one out later — but resist the urge until you actually feel the need. Broad categories are a feature, not a limitation.

Step 3: Let the totals do the math

A simple budget needs exactly one piece of logic: total expenses subtracted from total income. In the template it's already wired up, so the money left over figure appears the moment you start typing. If you're building from scratch, a single =SUM() for expenses and one subtraction from income is all it takes — no other formulas required.

That leftover number is the entire point. Positive means you have room to save or spend; negative means you're overspending and one category needs to come down. You don't need a chart to read it.

Step 4: Keep it current

You have three ways to keep the expenses up to date, in increasing order of "set it and forget it":

  1. Manual entry — add each expense as it happens. Most accurate, most effort.
  2. Weekly catch-up — sit down once a week and enter the week's spending. Five minutes.
  3. Automatic sync — connect Avery and your transactions import and categorize themselves.

For a simple budget, option 2 is realistic for most people and option 3 is the one that survives a genuinely busy week — which is exactly when the budget matters most.

Step 5: Glance at it weekly

A budget you never look at is just a spreadsheet. Put two minutes on your calendar each week — Sunday evenings work well — to check the leftover number. Overspent on food? You'll see it while there's still time to ease off, not at the end of the month when it's too late. The goal is awareness and small corrections, not perfection.

A simple budgeting method to match

You don't need a complicated framework for a simple budget, but if you want a rule of thumb, the 50/30/20 rule maps perfectly onto these categories:

  • 50% needs — housing, food, transport, bills.
  • 30% wants — fun money and the catch-all.
  • 20% savings and debt — what you set aside before anything else.

Split your take-home pay into those three buckets and you have an instant sanity check: if your needs are eating 70% of your income, you've found the thing to work on. The rule isn't gospel — adjust the percentages to your reality — but it's a clean starting point that needs zero extra spreadsheet machinery.

If you'd rather give every dollar a job, zero-based budgeting works here too: keep assigning income to categories (including savings) until the leftover number hits exactly zero. The simple template supports it without any changes — you're just driving the same leftover figure down to nothing on purpose.

When to graduate from simple

A simple budget is a starting point, not a ceiling. You'll know it's time to step up when:

  • You want to track budget vs. actual by category, not just a single leftover number.
  • You want charts to see trends over several months.
  • You've split your broad buckets so many times that the simple layout feels cramped.

When that happens, move to the Budget Spreadsheet template for a fuller do-it-yourself sheet, or the Monthly Budget template for a month-by-month layout with a dashboard. Both are free, and if you're using Avery your transaction history comes with you — you're upgrading the view, not starting over.

Keeping a simple budget alive (the part that matters)

Here's the uncomfortable truth about every budget, simple or not: it dies the moment you stop entering data. The leftover number is only honest if the expenses behind it are current, and manual entry is the chore almost nobody keeps up. Even a five-minute weekly habit slips when life gets busy.

That's the gap Avery closes. Connect your bank with a read-only link and Avery:

  • Imports every transaction automatically into your sheet.
  • Categorizes each one with AI, learning your corrections over time.
  • Keeps the leftover number accurate, so the budget tells the truth even in a hectic month.

You go from "type in this week's spending" to "glance at what's left." For a simple budget — whose whole promise is low effort — that's the difference between a tool you use for a week and one you still trust in month six.

A simple budget gives you the one number that matters with the least possible effort. Start with the free template, fill in two figures, and let Avery handle the data entry so the leftover number is still telling the truth months from now — not gathering dust like every overbuilt spreadsheet before it.

FAQ

Questions readers ask

What is a simple budget?
A simple budget is the most stripped-back way to plan your money — just your income, your expenses, and what's left over. It deliberately skips charts, sub-categories, and extra tabs so it stays easy enough to actually keep using.
Is the simple budget template for Google Sheets free?
Yes. You can copy the template and use it forever at no cost. Avery's bank sync and AI categorization are an optional paid layer, but the template, categories, and totals are free.
How do I make a simple budget in Google Sheets?
Copy a template so the totals already work, type your monthly income at the top, and list your expenses under a few broad categories. The "money left over" figure calculates itself. The whole thing takes about five minutes.
How is a simple budget different from a full budget spreadsheet?
A simple budget shows income, expenses, and what's left in one view with no dashboards. A full budget spreadsheet adds budget-vs-actual tracking, charts, and more categories — useful once you've built the habit, but more than a beginner needs.
Do I need Avery to use the simple budget template?
No. The template works with manual entry in any Google account. Avery just removes the typing by syncing and categorizing your bank transactions automatically so the leftover number stays accurate.

Automate your budget in 10 minutes