spreadsheet for monthly income and expenses

SPREADSHEET FOR MONTHLY INCOME AND EXPENSES SOFTWARE
SPREADSHEET FOR MONTHLY INCOME AND EXPENSES FREE

If you own a small business, you’ll have expenditures in different categories to record. Business expenses to consider for your monthly tracker By using the AutoSum feature, you can see how much you’ll be spending per month, or year, and tweak your budget to match your goals. Lastly, Excel makes it easy to tally up a total cost across columns. You can estimate how much you’ll pay per month for utilities, or if you know that you have a fixed rate for mortgages and loans, you can fill in the blanks ahead of time. Your rows can be tied to the months in this year where you’re anticipated to make monthly payments or save for major repairs. In an Excel template, you can create new sheets for each of these major categories, then break them down to specific expenses.įor example, create a new sheet, name it Housing, and then dedicate a column to the expenses that fall under this category (monthly mortgage payments, anticipated home repairs, etc.). Goals: Something you might be saving for in the long term, whether it’s a new car, an appliance upgrade, or sending a child to college.Emergency savings: Create an emergency savings fund and be prepared for anything.Entertainment: streaming subscriptions, video games, live shows, upcoming vacations and weekend getaways.Utilities: gas, water, heat, electricity, and Internet.Transportation: auto loans, public transit fare, car maintenance and repairs.Housing: mortgage payments, home repairs, homeowners’ insurance, and property taxes.Important categories in your personal budgetįor the average household, expense trackers usually contain the following:

SPREADSHEET FOR MONTHLY INCOME AND EXPENSES SOFTWARE

The fundamental questions you want to be able to answer with a quick glimpse are, “What did I spend my money on, and how much did I spend?” Spreadsheet software like Excel is ideal for displaying this information in rows and columns.

SPREADSHEET FOR MONTHLY INCOME AND EXPENSES FREE

Savings: emergency fund, RRSPs, RESPs, TFSAs, seasonal expenses (e.g.Manage your finances with this free expense tracker template Go to Excel 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.

Spreadsheet for monthly income and expenses