#Monthly household budget spreadsheet how to

HOA Fees: HOA fees are homeowner’s association fees, but the budget calculator is flexible, so you can use this box however you need to. If you’re a homeowner and your property taxes are not included in your mortgage payment, divide those taxes by 12 and add that amount to your mortgage to make sure your property taxes are covered in your monthly budget. Mortgage or Rent: Enter the amount of your monthly mortgage payment in the mortgage box, or the amount of your monthly rent in the rent box of the budget calculator. This budget calculator guide will walk through each section, step by step. The rest of the budget maker is dedicated to capturing your monthly expenses.

#Monthly household budget spreadsheet how to

Step 2: How to determine and enter monthly expenses You can also use this section to add a second income if you’d like to create a joint budget. If you have additional income such as a side job, child support, alimony, or other supplemental income, add the monthly amount you can spend in the monthly budget calculator under Other Income. If the last 3 months were unusually high or low, add up all your deposits for the past year instead and divide by 12 to get a better average. Enter that amount in the budget calculator. If your income changes from month to month, add up your total monthly deposits for the last 3 months and divide that number by 3 to get a monthly estimate.If you get paid every other week, multiply your take-home amount by 26 for the number of checks you get each year, and then divide by 12 to get your monthly take-home pay.If you get paid twice a month, add the take-home amount of your two checks together and enter that amount.If you get paid a regular check once a month, simply enter the take-home amount of that check.To determine what to enter under Salary/Wages in the budget calculator: Net income is what you actually bring home after taking out taxes and any paycheck deductions for things like your retirement or your health insurance plan. Gross income is what you make before anything is deducted from your paycheck. This will be the amount you can spend every month, so be sure to use your net income, not your gross income. The first step in the monthly budget calculator is to determine your monthly income. Build your budget in 3 easy steps Step 1: How to determine and enter your income