The Google Sheets expense tracker

You opened the spreadsheet with good intentions. For a week, maybe two, every coffee and invoice landed in a tidy row. Then a busy day hit, the rows stopped, and now there's a three-week gap you're never going back to fill. Sound familiar?

A Google Sheets expense tracker is still one of the fastest, cheapest ways to see where your money goes, no app, no subscription, no bank login. This guide gives you a free Google Sheets expense tracker template, shows you how to build one yourself, turns it into a monthly expense calculator, and points you to a printable version. Then we'll be honest about the one thing spreadsheets can't fix.

Why a Google Sheets expense tracker is still a great first step

Budgeting apps are great until they ask you to link every bank account before you can see a single number. A spreadsheet asks for nothing. You own the file, you can see every formula, and you can bend it to your exact situation, side hustle, household, or a single trip.

For a first system, an expense tracker in Google Sheets gives you:

• Zero cost and zero lock-in. It lives in your Drive, works on any device, and you can export it anywhere.
• Full visibility. Every total is a formula you can read, so the math is never a black box.
• Total flexibility. Add a column for deductible business expenses, a tab for a specific project, whatever you need.

What's inside the free template

The Google Sheets expense tracker template above is built to work the moment you copy it. Four tabs:

• Expenses — your running log: date, merchant, category, amount, and notes.
• Dashboard — category totals and a monthly expense calculator that updates as you type.
• Categories — an editable list that powers the dropdowns, so spelling stays consistent.
• Printable — a clean, letter/A4 layout for logging on paper.

How to build an expense tracker in Google Sheets yourself

Prefer to roll your own? You can build a working tracker in about ten minutes.

1. Set up your columns

In row 1, add headers: Date, Merchant, Category, Amount, and Notes. Select the Amount column and set its format to currency (Format → Number → Currency).

2. Add category dropdowns

Select the Category column, choose Insert → Dropdown, and list your categories: Food, Transport, Rent, Subscriptions, Income, and so on. Dropdowns stop "Coffee" and "coffee" from splitting into two categories and breaking your totals.

3. Total each category

On a second tab, total each category with one formula:

=SUMIF(Expenses!C:C, "Food", Expenses!D:D)

That reads: add up column D (Amount) wherever column C (Category) equals "Food." Copy it down for each category and you have an instant breakdown.

Turn it into a monthly expense calculator

A list of expenses isn't a monthly expense calculator until it answers one question: how much did I spend this month? Two formulas get you there.

Total for everything logged:

=SUM(Expenses!D:D)

Total for a single month (using SUMIFS on the date range):

=SUMIFS(Expenses!D:D, Expenses!A:A, ">="&DATE(2026,5,1), Expenses!A:A, "<="&DATE(2026,5,31))

Subtract your income rows from your expense rows and you have a monthly net, the simplest budget that exists. The template wires this up for you with a month selector, so you never touch a formula.

Want it on paper? The printable expense tracker

Some people stick to a habit better with a pen. The template's printable expense tracker tab is formatted for letter and A4: print a fresh sheet for the week, keep it on the fridge or in your bag, and log spending as it happens. Transfer it to the digital tab on the weekend, or hand it straight to your accountant.

Self-employment bookkeeping in Google Sheets

Freelancers and sole traders can stretch a spreadsheet a long way. To use this as a self-employment bookkeeping system in Google Sheets, add three things:

• A Business / Personal column so you can filter out personal spend at tax time.
• A Deductible? column (yes/no) to flag write-offs as you go, far easier than reconstructing them in April.
• A Receipt column with a link to a photo in your Drive, so the proof is attached to the row.

That covers light bookkeeping. The catch is the receipt column: it only helps if you actually photograph the receipt, upload it, grab the link, and paste it in, four steps, per receipt, forever.

Where the spreadsheet quietly breaks down

Here's the honest part. A Google Sheets expense tracker doesn't fail because of bad formulas. It fails because of one word: typing.

Every transaction is a manual chore, open the sheet, find the row, type the merchant, pick the category, enter the amount. Miss a few days and the backlog feels like homework. Most spreadsheet trackers are abandoned within a month, not because people stop caring about money, but because the data entry never stops.

The upgrade: stop typing, just talk

This is the part the spreadsheet can't solve, and the reason Tapsayve exists. Instead of opening a sheet and typing a row, you say it:

"Lunch with Sarah at Joe's, twenty-four bucks."

Tapsayve transcribes it, pulls out the merchant, amount, currency, and category, and files it, in about five seconds, in any of 30+ languages. Got a paper receipt? Snap a photo and the AI receipt scanner reads the line items, tax, and total for you. No row to find, no formula to maintain, no backlog to dread.

You still get everything the spreadsheet gave you, category totals, monthly summaries, CSV and tax-bundle exports for your accountant, plus an AI spending summary that writes the month up for you. The difference is you never type a row again.

Keep the template for the months you want full manual control. When the typing wears thin, the upgrade is one tap away, and the free plan costs nothing to try.