GoWithFund
Sign in
💳Smart Finance• Private Net Worth, Envelope Budgeting, Cashflow & Wealth Engine

How to Create A Budget in Google Sheets: Tutorial

Learn how to create a budget in Google Sheets with step-by-step instructions, formulas, and a free template. Start budgeting today.

GoWithFund Editorial Team
GoWithFund Editorial Team
••7 min read
Person creating a budget in Google Sheets on a laptop
Quick Answer

To create a budget in Google Sheets, open a blank spreadsheet, list your income and expense categories, enter your monthly numbers, and use simple formulas like =SUM() and =SUMIF() to total income, expenses, and your remaining balance. This guide walks you through each step, from setup to tracking, and includes a free template to get started fast.

🌱
Key takeaways
  • Google Sheets is a free, cloud-based tool ideal for custom budgets.
  • Set up columns for category, planned amount, actual amount, and difference.
  • Use =SUM() for totals and =SUMIF() to sum by category.
  • Track expenses regularly and adjust your budget monthly.
  • Start with a free template to save time, then customize.

How to Create a Budget in Google Sheets

To create a budget in Google Sheets, open a blank spreadsheet, list your income and expense categories, enter your monthly numbers, and use simple formulas like =SUM() and =SUMIF() to total income, expenses, and your remaining balance. This guide walks you through each step, from setup to tracking, and includes a free template to get started fast.

Key Takeaways

  • Google Sheets is free, cloud-based, and accessible from any device with a Google account.
  • A basic budget needs three sections: income, expenses, and the difference (net cash flow).
  • Use =SUM() for totals and =SUMIF() to sum by category.
  • Track expenses weekly to stay accurate and adjust as needed.
  • Start with a template if you're new, then customize categories to fit your life.

Why Use Google Sheets for Budgeting

Google Sheets is a free, cloud-based spreadsheet tool that lets you build a custom budget and access it from any device. It's ideal for beginners because it requires no software installation and saves automatically. You can share your budget with a partner or financial advisor.

Unlike dedicated budgeting apps that lock you into preset categories, Google Sheets gives you full control. You decide how detailed your categories are, what formulas to use, and how to visualize your spending. It's also easy to export data or connect to other tools if you later want more automation.

For freelancers and small teams, Google Sheets can handle variable income and shared expenses with a bit of customization. The learning curve is gentle, and there are countless free templates available online.

Setting Up Your Budget Spreadsheet

Setting up your budget spreadsheet involves creating a new Google Sheet, labeling columns for categories and amounts, and formatting it for clarity. Start by opening Google Sheets (sheets.google.com) and clicking the blank template. Name your file something like "Monthly Budget 2025" so you can find it easily.

Step 1: Create Your Column Headers

In row 1, enter headers such as Category, Planned Amount, Actual Amount, and Difference. These will organize your income and expenses. You can add a Type column to distinguish income from expenses, which helps with formulas later.

Step 2: List Your Income Sources

Under the headers, list all sources of income:salary. Enter the expected monthly amount for each. If your income varies, use a conservative estimate or the average of the last three months.

Step 3: List Your Expense Categories

List your regular expenses: rent/mortgage. Be as detailed or broad as you like. A common approach is to group expenses into fixed (same each month) and variable (changes monthly).

Step 4: Format for Readability

Use bold text for headers, add borders, and apply currency formatting to amount columns. You can also use alternating background colors for rows to make it easier to read. Freeze the header row (View > Freeze > 1 row) so it stays visible as you scroll.

Google Sheets budget spreadsheet with income and expense columns

Essential Budget Formulas

Essential budget formulas in Google Sheets include =SUM() to total income and expenses, =SUMIF() to sum by category, and simple subtraction to calculate your remaining balance. These formulas automate calculations and reduce errors. Here are the most useful ones:

  • =SUM(range) – adds up all numbers in a range.
  • =SUMIF(range, criterion, sum_range) – adds numbers that meet a condition (e.g., sum expenses for "Groceries").
  • =Income - Expenses – calculates your net cash flow.
  • =Planned - Actual – shows the difference between budgeted and actual amounts.

How to Use SUM and SUMIF

Suppose your income amounts are in B2:B5. In a cell below, type =SUM(B2:B5) to get total income. For expenses, if you have categories in column A and amounts in column B, you can use =SUMIF(A2:A100, "Groceries", B2:B100) to total grocery spending. This is handy when you have many transactions.

Calculating Your Remaining Balance

After totaling income and expenses, subtract expenses from income to get your remaining balance. For example, if total income is in cell B10 and total expenses in B20, type =B10-B20 in a new cell. A positive number means you have money left; a negative number means you're overspending.

Tip: Use conditional formatting to highlight negative balances in red so you spot overspending immediately.

Adding Categories and Tracking Expenses

Adding categories and tracking expenses means recording each transaction under the right category and updating your actual amounts regularly. This is the ongoing part of budgeting. To make it easy, set up a system for capturing expenses as they happen—whether through a mobile app, receipts, or a dedicated transactions sheet.

Create a Transactions Log

In a separate sheet (tab), create a transactions log with columns:Date. Enter each expense as you make it. Then, on your main budget sheet, use =SUMIF() to pull totals from the log by category. This keeps your budget summary up to date automatically.

Use Data Validation for Categories

To avoid typos, use data validation for the Category column. Select the column, go to Data > Data validation, and set the criteria to "List of items" with your categories. Now you can pick from a dropdown, ensuring consistency.

Review and Adjust Weekly

Set a recurring reminder to review your budget weekly. Compare actual spending to planned amounts and adjust categories if needed. For example, if you consistently overspend on dining out, increase that category and reduce another. Budgeting is iterative—it should reflect real life.

Desk with laptop and receipts for tracking expenses in Google Sheets

Free Budget Template and Tips

A free budget template in Google Sheets is a pre-built spreadsheet you can copy and customize. It saves time and ensures you don't miss key categories. You can find templates in Google Sheets' template gallery (File > New > From template) or from reputable personal finance sites. Look for one that includes income, expenses, and a summary section.

How to Use a Template

Once you find a template, click "Use template" to make a copy. Then, replace the sample numbers with your own. Check that formulas are intact and adjust categories as needed. Templates are a great starting point, but don't be afraid to modify them to fit your situation.

Tips for Budgeting Success

  • Start with a simple budget and add detail later.
  • Include a category for savings and treat it like an expense.
  • Use the 50/30/20 rule as a guideline: 50% needs, 30% wants, 20% savings.
  • Review your budget monthly and adjust for changes in income or expenses.
  • Share your budget with a partner if you have joint finances.

For those who want more automation and reporting, consider using a dedicated tool like GoWithFund's Smart Finance app, which offers budgets and cash-flow reports in one place. It can complement your Google Sheets budget or replace it as your needs grow.

Keshav Gautam
Verified E-E-A-T Author

Keshav Gautam

Director, GoWithFund Inc.

Published on behalf of GoWithFund Inc., a registered U.S. 501(c)(3) tax-exempt public charity in Idaho (EIN: 33-1243835 | Idaho SOS #5902503). Articles are reviewed for statutory compliance under IRS Internal Revenue Code Section 170.

GoWithFund Smart Finance0% Platform Fee Ecosystem

Take Control of Your Personal Wealth & Cashflow

Stop letting predatory apps sell your financial data. Enjoy instant net worth calculations, automated envelope budgeting, and 1-click CPA exports.

100% Donor Funds DeliveredInstant Stripe Direct DepositNo Monthly Retainers
Recommended Reading
Explore all Smart Finance guides
Freelancer's desk with laptop and budget notebook, illustrating budgeting for irregular income.
💳 Net Worth & Wealth
Nov 22, 2026•7 min read

Budgeting for Freelancers with Irregular Income: A System

Learn budgeting for freelancers with irregular income using a baseline budget and buffer accounts. Stabilize your finances and reduce stress.

GoWithFund Editorial Team

GoWithFund Editorial Team

Staff Contributor

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Person reviewing a personal spending plan with charts and a laptop at a home desk
💳 Net Worth & Wealth
Nov 22, 2026•10 min read

How to Build A Personal Spending Plan That Sticks

Learn how to build a personal spending plan with clear categories and a free template—then track it in GoWithFund Smart Finance.

GoWithFund Editorial Team

GoWithFund Editorial Team

Staff Contributor

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Person organizing sinking funds with labeled jars on a desk, representing planned savings categories.
💳 Net Worth & Wealth
Nov 22, 2026•7 min read

Sinking Funds for Beginners: What They Are and How to Start

Explained: what they are, real category examples, and a simple formula to set your monthly contribution.

GoWithFund Editorial Team

GoWithFund Editorial Team

Staff Contributor

Read