Skip to content

Canadian Personal Budget Template (Free Spreadsheet Download)

Download our free, ready-to-use monthly budget spreadsheet built for Canadian households. Pre-configured with Canadian tax rules, registered accounts (TFSA, RRSP, FHSA, RESP), and provincial expense categories.

Most budget templates you find online are designed for Americans — with categories for 401(k)s, Roth IRAs, health insurance deductibles, and state taxes that make zero sense for everyday life in Canada. We built this spreadsheet specifically for Canadian households, incorporating net take-home pay, Canadian registered accounts (TFSA, RRSP, FHSA, RESP), government benefit deposits, provincial utility realities, and seasonal sinking funds.

Download the Canadian Budget Spreadsheet

Compatible with Microsoft Excel, Google Sheets, and Apple Numbers. 100% free — no email wall required.

Download Free Spreadsheet (.CSV)

How to Use This Template in Google Sheets, Excel, or Numbers

Getting started takes less than two minutes:

  1. Download the file: Click the download button above to save canadian-personal-budget-template.csv to your computer, tablet, or phone.
  2. Open in your preferred spreadsheet app:
    • Google Sheets: Go to sheets.google.com, create a blank spreadsheet, click File → Import → Upload, and select the downloaded CSV file.
    • Microsoft Excel: Double-click the file to open it directly in Excel, then choose File → Save As → Excel Workbook (.xlsx) so your formatting, colour coding, and custom formulas persist across months.
    • Apple Numbers: Drag and drop the file directly into Numbers on your Mac, iPad, or iPhone.
  3. Enter your monthly net income: Start at the top by inputting your actual after-tax take-home pay (after federal/provincial income tax, CPP/QPP, and EI deductions). If you live in Ontario, you can verify your exact net pay with our Ontario Income Tax Calculator.
  4. Enter your Planned vs. Actual columns: Set your target numbers before the 1st of the month in the Planned column, then update the Actual column once a week using your bank and credit card statements.

Prefer an interactive browser calculator without spreadsheets?

You can calculate your monthly 50/30/20 balance and test different Canadian spending scenarios in seconds right in your browser:

Open the Free Online Budget Calculator →

What’s Built Into the Canadian Template

Unlike generic American budgeting worksheets, every section of this template is structured around Canadian pay schedules, tax shelters, and household costs:

1. Canadian Net Income & Government Benefits

Budgeting from gross salary is one of the most common mistakes Canadians make. Your employment paycheque already has federal and provincial income tax, Canada Pension Plan (CPP), and Employment Insurance (EI) deducted. In addition, many Canadian families receive tax-free monthly or quarterly deposits that belong in your income block:

  • Employment Take-Home Pay (Net): For bi-weekly earners (26 paycheques per year), multiply one paycheque by 2 to set your reliable baseline month, and treat the two "three-paycheque months" each year as bonus savings accelerators.
  • Canada Child Benefit (CCB): Paid monthly on the 20th to eligible parents.
  • GST/HST Credit, Canada Workers Benefit (CWB), & Provincial Credits: Such as the Ontario Trillium Benefit (see our guide to the Canada Groceries & Essentials Benefit).
  • Side Hustle / Freelance Income (Net of Tax Reserve): If you earn self-employed income, set aside 25%–30% for CRA tax and CPP before adding the remainder to your spendable budget (see The Freelancer's Budgeting Guide).

2. The 50 / 30 / 20 Canadian Benchmark Structure

The worksheet organizes your spending into three foundational buckets (which you can customize if you prefer zero-based budgeting—see 7 Popular Budgeting Methods Compared):

  • Essential Needs (~50%): Rent or mortgage principal + interest, municipal property taxes, condo fees, home/tenant insurance, provincial hydro and winter natural gas heating, groceries (see How to Save Money on Groceries), GO Transit / TTC / TransLink / STM passes, auto insurance, and minimum required debt payments.
  • Discretionary Wants (~30%): Restaurants, coffee shops, takeout, streaming subscriptions, hobbies, personal care, and guilt-free fun money.
  • Savings, Investing & Extra Debt Payoff (~20%): Emergency fund building, extra principal payments on credit cards or loans, and registered account contributions.

3. Canadian Registered Shelters (TFSA, RRSP, FHSA & RESP)

The savings section includes dedicated rows for Canada’s four primary tax-advantaged accounts (explained in full in Canada's Registered Accounts Explained: TFSA vs RRSP vs FHSA):

  • TFSA (Tax-Free Savings Account): Tax-free investment growth and flexible withdrawals at any time. In 2026, the annual limit is $7,000 ($583.33/month). Check your exact cumulative limit with our TFSA Contribution Room Calculator.
  • RRSP (Registered Retirement Savings Plan): Pre-tax retirement contributions (18% of prior-year earned income up to $33,810 in 2026). Estimate your provincial tax refund with our RRSP Calculator.
  • FHSA (First Home Savings Account): For qualifying first-time Canadian homebuyers — $8,000/year ($666.67/month) up to a $40,000 lifetime cap, combining RRSP tax deductions with TFSA tax-free home withdrawals. Track your room with our FHSA Calculator.
  • RESP (Registered Education Savings Plan): Contributing $208.33/month ($2,500/year) per child unlocks the full $500 annual Canada Education Savings Grant (see our RESP Guide for Canadian Parents).

4. Canadian Seasonal Sinking Funds

Irregular annual bills are the #1 reason monthly budgets fail. Instead of putting a $900 winter tire bill or $1,200 December holiday spend on a 20% credit card, the template includes sinking fund rows where you set aside 1/12th of the annual cost each month inside a high-interest savings account:

  • Winter Vehicle Prep: Winter tires, seasonal tire swaps, rustproofing, and battery maintenance.
  • Home & Utility Spikes: Equalized winter heating buffer, property tax instalments, and DIY home maintenance.
  • Holidays & Annual Subscriptions: Christmas and holiday gifts (see our Holiday Budget Guide), back-to-school supplies, and annual CAA or Costco memberships.

How to Review Your Spreadsheet in 15 Minutes a Month

A spreadsheet only works if you build a simple habit around it. At the end of each month, follow this three-step review:

  1. Compare Planned vs. Actual: Identify the one or two categories where spending drifted above target (most commonly groceries or dining out) and adjust next month's allocation realistically.
  2. Sweep Your Surplus on Payday: Automate your TFSA, FHSA, RRSP, or debt acceleration transfers on the morning your paycheque lands, rather than waiting to see what is left over on the 30th.
  3. Update Your Net Worth Quarterly: Every three months, plug your updated savings and debt balances into our Canadian Net Worth Calculator to watch your progress compound over time.

Next Steps & Companion Guides