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 finances starts with a clear, well-organized budget. Google Sheets offers a free, powerful, and accessible way to build a monthly budget spreadsheet that tracks your income, fixed expenses, variable spending, and savings goals — all with automated formulas that do the heavy lifting for you. In this step-by-step guide, you’ll learn how to create a fully functional budget spreadsheet from scratch, complete with formulas that automatically calculate your remaining balance and savings progress.
What You’ll Need Before You Start
- A Google account (free)- Access to Google Sheets- A list of your monthly income sources- An estimate of your fixed and variable expenses- A savings target (optional but recommended)
Step-by-Step: Building Your Monthly Budget Spreadsheet
Step 1: Create a New Google Sheet
Open Google Sheets and click Blank spreadsheet. Rename it to something descriptive like “2026 Monthly Budget”. At the bottom of the sheet, rename the first tab to January — you’ll duplicate it later for each month.
Step 2: Set Up the Income Section
Starting in cell A1, create your income tracking area:
| Cell | Content |
|---|---|
| A1 | **INCOME** |
| A2 | Primary Salary |
| A3 | Side Income / Freelance |
| A4 | Investment Returns |
| A5 | Other Income |
| A6 | **Total Income** |
=SUM(B2:B5)
This automatically totals all your income sources.
Step 3: Create the Fixed Expenses Section
Fixed expenses are costs that stay the same each month. Starting in A8:
| Cell | Content |
|---|---|
| A8 | **FIXED EXPENSES** |
| A9 | Rent / Mortgage |
| A10 | Car Payment |
| A11 | Insurance (Health, Auto, etc.) |
| A12 | Internet / Phone |
| A13 | Subscriptions (Streaming, Software) |
| A14 | Loan Payments |
| A15 | **Total Fixed Expenses** |
=SUM(B9:B14)
Step 4: Add the Variable Spending Section
Variable expenses fluctuate month to month. Starting in A17:
| Cell | Content |
|---|---|
| A17 | **VARIABLE EXPENSES** |
| A18 | Groceries |
| A19 | Dining Out |
| A20 | Transportation / Gas |
| A21 | Entertainment |
| A22 | Shopping / Clothing |
| A23 | Personal Care |
| A24 | Miscellaneous |
| A25 | **Total Variable Expenses** |
=SUM(B18:B24)
For better control, add a **Budget** column in **C** with planned amounts and a **Difference** column in **D**. In **D18**, enter =C18-B18 and drag the formula down to **D24**. Positive values mean you're under budget; negative values signal overspending.
Step 5: Build the Savings Tracking Section
Starting in A27:
| Cell | Content |
|---|---|
| A27 | **SAVINGS** |
| A28 | Emergency Fund |
| A29 | Retirement Contributions |
| A30 | Vacation Fund |
| A31 | Other Savings Goals |
| A32 | **Total Savings** |
=SUM(B28:B31)
Step 6: Calculate the Monthly Summary
This is the most important section. Starting in A34:
| Cell | Content | Formula in Column B |
|---|---|---|
| A34 | **MONTHLY SUMMARY** | |
| A35 | Total Income | =B6 |
| A36 | Total Expenses | =B15+B25 |
| A37 | Total Savings | =B32 |
| A38 | **Remaining Balance** | =B35-B36-B37 |
| A39 | Savings Rate (%) | =IF(B35>0, B37/B35*100, 0) |
Step 7: Add Conditional Formatting for Visual Cues
- Select cell B38 (Remaining Balance).- Go to Format → Conditional formatting.- Set a rule: if the value is less than 0, format the cell with a red background.- Add another rule: if the value is greater than or equal to 0, use a green background.Repeat similar formatting for your Difference column (D18:D24) to instantly see where you’re over or under budget.
Step 8: Duplicate the Sheet for Each Month
Right-click the January tab at the bottom and select Duplicate. Rename the copy to February, and repeat for all 12 months. Each month starts with the same structure — simply update the actual amounts as the month progresses.
Step 9: Create an Annual Overview Sheet (Optional)
Add a new tab called Annual Summary. Use cross-sheet references to pull totals from each month:
=January!B6 for January’s total income, =February!B6 for February’s, and so on. Sum across all months for a yearly picture of your finances.
Pro Tips for Better Budget Management
- Use Data Validation: Restrict cells to accept only numbers to prevent accidental text entries. Go to Data → Data validation and set criteria to Number.- Freeze Header Rows: Select row 1, then go to View → Freeze → 1 row so headers remain visible while scrolling.- Use the 50/30/20 Rule: Allocate 50% of income to needs, 30% to wants, and 20% to savings. Add a formula to check:
=IF(B15/B6<=0.5, “On Track”, “Over Budget”).- Review Weekly: Set a recurring reminder to update variable expenses every Sunday to avoid month-end surprises.
Frequently Asked Questions
Can I share my budget spreadsheet with a partner or spouse?
Yes. Click the Share button in the top-right corner of Google Sheets and enter your partner’s email address. You can grant Editor access so both of you can update expenses in real time. Google Sheets supports simultaneous editing, making it ideal for household budgeting with multiple contributors.
How do I track daily expenses within a monthly budget?
Add a separate tab called Daily Log with columns for Date, Category, Description, and Amount. Then use the SUMIF formula on your monthly sheet to pull totals by category. For example, =SUMIF(‘Daily Log’!B:B, “Groceries”, ‘Daily Log’!D:D) automatically sums all grocery entries from your daily log into your monthly budget.
Is there a way to automatically import bank transactions into Google Sheets?
Google Sheets does not natively import bank transactions, but you can use third-party add-ons like Tiller Money or Plaid-based integrations to automatically pull transaction data into your sheet. Alternatively, most banks allow you to export transactions as CSV files, which you can import into Google Sheets via File → Import and then categorize manually or with formulas.