Monthly Expenses Tracker in Google Sheets: Setup Guide

Yes—you can make a monthly expenses tracker in Google Sheets by recording each purchase on a Transactions tab and summarizing it on a Dashboard tab. A date-based SUMIFS formula can calculate the selected month’s spending, while category totals and budgets help show where the money went.

What a monthly expenses tracker does

A tracker is a spreadsheet for logging expenses and reviewing them over a chosen month. Unlike a bank statement, it can include cash purchases, categories you define, budget targets, and notes about unusual transactions. It is useful for understanding spending patterns, but it does not automatically know about purchases unless you enter or import them.

A simple tracker has two parts:

Transactions: one row per expense, with a date, description, category, and amount.
Dashboard: a selected month’s total, category breakdown, and optional budget comparisons.

Keeping the transaction log separate from the summary matters. You can add new expenses without rebuilding the monthly view, and you can review another month by changing one date. Decide whether your goal is to track all household spending or only a particular account or person; that choice affects the categories and notes you will want.

Set up the Google Sheets workbook

In Google Sheets in a web browser, create a blank spreadsheet or open a suitable file from the Sheets home page. A template may be available in the template gallery, but layouts and availability can change; check that any template includes the fields and calculations you need before relying on it. A blank sheet gives you more control.

Rename the first sheet Transactions. Put these headings in row 1: Date, Description, Category, Payment method, Amount, and Notes.
Enter one expense per row, starting in row 2. Use a real date in column A and a positive number for the expense in column E. Keep the same currency throughout the sheet.
Add a second sheet with the plus button and name it Dashboard. Put a date representing the first day of the month in B1—for example, January 1, 2026—and format it as a month and year if you prefer.
Add headings on the dashboard for category, budget, actual spending, and remaining budget. List your categories down the first column.

For example, a transaction row could contain January 4, 2026; “Market”; “Groceries”; “Debit card”; 42.00; and a note such as “weekly shop.” A second expense on January 12 might be “Bus pass,” “Transport,” “Card,” and 18.50. With this consistent structure, the dashboard can sum amounts by date and category.

Format and make data entry consistent

Good formatting makes errors easier to spot, but it does not replace correct data. Select the date column and use Format > Number > Date. Select the amount column and choose Format > Number > Currency, selecting the currency you use. On the Transactions sheet, use View > Freeze > 1 row to keep the headings visible while scrolling.

To reduce inconsistent category names, select the cells where categories will be entered and use Data > Data validation to create a dropdown list. Use a fixed set of labels, such as Groceries, Housing, Transport, Utilities, Health, and Dining. If you later rename a category, make the same change in the dropdown source and dashboard list; otherwise, old and new spellings may be counted separately.

Consider leaving a few rows for headings or notes on the dashboard, but keep the transaction table itself rectangular: one header row followed by records, without blank rows between entries. This makes sorting, filtering, and charting less error-prone.

Calculate the selected month’s total

In the following formula, transaction dates are in Transactions!A2:A1000, expenses are in Transactions!E2:E1000, and Dashboard!B1 contains the first day of the month to report. Enter this in a dashboard cell for the monthly total:

=SUMIFS(Transactions!$E$2:$E$1000,Transactions!$A$2:$A$1000,">="&$B$1,Transactions!$A$2:$A$1000,"<"&EDATE($B$1,1))

SUMIFS adds amounts whose dates are on or after the first day in B1 and before the first day of the next month. The end boundary is exclusive, which works for months of different lengths and avoids missing entries on the final day. With example records of 42.00 and 18.50 in January and a 35.00 grocery purchase in February, a January 1 date in B1 returns 60.50.

The formula covers rows 2 through 1000, so expand those ranges if the log grows beyond that. The dates need to be recognized as dates by Sheets, not text that merely looks like a date. In a spreadsheet locale that uses semicolons as formula separators, Sheets may display or require semicolons instead of commas; the formula logic is the same.

Break down spending by category and budget

For the next formula, assume Dashboard!A5 contains a category name, such as Groceries; Dashboard!B1 contains the month’s first day; Transactions!A2:A1000 contains dates; Transactions!C2:C1000 contains category names; and Transactions!E2:E1000 contains amounts. Put this in Dashboard!C5, then fill it down beside the other categories:

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

With 42.00 of January groceries and the other example entry categorized as Transport, the Groceries row returns 42.00. The formula uses the category label in A5, so the category text must match the transaction log. Filling it down adjusts the category row reference while keeping the source ranges fixed.

For a remaining-budget calculation, assume the budget is in B5 and actual category spending is in C5. Enter this in D5 and fill down:

=B5-C5

If the grocery budget is 400.00 and the example month has 42.00 of grocery spending, the result is 358.00 remaining. A negative result means spending is above the entered target; it is a flag to review, not a judgment about whether the spending was necessary. Budget amounts are estimates you choose, not figures the sheet can verify.

Review results with filters and charts

A monthly total answers how much was recorded, but a category breakdown helps explain it. On the Transactions sheet, use Data > Create a filter to filter by date, category, or payment method. For a visual summary, select the dashboard’s category labels and actual totals, then choose Insert > Chart. In the Chart editor, check that the category names and values are assigned to the intended axes or series.

A chart is most useful when it stays readable. A bar chart can make it easier to compare several categories with similar amounts; a pie chart can become difficult to interpret when there are many small categories. Include only the selected month’s totals in the chart, and label the month clearly so a screenshot or printed copy is not mistaken for a different period.

At month-end, check for duplicate entries, missing categories, and refunds before treating the total as complete. If you record a refund as a negative expense, document that convention and use it consistently. Otherwise, put refunds in a separate category or column and decide how they should affect your summary.

Common problems and ways to avoid them

A month total is zero or too small: check that dates are actual date values and that the selected month in B1 is the first day of that month. Also confirm that amounts are numeric and that the formula ranges include the latest rows.
A category is missing: look for spelling differences, extra spaces, or a category that is not listed on the dashboard. A dropdown helps prevent many of these mismatches.
The total includes another month: make sure the formula uses both a start date and an exclusive next-month boundary. A date filter that checks only the month number can accidentally combine January from multiple years.
Expenses are counted twice: a bank import and manual entry can contain the same purchase. Compare dates, amounts, and descriptions before combining records, and keep a consistent import process.
Sorting scrambles the data: filter and sort the full transaction table rather than a single column, so each row’s date, category, and amount stay together.

Use four-digit years in dates and keep the date and amount columns in consistent formats. If you copy transactions from a bank file, check the sign convention: some exports show debits as negative numbers. Do not paste those values into a tracker designed for positive expense amounts without adjusting the formula or the entry convention.

Sharing, privacy, and alternatives

Google Sheets can be convenient when you want to access a tracker in a browser or share it with someone who has permission to open it. Use the Share button to review who has access and whether each person can view, comment, or edit. A spending log can reveal sensitive information, so avoid setting general access more broadly than necessary. Do not enter account passwords, full payment-card numbers, or other secrets in the sheet.

Sheets is not the only option. A paper ledger or a simple notes app may suit someone who wants no formulas; a budgeting app may offer bank connections or automated categorization, depending on the service and account. Excel is a reasonable alternative for people who prefer desktop files or already work in Microsoft 365. Basic spreadsheet formulas such as SUMIFS work in both Google Sheets and current Excel, but formatting, charts, and some features may not transfer perfectly between applications. If you download a Sheets file as an Excel workbook, review the formulas and layout after opening it.

Cost and access depend on the account and service plan. Google Sheets is available through Google accounts, while paid Google Workspace plans and third-party budgeting tools have their own terms. Check current plan details rather than assuming a particular feature or storage allowance is included.

Frequently Asked Questions

Does Google Sheets have a monthly expense tracker template?
Templates may be available from the Sheets template gallery, but the choices can change. You can also make a tracker from a blank spreadsheet using a transaction log and a dashboard; check any template’s formulas and categories before entering personal information.

How do I make a monthly total that changes when I select another month?
Put the first day of the month you want to review in a dashboard cell, such as B1, and use a date-bounded SUMIFS formula. Changing B1 then updates the total, provided the transaction dates and amounts are entered in the ranges used by the formula.

Can Google Sheets automatically import my bank transactions?
Sheets does not automatically connect to every bank account by default. You can enter transactions yourself or import a file provided by your financial institution, if available. Review imported dates, debit signs, and duplicate records before using the totals.

Can I track expenses in multiple currencies?
You can record currencies in separate columns or separate tables, but adding amounts with different currencies produces a misleading total unless you convert them consistently. Keep the original amount and currency identifiable, and document any exchange-rate method and date used.

Is a Google Sheets expense tracker private?
It is not automatically public, but people with access can see information according to their permissions. Review the Share settings, limit access to intended viewers, and avoid storing credentials or full card details in the workbook.

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.