Expenses Tracker in Google Sheets: Setup and Tips

Yes—you can make an expenses tracker in Google Sheets by recording each transaction in a table, then using categories, formulas, filters, and summaries to understand where your money goes. In a browser, start with columns for date, description, category, payment method, and amount; this guide explains how to build and maintain a tracker without needing a paid budgeting app.

What a Google Sheets expenses tracker can do

A spreadsheet tracker is a record you update as purchases happen. At its simplest, it totals spending for a chosen period. With a little structure, it can also show category totals, compare months, distinguish cash from card purchases, and flag entries that need review. Google Sheets saves changes to Drive when you are online and makes it possible to share a file with selected people.

It is not automatically connected to a bank account just because it is in Google Sheets. Unless you use a separate service or integration, you enter or import transactions yourself. That manual step gives you control over what is recorded, but it also means the tracker is only as current as your entries. A spreadsheet is most useful when its categories and workflow are simple enough to keep using.

Choose a layout that is easy to update

Keep one transaction per row and use a single header row. A practical starting layout is:

Date: the date the purchase posted or occurred; choose one convention and use it consistently.
Description: a short merchant name or explanation, such as “Market” or “Bus pass.”
Category: a consistent label such as Groceries, Housing, Transport, or Dining.
Payment method: optional, but useful for separating cash, debit, and credit purchases.
Amount: the amount spent, entered as a positive number.
Month: an optional helper column for grouping transactions by month.

For example, a row might read 1/7/2026, Market, Groceries, Debit, 42.50. Decide in advance how to handle refunds and reimbursements. One straightforward approach is to record a refund as a negative amount and label it clearly; that reduces the relevant spending total. If you instead enter refunds in a separate column, make sure your summaries account for them.

Avoid merged cells, blank rows inside the transaction list, and multiple transactions packed into one cell. These make filtering and summaries less dependable. If you want a dashboard, keep it on a separate sheet so the transaction table remains a clean source of data.

Set up the sheet in a browser

Create a blank spreadsheet at Google Sheets, or open an existing file in a web browser. Rename the first sheet something clear, such as Transactions, and type your column headings in row 1. Select the date column and use Format > Number > Date; select the amount column and use Format > Number > Currency. The exact currency symbol depends on the spreadsheet’s locale and formatting choices, so check that it matches the currency you intend to track.

To keep headings visible while scrolling, use View > Freeze > 1 row. To filter the table, click a cell in the data and choose Data > Create a filter. Filter by category, date, or payment method when you need to inspect a subset of transactions. Filtering does not delete rows, but take care not to paste over hidden rows when working with a filtered range.

For consistent categories, select the cells where category entries will go and choose Data > Data validation. Set up a dropdown using the available criteria, such as a list of category values. A dropdown reduces spelling variations like “Dining,” “dining,” and “Restaurants,” which otherwise split one spending type into separate totals. You can revise the list when your needs change.

Use formulas for quick totals

Formulas can calculate totals as entries are added. Suppose transaction amounts are in E2:E5, with example values 42.50, 18.00, 73.20, and 12.30. With those amounts in E2:E5, enter this formula in a total cell: =SUM(E2:E5). It returns 146.00 because 42.50 + 18.00 + 73.20 + 12.30 = 146.00. You can extend the range as the list grows, or use a larger range such as E2:E to include later rows.

A category total is also simple. Assume categories are in C2:C5, amounts are in E2:E5, and H2 contains the category name Groceries. Enter this formula in the summary cell: =SUMIF(C2:C5,H2,E2:E5). If the first and third example transactions are Groceries, it returns 115.70: 42.50 + 73.20. The category text must match the entries in column C; a dropdown helps keep it consistent.

If you add a Month helper column and the transaction date is in A2, enter =TEXT(A2,"yyyy-mm") in the helper cell on row 2, then fill it down. For a date of January 7, 2026, the result is 2026-01. This text label is convenient for grouping, though the original date column should remain a real date so it can be sorted and filtered chronologically.

Build monthly and category summaries

For a quick category breakdown, create a separate summary area with one category per row and a total beside it. A formula like SUMIF can calculate those totals, and the summary can feed a chart. In Google Sheets, select the summary range and choose Insert > Chart. Review the chart type and labels in the Chart editor; a pie chart can show a few broad categories, while a bar or column chart is often easier to compare when there are many categories.

For a larger list, a pivot table can group transactions without writing a separate formula for every category. Select the transaction range and choose Insert > Pivot table. In the pivot table editor, add Category as a row and Amount as a value, summarized by SUM. To review spending by month, include the Month helper as a row or column as appropriate. Check the source range if you add many new rows after creating the pivot table, since a summary only includes the data it is set to use.

Decide whether the tracker measures all spending or only a particular account, household, or budget period. Mixing personal and reimbursable work expenses, for example, can make a monthly chart misleading unless those transactions are clearly identified and reported separately.

Make entry and review a sustainable habit

Choose a routine that fits how you get transaction records. Some people enter purchases daily; others add them once or twice a week by checking bank and card statements. A short, regular review is usually easier than trying to reconstruct several months at once. Mark uncertain entries for follow-up rather than guessing at a category or amount.

Recurring bills deserve a little care. You can record a bill when it actually posts, or use a separate planned-expenses area to note expected costs. Do not count a planned bill as a completed transaction and then add it again when it posts. Keeping planned and actual expenses distinct helps prevent double counting. For subscriptions or annual charges, recording the real charge date and amount makes the transaction history easier to reconcile against statements.

Set a consistent review period, such as the first day of each month. Compare the spreadsheet against account statements, look for duplicate rows, and check that refunds have been recorded as intended. A tracker is a record-keeping tool, not a guarantee that a bank’s pending transactions or statement dates will match your chosen date convention.

Common problems and ways to prevent them

Category totals seem too low: check for blank categories, misspellings, or formulas that stop before the newest rows.
Dates sort strangely: some entries may be stored as text. Apply date formatting and confirm that the values are recognized as dates rather than merely looking like dates.
A total is unexpectedly high: look for duplicate imports, planned expenses included alongside actual charges, or refunds entered as positive spending.
Monthly reports miss transactions: inspect the pivot table’s source range or the date boundaries used in a formula, and make sure dates follow the same convention.
Charts are hard to read: combine overly specific labels into a smaller set of meaningful categories, while keeping descriptions available in the transaction table.

Use one row per actual transaction, and avoid manually typing totals into the transaction list. If you import a bank CSV, inspect the column mapping and date and amount formats before relying on the results. Imported descriptions can vary, and a credit-card payment may be a transfer rather than a new purchase; counting both the original purchases and the payment can double-count spending.

Sharing, privacy, and alternatives

Google Sheets offers sharing controls, but a file containing financial details should not be shared with a public link. Use the Share button to review who has access and whether each person can view, comment, or edit. Give edit access only to people who need it, and avoid putting full account numbers or other sensitive identifiers in the sheet. A spreadsheet password is not a substitute for controlling access to the Google account and file.

Sheets is a useful choice when you want a flexible, low-cost tool and are comfortable entering or importing data yourself. A dedicated budgeting app may offer automatic account connections, transaction categorization, or alerts, but features, fees, and data-handling practices vary by provider. A paper log can suit someone who wants no digital record. Compare the setup effort, privacy expectations, and features you actually need rather than assuming one option is best for everyone.

Google Sheets is not Microsoft Excel, although both handle tables and many familiar formulas. Menu names and some behaviors differ, so follow Google Sheets menus when editing in a browser rather than applying Excel-only instructions. For a simple tracker, the important ideas—consistent columns, clean records, and checked summaries—matter more than the brand of spreadsheet.

Frequently Asked Questions

Does Google Sheets have a free expense tracker template?
Google Sheets provides template options that may include budget or expense-related layouts, though available templates can change. You can also create a basic tracker from a blank sheet using the columns and steps above. Review any template’s categories and formulas before entering real transactions.

Can Google Sheets automatically track my bank transactions?
A standard spreadsheet does not automatically connect to your bank account. You can enter transactions manually or import a file supplied by your bank. Third-party connections or add-ons may offer other options, but check their permissions, costs, and privacy terms before using them.

How do I track expenses by month?
Keep the original transaction date and either use a Month helper column or summarize dates in a pivot table. A helper value such as 2026-01 groups dates in January 2026; the date itself should still be retained so you can audit individual entries.

Can I use the tracker on my phone?
Google Sheets can be used on mobile devices through its app, but this setup guide describes the browser interface. The screen layout and available controls differ on mobile, so creating dropdowns, editing pivot tables, or adjusting charts may be easier on a computer.

How do I share an expenses tracker safely?
Share it only with the people who need access, choose an appropriate permission level, and review access periodically. Do not include unnecessary account credentials or identifiers, and remember that anyone with edit permission can change the sheet’s contents.

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.