Google Sheets Expense Tracker: Track Every Dollar Without Apps

Most budgeting apps make the same promise: link your accounts, set your categories, watch the magic happen. And for the first week, it feels great. Then the "magic" starts to wobble. The app miscategorizes your coffee as "Dining" instead of "Personal." The free tier locks you out of features you need. Or you realize this app now has access to your bank login and you're not sure how you feel about that.

There's a simpler path. A Google Sheets expense tracker gives you full control over your data, costs nothing, and can be customized in ways no budgeting app will ever allow. Here's how to build one that actually works.

---

Why Budgeting Apps Keep Failing You

The problem isn't your willpower — it's the tool.

Privacy. Linking a budgeting app to your bank account means handing credentials (or OAuth access) to a third party. Most people do this without thinking twice, then feel uneasy later. A spreadsheet has no bank connection — you enter what you want, when you want.

Cost. Nearly every budgeting app has moved to a subscription model. YNAB is $99/year. Mint was shut down. The "free" apps are either ad-supported or have critical features paywalled. Google Sheets is free, forever, with your existing Google account.

Rigid categories. Apps give you preset categories and fight you when your life doesn't fit them. Your situation might have categories that matter to you — "dog expenses," "side project tools," "gifts" — that no app anticipates. A spreadsheet is a blank canvas.

Visibility. Spreadsheets are transparent. You can see every formula, trace every number, and understand exactly how your totals are calculated. Apps are black boxes.

---

Why Google Sheets Works for Expense Tracking

Google Sheets hits the sweet spot between flexibility and structure.

It's free — no subscription, no premium tier, no account linking required. It's accessible everywhere — open it on your phone, tablet, or laptop and it syncs automatically. It's flexible — you define the categories, the formulas, and the layout. And it's shareable — if you manage finances with a partner, you can both edit in real time.

The only real downside is that you have to enter transactions manually. But that's also a feature: the act of entering expenses makes you more conscious of where money is going. Passive tracking is comfortable but doesn't change behavior. Manual entry does.

---

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

Step 1: Set Up Your Transactions Sheet

Create a new Google Sheet. Rename "Sheet1" to Transactions.

Add these column headers in row 1:

• A: Date
• B: Description
• C: Category
• D: Amount
• E: Type (Income / Expense)
• F: Notes

Format column D as currency: select the column → Format → Number → Currency.

Step 2: Add a Category Dropdown

Select all cells in column C (starting at C2). Go to Data → Data Validation → Add Rule.

Under "Criteria," choose Dropdown and enter your categories: Housing, Food, Transport, Health, Personal, Entertainment, Subscriptions, Savings, Income, Other

Customize this list to match your life. Having a dropdown prevents typos and makes filtering consistent.

Step 3: Add a Running Total Formula

In cell G2, add:

=SUMIF(E:E,"Expense",D:D)

This gives you total expenses. Add another in G3:

=SUMIF(E:E,"Income",D:D)

And in G4, your net:

=G3-G2

Label G1 "Expenses," G3 "Income," G4 "Net" so you can glance at it instantly.

Step 4: Create a Monthly Summary Tab

Add a new sheet named Monthly Summary.

In column A, list your categories. In column B, pull totals from the Transactions sheet using SUMIFS:

=SUMIFS(Transactions!D:D, Transactions!C:C, A2, Transactions!E:E, "Expense", Transactions!A:A, ">="&DATE(2026,6,1), Transactions!A:A, "<="&DATE(2026,6,30))

Duplicate this column for each month and update the date range. Now you have a month-by-month breakdown by category. You can see immediately if your food spending crept up in December or whether your subscriptions have grown over six months.

---

Free resource: Want a head start? Grab the free NotionCraft spreadsheet starter kit at notioncraft.madethis.app/free — includes a pre-formatted expense log and category list you can copy and customize in under five minutes.

---

Advanced Move: Conditional Formatting to Flag Overspending

Once you have monthly category totals, you can set spending limits and get a visual alert when you're over.

1. In your Monthly Summary sheet, add a column Budget with your target for each category.
2. Add a column Status with this formula: =IF(B2>C2,"Over","OK")
3. Select the Status column → Format → Conditional formatting.
4. Set: "Text contains Over" → fill red.
5. Set: "Text is exactly OK" → fill green.

Now any category you've exceeded turns red. You can see the problem in one glance without running any numbers in your head.

For a more precise view, add a % Used column: =B2/C2. Format as percentage. When you're at 90%+ of a category budget mid-month, you know to slow down — before you're over.

---

The Weekly 10-Minute Review Habit

A tracker only works if you actually look at it. The most effective habit: a weekly review, same time every week.

When: Sunday evening or Monday morning — before the week starts, not after it ends.

What to do in 10 minutes:

1. Enter any transactions from the past week you haven't logged yet (5 minutes).
2. Glance at the Monthly Summary — any categories in red or approaching their limit? (2 minutes)
3. Adjust your plan for the coming week if needed. Going out a lot this week? Flag it in Notes. (2 minutes)
4. Check your net balance. Are you on track to hit your savings goal? (1 minute)

That's it. You don't need to spend an hour analyzing your finances — you need 10 minutes of consistent attention. The data does the thinking; you just need to look at it.

Over time, the weekly review builds an intuition for your spending that no app notification can replicate. You start to feel the seasons in your budget — the months when expenses spike, the categories where you consistently overspend, the small subscriptions that stack up.

---

Ready to Skip the Build?

If you'd rather start with a fully-built tracker than build from scratch, the Personal Finance Tracker for Google Sheets has everything pre-configured: transaction log with category dropdowns, monthly summary with automatic totals, budget tracking with conditional formatting, and a savings goal dashboard.

Pre-built, pre-formatted, and ready to use the moment you make a copy.

Get the Personal Finance Tracker — $19 →

One copy and your expense tracker is ready to go — no formulas to write, no formatting to configure.