Expense Tracker Google Sheets: The Complete Free Setup Guide for 2026

An expense tracker Google Sheets spreadsheet lets you monitor daily spending for free without monthly fees. You build a simple table, connect it to bank exports or manual entries, and use built-in formulas to auto-categorize transactions and visualize your budget in charts. This complete 2026 guide walks you through the setup in about 20 minutes. Ready to start?

A Google Sheets expense tracker does the opposite. It's free, it lives in your Google Drive, and it gives you complete control over your financial data. The tradeoff is that you have to set it up yourself—but that setup takes about 20 minutes, and this guide walks you through exactly what to build.

Copy the free expense tracker Google Sheets template to your Drive in one click—no formulas to build. Get the free template →

What's Your Emergency Fund Runway?

Calculate how many months of freedom you can afford right now

Total Savings ($)

Monthly Expenses ($)

Example: $30,000 saved ÷ $3,000/month = 10 months of freedom

Why Use Google Sheets for Expense Tracking?

Google Sheets isn't the flashiest option, but it's consistently the most durable one. Here's why people keep coming back to it:

It's Free

No subscription, no freemium tier that locks useful features, no app that shuts down after a pivot. Google Sheets is free for personal use and backed by one of the most stable platforms on the internet.

You Own the Data

Your transactions aren't stored on a company's servers or sold to data partners. They live in your Google Drive. You can export, delete, or share them entirely on your terms.

Works on Any Device

Google Sheets runs on desktop, tablet, and mobile. You can enter a transaction from your phone in a coffee shop and it syncs immediately to your desktop. No app download required—a browser is enough.

Adapts to Your Situation

A budgeting app has a fixed structure. Google Sheets adapts to yours. Single income, dual income, freelance, household with kids, FIRE tracking, business expenses alongside personal—you can build for exactly your situation without fighting the software.

Shareable Without Sharing Credentials

If you're tracking shared finances, you can share the spreadsheet with a partner with edit access—or give a financial advisor view-only access—without handing over account passwords.

What Your Google Sheets Expense Tracker Needs

Before touching a cell, understand what you're building. A functional expense tracker has three layers:

Transaction log — the raw data; one row per expense
Category summary — automatic totals by spending category for each month
Monthly overview — income vs. expenses vs. net savings at a glance

Everything else (annual trends, budget vs. actual, charts) builds on top of these three layers. Start with them and add complexity only when you have a specific question the basic version can't answer.

Step-by-Step: Building a Google Sheets Expense Tracker

Step 1: Create the Transaction Log

Open a new Google Sheet. Rename the first tab "Transactions".

In row 1, create these column headers:

Column	Header	Format
A	Date	Date (MM/DD/YYYY)
B	Description	Text
C	Amount	Currency ($1,234.56)
D	Category	Text (data validation dropdown)
E	Payment Method	Text
F	Notes	Text

Formatting tips:

Select column A, go to Format → Number → Date to ensure dates sort correctly
Select column C, go to Format → Number → Currency for consistent display
Freeze row 1: View → Freeze → 1 row, so headers stay visible as you scroll

Step 2: Define Your Categories

Create a second sheet called "Settings". In column A, list your spending categories. Start with these and adjust to your life:

Housing / Rent
Groceries
Dining & Takeout
Transport
Utilities
Health & Medical
Personal Care
Entertainment
Subscriptions
Shopping
Travel
Savings
Other

Why a separate list matters: Your SUMIF formulas—which calculate totals by category—require exact text matches. If you type "Groceries" in one transaction and "Grocery" in another, they won't sum together. A dropdown enforces consistency.

To add the dropdown:

On the Transactions sheet, select the entire column D (except the header)
Go to Data → Data validation
Set criteria to "Dropdown from a range" and point it at Settings!A:A
Click Save

Now every category entry comes from your canonical list.

Step 3: Build the Category Summary

Create a third sheet called "Summary".

Set up this structure:

Row 1 (header): Category | Budget | Actual | Remaining | % Used

Rows 2–15: One row per category. In column A, type your category names (matching exactly what's in Settings).

Column C formula (Actual spending):

=SUMIF(Transactions!D:D, A2, Transactions!C:C)

This totals every transaction in the Transactions sheet where the Category column matches A2.

Column D formula (Remaining):

=B2-C2

Simple: budget minus actual. Negative numbers mean overspent.

Column E formula (% Used):

=IFERROR(C2/B2, 0)

Format this column as a percentage. You'll see at a glance whether you're at 40% or 110% of your category budget.

Add a total row at the bottom:

=SUM(B2:B15)   [total budget]
=SUM(C2:C15)   [total actual]
=SUM(D2:D15)   [total remaining]

Step 4: Add a Monthly Overview

Above your category table (or in a separate section of the Summary sheet), create a header block:

Month:          [type current month]
Total Income:   [manually entered]
Total Expenses: =SUM(C2:C15)
Net Savings:    =income cell - expenses cell
Savings Rate:   =net savings / total income

This is the number you'll look at first every time you open the sheet. Income in, spending out, what's left.

Step 5: Filter Spending by Month

If you use one Transactions sheet for the whole year (recommended—it preserves history), you need to filter summaries by month.

Add a helper column to your Transactions sheet:

Column G header: Month
Column G formula (row 2):

=TEXT(A2,"YYYY-MM")

This converts each date to a "2026-03" style month code. Drag this formula down the entire column.

Update your SUMIF formulas in the Summary sheet to SUMIFS (plural—multiple conditions):

=SUMIFS(Transactions!C:C, Transactions!D:D, A2, Transactions!G:G, "2026-03")

Change "2026-03" to the month you want to show. Or create a cell at the top of the Summary sheet (say, cell B1) where you type the month code, and reference it:

=SUMIFS(Transactions!C:C, Transactions!D:D, A2, Transactions!G:G, $B$1)

Now you change one cell to switch which month the entire summary shows.

Entering Transactions: Three Approaches

Manual Entry

Type each transaction directly into the Transactions sheet. Works well if you review your bank statements weekly and enter in batches. Most people have 20–40 transactions per week—a batch entry takes about 10 minutes.

The discipline here: consistency. A tracker you update every Sunday is better than one you update perfectly once and then abandon.

CSV Import from Your Bank

Most banks let you download transactions as a CSV file. The columns won't match your sheet by default, but a quick paste-and-rearrange (or a VLOOKUP) gets you there fast.

The limitation: CSVs don't come pre-categorized. You'll spend time tagging each transaction—which is where automation helps.

AI-Assisted Categorization

If you export bank transactions regularly, tools exist that auto-categorize them using AI before the data lands in your sheet. This turns a 30-minute monthly task (manually tagging 150 transactions) into a 2-minute task (review and correct the automated tags).

This matters most for people who want the benefits of a Google Sheets tracker but don't want the manual overhead of categorization. The sheet handles your formatting and control; the AI handles the repetitive pattern-matching.

Key Formulas Reference

Here are the formulas you'll actually use, all in one place:

Purpose	Formula
Sum a category for one month	`=SUMIFS(Transactions!C:C, Transactions!D:D, "Groceries", Transactions!G:G, "2026-03")`
Month helper column	`=TEXT(A2,"YYYY-MM")`
Remaining budget	`=B2-C2`
Percentage used	`=IFERROR(C2/B2,0)` formatted as %
Total spending	`=SUM(C2:C15)`
Savings rate	`=D1/B1` where D1=net savings, B1=income
Count transactions in a category	`=COUNTIFS(Transactions!D:D,"Groceries",Transactions!G:G,"2026-03")`
Average transaction size	`=AVERAGEIFS(Transactions!C:C,Transactions!D:D,"Dining & Takeout",Transactions!G:G,"2026-03")`

Setting a Budget (Without Guessing)

If you're new to budgeting, don't try to set spending targets before you have real data. You'll either guess too high (no useful constraint) or too low (constant discouragement).

Instead:

Run the tracker without a budget for one full month
Review your actual category totals
Set budget targets for month two based on what you actually spent—adjusting only the categories where you want to change behavior

This approach gives you a realistic baseline and makes the first month's budget feel achievable rather than arbitrary.

Keeping the Tracker Running: A Sustainable Routine

The biggest risk with any expense tracker isn't bad formulas—it's abandonment. A tracker that goes unupdated for two months is useless.

Weekly (5 minutes)

Open the Transactions sheet. Scan your bank app or statement for the past 7 days. Enter anything new. The goal is to never face a backlog of more than a week.

Monthly (15 minutes)

On the first of each month:

Update the month code in your Summary sheet to the previous month
Review category totals—which were over budget? Which surprised you?
Check your net savings figure
Update budget targets if anything was systematically off

Annually (30 minutes)

Create a new tab called "Annual Review". Copy each month's total income, total expenses, and category totals into a single table. This gives you a year-over-year view that's impossible to get from month-by-month sheets.

Common Setup Mistakes

One Sheet Per Month

Some guides tell you to create a new sheet tab each month. This makes cross-month analysis extremely painful. Use one Transactions sheet with a month helper column, filter by month in your Summary—you get both: all your history in one place and clean monthly views.

Too Many Categories

The more categories you have, the harder entry becomes and the harder the summary is to read. Start with 10–12 categories maximum. "Miscellaneous" or "Other" is a valid and useful category.

No Income Tracking

An expense tracker without income is half a picture. Even a single cell where you enter your monthly take-home pay is enough to calculate net savings and savings rate.

Overly Complex Formulas

If you can't read a formula six months later, it's too complex. The SUMIFS examples above cover 90% of what you actually need. Pivot tables and QUERY functions are powerful but often unnecessary for personal expense tracking.

When to Add More Features

The base setup above handles most use cases. Here's when to add complexity:

Add a year-over-year comparison tab — when you've been tracking for 6+ months and want to see trends

Add a debt payoff tracker — if credit card debt or loan repayment is a meaningful part of your budget

Add a savings goal progress bar — if you're saving toward a specific target (house deposit, emergency fund, holiday)

Add multiple income sources — if you have side income, rental income, or partner income to track separately

Add AI auto-categorization — if manual tagging is taking more than 15 minutes per week and becoming a reason to skip updates

Variations for Different Situations

The core setup works for most people, but specific situations call for specific structures:

Couples and shared finances: You need to track joint expenses, split bills, and individual spending separately. See expense tracker for couples in Google Sheets for a setup that handles configurable bill splits and individual budgets alongside shared ones.

Freelancers and irregular income: Standard monthly budgets break when income is unpredictable. A freelancer budget system uses rolling averages and cash flow smoothing to handle income variability.

Privacy-first tracking (no bank linking): If you want to avoid connecting accounts to any service, a fully offline expense tracker keeps everything local and private.

Family households: When multiple earners and shared expenses are involved, a family budget in Google Sheets adds income tracking per earner, shared expense pools, and household savings goals.

Business expense tracking: If you're self-employed or tracking deductible expenses, you need separate categories and a structure that maps to tax line items. See business expense tracking in Google Sheets for a system built around tax-ready categories.

The Honest Limitation: Manual Entry Takes Time

Google Sheets is the right tool for many people—but the main cost is time. Manual entry, category assignment, and monthly reviews take real effort.

For some people, that effort is the point. The friction of entering every transaction manually creates useful awareness of where money is going. Knowing you'll have to type it in at the end of the week changes how you spend during it.

For others, the friction becomes a reason to stop tracking entirely. If that's you, the answer isn't a fancier spreadsheet—it's removing the manual step. Automated bank transaction import and AI categorization can feed your Google Sheet with categorized data, keeping the control and flexibility of spreadsheets without the tedium of manual entry.

Frequently Asked Questions

Can I use Google Sheets as an expense tracker?

Yes. Google Sheets is one of the best free options for expense tracking. It's flexible enough to handle any budget structure, works on every device, and never locks your data behind a paywall. The main limitation compared to dedicated apps is that setup and data entry require some manual effort—which this guide is designed to minimize.

How do I create a simple expense tracker in Google Sheets?

Start with three sheets: Transactions (one row per expense with Date, Description, Amount, Category), Settings (your category list for dropdown validation), and Summary (SUMIFS formulas to total spending by category and month). That's the complete base system. Add complexity only when you have a specific question the basic version can't answer.

What formulas do I need for a Google Sheets expense tracker?

The two formulas that do most of the work are:

=SUMIFS(Transactions!C:C, Transactions!D:D, "Groceries", Transactions!G:G, "2026-03") — totals spending for a category in a specific month
=TEXT(A2,"YYYY-MM") — creates a month helper column so you can filter by month

Everything else—remaining budget, percentage used, savings rate—is simple arithmetic on top of these two.

Is a Google Sheets expense tracker better than a budgeting app?

It depends on your priorities. Google Sheets wins on cost (free), privacy (no bank connections required), flexibility (you control the structure), and longevity (no app shutdowns). Budgeting apps win on automation (automatic transaction import and categorization) and setup speed. If manual entry is a concern, pairing Google Sheets with an AI categorization tool gives you the best of both approaches.

Getting Started Today

You don't need a perfect system on day one. You need a working one.

Open a new Google Sheet. Create three tabs: Transactions, Settings, Summary. Add the column headers to Transactions. List your categories in Settings. Add the SUMIFS formulas to Summary.

That's it. Enter today's transactions. Come back tomorrow and do it again.

The insight comes from consistency, not complexity. A simple tracker you maintain is worth more than an elaborate one you abandon. Start with the basics above, and add features only when you have a specific gap the current version can't fill.

Skip the setup entirely: Copy the free expense tracker Google Sheets template → — pre-built with all the formulas, categories, and monthly summaries from this guide.

free expense tracker Google Sheets template

step-by-step setup guide

Expertise: This guide was written by a founder with 10+ years of experience building financial automation tools. For more budgeting and expense tracking strategies, explore our complete library of Google Sheets finance tutorials.