Household expense spreadsheet8/18/2023 Savings: emergency fund, RRSPs, RESPs, TFSAs, seasonal expenses (e.g. Personal: tobacco, alcohol, books, music, clothing and shoes, donations, subscriptionsĮating Out: meals, snacks, take-out, beverages (coffee, tea, juice, soft drinks)Įntertainment: recreation, sports equipment and fees, movies, concerts, hobbies, gamingĬhild: daycare, lessons and activities, allowance, school supplies and fees, babysitting, programs, tutorsĭebt Payments: credit cards, loans, leases, support payments, government debts, personal debt Health Care: medical premiums, life insurance, medication, eye care, dental, supplements, wellness costs Transportation: fuel, auto insurance, transit, parking, taxi, rentals, car sharing, tolls Living: personal care, bank fees, salon and spa services, dry cleaning, pet costs, memberships (fitness, clubs, associations) Groceries: food, baby needs, household supplies, toiletries Household: furnace, water tank, roof and gutters, decor, upgrades, storage locker, gardening, cleaning services, outdoor equipment and maintenance Utilities: phone/cell, cable/internet, gas, hydro, security Housing: mortgage, rent, strata fees, house insurance, property taxes View a sample of a completed tracker (from the previous version of our Monthly Expenses Tracker).Įxpense Categories – Know Where Your Money is Going This becomes the cash balance for the next week. If there’s a surplus, you should have money in your wallet or bank account. Total all columns and subtract actual expenses from actual income.On these pages, keep track of seasonal expenses rather than recording on your weekly pages. You also need to record weekly savings amounts on pages 14 – 15 of the Expense Tracker.You may want to track coffees, dining out, or fuel separately. You can then use the blank columns to create your own categories. List the dates down the left side and record actual money spent each day.You should also list any income you may expect to receive during each week. Record cash balances on hand or in your bank account.For example, a 7 day tracking period would be March 30th to April 5th. For each week, record dates you are tracking.The expense categories listed further below and on page 1 of the Expense Tracker will help you decide which expenses to record where.Open a copy of our Monthly Expense Tracker.Savings can be in the form of things such as cash, investing in shares, contributing to superannuation or, most commonly, paying down or retiring debts (including principal repayments on credit cards, personal debts and mortgages). Once you have a rough idea of your spending, you can simply deduct it from your income to figure out how much you can potentially save each budget period. If you don’t, one big bill is going to blow your monthly budget entirely. Because I budget monthly, I then divide those costs into 12 and include them as line items in my budget (“Household Fund” etc) to make sure I am provisioning for such future costs. Professional fees: financial, legal and other fees to get my financial affairs in orderĪt the start of each financial year, I make an estimate of my likely expenses in each category.Holidays: all costs associated with taking a holiday.Birthdays and Christmas: gifts for myself, my son and others.Health: health insurance and $1000 a year for unexpected medical expenses.School: school fees, uniforms and extra curricular activities.Car: registration, comprehensive insurance, compulsory third party insurance, regular servicing and repairs, parts and roadside assist.Household: strata fees, council rates, home insurance, water bills and $1000 a year for emergency household repairs.Then, you need to list all your outgoings across three different types of expenditure: direct debits, variable spending and regular contributions towards large expenses or spending goals (I call these “Future Funds” – more later). For people on irregular incomes, you can either choose to estimate a sum you think you are likely to receive, or you can budget off the minimum you know you will receive. ![]() Because I am paid regularly, I can just divide my annual salary by 12 to get my monthly income. I budget monthly, even though I am paid fortnightly. Download my free monthly budget template here.įirst: set a time frame for your budget and determine your income. ![]() If you’re not, I still encourage you to still have a stab. Highlight the range of data in your list that you want to use. Ok, let’s assume you are mildly familiar with where your money goes, it’s time to create a budget. Click anywhere within your list of data and then select Insert > Table. I send out links each week to my 10 budget category worksheets. Did you miss my series breaking down my 10 spending categories? No worries, sign up to receive my free weekly newsletter email via this link /moneywithjess or /moneywithjess.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |