How to Make a Worksheet Template to Budget Your Monthly Bills
How to Make a Worksheet Template to Budget Your Monthly Bills. Balancing your household finances is not always easy. Sometimes you might end up with extra money at the end of the month, which is great. But other times you might find yourself scraping to cover all your monthly bills. Making and using a budget worksheet is one of the best ways to track your spending. A worksheet lists your income and expenses in one place, but most people don’t want to write out a new one every month. Use the table feature in a word processing program to design a worksheet template that you can use repeatedly.
- Financial records
Gather your financial documents for a month. Make one pile for income and a second pile for expenses. Arrange the expenses from most important to least important. Count how many monthly bills you have.
Open a new blank document in Microsoft Word.
Type a name for the worksheet template, such as “Household Budget Worksheet,” and center it on the top line using a large font size, such as 18 points or above.
Skip a line, click “Insert,” select “Table” and then click “Insert Table.” Under “Table Size” make four “Columns.” Make the “Rows” whatever number equals your household’s total monthly bills plus four additional rows. These additional rows are for the titles, the extra bills that might come in some months and the totals.
Type “Income” using a bold font in the first cell of the top row. Skip the next cell. Type “Expenses” in the third cell of the top row.
Type the sources of your household income in the first column, such as “Net Salary,” “Bonus,” “Tips,” “Rental Income” and “Child Support,” and end with “Other Income.” Use the first column for income sources only.
Skip the second column, which is used for income amounts.
Type the sources of your household’s monthly bills in the third column, such as “Housing,” “Car Payment,” “Gas,” “Electric,” “Food,” “Medical,” “Child Care” and “Credit Card,” and end with two “Other Expenses.”
Type “Total” in the first and third columns on the bottom row of the table, either in bold or a larger font size. Skip a line beneath the table and type “Total Household Income.” Type “Total Household Expenses” on the line below, and then “Difference” on the next line.
Skip a line and type “Household Changes Needed for Next Month.” This area is for writing down the plans for your next month's budget. This might include setting up a savings account for extra money or cutting out an expense to cover your monthly bills.
Look over all areas for mistakes. Click on the Office Button or “File” in older versions. Click “Save As.” Select “Word Template” under “Save As Type.” Type in “Household Budget Worksheet” and click “Save.”
- Insert figures in the second column for income amounts that remain the same each month, such as rentals or child support, before you save the worksheet template. This step saves you from having to write them in every month.
- Insert figures in the fourth column for expenses that stay the same each month, such as housing and car payments. Do this before saving the worksheet template.
- Do not type in any amounts for incomes or expenses that fluctuate each month, such as tips, bonuses, wages, gas, electric and food. You will write these in every month.
- The University of Maine: Budgeting: Making a Plan