My Bills and Budget spreadsheet is the master budget--what my budget is going to look like each month.
Every month or so, when I've deleted a bunch of things from my Number Crunch worksheet and it's only looking about two months into the future, I copy and paste the items from this spreadsheet into the bottom of the Number Crunch and adjust the dates to match when they'll actually hit for that next month.
(That does bring up an interesting point--I don't track spending each month the way a lot of people here do--I don't keep track of what's spent and look back over past months. When something occurs in my checking account, I delete it from the Number Crunch. It's worked out really well for me, so I can't see adding more work just to satisfy my curiosity as to how much I actually spend versus what I think I'm going to--the adjustments I make to the budget are very slight anyway, usually just increasing my savings when we get more income than expected.)
As with other spreadsheets, I've tinkered around with Bills and Budget and added a few things. Initially, it just looked like this:
Then I got interested in how my budget broke out percentagewise for general spending areas, so I came up with this gadget:
I also have a separate calculation of what the take-home pay amount is, to make sure that the above widget is up-to-date (since I have to change the formulas anytime I add or subtract a line item). I also made a note to myself of what NT's weekly take-home averages out to. That's just so I can quickly refer to it if he gets furloughed and I need to make cutbacks to discretionary spending.
Personal finance tools: No. 3 - Bills and Budget
May 5th, 2009 at 04:05 pm
May 5th, 2009 at 10:42 pm 1241563353
May 6th, 2009 at 02:17 pm 1241619434