Google Sheets Expense Tracker — Know Exactly Where Your Money Goes Each Month

Budgeting and expense tracking are not the same thing. A budget is a plan — you decide in advance how much you'll spend in each category. Expense tracking is a record — you write down what you actually spent. Most personal finance advice conflates the two, which is why people set up elaborate budgets and then abandon them within a week.

Expense tracking is the easier starting point. You don't need targets or projections. You just need to log what happened. After a month of tracking, you have real data about where your money actually goes — and that data makes budgeting far more effective, because your numbers are grounded in reality rather than optimism.

A Google Sheets expense tracker is the simplest version of this system. No app subscription, no syncing issues, no learning curve. A spreadsheet you open, log your spending, and close again in two minutes.

What an expense tracker needs

An effective expense tracker has a small, fixed set of columns. The more columns you add, the more friction there is to logging — and friction is what kills the habit. Here's what each column does.

That's six columns. You can build a complete, useful expense tracker with exactly these six. Resist the urge to add more until the habit is established.

Setting up the tracker in Google Sheets

You need three things: a categories list, a transactions tab, and a summary tab. Here's how to build each one.

Step 1 — Create a categories list

On a separate tab (call it "Setup" or "Lists"), write your spending categories in a single column. Keep it to seven to ten categories — broad enough that every transaction fits somewhere without you having to think too hard. You'll use this list to create a dropdown in the Category column of your transactions tab.

Step 2 — Build the transactions tab

Create a new tab called "Transactions". Add the six column headers from the table above. In the Category column, set up data validation: select the column, go to Data > Data Validation, and point it at your categories list. Now every row has a dropdown — no typos, consistent categories, and SUMIF formulas that actually work.

For the Running Total column, use a formula like =SUM($D$2:D2) in the first row and copy it down. This gives you a cumulative total that updates as you add rows.

Step 3 — Build the monthly summary tab

Create a tab called "Summary". List your categories down column A. In column B, use SUMIF to pull the total for each category from the transactions tab: =SUMIF(Transactions!C:C,A2,Transactions!D:D). Copy that formula down for each category. Add a grand total at the bottom with =SUM(B2:B10).

That's it. Every time you log a transaction, the summary updates automatically. No manual adding, no calculator, no guesswork.

Step 4 — Add a monthly income row

At the top of the summary tab, add a row for your total monthly income. Below your expense totals, add a "Remaining" row: income minus total expenses. This single number tells you whether you're on track or overspending — visible every time you open the file.

The best expense categories

The categories you use determine how useful the tracker is. Too granular and you'll spend more time categorising than the insight is worth. Too broad and the data tells you nothing.

Start with these seven:

Housing — rent or mortgage, council rates, home insurance, repairs and maintenance. Everything related to the place you live.

Food — groceries, takeout, coffee, dining out. Some people split this into Groceries and Eating Out once they have a few months of data, but keep it combined to start. Planning your meal plan in advance is the single most effective way to reduce this category.

Transport — fuel, public transit, parking, car insurance, registration, servicing. Everything that gets you somewhere.

Health — prescriptions, GP and specialist visits, gym membership, dental, optical. Keep all health-related spending together.

Entertainment — streaming subscriptions, cinema, concerts, hobbies, sport. The category that usually surprises people most when they first look at the total.

Personal — clothing, haircuts, toiletries, gifts. Everything that doesn't fit the other categories goes here initially.

Savings — treat savings as a spending category. Log your transfers to savings accounts here. When you include it in your expense tracker, you can see whether you're actually saving what you planned to save.

The weekly 10-minute review habit

The tracker only works if you use it. The biggest mistake is trying to log transactions daily — it's too much friction and most people stop within a two weeks. A weekly review works better.

Pick one day — Friday evening or Sunday morning both work well. Open your tracker. Open your bank app or internet banking alongside it. Work through the week's transactions in order and log each one. For most people this takes eight to twelve minutes, even for a busy week.

While you're there, glance at the Summary tab. Check the running total against where you expected to be at this point in the month. If you're on track, close it and move on. If a category is already over or running high, you know about it with time to adjust — not on the last day of the month when the damage is done.

After three months of weekly reviews you'll start to know your numbers without looking. That's when expense tracking becomes genuinely useful — when you have the baseline and can make informed decisions about where to cut or redirect spending.

Expense tracker vs budget template

An expense tracker is reactive. It records what happened. A budget template is proactive — it sets targets in advance and compares actuals to those targets at the end of the month.

They're complementary, not competing. The ideal flow is: track expenses for two to three months to establish your real baseline, then use that data to build a realistic budget. A family budget template built on three months of actual spending data will be far more accurate — and far more likely to stick — than one built on estimates and good intentions.

If you already have a budget, the expense tracker is how you verify whether the budget is working. The budget says you'll spend $600 on food this month. The tracker shows you spent $820. That gap is where the real conversation starts.

For households also tracking regular bill payments, a bill tracker in a separate tab handles the fixed outgoings — automatic payments, subscriptions, loan repayments — while the expense tracker handles discretionary day-to-day spending. The two systems work side by side without overlapping.

Common mistakes

Logging too infrequently. Waiting until the end of the month to log four weeks of transactions is miserable and error-prone. Weekly is the minimum. Set a recurring calendar reminder so it actually happens.

Too many categories. If you have fifteen categories, you'll spend more time deciding where a transaction goes than the insight is worth. Seven broad categories give you 95% of the useful data with a fraction of the cognitive load.

Giving up after a bad month. A month where you overspent in three categories is not a failure — it's useful data. The point of the tracker is to see what's actually happening, including the months that don't look good. The information only becomes actionable once you have it.

Not separating income and expenses clearly. Keep income as a single reference number at the top of your summary. Don't mix refunds, cashbacks, or transfers between accounts into your expense rows — they distort the totals. Refunds can be entered as negative amounts in the relevant category if you want them reflected accurately.

Treating the tracker as a judgement. The tracker is a tool, not a verdict on your financial discipline. Some months are expensive. A tracker shows you what's normal for your household, which lets you plan accurately — that's the only goal.