Cash Flow

Free Google Sheets Budget Template (and How to Use It)

By · Updated November 19, 2026
The short answer

Download our free budget template, import it with File > Import > Upload, and fill in Planned until Left to assign shows $0. Log every transaction on the Tracker tab and the Actual column fills itself in.

Like the math? New money videos on YouTube. No hype, no jargon.

Subscribe to the channel

Gemma is 34 and manages the front office at a veterinary clinic for $61,000 a year. She was paying for a budgeting app she opened about twice a month. When the renewal notice came, she canceled it and went looking for a free Google Sheets budget template instead.

What she found was either too simple (one column, no way to track what she actually spent) or too much (60 categories, five tabs of charts and formulas she was scared to touch). She wanted one thing: a plan at the start of the month, the real numbers as the month went, and a clear sign when every dollar had a job.

So we built one.

Here’s the short answer. Download our free budget template, then in Google Sheets go to File > Import > Upload and choose Create new spreadsheet. Fill in the Planned column on the Monthly Budget tab until “Left to assign” shows $0, then log every paycheck and purchase on the Tracker tab. The Actual column fills itself in.

What’s in the free Google Sheets budget template

It’s one file with four tabs, and nothing is hidden or locked:

  • Start Here: the instructions below, in short form.
  • Monthly Budget: five sections (Income, Fixed bills, Variable spending, Debts, Savings), each row with Planned, Actual and Remaining. At the top is a summary with the cell that matters most: Left to assign, which turns green at $0 and red when you’re over or under. A status line tells you in words, like “Give $50.00 more a job.”
  • Tracker: one row per transaction (date, what it was, category, amount). The category is a dropdown, so the totals can’t break because of a typo.
  • Lists: fills itself from your budget rows and feeds the dropdown. You don’t need to touch it.

It’s built as a zero-based budget, the only method we recommend: every dollar of take-home pay gets a job until nothing is left unassigned. If that idea is new, our guide to the zero-based budget explains it with a full example. The gray numbers in the file are an example month; you type over them.

The file is an .xlsx, so it also opens in Excel and Apple Numbers.

How to import the budget template into Google Sheets

You have two ways. Both take about a minute on a computer.

Option 1: Import it into a new sheet

  1. Download mmg-budget-template.xlsx.
  2. Open Google Sheets and start a blank spreadsheet.
  3. Click File > Import, then the Upload tab, and pick the file.
  4. Choose Create new spreadsheet, then click Import.

Google’s help page on importing data sets and spreadsheets lists .xlsx as a supported format and explains each import option.

Option 2: Upload it to Google Drive

Drag the file into Google Drive and double-click it. Google opens Office files right in Sheets, as its page on working with Office files explains. Then use File > Save as Google Sheets so you’re working on a true Google Sheets copy.

Do the import on a computer. After that, the Google Sheets phone app is fine for logging purchases on the go.

So what: your budget lives in your own Google account. No bank login, no subscription, nobody selling your data.

How to use it, step by step: Gemma’s first month

Gemma’s estimated take-home is about $3,892 a month: $61,000 minus 2026 federal income tax for a single filer, 7.65% for Social Security and Medicare, about 4% state tax, and the 4% she puts in her 401(k) to get the full employer match. It’s an estimate. She’s paid every two weeks, about $1,796 a check, so she budgets two paychecks a month: $3,592. The two months a year with a third paycheck get their own job; our guide to budgeting biweekly paychecks shows how.

  1. Type the month in B2 on the Monthly Budget tab.
  2. Income: enter the take-home pay you expect this month. Not your salary. Gemma enters $1,796 for Paycheck 1 and Paycheck 2. Your 401(k) match already came out of your paycheck, so it isn’t a row.
  3. Fixed bills: rent, insurance, utilities, phone, subscriptions. Use last month’s real bills.
  4. Debts: every minimum payment, plus any extra on the one you’re attacking.
  5. Savings: the step you’re on. Gemma has a credit card, a car loan and a student loan, so her savings row is a $2,000 starter cushion, plus $120 a month in sinking funds for gifts, car registration and vet bills for her own dog. The Investing row stays at $0 while she has any non-mortgage debt, per the Middle Money Ladder.
  6. Variable spending: groceries, gas, eating out, fun money. Keep some fun in there.
  7. Watch Left to assign. Move dollars between rows until it hits $0 and turns green.
  8. Log everything on the Tracker as it happens, or once a week from your bank app. Every amount is a positive number; the category decides where it goes.

Here’s Gemma’s plan, by section:

Section Planned
Income (two paychecks) $3,592
Fixed bills (rent $950, renters insurance, utilities, phone, car insurance, subscriptions) $1,360
Variable spending (groceries $380, gas, eating out, household, pet, fun money) $970
Debts (card, car loan, student loan minimums) $605
Savings (starter cushion $537, sinking funds $120) $657
Left to assign $0

Ten days into November, the example rows on her Tracker show $1,683.50 gone out and one paycheck in. Groceries show $196.65 spent of $380, so the Remaining column says $183.35 is left for the rest of the month. That’s the whole point: she knows on the 10th, not the 31st.

So what: at $537 a month, Gemma’s starter cushion is full in about four months. Then that money rolls onto her debts, one at a time.

Google Sheets budget tutorial: build the core formulas yourself

Want to build your own, or understand ours before you trust it? These five pieces are the whole engine. Cell references match our template.

1. Actual from the Tracker (SUMIF)

In the Actual column next to “Groceries” (row 30 in our file):

=SUMIF(Tracker!$C$2:$C$1000, A30, Tracker!$D$2:$D$1000)

In plain words: look down the Tracker’s Category column, and add up the Amount on every row where the category matches this row’s name. The dollar signs lock the Tracker range so you can copy the formula down without it sliding.

2. Remaining

=B30-C30 (Planned minus Actual). For spending, it’s what’s left in that row. For income, it’s pay you’re still expecting.

3. Section totals and Left to assign

Each section ends with a total like =SUM(B30:B37). The summary adds all the “going out” totals into one cell (B6), and Left to assign is simply =B5-B6: planned income minus every planned job.

4. A status line in words

=IF(ROUND(B7,2)=0, "Every dollar has a job", IF(B7>0, "Give "&TEXT(B7,"$#,##0.00")&" more a job", "Over plan by "&TEXT(-B7,"$#,##0.00")))

ROUND keeps a stray fraction of a cent from showing “not zero.”

5. The category dropdown and the green light

Select the Tracker’s Category column, then Data > Data validation > Add rule, choose Dropdown (from a range) and enter =Lists!$A$2:$A$29. For the green light, select B7, then Format > Conditional formatting, choose Custom formula is and enter =ROUND($B$7,2)=0 with a green fill. Add a second rule with <>0 and a red fill.

One more check we added: =SUM(Tracker!$D$2:$D$1000)-(C5+C6). It should always be $0. If it isn’t, a Tracker row has a blank or misspelled category, so that money isn’t counted anywhere.

So what: you don’t need to know spreadsheets to use the template, but knowing these five formulas means you can fix or change anything in it.

Tips that keep a Google Sheets budget tracker alive

  • Get your categories from real statements. Before you trust the template’s rows, pull three months of bank statements. In our podcast episode on knowing your numbers, that’s how you find the gym you don’t use and the three streaming services for one show. Our spending tracking guide has the one-evening method.
  • Check it for 15 minutes every Sunday. A spreadsheet doesn’t fail; people stop opening it. In our video on budgeting without feeling broke, the app, the spreadsheet and the cute notebook all tend to die around week three. The fix is a Sunday alarm called “money meeting.” In the video, it goes off at 7 p.m., right after dinner.
  • Balance the weeks, not just the month. If rent, the car payment and your phone all leave in week one, note the due dates in the Notes column and ask a lender to move one. The same video shows how one four-minute call fixed a couple’s worst week.
  • Every row gets a real number. In our podcast episode on giving every dollar a job, each job gets its own row with “a real number, not a little,” including a row for the emergency fund even if it’s only $50 to start.
  • New month, new tab. Right-click the Monthly Budget tab, choose Duplicate, rename it, and build the plan from zero instead of copying last month’s numbers.
  • Budgeting with a partner? Share the sheet with edit access and do the Sunday check together. Our guide to budgeting as a couple covers splitting bills.

If you know you won’t keep a spreadsheet open every Sunday, an app can carry more of the structure. Hoarding Wealth, our podcast sponsor, uses the same Planned and Actual setup as this template and closes the month when every item is done. Their guide to building a budget template in Google Sheets is honest about where a spreadsheet falls short. We compared it with five other apps in the best budgeting apps.

Run your own numbers

Copy the balances, rates and minimums from your Debts rows to see your debt-free date. Try the free debt payoff calculator.

Your debts

What to do this week

  1. Download the template and import it into Google Sheets (File > Import > Upload).
  2. Delete the gray example rows on the Tracker and type your own month in B2.
  3. Fill in Planned for every row using your last bank statement, and keep adjusting until Left to assign shows $0.
  4. Log every transaction from the 1st of this month so far.
  5. Set a Sunday alarm for a 15-minute check, and put the Sheets app on your phone’s home screen.

Frequently asked questions

Does Google Sheets have a budget template?

Yes. Google Sheets has a few built-in budget templates in its template gallery (File > New > From template gallery). They’re fine for simple tracking, but they aren’t built around a zero-based plan, which is why we made ours with a Left to assign cell and a category dropdown.

Can I use this budget template in Excel?

Yes. It’s a standard .xlsx file with ordinary formulas (SUM, SUMIF, IF), so it works in Excel, Google Sheets and most other spreadsheet apps.

How do I make a budget tracker in Google Sheets?

Make one tab with your categories and a Planned column, and a second tab where you log each transaction with a category. Then use SUMIF on the first tab to add up each category’s spending from the second. Our template does exactly that, if you’d rather not start from scratch.

How do I add a new category to the template?

Insert a row inside the right section on the Monthly Budget tab, type the name, and copy the Actual and Remaining formulas from the row above. Then add a matching line on the Lists tab so it shows up in the Tracker dropdown.

Is it safe to keep my budget in Google Sheets?

For a budget, generally yes, as long as your Google account is protected with a strong password and 2-step verification. Don’t store account numbers, passwords or your Social Security number in the sheet. Category totals and amounts are all you need.

Keep reading

Education, not financial advice. The numbers here are examples; talk to a licensed professional about your own situation. Some links may be sponsored or affiliate links; see our disclosure.

The Middle Money Guy, illustrated host of The Middle Memo newsletter

THE MIDDLE MEMO

One money decision. One number worth knowing. One mindset shift. In your inbox every week, free, in about four minutes of reading.

No spam, no hype. Unsubscribe anytime.