Aspire Budgeting

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

Set up a free expense tracker in Google Sheets in under 10 minutes. Log transactions, categorize spending, and see monthly totals — no apps, no add-ons required.

June 8, 2026

Jump to a section

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:

Date Description Amount Category
6/15 Grocery store $47.82 Groceries
6/15 Coffee $5.50 Dining
6/16 Gas station $42.00 Transportation

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.

Frequently asked questions

What is the simplest way to track expenses in Google Sheets?

Create a sheet with four columns: Date, Description, Amount, and Category. Log each purchase as one row. Use =SUMIF to total spending per category. This takes 5 minutes to set up and gives you a clear picture of where money goes.

How do I categorize expenses in Google Sheets?

Use data validation to create a dropdown list of categories. On a separate “Config” sheet, list your categories, then apply Data → Data validation → List from a range on your Category column. This prevents typos and makes logging faster.

Can I track expenses from my phone?

Yes. The Google Sheets app (iOS and Android) lets you open your expense tracker and add rows on the go. Many people log purchases immediately after paying — it takes about 10 seconds per entry.

How many expense categories should I have?

Start with 10-15 broad categories (Groceries, Dining, Transportation, etc.). You can split them later once you see patterns. Too many categories upfront makes logging tedious and you’re more likely to quit.

What if I want to move from tracking to full budgeting?

Expense tracking shows where money went. Budgeting decides where it should go before you spend it. Aspire Budgeting is a free Google Sheets template that adds a dashboard, category balances, transfers, and reports on top of transaction tracking — the natural next step without switching platforms.