Google Sheets Budget Planner: Build a Simple Monthly Budget

A practical guide to tracking income, expenses, and savings.

Quick answer: You can create a simple monthly budget in Google Sheets by recording planned and actual income, expenses, and savings transfers. The sheet helps organize the numbers you enter; it does not automatically track your bank account or guarantee that you will save money.

A budget can help you see what you expect to receive, what you plan to spend, and what actually happened during the month. This can be especially useful when freelance payments or other income vary.

This guide shows you how to build a basic planner from a blank spreadsheet. The amounts are fictional examples, not suggested budgets or results from a real household.

Note: This article is general information, not personalized financial, tax, or legal advice. Your obligations and financial needs may differ from the example.

What This Budget Planner Will Do

• Compare planned income with income actually received.
• Record planned and actual spending by category.
• Show a savings transfer separately from expenses.
• Calculate an amount remaining in the monthly plan.

This is a manual planner. It does not connect to your bank, send bill reminders, or automatically discover missing transactions. Its results are only as complete as the information you enter.

Step 1: Create a Blank Spreadsheet

1. Open Google Sheets and sign in if needed.
2. Create a blank spreadsheet and name it Monthly Budget.
3. In cells A1, B1, and C1, enter Item, Planned, and Actual.
4. Enter the labels and example values shown below.

Use numbers without currency symbols while entering the example. You can apply currency formatting afterward. Cells marked with a dash in the table should be left blank.

On a phone, scroll sideways to see all columns.

Row	Column A: Item	Column B: Planned	Column C: Actual
2	Income	—	—
3	Main income	1800	1800
4	Freelance payments	200	150
5	Total income	=SUM(B3:B4)	=SUM(C3:C4)
6	Expenses	—	—
7	Housing	800	800
8	Utilities	150	160
9	Groceries	300	320
10	Transport	150	140
11	Other	150	140
12	Total expenses	=SUM(B7:B11)	=SUM(C7:C11)
13	Savings transfer	200	100
14	Remaining	=B5-B12-B13	=C5-C12-C13

For this example, the income amounts represent money received for the month. In your own budget, account for taxes, fees, and other payments that apply to your situation.

To display amounts as currency, select the relevant cells in columns B and C, then choose Format → Number → Currency. Select the currency appropriate to your own budget.

Step 2: Check the Results

After entering the fictional example, your summary should show:

• Planned income: 2,000.
• Actual income: 1,950.
• Planned expenses: 1,550.
• Actual expenses: 1,560.
• Planned remaining: 250 after the planned savings transfer.
• Actual remaining: 290 after the actual savings transfer.

The actual remaining amount is higher in this example partly because only 100 was transferred to savings, compared with 200 planned. It does not mean the person earned more than expected.

Remaining means income minus the expenses and savings transfer recorded in this sheet. It is not necessarily your bank balance or business profit. Opening balances, unpaid bills, and transactions you have not entered are not included.

Blank cells are not proof of zero spending

The SUM formulas ignore empty cells. If you have not entered a bill yet, the sheet does not know it exists. Review your records before treating the remaining figure as money available to spend.

Step 3: Adjust the Categories to Your Life

The five expense categories are only a starting point. Your own budget might also need categories for insurance, debt payments, education, business costs, or bills that occur less often than once a month.

• Use realistic income: For variable income, distinguish money expected from money already received.
• Include irregular costs: A yearly renewal or occasional repair can still affect your plan.
• Check transfers: A transfer to your own savings account is not income; avoid counting it twice.
• Keep personal and business records clear: Freelance revenue is not automatically the same as personal take-home income.

If you add new expense rows, check that the formulas in B12 and C12 include every category. The original example only sums rows 7 through 11.

Review your categories and update them when your circumstances change.

Optional: Add a Transaction Log

If you prefer to record individual expenses, create another sheet named Transactions in the same spreadsheet. Add these headings:

• A1: Date
• B1: Category
• C1: Amount

Enter positive expense amounts in column C and use the same category names as the budget: Housing, Utilities, Groceries, Transport, and Other. For the fictional example, those category totals are 800, 160, 320, 140, and 140 respectively.

To calculate the actual Housing total from the log, enter the following formula in C7 on your budget sheet:

=SUMIF(Transactions!$B$2:$B$100,A7,Transactions!$C$2:$C$100)

Copy that formula down through C11. Each row checks its category name in column A and adds matching amounts from the Transactions sheet.

Before trying it: These formulas replace any manually entered values in C7:C11. Make a copy of your sheet and practice with fictional data first.

This formula adds matching entries from rows 2 through 100. It does not filter by date, so keep only the relevant month’s expenses in that Transactions sheet. A simple approach is to use a separate spreadsheet for each month.

Some spreadsheet locales use semicolons instead of commas between formula arguments. If you receive a formula parse error, check your spreadsheet’s locale and try replacing the separating commas with semicolons.

A Weekly Budget Review

1. Record income you actually received and expenses you actually paid.
2. Check whether any bill or transaction is still missing.
3. Compare actual spending with the planned amount for each category.
4. Review upcoming payments before deciding what the remaining amount means.
5. Update the plan if your income or costs have changed.

A budget is a record and a plan, not a guarantee that unexpected costs will disappear. If the remaining figure is negative, check the entries and upcoming obligations rather than hiding the number.

For another approach to planning, visit our separate tools site’s guide to creating a realistic personal budget.

Should You Buy a Ready-Made Template?

A template may save setup time if its categories and formulas match what you need. But a paid template is not required to make the basic sheet above.

Before buying one, check:

• Whether it works with your account and devices.
• Which categories, formulas, and instructions are included.
• Whether you can make a copy and customize it.
• The total price, support, and refund terms.
• Whether it asks you to connect an account or grant extra permissions.

Do not grant an unfamiliar template or script access to financial accounts simply because it promises automatic tracking. This guide does not recommend or claim to have tested a specific paid template.

Protect Your Financial Information

• Check the spreadsheet’s sharing settings and give access only to people who need it.
• Use a strong, unique password and additional account protection where available.
• Never put banking passwords, card security codes, or one-time login codes into the sheet.
• Do not upload private financial records to an AI service without understanding its terms and obtaining any necessary permission.
• Keep an appropriate backup of important records and check that you can access it.

Cloud access can be convenient, but it depends on your account and settings. If offline access matters, check the current Google Sheets instructions and prepare it before you lose your connection.

Frequently Asked Questions

Do I need to buy a template?

No. You can build a basic planner using the steps above. A paid template is optional; check its features and terms before purchasing.

Does this sheet import my bank transactions?

No. This guide uses manual entry. The optional transaction log adds amounts you enter yourself; it does not connect to a bank.

Is the remaining amount my bank balance?

Not necessarily. It reflects only the income, expenses, and savings transfers recorded in the sheet. It does not automatically include an opening balance or missing transactions.

Can freelancers use it?

Yes, as a simple personal planning tool. Freelancers may also need separate records for business expenses, taxes, and irregular payments. The sheet is not a replacement for professional accounting advice.

Final Thoughts

A useful budget does not need a complicated dashboard. Start with the income and expenses you can identify, review the numbers regularly, and change the categories when your needs change.

Bottom line: Record what actually happens, check for missing expenses, and treat the spreadsheet as a planning aid—not a promise of a financial result.

Further Reading

• Google Docs Editors Help — guidance on Google Sheets and its settings.
• Consumer Financial Protection Bureau: Consumer Tools — U.S. resources about financial decisions.