Monthly Expense Calculator and Tracker
Personal Budgeting
When you think of tracking your expenses, what comes to mind first? Maybe you’re curious about where your money is going. Or, do you dread the thought of having to write down every penny you spend?
Most people only track their spending for a few weeks so that they can see where their money is actually going. Other people only track certain types of expenses, like where they spend their cash.
Tracking your spending can be as easy or as hard as you make it, but when you’re trying to get on top of your money and debt, the pay off for doing it is huge!
Resources Provided on This Page
Jumping right to the point, here are the two key resources offered on this page. For more details on using them, please see further down the page.
option one:
monthly expense calculator tracker
option two:
daily & weekly expense tracker
Excel monthly expense tracker (that also works in Google Sheets) – it’s a worksheet, spreadsheet, calculator and spending planner for individuals and households.
Resources Provided on This Page
Jumping right to the point, here are the two key resources offered on this page. For more details on using them, please see further down the page.
option one:
monthly expense calculator tracker
Excel monthly expense tracker (that also works in Google Sheets) – it’s a worksheet, spreadsheet, calculator and spending planner for individuals and households. Below is a screenshot.
Download Monthly Expense Calculator & Tracker as Microsoft Office Excel 97-2003 Worksheet (.xls) File
Also works in Google Sheets
option two:
daily & weekly expense tracker
Daily, weekly, and monthly personal expense tracker for printing out on paper. You can download a copy below.
Expense Calculator and Tracker
Personal Budgeting
If this is your first time tracking your expenses, or if you’re getting back to it because your situation has changed, below are tips and tools to help you get started.
However, if you’ve got a lot of bills you’re trying to manage, there are non-profit credit counselling organizations that are happy to help you get started. Every day their Counsellors help every one of their clients with their expenses and budget. They’re experts at it, so contact them for a free appointment and they’ll share their best help with you too!
How to Track Your Spending and Expenses
Tracking where your money is going is the process of writing down what you spend. You may use a little notebook to do this, a spreadsheet, an app on your phone or other software programs. You might track as you spend money or you might collect receipts and track at the end of the day or week. Regardless of which method you choose, the purpose is the same; you want to see what you’re spending your money on so that you can make some decisions about how to spend it more wisely.
Know Your Spending Habits – Track What You Spend
When you first start tracking expenses, you might be tempted to jot down what you should be spending. Fight that urge and spend as you normally would. Tracking isn’t meant to make you feel guilty and stop you from spending. It’s meant to highlight what your habits are so that you can make some choices and changes later.
Budget Planner – Track Expenses to Help You Build a Personal Budget
It’s unrealistic to think that you’ll track your spending forever. If you can track for a month, be proud of yourself and incorporate what you learned into your monthly budget. Then if your circumstances change, go back to tracking for another few weeks to get your spending in line with your new level of expenses or income.
If you’re not sure how to start tracking, here are two options to get you started. Remember, keep it simple, go easy on yourself and ask for help if you need it. Old habits are hard to break!
Two Options to Help You Track Your Spending
- Download an Excel Monthly Tracking Worksheet (also works in Google Sheets) and track your spending using either Microsoft Excel or Google Sheets, or
- Open our simple Monthly Expense Tracker (PDF) and follow the steps below.
option one:
monthly expense calculator tracker
option two:
daily & weekly expense tracker
Budget Planner – Track Expenses to Help You Build a Personal Budget
It’s unrealistic to think that you’ll track your spending forever. If you can track for a month, be proud of yourself and incorporate what you learned into your monthly budget. Then if your circumstances change, go back to tracking for another few weeks to get your spending in line with your new level of expenses or income.
If you’re not sure how to start tracking, here are two options to get you started. Remember, keep it simple, go easy on yourself and ask for help if you need it. Old habits are hard to break!
Two Options to Help You Track Your Spending
- Download an Excel Monthly Tracking Worksheet (also works in Google Sheets) and track your spending using either Microsoft Excel or Google Sheets, or
- Open our simple Monthly Expense Tracker (PDF) and follow the steps below.
Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
option one:
monthly expense calculator tracker
Download Monthly Expense Calculator & Tracker as Microsoft Office Excel 97-2003 Worksheet (.xls) File
Also works in Google Sheets
option two:
daily & weekly expense tracker
Monthly Expense Tracker
Easy Instructions
- Click here to open a copy of our Monthly Expense Tracker.
- The expense categories listed below and on page 1 of the Expense Tracker will help you determine which expenses to record where.
- For each week, record dates you are tracking. For example, a 7 day tracking period would be May 3th to June 5th. The next week would start on June 6th.
- Record cash balances on hand or in your bank account and list any income you expect to receive during each week.
- List the dates down the left side and record actual money spent each day. Use the blank columns to create your own categories. Maybe you want to track coffees, magazines or fuel separately.
- Weekly savings amounts also need to be recorded on pages 14–15 of the Expense Tracker. Keep track of seasonal expenses on these pages, not on your weekly pages.
- Total all columns and subtract actual expenses from actual income. If there is a surplus, this means you should have money in your wallet or bank account. This becomes the cash balance for the next week.
How to Choose Expense Categories for Tracking
Recording where you spend your money involves categorizing your expenses. Below are the most popular expense categories which include where most people spend their money.
Another way of tracking your spending is by choosing the types of stores you shop at. If you usually shop for groceries, personal care and paper/household products all at one superstore, having a category with the name of the store might work better for you.
Ultimately, there’s no right or wrong category, but you do need enough categories to be able to track your spending accurately.
Expense Categories – Know Where Your Money is Going
Housing: rent, mortgage, strata fees, property taxes, house insurance
Utilities: phone/cell, cable/internet, gas, hydro, security
Household: storage locker, decor, gardening, misc. items
Groceries: food, baby needs, household supplies, toiletries
Living: personal care, bank fees, dry cleaning, pet costs
Transportation: fuel, auto insurance, transit, parking, taxi, ride share
Health Care: medical premiums, life insurance, medication, eye care, dental, wellness costs
Personal: tobacco, alcohol, books, music, donations, subscriptions
Eating Out: meals, snacks, take-out, coffee/water
Entertainment: recreation: sports equipment/fees, movies/tickets, hobbies, lottery/gaming, memberships (fitness, etc.)
Child: daycare, lessons/activities, allowance, school supplies/fees, babysitting
Debt Payments: loans, credit cards, leases, support payments, government debts
Savings: emergency fund, TFSAs, RRSPs, RESPs, for seasonal expenses (e.g. car repairs, travel/vacations, clothing, gifts, assisting family/friends)
Business Expenses: materials, labour, administration, taxes, human resources
To download the expense sheets and complete information, click here.
Contact a Non-Profit for More Information About Monthly Expense Tracking and Budgeting
The most important part of tracking your expenses is getting started! Don’t wait until you have the perfect monthly expense tracker system or all the right categories for your budget. Dive right in, get started and adjust your method as you go.
And if you need help, a budgeting expert is just a call or email away!
learn all about credit
online workshop
In this free online workshop you’ll learn everything you want to know about credit reports, ratings, and scores.
how to get
debt help
Are you looking for confidential, non-judgmental help to relieve your stress get your finances back on track?
insights and ideas
on our blog
On our blog we endeavour to explore insightful ways of saving money and using it more wisely.