🪺 Planful Nest
Budgeting

How to Use Google Sheets for Budgeting (Step-by-Step for Beginners)

2026-06-29

Google Sheets is one of the best free tools for budgeting, and you don't need to be a spreadsheet expert to use it. It's free, works on any device, saves automatically, and can do the math for you so you always know where your money stands. This beginner-friendly guide walks you through building a simple, working budget in Google Sheets step by step, with the exact formulas to use.

Why Google Sheets for Budgeting?

Unlike budgeting apps, Google Sheets gives you total control with zero cost and no subscription. You decide the categories, the layout, and the level of detail. It syncs across your phone and computer, so you can log a purchase the moment it happens. And because it does calculations automatically, you avoid the math errors that derail handwritten budgets. It's flexible enough to grow with you as your needs change.

Step 1: Create Your Spreadsheet

Open Google Sheets and start a blank sheet. Give it a clear name like "Monthly Budget 2026." At the top, create a few labeled rows for the month and your total monthly income, since that number anchors everything else.

Step 2: Set Up Your Income Section

In one area, list your income sources, your paycheck, any side income, and so on, with amounts next to each. Then total them with a simple formula. If your amounts are in cells B2 to B4, type =SUM(B2:B4) in the cell below to get your total income. That's your first taste of letting the sheet do the work.

Step 3: Build Your Expense Categories

Below income, create a table with three columns: Category, Budgeted, and Actual. List your categories down the left, for example:

In the Budgeted column, enter how much you plan to spend in each category this month. You'll fill in Actual as the month goes.

Step 4: Add Formulas That Do the Work

Total Your Spending

At the bottom of your Actual column, use =SUM() to add up everything you've spent. This updates automatically as you log purchases.

See What's Left

Create a cell that subtracts total expenses from total income: =TotalIncome - TotalExpenses (using the right cell references). This is your remaining money, and watching it shrink in real time is exactly the nudge that keeps you on track.

Track Each Category

Next to each category, add a column that calculates the difference: =Budgeted - Actual. A positive number means you have room left; a negative number means you've overspent and need to adjust.

Step 5: Use Color to Make It Readable

Conditional formatting turns numbers into instant signals. Highlight your difference column, open Format then Conditional formatting, and set negative numbers to turn red and positive ones green. Now a single glance tells you which categories are healthy and which need attention, no math required in the moment.

Step 6: Log Spending Consistently

A budget only works if you update it. Keep the sheet bookmarked on your phone and enter purchases as they happen, or set aside five minutes each evening. The Google Sheets app makes this easy on the go. Consistency here is the entire difference between a budget that works and one that gathers dust.

Want to Skip the Setup?

Building formulas, formatting, and dropdowns from scratch takes time, and small mistakes can throw off your totals. If you'd rather start tracking tonight, our ready-made budget spreadsheet comes with all the categories, formulas, and automatic totals already built and tested, so you just plug in your numbers and go. It works right inside Google Sheets, free to use after download.

You're Ready to Budget Smarter

You now know how to build a real budget in Google Sheets: set up income, list categories, add formulas, color-code the results, and log spending consistently. Start with this month, refine as you learn, and you'll have a free, powerful money tool that grows with you. Prefer a done-for-you head start? Grab our budget spreadsheet and have a polished system running in minutes.

Free Monthly Budget Template

Ready-to-use, beautifully designed, instant download.

Get the template →

Keep reading

← More guides on the blog