Aspire Budgeting

How to Build a Zero-Based Budget in Google Sheets

Build a zero-based budget in Google Sheets with three tabs and simple formulas, then learn how to assign every dollar, track spending, and adjust your plan.

By Matt Alcorn · Updated August 29, 2026

Jump to a section

To build a zero-based budget in Google Sheets, create three tabs: Categories, Transactions, and Budget. List the money you currently have, assign all of it to categories, and use SUMIF formulas to subtract transactions from each category balance. When the amount left to assign reaches zero, every available dollar has a job.

It is one of the most effective ways to take control of your money because it starts with a decision instead of an after-the-fact report. When your income minus your budgeted amounts equals zero, you’ve given every dollar a job.

This isn’t about spending everything — it’s about deciding everything. Savings, debt payments, and investments all get categories too. The point is intentionality.

This guide walks through that spreadsheet structure, the formulas behind it, and the weekly routine that keeps the budget accurate. If you want the category balances, reports, and rollover logic already built, use the free zero-based budget template for Google Sheets instead.

What is zero-based budgeting?

Traditional budgeting usually means setting rough limits (“I’ll try to spend under $500 on groceries”) and then checking at the end of the month to see how you did. Zero-based budgeting flips this around:

  1. Start with your income — How much money do you actually have right now?
  2. Assign every dollar — Rent, groceries, gas, savings, fun money — everything gets a specific allocation.
  3. Your “Available to Budget” hits zero — Not because you’re broke, but because nothing is unaccounted for.
  4. Track spending against categories — As you spend, the balance in each category decreases.
  5. Adjust as needed — Overspent on dining? Transfer from another category. The budget stays balanced.

The key insight: unassigned money gets spent unconsciously. When every dollar has a name, you make intentional decisions instead of wondering where your paycheck went.

Why Google Sheets?

You could zero-base budget with pen and paper, an app like YNAB ($14.99/month), or a spreadsheet. Here’s why Google Sheets is a strong choice:

  • Free forever — No subscription that might increase or disappear
  • Accessible anywhere — Works on your phone, tablet, and computer
  • Shareable — Budget with a partner without both needing accounts
  • You own it — Your data lives in your Google Drive, not a company’s servers
  • Flexible — Add your own formulas, charts, or columns if you want
  • Private — No third-party company has access to your financial data

The main tradeoff is no automatic bank transaction importing. You enter transactions manually. Most people who stick with spreadsheet budgeting find that this actually helps — the few seconds it takes to log a purchase keeps spending top of mind.

Build the spreadsheet in three tabs

You can make a working first version without scripts or advanced spreadsheet functions. Use these three tabs.

1. Categories

In column A, list each category name. In column B, enter its type, such as Fixed, Variable, Savings, or Debt. Keep the names unique because the Transactions and Budget tabs will use them as lookup values.

Category Type
Rent Fixed
Groceries Variable
Emergency Fund Savings

2. Transactions

Create columns for Date, Description, Amount, and Category. Enter expenses as positive numbers. Use a dropdown in the Category column so every value exactly matches the Categories tab.

Date Description Amount Category
2026-08-05 Grocery store 72.14 Groceries

3. Budget

Create columns for Category, Assigned, Spent, and Available. Copy your category names into column A, then enter the amount assigned to each category in column B.

In C2, add the transactions assigned to that category:

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

In D2, subtract spending from the assigned amount:

=B2-C2

Fill both formulas down the sheet. Enter the money you currently have in F2, then use F3 for the amount left to assign:

=$F$2-SUM($B$2:$B$100)

Extend row 100 if you use more categories. A true zero-based plan is complete when the result equals 0.

This simple version works for one budgeting period. Monthly rollovers, account reconciliation, category transfers, and historical reporting require more structure. Those are good reasons to use a maintained template, but they are not required to learn the method.

Run your first zero-based budget

Step 1: Define your categories

Think about where your money actually goes each month. Start broad — you can always split categories later. Common starting points:

  • Fixed expenses: Rent/mortgage, utilities, insurance, subscriptions
  • Variable necessities: Groceries, gas/transport, medical
  • Discretionary: Dining out, entertainment, clothing, hobbies
  • Financial goals: Emergency fund, debt payoff, retirement, vacation savings

Step 2: Enter your account balances

Add the current balances of the accounts that fund your budget. Do not include credit limits or expected future paychecks. Your starting amount should represent money you can assign today.

Step 3: Allocate your available money

Use the amount-left-to-assign cell on your Budget tab. Distribute that money across categories until the result reads zero.

If your rent is $1,500, put $1,500 in Rent. If you want to spend $400 on groceries, put $400 in Groceries. Keep going until every dollar is spoken for.

Step 4: Log transactions as they happen

When you buy groceries for $47.82, log it on the Transactions tab. The Spent formula updates automatically, and your Groceries balance drops by $47.82.

Step 5: Adjust mid-month as needed

Spent more on gas than planned? Reduce the Assigned amount for a category with surplus and add the same amount to Gas. Maybe you budgeted $100 for clothing but have not bought anything—move part of it to cover the gas overage. The total assigned stays unchanged, and you have made a conscious decision.

When a ready-made template is the better choice

The three-tab spreadsheet is enough to learn zero-based budgeting and run a simple monthly plan. A ready-made system becomes useful when you want balances to roll forward, transfers to have an audit trail, multiple accounts to reconcile, or reports to span several months.

The Aspire zero-based budget template provides those features without requiring you to design the extra formulas. The landing page shows what is included and lets you copy the spreadsheet to your Drive.

Common zero-based budgeting mistakes

Starting too specific. Don’t create 30 categories on day one. Start with 10-15 broad ones and refine after a month or two of data.

Not budgeting for irregular expenses. Annual insurance premiums, car registration, holiday gifts — divide the annual cost by 12 and budget monthly so you’re not blindsided.

Treating it as restrictive. Zero-based budgeting isn’t about denial. If coffee brings you joy, budget for coffee. The point is choosing where money goes rather than watching it vanish.

Giving up after one bad month. The first month is always rough. Your estimates will be off. That’s data, not failure. Adjust and keep going.

Zero-based vs. other methods

Method How it works Best for
Zero-based Every dollar assigned before spending People who want full control and awareness
50/30/20 50% needs, 30% wants, 20% savings People who want simple guardrails
Pay yourself first Save a fixed amount, spend the rest freely People focused primarily on savings rate
Envelope method Cash in physical envelopes People who overspend with cards

Zero-based budgeting combined with digital envelopes (like Aspire’s categories) gives you envelope-method discipline without needing to carry cash. It’s the most granular approach, which means the most control — but also the most ongoing engagement.

Getting started today

If you want a complete system rather than building the formulas yourself, review the free zero-based budget template before you start.

  1. Copy the free Aspire Budgeting spreadsheet to your Google Drive
  2. Spend 10 minutes setting up your accounts and categories
  3. Allocate your current money on the Dashboard
  4. Start logging transactions

The first month won’t be perfect — no first month ever is. But you’ll have more awareness of your money in the first week than most people get in a year of “I should probably budget.”