This is a free budget spreadsheet for couples who share some costs and keep some money of their own. It splits shared costs 50/50 or in proportion to each partner’s take-home pay, shows what each of you moves to the joint account every month, and what each has left.
It’s an Excel file that also opens in Google Sheets and Apple Numbers, in Canadian dollars. There’s no sign-up.
What’s in the template
- Take-home pay for each partner, each with their own pay schedule: weekly, every two weeks, twice a month or monthly.
- The split. Choose 50/50 or by income. By income, each partner pays the same share of the shared costs as their share of household pay.
- Shared costs (ours). Rent or mortgage, groceries, utilities and the rest, each with each partner’s part, and a total each moves to the joint account.
- Yours and mine. Each partner’s pay, less their share of shared costs, less their own spending, and what’s left.
- Who paid. The Spending log records shared purchases and who paid them, and the Budget sheet compares what each paid this month with their share.
A worked example
Alex is paid $2,600 every two weeks and Sam $1,900 twice a month, both take-home. Their shared costs come to $5,010 a month.
| Alex | Sam | Household | |
|---|---|---|---|
| Take-home pay a month | $2,600 × 26 ÷ 12 = $5,633.33 | $1,900 × 24 ÷ 12 = $3,800.00 | $9,433.33 |
| Share of household pay | 59.7% | 40.3% | 100% |
| Pays toward $5,010 of shared costs, by income | $2,991.84 | $2,018.16 | $5,010.00 |
| Pays toward shared costs, 50/50 | $2,505.00 | $2,505.00 | $5,010.00 |
Split by income, each keeps about 47% of their own pay after shared costs: $2,641.50 for Alex and $1,781.84 for Sam. Split 50/50, Alex keeps $3,128.33 (56%) and Sam $1,295.00 (34%). Figures on this page are examples.
How to use it
- Enter both names, take-home pay per cheque and pay schedules.
- Choose 50/50 or by income.
- List your shared costs with a monthly amount each.
- Set each partner’s own spending. The template shows what’s left for each.
- Through the month, log shared purchases and who paid, to see if one of you is carrying more than their share.
One budget or two
If you run all your money as one pot, the Canadian budget template treats the household as one budget. Our guide to joint or separate accounts sets out how each kind of account works in Canada.
Larch does this from your statements, with every figure for the household or either of you.