Layout:
Home > Personal finance tools: No. 3 - Bills and Budget

Personal finance tools: No. 3 - Bills and Budget

May 5th, 2009 at 04:05 pm

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.

2 Responses to “Personal finance tools: No. 3 - Bills and Budget”

  1. whitestripe Says:
    1241563353

    Smile interesting! i like to see how other people keep track. makes me want to post mine too!

  2. ceejay74 Says:
    1241619434

    You should, whitestripe! I'm curious about how other people do theirs, and was kinda hoping this would spur someone to post their methods.

Leave a Reply

(Note: If you were logged in, we could automatically fill in these fields for you.)
*
Will not be published.
   

* Please spell out the number 4.  [ Why? ]

vB Code: You can use these tags: [b] [i] [u] [url] [email]