Before You Start
You need a free Google account and about 15 uninterrupted minutes. No formula knowledge required — every formula below is copy-paste. If you just want the template structure at a glance first, see our Google Sheets expense tracker template overview, then come back here for the detailed walkthrough.
The 7 Setup Steps
1Create the sheet and name it
Go to sheets.google.com → Blank spreadsheet. Click "Untitled spreadsheet" and name it Expense Tracker 2026. Rename "Sheet1" (bottom tab) to Log — you'll add a Dashboard tab later.
2Build the four columns
In row 1 of the Log tab, enter: A1: Date B1: Description C1: Category D1: Amount. Select row 1, make it bold, then View → Freeze → 1 row so headers stay visible while scrolling.
3Add a category dropdown (this is the key step)
Select column C, then Data → Data validation → Add rule → Dropdown. Enter your categories: Housing, Food, Transport, Subscriptions, Health, Everything Else. Now every entry gets a clean, consistent category — no typos breaking your totals later.
4Format the Amount column
Select column D → Format → Number → Currency. Select column A → Format → Number → Date. Enter numbers only in column D — no "$" signs typed by hand.
5Add the summary formulas
Leave a blank row after your entries, then list each category in column B and paste this in column C beside the first one:
=SUMIF($C$2:$C$200, B32, $D$2:$D$200)
(Adjust B32 to the cell holding your first category name.) Copy down for each category. Then the grand total:
=SUM(D2:D200)
Test it: add three fake expenses and watch the totals update.
6Build a 2-minute dashboard
Add a new tab called Dashboard. In A1 write "Total spent", in B1 enter =SUM(Log!D2:D200). In A3:A8 list your categories, in B3 enter =SUMIF(Log!$C$2:$C$200, A3, Log!$D$2:$D$200) and copy down. Select A3:B8 → Insert → Chart → Pie chart. You now have a visual spending breakdown.
7Make it a habit
Install the Google Sheets app on your phone and star this sheet. The rule: log within the hour, review every Sunday. A tracker you don't open is just a spreadsheet.
Common Setup Mistakes
| Mistake | Why it hurts | Fix |
|---|---|---|
| Typing categories by hand | "Food" vs "food" breaks SUMIF | Use the dropdown from Step 3 |
| Currency symbols in Amount | Turns numbers into text | Numbers only + currency formatting |
| 20+ categories on day one | Logging becomes a chore | Start with 6, split later |
| No frozen header row | Lost scrolling on mobile | View → Freeze → 1 row |
Troubleshooting: When Something Looks Wrong
Three symptoms cover 95% of expense tracker in Google Sheets problems:
Totals show 0 but entries exist
Your Amount column contains text, not numbers. Select column D, check the format is Number → Currency, and retype one value. Also check SUMIF ranges actually cover your rows ($D$2:$D$200 won't see row 205).
Categories don't match
"Food" vs "food " (trailing space) are different categories to SUMIF. This is why Step 3's dropdown matters — but if damage is done, use Data → Data cleanup → Remove duplicates thinking, or Find & Replace to unify spellings.
Chart shows nonsense
You selected the wrong range for the pie chart. Delete the chart, reselect only your category-total block (labels + numbers, no blanks), and re-insert. Blank cells become mystery slices.
When in doubt, the backup copy from the FAQ is your time machine — never troubleshoot on your only copy.
Monthly Maintenance (5 Minutes)
Your expense tracker in Google Sheets needs almost no upkeep, but this monthly pass keeps it accurate:
- Extend the ranges. If SUMIF covers rows 2–200 and you're at row 190, extend to 400 now — not when formulas silently stop counting.
- Archive old months. At quarter-end, duplicate the sheet tab, rename it "2026-Q3", and clear the Log for the new quarter. History preserved, sheet stays fast.
- Prune dead categories. A category with zero entries for 3 months gets merged into "Everything Else". Fewer choices = faster logging.
- Spot-check one week. Pick any 7 days, compare against your bank app. If they match, your system is trustworthy; if not, you found the leak in your process.
Key Takeaways
- Setting up an expense tracker in Google Sheets takes ~15 minutes: columns, dropdown, formats, formulas, dashboard, habit.
- The category dropdown (Step 3) is the single most important step — it protects every formula.
- Keep a blank backup copy before troubleshooting anything.
- Archive quarterly, prune dead categories monthly, extend formula ranges before they run out.
- If setup feels heavy, the free web app is the same system with zero formulas.
Frequently Asked Questions
How long does it take to set up?
About 15 minutes following this guide — most of that is the formulas section, which is copy-paste.
Do I need to know formulas already?
No. You only need SUM and SUMIF, and both are given to you verbatim above.
Can I share it with my partner?
Yes — share the sheet and you both log to the same tracker in real time. Use the comment feature to flag questionable entries instead of arguing.
What if I break a formula?
Keep a blank copy as backup (File → Make a copy). If something breaks, copy the formula back from the backup.
Built it? Or rather skip all this?
If 7 steps feels like 6 too many, our free budget tracker web app is the same idea with zero setup — open and log.