✦Template Printable Ideas Insights

How to Create an Easy Budget in Google Sheets

By

Budgeting is an essential aspect of personal finance, and creating one in Google Sheets can be a simple and efficient process. With its user-friendly interface and powerful tools, Google Sheets allows you to manage and track your income, expenses, and savings with ease. Here's how to make a simple budget in Google Sheets, step by step.

Before you start, make sure you have Google Sheets installed on your device. If not, you can create a new Google Sheets file online by visiting sheets.google.com and clicking on "Start a new sheet".

Setting Up Your Budget Template

To begin, let's set up a basic budget template with the main categories: income, fixed expenses, variable expenses, and savings.

Build a budget in Google Sheets in 20 minutes (free, no app)
Build a budget in Google Sheets in 20 minutes (free, no app)
How to Set Up a Budget in Google Sheets for Free
How to Set Up a Budget in Google Sheets for Free
How To Make A Budget On Google Sheets in 2026 (+ Examples)
How To Make A Budget On Google Sheets in 2026 (+ Examples)

1. In cell A1, title your sheet "Budget" and make the font size larger, so it stands out. You can do this by selecting the cell, clicking on the font size dropdown in the toolbar, and choosing a larger font size.

Adding Income and Expenses Categories

2. In row 3, starting from cell A, list your income sources (e.g., Salary, Freelance, Rental Income) and in row 5, list your fixed expenses (e.g., Rent, Utilities, Insurance). In row 7, list your variable expenses (e.g., Groceries, Dining Out, Entertainment).

Annual Budget Free Google Sheets & Excel Template
Annual Budget Free Google Sheets & Excel Template
How to Make a Budget in Google Sheets
How to Make a Budget in Google Sheets
Monthly Budget in Google Sheets Spreadsheet
Monthly Budget in Google Sheets Spreadsheet

3. In row 9, add a category called "Savings" and under it, list the types of savings you have, like Emergency Fund, Retirement, Vacation, etc.

Creating Calculations for Your Budget

4. In column B, starting from row 3, use the SUM function to calculate the total income, fixed expenses, and variable expenses. For example, in cell B3, enter the formula "=SUM(C3:C6)" and drag the formula down to cell B7 to calculate the total expenses.

5. In cell B9, enter the formula "=B2 - (B7 + B8)" to calculate the total savings. This formula subtracts the total expenses from the total income to determine how much you can save.

Step‑By‑Step Setup of a Custom Monthly Budget in Google Sheets
Step‑By‑Step Setup of a Custom Monthly Budget in Google Sheets
Free Monthly Expense Tracker - Google Sheets Template
Free Monthly Expense Tracker - Google Sheets Template
How to Make a Budget in Excel + Free Template
How to Make a Budget in Excel + Free Template
Free Google Sheets Budget Template Perfect for Beginners
Free Google Sheets Budget Template Perfect for Beginners
All-in-One Google Sheet Budget Planner for Effortless Financial Organization 📊
All-in-One Google Sheet Budget Planner for Effortless Financial Organization 📊
How to Make a Budget Spreadsheet that Works as a Beginner!
How to Make a Budget Spreadsheet that Works as a Beginner!

Tracking Your Monthly Income and Expenses

Now that you have your budget template set up, it's time to start tracking your income and expenses. You can update your sheet at the end of each month or even more frequently, depending on your preference.

Recording Income

6. In column C, starting from row 3, record the amount of income you receive from each source each month. You can use positive numbers to indicate income.

7. To keep track of your income for multiple months, insert a new row below the existing data and copy-paste the entire table to the new row. This way, you can compare your income from month to month and see any patterns or trends.

How to Make a Budget Spreadsheet
How to Make a Budget Spreadsheet
50/30/20 Budget Free Google Sheets & Excel Template
50/30/20 Budget Free Google Sheets & Excel Template
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet

Recording Expenses

8. In column C, starting from row 5, record the amount of money you spend on each expense category. Use negative numbers to indicate expenses.

9. Just like with income, insert a new row below the existing data to track your expenses for multiple months. This will help you identify areas where you can cut back on spending or adjust your budget accordingly.

Analyzing Your Budget Data

With your monthly income and expenses recorded, you can now analyze your budget data to gain insights into your spending habits and make informed decisions.

Using Pivot Tables to Analyze Your Budget

10. Select the data in your sheet, from A1 to the last row of data, and click on "Insert" in the toolbar, then "Pivot table". In the "Create a pivot table" window, choose where you want to place the pivot table and click "OK".

11. In the "Rows" section of the "Pivot table editor" window, select the date or month column (if you've been tracking your budget for multiple months). In the "Values" section, select the amount or cost column. Now, you can sort and filter your data to analyze your income and expenses in more detail.

Creating a simple budget in Google Sheets is a powerful way to take control of your finances and achieve your financial goals. By regularly updating and analyzing your budget, you can make data-driven decisions, ensure long-term financial stability, and evenUnexpected increases or decreases in income and expenses can have significant effects on your budget. To account for these changes, you can adjust your budget template and update your data accordingly. Don't forget to review your budget regularly and make any necessary adjustments to keep your financial goals on track. Happy budgeting!