How to Track Expenses in Google Sheets (Complete Guide)

To track expenses in Google Sheets, you need one tab where each row is a purchase (Date, Category, Amount, Notes), a dropdown for categories, and a SUMIFS formula that totals the current month. That takes about 15 minutes to build. The part most guides skip is logging from your phone, which is where most spreadsheet trackers die. This guide covers both.

You'll go from a blank sheet to a monthly dashboard that resets by itself on the 1st, then look at three realistic ways to add expenses on the go.

Why track expenses in Google Sheets instead of an app?

A budgeting app gives you a dashboard on day one. A spreadsheet takes a little set-up, but you get things in return that most apps don't offer:

• You own the data. It's a file in your Google Drive. No app can lock it behind a subscription or take it with them when they shut down.
• No bank connection. You record only what you choose to record. (If that matters to you, here's how to track expenses without linking your bank.)
• It's yours to shape. Want a column for "work trip" or a chart nobody else offers? Add it.
• It's shareable. A partner or accountant gets a link, not an export.

The trade-off is that you build it once and enter data yourself. Both are easier than they sound.

Step 1: Set up the columns

Create a new spreadsheet, rename the first tab Expenses, and add these headers in row 1:

A few rules keep the sheet easy to calculate later:

1. One expense per row. Never put two purchases in one row or a subtotal in the middle of the data.
2. No blank rows or merged cells inside the table. Formulas read whole columns, and gaps cause confusion.
3. Freeze the header row (View → Freeze → 1 row) so you always see the column names.
4. Format the Amount column as currency and type only numbers. "$12.50" typed as text won't add up.
5. Make sure dates are real dates. If a date sits on the left of its cell, Sheets is treating it as text. Re-enter it or fix the format.

Want an Income tab too? Use the same pattern: Date, Source, Type, Amount.

Step 2: Add category dropdowns

Free-typed categories drift. "Food", "food", "Groceries" and "Eating out" end up as four separate totals. A dropdown fixes that.

1. Select the Category column (click the B header).
2. Go to Insert → Dropdown. The data validation panel opens.
3. Add your options, one per line. A good starting set: Food, Transport, Rent, Utilities, Health, Entertainment, Shopping, Other.
4. Pick a color for each if you like. Colored chips make the sheet easier to scan.
5. Under Advanced options, choose Reject the input so typos can't sneak in.

Repeat for the Payment column with Cash, Card and Transfer.

Keep it to 6–10 categories at first. Too many choices slow down every entry, and you can always split a category later. Dropdowns also pay off on mobile: some apps (Voice Sheet included) read your dropdown options and use them as the choices in their entry form.

Step 3: Total each month with SUMIFS

SUMIFS adds up the numbers that match every condition you give it. For a month, the conditions are "on or after the 1st" and "before the 1st of next month".

To avoid editing formulas every month, create a second tab called Settings that works out the current month for you:

DATE handles December for you: month 13 rolls over to January of the next year.

Now the total spent this month is:

=SUMIFS(Expenses!C:C, Expenses!A:A, ">="&Settings!$B$4, Expenses!A:A, "<"&Settings!$B$5)

And the total for one category (with the category name in cell A2) adds a third condition:

=SUMIFS(Expenses!C:C, Expenses!B:B, A2, Expenses!A:A, ">="&Settings!$B$4, Expenses!A:A, "<"&Settings!$B$5)

If a SUMIFS returns 0 when it shouldn't, the usual cause is dates stored as text. Test a cell with =ISNUMBER(A2). If it says FALSE, that date isn't a real date.

Want last month instead? Change B3 to =MONTH(TODAY())-1, or type any month number to look back.

Step 4: Build a simple budget dashboard

Add a third tab called Dashboard with one row per category:

Fill the formulas down for every category. Then add:

• A total row at the bottom: =SUM(B2:B9) for the budget and =SUM(C2:C9) for spent.
• Conditional formatting on the Remaining column (Format → Conditional formatting → "Less than 0", red fill) so overspending jumps out.
• Protection on the formula cells (Data → Protect sheets and ranges) so nobody overwrites them by accident.

Because every formula points at the Settings dates, the dashboard starts fresh on the 1st of each month without any editing. Last month's expenses stay untouched in the Expenses tab.

If you'd rather not build this yourself, Voice Sheet's free Personal Finances template comes with Expenses, Income and a Monthly Budget tab already wired up this way, and the budget dashboard shows budget versus spent per category. There are more free Google Sheets templates for other kinds of tracking, and the full template walkthrough is in our free Google Sheets expense tracker template guide.

How do you log expenses to Google Sheets from your phone?

This is where most trackers fail. The sheet works perfectly on a laptop, but you spend money standing in a shop with your phone in one hand. If adding a row takes a minute, you'll put it off, the receipts pile up, and by week three the sheet is abandoned.

There are three realistic options:

Option 1: Type directly in the Sheets app

It works and costs nothing. To make it bearable, keep the newest rows at the top or jump to the end with a filter view, and use your keyboard's dictation button to fill the Notes cell. Expect it to be slow. Every entry means scrolling, tapping a cell, typing, moving to the next cell and repeating.

Option 2: Use a Google Form

Create a form with questions matching your columns (Date, Category as a dropdown, Amount, Notes), then link it to your spreadsheet from the form's Responses tab. Save the form link to your home screen.

It's faster than typing in cells, and the form is easier to tap through. But responses go into a new "Form Responses" tab, not your Expenses tab, so your formulas need to point there. And whenever you add a category, you have to update both the sheet's dropdown and the form.

Option 3: An app that writes rows to your sheet

Some apps connect to your Google account and add rows to a sheet you choose. That's what Voice Sheet's expense tracker for Google Sheets does. It reads your column names and dropdown options and builds a phone-sized form from them. You can also say an entry, like "lunch 12.50 yesterday, card", and it fills Date, Category, Amount and Payment for you, then shows the form so you can check it before saving.

The row lands in your sheet like any other, so your SUMIFS and dashboard update straight away. There's no Voice Sheet database of your entries: the data lives on your phone and in your own Google Sheet. The form entry is free; voice entry, pasting a list of expenses, and the home screen widget are part of Premium.

Whichever you choose, the habit matters more than the tool: log it when you pay, then take two minutes in the evening to add anything you missed.

Share your expense tracker with a partner or accountant

A Google Sheet is easy to share, which makes it a natural choice for households and freelancers.

With a partner: click Share, add their email and give them Editor access. Add a Person column (a dropdown with both names) so you can see who spent what. Both of you can log from your own phones into the same sheet.

With an accountant or bookkeeper: give Viewer or Commenter access instead. They see the live data whenever they need it, and you never email another CSV. If they want a file, File → Download → Microsoft Excel (.xlsx) or CSV works too.

Keep personal and business separate: if you're self-employed, use a separate spreadsheet (or at least a separate tab) for business expenses, so you can share it without exposing your personal spending.

Common mistakes to avoid

• Too many categories. Start small. Splitting "Food" into "Groceries" and "Eating out" later is easy; merging fifteen categories is not.
• Text in the Amount column. "12.50 approx" breaks totals. Put comments in Notes.
• Catching up weekly from receipts. It feels efficient, but it's the main reason people quit. Log at the moment of payment.
• Rebuilding the sheet every month. Use the Settings-tab approach above instead of copying a new tab each month.
• Mixing currencies in one column. If you spend in several currencies, use one spreadsheet per currency or per trip, rather than adding numbers in different currencies together.

Start with the simplest version that works

You can track expenses in Google Sheets with four columns, one dropdown and one formula. Build that today, log every purchase for a week, and add the dashboard once you've seen what you actually spend. The spreadsheet is the easy part. A phone capture method fast enough to use at the till is what keeps it going past the first month.