This is a free monthly budget spreadsheet for Canadian households, in Canadian dollars. It turns pay every two weeks or twice a month into a monthly figure, lists 22 common categories with a planned and an actual amount, and shows how your plan splits against 50/30/20.
It’s an Excel file that also opens in Google Sheets and Apple Numbers. There’s no sign-up.
What’s in the template
- Budget. Your take-home pay for up to three earners or sources, each with its own pay schedule. Then 22 categories, each with a planned amount, the actual amount for the month you choose, and what’s left or over. Overspent lines turn red.
- Spending log. One row per purchase or bill. Paste rows from your bank or card statement, pick a category, and the Budget sheet adds them up for the month.
- 50/30/20 box. Your planned needs, wants and savings as a share of take-home pay, next to the 50/30/20 rule of thumb.
- Lists. The category names and groups. Rename them and the Budget sheet follows.
The savings group has its own lines for a TFSA, RRSP and FHSA, so registered savings sit in the budget like any other bill.
How to use it
- Enter your take-home pay per cheque and choose how often you’re paid.
- Put a planned amount next to each category you use. Leave the rest at $0.
- As the month goes, add purchases to the Spending log, or paste them from a statement.
- Change the month at the top of the Budget sheet to see any month you’ve logged.
Paid every two weeks or twice a month
The difference is two cheques a year. Every two weeks is 26 cheques; twice a month is 24. The template multiplies each cheque by the right number and divides by 12.
| Example | Cheques a year | Per cheque | Per month |
|---|---|---|---|
| Every two weeks | 26 | $2,150 | $2,150 × 26 ÷ 12 = $4,658.33 |
| Twice a month | 24 | $1,800 | $1,800 × 24 ÷ 12 = $3,600.00 |
Figures on this page are examples.
A worked example
Here’s the example budget in the template. Two take-home pays come to $8,258.33 a month: $4,658.33 and $3,600.00 from the table above.
| Group | Planned a month | Share of take-home pay | 50/30/20 |
|---|---|---|---|
| Needs: rent, groceries, utilities, transit and the rest | $3,995 | 48% | 50% |
| Wants: eating out, shopping, travel and the rest | $805 | 10% | 30% |
| Savings: TFSA, RRSP, emergency fund | $700 | 8% | 20% |
| Not yet planned | $2,758.33 | 33% |
This example household has $2,758.33 a month it hasn’t given a job yet. The template shows that line so nothing goes missing.
When there are two of you
This template treats the household as one budget. If you each pay a share of shared costs and keep your own money too, the couples’ budget template splits shared costs 50/50 or by income and shows what each of you moves to a joint account.
Other free budget tools
The Financial Consumer Agency of Canada has a free online Budget Planner and a guide to making a budget. Both work in your browser.
Larch does this month by month from your statements: spending by category against your usual month, for the household or either of you.