How to Use Google Sheets for Budgeting: A Practical Guide

To use Google Sheets for budgeting, create a monthly sheet with planned amounts, record transactions in a second tab, and use formulas to total spending and show what remains. You will need a Google account, a web browser, and figures for your income, regular bills, and recent spending. The example below uses an illustrative monthly plan; adjust the categories and amounts to fit your circumstances. A spreadsheet can help organize money, but it is not financial, tax, investment, or legal advice.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
An estimate of monthly take-home income and the amounts you plan to assign to bills, day-to-day expenses, savings, or debt payments.
Recent bank or card statements, receipts, or transaction exports to help estimate spending. Do not share account passwords or sensitive account details in the sheet.

Step-by-Step

Create a workbook and name it. Open Google Sheets, choose Blank spreadsheet, and give the file a clear name such as Monthly Budget. If you start from a template, check its formulas and categories rather than assuming they match your needs. If you are adapting an existing file, use File > Make a copy to preserve the original.
Set up the monthly budget tab. Rename the first sheet Budget by double-clicking its sheet tab. In A1:D1, enter the headings Category, Planned, Actual, and Remaining. In A2:A8, enter categories such as Housing, Utilities, Groceries, Transport, Insurance, Debt payments, and Savings. Put your planned monthly amounts in B2:B8. Leave row 9 for totals. Keep categories specific enough to be useful, but avoid making so many that it becomes difficult to maintain.
Format the amounts as currency. Select B2:D9, then choose Format > Number > Currency. If you want a particular currency, check the spreadsheet locale under File > Settings; locale affects currency and number display. Formatting changes how values appear, not the underlying calculations. Enter numbers as values, not text with a currency symbol typed into each cell.
Add a transactions tab. Click the plus button at the bottom to add a sheet, then rename it Transactions. Add Date in A1, Description in B1, Category in C1, and Amount in D1. Enter one expense per row, using the same category wording as the Budget tab. For instance, a grocery purchase goes in the Groceries category. Use positive amounts for expenses throughout the sheet; consistent entry makes totals easier to interpret. You can paste rows from a bank export, but review the columns and categories before relying on them.
Calculate actual spending by category. With Budget!A2:A8 holding category names and Transactions!C2:C500 holding categories alongside amounts in Transactions!D2:D500, enter this in Budget!C2 and copy it down through C8: =SUMIF(Transactions!$C$2:$C$500,$A2,Transactions!$D$2:$D$500). SUMIF adds amounts for rows whose category matches the category in column A. For example, if the transaction rows labeled Groceries total 180, 160, and 110, the Groceries actual is 450. Increase the ending row number if your transaction list grows beyond row 500.
Show what remains in each category. With planned values in B2:B8 and actual totals in C2:C8, enter this in D2 and copy it down through D8: =B2-C2. If a category has 600 planned and 450 actually spent, the result is 150 remaining. A negative result means spending is above the plan by that amount. This is a simple comparison, so make sure the sign convention and your meaning of remaining are clear to anyone else who uses the sheet.
Add totals and check them. With category values in rows 2 through 8 and row 9 reserved for totals, enter this in B9: =SUM(B2:B8). It totals the planned amounts; the example amounts of 1,400, 250, 600, 250, 200, 300, and 300 produce 3,300. With actual category totals in C2:C8, enter this in C9: =SUM(C2:C8). In the example, actual expenses of 1,400, 220, 450, 180, 200, 300, and 300 total 3,050. With totals in B9 and C9, enter this in D9: =B9-C9. The result is 250 remaining overall. Check that the total agrees with your category figures before using it to make decisions.
Compare the plan with take-home income. In F1, type Monthly take-home income and enter an illustrative amount such as 4,000 in G1. In F2, type Planned expenses; with the planned categories in B2:B8, enter this in G2: =SUM(B2:B8). It returns 3,300 for the example. In F3, type Unallocated; with income in G1 and planned expenses in G2, enter this in G3: =G1-G2. The example returns 700. Treat this as a check that your plan accounts for income, not as proof that every expense has been included. If planned expenses exceed income, G3 will be negative.
Make the sheet easier to review. Select the header row and use the toolbar’s bold control, or choose Format > Text > Bold. To keep headings visible while scrolling, select View > Freeze > 1 row. You can select the Budget table and choose Data > Create a filter to sort or filter its rows. For visual alerts, select D2:D8 and choose Format > Conditional formatting, then set a rule for values less than 0. Check the selected range and rule before closing the side panel.
Review it on a regular schedule. Add new transactions as they happen or set a weekly reminder to enter them. At month-end, compare the sheet with statements, correct miscategorized entries, and save a copy for the next month if you want a separate record. Keep one consistent source of truth: if a purchase is entered twice, the formula will count it twice. Google Sheets runs in a browser; Excel has comparable spreadsheet concepts, but its menus and some interface steps differ.

Common Mistakes

Mixing categories. If the budget says Groceries but transactions use Food, SUMIF will not treat those labels as the same category. Use a consistent set of names, and correct spelling differences rather than adding duplicate categories.

Entering amounts as text. A pasted value containing extra words or an apostrophe may not behave like a number. Check that amounts are numeric and that the currency format is applied to the cells rather than typed into every entry.

Forgetting irregular costs. Annual subscriptions, repairs, gifts, and other occasional costs can make a monthly plan look more comfortable than it is. Estimate a monthly amount for recurring but infrequent expenses, or add a category for them. Do not count a transfer between your own accounts as spending twice.

Changing the layout without updating formulas. Inserting rows or moving columns can affect references, especially in copied formulas. After a layout change, inspect totals and test a category with a known transaction amount. Also remember that an empty transaction list can produce a zero actual amount, which may mean no data has been entered yet rather than no spending occurred.

Tips

Start with a small number of categories and add detail only when it helps you understand a meaningful pattern. Use planned amounts that reflect your own records and priorities; the sample values are only there to demonstrate arithmetic. Give transactions a useful description, but avoid putting full card numbers, account credentials, or other unnecessary sensitive information in the workbook.

Keep planned amounts separate from actual transactions. That makes it easier to see whether a difference comes from the plan or from spending. When copying a month, clear old transaction rows and confirm that formulas still cover the intended range. If several people need access, use the Share button and grant only the access level they need. Protecting account security matters even for a personal budget.

For a quick visual review, use consistent currency formatting and make negative remaining amounts stand out with conditional formatting. You can also create a chart with Insert > Chart, but a chart is optional: first check that the totals and categories are correct. Review actual spending against statements, because a clean-looking sheet can still contain missing, duplicated, or mistyped entries.

Troubleshooting

A category shows zero unexpectedly: Check that the label in Transactions column C exactly matches the Budget label, including spaces, and that the amounts are numeric in column D. Make sure the new transaction is within the formula’s referenced rows. If you extended the list past row 500, edit the SUMIF range to include those rows and confirm the category and amount ranges remain the same size.

A formula appears as text or shows an error: Confirm the entry begins with an equals sign and that the cell is not set to plain text. Click the cell and inspect the formula for missing parentheses, misspelled sheet names, or references to the wrong columns. If your spreadsheet locale uses different formula separators, follow the locale’s expected syntax or change the locale under File > Settings. Google Sheets may display function help while you edit a formula.

The total does not match your records: Check for duplicate transactions, omitted rows, refunds entered with the wrong sign, and categories that do not match. Compare the transaction list with the source statement for the same date range. Decide consistently whether the budget tracks purchases by transaction date or by statement date, particularly around month-end.

A negative remaining amount or unallocated figure surprises you: Recheck the planned amount, actual entries, and income figure. A negative category balance means actual is greater than planned under this setup; a negative unallocated figure means planned categories exceed the entered income. The sheet identifies a mismatch, but it cannot tell whether an input is complete or what action to take.

Frequently Asked Questions

Is there a free Google Sheets budget template?
Google Sheets may offer templates when you create a spreadsheet, and you can also build the simple two-tab layout above from a blank file. Inspect any template’s categories, formulas, and sharing settings before entering personal information.

Can Google Sheets automatically import my bank transactions?
Some banks offer transaction downloads that can be opened or imported, but availability and file formats vary. Review imported dates, amounts, and categories carefully. Do not assume a bank connection or automatic import is available in Sheets itself.

How often should I update a budget?
Choose a rhythm you can maintain. Entering transactions weekly helps catch mistakes sooner, while a monthly review helps compare the full period. If you have many transactions, more frequent updates can make reconciliation easier.

Can I use this budget on my phone?
Yes. You can open Google Sheets in a mobile browser or the Sheets app, though editing a wide table is often easier on a computer. Freeze the header row and keep columns clearly labeled to make the sheet easier to navigate.

What is the difference between planned and actual?
Planned is the amount you assign to a category before or during the month. Actual is the sum of recorded transactions for it. Remaining is planned minus actual in this example, so it falls below zero when actual spending is higher than planned.

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.