How do I make an expense tracker in Google Sheets?

Open a new sheet, add columns for Date, Merchant, Category, Amount, Payment method, and Notes, and freeze the header row. Format the Amount column as currency and add dropdowns to the Category column using Data → Data validation. Then create a Summary tab with SUMIFS formulas for monthly totals and a pie chart by category.

Is there a free Google Sheets expense tracker template?

Yes. Google Sheets ships with a "Monthly budget" template and an "Annual budget" template under File → New → From template gallery. Both include monthly totals, category breakdowns, and a starting chart. You can also rebuild the layout described on this page in about 10 minutes.

Google Sheets vs. an expense tracking app — which is better?

Google Sheets is free and flexible, but every transaction requires manual entry and every report requires a formula. An AI-powered app like Smart Expense captures receipts from email, scans paper receipts, and generates reports automatically. Use Google Sheets if you want full formula control. Use Smart Expense if you want the tracking to happen on its own.

Can I import my Google Sheets expense tracker into Smart Expense?

Yes. Export your Google Sheets tracker as CSV and forward it to Smart Expense — we preserve the date, merchant, category, amount, and notes fields. New expenses then flow in automatically from email or receipts, so you never have to paste rows again.

What formulas should I use in a Google Sheets expense tracker?

SUMIFS handles monthly totals across date ranges, SUMIF sums a specific category, and COUNTIF with INDEX/MATCH finds your most frequent merchant. Combine these on a Summary tab with a pie chart of category totals for a one-glance monthly view.

Does Google Sheets sync receipts from Gmail?

Not natively. You would need a third-party Apps Script, an extension, or a paid Zapier / Make flow. Smart Expense is built for this — it connects to Gmail or Outlook via secure OAuth and pulls expenses automatically with no scripts to maintain.

Is Google Sheets good for tracking business expenses?

For very small workloads, yes. It becomes painful once you have dozens of transactions a week, multiple categories, or tax reporting requirements. An automated app saves hours every month and produces cleaner records at tax time.

Can I track expenses in Google Sheets on my phone?

Yes — install the Google Sheets mobile app and pin your tracker to the home screen. Entry on a phone keyboard is slow, which is why most people eventually move to a dedicated tracker like Smart Expense that accepts chat-style input.

Free template + the AI alternative that logs expenses for you

Expense tracker Google Sheets: free template and a smarter way

Build your own Google Sheets expense tracker in under 10 minutes with the columns, formulas, and summary tab on this page — or skip the spreadsheet entirely and let Smart Expense capture every receipt from Gmail, Outlook, and your camera automatically.

Works with existing Google Sheets exports Set up in under 10 minutes

Free template Setup steps Key formulas Sheets vs Smart Expense When to upgrade FAQ

Free template

Copy this Google Sheets expense tracker layout

Every reliable Google Sheets expense tracker uses the same six columns. Recreate this table in a blank sheet, format the Amount column as currency, and you have a working tracker in minutes — no add-ons required.

Tip: duplicate the tab for each month, or use a single sheet with date filters. Both approaches work, but a single sheet scales better when you add formulas.

expense-tracker.gsheet

Column

What it captures

Type

Date

Transaction date (auto-sorted).

=TODAY()

Merchant

Who you paid — store, vendor, service.

Text

Category

Dropdown with presets.

Data validation

Amount

How much you spent in your currency.

Currency format

Payment method

Card, cash, or account used.

Dropdown

Notes

Quick context for later review.

Free text

Step-by-step

How to make an expense tracker in Google Sheets

Five steps take a blank Google Sheet from empty to a usable tracker with dropdowns, currency formatting, and a working summary.

Copy a Google Sheets expense tracker template

Open a blank Google Sheet and add columns for Date, Merchant, Category, Amount, Payment method, and Notes. Freeze the header row with View → Freeze → 1 row so it stays visible as you scroll.
Set dropdowns and currency formatting

Select the Category column and use Data → Data validation to add options like Food, Travel, Bills, Subscriptions. Format the Amount column as currency via Format → Number → Currency.
Add a summary tab with formulas

Create a second sheet named "Summary". Use SUMIFS for monthly totals, SUMIF for category totals, and a simple pie chart for a one-glance view of where your money goes each month.
Enter receipts as they happen

Type or paste every receipt the same day — Google Sheets has no automation, so consistency is what keeps it accurate. Use the mobile app when you are on the go.
Review weekly, export monthly

Scan the Summary tab every Sunday and flag anything unusual. Export to CSV or PDF at month-end for bookkeeping, taxes, or to share with a partner.

Don't want to build it?

Smart Expense does every step automatically — no formulas, no manual entry.

Try Smart Expense free →

Formulas

Four Google Sheets formulas that power every expense tracker

Paste these into your Summary tab, adjust the ranges, and you have monthly totals, category breakdowns, and spending insights — no add-ons required.

Monthly total

=SUMIFS(D:D, A:A, ">="&DATE(2026,1,1), A:A, "<"&DATE(2026,2,1))

Adds every expense dated in January 2026. Change the month to see any period.

Total by category

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

Sums the Amount column for all rows tagged "Food". Duplicate for each category.

Running balance

=E2-SUM($D$2:D2)

Subtracts running expenses from a starting budget in column E to show what is left.

Top merchant

=INDEX(B:B, MATCH(MAX(COUNTIF(B:B,B:B)), COUNTIF(B:B,B:B), 0))

Finds the merchant you paid most often — great for spotting subscriptions.

Comparison

Google Sheets vs. Smart Expense

Google Sheets wins on flexibility. Smart Expense wins on automation. Here is how the two approaches compare on the tasks that actually take up your time.

Feature	Google Sheets	Smart Expense
Free to start	Yes	Yes
Works on mobile & desktop	Yes	Yes
Manual data entry required	Every transaction	Optional
Auto-capture receipts from Gmail / Outlook	No	Yes
Scan paper receipts with your camera	No	Yes
AI auto-categorization	No	Yes
Chat-style expense entry	No	Yes
Export to CSV / Excel	Yes	Yes
Typing formulas to get totals	Required	Built-in reports
Privacy (no inbox storage)	N/A	Yes

Why upgrade

When a Google Sheets expense tracker stops being enough

A spreadsheet is perfect for 5–10 transactions a week. Above that, the time you spend typing rows, fixing formulas, and tagging categories adds up fast.

Stop copying rows from receipts

Smart Expense reads Gmail and Outlook confirmations and turns them into structured entries — the one task Google Sheets can never automate on its own.

Automatic categorization

AI assigns categories like Travel, Meals, or Subscriptions based on the merchant, so you do not have to set data validation rules or maintain dropdown lists.

Reports without formulas

Monthly totals, top merchants, and category breakdowns appear instantly — no SUMIFS, no chart builder, and no broken references when you edit a row.

Privacy-first by design

Your email content is not stored on our servers. Smart Expense extracts the expense details and leaves your inbox untouched.

Still love spreadsheets?

Export everything to CSV or Excel whenever you want. Smart Expense captures the data — you decide where it ends up.

iOS and Android native

Log expenses on the go with a proper mobile app — faster than tapping individual cells in a Google Sheets mobile view.

Get the automated alternative to a Google Sheets expense tracker

Scan receipts, chat with AI, and sync expenses from Gmail or Outlook. Smart Expense is free to start on iPhone and Android.

Download free → Browse expense guides

FAQ

Google Sheets expense tracker questions

Everything people ask about tracking expenses in Google Sheets, from templates to formulas to syncing receipts.

How do I make an expense tracker in Google Sheets?: Open a new sheet, add columns for Date, Merchant, Category, Amount, Payment method, and Notes, and freeze the header row. Format the Amount column as currency and add dropdowns to the Category column using Data → Data validation. Then create a Summary tab with SUMIFS formulas for monthly totals and a pie chart by category.
Is there a free Google Sheets expense tracker template?: Yes. Google Sheets ships with a "Monthly budget" template and an "Annual budget" template under File → New → From template gallery. Both include monthly totals, category breakdowns, and a starting chart. You can also rebuild the layout described on this page in about 10 minutes.
Google Sheets vs. an expense tracking app — which is better?: Google Sheets is free and flexible, but every transaction requires manual entry and every report requires a formula. An AI-powered app like Smart Expense captures receipts from email, scans paper receipts, and generates reports automatically. Use Google Sheets if you want full formula control. Use Smart Expense if you want the tracking to happen on its own.
Can I import my Google Sheets expense tracker into Smart Expense?: Yes. Export your Google Sheets tracker as CSV and forward it to Smart Expense — we preserve the date, merchant, category, amount, and notes fields. New expenses then flow in automatically from email or receipts, so you never have to paste rows again.
What formulas should I use in a Google Sheets expense tracker?: SUMIFS handles monthly totals across date ranges, SUMIF sums a specific category, and COUNTIF with INDEX/MATCH finds your most frequent merchant. Combine these on a Summary tab with a pie chart of category totals for a one-glance monthly view.
Does Google Sheets sync receipts from Gmail?: Not natively. You would need a third-party Apps Script, an extension, or a paid Zapier / Make flow. Smart Expense is built for this — it connects to Gmail or Outlook via secure OAuth and pulls expenses automatically with no scripts to maintain.
Is Google Sheets good for tracking business expenses?: For very small workloads, yes. It becomes painful once you have dozens of transactions a week, multiple categories, or tax reporting requirements. An automated app saves hours every month and produces cleaner records at tax time.
Can I track expenses in Google Sheets on my phone?: Yes — install the Google Sheets mobile app and pin your tracker to the home screen. Entry on a phone keyboard is slow, which is why most people eventually move to a dedicated tracker like Smart Expense that accepts chat-style input.

Keep exploring

Ready to stop typing receipts into Google Sheets?

Let Smart Expense handle the data entry so your numbers stay current without the busywork.

Get Smart Expense free Have a question? Contact us →