Monthly Budget Tracker Template for Google Sheets?

A monthly budget tracker template for Google Sheets can be built from a transaction log, a monthly category budget, and a few formulas that compare planned spending with actual spending. Create those tabs in a blank spreadsheet, enter each transaction once, and use the formulas below to calculate category totals for the month you select.

What a monthly budget tracker does

A tracker turns a monthly plan into a record you can review. The budget tab says how much you intend to spend in categories such as groceries or transport; the transaction tab records what actually happened. A summary then shows the difference between the two. That distinction matters: a budget is a plan, while the transaction list is the source data used to measure it.

Google Sheets is useful for this kind of template because it runs in a web browser, saves changes to Google Drive, and can be shared with other people. You do not need a special budgeting function. Standard functions such as SUM, SUMIFS, and EDATE can total transactions for a selected month. You can begin with a small number of categories and add detail only when it helps you make a decision.

Choose a template or start with a blank sheet

You can start with a blank spreadsheet or look through the template gallery available from the Google Sheets home page. Gallery contents can change, so check that any template you choose actually includes a monthly view and editable transaction data. A visually polished dashboard is less useful if it hides how totals are calculated or makes it difficult to add categories.

A blank file is a good choice if you want a tracker that matches your household’s needs. Create three tabs named Transactions, Budget, and Summary. Keeping raw entries separate from the monthly plan makes formulas easier to inspect and reduces accidental edits. If you adapt a downloaded template, make a copy first and check its formulas, sharing settings, and category names before entering sensitive information.

Set up the transaction log

On the Transactions tab, put these headings in row 1: Date, Type, Category, Description, and Amount. Enter one transaction per row, with the date in column A, type in B, category in C, description in D, and a positive amount in E. Use Income or Expense consistently in the Type column. Keeping all amounts positive and recording the type separately makes the entries easier to read and avoids confusion about whether a negative number represents a refund, income, or a data-entry error.

For example, a grocery purchase on March 4 could be entered as 3/4/2026, Expense, Groceries, Weekly shop, and 86.42. A paycheck would use Income as the type and a suitable category such as Salary. Use the actual transaction date rather than the date you happened to update the sheet. If you receive a refund, decide on a consistent method: record it as income in a Refunds category, or enter it as an expense adjustment using a clearly documented convention.

In Google Sheets, you can use Data > Data validation to create a dropdown for Type or Category. This helps prevent entries such as Grocery, Groceries, and grocery from being treated as separate categories. Format dates as dates and amounts as currency with Format > Number > Currency. If the log grows, Data > Create a filter can make it easier to display one category or month at a time.

Build the monthly budget and summary

On the Budget tab, list your spending categories in column G, planned amounts in H, actual amounts in I, and remaining amounts in J. For instance, put Groceries in G2 and a planned amount of 500 in H2. Add categories below it, such as Housing, Utilities, Transport, and Dining out. Set aside a cell for the month you want to review: enter the first day of that month in K1, such as March 1, 2026, and format it as a date or a month and year.

Using the first day of the month as the selector lets the formulas include dates from that day up to, but not including, the first day of the next month. That boundary works for months of different lengths and avoids treating the final day as a special case. Keep the selector as a real date value; typing a month name as plain text may not work as intended in date calculations.

On a Summary tab, you can display the selected month, total planned expenses, actual expenses, and the difference. Make the labels clear: a positive remaining amount means spending is below the plan, while a negative one means it has gone over. If you include income and savings, show those separately rather than quietly mixing them into expense categories.

Use formulas to compare plan and actual spending

With transaction dates in Transactions!A2:A, types in B2:B, categories in C2:C, and positive amounts in E2:E; with the category for the current budget row in G2 and the month’s first date in K1, enter this in I2 to total that category’s expenses for the selected month:

=SUMIFS(Transactions!$E$2:$E,Transactions!$B$2:$B,"Expense",Transactions!$C$2:$C,G2,Transactions!$A$2:$A,">="&$K$1,Transactions!$A$2:$A,"<"&EDATE($K$1,1))

For the illustrative case where the March log contains grocery expenses of 86.42, 142.18, and 221.40, the result is 450.00. The calculation checks both the category and the date range, so it excludes groceries from other months and excludes income entries. Copy the formula down column I for the other categories.

With the planned amount in H2 and actual spending in I2, enter this in J2 to show the remaining budget:

=H2-I2

For the example of a 500.00 grocery plan and 450.00 of actual spending, the result is 50.00 remaining. Copy this formula down alongside the category list. To total the planned, actual, and remaining values for rows 2 through 10, use the following formulas in the corresponding total cells:

With planned amounts in H2:H10, use =SUM(H2:H10). If the plans total 2,400.00, the result is 2,400.00.
With actual amounts in I2:I10, use =SUM(I2:I10). If those expenses total 2,325.00, the result is 2,325.00.
With remaining amounts in J2:J10, use =SUM(J2:J10). For those totals, the result is 75.00 below the overall plan.

These totals assume the category rows contain all the categories you want included and that the total row is outside rows 2 through 10. Adjust the ranges if your list is longer. Google Sheets formulas use commas between arguments in many locales; spreadsheet locale settings can affect separators and date interpretation.

Make the sheet easier to use month after month

Once the basic calculations work, a few small design choices make routine updates more reliable. Freeze the heading row with View > Freeze so column names stay visible while scrolling. Use consistent number formats, keep descriptions short, and avoid blank rows inside the transaction data. Add a note near K1 explaining that it should contain the first day of the month.

You can apply conditional formatting to highlight categories that exceed their plans. Select the remaining-balance cells and choose Format > Conditional formatting; create a rule for values less than zero. A red fill can draw attention to over-budget categories, but include a label or legend so the color’s meaning is not ambiguous. To create a chart, select the category and actual-spending data and use Insert > Chart. A bar chart is often easier to compare across categories than a chart with many small slices.

At the end of a month, check that transactions are complete before using the totals to make comparisons. Then change K1 to the first day of the next month. The same category plan can remain in place if that is your approach, or you can revise planned amounts for the new month. If you want to preserve a record of past plans, copy the monthly values to a dated archive or maintain a separate plan table instead of overwriting them.

Choose categories and plan amounts thoughtfully

Categories should be specific enough to explain spending but not so detailed that recording becomes a chore. A practical starting list might include housing, utilities, groceries, transport, health, debt payments, subscriptions, dining out, and personal spending. Add a category when it helps answer a recurring question; combine categories that you never review separately.

Do not assume that every month will have identical expenses. Annual or occasional bills can be easy to overlook if the tracker only shows regular monthly purchases. You might add an irregular-expenses category or keep a separate list of upcoming bills. The tracker can help organize information, but it cannot decide what amount is appropriate for your circumstances. For loan terms, taxes, investment choices, or other financial decisions, check the actual documents or consult a qualified professional.

Common problems and how to fix them

A category total is zero: Check for spelling differences between the transaction category and the Budget tab. Also verify that the Type cell says Expense and that the transaction date falls within the selected month.
Dates appear in the wrong month: Confirm that the cells contain date values rather than text, and check the spreadsheet’s locale if dates such as 3/4 are ambiguous. Use a clear date format when entering data.
The total looks too high: Look for duplicate transactions, an accidental income entry marked as an expense, or a total formula that includes an extra row. Filter the transaction log by date and category to inspect the underlying entries.
A new category does not appear in a chart: Check that the chart’s data range includes the added row. Charts do not always expand in the way a user expects when new data is placed outside the selected range.
Formula parsing errors appear: Check parentheses, sheet names, and argument separators. Depending on locale, the spreadsheet may require semicolons instead of commas. If you rename a tab, verify that formulas still refer to the correct tab.

Google Sheets and Excel share many familiar functions, but their interfaces and some range conventions differ. The menu paths in this guide are for Google Sheets in a web browser. Do not assume every formula or menu instruction can be pasted unchanged into Excel; check the ranges and syntax for the version you use.

Privacy, sharing, and backups

A budget can reveal personal details through merchant names, income, recurring bills, and account information. Avoid storing passwords, full card numbers, or online banking credentials in the sheet. Use Google Drive’s sharing controls to grant access only to people who need it, and review who can view or edit the file before sharing a link. A spreadsheet’s sharing link should not be treated as private merely because it is difficult to guess.

Consider making a copy before changing a template’s structure or replacing formulas. Google Sheets keeps file changes in Drive, but a separate copy gives you a straightforward fallback if you delete a tab or overwrite important data. For collaborative household tracking, agree on category names and whether pending card purchases should be recorded before or after they post.

Frequently Asked Questions

Does Google Sheets have a free monthly budget template?
Google Sheets has a template gallery that may include budget-related options, though available templates can change. You can also make the simple three-tab tracker described here in a blank spreadsheet. Review a template’s formulas and sharing settings before relying on it.

How do I make a budget tracker automatically show a new month?
In this setup, change the month selector in K1 to the first day of the new month. The SUMIFS formula uses that date and EDATE to calculate the next month’s boundary. This updates the monthly totals without deleting or moving the transaction history.

Can Google Sheets track income as well as expenses?
Yes. Record both in the transaction log and label each row Income or Expense in the Type column. The example expense formula deliberately includes only Expense rows. You can make a separate income summary using the same date-range approach and the Income type.

Should I enter expenses as negative numbers?
Not in the layout described here. Enter amounts as positive numbers and use the Type column to distinguish income from expenses. This keeps expense totals straightforward and makes it easier to spot an incorrect sign. If you choose a different convention, use it consistently and adjust formulas accordingly.

Can I use the template with Excel?
The basic idea and several functions are familiar in Excel, but this guide is written for Google Sheets in a browser. Menu paths differ, and the open-ended ranges used in the examples may need to be changed to bounded ranges in Excel. Check the syntax and results in the specific spreadsheet program you use.

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.