Free Canadian budget template for Excel and Google Sheets

Canadian monthly budget template

Excel file (.xlsx), 17 KB · free, no sign-up

Download
Budget
Take-home pay for any pay schedule, 22 categories with planned and actual amounts, and a 50/30/20 check
Spending log
One row per purchase; the Budget sheet adds up the month you pick
Lists
Category names and groups you can change

Opens in Excel, Apple Numbers and Google Sheets (in Sheets: File, then Import, then Upload). Example amounts are filled in so you can see it working; replace them with your own.

A template that does arithmetic on what you type. Where CRA limits apply, they're the published limits as of Nov 20, 2026. Not advice. Check it against your own records before you act on it.

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

  1. Enter your take-home pay per cheque and choose how often you’re paid.
  2. Put a planned amount next to each category you use. Leave the rest at $0.
  3. As the month goes, add purchases to the Spending log, or paste them from a statement.
  4. Change the month at the top of the Budget sheet to see any month you’ve logged.

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.

Common questions

Is there a free budget template for Canadians?

Yes. Larch's Canadian budget template is a free Excel file that also opens in Google Sheets and Apple Numbers. It works in Canadian dollars, turns pay every two weeks or twice a month into a monthly figure, and includes TFSA, RRSP and FHSA savings lines.

How do I budget if I'm paid every two weeks?

Multiply one take-home cheque by 26, then divide by 12. A $2,150 cheque every two weeks is $2,150 × 26 ÷ 12 = $4,658.33 a month. Being paid twice a month is 24 cheques a year, so the same cheque would be $3,583.33 a month.

What is the 50/30/20 budget?

A rule of thumb that splits take-home pay into about 50% for needs, 30% for wants and 20% for savings and extra debt payments. It's a starting point, not a rule; the template shows your own split next to it.

Does this budget template work in Google Sheets?

Yes. In Google Sheets, choose File, then Import, then Upload, and pick the downloaded file. The formulas and drop-down lists carry over.

Do I need to sign up to download it?

No. It's a direct download with no email or account.

Changes

  1. Published.

Try Larch free

Make your login in a minute. Free while Larch is in beta. No bank password, now or later.

Sign up Have a login? Sign in to Larch