Template
Family Finance Dashboard
When two people run a household, money lives in many places — two salaries, joint and personal expenses, shared EMIs, separate SIPs. This dashboard pulls it all onto one sheet so a couple can see total household income, where it goes, how much is being saved, and progress on shared goals like a home down payment or a child’s education. It replaces "I thought you paid that" with a single monthly view both partners trust, making household money a shared, calm conversation instead of a guessing game.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The dashboard consolidates a household’s full financial picture into one place. It captures both partners’ take-home incomes, totals all household expenses (split into fixed, variable, and shared categories), tracks every EMI and its remaining tenure, and rolls up combined savings and investments across both partners’ SIPs, PPF, and EPF. It also tracks shared goals — a home down payment, a car, a child’s education fund — showing target, saved-so-far, and monthly contribution for each. The result is a single monthly snapshot of household net cash flow and savings rate, so both partners can make decisions from the same numbers.
Who it’s for
- Dual-income couples who currently track money in separate, disconnected places.
- Families saving toward big shared goals like a house, car, or child’s education.
- Single-earner households coordinating one income across many family expenses.
- Couples who want one monthly money review instead of scattered, stressful conversations.
Fields included
How to use it
- Enter both partners’ take-home incomes at the top to get total household income.
- List shared fixed expenses — rent or home EMI, utilities, school fees, insurance, domestic help.
- Add variable and personal expenses for each partner so nothing is invisible.
- Record every EMI with its monthly amount and remaining tenure in one block.
- Total combined savings and investments — both partners’ SIPs, PPF, EPF, and RDs.
- List shared goals with a target, amount saved, and monthly contribution for each.
- Review the household cash-flow and savings-rate summary together once a month and adjust.
Preview
| Line | Amount (₹) | Notes |
|---|---|---|
| Household income | 1,60,000 | Both take-home salaries |
| Total expenses | 1,05,000 | Fixed + variable + personal |
| Combined savings | 35,000 | SIPs + PPF |
| Net surplus | 20,000 | Savings rate ~22% |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Rohan and Anjali take home ₹90,000 and ₹70,000 — ₹1,60,000 a month combined. Shared fixed costs (home EMI ₹35,000, utilities and help ₹15,000, school fees ₹12,000, insurance ₹5,000) come to ₹67,000. Personal and variable spends add ₹38,000. Their combined SIPs and PPF are ₹35,000. The dashboard shows a net surplus of ₹20,000 and a household savings rate of about 22%. They are saving for a ₹15L home renovation, currently at ₹4L with ₹15,000 going in monthly. Seeing the surplus, they raise that goal contribution to ₹25,000 and agree to revisit at the next monthly review.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)