VX42 Home Budget Worksheet JAN FEB MAR APR MAY JUN JUL Created by Eric Bray and Vertex42 LLC © 2007 Vertex42 LLC AUG SEP OCT NOV DEC TOTALS Income Categories Take Home Pay Bonuses Gifts Received Tax Refunds Interest Income Dividends Refunds/Reinbursements Savings Withdrawal Other Income #1 Other Income #2 Other Income #3 TOTAL INCOME 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Deductible Expenses Business Expenses Unreimbursed Office At Home Other Business Expenses Charitable Contributions Religious Other Non-Profit Deductible Tax Personal Propery Tax Real Estate Tax Other Deducible Tax Health Medical Insurance Medicine/Drug Doctor/Dentist/Optometrist Hospital Other Health Alimony Losses-Unreimbursable Mortgage Interest Other Deductible Total Deductible Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Non-Deductible Expenses Auto/Transportation Fuel Service Transportation Other Baby Diapers Formula Clothing Clothes / Shoes Laundry / Dry Cleaning Other Clothing Daily Living Babysitting / Child Care Dining / Eating Out Groceries Personal Supplies Discretionary Name 1 Allowance Name 2 Allowance Dues/Subscriptions Club Memberships Newspaper Child Sports Education Music Lessons School Lunch Tuition Other Education Expenses Entertainment CD/DVD Books/Magazine 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Dates Film/Photos Hobby Movie Rental Other Entertainment Gifts Given Household Furnishings Appliances Improvements Maintenance Other Household Insurance Auto Insurance Homeowners Insurance Life Insurance Rental Insurance Other Insurance Lawn/Garden Lawn/Plants Tools/Equipment Other Lawn/Garden Loan Payments Auto Loan Credit Card Payments Educational Loan Installment Loan Personal Note Other Loan Miscellaneous Bank Fees Postage Other Miscellaneous Non-deductible Expense Rent Expense House Payment Savings Emergency Fund Transfer To Savings Investments Other Savings Expense Tax Not Withheld Fed Tax Not Withheld Other Tax Not Withheld Utilities Electricity Gas Internet Oil/Fuel Telephone Trash Pickup Water/Sewer Other Utility Vacation/Travel Total Non-Deductible Expenses TOTAL EXPENSES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Income - Expenses Beginning Balance Predicted Ending Balance Actual Ending Balance 0.00 1,000.00 1,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 VX42 Home Budget Worksheet Instructions The 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 financially in the future. If you are moving, changing jobs, purchasing a home, or making other major life changes, it is essential to plan for many months down the road. 1. Edit/Create/Delete categories and subcategories Use row operations, such as copying an entire row and then inserting it above another row. The subtotal formulas are set up to allow this type of editing without messing up the formulas. 2. Verify that all of the subtotal formulas are correctly summing the correct cells 3. Modify the month headings as needed 4. Enter your beginning balance at the bottom of the worksheet 5. Fill in the income and expenses for the year a. You can copy and paste cells as needed For example, enter an average fuel cost in Jan, and copy it across through Dec b. Include large lump payments in the months in which they will likely occur or use the approach of averaging the cost across each month. When using the averaging approach, consider that your actual balance may not reflect the predicted balance for the month. If you use the lump payment approach, it may be easier to compare actual balances, but make sure you have enough saved. c. Add cell comments as needed to help explain costs. For example, include the names of Birthdays in comments for the Gifts Given category Updating the Worksheet After 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 you may want to adjust your worksheet to reflect what you actually received and spent. Tips for Quicken Users Make sure that you set up the Quicken categories the same as in your budget worksheet, or vice versa. It helps to have the categories organized alphabetically in 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 expenditures to your budget.