Expense Tracker Spreadsheet For Personal Finance

The Expense Tracker is Avery's clean, do-it-yourself spending log for Google Sheets. It sits between a blank spreadsheet (too much work) and a locked-down app (too little control): the categories, filters, and summaries are already built, but every cell is yours to change.

Who it's for

• People who want awareness, not a full budget — a simple log that answers "where is my money going?"
• Spreadsheet-first trackers who want control over categories instead of an app's fixed structure.
• People leaving a budgeting app who want to own their transaction data in a sheet they control.
• Couples who want one shared spending log both partners can edit in real time.

What's inside

A pre-built Google Sheet with everything wired up:

• Transaction log — date, amount, category, account, and merchant for every expense.
• Categories — a starter set you can rename, add to, or trim.
• Summaries — monthly and category totals that calculate themselves.
• Filters — slice the log by account, category, or merchant in a click.

The honest part

An expense tracker only works if the transactions are actually in it. Most trackers go stale because nobody wants to type in spending every week. This template assumes Avery handles that part — syncing and categorizing your bank transactions automatically — so the log stays current and your spending picture is never guesswork.

Want the full walkthrough with examples? Read the complete expense tracker guide, or jump to the most-asked expense tracker questions. Self-employed? Try the Freelancer Expense Tracker built around Schedule C deductions.