📢 Disclosure: This post contains affiliate links. We may earn a commission at no extra cost to you. We only recommend products we genuinely believe in.
Learning how to use Google Sheets for budgeting is one of the most practical financial skills you can develop — and it costs absolutely nothing. Google Sheets is free, works on any device, automatically saves your work to the cloud, and gives you complete control over how your budget looks and functions. Whether you’re a complete beginner or you’ve tried budgeting apps that never stuck, this step-by-step guide will show you how to use Google Sheets for budgeting from scratch — no spreadsheet experience required.
Why Use Google Sheets for Budgeting?
There are dozens of budgeting apps and tools available in 2026 — so why choose Google Sheets? Here’s what makes it stand out:
- Completely free — no subscription, no premium tier, no hidden costs
- Works everywhere — access your budget from your phone, tablet, or any computer
- Fully customizable — build it exactly the way you want, with your categories and your layout
- Auto-saves to Google Drive — your data is never lost
- Easy to share — share with a partner or spouse in real time
- No ads, no data selling — your financial data stays private
- Simple formulas — basic math functions like SUM and IF do everything you need
If you haven’t yet decided on a budgeting method, our guides on the 50/30/20 budget rule and zero-based budgeting will help you pick the right approach before building your spreadsheet.
Step 1 — Open Google Sheets and Create a New File
To get started with how to use Google Sheets for budgeting, all you need is a free Google account.
- Go to sheets.google.com and sign in with your Google account
- Click the + Blank button to create a new spreadsheet
- Click on “Untitled spreadsheet” at the top left and rename it: “Monthly Budget — [Month] [Year]” (e.g. “Monthly Budget — June 2026”)
- Your file is now automatically saved to Google Drive — no manual saving needed
You’re now looking at a blank grid of rows and columns. Each box is called a “cell” and is identified by a letter (column) and number (row) — for example, cell A1 is the top-left corner.
Step 2 — Set Up Your Budget Categories
The foundation of your Google Sheets budget is your category structure. Here’s a proven layout that works for most people. Type each item into the cell listed:
Column Headers (Row 1)
- A1: Category
- B1: Budgeted Amount
- C1: Actual Amount
- D1: Difference
Income Section (Rows 2–5)
- A2: INCOME
- A3: Paycheck #1
- A4: Paycheck #2 (if applicable)
- A5: Other Income
- A6: TOTAL INCOME
Expenses Section (Rows 8–25)
- A8: EXPENSES
- A9: Rent / Mortgage
- A10: Utilities (electric, gas, water)
- A11: Internet / Phone
- A12: Groceries
- A13: Transportation (gas, transit)
- A14: Car Payment / Insurance
- A15: Health Insurance / Medical
- A16: Subscriptions (streaming, apps)
- A17: Dining Out / Takeout
- A18: Entertainment
- A19: Clothing / Personal Care
- A20: Debt Payments (credit cards, loans)
- A21: Savings Transfer
- A22: Emergency Fund Contribution
- A23: Miscellaneous
- A24: TOTAL EXPENSES
Summary Section (Rows 26–28)
- A26: NET (Income minus Expenses)
- A27: Savings Rate %
- A28: Status
Step 3 — Enter Your Income and Expense Amounts
In column B (Budgeted Amount), enter what you plan to spend or earn each month. Use your last 2–3 months of bank statements to get realistic numbers for each category. Common mistakes to avoid:
- Don’t underestimate groceries — most people spend 20–30% more than they think
- Include annual expenses divided by 12 (car registration, insurance renewals, holiday gifts)
- List your savings transfer as an expense — it’s money leaving your checking account on payday
- Include your emergency fund contribution as a separate line item so it’s intentional, not an afterthought
In column C (Actual Amount), you’ll fill in real numbers throughout the month as you spend. Leave this blank for now and update it weekly.
Step 4 — Add Key Formulas
This is where Google Sheets does the work for you. Here are the essential formulas to add — just click the cell and type the formula exactly as shown:
Total Income (Cell B6)
=SUM(B3:B5)This adds up all your income sources automatically. Copy this formula to C6 for actual income totals.
Total Expenses (Cell B24)
=SUM(B9:B23)This adds up all your expense categories. Copy this formula to C24 for actual expense totals.
Difference Column (Cell D9, then copy down)
=B9-C9This shows how much you’re over or under budget for each category. A positive number means under budget (good). A negative number means over budget (needs attention). Copy this formula from D9 all the way down to D23.
Net Balance (Cell B26)
=B6-B24This is your bottom line: total income minus total expenses. If positive, you’re living within your means. If negative, you’re overspending and need to adjust categories.
Savings Rate (Cell B27)
=B21/B6Format this cell as a percentage (Format → Number → Percent). This shows what percentage of your income you’re saving. The goal for most people following the 50/30/20 rule is 20% or more.
Step 5 — Format Your Budget to Make It Easy to Read
A well-formatted budget is one you’ll actually use. Here are quick formatting tips:
- Bold the header row — select row 1, press Ctrl+B
- Color section headers — highlight “INCOME”, “EXPENSES”, “NET” rows in navy or dark green to separate sections visually
- Format currency — select all number cells, go to Format → Number → Currency
- Freeze the header row — View → Freeze → 1 row, so headers stay visible when you scroll
- Color the Difference column — use conditional formatting (Format → Conditional formatting) to automatically turn positive differences green and negative ones red
Step 6 — Duplicate for Each Month
Once your first month is set up, you don’t need to start from scratch. Right-click the sheet tab at the bottom (it probably says “Sheet1”) and select “Duplicate”. Rename the new tab to the next month and clear the “Actual Amount” column (C) while keeping all your budgeted amounts and formulas. This creates a rolling monthly budget tracker in one file.
How to Use Your Budget Every Month
Building the spreadsheet is the easy part. Using it consistently is what creates results. Here’s a simple weekly routine:
- Payday: Update your income in column C, confirm your savings transfer went through, and make sure all bills are scheduled
- Every Sunday (10 minutes): Open your budget, check your bank statement, and update the “Actual Amount” column for the week’s spending
- End of month: Review your totals — which categories went over? Which came in under? Use this data to adjust next month’s budgeted amounts
This weekly review habit is one of the most powerful financial habits you can build. People who track their spending consistently spend 15–20% less than those who don’t — simply because awareness changes behavior. If you’re struggling with overspending, read our guide on how to stop living paycheck to paycheck.
Essential Google Sheets Budget Formulas Cheat Sheet
| Formula | What It Does | Where to Use It |
|---|---|---|
| =SUM(B3:B5) | Adds a range of cells together | Total income, total expenses |
| =B9-C9 | Subtracts actual from budgeted | Difference column for each category |
| =B6-B24 | Net income minus expenses | Bottom-line net balance |
| =B21/B6 | Savings as % of income | Savings rate tracker |
| =IF(B26<0,”Over Budget”,”On Track”) | Shows status based on net | Status cell (A28) |
| =AVERAGE(B9:B23) | Average monthly expense | Expense analysis |
Google Sheets Budget Tips for Beginners
- Start simple — don’t overcomplicate it. A basic income/expenses/difference layout is all you need to start.
- Use real numbers — look at your last 3 months of bank statements for accurate category averages
- Budget for irregular expenses — divide annual costs (car registration, holiday gifts, subscriptions) by 12 and include them monthly
- Track actuals weekly, not daily — daily tracking feels like a chore; weekly is sustainable
- Don’t aim for perfection — if you go over in a category, adjust and move on. The goal is awareness, not punishment.
- Add a “Savings” section — track your emergency fund balance and savings goals right in your budget. Watching the number grow is motivating.
Once your budget shows consistent monthly savings, the next step is deciding where to put that money. Read our guide on how to build an emergency fund for the recommended first destination, and our guide on debt consolidation explained if high-interest debt is your biggest monthly expense.
Frequently Asked Questions
Is Google Sheets good for budgeting?
Yes — Google Sheets is one of the best free budgeting tools available. It’s fully customizable, works on any device, automatically saves to the cloud, and uses simple formulas that anyone can learn in minutes. Unlike budgeting apps, it has no subscription fees and gives you complete control over your data.
What formulas do I need for a Google Sheets budget?
The only formulas you need to start are: =SUM() to total income and expenses, a simple subtraction (=B9-C9) to calculate the difference between budgeted and actual amounts, and =B6-B24 for your net balance. These three formulas handle 90% of what a basic monthly budget needs.
How do I make a monthly budget in Google Sheets?
Open Google Sheets, create a new blank spreadsheet, and set up four columns: Category, Budgeted Amount, Actual Amount, and Difference. List your income sources and expense categories in column A, enter your planned amounts in column B, and use SUM formulas for totals. Then update the Actual Amount column weekly as you spend.
Can I share my Google Sheets budget with my partner?
Yes. Click the “Share” button in the top right corner of Google Sheets and enter your partner’s email address. You can give them edit access so you both update the budget in real time, or view-only access if you prefer to manage it yourself and share progress. Changes sync instantly for both users.
Is Google Sheets budgeting better than budgeting apps?
It depends on your preference. Google Sheets is free, fully customizable, and private — but requires manual entry and some setup. Budgeting apps often connect to your bank automatically and require less setup, but may cost $5–$15/month and share your data with third parties. For beginners who want full control at zero cost, Google Sheets is an excellent starting point.
Final Thoughts: Your Budget Is Only as Good as Your Consistency
Knowing how to use Google Sheets for budgeting gives you a powerful, free tool — but the real value comes from using it every week. A budget you build and never look at changes nothing. A budget you review weekly and adjust monthly transforms your relationship with money over time.
Build your spreadsheet today, fill in your numbers honestly, and commit to a 10-minute weekly review. Within 30 days, you’ll have more clarity about your finances than most people get in a year. From there, use your new financial awareness to tackle the next priority — whether that’s building your emergency fund, paying off debt, or starting to invest.