Personal finance template
Household Budget Template
Split shared costs fairly. Each person pays a share in proportion to their income.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Item | Amount |
| 2 | Income person 1 | 38,000 |
| 3 | Income person 2 | 30,000 |
| 4 | Rent | 14,000 |
| 5 | Food | 7,000 |
| 6 | Utilities | 2,500 |
| 7 | Shared costs | =SUM(B4:B6) |
| 8 | Share person 1 | =B7*B2/(B2+B3) |
| 9 | Share person 2 | =B7*B3/(B2+B3) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B7 =SUM(B4:B6)
All shared monthly costs.
B8 =B7*B2/(B2+B3)
Person 1 pays in proportion to their share of total income.
Make it yours by asking
Try a request like this in Tabstra:
"Create a household budget with two incomes, shared costs, and each person's fair share based on income"