What a good Google Sheets budget template needs

A good budget template in Google Sheets needs four things: your monthly take-home pay at the top, a list of every planned expense, saving and debt payment, a Planned column and an Actual column side by side, and one cell that shows how much money is still without a job. When that last cell reads zero, every dollar has a job.

You can build it in about 20 minutes, it costs nothing, and you can shape it exactly the way you want. Below are the columns, the formulas and a full example month, so you can make your own today. After that, we are honest about where a spreadsheet tends to break down, and what to do if it does.

Set up the sheet: columns and rows

Open a blank Google Sheet and name it with the month, for example “Budget November”. In row 1, type these headings: Category in column A, Item in column B, Planned in column C, Actual in column D and Difference in column E.

In row 2, type Income in column A, Take-home pay in column B, and your monthly take-home pay in column C. Use the amount that actually lands in your account after taxes and deductions, not your salary. If you have more than one paycheck or side income, give each its own row. Not sure what counts? This guide to types of income sources helps you list them all.

Leave a blank row, then list your spending in groups, one item per row. A simple order works best: Giving (if you give), Saving (starter buffer, emergency fund, sinking funds), Housing (rent or mortgage, utilities), Transportation (car payment, gas, insurance), Food (groceries, eating out), Debt (every minimum payment, plus any extra), Personal (phone, subscriptions, clothes) and Other.

Put saving near the top on purpose. If saving sits at the bottom, it only gets what is left, and there is rarely anything left.

The formulas that make it work

Total income. Below your income rows, add a cell called Total income with =SUM(C2:C3), adjusting the range to cover every income row.

Total planned. At the bottom of your spending list, add Total planned with =SUM(C6:C40), covering every spending row. Add Total actual next to it in column D with the same range.

Left to plan. This is the most important cell in the sheet. Type =C4-C41 (total income minus total planned, using your own cell addresses). Color it so you notice it. This is the zero-based budget rule in one cell: keep adjusting your planned amounts until it shows exactly 0.

Difference per line. In column E, type =C6-D6 on the first spending row and drag it down. A positive number means you spent less than planned on that line. A negative number means you went over.

Optional: use Format, then Conditional formatting, to turn negative differences red. Then you can see at a glance which lines need attention.

An example month in the template

Here is an example. A single parent takes home $3,600 a month. The numbers are made up but realistic. Planned: rent $1,350, utilities and internet $220, phone $60, car insurance $120, gas $160, groceries $520, childcare $450, credit card minimum $90, starter buffer $200, sinking fund for car repairs and school costs $100, personal and kids’ extras $180, eating out $80, subscriptions $40, gifts and birthdays $30.

Add them up: $3,600. Total income minus total planned is $0. Every dollar has a job before the month starts.

During the month, she types what she really spends in the Actual column. Groceries come to $560, $40 over. Eating out comes to $50, $30 under. At the end of the month, she checks the Difference column, notes what happened, and starts next month’s copy with better numbers. Most budgets take two or three months to feel right, so a few red cells early on are normal.

Where a spreadsheet budget usually breaks

A Google Sheets budget is a real tool, and some people use one happily for years. But most spreadsheet budgets fail for the same few reasons, and none of them has to do with formulas.

Nobody tells you what to do next. The sheet shows numbers, but it does not tell you whether to build a buffer, pay off the card or start investing. You have to bring the plan yourself, in the right order.

It is easy to stop opening it. Typing into small cells on a phone is awkward, so many people stop recording spending by the second week. A budget nobody updates turns into a plan on paper that fails in real life.

Formulas break quietly. One deleted row or a total that misses a new line, and the sheet shows the wrong number without warning. You find out when the bank balance doesn’t match.

Months don’t connect. Each month is a new copy, so progress on goals, debts and savings is hard to see. Couples sharing one sheet also run into edits that overwrite each other.

No spreadsheet knows your habits. If you spend after a stressful day or avoid looking at your account, the template can’t help with that. Understanding your pattern matters as much as the math.

The same method in Hoarding Wealth, without the setup

Hoarding Wealth uses the same zero-based method as the template above, with the setup already done. You enter your take-home pay and plan your month line by line, and the app shows what is left to plan until it reaches zero.

During the month you record Actual amounts next to Planned, and at the end you close the month and start the next one.

Be clear about one thing: like a spreadsheet, Hoarding Wealth does not connect to your bank. You type your own numbers. What it adds is everything a sheet can’t do on its own: a budget score that shows how well your plan held up, a Wealth Path that tells you which step comes next (buffer, debt, emergency fund, investing), goals, short lessons, Wealth Coach to answer questions, and the full app in English and Spanish.

The free plan includes the zero-based budget for the current month with one income source, one goal and the lessons. If you are tired of fixing formulas, or you want a plan and not just a sheet, you can start for free here.

Not sure which tool fits you? Our honest guide to the best budgeting apps for families compares several options, spreadsheets included.

And if you want to know why your past budgets didn’t stick, the free Money Personality assessment takes a few minutes and shows your money pattern.

Frequently asked questions

Does Google Sheets have a free budget template?

Yes. Google Sheets includes a few budget templates in its template gallery, and you can also build your own in about 20 minutes with the columns and formulas in this article.

What is the best formula for a budget spreadsheet?

The key formula is total income minus total planned. Keep adjusting your planned amounts until that cell shows zero, so every dollar has a job.

Should I use a spreadsheet or a budgeting app?

A spreadsheet suits people who enjoy building and maintaining their own system. An app suits people who want the setup done, an easier way to record spending on a phone, and guidance on what to do next.

Does Hoarding Wealth connect to my bank like some apps?

No. Like a spreadsheet, you type your own numbers. It never connects to your bank or moves money.