excel spreadsheet for expenses monthly expenses template

EXCEL SPREADSHEET FOR EXPENSES MONTHLY EXPENSES TEMPLATE HOW TO

By the end, you will know how to design an customize a spreadsheet according to your unique requirements. After that, I’ll show you how to create your own Google Sheets expense tracker. I’ll show you how to use it as is and how to customize it for your specific situation. The first part of my guide talks about my budgeting template. In this tutorial, I’ll show you two ways to use Google Sheets to track your expenses. Create an Expense by Category Pie Chart.Cell Validation to Avoid Accidental Category Entries.Cell Validation to Ensure the Total Budget Doesn’t Exceed Amount Available.Advanced Functions of the Expense Tracker.Adding Formulas to the Overall Summary Table.Adding Formulas to the Expense by Category and Income by Category Tables.Building the Outline for the Expense / Budget Summary Sheet.Building the Outline for the Transactions Sheet.Renaming the Transactions and Summary Tabs.Creating a Google Sheets Expense Tracker from Scratch.Understanding the Monthly Budget Template.Creating a Bill Tracker / Expense Tracker Using the Built-in Monthly Expenses Template in Google Sheets.How to Create a Google Sheets Expense Tracker.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.

Excel spreadsheet for expenses monthly expenses template