How to Set Up a Monthly Budget Spreadsheet in Google Sheets (Step-by-Step Guide)
How to Set Up a Monthly Budget Spreadsheet in Google Sheets
Managing your personal or household finances doesn’t require expensive software. Google Sheets offers a powerful, free platform to build a fully functional monthly budget spreadsheet complete with income tracking, categorized expenses, and automatic running balance formulas. In this step-by-step guide, you’ll learn how to create a professional budget tracker from scratch.
What You’ll Need Before You Start
- A free Google account- Access to Google Sheets via sheets.google.com- A list of your income sources and typical monthly expenses- Approximately 30–45 minutes for initial setup
Step-by-Step: Building Your Monthly Budget Spreadsheet
Step 1: Create a New Spreadsheet and Set Up Sheet Tabs
Open Google Sheets and create a new blank spreadsheet. Rename it to something descriptive like “2026 Monthly Budget Tracker.” At the bottom, create three sheet tabs:
- Dashboard – for your summary overview- Income – for tracking all income sources- Expenses – for logging all spending by category
Step 2: Build the Income Tracking Sheet
Navigate to the Income tab. Set up the following column headers in Row 1:
| Column | Header | Purpose |
|---|---|---|
| A | Date | When the income was received |
| B | Source | Employer, freelance client, side hustle, etc. |
| C | Category | Salary, freelance, investment, rental, etc. |
| D | Amount | Dollar amount received |
| E | Notes | Any additional context |
=SUM(Income!D2:D)
This automatically totals all income entries regardless of how many rows you add.
Step 3: Build the Expense Tracking Sheet
Navigate to the Expenses tab and create these column headers:
| Column | Header | Purpose |
|---|---|---|
| A | Date | Date of the transaction |
| B | Description | What the expense was for |
| C | Category | Housing, Food, Transport, Utilities, etc. |
| D | Amount | Dollar amount spent |
| E | Payment Method | Cash, credit card, debit, etc. |
| F | Running Balance | Automatic running total |
=SUM(Income!D$2:D) - SUM(D$2:D2)
This formula takes your total income and subtracts all expenses up to and including the current row. For cell **F3** and below, the formula automatically adjusts as you copy it down:
=SUM(Income!D$2:D) - SUM(D$2:D3)
Select cell F2, then drag the fill handle (small blue square at the bottom-right corner) down to cover as many rows as you need. The running balance will update in real time as you add new expenses.
**Pro tip:** Use conditional formatting on column F to highlight cells in **red** when the balance drops below zero. Select column F, go to **Format > Conditional formatting**, set the rule to "Less than" with value **0**, and choose a red background.
Step 5: Build the Dashboard Summary
Navigate to the Dashboard tab and create a summary section with these key formulas:
| Cell | Label | Formula |
|---|---|---|
| A1/B1 | Total Income | =SUM(Income!D2:D) |
| A2/B2 | Total Expenses | =SUM(Expenses!D2:D) |
| A3/B3 | Net Balance | =B1-B2 |
| A4/B4 | Savings Rate | =IF(B1>0, (B1-B2)/B1, 0) |
=SUMIF(Expenses!C:C, "Groceries", Expenses!D:D)
Repeat this formula for each expense category to see exactly where your money goes each month.
Step 6: Add Visual Charts
Select your category breakdown data on the Dashboard, then click Insert > Chart. Choose a Pie chart to visualize spending distribution or a Bar chart to compare categories side by side. Google Sheets automatically updates charts as your data changes.
Step 7: Duplicate for Each Month
Once your template is complete, right-click the sheet tabs and select Duplicate. Rename each copy for the corresponding month (January, February, etc.). Clear the data but keep the formulas and formatting intact. Alternatively, keep all months in a single sheet and add a “Month” column, then use filters to view one month at a time.
Tips for Maintaining Your Budget Spreadsheet
- Update daily or weekly – Don’t let transactions pile up; smaller, frequent entries are more accurate.- Review monthly – At the end of each month, review your Dashboard to identify spending patterns.- Adjust categories – If a category consistently shows zero, remove it. If “Miscellaneous” is too large, break it into specific categories.- Use Google Sheets mobile app – Log expenses on the go directly from your phone.- Protect formulas – Right-click formula cells, select Protect range, to prevent accidental edits.
Frequently Asked Questions
Can I share my budget spreadsheet with a partner or family member?
Yes. Click the Share button in the top-right corner of Google Sheets and enter your partner’s email address. You can grant them Editor access so both of you can log income and expenses in real time. Changes sync automatically, making it ideal for joint household budgeting.
How do I handle irregular income in my budget spreadsheet?
If your income varies month to month (freelance, commissions, gig work), use the Income sheet to log each payment as it arrives. Your Dashboard formula =SUM(Income!D2:D) will dynamically total whatever has been entered. Consider budgeting based on your lowest expected monthly income and treating anything above that as a surplus to direct toward savings or debt repayment.
Is there a way to automatically import bank transactions into Google Sheets?
Google Sheets does not natively pull from bank accounts, but you can use third-party add-ons like Tiller Money which automatically imports daily bank and credit card transactions directly into your spreadsheet. Alternatively, most banks allow you to export transactions as CSV files, which you can then paste or import into your Expenses sheet using File > Import.