Tracking household expenses as a family requires a different template than a personal budget. You need shared categories that cover the full range of family spending — groceries, childcare, medical, home maintenance, utilities, and family activities — plus a way for both partners to see the same data and contribute to tracking.
This free Google Sheets template is built specifically for families. Copy it to your Google Drive, share it with your partner, and you'll have a complete household expense tracking system in under 15 minutes.
What's in the Template
Tab 1 — Family Budget Dashboard. The dashboard shows your monthly income, total budgeted expenses, total actual expenses, and the difference for each category. A color-coded status column shows green (on track), yellow (within 10% of budget), or red (over budget) for each category at a glance.
Tab 2 — Shared Expense Log. Every shared household transaction goes here: date, who paid (Partner A or Partner B), merchant, category, amount, and a notes field. Both partners have edit access and can add transactions throughout the month. At the end of each week, export your ReceiptSync data and paste it here — no manual entry required.
Tab 3 — Tax-Relevant Expenses. A dedicated tab for expenses that may have tax implications: childcare (Form 2441), medical and pharmacy (FSA/HSA reimbursement), home improvements (cost basis), and home office expenses (if one partner is self-employed). This tab makes tax season significantly easier — all your documentation is in one place.
Tab 4 — Monthly Summary. Budgeted vs. actual for each category, shown as a bar chart. Updated automatically from the Expense Log. Useful for the weekly review — both partners can see at a glance where the month stands.
Tab 5 — Annual Overview. Month-by-month totals for each category across the full year. Useful for spotting seasonal patterns (holiday spending, summer activities, back-to-school) and planning next year's budget.
→ Download the free expense tracker template — open it in Google Sheets via File → Import.
Pre-Filled Family Expense Categories
The template comes pre-filled with the most common family expense categories:
Housing & Utilities: rent or mortgage, electricity, gas, water, internet and phone, home maintenance and repairs.
Food: groceries, dining out (family), coffee and snacks.
Family & Children: childcare / daycare, school supplies and fees, children's activities (sports, music, etc.), clothing (children).
Health: health insurance premiums, doctor and specialist visits, prescriptions and pharmacy, dental and vision, mental health.
Transportation: car payment(s), gas, car insurance, car maintenance, public transit.
Personal: clothing (adults), personal care, gym and fitness, individual entertainment.
Savings & Debt: emergency fund, retirement contributions, debt payments (above minimums), vacation fund, home improvement fund.
Add or remove categories as needed — the template is fully editable.
How to Set Up the Template in 15 Minutes
Step 1 (3 minutes): Make a copy of the template to your Google Drive. Rename it "Family Budget — [Month] [Year]."
Step 2 (2 minutes): Share the spreadsheet with your partner. In Google Sheets, click Share → enter your partner's email → set to "Editor." Both partners now have full access.
Step 3 (5 minutes): In the Family Budget Dashboard tab, enter your combined monthly income and your budgeted amount for each category. Start with your fixed expenses (rent, car payments, insurance) and then estimate your variable expenses based on last month's spending.
Step 4 (5 minutes): Set up ReceiptSync on both phones. Create a shared ReceiptSync account and log in on both devices. Both partners can now scan receipts to the same archive.
Ongoing (10 minutes/week): Each Sunday, export your ReceiptSync data for the week and paste it into the Shared Expense Log. Check the Monthly Summary tab together. Adjust next week's spending based on what you see.
Connecting ReceiptSync to the Template
The template is designed to work with ReceiptSync's Google Sheets export. When you export your receipt data from ReceiptSync, the columns match the Shared Expense Log tab exactly: date, merchant, category, amount. Paste the export data directly — no reformatting required.
This eliminates the manual entry that makes most budget templates fail. Instead of typing in every transaction, you scan receipts throughout the week and paste the data once on Sunday. The whole weekly update takes under 5 minutes. ReceiptSync is free to try — the free plan includes 10 scans per month.
The Tax-Relevant Expenses Tab: Why It Matters
Most family budget templates don't have a dedicated tax documentation tab. This one does — because families have more tax-relevant expenses than most people realize.
Childcare: The Child and Dependent Care Tax Credit (Form 2441) allows you to claim up to $3,000 for one child or $6,000 for two or more children in childcare expenses. You need the provider's name, address, and tax ID number, plus documentation of what you paid. The Tax-Relevant Expenses tab tracks all of this.
Medical and pharmacy: If your medical expenses exceed 7.5% of your adjusted gross income, the excess is deductible on Schedule A. More commonly, medical receipts are needed for FSA/HSA reimbursement. The template tracks both.
Home improvements: Capital improvements increase your home's cost basis and reduce capital gains tax when you sell. The template has a dedicated row for home improvement receipts with a "permanent" retention flag.
Home office: If one partner is self-employed with a dedicated home office, a portion of housing costs (rent, utilities, home improvements) is deductible. The template flags these expenses for potential home office deduction.
Related guides: Best Expense Tracker for Families, How to Track Shared Expenses as a Couple, How to Organize Medical Receipts for HSA Reimbursement, and Free Monthly Budget Template for Google Sheets (Self-Employed).