Spreadsheet For Expenses 40786 | Budgeting Worksheet Financialeducation

Partial file snippet.

Sheet 1: Create Your Budget

	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
 
		
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Enter your monthly income (Incoming Money), expenses (Outgoing Money) and savings (Saving for the future) into the yellow cells below. This will help you determine if you have an EXCESS or SHORTAGE of cash at the end of each month. 
If you have an EXCESS, great job! You have extra money you can spend or save. 
If you have a SHORTAGE, consider where you can lower your spending or savings to ensure you balance your budget and do not overextend yourself. Additional information can be accessed by clicking on the ? found throughout the worksheet.                                                                                                                                                                                                                                                                                                                   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Step 1: Incoming Money
		

		

		

		Monthly Total
		

		

		

		

		

		

		

		

		

	
	
		Start by adding up how much your household makes each month from all full time, part time, and miscellaneous income. This is the amount of money available to pay all bills, make personal (discretionary) purchases, and save for the future.
		Income
		
		If you get paid more than once a month, make sure to include all of your paychecks. 

Example: If you get paid $500.00 two times each month, your monthly income is $1,000.00. 

We also suggest using your net income and not your gross income.

Net Income = the amount of your paycheck that you "take home" after taxes, insurance, retirement, etc. are automatically deducted.

		?
		Person #1 Monthly Income
		

		

		

		

		

		

		

		

		

		

	
	
		

		Person #2 Monthly Income
		

		

		

		

		

		

		

		

		

		

	
	
		

		Child Support Received
		

		

		

		

		

		

		

		

		

		

	
	
		

		Incoming Rent Payments
		

		

		

		

		

		

		

		

		

		

	
	
		

		Miscellaneous Income
		

		

		

		

		

		

		

		

		

		

	
	
		

		Miscellaneous Income
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Total Income
		 -   
		

		

		

		

		

		

		

		

		

	
	
		Step 2: Outgoing Money
		

		

		

		Monthly Total
		

		

		

		

		

		

		

		

		

	
	
		


Next, add up your monthly bills and expenses so you can determine if you have excess income to save or spend on discretionary items.
		Housing 
		

		Rent or Mortgage
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; electric, water, sewer, heat, trash pickup, gas(**HEAT).
		?
		Utility Bills
		

		

		

		

		

		

		

		

		

		

	
	
		

		Internet, Cable and Streaming Services
		

		

		

		

		

		

		

		

		

		

	
	
		

		Mobile Phone Bills
		

		

		

		

		

		

		

		

		

		

	
	
		
		For some property owners, their taxes are already included in the mortgage payment. Double check to make sure your taxes are paid as a separate payment before including it as an expense in this row.

		?
		Property Taxes & Insurance
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; landscaping, plumber, electrician, house cleaner, etc.



		?
		Maintenance Costs
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Housing Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Housing Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Food
		

		Groceries
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; fast food, coffee shops, workday lunches, casual/fine dining, etc.

		?
		Dining Out
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Food Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Food Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Transportation
		

		Car Payment(s)
		

		

		

		

		

		

		

		

		

		

	
	
		

		Auto Insurance
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; bus, train, cab, etc.

		?
		Public Transportation
		

		

		

		

		

		

		

		

		

		

	
	
		

		Gas
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; oil change, new tires, replacement parts etc.



		?
		Maintenance Costs
		

		

		

		

		

		

		

		

		

		

	
	
		

		Parking & Tolls
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Transportation Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Transportation Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Health & Family
		
		Examples include; daycare, babysitting, etc.

		?
		Child Care
		

		

		

		

		

		

		

		

		

		

	
	
		

		Child Support Payments
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; child in college, family abroad.

		?
		Money sent to Family
		

		

		

		

		

		

		

		

		

		

	
	
		

		Prescriptions
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; co-pays, premiums

		?
		Health Insurance
		

		

		

		

		

		

		

		

		

		

	
	
		

		Gym Membership
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; vet bill, food, dog walker, etc.

		?
		Pet Costs
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; tuition, books, supplies, etc.

		?
		Educational Expenses 
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Health & Family Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Health & Family Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Personal
		

		Clothing/Seasonal Shopping
		

		

		

		

		

		

		

		

		

		

	
	
		

		Dry Cleaning
		

		

		

		

		

		

		

		

		

		

	
	
		

		Salon
		

		

		

		

		

		

		

		

		

		

	
	
		
		Examples include; movies, events, parties, books, video games etc.

		?
		Entertainment
		

		

		

		

		

		

		

		

		

		

	
	
		

		Donations
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Personal Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Personal Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Other
		

		Student Loan Payments
		

		

		

		

		

		

		

		

		

		

	
	
		

		Prepaid / Phone Cards
		

		

		

		

		

		

		

		

		

		

	
	
		

		Credit Card Payment #1
		

		

		

		

		

		

		

		

		

		

	
	
		

		Credit Card Payment #2
		

		

		

		

		

		

		

		

		

		

	
	
		

		Credit Card Payment #3
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Total Other Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		Total Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		Step 3: Saving for the future
		

		

		

		Monthly Total
		

		

		

		

		

		

		

		

		

	
	
		Finally, how much do you contribute to saving for the future?
		Savings
		

		For Unexpected Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		For Planned Vacations
		

		

		

		

		

		

		

		

		

		

	
	
		

		For Educational Expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		For Retirement 
		

		

		

		

		

		

		

		

		

		

	
	
		

		For Holidays/Birthdays
		

		

		

		

		

		

		

		

		

		

	
	
		

		Other Savings
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Total Savings
		 -   
		

		

		

		

		

		

		

		

		

	
	
		Let's take a look at your budget. Did you over spend or have excess income?
		

		

		

		Monthly Total
		

		

		

		

		

		

		

		

		

	
	
		

		Monthly Income
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		Monthly Expenses
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		Monthly Savings
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		Income less Expenses less Savings
		 -   
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 2: Track Your Budget

	
	
	
	
	
	
	
		
 
		
		
	
		BUDGET TRACKING WORKSHEET
		
	
		Enter your actual monthly income (Incoming Money), expenses (Outgoing Money) and savings (Saving for the future) into the yellow cells below. This will help you determine how well you are managing your budget. 
Your Budget will automatically be populated from the "Create Your Budget" tab.
		
	
		Step 1: Incoming Money
		

		

		

		Description
		Budget
		Actual
		Over / Under 
Budget
	
	
		Start by adding up how much your household makes each month from all full time, part time, and miscellaneous income. This is the amount of money available to pay all bills, make personal (discretionary) purchases, and save for the future.
		Income
		

		Person #1 Monthly Income
		 -   
		

		 -   
	
	
		

		Person #2 Monthly Income
		 -   
		

		 -   
	
	
		

		Child Support Received
		 -   
		

		 -   
	
	
		

		Incoming Rent Payments
		 -   
		

		 -   
	
	
		

		Miscellaneous Income
		 -   
		

		 -   
	
	
		

		Miscellaneous Income
		 -   
		

		 -   
	
	
		

		

		Total Income
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

		

		Over / Under 
Budget
	
	
		Step 2: Outgoing Money
		

		

		Description
		Budget
		Actual
		Budget
	
	
		


Next, add up your monthly bills and expenses so you can determine if you have excess income to save or spend on discretionary items.
		Housing 
		

		Rent or Mortgage
		 -   
		

		 -   
	
	
		

		Utility Bills
		 -   
		

		 -   
	
	
		

		Internet, Cable and Streaming Services
		 -   
		

		 -   
	
	
		

		Mobile Phone Bills
		 -   
		

		 -   
	
	
		

		Property Taxes & Insurance
		 -   
		

		 -   
	
	
		

		Maintenance Costs
		 -   
		

		 -   
	
	
		

		Other Housing Expenses
		 -   
		

		 -   
	
	
		

		Total Housing Expenses
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

	
	
		Food
		

		Groceries
		 -   
		

		 -   
	
	
		

		Dining Out
		 -   
		

		 -   
	
	
		

		Other Food Expenses
		 -   
		

		 -   
	
	
		

		Total Food Expenses
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

	
	
		Transportation
		

		Car Payment(s)
		 -   
		

		 -   
	
	
		

		Auto Insurance
		 -   
		

		 -   
	
	
		

		Public Transportation
		 -   
		

		 -   
	
	
		

		Gas
		 -   
		

		 -   
	
	
		

		Maintenance Costs
		 -   
		

		 -   
	
	
		

		Parking & Tolls
		 -   
		

		 -   
	
	
		

		Other Transportation Expenses
		 -   
		

		 -   
	
	
		

		Total Transportation Expenses
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

	
	
		Health & Family
		

		Child Care
		 -   
		

		 -   
	
	
		

		Child Support Payments
		 -   
		

		 -   
	
	
		

		Money sent to Family
		 -   
		

		 -   
	
	
		

		Prescriptions
		 -   
		

		 -   
	
	
		

		Health Insurance
		 -   
		

		 -   
	
	
		

		Gym Membership
		 -   
		

		 -   
	
	
		

		Pet Costs
		 -   
		

		 -   
	
	
		

		Educational Expenses 
		 -   
		

		 -   
	
	
		

		Other Health & Family Expenses
		 -   
		

		 -   
	
	
		

		Total Health & Family Expenses
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

	
	
		Personal
		

		Clothing/Seasonal Shopping
		 -   
		

		 -   
	
	
		

		Dry Cleaning
		 -   
		

		 -   
	
	
		

		Salon
		 -   
		

		 -   
	
	
		

		Entertainment
		 -   
		

		 -   
	
	
		

		Donations
		 -   
		

		 -   
	
	
		

		Other Personal Expenses
		 -   
		

		 -   
	
	
		

		Total Personal Expenses
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

	
	
		Other
		

		Student Loan Payments
		 -   
		

		 -   
	
	
		

		Prepaid / Phone Cards
		 -   
		

		 -   
	
	
		

		Credit Card Payment #1
		 -   
		

		 -   
	
	
		

		Credit Card Payment #2
		 -   
		

		 -   
	
	
		

		Total Other Expenses
		 -   
		 -   
		 -   
	
	
		

		

		Total Expenses
		 -   
		 -   
		 -   
	
	
		

		

		

		

		

		

		

		Over / Under 

	
	
		Step 3: Saving for the future
		

		

		Description
		Budget
		Actual
		Budget
	
	
		Finally, how much did you contribute to saving for the future?
		Savings
		

		For Unexpected Expenses
		 -   
		

		 -   
	
	
		

		For Planned Vacations
		 -   
		

		 -   
	
	
		

		For Educational Expenses
		 -   
		

		 -   
	
	
		

		For Retirement 
		 -   
		

		 -   
	
	
		

		For Holidays/Birthdays
		 -   
		

		 -   
	
	
		

		Other Savings
		 -   
		

		 -   
	
	
		

		

		Total Savings
		 -   
		 -   
		 -   
	
	
		Let's take a look at how well you managed your budget…
		

		

		

		

		

		Over / Under 
Budget
	
	
		

		

		Budget
		Actual
		
	
		

		Monthly Income
		 -   
		 -   
		 MET 
	
	
		

		Monthly Expenses
		 -   
		 -   
		 MET 
	
	
		

		Monthly Savings
		 -   
		 -   
		 MET 
	
	
		

		Income less Expenses less Savings
		 -   
		 -   
		 MET 
	
	
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	



Sheet 3: Debt Tracking

	
	
	
	
	
	
	
	
	
	
	
	
		
 
		
		

		

	
	
		

		

	
	
		This tab can be used to track your debt; credit cards, auto loans, home loans, etc. 
		

		

	
	
		Debt Breakdown
		

		Debt Type
		Lender/Payee
		Loan/Debt Start Date
		Annual             Percentage Rate
		Original Amt. Borrowed/Owed
		Current               Balance
		Min Mthly. Payment
		Actual Mthly. Payment 
		

		

	
	
		Enter debt currently owed, including lender, interest charged, original amount borrowed/owed, current balance and payment information.
		Debt
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		 Total 
		 -   
		 -   
		 -   
		 -

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet create your budget enter monthly income incoming money expenses outgoing and savings saving for the future into yellow cells below this will help you determine if have an excess or shortage of cash at end each month great job extra can spend save a consider where lower spending to ensure balance do not overextend yourself additional information be accessed by clicking on found throughout worksheet step total start adding up how much household makes from all full time part miscellaneous is amount available pay bills make personal discretionary purchases get paid more than once sure include paychecks example two times we also suggest using net gross paycheck that quot take home after taxes insurance retirement etc are automatically deducted person child support received rent payments next add so items housing mortgage examples electric water sewer heat trash pickup gas utility internet cable streaming services mobile phone some property owners their already included in payment doub...

Related files

Share

Help


BUDGET TRACKING WORKSHEET
Enter your actual monthly income (Incoming Money), expenses (Outgoing Money) and savings (Saving for the future) into the yellow cells below. This will help you determine how well you are managing your budget. Your Budget will automatically be populated from the "Create Your Budget" tab.
Step 1: Incoming Money		Description	Budget	Actual	Over / Under Budget
Start by adding up how much your household makes each month from all full time, part time, and miscellaneous income. This is the amount of money available to pay all bills, make personal (discretionary) purchases, and save for the future.	Income	Person #1 Monthly Income	-		-
		Person #2 Monthly Income	-		-
		Child Support Received	-		-
		Incoming Rent Payments	-		-
		Miscellaneous Income	-		-
		Miscellaneous Income	-		-
		Total Income	-	-	-
					Over / Under Budget
Step 2: Outgoing Money		Description	Budget	Actual	Budget
Next, add up your monthly bills and expenses so you can determine if you have excess income to save or spend on discretionary items.	Housing	Rent or Mortgage	-		-
		Utility Bills	-		-
		Internet, Cable and Streaming Services	-		-
		Mobile Phone Bills	-		-
		Property Taxes & Insurance	-		-
		Maintenance Costs	-		-
		Other Housing Expenses	-		-
		Total Housing Expenses	-	-	-

	Food	Groceries	-		-
		Dining Out	-		-
		Other Food Expenses	-		-
		Total Food Expenses	-	-	-

	Transportation	Car Payment(s)	-		-
		Auto Insurance	-		-
		Public Transportation	-		-
		Gas	-		-
		Maintenance Costs	-		-
		Parking & Tolls	-		-
		Other Transportation Expenses	-		-
		Total Transportation Expenses	-	-	-

	Health & Family	Child Care	-		-
		Child Support Payments	-		-
		Money sent to Family	-		-
		Prescriptions	-		-
		Health Insurance	-		-
		Gym Membership	-		-
		Pet Costs	-		-
		Educational Expenses	-		-
		Other Health & Family Expenses	-		-
		Total Health & Family Expenses	-	-	-

	Personal	Clothing/Seasonal Shopping	-		-
		Dry Cleaning	-		-
		Salon	-		-
		Entertainment	-		-
		Donations	-		-
		Other Personal Expenses	-		-
		Total Personal Expenses	-	-	-

	Other	Student Loan Payments	-		-
		Prepaid / Phone Cards	-		-
		Credit Card Payment #1	-		-
		Credit Card Payment #2	-		-
		Total Other Expenses	-	-	-
		Total Expenses	-	-	-
					Over / Under
Step 3: Saving for the future		Description	Budget	Actual	Budget
Finally, how much did you contribute to saving for the future?	Savings	For Unexpected Expenses	-		-
		For Planned Vacations	-		-
		For Educational Expenses	-		-
		For Retirement	-		-
		For Holidays/Birthdays	-		-
		Other Savings	-		-
		Total Savings	-	-	-
Let's take a look at how well you managed your budget…					Over / Under Budget
			Budget	Actual	Over / Under Budget
		Monthly Income	-	-	MET
		Monthly Expenses	-	-	MET
		Monthly Savings	-	-	MET
		Income less Expenses less Savings	-	-	MET

Related files

Share

Share to social media

Help

Login Area