Home Budget Worksheet

HomeBudgetWorksheetSaveTheStudent.orgStudent Budget WorksheetJANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDECTOTALSIncomeWork Pay0.00Grant0.00Gifts Received0.00Interest Income0.00Other Income0.00Other Income0.00Other Income0.00TOTAL INCOME0.000.000.000.000.000.000.000.000.000.000.000.000.00ExpensesTransportation0.00Clothes0.00Food0.00Personal Supplies0.00Tuition Fees0.00Extra Tuition0.00Course Books & Supplies0.00CDs, DVDs, Games etc.0.00Nights OutRentUtilitiesInsurance0.00Charity Donations0.00Gifts0.00Taxes (Income, Council..)0.000.000.000.000.000.000.000.000.000.000.000.000.00Income - Expenses0.000.000.000.000.000.000.000.000.000.000.000.00Opening Balance1,000.00Predicted Ending Balance1,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.00Actual Ending Balance

SaveTheStudent.org

HelpVX42Home Budget WorksheetInstructionsThe Home Budget Worksheet is meant to help you create a budget for an entire year.Doing this will help you make predictions about where you may stand financiallyin the future. If you are moving, changing jobs, purchasing a home, or making othermajor life changes, it is essential to plan for many months down the road.1. Edit/Create/Delete categories and subcategoriesUse row operations, such as copying an entire row and then inserting itabove another row. The subtotal formulas are set up to allow this type ofediting without messing up the formulas.2. Verify that all of the subtotal formulas are correctly summing the correct cells3. Modify the month headings as needed4. Enter your beginning balance at the bottom of the worksheet5. Fill in the income and expenses for the yeara. You can copy and paste cells as neededFor example, enter an average fuel cost in Jan, and copy it across through Decb. Include large lump payments in the months in which they will likely occuror use the approach of averaging the cost across each month. When using theaveraging approach, consider that your actual balance may not reflect the predictedbalance for the month. If you use the lump payment approach, it may be easierto compare actual balances, but make sure you have enough saved.c. Add cell comments as needed to help explain costs. For example, includethe names of Birthdays in comments for the Gifts Given categoryUpdating the WorksheetAfter a month has passed, enter your Actual Balance at the bottom of the worksheet.If the actual balance is much different from the prediction, try to figure out why, and youmay want to adjust your worksheet to reflect what you actually received and spent.Tips for Quicken UsersMake sure that you set up the Quicken categories the same as in your budgetworksheet, or vice versa. It helps to have the categories organized alphabeticallyin this worksheet, because that is the way Quicken displays them in the Cash Flow reports.Creating a Cash Flow report in Quicken makes it easy to compare the month's expendituresto your budget.

VX42

Attribute VB_Name = "Sheet2"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "ThisWorkbook"Attribute VB_Base = "0{00020819-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True

Attribute VB_Name = "Sheet4"Attribute VB_Base = "0{00020820-0000-0000-C000-000000000046}"Attribute VB_GlobalNameSpace = FalseAttribute VB_Creatable = FalseAttribute VB_PredeclaredId = TrueAttribute VB_Exposed = TrueAttribute VB_TemplateDerived = FalseAttribute VB_Customizable = True