Free Monthly Expenses Spreadsheet for Excel, Google Sheets and Paper
Fill It In, See Your Total, and Compare It With the Average Canadian Household
This free monthly expenses spreadsheet does one job: it turns every bill you pay, however often you pay it, into one monthly number, then tells you what is left. No sign up, no email address, no watermark. Download it for Excel, make a copy in Google Sheets, or print the checklist and do it with a pen.
It was built by the Credit Counselling Society’s money coaches, who have reviewed tens of thousands of household budgets, and it uses the same expense categories as our guide to average monthly expenses in Canada. That means it can show you, line by line, how your spending compares with Statistics Canada’s figures for the average household while you fill it in. Think of it as a personal budget sheet for the whole household, not just for you.
What the Monthly Expenses Spreadsheet Does
Type what you pay in the yellow cells. Pick how often you pay it: monthly, weekly, every two weeks, every three months, twice a year or once a year. The sheet converts everything to a monthly amount, so a $1,680 car insurance bill shows up as $140 a month instead of ambushing you in March. It totals each group, shows each one as a share of your take home pay beside the guideline our counsellors use, compares you with the average Canadian household, and tells you what is left at the end of the month. A second tab is a month by month budget spreadsheet with a chart of the year, and a third is a monthly expenses checklist so nothing gets missed.
Pick your format
Same categories, same math, three ways to use it. Answer three quick questions or just pick one.
Excel spreadsheet
The full file: dropdowns, automatic monthly conversion, totals, the year tab and chart, the checklist tab.
- Works in Excel, LibreOffice and Numbers
- Compares you with the Canadian average
- Guideline check on every group
Google Sheets
The same spreadsheet in your browser and on your phone, saved to your own Google Drive. Share it with a partner and fill it in together.
- Opens with one tap: Make a copy
- Nothing is shared with us
- Everything the Excel file does
Printable checklist
Two pages: the checklist of 48 expenses with a line for each amount, and a worksheet with the totals, guidelines and Canadian averages.
- Letter size, prints in black and white too
- No screen, no account
- Good for a fridge door
Pick Your Format
Three versions, one list, same math. Excel is the full monthly expenses sheet: formulas, dropdowns, the year view and the chart. It also opens in LibreOffice and Apple Numbers. Google Sheets gives you the same free monthly budget spreadsheet in your browser, saved to your Google Drive, so it works on your phone and you can share it with a partner and fill it in together. The printable PDF is a two page checklist and worksheet for people who think better with a pen: every category, a line for each amount, the four steps and the guideline percentages on one sheet of paper. Not sure which you want? Answer the three questions above and it will tell you.
What you get, tab by tab
Filled in with sample numbers so you can see how it works. Yours starts blank.
Inside the Spreadsheet
The My Monthly Expenses tab is the one you will use most. Income at the top, eleven groups of household expenses below, 48 lines in all, each with an amount, a frequency and a notes column. Every group has a total, a share of take home pay and the Credit Counselling Society guideline beside it, so you can see at a glance that housing is at 31% against a 35% ceiling, or that food is at 23% against a 10 to 20% range. To the right, a How You Compare block puts your housing, groceries, transportation, health and irregular costs next to the average Canadian household from Statistics Canada’s 2023 survey, revised in September 2026.
The Month by Month tab is a simple monthly budget spreadsheet and monthly expense tracker for the year: type what you actually spent in each group at the end of every month and it keeps the running totals, the monthly average, what was left over, and a bar chart of income against expenses. The Checklist tab lists all 48 expenses with a Yes or No column and counts how many you pay for. The Start Here tab explains the whole thing in five lines, with a worked example of how a yearly bill becomes a monthly one.
How to Fill It In: 10 Minutes and Three Months of Statements
- Enter your take home pay first. After tax and deductions, for everyone in the household. If you are paid every two weeks, enter the paycheque amount and set the frequency; the sheet does the conversion.
- Fixed bills next. Rent or mortgage, utilities, phone and internet, insurance, loan payments, child care, subscriptions. These rarely change, so copy them straight from the bill.
- Variable costs as a three month average. Groceries, fuel, eating out, personal care. Add up three months of statements and divide by three. Guessing is where most budgets go wrong, so if you do not have the statements, track for a month with our free Spending Tracker and come back.
- Yearly and occasional costs with the frequency set. Car insurance, property tax, gifts, clothing, vacations, vet bills. Enter the yearly total, choose Yearly, and the sheet spreads it across twelve months.
- Read the bottom three lines. Total monthly expenses, what is left over, and expenses as a share of pay. Then look at the How You Compare block and the guideline check beside it.
If the first total is higher than your income, you are in the majority. That is the information, not the verdict. The sheet will tell you which groups are over the guideline, and that is where you start.
The Printable Monthly Expenses Checklist
Some people want paper. The printable version is the same monthly expenses list in two pages: page one is the checklist, 48 expenses in eleven groups with a box to tick and a line for the monthly amount; page two is the worksheet, with the income lines, the group totals, the guidelines, the four steps, the frequency conversions and the Canadian averages for comparison. Tick what you pay for below, copy the list to your notes app, or print the PDF and keep it on the fridge.
Tick what you pay for
Even occasionally. Then copy the list to your notes app, or print the PDF and fill it in by hand.
Using It in Google Sheets
Open the Google Sheets link and choose Make a copy. Google saves your own copy to your Drive; nobody else can see it, and we cannot see it either. Your copy becomes a Google Sheets monthly budget you can open anywhere. The dropdowns, formulas, year view and chart all carry over. On your phone, open the Google Sheets app and your copy is there. To budget with a partner, use Share and give them edit access, and you can both fill it in from wherever you are. If you would rather not use Google, the Excel file does everything the same way on a computer.
Turn the Spreadsheet into a Budget
A monthly expenses spreadsheet tells you what you spend. A budget decides what you will spend. When you are ready for that step, and want a monthly budget planner that decides the numbers rather than just recording them, our free online Budget Calculator takes the same categories and builds a full budget around them, with every line checked against the budgeting guidelines, coaching tips as you go, and a plan for whatever is left over. If you prefer to stay in Excel, the classic Budget Calculator spreadsheet is the bigger, more detailed cousin of this one. And if the food lines are what surprised you, our guide to the average cost of groceries per month in Canada shows what households your size really spend and how to set a grocery number that holds.
Your Monthly Expenses Spreadsheet Is Filled In. Now What?
Three outcomes. Money left over: give it a job before it finds one, emergency fund first, then the most expensive debt, then a goal. Breaking even: the irregular costs line is the one to watch, because one surprise bill tips it. Expenses higher than income: start with the big three, housing, transportation and food, then look hard at the debt line. If credit card and loan payments are what keep the total above your pay, a better spreadsheet will not close the gap, and a free, confidential conversation with a money coach at the Credit Counselling Society, a non-profit organization, will. Your monthly expenses spreadsheet gave you the number. Book a free appointment and a coach will help you build the plan around it.
0 Comments