Free template · Excel & Google Sheets
Free family expense tracker template
A monthly household expense tracker for Excel and Google Sheets. Log each expense, set a budget per category, and see what is left and who has paid what.
Download free template (.xlsx) Fair-share calculator →
No sign-up, no email. Works in Excel, Google Sheets, Numbers and LibreOffice.
What’s inside
- Expenses sheet: One row per expense: date, description, category, who paid and the amount.
- Budget sheet: A monthly budget per category. Spent, Left and % used fill in by themselves.
- Who paid sheet: Each earner’s share of household costs, what they actually paid, and the balance between you.
Preview, with sample data
| Category | Monthly budget | Spent | Left | % used |
|---|---|---|---|---|
| Housing | 18,000 | 18,000 | 0 | 100% |
| Groceries | 9,000 | 7,600 | 1,400 | 84% |
| Utilities | 3,500 | 2,939 | 561 | 84% |
| Education | 6,500 | 6,500 | 0 | 100% |
| Total | 46,500 | 40,239 | 6,261 | 87% |
Where a spreadsheet falls short
- Only one person can comfortably edit it at a time, usually on a laptop.
- Nobody gets a warning when a category is about to run out.
- Recurring bills like rent and school fees have to be typed again every month.
In Traxpend, everyone adds expenses from their own phone, budgets warn you at 80%, recurring bills log themselves, and settle-up shows the fewest payments with a UPI QR or a PayPal or Venmo link. Free for up to five people. Traxpend for families.
Questions
Is this family budget template free?
Yes. Download it, change it and share it with your family. No sign-up and no email needed.
Does it work in Google Sheets?
Download the file, open Google Sheets, choose File → Import → Upload, pick the file and select “Create new spreadsheet”. The formulas carry over.
Which currency does it use?
Any. Type plain numbers in your own currency, whether rupees, dollars, euros or pounds. The template has no currency symbols.
Can I track several months?
Make a copy of the file each month, or add a Month column to the Expenses sheet and filter by it.