Thank you to TurboTax for sponsoring my writing about household finances.Learn more about how TurboTax can help you find every tax deduction you deserve. I was selected for this sponsorship by the Clever Girls Collective, which endorses Blog With Integrity, as I do.
A long time ago I was using the envelope system of budgeting. This is where you deal mostly in cash. You take all the cash out of your bank account and split it into envelopes in your house. So your grocery envelope will have cash in it, electricity, mortgage, etc. When the bill comes or when it’s time to spend that money, you take the cash out of the envelope and pay the bill (or go shopping). This makes sure that you never overspend in any of your budget categories.
Now, I’m a technology junkie (have you noticed that about me yet? 😉 ) This method was a little “archaic” for me. Plus I don’t like keeping that much cash around. So then I moved to a big piece of paper. I drew several lines on the paper and split the money that I currently had in my checking account and savings account into categories. So say I had 400 in my checking account. I would have columns labeled along the top with the various categories… Mortgage, Electricity, Gas, Groceries, etc. Then I would split that 400 into the categories. Like I would put $100 in Mortgage, $100 in Electricity, $100 in Gas and $100 in Groceries (actual numbers are for simplicity). Now when I would go grocery shopping and I spent $50, I would come back to my piece of paper and deduct $50 from the grocery category and know that I had $50 left to spend for groceries.
Again, this was feeling a bit ancient. So I decided to make an excel spreadsheet with the data, so I wouldn’t have to do the math myself. I went a step further and added the amounts from each paycheck that need to go into each category. So along the top I will put Hubby’s 1st Paycheck of the month. In each column I will put the amount of each paycheck that should go into the category. Again for simplicity I will use basic numbers. So say Hubby’s paycheck is usually at least $300. Along the top of the budget I will put 50 in the grocery category, 100 in mortgage, 50 in electricity, and 100 in gasoline. Now when payday arrives I put 300 in my calculator and start deducting. -50 on the calculator and then add 50 to the excel sheet. Along the top will have the actual amounts currently in each category in case there is some left over from the last deduction to that category.
More recently I have added some additional tabs along the bottom of my excel sheet. One is our debt reduction. It’s pretty self explanatory in that we just put how much we’ve paid, and it will show how much is left. This does not include interest, as it’s really just a gauge into approximately how much debt is left. If you want to include interest I would just deduct the interest from the actual payment so it looks like you are actually paying less (which technically you are since you aren’t paying down the balance on the interest).
The last tabs are the monthly budget template and the monthly budget acutals. Each month you create a new tab with the current month. You copy the data from the template to the new month. This is where you can put the dates you paid your bills so you know that all the bills that need to be paid have been paid, and you can keep track of what you are actually spending. At the end of the month I total up the items in my account allocation (just the negative amounts) and add them to the month tab. Then I put the amount that is going to carry over into the next month at the top of the positive section and delete all the amounts underneath.
Here is a link to my Monthly Budget excel sheet. If you have any questions about it, just post it in the comments here, since other people may have the same question!
Good luck and happy budgeting!
This post may contain affiliate links, which means I receive compensation if you make a purchase using the links.
I am a mom who can fix your blog, your computer, or your server. I have been in the IT industry supporting small businesses for over 15 years. As a diehard PC and Android user, I can usually be found sparring with Apple fanboys, or watching movies with my family.