Create a Budget in Google Sheets: A Practical Guide

To create a budget in Google Sheets, make a monthly table with spending categories, planned amounts, and actual spending, then use formulas to total each column and show what remains. In a browser, start a blank spreadsheet, enter your income and expense categories, and update actuals as transactions happen; a few simple checks can reveal overspending before the month ends.

Choose a budgeting approach

Before building the sheet, decide what you want the budget to do. A simple monthly plan is often enough: list expected take-home income, assign amounts to expenses and savings, and compare those plans with what you actually spend. It can be useful even if you do not track every transaction, as long as you update the totals consistently.

Two common approaches are a category budget and a transaction ledger. A category budget has one row per category, such as groceries, housing, and transport. You enter or calculate a monthly actual total for each row. A ledger records each purchase on its own row, usually with a date, description, category, and amount. A ledger takes more upkeep, but it makes it easier to see what makes up a category’s total.

This guide starts with a category budget because it is quick to build and easy to read. You can add a separate transaction tab later. Treat the numbers as a planning example, not as financial, tax, investment, or legal advice. For decisions involving your own finances, check the relevant account or lender terms or consult a qualified professional.

Set up the monthly sheet

Open Google Sheets in a web browser and choose Blank spreadsheet. Give the file a clear name, such as “Monthly budget,” and label the first sheet with the month or the word “Template.” A practical layout keeps the income figure near the top and the expense table below it:

In A1, type the month; in B1, enter the month or date range.
In A2, type “Take-home income”; enter an illustrative amount of 4200 in B2.
In row 5, enter the headings Category, Planned, Actual, and Left in columns A through D.
In rows 6 through 14, enter expense and savings categories, with planned and actual figures in columns B and C.
Use row 15 for totals, and row 17 for the amount left after actual allocations.

For this example, use housing, groceries, utilities, transport, insurance, debt payments, savings, dining, and subscriptions. Put 1450, 500, 220, 300, 180, 350, 500, 200, and 50 in B6:B14 respectively. Put 1450, 540, 205, 275, 180, 350, 500, 245, and 45 in C6:C14. These figures are illustrative and add up to a planned allocation of 3750 and actual allocations of 3790.

Including savings as a planned allocation can make the budget show how much income is assigned to goals as well as bills and purchases. Keep the category definition consistent from month to month. For instance, if savings is counted as an allocation, do not also treat a transfer to savings as ordinary spending in another part of the sheet.

Calculate totals and what remains

Formulas let Sheets recalculate totals when you change a number. With planned amounts in B6:B14 and actual amounts in C6:C14, enter =SUM(B6:B14) in B15. It returns 3750 for the illustrative planned figures. With the same table layout, enter =SUM(C6:C14) in C15; it returns 3790 for the actual figures. The total row gives you a quick comparison without manually adding each category.

To see the difference by category, use planned minus actual. With row 6 containing housing, B6 holding its planned amount of 1450, and C6 holding its actual amount of 1450, enter =B6-C6 in D6. The result is 0. Copy the formula down through D14 by selecting D6 and dragging the small blue handle at the cell’s lower-right corner. Positive results mean you spent less than planned in that category; negative results mean you went over. The total difference in D15 can be calculated with =B15-C15; in this example, it is -40.

To calculate the cash remaining after the actual allocations, put “Remaining after actual” in A17. With take-home income in B2 and total actual allocations in C15, enter =B2-C15 in B17. The example returns 410 because 4200 minus 3790 is 410. For comparison, planned income less planned allocations is 450. That distinction matters: the planned remainder is a target, while the actual remainder changes as real spending changes.

Format the budget for quick reading

Make the sheet legible before adding more features. Select the amount cells and choose Format > Number > Currency. The currency display changes how values look, not the underlying arithmetic. Set the currency and number of decimal places to suit your needs, and use the same currency throughout. Bold the heading row and total row, and widen column A if category names are cut off.

To keep headings visible while scrolling, choose View > Freeze > 1 row. If your sheet has several introductory rows above the table, freeze the appropriate number of rows instead. You can also select the category table and use Format > Conditional formatting to highlight negative values in D6:D15. For example, choose a formatting rule that identifies values less than zero. This makes overspending easier to spot, but it does not change any totals or automatically fix the budget.

A chart is optional. Select the category names and the planned or actual figures, then choose Insert > Chart. A column chart can compare planned with actual amounts; a pie chart can show how a selected total is distributed. Check the chart’s selected data range and labels, since an incorrectly selected range can produce a confusing graphic. The table remains the authoritative record.

Update actual spending reliably

A budget is only as current as its inputs. Choose a regular routine, such as updating the sheet once a week and reviewing it near the end of the month. If entering every transaction feels burdensome, record totals from account statements or another tracking method, while taking care not to count transfers or card payments twice. Credit-card purchases, for example, are often easiest to track by purchase category; counting the later card bill as another expense can duplicate them.

When actuals are typed directly into the category table, keep a separate record of where those numbers came from if you need transaction-level detail. A second tab can hold a ledger with columns for date, description, category, and amount. Use consistent category names so that later summaries can group transactions correctly. Avoid mixing a transaction list total with manually entered category totals unless you know which figures are included in each calculation.

At month-end, review the difference column rather than treating every overage as a spreadsheet error. A negative amount may reflect a one-off bill, a changed price, a timing issue, or a category that was too low. Adjust future planned amounts if your circumstances or recurring costs have changed. If income varies, use a clearly chosen planning figure and note assumptions; do not confuse expected income with money already received.

Make a reusable template and protect access

Once the layout works, keep a clean template with category names and formulas but without the previous month’s actual figures. Use File > Make a copy to create a separate sheet for a new month, then update the month label and clear only the cells intended for new actuals. Before clearing anything, confirm that the formulas and category labels remain in place. A separate file or tab for each month can make historical comparisons easier, while one rolling sheet keeps everything in one place.

Google Sheets saves changes to Google Drive when you are online, so you do not need to use a separate Save command after each edit. Still, make copies or retain prior monthly tabs before making substantial structural changes. A budget may contain sensitive information: use Share to review who has access, avoid public link access for private financial details, and share with specific people only when needed. Do not put account passwords, full card numbers, or other authentication details in a budget spreadsheet.

Common problems and useful checks

A total does not change: Check that the edited value is inside the formula’s range. If you added a new category below row 14, a total of B6:B14 will not include it until the range is expanded.
A number is treated as text: Look for a leading apostrophe or pasted formatting. Re-enter the value as a number and apply currency formatting through the menu.
The remaining amount seems wrong: Confirm whether you are subtracting planned or actual expenses, and check that savings and transfers are not counted twice.
Negative differences are confusing: The example uses planned minus actual, so a negative value means actual spending exceeded the plan. If you reverse the subtraction, the sign interpretation reverses too.
Categories overlap: Decide whether items such as takeout, household supplies, or annual fees belong in one category or another, then use the same rule each month.

For a basic comparison, you do not need a complicated formula or an add-on. Start with clear labels and a limited number of categories, then add detail only when it helps answer a real question. If the sheet will be used by multiple people, agree on who enters each item and how to handle shared purchases before relying on the totals.

Google Sheets compared with Excel

The formulas shown here, including SUM and simple subtraction, also work in current Microsoft Excel, but this page’s menu paths describe Google Sheets in a browser. Excel has its own ribbon locations and sharing workflow, and the appearance of menus can differ by platform. Sheets is convenient for browser-based collaboration and Drive storage; Excel may be preferable for users whose workflow depends on desktop workbook features or Microsoft 365 integration. You can export a Sheets file to Excel format, but check formulas, formatting, and charts after conversion rather than assuming every detail will look identical.

Frequently Asked Questions

Does Google Sheets have a free budget template?
Google Sheets offers templates through its template gallery when available in the account interface. You can also make a blank sheet and build the simple category table above. Template names and gallery availability can change, so check the template options shown when you create a spreadsheet.

Can Google Sheets automatically track my bank spending?
A basic budget spreadsheet does not automatically know what you spent. You can enter totals yourself or import data from a source you trust, but automatic connections depend on third-party services and account availability. Review permissions and privacy terms carefully before giving an outside service access to financial accounts.

How do I make a monthly budget in Google Sheets?
Create a new copy of a monthly template, set the month and take-home income, enter planned amounts, and update actual spending throughout the month. At the end, compare planned and actual totals and carry forward only the categories or formulas needed for the next month.

Can I use Google Sheets for a budget on my phone?
Yes. You can view and edit spreadsheets with the Google Sheets mobile app, though this guide describes the browser interface. Small screens can make wide tables and formula editing less convenient, so freeze headings, keep category names concise, and use the app’s current controls for formatting or sharing.

Why is my budget total not matching my bank balance?
A category budget may omit pending transactions, fees, cash purchases, timing differences, or accounts that are outside the sheet. It may also count savings transfers differently from your bank’s balance display. Reconcile the included transactions and date range before concluding that a formula is wrong.

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.