A note before you read: This article is general financial education only. It teaches you how to build a spreadsheet for tracking your own spending; it is not financial advice, and it does not tell you how much you should spend, save, or allocate to any category. Your budget is your own — if you need advice about your money, talk to a qualified financial professional.
Introduction
Most people do not overspend because they are careless. They overspend because they never see the total. A coffee here, a subscription there, a takeaway on a tired evening — each one is small, and the month ends with a number nobody expected. A spreadsheet fixes that by making the total visible while there is still time to act.
Google Sheets is a good tool for the job: it is free, it lives in your Google Drive, it syncs to your phone, and it does the arithmetic for you. This guide builds a tracker from scratch in about 20 minutes — a transaction log, a category summary with automatic totals, and a monthly overview — and then shows the weekly routine that keeps it accurate. You will not need to download any file: everything here is a layout and a set of formulas you can recreate yourself.
What your tracker needs
A working expense tracker has three layers:
- Transaction log — the raw data; one row per expense.
- Category summary — automatic totals by spending category for the month.
- Monthly overview — income versus expenses versus net savings at a glance.
You will build these as three tabs in one spreadsheet: Transactions, Summary, and Settings. The Settings tab holds your category list, so every dropdown in the log draws from the same list and your totals always match.
Step 1: Build the transaction log
Create a new spreadsheet and name the first tab Transactions. Set up five columns:
| Column | Header | What goes here |
|---|---|---|
| A | Date | The date you spent the money |
| B | Description | What you bought, in a few words |
| C | Amount | Numbers only — no currency symbols |
| D | Category | Pick from your category list |
| E | Notes | Optional — receipt, who it was for, anything useful |
Enter amounts as plain numbers. Currency symbols and commas inside the amount column break the formulas, so keep the numbers clean and format the column as currency instead — select the column, then Format > Number > Currency.
Add a month helper column if you want monthly summaries later: in column F, use =TEXT(A2,”mmm yyyy”) and copy it down. It turns each date into a label like “Nov 2026” that the summary formulas can filter on.
Step 2: Define your categories
Create a second tab called Settings. In column A, list your spending categories. Start with a short list and add more only when a category keeps surprising you — most trackers die from too many categories, not too few. Eight to twelve is a workable range for most people:
Housing / Rent, Groceries, Dining & Takeout, Transport, Utilities, Health & Medical, Personal Care, Entertainment, Subscriptions, Shopping, Travel, Savings, Other.
Split fixed and variable costs in your head, even if they share one list: fixed costs (rent, insurance, subscriptions, phone bill) do not change month to month, while variable costs (groceries, dining, transport, shopping, entertainment) fluctuate — and the variable ones are where the surprises live.
Now turn the Category column in Transactions into a dropdown. Select the Category column, then Data > Data validation, choose Dropdown (from a range), and point it at your Settings list. This matters more than it looks: your SUMIF formulas require exact text matches, and a dropdown stops “Groceries” and “grocery” from becoming two different categories.
Step 3: Build the category summary
Create a third tab called Summary. Set up five columns:
| Column | Header | Formula or value |
|---|---|---|
| A | Category | Copy your category list from Settings |
| B | Budget | Type your planned amount for each category |
| C | Actual | =SUMIF(Transactions!D:D, A2, Transactions!C:C) |
| D | Remaining | =B2-C2 |
| E | % Used | =IFERROR(C2/B2, 0) formatted as a percentage |
The SUMIF formula is the heart of the tracker. It adds up every amount in the Transactions sheet where the Category column matches the label in A2. Copy it down for each category, then add a grand total with =SUM(C2:C15) for actual spending and =SUM(B2:B15) for the total budget.
To filter by month, use SUMIFS instead — the same idea, with an extra condition:
=SUMIFS(Transactions!C:C, Transactions!D:D, A2, Transactions!F:F, “Nov 2026”)
That totals category A2 only for transactions whose month helper column says “Nov 2026”. Point the month at a cell instead of typing it into the formula, and you never have to edit the formulas when the month changes.
Step 4: Add a monthly overview
At the top of the Summary tab, or on a small fourth tab, add three lines:
- Total income: type your monthly income, or pull it from an income section in the Transactions tab.
- Total expenses: =SUM(C2:C15) — the grand total from your category summary.
- Net savings: income minus expenses.
- Savings rate: net savings divided by income, formatted as a percentage.
This is the number the tracker exists for. A category can be over budget and the month can still be fine; a category can be under budget and the month can still be a problem. The overview tells you which is true.
Step 5: Add the extras that make it stick
Conditional formatting for over-budget flags. Select the Actual column, then Format > Conditional formatting > Custom formula and use =C2>B2 with a red fill. A category that turns red the moment it passes its budget is harder to ignore than a number in a column.
Average daily spending. =SUM(Transactions!C:C) / MAX(1, TODAY() – DATE(2026,11,1) + 1) gives your average daily spend so far this month. Change the date to the first of the current month when the month changes.
A chart. Select the category summary and insert a pie chart (Insert > Chart). A visual share of spending lands differently from a table — most people are surprised by how large Dining & Takeout or Subscriptions looks as a slice. Speaking of subscriptions, if the tracker shows charges you do not recognise, our forgotten subscriptions guide shows how to audit them across cards, app stores, and PayPal.
Count transactions in a category. =COUNTIFS(Transactions!D:D, “Groceries”) tells you how many times you shopped, not just how much you spent — useful when the problem is frequency, not size.
The weekly routine
A tracker only works if it is current. The routine that keeps it alive takes about ten minutes a week:
- Log as you go, or batch it twice a week. Enter receipts the same day when you can; if not, set two fixed times a week to catch up. A backlog of three weeks is where trackers die.
- Check the bank statement. Once a week, compare the tracker against your bank or card statement. Anything in the statement that is not in the tracker is a missing entry; anything in the tracker that is not in the statement is a duplicate or a cash expense you already recorded.
- Look at the red cells. Open the Summary tab and look at the categories that are over budget or close to it. One over-budget category is information; three is a pattern.
- Adjust next month, not this one. If groceries ran over, do not rewrite the budget mid-month to make the red go away. Note it, and set next month’s budget from what you actually spent, not from what you wished you spent. A budget built from real numbers is useful; a budget built from wishes is a decoration.
A worked example
To see the whole thing working, imagine a hypothetical household — not a real person’s finances, and not a recommendation. Maya earns $3,200 a month after tax. Her tracker for November shows: Housing $1,200, Groceries $380, Dining & Takeout $160, Transport $140, Utilities $180, Subscriptions $65, Shopping $120, Entertainment $90, Personal Care $60, Other $75. Total expenses: $2,470. Net savings: $730, a savings rate of about 23%.
The summary also shows that Dining & Takeout is at 107% of its $150 budget with a week left in the month — the one red cell. She does not need a new budget; she needs to know that one number, and to decide whether to cook more this week or accept the overspend. That is the whole job of the tracker: one visible number, in time to act on it. If you want a framework for dividing that income before you track it, the 50/30/20 rule explains one starting point, and our beginner budget guide walks through building the first-month budget the tracker will measure against.
Common mistakes
- Too many categories. If you have 30 categories, logging becomes a chore and you will stop. Start with 8–12 and split a category only when it keeps hiding surprises.
- Logging only the big expenses. The tracker is for the small ones — they are the ones you forget, and they add up.
- Typing amounts with currency symbols. Numbers only in the Amount column, or the formulas silently ignore the row.
- Forgetting cash. If you pay cash, log it the same day. Cash is invisible to the bank statement, so the weekly check cannot catch it.
- Treating the budget as a verdict. An over-budget month is data, not failure. The tracker exists to show you what happened; what you do about it is a separate decision, and it is yours.
The bottom line
Build three tabs — Transactions, Summary, Settings — with a dropdown for categories and a SUMIF formula for each category’s total. Add a monthly overview, a conditional-format flag for over-budget categories, and a ten-minute weekly routine to log, check against the statement, and look at the red cells. The spreadsheet does not change your spending. Seeing the total, while there is still time in the month, does.
