Budget Spreadsheet Template for Google Sheets: Setup

Yes—a budget spreadsheet template for Google Sheets is available through the Sheets template gallery when a suitable template appears for your account, or you can create a simple one in a blank spreadsheet. For a useful monthly budget, track each category’s planned amount and actual amount, then use formulas to calculate totals and what remains.

Find a template in Google Sheets

Open Google Sheets in a web browser and go to the Sheets home screen. Select Template gallery and browse the available templates for a budget or personal-finance option. Template names and availability can vary by account, language, and changes to Google’s gallery, so a particular template may not appear for everyone. Open a template to make a copy you can edit; avoid entering personal information until you understand who can access the file.

A ready-made sheet can save setup time, but inspect its categories, formulas, and date ranges before relying on it. Some templates are designed for a household, a business, or a specific budgeting method, and may include sections you do not need. Remove irrelevant rows and check that totals include all of the categories you intend to track.

If you do not find an appropriate template, choose a blank spreadsheet from Sheets and make a compact version yourself. A small sheet with understandable labels is often easier to maintain than a complicated template with charts and numerous tabs. You can add detail later once you know what information is useful to you.

What a practical monthly budget includes

Start with one row per spending or savings category. A straightforward layout uses columns for Category, Planned, Actual, and Remaining. Planned is the amount you expect to allocate; Actual is what you have recorded so far; Remaining is the difference. With this convention, a positive remaining amount means the actual allocation is below the plan, while a negative amount means it has exceeded the plan.

For example, a small illustrative budget might include rent, groceries, utilities, transport, and a savings contribution. Put the month and year near the top, and add a separate line for monthly take-home income. Keep savings contributions distinct from spending if you want to see those totals separately. Whether a savings transfer belongs among budget allocations depends on what you want the sheet to measure.

Income: Record the take-home income you want to plan against, rather than mixing gross pay and take-home pay in the same total.
Categories: Use labels that match your own records. Broad categories are easier to maintain; detailed categories can make patterns clearer but require more data entry.
Planned and actual amounts: Enter amounts in the same currency and for the same period.
Notes or dates: Add these only if they help you explain an unusual charge or reconcile the numbers.

Build the sheet step by step

In a blank spreadsheet, place the four column headings in A1:D1: Category, Planned, Actual, and Remaining. Enter your category names in A2:A6 and the relevant planned and actual amounts in columns B and C. The figures below are purely illustrative: rent 1,500 planned and actual; groceries 500 planned and 465 actual; utilities 180 planned and 195 actual; transport 160 planned and 130 actual; and savings 300 planned and actual. Enter amounts as numbers, not text containing currency symbols, so calculations work reliably.

Put Total in A7. Add a monthly take-home income label in A9 and its value in B9; for this example, use 3,600. If you want to show planned and actual amounts not yet assigned to the listed categories, label A10 Planned unallocated and A11 Actual unassigned. These figures are not necessarily the balance in a bank account: timing, cash withdrawals, debt payments, other income, or omitted categories can make the real balance different.

Format the planned and actual columns as currency using Format > Number, then select the currency format that suits your spreadsheet’s locale. Use View > Freeze > 1 row to keep the headings visible as you scroll. In Google Sheets, the menus are in the browser interface; Excel has its own ribbon and menu paths, so do not assume an Excel instruction applies verbatim.

Use formulas to calculate totals

With category names in A2:A6 and planned and actual values in B2:C6, enter this formula in D2 to subtract actual from planned. In the example, the rent row returns 0 because both amounts are 1,500. Copy the formula down through D6; groceries then returns 35, utilities returns -15, transport returns 30, and savings returns 0.

=B2-C2

With planned amounts in B2:B6, put this formula in B7 to total the plan. It returns 2,640 for the illustrative figures.

=SUM(B2:B6)

With actual amounts in C2:C6, put this formula in C7 to total the recorded allocations. It returns 2,590.

=SUM(C2:C6)

With take-home income in B9 and the planned total in B7, enter this formula in B10 to calculate the amount not allocated in the plan. It returns 960, because 3,600 minus 2,640 is 960.

=B9-B7

With take-home income in B9 and the actual total in C7, enter this formula in B11 to show income less the actual amounts recorded in this example. It returns 1,010, because 3,600 minus 2,590 is 1,010. Treat that as an arithmetic remainder within this sheet, not as a verified account balance.

=B9-C7

Make the budget easier to read and update

Use formatting to make exceptions visible without changing the underlying calculation. Select D2:D6, then choose Format > Conditional formatting. Set a rule to format cells if they are less than 0, and choose a visible style. That highlights categories where recorded amounts exceed the plan under the remaining convention used here. Check the range if you add more categories, because new rows may sit outside a rule’s original range.

A category dropdown can reduce spelling differences that split the same type of expense into multiple labels. Select the cells where you enter categories and use Data > Data validation to create a dropdown from a list of the category names. Google Sheets may present dropdown controls differently as its interface changes, so review the choices offered in the sidebar and confirm the list covers the categories you actually use.

Keep one month per tab or use a transaction log with a month field; choose the approach you will update consistently. Separate tabs are simple to scan, while a transaction log makes it easier to filter records across months. If you build a transaction log, agree on what counts as a transaction and whether transfers between your own accounts should be recorded. Counting a transfer as both income and spending can distort totals.

Choose a template that fits your routine

The best template is not necessarily the one with the most features. Consider how often you will update it, how much detail you need, and whether another person needs to use it. A monthly summary suits someone who wants a quick comparison of planned and actual totals. A transaction-based sheet can answer more detailed questions, but it takes more effort to enter and categorize each item.

For a simple household plan: Look for a monthly view, a small number of editable categories, and visible totals.
For irregular income: Check whether the template lets you adjust income by month instead of assuming the same amount every period.
For shared budgeting: Consider whether collaborators can edit the file and agree on who updates entries to avoid duplicate records.
For tracking several months: Confirm that the template has a clear way to compare periods and that copied tabs do not keep formulas pointed at the wrong month.

Before choosing, test a copy with a few made-up numbers. Confirm that category totals change when you edit an amount and that the date or month labels make sense. This quick check can reveal a formula that excludes a row or a template that assumes a different currency or budgeting period.

Common spreadsheet problems and fixes

If a total looks too low, check whether the formula range includes every category row. For example, a total ending at row 6 will not include a new category entered in row 7. If a formula displays as text rather than calculating, check that the cell is formatted as a number or automatic, and that the entry begins with an equals sign. Also check for an accidental leading apostrophe.

A number stored as text may not behave as expected in a sum. Enter plain numeric values and apply currency formatting to the cells, instead of typing symbols into each value. If a formula reports a parse error, check parentheses and separators. Spreadsheet locale settings can affect number formats and, in some locales, the separator used between formula arguments. The simple formulas shown here do not use argument separators beyond the colon in a range.

Do not interpret a positive Remaining figure as money that is automatically safe to spend. It means only that the recorded actual amount is below the planned amount for that row. An expense not entered, a bill due later, or a category left out of the sheet can change the real picture. Update the data regularly and label the period clearly.

Cost, sharing, and privacy

Google Sheets is available through a Google account, and personal use does not require purchasing a separate budget-template file. Google Workspace plans and organizational policies can vary, so work or school accounts may have different features or sharing restrictions. A third-party template may be free, paid, or bundled with another product; check its terms before downloading or granting access.

Sheets files can be shared with specific people or made more broadly accessible through the Share controls. Give collaborators only the access they need, and review the sharing setting before sending a link. Avoid placing bank passwords, full card details, or other credentials in a budget. A spreadsheet is a planning and recordkeeping tool, not a secure place to store account login information. For financial, tax, investment, or legal decisions, this illustrative arithmetic is not professional advice; check actual terms with the lender or a qualified professional where relevant.

Alternatives to a Google Sheets budget

A blank spreadsheet is the most flexible alternative to a gallery template, and it avoids having to understand someone else’s layout. A budgeting app may offer automatic transaction imports or mobile notifications, but features, fees, and data practices differ by provider. A paper budget can work for people who prefer not to maintain an online file, though totals must be calculated manually. Compare the upkeep and privacy trade-offs rather than assuming one format is automatically better.

Frequently Asked Questions

Does Google Sheets have a free budget template?
Google Sheets has a Template gallery with templates that may include budget options. Availability can vary, and you can also make a budget in a blank spreadsheet without buying a template.

How do I make a monthly budget in Google Sheets?
Create columns for category, planned amount, actual amount, and remaining amount. Enter monthly figures, use a subtraction formula for each category, and add totals with SUM. Keep income separate so the comparison is clear.

Can I use a Google Sheets budget template on my phone?
You can view and edit Sheets files with the Google Sheets mobile app, although the app’s controls and screen layout differ from the browser version. For initial setup or detailed formatting, a larger screen may be easier.

Can I share a budget spreadsheet with someone else?
Yes. Use the Share controls to invite specific people and choose whether they can view, comment, or edit, subject to the account’s sharing settings. Check who has access before adding sensitive financial details.

Why is my budget total wrong?
Check the formula’s cell range, confirm that amounts are numeric rather than text, and make sure a new row has not been left outside the total. Also verify that you have not counted a transfer or category twice.

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.