Google Sheets Expense Tracker: Setup and Formulas

Create an expense tracker in Google Sheets by entering each purchase on its own row, adding consistent columns for date, merchant, category, and amount, then using summary formulas such as =SUM(D2:D1000) to total spending. In a browser, you can build the basic tracker with a blank spreadsheet, dropdowns for categories, and a separate summary or budget tab—no special add-on is required.

Plan the tracker before entering expenses

Start with one tab called Transactions and decide what you want to learn from the data. A simple tracker can answer how much you spent this month and which categories took the largest share. If you also want to compare spending with limits, add a second tab called Budget. Keeping entries in a consistent table makes those calculations easier and reduces errors.

In row 1 of Transactions, add headings such as Date, Merchant, Category, Amount, Payment method, and Notes. Use one row for each purchase or refund, and keep the amount as a number rather than typing a currency symbol into the cell. For example, enter 42.60 in Amount and apply currency formatting to the column. That lets Sheets calculate with the value correctly.

For a small example, imagine these three transactions: groceries for $42.60 on November 1, transport for $18.00 on November 2, and dining for $26.40 on November 3. Use real dates in the Date column, not text such as “Nov 1,” because date-based summaries depend on Sheets recognizing the values as dates. If you track refunds, enter them as negative amounts and decide whether your reports should show net spending or separate purchases and refunds.

Build the transaction table

Open Google Sheets in a web browser, create a blank spreadsheet, and rename the file and first sheet. Enter headings in row 1 and transactions below them. Keep the table rectangular: avoid blank rows between entries, merged cells in the data area, or subtotal rows mixed into the transaction list. Those choices make filtering and formulas less predictable.

Date: the date the expense occurred, entered as a date value.
Merchant: the store, service, or person paid.
Category: a reusable label such as Groceries, Housing, Transport, or Health.
Amount: the amount paid, stored as a number.
Payment method: optional, but useful for reviewing cash, card, or account activity.
Notes: optional context, such as “work lunch” or “annual renewal.” Avoid putting sensitive account details here.

Select the heading row and choose View > Freeze > 1 row so the labels remain visible while scrolling. To filter transactions, choose Data > Create a filter. The filter controls let you show one category or date range without deleting or moving the other records. Sort the full table using a column’s filter control; selecting and sorting only one column can disconnect amounts from their merchants and dates.

Format amounts and control category names

To display amounts as currency, select the Amount column and choose Format > Number > Currency. The displayed currency and symbol can depend on spreadsheet locale and formatting settings. Set a suitable locale through File > Settings if date or number conventions are not what you expect. For example, a date such as 03/04 can mean different days in different locales, so entering an unambiguous date or checking the locale prevents confusion.

Category consistency matters. If one row says “Food” and another says “Groceries,” a summary for Groceries will not include both. To make entry more consistent, create a category list on the Budget tab or another list area, select the Category cells, and choose Data > Data validation > Add rule. Set the rule to a dropdown based on the category range, then save it. The interface may show slightly different labels as Google updates Sheets, but Data validation is the feature to use. A dropdown helps prevent spelling variations; it does not decide which category is right for you.

You can also apply a visual cue to unusually large expenses. Select the Amount range and choose Format > Conditional formatting, then create a rule such as “Greater than” a threshold you choose. This only changes how cells appear; it does not change the amount or flag a transaction as incorrect automatically.

Calculate total and category spending

Place summaries outside the transaction table or on a separate Summary tab. With the sample entries in rows 2 through 4, Date in column A, Category in C, and Amount in D, the overall total is $87.00. In a cell outside the data table, enter:

With amounts in D2:D4, =SUM(D2:D4) adds the three example expenses and returns 87.

To total one category, use SUMIF. With categories in C2:C4 and amounts in D2:D4, =SUMIF(C2:C4,"Groceries",D2:D4) returns 42.6, or $42.60 when formatted as currency. The first range contains the labels to check, the quoted text is the category to match, and the final range contains the values to add. As the tracker grows, expand the ranges or use open-ended ranges such as C2:C and D2:D.

If you want a category total to update from a label in a summary table, put Groceries in F2. With categories in C2:C1000, amounts in D2:D1000, and the summary category in F2, enter =SUMIF($C$2:$C$1000,F2,$D$2:$D$1000) in G2. For the sample data, G2 returns 42.6. The dollar signs keep the transaction ranges fixed if you copy the formula down for other category labels.

Make a monthly summary and simple budget

A monthly total is more useful when it uses real date boundaries rather than matching month names typed as text. Put the first day of the month you want to report in G2—for example, November 1, 2026—and format that cell as a date or month and year. With dates in A2:A1000 and amounts in D2:D1000, enter =SUMIFS($D$2:$D$1000,$A$2:$A$1000,">="&G2,$A$2:$A$1000,"<"&EDATE(G2,1)) in H2. For the three November example expenses, it returns 87. The lower boundary includes the first day of the month; the next-month boundary is exclusive, so expenses on the final day are included without needing to guess how many days are in that month.

On the Budget tab, list categories in column A and planned monthly limits in column B. In C1, label the column Actual; in C2, use the category-total SUMIF formula with A2 as the criterion and the transaction columns as the ranges. In D1, label the column Remaining. With the budget limit 300 in B2 and actual Groceries spending of 42.60 in C2, enter =B2-C2 in D2; it returns 257.4, or $257.40 when formatted as currency. A negative remaining amount means actual spending is greater than the entered limit, but it is a tracking signal rather than a judgment about whether the spending was appropriate.

These examples assume one currency and a monthly budget. If you record expenses in multiple currencies, do not simply add the original amounts together: convert them consistently first and retain the original amount and currency if you need an audit trail. Currency conversion rates and timing can vary, so a homemade tracker should not be treated as an official account statement.

Keep the tracker accurate over time

A tracker is only as useful as its entries. Choose a repeatable routine—for instance, enter purchases daily or reconcile the sheet once a week against account statements. Add a transaction promptly, check the date and amount, and resolve duplicates rather than deleting a whole row by accident. For recurring bills, record each actual charge when it posts; a planned bill and a posted transaction are not the same thing.

Use Data > Create a filter to review a month or merchant, and compare the spreadsheet’s recorded expenses with the relevant account activity. This is a manual check, not an automatic bank reconciliation. Google Sheets does not make every bank or card provider’s transactions appear in a personal sheet by default. A CSV export can sometimes be imported, but review its date, decimal, and category columns before relying on the resulting totals.

Protect formulas from accidental edits by keeping them in a clearly labeled summary area and using cell protection if needed. In Sheets, protection is available under Data > Protect sheets and ranges. Protection helps control editing; it is not encryption and does not make a shared spreadsheet private from people who already have access.

Common problems and practical fixes

A total is zero or too low: check that amounts are numbers, not text, and that category labels match exactly. Currency symbols typed into values or inconsistent category spelling can interfere with calculations.
Dates sort strangely: some entries may be text rather than dates, or the sheet locale may interpret them differently. Format the cells as dates and correct entries that Sheets has not recognized as date values.
A formula shows an error: inspect the range references and quotation marks. In a formula, category text needs straight double quotes, and the ranges being added should line up in size.
Totals change after sorting: sort the whole filtered table, not only one field. Each transaction’s date, category, and amount must stay on the same row.
The monthly figure misses transactions: verify that G2 is the first day of the desired month and that transaction dates are valid date values. Also check that the amounts fall inside the ranges referenced by the formula.

Google Sheets formulas generally use commas between arguments in the examples here. Spreadsheet locale settings can affect date interpretation and, in some locales, formula separators. If a correctly copied formula is rejected, check File > Settings and use the separator expected by that locale.

Privacy, sharing, and alternatives

Expense records can reveal routines, purchases, and financial circumstances. Share a tracker only with people who need access, review the sharing list, and avoid storing full card numbers, passwords, bank logins, or identity documents in cells or notes. Google account security and sharing settings matter, but a spreadsheet is not a replacement for secure banking records. Keep a separate copy or export if you want an offline backup, and consider whether a shared household tracker should use a dedicated account or limited access.

Google Sheets suits people who want flexible categories, custom summaries, and collaboration from a browser. A dedicated budgeting app may offer bank connections, recurring transaction detection, or mobile-first entry, though features, fees, and privacy practices differ by provider. A local spreadsheet or desktop spreadsheet can work offline, but it may require more deliberate file backup and sharing. Choose based on whether customization, automatic imports, offline access, or collaboration matters most to you; check the current terms and privacy information for any service you use.

Frequently Asked Questions

Is Google Sheets free for an expense tracker?
Personal use of Google Sheets is available with a Google account, and a basic tracker does not require a paid add-on. Google Workspace plans and some connected services may have separate costs, so check current plan details if you need business features or third-party integrations.

Can Google Sheets automatically track my bank transactions?
Not by default for every bank or card provider. You can enter expenses yourself or import a downloaded file where supported, but any import should be checked for duplicates, date interpretation, and amount formatting. Third-party connection tools have their own availability, costs, and data-access implications.

What is the best way to categorize expenses?
Use categories that are distinct enough to answer useful questions but few enough to apply consistently. A starter set might include Housing, Groceries, Transport, Health, Dining, Utilities, and Other. Adjust it to your needs, and avoid creating a new label for every merchant.

How do I track expenses by month?
Store each transaction as a date value, put the first day of the month in a summary cell, and use SUMIFS with a start date and the first day of the next month as the exclusive end date. This method includes the entire month even when its number of days changes.

Can I use the same tracker with Excel?
You can open or export spreadsheet data for Excel, and common functions such as SUM, SUMIF, and SUMIFS are available in both applications. Menus, sharing features, data validation interfaces, and some formula details can differ, so check the destination application after moving the file rather than assuming every setting transfers unchanged.

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.