household budget worksheet excel us bank

Household budget worksheet excel us bank how to#
Household budget worksheet excel us bank download#

Once you put this number into the spreadsheet in the lines “Net paycheck 1” and “Net paycheck 2” with the frequency, the template will automatically calculate the equivalent weekly amount for your income and it shows this number at the top next to “Average Weekly Income”. You can choose “Weekly”, “Every Two Weeks”, “Twice a Month”, “Monthly”, “Every 3 Months”, or “Every 6 Months”. Next choose how often you are paid from the dropdown in the spreadsheet. First input your regular incomeįirst thing to do is to get a copy of your paychecks and fill in the how much you get paid. After putting in your income and expenses, the spreadsheet will calculate their weekly equivalents and let you know what you can safely spend in a week. This is where you will put in all your recurring income and expenses. So to start, open the sheet called “Safe-to-Spend”. The first step in creating a weekly budget is to understand what you “Safe-to-Spend” number is.

Household budget worksheet excel us bank how to#

(It syncs with your bank and credit cards to keep your Safe-to-Spend number up-to-date!)īelow are the instructions on how to use the weekly budget template spreadsheet to calculate a weekly budget for yourself and then use the spreadsheet to track your personal spending. If you get tired of using a spreadsheet to track of your weekly spending, we suggest giving our weekly budget app a try. It behaves much the same way that our app does but in a spreadsheet instead.

Household budget worksheet excel us bank download#

You can download our weekly budget template as an Excel document (.xlsx) or open it as a Google Sheet to calculate your Safe-to-Spend and then track of your spending on a weekly basis. If you would like to try and do the same thing but with a spreadsheet instead, you are in luck! Savings: emergency fund, RRSPs, RESPs, TFSAs, seasonal expenses (e.g.We created Weekly as an app to help you stay on track with your personal finances using a weekly budget. 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.