Monthly Budget Template for Canada

The classic starting point. Eleven categories that cover a typical Canadian month.

This monthly budget template uses the same category set most Waypoint Budget users start with. It is built around a sample after-tax income of $4,000 per month, which is close to the Canadian median for a full-time worker. Adjust every number to your own city and situation. The percentages matter more than the dollar amounts.

Using Google Sheets? 1. Download the Excel (.xlsx) file. 2. In Google Sheets, choose File, then Import, then Upload, and pick the file. Or drag the file into Google Drive and open it with Google Sheets. The formulas come with it, so the totals keep updating.

New for the New Year: the January 2027 Monthly Budget sheet

The template

Sample income: $4,000 after-tax per month. Amounts are a starting point, adjust them to your city and situation.

CategoryMonthly (CAD)% of income
Rent

Swap for Mortgage plus Property Tax if you own

$1,20030%
Groceries
$40010%
Utilities

Hydro, gas, water

$1504%
Transportation

Transit pass or gas and parking

$2005%
Insurance

Tenant, auto, life

$1504%
Internet & Phone
$1002.5%
Healthcare

Dental, prescriptions, glasses

$1002.5%
Dining Out
$2005%
Entertainment
$1002.5%
Shopping

Clothing, household items, everything retail

$1504%
Savings

Emergency fund first, then TFSA or FHSA

$3007.5%
Total budgeted$3,05076%

Needs $2,300 (57%) • Wants $450 (11%) • Savings & debt $300 (8%)

The Excel file has four tabs: Budget (income, budgeted, spent and remaining, with Needs, Wants and Savings & debt totals), Transactions (log spending once and every total updates), Month by month (twelve months of actual spending from the same log) and How to use.

What Waypoint Budget adds: The Just Me template at sign-up starts you on nearly the same categories, rollover categories build up money for irregular costs on every plan, Bank sync brings in transactions from Canadian banks on paid plans (the free plan has no bank connections), and the CSV import reads this sheet's Transactions tab.

January 2027 Monthly Budget

The same eleven categories, with the month already set to January 2027 and the Month by month tab set to 2027, so you can start logging on January 1. January is when most budgets get rebuilt, and it carries a few costs the rest of the year does not.

  1. 1

    Holiday spending usually shows up on the January credit card statement. Decide how much of it this month pays off before you set the other categories.

  2. 2

    Look for annual renewals that land in January, such as memberships, software and some insurance policies, and fund them before Dining Out and Entertainment.

  3. 3

    New TFSA contribution room opens on January 1. Once your emergency fund is in place, decide how much of the Savings line goes to your TFSA this year.

  4. 4

    Pick a date at the end of January to compare Spent with Budgeted. The first month is for learning your real numbers, not for hitting every line.

Using Google Sheets? 1. Download the Excel (.xlsx) file. 2. In Google Sheets, choose File, then Import, then Upload, and pick the file. Or drag the file into Google Drive and open it with Google Sheets. The formulas come with it, so the totals keep updating.

How to use this template

  1. 1

    Start with your real after-tax income: the amount that lands in your chequing account each month.

  2. 2

    Fill in your fixed expenses first: rent, utilities, insurance, internet and phone. These rarely change month to month.

  3. 3

    Set realistic amounts for groceries, dining out and entertainment based on your last two months of statements, not on what you wish you spent.

  4. 4

    Whatever is left after categories is your buffer. In this sample about $950 stays unassigned for irregular costs and extra savings.

  5. 5

    Review at the end of the first month and adjust. A budget you tune beats a budget you abandon.

Skip the spreadsheet

Sign up for Waypoint Budget and pick the Just Me template during onboarding. You start on nearly the same categories, adjust the amounts, and your transactions are sorted into them with Smart auto-categorization. Bank sync with major Canadian banks is available on paid plans.

Start free with this template

Free tier available. No credit card required.

Frequently asked questions

What percentage of income should rent be in Canada?

The traditional guideline is 30% of after-tax income, and this template uses that number. In Toronto and Vancouver many renters realistically spend 35% to 40%. If housing runs high, trim dining out, shopping and entertainment rather than savings.

How much should I budget for groceries in Canada?

A reasonable starting point for one person is $350 to $450 per month. Statistics Canada data puts average per-person food spending in that range, higher in northern and remote communities. Track two real months before locking in your number.

Is this template based on the 50/30/20 rule?

It is compatible with it but more specific. Needs in this sample come to roughly 60% of income, wants about 12%, and savings 7.5% plus the unassigned buffer. Use the category lines to build toward 20% savings over time.

More Canadian budget templates

Disclaimer: This template is for educational and informational purposes only and does not constitute financial, tax, or legal advice. Results are estimates based on simplified assumptions and may not reflect your actual situation. Tax laws, contribution limits, and regulations change frequently. Always consult a qualified financial advisor or tax professional before making financial decisions. See our Terms of Service for full details.