How to Make a Budget in Google Sheets and Finally See What's Left Each Month

It's the 24th. You're at the checkout with your card out, doing math in your head. Rent went out. Did the electric? What did the weekend cost? You think you have enough. You aren't sure.

That small knot is what a budget is supposed to remove. Not by taking things away from you, but by giving you one number you can trust: what's left.

This guide shows you how to make a budget in Google Sheets that gives you that number. You can build the budget spreadsheet yourself in four steps, or skip the building with a ready-made monthly budget template. Either way, here's what you walk away with.

What changes once your monthly budget lives on one page

• One screen that shows money in, money out and money left.
• A real picture of where your money goes, instead of a rough guess.
• Bills you can see coming, instead of bills that catch you off guard.
• A short weekly check-in in place of a big monthly project.

I never actually knew where my cash was going, just a rough guess.

If that sounds familiar, you're not behind. Plenty of people have a budget planner they opened once and meant to get back to. The most common complaint about budget templates is that they're too complicated, and if other budget sheets made you feel dumb, the sheet was the problem.

So let's keep this to the part that matters. A simple budget needs three numbers: money in, money out, money left. Get those three on one page and the month stops being a guessing game.

Step 1: Put every paycheck in one place

This is where “I think I'm fine” turns into “I know what I have.” Open a blank spreadsheet in Google Sheets, name the first tab Income, then add two more tabs: Bills and Spending. On the Income tab, use three columns, Source, Date and Amount, with one row for every paycheck and one for any side income. Paid weekly, every two weeks, twice a month or monthly, it adds up the same way.

Step 2: Line up your bills so nothing sneaks up on you

On the Bills tab, use Bill, Due day and Amount. Write the due day as a plain number: rent due on the 1st is 1, electric due on the 10th is 10. Once every bill sits in one list, the “wait, what's due this week?” feeling gets a lot quieter.

Step 3: Log your spending and watch the mystery disappear

On the Spending tab, use Date, What, Category and Amount. Start with a handful of categories: groceries, transportation, dining out and everything else. Fewer categories are easier to keep up, and a few weeks in you'll know where the money goes, because it's written down.

Step 4: Let one tab give you the answer

Make a fourth tab called Summary. Type these labels in column A and these formulas in column B:

• A1 Money in, B1 =SUM(Income!C2:C50)
• A2 Money out, B2 =SUM(Bills!C2:C50)+SUM(Spending!D2:D500)
• A3 Money left, B3 =B1-B2

That's the whole payoff. Change a number anywhere and the answer changes with it. (The formulas assume the layout above: Amount in column C on Income and Bills, and in column D on Spending.)

Here's the catch, and why most budget spreadsheets get abandoned

The sheet above works. But look at what you'll want next: a budget for each category, a chart, a way to see which bills are overdue, your account balances, a clean start for next month. Each one is more formulas to write and more formulas to fix. The first time one breaks, the tab gets closed, and the “later” never comes.

That's not a discipline problem. It's a build problem. Which is why there's a shortcut.

The shortcut: a Google Sheets budget template that's already built

The Grab-and-Go Budget System is a monthly budget template with the building done for you. It's one Google Sheet with six tabs: Start Here, Income, Bills, Expenses, Accounts and Summary. You type in the white cells. The green cells hold the formulas, so you never write one.

I can't stop smiling. Even in a really expensive month, we're still going to have $250 left over. We'll have enough.

That's the kind of relief a clear “money left” number can bring. Here's what you get to see:

• Income: every paycheck and side income on its own row, so your income tracker is always current.
• Bills: add each bill's due day. Mark a bill paid, and the others show Due Soon, Overdue or Upcoming on their own.
• Expenses: a spending tracker with budget vs actual for 8 categories, and a chart that shows where it all went.
• Accounts: your balances in one total, with credit card balances subtracted.
• Summary: money in, money out, money left and how much of your income you've used.

It costs $11.99 once. No subscription and no bank login. You get a PDF access guide with your link and three steps to make your own copy, plus a backup Excel (.xlsx) copy. You'll need a free Google account, and you can log spending from the Google Sheets app on your phone. Setting it up is easiest on a computer.

When I went from the PDF to my own copy, it took under a minute, and replacing the sample numbers with my own took under 7 minutes. That was one try, and I built it, so give yourself a little longer.

If Google asks whether you really want to edit a green cell, that's the protection doing its job. Nothing is broken.

Not for: debt-payoff plans, savings-goal tracking, investing, business bookkeeping, or an app that connects to your bank. Not right for you? Email us within 30 days of buying to request a refund.

Keep it going with one small habit

For the first time it feels like I'm actually driving my money instead of just reacting to it.

That feeling comes from a weekly check-in, not from tracking everything perfectly. Pick one day. Payday and Sunday morning work for many people. Add that week's spending and look at money left. On the 1st of the month, make a fresh copy for the new month. Last month stays saved as your history.

Budget template and budget planner questions

Does Google Sheets have a budget template?

Yes. Google Sheets has a template gallery that includes budget templates, and other shops sell their own Google Sheets budget templates. If one feels like too much, look for one with fewer moving parts.

Is Google Sheets good for budgeting?

It can be. It's free, it works in a web browser, and your copy lives in your own Google Drive. The catch is the building: you write the formulas yourself, or you start from a budget template where that's already done.

What's the best way to start budgeting for beginners?

Start with the three numbers: money in, money out and money left. A budget for beginners doesn't need dozens of categories. Everything else can wait until you've finished one month.

How many categories should a budget have?

A handful. You can split a category later, but a long list is harder to keep up.

Can I use this as an expense tracker or an income and expense tracker?

Yes. The Income tab tracks what comes in, the Expenses tab tracks what goes out by category, and the Summary tab puts both together.

Is there an Excel budget template version?

The Grab-and-Go Budget System is made for Google Sheets and includes a backup Excel (.xlsx) copy with the same tabs and formulas. The green-cell protection works in Google Sheets only.

Can I use a budget spreadsheet if I'm paid every two weeks?

Yes. Give each paycheck its own row. We walk through it in how to budget with a biweekly paycheck.

Next: how to track your bills and due dates in Google Sheets.

A budgeting tool for personal use, not financial or tax advice.