How to Set Up a Zero-Based Budget in Google Sheets

Maybe you tried a budgeting app and it wanted your bank login on day one. Maybe you just do not like the idea of a company reading every transaction you make. Or maybe you want a budget that works exactly the way you think, without paying a monthly fee.

A Google Sheets budget solves all 3. It is free with a Google account, it works on your phone and laptop, and nothing connects to your bank unless you choose to import a file.

This guide builds a zero-based budget from a blank sheet in about an hour. You will end up with 2 tabs: a monthly plan and a transaction log that totals itself. No add-ons, no scripts and no bank linking.

What a zero-based budget is

A zero-based budget means you give every dollar of income a job before the month starts. Income minus everything you plan to spend, save and pay off should equal exactly zero.

Zero does not mean your bank balance hits zero. Savings, emergency fund contributions and extra debt payments are all “jobs” too. The point is that no money is left unassigned, because unassigned money tends to disappear.

Here is a simple example:

Line	Amount
Monthly take-home pay	$4,200
Rent, utilities, phone and insurance	$2,050
Groceries, gas and household	$900
Debt payments	$350
Emergency fund	$400
Fun money and eating out	$300
Irregular expenses fund (car repairs, gifts)	$200
Left to assign	$0

The numbers are only an example. Your categories and amounts will be different.

Key takeaway: A zero-based budget is a plan, not a spending limit on fun. The goal is for income minus assigned dollars to equal $0, with savings and debt payoff counted as assignments.

Why use Google Sheets instead of an app

Spreadsheets and apps both work. The right choice depends on how you like to manage money.

Factor	Google Sheets budget	Typical budgeting app
Cost	Free with a Google account	Free tiers or monthly or annual subscriptions
Bank linking	None required	Usually links accounts through a data aggregator
Data privacy	Data stays in your Google Drive	Shared with the app and sometimes its partners
Transaction entry	Manual, or import a CSV file from your bank	Mostly automatic
Customization	Total control over categories and layout	Limited to the app’s design
Effort	5 to 10 minutes a few times a week	Less entry, but still needs review

Manual entry sounds like a drawback, but many people find it makes them more aware of spending. If you prefer automation, our guide on how to build a budget with an app covers that route.

Step 1: Gather your numbers

Before opening Sheets, collect:

• Take-home pay for the month, after taxes and deductions. If your income varies, use your lowest typical month.
• Fixed bills: rent or mortgage, utilities, phone, insurance, loan minimums, subscriptions
• Variable spending from the last 2 or 3 months: groceries, gas, dining out, shopping
• Irregular expenses for the year: car registration, holidays, annual subscriptions, school costs

The Consumer Financial Protection Bureau’s free Your Money, Your Goals toolkit includes a spending tracker and income tracker you can use to estimate these if you have never tracked spending.

While you are reviewing statements, look for subscriptions you forgot about. Our guide to finding and canceling subscriptions can help.

Step 2: Build the Budget tab

Create a new spreadsheet at sheets.google.com and rename the first tab “Budget.”

Set up these columns in row 1:

A	B	C	D	E
Category	Group	Planned	Actual	Remaining

Then:

1. In column A, list every category, starting with income at the top in its own section.
2. In column B, add a group for each category, such as Bills, Essentials, Savings, Debt or Fun. Groups make the plan easier to read.
3. In column C, enter your planned amount for each spending category.
4. Put your total monthly income in a cell near the top, for example cell H2, with the label “Income” in G2.
5. In G3, type “Left to assign” and in H3 enter: =H2-SUM(C2:C40)

Adjust the range to cover all your category rows. Now change planned amounts until H3 shows exactly 0. That is your zero-based plan.

Step 3: Build the Transactions tab

Add a second tab called “Transactions” with these columns:

A	B	C	D
Date	Description	Category	Amount

To keep category names consistent, add a dropdown:

1. Select column C below the header.
2. Go to Insert > Dropdown, or Data > Data validation > Add rule.
3. Choose the option to build the dropdown from a range, and select the category list in column A of your Budget tab.

Now every transaction you enter uses exactly the same spelling as your budget, which the formulas need.

Step 4: Connect actual spending with SUMIF

Back on the Budget tab, column D will total spending for each category automatically. In D2, enter:

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

Copy it down for every category. SUMIF looks through the Category column on the Transactions tab, finds rows that match the category in A2 and adds up their amounts.

In E2, enter =C2-D2 and copy it down. This shows how much is left in each category.

If you later want to total by category and date range, Google Sheets also has SUMIFS, which checks several conditions at once.

Step 5: Add simple visual warnings

Conditional formatting makes problems jump out:

1. Select the Remaining column.
2. Go to Format > Conditional formatting.
3. Set the rule to “Less than” 0 and choose a red fill.
4. Add a second rule, “Less than” 10% of planned if you like, with a yellow fill.

Also format H3, your “Left to assign” cell, so it turns red if it is anything other than 0. That reminds you to rebalance when income or plans change.

Step 6: Run the budget each month

A spreadsheet budget only works if you use it. A simple routine:

• 2 or 3 times a week: log transactions from receipts or your banking app. This takes 5 to 10 minutes.
• When you overspend: move money from another category. Lower its planned amount, raise the overspent one, and keep “Left to assign” at 0.
• End of month: right-click the Budget tab, choose Duplicate, rename it for the next month and clear the Transactions tab or start a new one.

Speed up entry without linking your bank

If typing every purchase feels slow, most banks let you download transactions as a CSV file from online banking. In Google Sheets, use File > Import to bring the file into your Transactions tab, then pick categories from the dropdown. You get some automation without giving any app access to your account.

Protect the sheet, too. Turn on 2-step verification for your Google account and avoid storing full account numbers in the spreadsheet. Our guide to banking app security settings covers similar protections for your bank.

Tips for irregular income

Zero-based budgeting works well with variable pay if you adjust the method:

1. Budget based on your lowest typical month.
2. Rank categories by priority: housing and food first, then bills, debt, savings and fun.
3. Assign extra income when it arrives, starting with a buffer fund that covers next month’s essentials.
4. Aim to live on last month’s income once your buffer is big enough.

Keep your buffer and emergency savings somewhere safe that still pays interest. Our explainer on how high-yield savings accounts work explains the options.

Conclusion

A zero-based budget in Google Sheets gives you full control with no subscription and no bank linking. Build 2 tabs, use a dropdown for categories, let SUMIF total your spending and keep “Left to assign” at zero. The first setup takes about an hour, and after that it is a few minutes a week. If you want help brainstorming categories or reviewing your plan, our guide to using AI chatbots to plan your budget shows how to do it without sharing sensitive data. This is general information, not financial advice.

Sources

• Google Docs Editors Help: SUMIF — syntax and single-criterion conditional sums
• Google Docs Editors Help: SUMIFS — sums with multiple conditions
• Google Docs Editors Help: Create an in-cell dropdown list — Insert > Dropdown and data validation from a range
• CFPB: Your Money, Your Goals toolkit — free spending tracker, income tracker and budget tools