It's been a while since my
budget update. Most of 2012 was pretty rough budget-wise, resulting from a temporary dip in income, and us neglecting to properly adjust.
In November The Hubby got a new job which restored our income back to where it used to be. We still have room for improvement in our budget, but at least we are floating instead of sinking now.
In March I put a few formulas into the spreadsheet I've been using to track our spending. Now it does all the math for me, all I have to do is enter in the activity. I wasn't keeping up as well as I should have before that, because it would take too much time figuring out how much I had spent and where. I also uploaded the file to
Dropbox so that I could access and update it where ever I had a moment to do so.
In April I updated the tracker almost every day. This made it a lot easier to gauge where I needed to make adjustments as the month went on.
If you're interested, here is a blank version of the template.
Budget Template
The Transactions tab has data validation so that you can only choose certain categories, which ensures everything gets calculated properly on the Budget tab. These categories can be changed as necessary, but you'll need to remember to add a spot on the Budget tab where it gets added up.
The Budget tab is based on
Dave Ramsey's budget sheets. I've added a few categories of my own, and there are some I don't use. There is a column in which to mark how much you plan to spend in any given category. The next column adds up those goals into sub totals. The third column pulls from the Transactions tab, and adds up spending based on what category was chosen.
I also added sections to show variances in discretionary spending categories and the categories where spending varies month to month. It gives a quick heads up if I start going into the red in something (I put in conditional formatting to actually turn it red).
In April, we did quite a bit of overspending in the discretionary areas, but we still ended up in the green at the end of the month. With a Dave Ramsey zero based budget, that means the leftover gets used to pay off debt. I ended up making a pretty big extra payment on our credit card. But I could have doubled it if I had stuck to my budget.
How's your budget?