Google Sheets Budget Template: Free Copy + 20-Minute Setup

Hey folks, it's Ren here.

The busiest day of the month for buying a budget template is the second. Not the first. The second.

I know because I went through every order we have taken since 2023, 77,274 of them, and counted. The first three days of any month bring in a quarter more budget templates than an average three days would. Monday beats Saturday by a quarter as well. People start budgets on a fresh page, a day after they meant to.

Rebuilt September 2026 with the tab-by-tab Sheets setup, a worked household, the 50/30/20 calculator and our purchase-timing data.

Which tells you something about what a Google Sheets budget template actually has to do. It does not need to be clever. It needs to survive the third week, when the fresh page has stopped feeling fresh, and that is the whole design brief for everything below.

"A goal without a plan is just a wish." — Antoine de Saint-Exupery

📌 Is Google Sheets good for budgeting?

Google Sheets is good for budgeting because it is free, it opens on any phone or laptop, it saves every change on its own, and two people can type into the same file at the same time. Those four things cover most of what people pay a budgeting app for.

The most reliable planning tool in a lot of homes is still the calendar on the fridge. It works because it sits where everyone walks past and anyone can pick up a pen. A shared Google Sheet has the same quiet strength. The tool was never the clever part. The visibility is.

The one thing Sheets will not do is pull your bank transactions in for you. I have come to think of that as a feature. Typing "groceries, 138" is the moment you notice groceries, and automatic syncing skips that moment entirely.

🧱 How to make a budget in Google Sheets, tab by tab

A working Google Sheets budget template needs two tabs, a setup tab that holds your income and category list, and a monthly tab that logs what happened, plus a summary tab once the first two exist. Here is the build, in the order that avoids rework.

The setup tab. Cell B1 is your monthly take-home pay. Below it, a list of your categories, one per row, with a budgeted amount beside each. Keep this tab boring. It is the list everything else reads from.

The monthly tab. A header row that reads Date, Category, Description, Budgeted, Actual, Difference. Freeze it with View, then Freeze, then 1 row, so it stays put as the month fills up. Then select the Category column, open Data, then Data validation, and point the dropdown at your category list on the setup tab. That one step is what stops "Groceries", "groceries" and "food" becoming three categories by March.

The four formulas. Everything else is these.

Job	Formula	What it does
Total a column	=SUM(E2:E200)	Adds every actual amount entered this month
Spent per category	=SUMIF(B:B,"Groceries",E:E)	Adds only the rows tagged Groceries, so one category, one number
The gap	=D2-E2	Budgeted minus actual, so a negative number means over
The flag	=IF(F2<0,"Over","Under")	Turns the gap into a word you can scan in a second

Then one conditional formatting rule on the Difference column: Format, then Conditional formatting, then "Less than 0", fill it coral. Now the sheet reads itself. Anything shaded is a category to look at, and nothing else needs your attention.

To make that concrete, here is a real shaped household on 5,200 dollars a month take-home, ten categories, one ordinary month.

Category	Budgeted	Actual	Difference
Rent	$1,650	$1,650	0
Groceries	$620	$684	-64
Utilities and phone	$240	$231	+9
Transport	$310	$342	-32
Insurance	$190	$190	0
Subscriptions	$55	$68	-13
Dining out and fun	$300	$362	-62
Kids and school	$180	$140	+40
Debt repayment	$400	$400	0
Savings	$600	$600	0
Total of $5,200 take-home	$4,545	$4,667	-122

Four coral cells, 122 dollars over, and 533 dollars of the 5,200 unassigned. That last number is the interesting one, and it is where the next section comes from.

🗂️ Which categories, and what about the bills that only come once a year?

Eight to twelve broad categories cover most households, and the most common setup mistake is having twenty. If a category averages fewer than three transactions a month, merge it into a neighbour. Every extra category is a small tax on the ten seconds it takes to log a coffee, and those ten seconds are what the whole system runs on.

Category type	Examples	How to budget it
Fixed	Rent, loan repayments, insurance	Exact amount each month
Variable necessities	Groceries, fuel, utilities	Average of the last three months plus ten percent
Discretionary	Dining out, entertainment, hobbies	A deliberate limit, not a guess
Irregular	Car registration, annual fees, gifts	Annual cost divided by twelve, set aside monthly

That last row is the one that quietly decides whether the budget lives. Take the household above. Car registration and a service at 1,500 a year, home and contents insurance at 1,800, Christmas and birthdays at 900, the dentist and optometrist at 600. That is 4,800 dollars a year that appears in no monthly category, and it lands in four separate months as four separate emergencies.

Divided by twelve it is 400 dollars a month. Add a block on the setup tab called Sinking funds, one row per bill, annual amount divided by twelve, and move that 400 into a separate savings account on payday. The unassigned 533 dollars from the worked example just found its job, and the four emergencies stop being emergencies.

If you already run a budget and it keeps failing in the same month every year, please do not be hard on yourself. It is almost always a missing sinking fund, not a missing willpower.

📊 The summary tab: five numbers on one screen

A summary tab pulls the handful of figures you actually check from the monthly tabs onto one screen, so "how are we doing" takes a glance rather than a scroll. Five numbers are enough: income so far, spent so far against budget, the biggest overspend, savings rate, and the sinking funds balance.

Cell references do the pulling. ='September'!E202 brings a monthly total straight through, and once you have twelve monthly tabs the summary becomes a year at a glance without anyone retyping anything. One line of =SPARKLINE(B2:M2) beside each category draws a tiny twelve month trend inside the cell, which is the fastest way I know to spot a subscription creeping up.

Then share it. Click Share, add your partner as an editor, and agree on three things upfront: who logs what, how much either of you can spend without a conversation, and which day the weekly look happens. If you are running one file between two people, the budget spreadsheet for couples goes into the rules that keep that peaceful.

📉 When do people start a budget, and when do they stop?

People start budgets on the second day of the month and on Mondays, and the ones who keep them are the ones who stopped caring which day it was. That is not a guess. It is what 77,274 orders for our templates say when you sort them by date.

The first three days of a month account for 12.3 percent of purchases, against 9.9 percent for an average three days, a lift of about a quarter. The second of the month is the single busiest day of the thirty one. Monday takes 15.4 percent of the week's orders and Saturday 12.1, so a Monday is a quarter busier than a Saturday. And the January spike, which I wrote up in when people start budgeting, and when they quit, drops by roughly half by February every year we have looked.

Read that as a picture of how budgets fail. Everyone starts on a clean edge. The first week is tidy, the second is fine, and somewhere in the third week a bad grocery shop or a forgotten bill makes the sheet feel like a place where you get told off, and it stops being opened.

So the design goal is not a better first day. It is a survivable third week. Three things do most of that work.

• Start on whatever day it is. The first "month" can be a partial one, and the sheet does not care, but waiting for the first costs most people three weeks of momentum.
• Anchor the review to something you already do every week, Sunday coffee or Friday payday, and make it five minutes: open the summary tab, read the five numbers, close it.
• Let a bad week stay in the sheet. The people who keep budgets log the ugly week and carry on, because the coral cell is information, not a verdict.

➗ The 50/30/20 method in Google Sheets

The 50/30/20 method sends half of take-home pay to needs, thirty percent to wants and twenty percent to savings and debt, and in Google Sheets it is three formulas on top of the budget you already built. With take-home pay in B1 on the setup tab, =B1*0.5, =B1*0.3 and =B1*0.2 give you the three targets.

Then add a fourth column to the monthly tab called Type, with a dropdown of Need, Want or Save, and three SUMIF cells that subtotal each. The household above lands at 3,190 dollars of needs, which is 61 percent of take-home, a little heavy on the needs side and a useful thing to know before deciding the dining out line is the problem. The free template has this calculator built in, and the 50/30/20 budget spreadsheet guide goes deeper if the rule suits you.

⚖️ Google Sheets vs YNAB and EveryDollar

Google Sheets beats a budgeting app on cost, ownership and sharing, and loses to one on bank syncing, which is the trade-off to decide on before anything else. If EveryDollar or YNAB already keeps you consistent, stay put. For everyone else, here is the honest comparison.

	Google Sheets	Budget apps
Cost	Free	Free tiers exist, syncing and full features usually sit behind a subscription
Bank syncing	Manual entry	Automatic
Customisation	Anything you can build	The app's categories and rules
Sharing with a partner	One shared sheet, live edits	Often two accounts or a paid plan
Your data	Yours, in your Drive	On the app's servers

If you are weighing a switch, the full spreadsheet versus YNAB comparison and the EveryDollar alternative spreadsheet guide walk through rebuilding each method in Sheets, zero-based included.

🛠️ Set it up in 20 minutes

1. Put take-home pay in one cell and list your categories under it. This is the setup tab, and every other formula in the file reads from it, so build it first and keep it plain.
2. Make the monthly tab with six columns and freeze the header. Date, Category, Description, Budgeted, Actual, Difference, then View, Freeze, 1 row so the labels never scroll away.
3. Turn the Category column into a dropdown. Data, then Data validation, pointed at your category list, so the same thing is always spelled the same way.
4. Add the four formulas and one colour rule. SUM for totals, SUMIF per category, budgeted minus actual for the gap, and a conditional format that shades any negative difference coral.
5. Add a sinking funds block and move the money. Every once-a-year bill divided by twelve, with the total transferred to a separate account on payday.
6. Build the summary tab and share the file. Five cell references and a SPARKLINE per category, then Share, add your partner as an editor, and pick the weekly five minute slot.

That is the Google Sheets budget template you build yourself, and it handles the fundamentals. Here is what the fully built one looks like, the one the dashboard tab above is reaching towards.

⚠️ Mistakes that kill a Sheets budget by week three

• Typing categories instead of picking them. Fix it: a Data validation dropdown, because SUMIF cannot add up three spellings of the same word.
• Twenty categories. Fix it: merge anything under three transactions a month, since friction at the moment of logging is what ends budgets.
• Budgeting the year's bills as if they were monthly. Fix it: a sinking funds block, annual cost divided by twelve, moved on payday.
• Waiting for the first of the month to start. Fix it: start today with a partial month, because the second is already the busiest day and the third week is where the real test is.
• Reviewing when you remember to. Fix it: one calendar reminder on a day you already keep, five minutes, summary tab only.

If the spending side is what you most want to see in detail, the Google Sheets expense template guide is the transaction log on its own, and the sample household budget spreadsheet is a filled in starting point if a blank sheet is the obstacle.

🎯 Your action steps this week

• Copy the free template, or open a blank sheet and build the setup tab with your take-home pay and categories.
• Add the six column monthly tab, freeze the header, and turn Category into a dropdown.
• Write down every bill that comes less than monthly, divide each by twelve, and open a separate account for the total.
• Log this week's spending from your banking app, even though the month has already started.
• Share the file with your partner and put one five minute review in both calendars.

❓ Frequently asked questions

Is Google Sheets good for budgeting?

Yes. It is free, works on any device, saves automatically and lets two people edit the same budget at once. The trade-off is manual entry rather than bank syncing, which many people find builds better awareness of spending. The main requirement is a five minute weekly review, not any spreadsheet skill.

How do I make a budget in Google Sheets?

Put your take-home pay and a category list on a setup tab, then make a monthly tab with Date, Category, Description, Budgeted, Actual and Difference columns. Turn Category into a dropdown, add SUM and SUMIF totals, a budgeted minus actual column, and a conditional format that shades negatives. The whole build takes about 20 minutes.

Does Google Sheets have a free budget template?

Google Sheets ships with a basic monthly and annual budget in its template gallery, and plenty of free ones exist beyond that, including our Simple Budget template above, which adds a self-totaling tracker, a 50/30/20 calculator and an expenses chart. Any Google Sheets budget template works if it has a budgeted column, an actual column and a difference between them.

How do I share a Google Sheets budget with my partner?

Click Share, enter their email and give editor access, and you both edit the same file live from any device. Agree upfront on who logs what, how much either person can spend without a conversation, and which day of the week you look at the summary tab together.

The second of the month is a fine day to start a budget. So is the seventeenth, or whatever today happens to be.

Start on the day it is, and build the sheet for week three.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.