How to Make a Budget in Google Sheets (Step by Step)

A budget in Google Sheets boils down to a list of line items, two columns of numbers, and a couple of formulas that weigh one against the other. The whole thing takes roughly five minutes to assemble, and once it's wired up the arithmetic happens automatically — at no cost. This walkthrough builds one from an empty workbook, so there's no template to download and nothing tangled to unpick. By the end you'll own a plan that draws your real outgoings from a purchase log and flushes a cell red the second you blow past target.

Step 1: Create the tabs

Open a fresh workbook at sheets.new and create two tabs along the bottom: rename the first one Budget and add a second named Transactions. The Budget tab holds your plan — one row per line item. The Transactions tab keeps a running ledger of every individual purchase. Separating the two earns its keep: your plan stays clean and readable while the ledger swells to hundreds of entries, never crowding the summary you actually glance at.

Step 2: List your income and categories

On the Budget tab, type your expected monthly take-home into cell B2 — the after-tax figure that actually reaches your account. Skip a blank row, then beginning at A5 list your buckets vertically down column A: Groceries, Rent, Transport, Dining out, and onward. Immediately to their right, in column B, enter the sum you intend to spend there this month — planned Groceries in B5, planned Rent in B6, and so forth down the rows.

Now hop to the Transactions tab and give it three headings: the date in column A, the amount in column B, and the label in column C. The single rule that bites: whatever you type into column C has to mirror the bucket names on the Budget sheet precisely — Groceries must read Groceries every time, not "groceries" or "Grocery." That exact pairing is what lets the upcoming formula locate and tally the right entries.

Step 3: Add the formulas

Three formulas turn those two lists into a live budget. Add a header in column C of the Budget sheet labelled "Actual" and one in column D for "Remaining."

First, total what you set out to spend. Below your line items, drop:

=SUM(B5:B14)

That simply adds every planned figure between B5 and B14 so you can weigh your plan against the income parked in B2.

Next comes the genuine trick — drawing real costs from the Transactions tab without lifting a finger. In C5, beside Groceries, type:

=SUMIF(Transactions!C:C,"Groceries",Transactions!B:B)

SUMIF takes three arguments, in plain English: where to look (Transactions!C:C, the entire label column on the ledger), what to look for ("Groceries", the bucket you want totalled), and what to add up (Transactions!B:B, the amounts). It sweeps every entry, isolates the ones tagged "Groceries," and sums their values. Drag that formula downward, swapping the middle argument per row — or point it at the label cell with =SUMIF(Transactions!C:C,A5,Transactions!B:B) so it adjusts itself as you fill down.

Finally, in D5, work out what remains in each bucket as =Budgeted-Actual — concretely =B5-C5. A positive result means cash is still on hand; a negative one signals you've blown past plan there.

Step 4: Add conditional formatting for overspending

Numbers are easy to skim past, so let the workbook shout for you. Highlight your Actual range (say C5:C14), then open Format → Conditional formatting. Under "Format rules," choose Custom formula is and enter:

=$C5>$B5

Set the fill to red and click Done. The dollar signs pin the references so each row's Actual gets weighed against that same row's Budgeted. From here on, the instant a recorded purchase tips a bucket beyond its target, that cell reddens unprompted — no hunting, no mental arithmetic, just a colour you can't overlook.

Step 5: Keep it updated

Here's the part the template makers never mention: none of this holds up unless you faithfully record every purchase. The formulas are flawless, yet they're only ever as truthful as the ledger feeding them. Skip a week of entries and the red cells fall silent, the remaining figures start lying, and your faith in the whole thing erodes right when you lean on it most. This is where the vast majority of spreadsheet budgets quietly die — not from a broken calculation, but from the tiny daily friction of opening the file, hunting the right tab, and keying one more line. Decide your habit now: jot each purchase the day it lands, or carve out fifteen minutes each Sunday to clear the backlog from your receipts and banking app.

Troubleshooting

Why is my SUMIF returning 0?

Almost always it's a text mismatch. The label in the second argument has to mirror what sits in your Transactions column exactly — same spelling, same capitalisation, no stray spaces. "Groceries" won't catch entries recorded as "groceries" or "Grocery." Also re-check the ranges: the search range (column C) and the sum range (column B) must aim at the right columns on the ledger tab.

How do I budget for irregular expenses?

For costs that strike once or twice a year — insurance, holidays, car repairs — don't let the bill ambush a single month. Add a sinking-fund bucket and set aside a recurring amount: divide the annual figure by twelve and stash that slice every month, so the cash is already waiting when the charge arrives.