✦Template Printable Ideas Insights

Create Simple Budget Spreadsheet with Google Sheets

By

Creating a simple budget spreadsheet is a fundamental step towards effective financial management. Google Sheets, a powerful tool in the Google Drive suite, offers an excellent platform to design and maintain your budget. Let's dive into the process of creating a simple yet functional budget spreadsheet in Google Sheets.

Before starting, ensure you have a Google account and access to Google Drive. Once logged in, open Google Drive and click on "New" in the top left corner, then select "Google Sheets" to create a new spreadsheet. Now, let's structure your budget step by step.

Setting Up Your Budget Categories

Begin by listing your income and expense categories. These serve as the foundation of your budget. Common categories include salary, freelance income, rent, utilities, groceries, dining out, entertainment, savings, and investments.

Free Monthly Expense Tracker - Google Sheets Template
Free Monthly Expense Tracker - Google Sheets Template
Annual Budget Free Google Sheets & Excel Template
Annual Budget Free Google Sheets & Excel Template
Easy Monthly Budget in Google Sheets – Free & Simple Template
Easy Monthly Budget in Google Sheets – Free & Simple Template

To create these categories, click on the cell where you want to start (e.g., A1) and type the category name. Then, drag the small square at the bottom-right corner of the cell to copy the category names down your desired number of rows.

Income Categories

Start with your income categories in the top rows. These can include your salary, side hustle earnings, rental income, or any other sources of income.

How To Make A Budget On Google Sheets in 2026 (+ Examples)
How To Make A Budget On Google Sheets in 2026 (+ Examples)
Free Monthly Budget Spreadsheet Google Sheets Template
Free Monthly Budget Spreadsheet Google Sheets Template
How to Make a Budget Spreadsheet that Works as a Beginner!
How to Make a Budget Spreadsheet that Works as a Beginner!

For instance, in cell A1, type "Income" and in A2, type "Salary". Drag the small square in the bottom-right corner to copy "Salary" down to A5, assuming you have four other income sources.

Expense Categories

Next, list your expense categories. Start these in row 6, following the income categories. Expenses can be anything from rent to leisure activities.

In cell A6, type "Expenses" and in A7, type "Rent". Drag the small square to copy "Rent" down to A16, allowing for 10 total expense categories in your budget.

How to Make a Budget in Google Sheets
How to Make a Budget in Google Sheets
50/30/20 Budget Free Google Sheets & Excel Template
50/30/20 Budget Free Google Sheets & Excel Template
Step‑By‑Step Setup of a Custom Monthly Budget in Google Sheets
Step‑By‑Step Setup of a Custom Monthly Budget in Google Sheets
Monthly Budget Planner Google Sheets Template
Monthly Budget Planner Google Sheets Template
Simple Monthly Budget Planner - Google Sheets
Simple Monthly Budget Planner - Google Sheets
How to Make a Budget Spreadsheet
How to Make a Budget Spreadsheet

Adding formulas for Calculations

Google Sheets' strength lies in its ability to perform calculations. By using a few key formulas, you can automatically update your budget as you input your income and expenses.

First, you'll want to calculate your total income and total expenses. Then, you can find out how much you have left over each month.

Calculating Total Income

In cell B17, type "=SUM(B2:B5)" to add up your income from cells B2 to B5.

Free Google Sheets Budget Template Perfect for Beginners
Free Google Sheets Budget Template Perfect for Beginners
How to Make a Budget in Excel + Free Template
How to Make a Budget in Excel + Free Template
All-in-One Google Sheet Budget Planner for Effortless Financial Organization 📊
All-in-One Google Sheet Budget Planner for Effortless Financial Organization 📊

This formula tells Google Sheets to add up all the numbers in cells B2 to B5 (assuming these are where you've listed your income). When you change any of the numbers in those cells, your total income in B17 will update automatically.

Calculating Total Expenses

In cell B18, type "=SUM(B7:B16)" to add up your expenses from cells B7 to B16.

Similarly, this formula will calculate your total expenses based on the cells you've filled out. With this, you can see a running total of your expenses.

Checking Your Balance

Finally, subtract your total expenses from your total income to find out how much money you have left each month.

In cell B19, type "=B17-B18". This will display the difference between your total income and total expenses, providing you with your available balance.

With your budget spreadsheet set up and formulas in place, you're ready to start tracking your income and expenses. Regularly update your spreadsheet to monitor your spending, make adjustments as needed, and stay on top of your budget. Happy planning!