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.

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.

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.







