← All Money Detective articles Budgeting & saving

Expense Tracker Spreadsheet: How to Track Spending

An expense tracker is a list of what you spend, sorted into categories and totalled. Here is how to set one up in Excel, keep it going without typing everything, and know what to do with the results.

Written by Alex BPublished 13 November 2026
Money Detective is built around practical household money tools for Australians.

To track your expenses in Excel, set up four columns (date, description, category and amount), give the category column a dropdown, and use one SUMIFS formula per category to add them up each pay. That shows you where your money actually went, which you can then compare with your plan. This guide covers the setup, and how to keep it going when you do not have the patience to type in every coffee.

What an expense tracker needs

Four columns do almost all the work:

Date	Description	Category	Amount
2 Nov	Woolworths	Groceries	$142.60
3 Nov	Servo	Fuel	$78.00
4 Nov	Coffee	Eating out	$5.50

Invented examples.

Make the Category column a dropdown (Data, then Data Validation, then List) with a short list of names. A dropdown stops "Groceries" and "Grocery" being counted as two different things.

Choose your categories first

Keep the list short. Ten to twenty categories is plenty for most households, such as groceries, eating out, fuel, transport, kids, health, subscriptions, shopping, gifts and everything else. Too many categories makes it hard to choose one, and you will stop. You can always split a category later if one grows too big.

Three ways to get spending into the sheet

Type it as you go. Best for cash and for people who like to see every purchase. It takes a moment each time.
Copy rows from your online banking. Download or copy the transaction list once a week or each pay, paste it under your headings, and add the category to each row.
Convert a PDF statement. The free Bank Statement Converter turns statement PDFs into clean rows with date, description, account and amount, ready to paste into Excel. The statement is read in your browser. Check the rows against your statement, because automatic reading can misread a date or an amount.

None of these connects to your bank. You are working from your own records.

Add up each category

Once your transactions are in, list your categories on a separate Summary tab, and use SUMIFS to total each one. If the categories are in column C of the Transactions tab and the amounts in column D, the formula for the category named in A2 is:

=SUMIFS(Transactions!D:D,Transactions!C:C,A2)

SUMIFS adds the amounts that match a condition. Microsoft's help page on the SUMIFS function has more examples. Add a date condition to total just one pay or one month.

A worked example: one fortnight of spending (invented figures)

Category	Transactions	Total
Groceries	4	$412.35
Fuel	2	$150.00
Eating out	9	$74.50
Subscriptions	3	$38.97
Total tracked	18	$675.82

If your plan for groceries was $380, the tracker shows you are $32.35 over, and you can decide whether to move money from another category or adjust the plan.

Things that spoil a tracker

Counting transfers as spending. Moving money between your own accounts is not an expense.
Counting credit card repayments and card purchases. If you count both, the same money appears twice. Track the purchases, and treat the repayment as paying off a balance.
Refunds. Enter them as negative amounts in the right category so the total is true.
Cash that never gets recorded. Even a rough note keeps the total honest.
Waiting too long. A week of transactions is easy to catch up. Three months is a chore.

What to do with the results

A tracker on its own tells you what happened. The useful part is what you do next:

Find the two or three biggest categories. They matter more than the small ones.
Compare each against a plan. This is budget vs actual.
Look for costs that repeat, such as subscriptions. The subscription audit helps you add them up.
Set the plan for the next pay using what you learned.

When a tracker isn't enough

If all you need is to see where the money went, a tracker is perfect. If you also want a plan, savings goals and a comparison, it helps to have it all in one workbook so the totals feed straight into your budget.

Want it sorted for you? Fortnightly Budget Plus has an optional import tab where you paste rows from your bank statement, and each transaction is sorted into your budget categories. If you correct a category once, a rule remembers it for next time. The results feed a budget vs actual tab and a dashboard. It is an Excel workbook and nothing connects to your bank.

Just want a snapshot of a statement? The 3-Minute Budget is an Excel spreadsheet where you paste your bank statement and see what went to rent or mortgage, bills, debt, spending and savings.

If you would like to start free, the Free Fortnightly Budget has 23 categories and shows planned vs actual for each one. You type your own amounts.

Questions about expense trackers

What is the difference between an expense tracker and a budget?

A budget is a plan for what you intend to spend. A tracker records what you did spend. Using both lets you compare them.

How often should I update it?

Weekly or once each pay works for most people. The shorter the gap, the easier it is.

Is it better to track by hand or from my statement?

By hand shows you every purchase as it happens. Statement rows save time and catch things you forgot. Many people combine the two.

Official sources and further reading

This article provides general information only. It does not take into account your personal objectives, financial situation or needs, and it is not financial advice. Examples use invented figures. Money Detective's tools provide estimates and planning information. Consider your own circumstances, and seek independent advice if you need it, before making financial decisions.