Track a Budget in Google Sheets: A Practical Guide

To track a budget in Google Sheets, make one tab for transactions and another for your monthly plan, then use SUMIFS to total transactions by category and date. You’ll be able to compare what you planned to spend with what you actually spent, see what remains, and update the picture as new transactions come in. The example below uses Google Sheets in a web browser and an illustrative monthly budget; it is a tracking method, not financial, tax, investment, or legal advice. Check loan or account terms with your lender or a qualified professional.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
A rough list of monthly spending categories and planned amounts, such as rent, groceries, transport, and utilities.
Transaction details, including dates, descriptions, categories, and amounts. You can enter them manually or paste them from a statement after checking the data.
A few minutes to choose the month and set up the sheet. Avoid storing passwords, full card numbers, or other sensitive account details in the spreadsheet.

Step-by-Step

Create the spreadsheet and two tabs. Open Google Sheets, create a blank spreadsheet, and rename the first sheet Transactions. Add another sheet with the plus button and name it Budget. Keeping the raw transaction list separate from the summary makes it easier to review entries and reduces the chance that a formula or format change will damage your source data. Rename tabs by double-clicking their names. You can also add a note at the top of the Budget tab with the household or purpose, but keep personal account details out of it.
Set up the transaction columns. In Transactions, enter these headers in row 1: Date in A1, Description in B1, Category in C1, Income in D1, and Expense in E1. Put each transaction on its own row, starting in row 2. Record money received in Income and money spent in Expense, leaving the other amount cell blank. For example, a grocery purchase goes in Expense, while a paycheck goes in Income. Enter amounts as positive numbers; the separate columns make it clear whether a transaction adds income or represents spending. Give every transaction a real date value, not a date typed as descriptive text.
Choose consistent categories. Decide on a manageable set of expense categories before adding many transactions. For example, use Housing, Utilities, Groceries, Transport, Health, Eating out, Entertainment, and Other. Use the same spelling each time: “Groceries” and “Grocery” are different labels to a spreadsheet formula. You can make a dropdown by selecting the category cells, choosing Data > Data validation, and setting a dropdown from a list of category names. This helps prevent typos. For a small budget, typing categories consistently is also workable; the important point is to use the exact same labels on the Budget tab and Transactions tab.
Build the category plan. On Budget, put Category in A5, Planned expenses in B5, Actual expenses in C5, and Remaining in D5. Enter your categories in A6:A14 and the amount you intend to allow for each month in B6:B14. These planned amounts are examples of what you choose to track, not recommendations. Use the same category names as the transaction list. Select the planned and transaction amount cells and choose Format > Number > Currency. You can change the currency from the toolbar’s currency-format options if the default is not right for you. Keep the amounts numeric; typing a currency symbol into text can prevent Sheets from calculating the value as expected.
Choose the month being tracked. On Budget, enter Month start in F2 and the first day of the period in G2; enter Month end in F3 and the final day in G3. For example, enter April 1, 2026 in G2 and April 30, 2026 in G3. Format those cells as dates using Format > Number > Date if needed. The formula will include transactions on both boundary dates. For a calendar-month budget, update both dates when you move to another month. If you budget on a different cycle, enter that cycle’s start and end dates instead, and keep them in chronological order.
Calculate spending by category. With transaction dates in Transactions!A2:A, categories in Transactions!C2:C, expenses in Transactions!E2:E, the category to match in Budget!A6, and the period dates in Budget!G2:G3, enter this formula in Budget!C6, then fill it down through C14: =SUMIFS(Transactions!$E$2:$E,Transactions!$C$2:$C,$A6,Transactions!$A$2:$A,">="&$G$2,Transactions!$A$2:$A,"<="&$G$3). SUMIFS adds expense amounts only when the category and date match. In an illustrative April example, if Groceries in A6 has expenses of $42, $68, and $125 during the selected dates, C6 returns $235. The arithmetic is 42 + 68 + 125 = 235. Transactions outside April or assigned another category are excluded.
Show what remains in each category. With the planned amount in B6 and the calculated actual spending in C6, enter this in D6 and fill it down through D14: =B6-C6. If Groceries has a $500 plan and $235 actual spending, D6 returns $265, because 500 − 235 = 265. A positive result means the recorded spending is below the planned amount; a negative result means it is above. This is a comparison, not a warning about what you should spend. If a cell displays a row of hash marks, widen the column; the value may be correct but too wide to display.
Add totals and income tracking. With planned amounts in B6:B14, actual expenses in C6:C14, and remaining amounts in D6:D14, enter =SUM(B6:B14) in B15, =SUM(C6:C14) in C15, and =SUM(D6:D14) in D15. These formulas assume row 15 is your totals row and return the sum of the nine category rows above. For income, add Planned income in F7 and type your chosen target in G7. With income amounts in Transactions!D2:D, dates in Transactions!A2:A, and period boundaries in Budget!G2:G3, enter =SUMIFS(Transactions!$D$2:$D,Transactions!$A$2:$A,">="&$G$2,Transactions!$A$2:$A,"<="&$G$3) in G8 for actual income. If income is $3,000 and expenses total $2,100 for the period, then with G8 showing $3,000 and C15 showing $2,100, enter =G8-C15 in G9 to show $900 net after tracked expenses.
Make the sheet easier to scan and keep it current. Freeze the transaction header by choosing View > Freeze > 1 row while on Transactions. Bold the header rows, widen columns so dates and descriptions are readable, and use Format > Conditional formatting on D6:D14 to highlight negative values if you want overspending to stand out. Add transactions as they happen or set a regular time to enter them from receipts or statements. Before relying on the summary, compare a few entries with their source records. Formulas update when matching rows are added, but they cannot correct missing or miscategorized transactions.

Common Mistakes

Mixing income and expenses in one column: If you put income and spending together as positive numbers, a spending total may add income by mistake. Keep separate Income and Expense columns, and use the appropriate one in each summary formula.

Using inconsistent labels: A category formula will not combine “Transport” with “Transportation.” Choose one spelling and use a dropdown or copy the category from the Budget tab. Also check for accidental spaces before or after a label.

Entering dates or amounts as text: A date that looks right may be stored as text, and an amount such as “$42 dollars” may not be numeric. Use Format > Number > Date or Currency to format values; formatting does not turn incorrectly entered text into a valid date or number, so re-enter the cell value if needed.

Changing the formula range or overwriting a formula: If you type over C6 or D6, that cell stops calculating. Keep formula columns distinct from entry columns, and use copy and paste carefully. Make sure your formulas include all transaction rows; the example uses open-ended ranges from row 2, so new rows are included.

Tips

Start with a short category list. If a category is too broad to be useful, split it later; a long list from day one creates more data entry and more chances to choose the wrong label. A separate “Other” category can be useful, but review its entries periodically so it does not hide recurring costs you would prefer to track separately.

Keep one transaction per row and preserve the original transaction records. If you paste bank or card data, check that dates, descriptions, and amounts landed in the intended columns before trusting the totals. If a refund or correction needs to be represented, choose a consistent method and label it clearly; for example, record a refund as a positive entry in Income only if that matches how you want to report it, or use a separate refund category and adjust the summary deliberately. Avoid silently changing old rows just to make the total look right.

Use a copy of the spreadsheet as a starting point for a new month if you want to preserve a month-by-month history. Update the date boundaries and planned amounts, and confirm that formulas still point to the intended rows. You can also add a note describing the period covered, which is helpful if you use a non-calendar cycle. Google Sheets saves changes to Drive automatically when online, but a separate copy or version history can help you recover from accidental edits.

Google Sheets in a browser is the focus here. The SUMIFS and SUM formulas shown are also available in current Excel versions, but Excel’s menus and some sharing or dropdown controls may be arranged differently. Do not assume that a Google Sheets menu path will match Excel exactly.

Troubleshooting

The actual-spending total stays at zero: Check that the transaction category exactly matches the label in Budget column A, the amount is a number in Transactions column E, and the transaction date falls between G2 and G3. Confirm that the formula refers to the correct columns and that the date cells contain dates rather than text. Click the formula cell to inspect its references.

The total is too high or too low: Look for duplicate transactions, missing entries, a transaction recorded in both Income and Expense, or a date outside the period. Check whether the category formula was filled down correctly: each row should match its own category in column A. Compare the spreadsheet’s included entries with the source records instead of changing the formula to force a desired result.

The formula shows an error: Check that the formula begins with an equals sign and that parentheses, quotation marks, and commas are present as shown. In a localized spreadsheet, the required argument separator may differ from a comma; use the separator expected by your Google Sheets locale. Also confirm that the sheet tab is named exactly Transactions, since the formula uses that name.

Dates are excluded even though they look correct: Select a date cell and inspect the formula bar or re-enter the date using a clear format such as April 1, 2026. Ensure G2 is not later than G3. If you want the next month, update both boundaries rather than changing only the displayed month label.

A number displays as a date or as hash marks: Select the affected cells and choose Format > Number, then choose the appropriate format. Widen the column if the value is clipped. If the cell contains text rather than a number, correct the underlying entry; changing its number format alone will not make text calculable.

Frequently Asked Questions

Can I use this budget for more than one month?
Yes. Keep a separate dated transaction list and change G2 and G3 to the period you want to review. To preserve a clear monthly record, duplicate the Budget tab for each month or save a copy, then verify the dates and formulas on the new tab.

Can I track weekly or irregular pay periods?
Yes. Enter the beginning and ending dates of the period in G2 and G3. The date conditions in SUMIFS include transactions on those dates, so the same layout works for a week, a pay period, or another defined interval.

Can I import transactions from my bank?
You can paste exported transaction data into the Transactions tab if the columns can be mapped to the sheet. Review the import for duplicate rows, date formats, signs, categories, and misplaced amounts. Do not share banking credentials or sensitive account numbers in the budget sheet.

What if a category has no transactions?
Its actual total should be zero, and the remaining amount should equal the planned amount. If the result is blank or unexpected, check that the category name exists in the formula’s row and that the formula was filled down.

Can Google Sheets make the budget update automatically?
The summary formulas recalculate when you edit matching cells or add transactions within their referenced ranges. They do not automatically fetch every bank transaction in this setup; you still need to enter or import records and check them for accuracy.

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.