Google Sheets Budget Spreadsheet: Setup and Formulas

A Google Sheets budget spreadsheet is a reusable table for recording income, planned spending, and actual spending, with formulas that total the figures and show what remains. Start with a blank sheet or a template, create columns for categories, budgeted amounts, and actual amounts, then add simple SUM formulas to calculate totals.

What a Google Sheets budget spreadsheet does

A budget spreadsheet makes it easier to compare the money you expect to receive and spend with what actually happens. Unlike a bank account, it does not automatically know every transaction unless you enter or import the information. That manual step can be useful: reviewing purchases by category helps you notice patterns, but it also means the sheet is only as current as its entries.

A practical monthly budget usually includes:

Income: take-home pay and other money expected during the month.
Planned spending: an amount assigned to each expense category.
Actual spending: what you paid, entered as transactions occur or summarized later.
Remaining amount: income minus actual expenses, including any savings goal you choose to track.

It is a planning and record-keeping tool, not a guarantee that an estimate will match future bills. Use amounts and categories that reflect your own situation, and distinguish take-home income from gross pay so the comparison is meaningful.

Choose a template or start with a blank sheet

In a web browser, open Google Sheets and look for the Template gallery on the Sheets start page. Templates can provide a preformatted starting point, though the gallery and available designs may change. Review a template before entering personal figures: remove categories you do not use, check how its totals are calculated, and make sure its date range matches your budgeting period.

A blank spreadsheet is often easier to understand if you want a straightforward monthly tracker. To create one, open Sheets, choose a blank spreadsheet, and give it a clear name such as “Monthly Budget.” Name the sheet tab for the month, or use a general name such as “Budget” if you intend to reuse it. In either case, keep a separate untouched copy of a template if you may want to return to the original layout.

Choose a design based on how you will maintain it, rather than how elaborate it looks. A transaction-by-transaction ledger offers detail but requires more regular entry. A monthly category summary takes less maintenance but may not explain why a category went over budget.

Set up useful columns and categories

One simple layout puts income near the top and expenses below. For example, enter income labels in A5:A6 and amounts in B5:B6. Use a total row beneath them. For expenses, put category names in A10:A15, planned amounts in C10:C15, and actual amounts in D10:D15. Column B can be left blank as a spacer, or used for notes. Add totals beneath the expense rows and label every section clearly.

For a sample month, the income entries might be $3,200 in take-home pay and $400 in other income. Expense categories could include rent, utilities, groceries, transport, phone, and savings. A savings transfer is not a bill in the same sense as rent, but including it as a planned category can help show whether you set that money aside.

Keep categories specific enough to guide decisions but not so detailed that logging becomes a chore. “Food” may be sufficient for a quick overview; separate grocery and restaurant categories can be more revealing if that distinction matters to you. Use consistent names month to month so comparisons are easier.

Add totals, remaining money, and variance formulas

Google Sheets recalculates formulas when their referenced values change. In the examples below, enter the formula in the stated cell. The sample totals assume the illustrative amounts in the layout; your results will differ if you enter different figures.

With income amounts in B5:B6 ($3,200 and $400), enter =SUM(B5:B6) in B7. The result is $3,600.
With planned expenses in C10:C15 of $1,400, $180, $450, $160, $60, and $300, enter =SUM(C10:C15) in C16. The result is $2,550.
With actual expenses in D10:D15 of $1,400, $195, $470, $145, $60, and $300, enter =SUM(D10:D15) in D16. The result is $2,570.
With total income in B7 and total actual expenses in D16, enter =B7-D16 in B8. The result is $1,030 remaining ($3,600 minus $2,570).
With groceries planned in C12 at $450 and actual groceries in D12 at $470, enter =D12-C12 in E12. The result is $20 over budget. Using actual minus planned means a positive variance is over budget and a negative one is under.

Keep the meaning of each calculation visible in its label. “Remaining after actual expenses” is clearer than a bare “Balance,” which might be mistaken for a bank balance. If a formula displays as text, check that the cell is not formatted as plain text and that the entry begins with an equals sign.

Make the sheet easier to update

For a transaction-level budget, add a second sheet tab named “Transactions” with columns for date, description, category, and amount. Enter one purchase or income item per row, then summarize the transactions by category in the monthly budget. This gives you a record to review while keeping the summary readable. It also takes more effort than entering one monthly total per category, so choose the level of detail you can maintain.

Google Sheets includes features that can reduce mistakes and make a sheet easier to scan:

Use Format > Number to display amounts as currency, and format date entries as dates.
Use Format > Conditional formatting to highlight over-budget values, such as positive amounts in a variance column. Set the range and rule to match your layout.
Use Data > Data validation to create a dropdown for transaction categories, helping keep labels consistent.
Use View > Freeze to keep a heading row visible while scrolling through a longer transaction list.
Select a data range and choose Insert > Chart if a visual comparison of planned and actual spending would be useful. Check that the selected range includes the intended labels and values.

Formatting improves readability, but color alone should not carry essential meaning. Keep headings and labels so the sheet remains understandable when printed, viewed on a small screen, or used by someone who does not distinguish the colors you chose.

Organize months and review the results

You can duplicate a monthly tab and rename it for the next month, or create one tab for each month. Duplicating is convenient, but check that the copied formulas still point to the intended cells and clear last month’s actual entries before using the new tab. A separate yearly summary can collect the monthly totals, but make its references explicit and verify that each month is included once.

Compare like with like. If a category has three grocery transactions entered but several are missing, its actual total is not a reliable comparison with the planned amount. Also account for timing: a bill paid this month for a prior period can make a single month look unusual. Notes beside exceptional items can preserve useful context without changing the arithmetic.

At month-end, check that income and expenses are complete, review categories with the largest differences, and adjust future estimates where appropriate. A budget is most useful as a feedback loop: plan, record, compare, and revise. It should not be treated as proof that an expense is affordable or as a substitute for checking account records.

Sharing, privacy, and cost

Google Sheets supports collaboration through its sharing controls. Use the Share button to choose who can access a file and whether they can view, comment, or edit it. For a household budget, consider whether each person needs editing access or whether some people only need to view the summary. Review access when circumstances change, and avoid putting account passwords, full payment-card numbers, or other authentication details in a spreadsheet.

Google Sheets is available through a Google Account, and Google Workspace also offers Sheets as part of its services. Workspace plans and features can vary; check Google’s current plan details rather than assuming a particular subscription is required. Files use Google Drive storage, so storage availability and account settings may matter, especially if the account contains many other files. Offline access depends on Google’s supported settings and device configuration; do not assume a file will be available without a connection unless you have enabled and confirmed offline use.

A shared spreadsheet can expose sensitive household information if its permissions are too broad. Prefer restricted access over a public link, and remember that anyone with editing permission can change cells or formulas. Keep a backup or version history available before making extensive changes.

Common mistakes and how Sheets differs from Excel

Frequent problems include entering actual costs in the planned column, forgetting a transaction, overwriting a total formula, and copying a tab without clearing old figures. Protect important formulas from accidental edits where appropriate, and test the sheet with a small example before relying on it. If totals seem wrong, inspect the formula’s cell range and check for amounts stored as text or expenses entered as negative numbers when the formula expects positive amounts.

Google Sheets and Microsoft Excel share many basic spreadsheet ideas, and simple formulas such as SUM work in both. However, this guide uses Google Sheets’ browser menus and sharing model. Excel has its own interface, file behavior, and collaboration settings; menu names and some features differ. A downloaded Excel copy may not preserve every Sheets-specific setting or feature exactly, so verify formulas and formatting after converting or exporting a workbook.

Another misconception is that a budget sheet automatically syncs every bank transaction. A normal blank spreadsheet does not do that. Any import or connection depends on a separate service or process, and it should be reviewed for accuracy and privacy. Manual entry or periodic totals are often enough for a simple household budget.

Frequently Asked Questions

Does Google Sheets have a free budget spreadsheet?
Sheets has a Template gallery and can also be used to make a budget from a blank spreadsheet. Availability of particular templates can change, and a template may need editing to fit your categories.

How do I make a monthly budget in Google Sheets?
Create columns for categories, planned amounts, and actual amounts; enter income separately; and add totals and a remaining-money calculation. Then record spending consistently and compare actual totals with your plan.

Can Google Sheets calculate a budget automatically?
It automatically recalculates formulas when you change their inputs. It will not know your purchases by itself: you must enter them or use a separate, trusted method to bring in transaction data.

Can I use the same budget spreadsheet on my phone?
You can open and edit Sheets files with Google’s mobile app, though a wide spreadsheet may be easier to manage in a browser on a larger screen. Check that edits have synced before relying on them elsewhere.

Is Google Sheets or Excel better for budgeting?
Either can handle a basic category budget. Sheets is convenient for browser-based sharing and collaboration, while Excel may suit people who already manage their files in Microsoft 365. Choose the tool you can maintain and check sharing and backup needs.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.