Aspire Budgeting

How to Track Expenses in Google Sheets (Simple Setup, No Add-ons)

Published on June 8, 2026

Tracking expenses is the foundation of any budget. Before you can plan where money should go, you need to know where it’s actually going. Google Sheets is a natural fit — it’s free, accessible from your phone, and doesn’t require sharing your bank credentials with anyone.

This guide covers setting up a simple expense tracker from scratch, then shows how to level it up when you’re ready for more.

The simplest expense tracker (5 minutes)

Open a new Google Sheet and create these columns:

DateDescriptionAmountCategory
6/15Grocery store$47.82Groceries
6/15Coffee$5.50Dining
6/16Gas station$42.00Transportation

That’s it. One row per purchase. Log them as they happen (from your phone) or batch-enter each evening.

Add a totals section below or on a second sheet:

=SUMIF(D:D, "Groceries", C:C)

This sums all amounts where the category is “Groceries.” Repeat for each category. Now you can see at a glance how much you’re spending per category per month.

Choosing your categories

Keep it simple to start. Here’s a reasonable starting set:

  • Housing (rent, mortgage)
  • Utilities (electric, water, internet)
  • Groceries
  • Dining out
  • Transportation (gas, transit, parking)
  • Health (medical, gym, pharmacy)
  • Entertainment (streaming, movies, games)
  • Shopping (clothing, household items)
  • Subscriptions
  • Personal care
  • Gifts
  • Miscellaneous

You can always split categories later as patterns emerge. If “Dining out” is consistently your biggest variable expense, you might split it into “Coffee,” “Lunch,” and “Dinner out” to see which habit is driving the cost.

Adding structure: monthly sheets vs. one long list

Option A: One continuous list (recommended)

Keep all transactions in a single sheet, indefinitely. Use date filters or pivot tables to view by month. This makes year-over-year comparisons easy and prevents the “I forgot to start a new sheet” problem.

Add a “Month” column with a formula:

=TEXT(A2, "YYYY-MM")

Then use SUMIFS to total by category AND month:

=SUMIFS(C:C, D:D, "Groceries", E:E, "2026-06")

Option B: One sheet per month

Duplicate the sheet each month. Simpler mentally, but harder to compare across months and easy to fall behind on.

Making it fast: data validation for categories

Typing category names manually is slow and error-prone. Use data validation to create a dropdown:

  1. On a separate “Config” sheet, list your categories in column A
  2. On your Transactions sheet, select the Category column
  3. Data → Data validation → Criteria: “List from a range” → point to your Config sheet categories
  4. Now each cell shows a dropdown when clicked

This takes 2 minutes to set up and saves time on every future transaction.

Useful formulas for expense tracking

Total spending this month:

=SUMPRODUCT((MONTH(A2:A1000)=MONTH(TODAY()))*(YEAR(A2:A1000)=YEAR(TODAY()))*C2:C1000)

Average daily spending:

=total_this_month / DAY(TODAY())

Spending by category (summary table):

Create a summary section with each category name in column A, then:

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

Running balance (if tracking account balance):

Add a “Balance” column:

=previous_balance - current_amount

From tracking to budgeting

Expense tracking answers “where did my money go?” That’s useful, but it’s reactive. You only see the damage after it’s done.

The next step is budgeting — deciding where money should go before you spend it. This means adding a “Budgeted” column next to your category totals and comparing planned vs. actual.

When you want that upgrade without building it yourself, Aspire Budgeting is a free Google Sheets template that adds:

  • A dashboard showing category balances at a glance
  • Zero-based envelope methodology (every dollar gets assigned before spending)
  • Category transfers (move money between categories mid-month)
  • Spending reports and trend tracking over time
  • Multi-account support

It’s the natural next step after basic expense tracking — same platform (Google Sheets), same data ownership (your Drive), but with the budgeting layer built in.

Tips for consistent tracking

Log immediately. Open Google Sheets on your phone right after a purchase. It takes 10 seconds. Waiting until “later” means you forget transactions.

Set a daily alarm. If real-time logging isn’t your style, set a 9pm reminder to enter the day’s spending. Check your bank app for amounts.

Import your bank CSV weekly. If manual entry feels like too much friction, most banks let you download transactions as CSV. You can paste them into your sheet and add categories in bulk. (Aspire Turbo automates this process for $5/month.)

Review weekly, not just monthly. A quick 2-minute look at your category totals every Sunday catches overspending before it compounds.

Don’t track cash you can’t remember. If you spent $3 at a vending machine and forgot, that’s fine. Tracking is about patterns, not forensic accounting. Add a “Cash/Unknown” category for small unmemorable purchases.

When basic tracking isn’t enough

You’ll outgrow a basic tracker when:

  • You want to plan spending, not just record it
  • You want to see trends over 3-6 months
  • You’re budgeting with a partner and need a shared system
  • You want reports without building pivot tables manually
  • You need multiple accounts (checking + savings + credit card)

At that point, a purpose-built template saves significant time. Aspire Budgeting gives you all of this free — copy it to your Drive and migrate your data.

Getting started

  1. Open a new Google Sheet
  2. Add columns: Date, Description, Amount, Category
  3. Set up data validation for categories
  4. Start logging today’s purchases
  5. At month-end, add up categories and see where the money went

That first month of data is worth more than any budgeting advice. It shows your patterns, not averages — and that’s where real change starts.