This worksheet will calculate how much you have each month.Īre your incomes paid twice a month? Then you will need to change the formula a little bit. If it doesn’t, then you will want to add it to one of the expense items.Īre your incomes paid every two weeks? Then you’re all set. Health insurance is typically an expense that comes right out of someone’s paycheck. The “net” is the money you have to work with in your budget - and the reason why this budget doesn’t include health insurance expenses. That is, the amount of money that gets deposited in the bank. Just because I want to spend $15 a month on Dunkin Donuts doesn’t mean that my husband should have a $15 per month D&D budget. We each have different spending priorities personally, so this is a great example of “fair is not always equal” (as my sister says). For us, that means that my trips to Dunkin Donuts come out of my allowance and my husband’s gadget purchases come out of his allowance. We each have a monthly allowance, so to speak, to spend on whatever we want - no questions asked. Not all families do this, and that’s fine. Here is an example of how the budget worksheet works with annual expenses that are completely shared: Personal Expenses
Enter those amounts in the “Shared” column and the “Subtotal” will calculate $83.33 and $250 per month expenses. For example, you may spend $1,000 per year on travel and $3,000 per year on home repairs and maintenance. The Subtotal will still divide the “Shared” number by 12 and give you a monthly amount.
What if you have an annual expense that’s shared, and not paid per individual? Just enter a number into the “Shared” column and it will overwrite the formula in that cell. Here is an example of how the budget worksheet functions with annual expenses, using hypothetical life and disability premiums: The “Subtotal” column will divide that “Shared” amount by 12, which gives you the amount you should set aside every month for that annual expense. The “Shared” column will add up all the life insurance premiums paid annually. Those annual expenses have $0 already written into the “Shared” column - just like the items in the “Annual Expenses” category. Enter the amount your family spends, per person, every year on that item.įor example, if you pay a life insurance premium every year in August, enter the amount of the premium. It’s an expense that we can pay for when it arises, but it’s just easier to put it into the budget as an annual expense and let the worksheet figure out how much it costs us per month. A good example of those expenses are gifts: We spend $50 per person per birthday and for Christmas. We also have items that we spend on throughout the year but do not set up an automatic savings deposit to pay for them. We set up our checking account to automatically deposit this amount into a savings account on the 5th of each month. Thus, the “Total” is the amount of our monthly deposit. We have an “Annual Expenses” category, for items we save for over the course of a year by depositing money into a savings account each month. Annual ExpensesĪnnual Expenses are expenses that happen less frequently than every month. If the expense is not an individual amount, but an expense for the entire family (for example: your mortgage or rent), enter that number into the “Shared” column. How to Use The Budget WorksheetĮnter the monthly amount spent for each family member on every item. It is a link to a Google Drive document, which you can download to your computer or save to your Drive folder - where you can access it whenever you have an internet connection. Do you want to figure out where you have been spending your money?ĭo you want to set up a budget for where to spend your money going forward? Click here for the budget worksheet I created for my family’s finances.