Hey all, it's been way too long since I dropped in to write a bit. Nothing sinister or unpleasant, things have just been busy. I know, I know, that's a lame excuse but it really is the truth. Most days I can grab 30 minutes here & there for some recreational surfing but I rarely have the time to write.
So what's been going on? Well, Mountain Lake has been it's usual crazy self. Those of you who attend know what I'm talking about! Growth groups have started back and I find myself leading a whole new group of people. It's a larger group that I'm accustomed to so that'll take some adjusting on my part. They're great folks though and it'll be exciting as we all grow together.
MLC just wrapped up a series on finances called Becoming the Boss of Our Bling. The pastors spent three weeks talking about different aspects of finances: faithful giving, the danger of defining ourselves through our stuff, and how to evaluate our financial status.
Like every series at MLC it was relevant to our day to day lives. We've always tried to keep control of our finances but it's all too easy to let our finances take control of us! Check out Casey Graham's blog for some cool stuff. Casey really has some great ideas on getting things in order and he's plugged into a whole pile of like-minded people.
So, sorry to disappoint, I don't have any deep insightful thoughts tonight -- not that I'm under any illusion that I ever did have any deep insightful thoughts. I've got a few things bubbling around in my head so if I can grab a chunk of time soon I promise to post one or two before the end of the year.
Oh... wait... there is something I want to add on the topic of finances...
This is, like, so 1980's but my primary financial management tool is ... wait for it ... a spreadsheet. Yes, I use Quicken to pay my bills and manage my accounts and it's really great for that. But, honestly, it's forecasting and tracking just aren't that good for me. It could be because it's a canned application and doesn't give me any way to really customize things -- no, changing the categories of a report is not customization! Not that a spreadsheet is as malleable as a Java file in an IDE but it does give me a chance to manipulate my financial data in ways that I want rather than in ways the Quicken programmers decided.
So what's in my high-tech late-80's era spreadsheets? Well, I have two currently. The one I've used for many years is a projection tool. I have a tab per month and on each tab I track everything coming in and going out. Regular, recurring payments are scheduled and each month's value comes from the preceding history (and gets updated with real values when they roll around). It's more than I can describe in words but the point is that at any time during the year I can look at any tab (or the handy-dandy graph on the 13th tab) and see what my cash-flow will look like at that point in time. Of course the projection can't predict things like a broken washing machine or whatnot but it does a good job at covering 80% of the situation. That gives us enough information at a glance to know whether or not it'll be smart to remodel the kitchen. We may have enough money this month to get started but if the project says we're in the red three months out then getting started is a Bad Idea. If you're not using some method -- even pencil and paper -- to project your future cash-flow situation then you really have no idea how today's spending is going to impact tomorrow's opportunities.
My second spreadsheet is only a couple of months old. On this one I track our credit card expenses. If our credit card company was enlightened and would let me download transactions into Quicken daily I probably could live without the spreadsheet. Alas, they don't -- apparently they think it is sufficient to only show me the data on the web. So... a daily cut-and-paste into my spreadsheet lets me have a daily view into what we've spent. That in itself would be useful but where it really helps is to throw that up against a weekly budget value that rolls up into a billing-cycle budget value. I don't care how much we spend on food or movies -- I only care that we stay in the budget amount each week. This works surprisingly well. If we do really good or really bad one week then we adjust it into the next week as appropriate. If we're having bad weeks at the beginning of the month the we know that dinner & a movie isn't on the todo list at the end of the month. C'est la vie. Since we started doing this we've cut our monthly credit card bill to somewhere between two-thirds and three-quarters of its previous average. The tool is just a means to an end though; as with the projection spreadsheet, the real value is in raising our awareness of where things stand.
OK, so not a very spiritual post but rethinking the Bling series gave me the idea. My spreadsheets work for me and I make no promise that they're anything other than noise to anyone else but... if you're interested post a comment and I'll figure out a way to make 'em available.
Peace to all.
No comments:
Post a Comment