Expense Tracker Template for Google Sheets (Free, 2026)

Most money problems start the same way: you get to the end of the month, look at your balance, and have no idea where it went. An expense tracker fixes that. It's the simplest tool in personal finance — a running list of what you spent, grouped by category — and it answers the one question a bank balance never will. This guide gives you a free Google Sheets expense tracker template with the categories and summaries already built, plus a simple way to keep it current without typing in every transaction.

What an expense tracker actually is

An expense tracker has two moving parts:

1. The log — one row per transaction, with a date, amount, category, and account.
2. The summary — those rows added up by category and by month.

Everything else is presentation. The value is in the summary: once each transaction carries a category, the sheet can tell you that you spent more on dining out than groceries, or that subscriptions quietly grew to a meaningful number. That's awareness you can act on.

A tracker is deliberately lighter than a full budget. A budget sets a planned amount for each category and measures you against it; a tracker just records reality. For a lot of people, starting with reality is the right first step — you can't set a sensible budget until you know what you currently spend.

Why Google Sheets is the best home for it

You can track expenses on paper, in an app, or in Excel. Google Sheets hits a sweet spot:

• Free and cloud-based. No license, and it auto-saves so you never lose your log.
• Works everywhere. Edit on your laptop, log a coffee on your phone with the Sheets app.
• Easy to share. A partner can edit the same tracker in real time — no emailing files.
• Automatable. It connects to Avery, which imports and categorizes your bank transactions for you, so the log stays current without manual entry.

That last point is the difference between a tracker you use for one week and one you keep for years. More on that below.

How to set up an expense tracker in Google Sheets (step by step)

You can build one from scratch, but starting from the free template means the columns, categories, and summary formulas already work. Here's the full process either way.

Step 1: Build the log columns

Create one row per transaction with these columns across the top:

• Date — when the money left your account.
• Amount — what you spent (keep it positive; use a separate column or sign for refunds).
• Category — the bucket this expense belongs to (more on categories next).
• Account — which card or account it came from.
• Merchant / note — where you spent it, so a mystery charge is easy to recognize later.

Keep it to these few columns. The temptation is to add fields you'll never fill in; the trackers that survive are the ones that take ten seconds to update.

Step 2: Build your categories

Down a separate tab or list, define your spending categories. Keep it to roughly 10–15 — too many categories is the number-one reason trackers get abandoned. A solid starter set:

• Groceries
• Dining out
• Transport (gas, transit, rideshare)
• Housing & utilities
• Phone & subscriptions
• Shopping
• Health & personal
• Entertainment
• Travel
• Fees & charges
• Other

Use a dropdown (Data → Data validation) on the Category column so every row picks from the same list. Consistent category names are what make the summary trustworthy — "Groceries" and "grocery" should never be two different buckets.

Step 3: Add the summary

This is where a template saves you. The two formulas that do the heavy lifting:

• Total per category — =SUMIF(category_range, "Groceries", amount_range) adds up every row tagged with that category.
• Total per month — =SUMIFS(amount_range, date_range, ">="&start, date_range, "<="&end) totals a date range.

Lay your categories down the left and your months across the top, and a small grid of SUMIFS formulas gives you a month-by-month breakdown you can read at a glance. A little conditional formatting (shading your largest categories) makes the problem areas jump out.

Step 4: Track your spending

You have three options, in increasing order of "set it and forget it":

1. Manual entry — add each expense as it happens. Most accurate, most effort.
2. Weekly catch-up — sit down once a week with your statements and enter everything. Ten minutes.
3. Automatic sync — connect Avery and your transactions import and categorize themselves.

Option 3 is the only one that survives a busy month, which is exactly when an honest spending picture matters most.

Step 5: Review the summary weekly

A tracker is only useful if you look at it. Put a recurring 10 minutes on your calendar — Sunday evenings work well — to scan your category totals. The point isn't to feel bad about a number; it's to notice the one or two categories that drifted and decide whether that's fine or worth changing. Small, regular reviews beat a once-a-year reckoning every time.

What to do with the patterns you find

After a few weeks the tracker stops being a data-entry chore and starts being useful. A few moves that pay off:

• Find the silent leaks. Subscriptions, delivery fees, and "small" daily purchases are where money disappears without a single big shock. The category totals make them obvious.
• Right-size one category at a time. Don't overhaul everything. Pick the category that surprised you most and set a soft cap for next month.
• Graduate to a budget when you're ready. Once you know your real numbers, a planned amount per category is a small step. The Budget Spreadsheet template adds a plan-versus-actual column on top of the same logic.

Expense tracker vs. a budgeting app

People reach for a spreadsheet instead of an app like Mint, YNAB, or Copilot for a few consistent reasons:

The historical trade-off was sync: apps imported transactions automatically, spreadsheets didn't. Avery closes that gap — you get app-style automatic bank sync inside a sheet you own. If you're comparing tools, the bookkeeping-in-Sheets guide walks through the same idea for small-business records.

Keeping the tracker current (the part that matters)

Here's the uncomfortable truth about every expense tracker: it dies the moment you stop entering data. February is where most trackers go quiet — not because the sheet failed, but because manual entry is a chore nobody keeps up.

That's the problem Avery solves. Connect your bank with a read-only link and Avery:

• Imports every transaction automatically into the tracker.
• Categorizes each one with AI, learning your corrections over time.
• Keeps the summaries live, so your spending picture is always accurate.

You go from "type in 60 transactions" to "spend five minutes confirming categories." The tracker stays current, which means you actually keep using it — and an expense tracker you keep using is the one that changes how you spend.

Related templates and guides

• Expense Tracker template — the free Google Sheet this guide is built around.
• Expense tracker Q&A — quick answers to the most common setup and customization questions.
• Budget Spreadsheet template — add a planned amount per category when you're ready to budget.
• Freelancer Expense Tracker template — the self-employed version with Schedule C categories and deduction calculators.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• Simplify bookkeeping in Google Sheets — the same automation idea applied to business records.
• Browse all free templates — the full Avery library.

An expense tracker gives you awareness; automation keeps it alive. Start with the free template, make the categories yours, and let Avery handle the data entry so you're still seeing clear numbers in month six — not staring at a balance and wondering where it all went.