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.

Part of the Google Sheets expense tracking guide — all templates and guides in one place.

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.

Personal expense tracker in Google Sheets

A personal expense tracker covers one person's spending only — your individual income, your subscriptions, and the purchases you make from your own accounts. It's different from a household tracker, which covers shared expenses like rent, joint grocery runs, and bills that both partners contribute to.

If you live alone, the setup in this guide is your personal tracker. If you share finances with a partner or housemate, the cleanest approach is to keep two trackers: a shared one for joint household expenses and a personal expense tracker for each individual. That way you can see your own discretionary spending clearly without it being buried under shared bills.

The personal version also lets you be more granular in your categories. Where a household tracker might lump all clothing into one row, a personal tracker can split "work clothing" from "personal clothing" or "gym" from "general health" — because you're only accounting for your own transactions.

Daily expense tracker in Google Sheets

A daily expense tracker uses the same structure as a standard tracker but is designed for same-day logging rather than weekly catch-up sessions. Instead of opening your bank statement once a week and logging everything in a batch, you record each purchase as it happens — or at the end of each day.

The advantage: better accuracy on cash purchases and a clearer picture of daily spending habits. The disadvantage: it requires more discipline. Most people find the habit drops off within a few weeks unless logging is genuinely frictionless — which means opening Google Sheets on your phone immediately after each transaction.

If daily logging appeals to you, the transactions tab structure stays the same. The difference is how you interact with it — short sessions throughout the day rather than one longer weekly session. See the dedicated daily expense tracker Google Sheets guide for a setup optimised for on-the-go logging, including how to add a quick-entry shortcut on your phone's home screen.

Monthly expense tracker: seeing the full picture

A monthly expense tracker aggregates your transactions into a single monthly view so you can compare spending across months and spot trends over time. The transactions tab stays the same — the difference is in how the summary tab is built.

Instead of one summary column for "this month", build a summary with thirteen columns: one for each month of the year and one for the full-year total. In your transactions tab, extract the month from the date with =TEXT(A2,"MMMM") into a helper column. Then your summary formula becomes SUMIFS instead of SUMIF, adding a second condition for the month:

=SUMIFS(Transactions!D:D,Transactions!C:C,A2,Transactions!E:E,"January")

Copy that formula across twelve columns with the month name changing in each, and you have a complete monthly expense tracker for the year in one view. You can see at a glance whether October's food spending was higher than August's, or whether your entertainment budget crept up in Q4. That's the data that makes patterns visible and spending decisions easier to defend.

Google Sheets as a spending tracker and money tracker

"Expense tracker", "spending tracker", and "money tracker" are different names for the same tool. Google Sheets works for all three. The distinction is mostly about framing: an expense tracker tends to focus on categories and totals, a spending tracker emphasises daily habits and control, and a money tracker often includes both income and outgoings in one view.

If you want a money tracker that shows the full picture — what's coming in and what's going out — the setup is straightforward. Add a second section to your summary tab for income sources (salary, freelance, rental income, etc.) alongside the expense categories. A single "Net" row at the bottom subtracts total expenses from total income. That's your money tracker: one number that tells you whether the month added to your financial position or subtracted from it.

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.

Shared expense tracker in Google Sheets for couples and housemates

A shared expense tracker works the same as a personal one, with two additions: a "Paid By" column and a settlement calculation.

Paid By column. Add a column next to Amount that records who paid for each transaction — Person A or Person B. This lets you use SUMIF to total spending by payer at the end of the month.

Settlement formula. Calculate each person's share of total joint spending (usually 50/50, but some couples use income-proportional splits). Compare each person's total paid to their share. The difference is the settlement amount — who owes whom, and how much.

For housemates tracking shared costs like rent, utilities, groceries, and cleaning, the same structure works with three or four payers instead of two. A shared Google Sheets budget is free, accessible to everyone on their own device, and avoids the subscription cost of dedicated apps like Splitwise (for anything beyond basic use).

For shared budgeting across a household, combine the expense tracker with a family budget template — the tracker captures actuals, the budget template sets targets and shows how the household is tracking against them.

Adding charts to your Google Sheets expense tracker

A chart turns your expense data from rows of numbers into a picture that answers questions instantly. Two charts cover most of what you need:

Spending by category (pie or bar chart). Select your category and total columns from the summary tab. Insert a pie chart to see what percentage of spending goes to each category. Select bar chart if you have more than eight categories — pie charts get unreadable at that number.

Monthly spending trend (line chart). If your tracker spans multiple months, create a summary row for each month's total. Select those monthly totals and insert a line chart. A rising line means spending is increasing. A flat line means you are consistent. This view makes seasonal patterns visible — most households spend significantly more in November and December, and that spike should appear in the plan rather than as a surprise.

To add a chart in Google Sheets: select the data range, go to Insert → Chart, and choose the chart type. Customize the title and axis labels so the chart is readable without context. Charts update automatically as you add new transactions — build them once and they stay current forever.