How to Set Up a Budget in Google Sheets, Step by Step

Spreadsheets have a reputation problem. People hear “build your own budget in Google Sheets” and imagine a wall of formulas, an afternoon lost, and a file they will never open again.

It does not have to go that way. A working budget spreadsheet takes about thirty minutes to build, uses four formulas total, and costs nothing. Better still, it does exactly what you tell it to, which is more than most budgeting apps manage. No paywall appears in month three. No bank connection breaks. No company decides to shut the product down and email you about it.

This guide walks through building one from scratch. You do not need any spreadsheet experience. If you can type in a box, you can do this.

Before you start

You need a Google account and a browser. That is it. Go to sheets.google.com and click the blank spreadsheet option.

A quick note before we build from nothing. Google does offer ready-made budget templates in its template gallery, reachable from the Sheets home screen. They are decent, and if you would rather start there, go ahead. The reason I suggest building your own anyway is that you will understand every cell in it, which means you will be able to fix it and change it later. A template you do not understand becomes a template you abandon the first time something breaks.

Give the file a name at the top left. Something plain like “Budget 2026” works. Google saves automatically as you go, so there is no save button to hunt for.

Step 1: Create three tabs.

At the bottom left of the screen you will see a tab called Sheet1 and a plus sign. Click the plus twice so you have three tabs.

Right-click each one, choose Rename, and name them:

• Transactions (where you log what you spend)
• Summary (where you see how you are doing)
• Categories (a small list that keeps everything tidy)

That is the whole structure. One place for raw data, one place for the picture, one place for the settings. Resist the urge to add more tabs at this stage. Complexity is what kills spreadsheet budgets.

Step 2: Set up the Categories tab.

Click the Categories tab. In cell A1 type “Category.” Then list your spending categories down in column A, starting in A2. Something like

Rent, Utilities, Groceries, Transport, Phone and Internet, Eating Out, Shopping, Health, Entertainment, Savings, Debt Payments, Other

Keep it to around ten or twelve. Beginners almost always create too many categories, then spend more time deciding whether a coffee counts as groceries or eating out than they spend actually budgeting. If you cannot decide, merge the two.

In cell B1 type “Type,” and next to each category in column B write either “Expense” or, for any income rows, “Income.” Actually, a simpler approach: leave column B for now and add one extra row at the bottom of column A called “Income.” We will handle it in a moment.

Step 3: Build the Transactions tab.

Click the Transactions tab. In row 1, type these headers across columns A to E:

• A1: Date
• B1: Description
• C1: Category
• D1: Amount
• E1: Type

Now make row 1 stand out. Select row 1 by clicking the number 1 on the left, then click the bold button. While row 1 is still selected, go to the View menu, then Freeze, then 1 row. This keeps your headers visible when you scroll down, which sounds minor and turns out to matter a lot once you have two hundred rows.

Next, format the Amount column as currency. Click the letter D at the top to select the whole column, then go to Format, then Number, then Currency. If your currency is not the default, go to File, then Settings, and change the locale. That adjusts currency and date formats across the whole file.

Step 4: Add a dropdown for categories.

This is the single most useful thing in the build, because it stops typos. If you type “groceries” one week and “groceries” the next, your totals will quietly be wrong, and you will not notice.

Select column C by clicking the letter. C. Go to the Data menu, then Data validation, then add a rule. Under Criteria, choose “Dropdown (from a range).” In the range box, type:

=Categories!A2:A30

Click Done. Now every cell in column C has a small dropdown arrow, and you pick from your list instead of typing. If you add a category to the Categories tab later, it appears in the dropdown automatically.

Do the same for column E, but instead of a range, choose “Dropdown” and add two options manually: Income and Expense.

Step 5: Enter a few transactions.

Add five or six real transactions from the last week so you have something to work with. Date in column A, a short description in B, pick a category in C, the amount in D, and income or expense in E.

One decision to make here: enter all amounts as positive numbers and let column E tell you the direction. It is much easier than dealing with negative signs, and it makes the formulas simpler.

Step 6: Build the Summary tab.

Click Summary. This is where the spreadsheet starts earning its keep.

In row 1, type these headers:

• A1: Category
• B1: Budgeted
• C1: Spent
• D1: Remaining
• E1: Percent Used

In column A starting at A2, list the same categories you used on the Categories tab. You can type them again or use this formula in A2 to pull them across automatically:

=Categories!A2

Then drag that down. Dragging means clicking the small blue square at the bottom right corner of the cell and pulling it downward.

In column B, type what you plan to spend on each category this month. Guess if you are not sure. Your first month’s numbers will be wrong, and that is completely fine. You are building a starting point, not a prediction.

Now the important formula. Click C2 and type:

=SUMIF(Transactions!C:C, A2, Transactions!D:D)

In plain English: look down the Category column on the Transactions tab, find every row matching the category in A2, and add up the matching amounts. Press Enter, then drag C2 down alongside your category list.

In D2, type:

=B2-C2

And drag it down. That tells you how much is left in each category.

In E2, type:

=IF(B2=0, "", C2/B2)

Drag it down, then select column E and go to Format, then Number, then Percent. The IF part is there so the column stays blank rather than showing an error when you have not set a budget for something yet.

Step 7: Add the totals that actually matter.

Leave a blank row under your category list, then in column A add three labels: “Total Income,” “Total Spent,” and “Left Over.”

Next to Total Income, type:

=SUMIF(Transactions!E:E, "Income", Transactions!D:D)

Next to Total Spent:

=SUMIF(Transactions!E:E, "Expense", Transactions!D:D)

Next to Left Over, subtract the second from the first. If your Total Income is in B16 and Total Spent is in B17, that would be:

=B16-B17

Use whatever cell references your own sheet actually has. Instead of typing them, you can click the cell you want, and Sheets fills in the reference for you.

That leftover number is the one to watch. Everything else is detail.

Step 8: Make overspending visible

Numbers alone do not grab attention. Color does.

Select cells C2 down to the bottom of your Spent column. Go to Format, then Conditional formatting. In the panel that opens, change “Format cells if” to “Custom formula is” and enter:

=C2>B2

Pick a red fill color and click Done. Now any category where spending has passed the budget turns red on its own. You will see it the moment you open the file.

If you want, add a second rule with the formula =C2>B2*0.8 in amber so you get a warning before you cross the line rather than after.

Step 9: Add one chart.

Select your Category column and your Spent column together. To select two separate columns, click and drag the first, then hold Ctrl (or Cmd on a Mac) while dragging the second.

Go to Insert, then Chart. Sheets will guess at a chart type. In the panel on the right, change it to a pie chart or a bar chart, whichever you find easier to read. Drag the chart somewhere out of the way, like off to the right of your table.

One chart is enough. Resist building a dashboard. Nobody has ever stuck to a budget because it had six charts.

Step 10: Set a routine.

This is the step that decides whether any of the previous nine mattered.

Pick a fixed time. Sunday evening is popular because most people are at home and the week is ending anyway. Open the sheet, look at your bank app, and log anything from the past week that is missing. For most people this takes five to ten minutes.

Two ways to make it easier. First, install the Google Sheets mobile app so you can add a transaction on the spot when you remember one. Second, bookmark the file in your browser or pin the tab, because “I could not find it” is the reason more budgets die than any spreadsheet error.

At the end of the month, right-click the file in Google Drive and choose “Make a copy,” then rename it for the next month. Delete the old transactions from the copy, keep your budget numbers and formulas, and you are ready to go in thirty seconds. Adjust the Budgeted column based on what actually happened, not what you wish had happened.

Common problems and quick fixes

Your Spent column shows zero. Almost always a category mismatch. The text on the Transactions tab has to match the Summary tab exactly. The dropdown from Step 4 prevents this, so if it is happening, check whether some rows were typed in before you added the dropdown.

Do you see #REF! or #NAME? Usually a typo in a tab name or a deleted row that a formula was pointing at. Click the cell and read the formula carefully. Tab names in formulas are case sensitive and need an exclamation mark after them.

Your dates sort strangely. Column A is probably formatted as text. Select the column, go to Format, then Number, then Date.

You keep forgetting to log things. Try logging by bank statement instead of by memory. Once a week, open your account, scan the transaction list, and copy across anything missing. You are transcribing rather than remembering, which is far less effort.

Why this beats an app for some people

A spreadsheet has no free tier to outgrow and no subscription creeping in later. It works in any currency and any country, which matters enormously if your bank is not supported by the big budgeting apps. Nobody gets access to your bank login. And you can shape it around your actual life rather than the categories a company in another country decided were normal.

The tradeoff is honest and worth stating. Nothing is automatic. If you stop logging, it stops working, immediately and completely. Apps survive a lazy fortnight. Spreadsheets do not.

But there is a quiet benefit hidden in that flaw. Typing each expense in yourself makes you look at it. That small moment of attention is doing more work than any chart on the page.

Give it one month before you judge it. The first few weeks will feel clunky, your categories will need rearranging, and you will miss some transactions. By week four it will feel routine, and somewhere around week six most people notice they are making different decisions at the shop without consciously trying to.

That is the whole point of the exercise. The spreadsheet is just where it becomes visible.