Google Sheets Expense Tracking — Every Template and Guide in One Place
Google Sheets is the most practical free tool for tracking your money. No subscription, no app to install, works on every device, and the formulas do the maths automatically. The question is usually which spreadsheet to use — because "expense tracking" covers a lot of ground depending on what you're actually trying to do.
This page organises every Google Sheets money template and guide on this site into one place, so you can go straight to the right one for your situation.
Day-to-day expense tracking
If you want to know where your money goes each month, start here. These templates are for logging transactions as they happen — or in a weekly catch-up session — and seeing your spending totalled by category automatically.
Most popular
Google Sheets Expense Tracker
The complete setup guide: transactions tab, category dropdowns, SUMIF totals, and a monthly summary dashboard. Build it from scratch in 20 minutes or download the pre-built template.
Log as you go
Daily Expense Tracker
Designed for same-day logging — record each purchase as it happens from your phone. Running daily total updates automatically so you always know where you stand.
Single person
Personal Expense Tracker
A tracker built for one person's spending — more specific categories, a personal income row, and no shared household noise. Best if you manage your own finances separately.
Monthly budgeting
Expense tracking records what happened. Budgeting plans what's going to happen. These templates are for setting monthly spending targets, tracking income, and seeing whether you're on track before the month ends.
Monthly Budget Template
One tab, every dollar accounted for. Income, fixed bills, variable spending, and savings — all auto-calculating. The clearest overview of a single month's finances.
Family Budget Template
Built for shared household finances — joint income, shared bills, and combined variable spending across one or two earners. No spreadsheet skills needed.
Household Budget Planner
A simple monthly system tracking income, fixed bills, variable spending, and savings goals together. Good starting point if you've never budgeted before.
Free Budget Planner
A one-page budget that plans every dollar before the month starts — income, fixed bills, savings, and variable spending all visible at a glance.
Get the free Google Sheets Expense Tracker.
Pre-built with category dropdowns, automatic SUMIF totals, a monthly summary dashboard, and running balance. Open it and start logging today — no formula work required.
Debt payoff tracking
If you're carrying debt across multiple accounts, a dedicated payoff tracker is more useful than a general expense tracker. These help you list every balance, choose a payoff strategy, and see your debt-free date.
Debt Payoff Tracker
Log every debt, track balances, calculate your payoff order using Snowball or Avalanche, and see exactly when each debt disappears. Free step-by-step guide.
Bill Tracker
A simple spreadsheet for every payment due date, amount, and status. Catches automatic payments you've forgotten about and stops late fees before they happen.
Savings tracking
Tracking savings separately from expenses keeps your goals visible and makes it clear whether you're actually saving what you planned — or just hoping it happens.
Savings Tracker
Track multiple savings goals at once — emergency fund, holiday, house deposit — with automatic progress bars, monthly contribution logs, and projected finish dates.
Business and freelance finance tracking
For freelancers and small business owners who need to track invoices, receivables, and business expenses separately from personal spending.
Accounts Receivable Tracker
Know exactly who owes you money, how much, and how overdue they are — with automatic ageing buckets and a follow-up log. No accounting software needed.
Track Business Expenses as a Freelancer
A practical system for logging every deductible cost throughout the year — so tax time is a 30-minute review rather than a panicked trawl through 12 months of bank statements.
Freelance Invoice Template
A professional, auto-calculating Google Sheets invoice with a payment tracker register. Send invoices and track who's paid without switching between multiple files.
Google Sheets Time Tracker
Log hours by client, project, and task — with automatic hour and billable amount calculations. Includes a weekly timesheet tab and a summary pivot that breaks down time per client per month.
Google Sheets Budget Template
Every free Google Sheets budget template in one place — monthly budget, family budget, zero-based, and simple one-tab. Comparison table helps you pick the right format for your situation.
Ready-made templates (download and use today)
If you'd rather download a finished template than build from scratch, these are the Google Sheets templates available on this site — pre-built with all formulas and categories already in place.
Family Budget Template
Auto-calculating family budget with income tracking, fixed and variable expense sections, variance analysis, and a savings goal tracker. Free to copy.
Accounts Receivable Tracker
Free Google Sheets AR tracker with automatic ageing, overdue alerts, follow-up log, and running totals. Built for service businesses.
Freelance Invoice Template
Professional Google Sheets invoice with auto-calculating totals, payment tracker register, client address book, and year-to-date income summary.
Which Google Sheets tracker do you need?
If you're not sure where to start, use this as a guide:
| Your situation | Start with |
|---|---|
| I want to see where my money goes each month | Expense Tracker |
| I want to log spending throughout the day on my phone | Daily Expense Tracker |
| I track my own finances separately from my household | Personal Expense Tracker |
| I want to set spending targets before the month starts | Monthly Budget Template |
| I share finances with a partner or family | Family Budget Template |
| I'm paying off credit cards or loans | Debt Payoff Tracker |
| I want to track savings goals alongside spending | Savings Tracker |
| I'm a freelancer tracking invoices and business costs | Accounts Receivable Tracker |
Frequently asked questions
What is the best free expense tracker for Google Sheets?
The best free Google Sheets expense tracker is one with a transactions log, automatic category totals via SUMIF formulas, and a monthly summary dashboard — all pre-built so you can start logging on the same day. The complete expense tracker guide on this site covers how to build one from scratch in 20 minutes, or you can get the pre-built template by entering your email above.
How do I track all my expenses in Google Sheets?
Set up three tabs: a Setup tab with your spending categories, a Transactions tab with columns for Date, Description, Category, Amount, and Payment Method, and a Summary tab where SUMIF formulas total each category automatically. Log transactions once a week in a 10-minute review session. After one month you'll have a complete picture of where your money goes. See the step-by-step expense tracker guide for the full build.
Can Google Sheets replace a budgeting app?
For most people, yes. Google Sheets has no subscription cost, no advertising, and no data sharing with third parties. The formulas that budgeting apps use — category totals, monthly summaries, remaining amounts — are all straightforward SUMIF and SUM formulas you can set up once and reuse indefinitely. The main thing a dedicated app does better is automatic transaction import from your bank. If you're willing to log manually (which takes 10 minutes a week), Google Sheets is a better tool than most paid apps.
Is it better to track expenses daily or weekly in Google Sheets?
Weekly is the practical sweet spot for most people. Daily logging is more accurate but has enough friction that most people stop within a few weeks. A weekly catch-up — open your bank statement, log the week's transactions, check your summary tab — takes eight to twelve minutes and is sustainable long-term. If you specifically want to build the daily logging habit, the daily expense tracker guide covers a setup built for on-the-go logging from your phone.
Do I need a separate budget template and expense tracker?
They serve different purposes and work best together. An expense tracker records what you actually spent. A budget template sets targets for what you plan to spend. The ideal sequence: track for two to three months first to establish your real baseline, then use that data to build a budget. A budget built on three months of actual tracked spending will be far more accurate — and more likely to stick — than one built on estimates.
What Google Sheets template should I use to track income and expenses?
The monthly budget template is the best fit — it has a dedicated income section at the top and expense categories below, with a remaining amount that updates automatically. If you have variable freelance income alongside regular expenses, the income and expense tracking section of the expense tracker guide covers how to add a Type column to log both in the same transactions tab.
Skip the setup — get the free template.
The Google Sheets Expense Tracker is pre-built with a transactions log, category dropdowns, automatic SUMIF totals, running balance, and a monthly income vs spending overview. Enter your email and we'll send it straight to you.