Household Expense Tracker — Excel and Google Sheets Spending Tracker
A household expense tracker logs daily spending by category with automated totals, monthly summaries, and visual charts. Track groceries, utilities, healthcare, and more in Excel or Google Sheets with formulas that don't break.
Free expense trackers are just blank spreadsheets with headers. Budgeting apps charge monthly for features you don't need. This household expense tracker gives you automated category totals, a visual dashboard, and monthly summaries — all for a one-time purchase.
Log transactions, see where your money goes, and spot spending trends — without a subscription.
Household Expense Tracker is a purpose-built Google Sheets and Excel spreadsheet with a dashboard, transaction log, monthly summary, and category setup. You enter transactions; the spreadsheet does the math. No subscription, no recurring fees, no cloud dependency.
Key Features
- Dashboard with pie chart of expenses by category
- Transaction log with category dropdown and income/expense tagging
- Monthly summary auto-populated from transactions via SUMIFS
- Customizable categories including a Misc catch-all
- Conditional formatting: color-coded categories and totals
- Full-column formula references that don't break when you add rows
Get Instant Access
Instant download. Secure payment. Fix-or-replace guarantee.
What's Inside
Five tabs that work together: a dashboard, a transaction log, a monthly summary, a category setup, and instructions. All formulas use full-column references so they don't break when you add rows. No macros — works in Excel, Google Sheets, and LibreOffice.
- Dashboard — current month summary: income, expenses, net, pie chart of expenses by category
- Transactions — log every transaction with date, description, category dropdown, payment method, amount, and income/expense type
- Monthly Summary — month-by-month totals auto-populated from Transactions via SUMIFS
- Category Setup — master category list with budget amounts, including a Misc category for catch-all spending
- Instructions — step-by-step guide for beginners
What This Tool Does NOT Do
- No bank syncing — you enter transactions manually for full control and privacy.
- No investment tracking — this is for daily spending, not portfolio management.
- No bill due-date tracking — use the Bill Tracker for that.
- No macros — works in Excel, Google Sheets, and LibreOffice Calc with no add-ons.
✓ All formulas unlocked and visible. Zero macros. Compatible with Excel 2016+, Google Sheets, and LibreOffice Calc.
If your tool doesn't work as described, we'll fix it or replace it free.
Frequently Asked Questions
How do I track household expenses in Excel?
Open the template, go to the Transactions tab, and enter each purchase with date, description, category, and amount. The Dashboard and Monthly Summary tabs update automatically using SUMIFS formulas with full-column references.
Is there an expense tracker template for Google Sheets?
Yes. Upload the .xlsx file to Google Drive, right-click and open with Google Sheets. All formulas, dropdowns, and conditional formatting work natively in Google Sheets.
What categories should I track for household expenses?
Common categories include housing, groceries, utilities, transportation, healthcare, entertainment, dining out, personal care, education, savings, and misc. This template includes all of these pre-loaded and customizable.
Can I track multiple income sources in a spreadsheet?
Yes. The Transactions tab has an Income/Expense dropdown. Enter each income source as a separate transaction with its own description. The Dashboard sums all income automatically.
How do I see spending trends by category?
The Dashboard tab includes a pie chart of expenses by category. The Monthly Summary tab shows month-over-month totals so you can spot trends across the year.
Does this expense tracker work on mobile?
Does this work on Mac?
Yes! All our tools are .xlsx files that open in Excel for Mac, Google Sheets, LibreOffice, and Numbers. No Windows-only features or macros are used.
Is this a one-time purchase?
Yes! Pay once, download immediately, and it's yours forever. No subscriptions, no recurring charges, no hidden fees.
Can I customize the tools?
Yes! All cells are unlocked and editable. Add your own categories, change formulas, rename tabs — make it yours. (Just don't resell or redistribute.)
What's your refund policy?
Fix-or-replace guarantee. If the tool doesn't work as described or the file is corrupted, email adelerocks80@gmail.com for a replacement or fix — we'll make it right.
Last updated: October 2, 2026