Google Sheets Monthly Budget Planner: Build It in an Hour

A monthly budget planner in Google Sheets takes about an hour to build: three tabs, one formula per category and a single cell that sets the month. This guide gives you the layout and the formulas, and covers entering purchases from a phone and sharing the sheet with a partner.

Why build a budget in Google Sheets?

A spreadsheet has no monthly fee, no required account link to your bank and no category structure imposed on you. You decide where every number lives. It also works on a phone, shares with one tap and keeps a version history if a number changes by mistake. The costs are real as well: you maintain the formulas, and nothing reminds you to open the sheet.

	Google Sheets	Paper planner	Budget app
Cost	Free	One purchase	Free to monthly fee
Math	Automatic once built	By hand	Automatic
Where the data lives	Your Google account	On paper	Depends on the app
Sharing with a partner	Easy	One copy	Varies

If you are brand new to budgeting, decide your categories first. Our beginner's guide walks through how to choose them from last month's statements.

What tabs does the sheet need?

Create three tabs in this order: Setup, Transactions and Dashboard.

• Setup holds your category list, monthly limits and income.
• Transactions is the running log: Date in column A, Category in B, Amount in C and Notes in D. One row per purchase.
• Dashboard totals the log by category for one month and compares each total with its limit.

Category list and drop-down

On Setup, list 5 to 7 categories in column A with the monthly limit in column B, for example Groceries, Eating out, Transport, Household, Health and Fun. Then select column B on the Transactions tab and choose Data, then Data validation, then Add rule. Choose "Dropdown (from a range)" and point it at the category list on Setup. Now every purchase gets a clean category pick, and "Grocery" and "Groceries" can no longer split your totals.

How do you build the Dashboard?

One month cell

In cell B1 of the Dashboard, type the first day of the month, such as 11/1/2026, and format it as a date. Every formula reads from this cell. When December starts, change B1 to 12/1/2026.

Spent, limit and left

List the categories in A4 downward, matching Setup. Then add these columns:

• B (Limit): =VLOOKUP(A4,Setup!A:B,2,FALSE)
• C (Spent): =SUMIFS(Transactions!$C$2:$C,Transactions!$B$2:$B,A4,Transactions!$A$2:$A,">="&$B$1,Transactions!$A$2:$A,"<"&EDATE($B$1,1))
• D (Left): =B4-C4
• E (Status): =IF(C4>B4,"OVER","OK")

The open-ended ranges such as C2:C mean new rows are included without editing the formula. SUMIFS keeps only transactions dated on or after the first of the month and before the first of the next, and EDATE works out that next month for you. All of these functions are documented in Google's function list.

Highlight what is over

Select the Left column and choose Format, then Conditional formatting. Add a rule that colors the cell red when the value is less than zero. That single color tells you more at a glance than any chart.

How do you track income and "left this month"?

On Setup, list each income source with its monthly amount and total them in one cell. At the top of the Dashboard, add three large cells: income, spent (=SUM(C4:C12)) and left (income minus spent). If your pay varies, enter the lowest typical month as the planned figure and treat extra as a bonus for a goal or buffer. Label the final cell "Left this month" and give it a big font, because this is the number you will check most often.

How do you enter purchases from your phone?

Install the Google Sheets app, open the Transactions tab and add a row at the bottom. The drop-down works on the phone too. If typing a row in a spreadsheet feels clumsy, you can set up a short Google Form with Date, Category and Amount questions and send its responses to the sheet. The form takes ten minutes to build, and each answer becomes a new row. Because the sheet totals by category and date, the Dashboard picks up form entries automatically as long as the columns line up.

Sharing with a partner

Use the Share button to give your partner edit access. Agree on who logs which purchases so nothing is entered twice, and use Version history under the File menu if a number changes and you want to see why. If you budget as a couple, our guide to budgeting as a couple covers joint, separate and hybrid setups.

What does a 15-minute monthly review look like?

On the first of the month, change the month cell and ask three questions about the month that just ended:

1. Which category went over, and was it a one-off or a pattern?
2. Did income match the plan, and if not, why?
3. Which single change would make next month easier?

Write the answers in a notes cell on the Dashboard. If one category went over three months in a row, raise its limit and lower another, instead of promising to try harder. Add a five-minute weekly entry session only after two clean monthly reviews, so the habit grows in stages.

What mistakes should you avoid in the first three months?

Too many categories on day one

Start with 5 to 7 categories, not 20. Every extra category is a decision at entry time, and decision fatigue is a common reason spreadsheet budgets stop in the second or third week. You can always split a category later.

Typing fixed costs from scratch each month

Rent, insurance and subscriptions repeat. Copy last month's rows for these and change only what changed. That leaves day-to-day purchases as the only entries you type.

Skipping the review

The sheet only works if you look at it. Book the monthly review on your calendar like any other appointment.

When is a spreadsheet not enough?

A sheet handles one job well: monthly money. It has no natural place for goals, home tasks or the people dates that compete for your attention. A few options if that matters to you:

• Paper & Prosperity is a free budget and debt app for iPhone, iPad, Android, Mac and the web. It uses manual entry with no bank link and shows a debt-free date.
• Empire Life Dashboard is a one-time purchase ($37 for Mac, $36.99 for Windows, with a 7-day free trial) that holds finance in one tab alongside planning, health, home, people and goals. It also uses manual entry and has no bank connection.

Pick the sheet if money is the only thing you want to track and you enjoy owning the setup. Pick an app if the upkeep is what would make you stop.

FAQ

Sources

• Google Docs Editors Help, Google Sheets function list. Covers SUMIFS, EDATE, VLOOKUP, IF and ARRAYFORMULA.
• Consumer Financial Protection Bureau, Your Money, Your Goals toolkit. Includes a cash flow budget tool for tracking income and spending.