Google Sheets Expense Tracker: Build One (Free)

July 3, 2026 · 9 min read · by the Trace team

A spreadsheet is one of the best free ways to watch your money — no subscription, no bank login, total control. This guide shows you how to build a Google Sheets expense tracker from scratch: the exact columns to use, the two formulas that do all the heavy lifting (=SUM and =SUMIF), a tidy category drop-down, and a monthly-tab layout that keeps things manageable. No template to hunt for — you'll understand every cell, so you can bend it to your life. And when a spreadsheet stops being the right tool, we'll be honest about that too.

Why a spreadsheet works so well for expenses

Spreadsheets sit in a sweet spot. They're free, they're private (nothing is linked to your bank), and they force you to look at each number as you type it — which is half the value of tracking in the first place. A Google Sheets expense tracker also lives in the cloud, so you can log a purchase from your phone and review it later on a laptop. The one thing it asks of you is a little setup and the discipline to keep opening it. Get past that and you have a tool that does exactly what you tell it, and nothing you didn't ask for.

Step 1: Set up your columns

Open a new sheet at sheets.new and name the first tab after the current month — say Jul 2026. In row 1, add these five headers. This layout covers everything most people need without clutter:

A few setup touches make it pleasant to use. Select row 1 and make it bold, then use View → Freeze → 1 row so your headers stay put as you scroll. Select column D and set Format → Number → Currency so amounts line up neatly. That's the whole foundation — everything else builds on these five columns.

Step 2: Add the totals with SUM

Now make the sheet add itself up. Leave a couple of blank rows under your headers for data, then pick a summary spot off to the side — say cell G1. Label G1 "Total spent" and in H1 enter:

=SUM(D2:D)

The open-ended D2:D range means the total keeps working no matter how many rows you add — you never have to update the formula. As you log expenses down column D, H1 shows your running monthly total automatically. That single formula is the backbone of the whole tracker.

If you also want to track income in the same sheet, add a row type or simply enter income as a negative expense — but most people keep it simpler by giving income its own small section or a separate tab. For a pure spending tracker, =SUM on column D is all you need.

Step 3: Add a category drop-down

Typing categories by hand invites typos — "Groceries" and "groceries" and "grocery" become three different things to a spreadsheet, which quietly breaks your totals. A drop-down fixes that. First, list your categories somewhere out of the way, say cells K1 down to K9:

Housing
Groceries
Eating out
Transport
Subscriptions
Shopping
Health
Fun
Other

Then select column C (from C2 down), open Data → Data validation → Add rule, choose "Dropdown from a range", and point it at K1:K9. Now every Category cell is a clean pick-list. The nice part: if you edit that list in column K, the drop-down updates itself. Keep the list short — eight or nine categories is plenty, and it keeps your reports readable.

Step 4: Total each category with SUMIF

Here's where the tracker earns its keep. =SUMIF adds up only the amounts that match a given category, so you can see exactly where your money goes. In a spare block, list your categories again in one column and put a formula beside each. If category names sit in G3:G11 and you want the totals in H3 downward, click H3 and enter:

=SUMIF(C:C, G3, D:D)

Read it as: "look through column C (the categories); wherever it matches the label in G3; add up the matching numbers from column D (the amounts)." Drag that formula down beside each category and you get a live breakdown — Groceries 312.40, Transport 88.00, and so on. The three ranges must line up, and the middle argument is your criterion; you can hard-code it in quotes instead, like =SUMIF(C:C, "Groceries", D:D), but pointing at a cell is tidier and easier to copy. This category block is your monthly report, and it updates the instant you log a new expense.

Step 5: Use one tab per month

Don't let a single endless list swallow the whole year. The cleanest approach is one tab per month. Once your Jul 2026 tab is set up the way you like, right-click the tab, choose Duplicate, rename the copy Aug 2026, and clear out July's rows — your headers, drop-down and formulas all come along for free. This keeps each month fast and easy to read, and it makes month-to-month comparison trivial: just glance from one tab's category totals to the next. If you want an annual overview later, add a summary tab that pulls each month's totals together, but you don't need it to get started.

Where a Google Sheets expense tracker breaks down

A spreadsheet is excellent, but it isn't magic, and it's worth knowing the limits before you rely on it:

• It's fully manual. Nothing imports. Every coffee and every subscription is a row you type — and the day you stop typing is the day the tracker stops being true.
• Receipts don't live in it. You can't neatly attach a receipt photo to a row, so proof of purchase ends up in a separate folder (or lost). For warranties, returns or expenses you'll claim, that separation is a real weakness — our receipt organizer guide covers ways around it.
• Multiple currencies get painful. A plain =SUM will happily add 100 USD to 100 EUR and give you 200 of nothing. If you earn or spend across currencies, you're stuck maintaining conversion columns by hand, and the totals are only ever as fresh as your last manual rate.
• There are no reminders. A sheet won't nudge you about a credit-card due date or a subscription renewal. It shows what happened; it can't warn you about what's coming.
• It's easy to abandon. The tracker that lives in a file you forget to open is the one you quietly stop using. Spreadsheets have no gentle prompt to bring you back.

None of this makes a spreadsheet a bad choice — for a single-currency, hands-on tracker it's genuinely great. But if you keep bumping into these edges, that's the signal to let a purpose-built tool carry more of the load. (The same trade-offs, incidentally, apply when you build a habit tracker in Google Sheets — powerful and free, but manual, with no reminders and easy to drift away from.)

When to switch to an app (and how Trace helps)

If the DIY upkeep is starting to outweigh the insight — the currency columns, the receipt folder, the missed due dates — a dedicated tracker removes that friction while keeping the parts you liked about your sheet.

Trace is a free web app that keeps the spreadsheet's best qualities and fixes its worst. Like a sheet, entry is manual — a deliberate privacy trade-off, so there's no bank login and nothing shared — but it handles the maths and the parts spreadsheets fumble. It holds accounts in any currency (USD, EUR, GBP, JPY, AUD and more) with per-currency totals that never merge into one meaningless number, so the multi-currency headache simply goes away. You can attach a receipt or invoice photo straight to any transaction, so proof lives with the record instead of in a lost folder. It tracks subscriptions, credit-card statements and due dates, and logs buy-now-pay-later instalments, so nothing coming up catches you out. It runs in any browser and syncs across devices with a Google sign-in — and if you want a fuller comparison of tools, our money tracker guide covers the landscape. The honest limit is the same one your spreadsheet had: it won't import your transactions for you. That's the cost of keeping your data private and yours. If you're deciding between the two approaches from scratch, our how to track expenses guide weighs spreadsheet versus app in more detail.

Frequently asked questions

Is there a free Google Sheets expense tracker template?

Yes — Google Sheets includes a built-in personal budget template (in the template gallery), and plenty of free ones exist online. But building your own from a blank sheet takes about ten minutes and means you understand every formula, so you can adapt it instead of fighting someone else's layout. This guide walks you through that build step by step.

How do I make an expense tracker in Google Sheets?

Add five columns — Date, Description, Category, Amount and Account/Currency — then use =SUM(D2:D) for your running total and =SUMIF(C:C, "Category", D:D) to total each category. Add a drop-down on the Category column with Data validation so your labels stay consistent, and use one tab per month to keep it manageable. That's a complete, genuinely useful tracker.

What's the difference between SUM and SUMIF?

=SUM adds up every number in a range — use it for your overall total. =SUMIF adds up only the numbers that match a condition, like a category — use it to see how much went to Groceries or Transport. Together they give you both the big total and the per-category breakdown, which is the heart of any expense tracker.

Is a spreadsheet or an app better for expenses?

A spreadsheet is better if you want full control, enjoy building your own formulas, track a single currency and don't mind remembering to open it. An app is better if you want reminders, receipts attached to transactions, multi-currency totals handled for you, and less friction overall. Spreadsheets win on flexibility; apps win on convenience — and convenience is what keeps most people tracking long-term.

How do I handle multiple currencies in a Google Sheets expense tracker?

Honestly, this is where spreadsheets struggle. A plain =SUM will add different currencies into one meaningless figure, so you'd need separate columns or tabs per currency and manual conversion rates that you keep updating. If you regularly deal with more than one currency, a tool like Trace that keeps per-currency totals separate by design will save you a lot of manual work.

Can I track expenses in Google Sheets on my phone?

Yes. The Google Sheets mobile app lets you open the same sheet and add rows on the go, which is handy for logging a purchase in the moment. It's a little fiddlier than typing on a laptop, and there are no reminders to prompt you, so many people log quick entries on their phone and do their weekly review on a bigger screen.

← Back to the Trace blog