One thing I love to do is play with the reports in Microsoft Money. I've been using it for years so I have every single solitary transaction downloaded right into Money so I can keep track of balances and spending and everything else. If you've read my most recent post in the debt tracker area you'd probably run from using Money! Well don't fear because it does have a use even for someone like me. There is a report called the Income and Spending report that will tell you by category every cent that you've made and spent from the dates that you decide. Well I decided this would be a great way to get a handle on how I got into this predicament of being (as of today) $95,714.92 in debt. Well here is the results of that report:
From 6/9/07 to 6/9/08:
Income: $263,049.02
That's every type of income (for us it would be salaries, bonuses, ebay income, rebates, etc.)
Expenses: $255963.03
Well...what the HECK did we spend Two hundred and fifty five thousand dollars on in one year? Oh it gets better!
There is what I like to call a top 3. Three expense categories which are all in the over $30,000 spent column. Yes that's over THIRTY THOUSAND spent column!
1) Taxes: $39,822.16
Obviously I can live with this one. Otherwise Uncle Sam probably wouldn't be too happy. Take that away from the above gross income and you have our net: $223,226.86. So where did it go?!!
2) Bank Charges: $36,994.30
You read that right. We sent almost $37,000 to the banks in interest charges, annual fees, monthly fees, etc. Are you kidding? Holy ouch Batman! When you've woken up from passing out you can continue...trust me I needed a few minutes after I first saw this number.
3) Vacation: $32,971.71
Now before you say that's insane no one would spend $33,000 on vacations...well go ahead and say it but it doesn't stop the bleeding. WOW. This includes Philadelphia to Seattle, Vancouver, Chicago a few times, St. John USVI, Phoenix and Hawaii. Yep we lived a little over the last twelve months...way, way, way, way, way beyond our means. It's crazy when it's a big number right in front of you.
***It drops considerably from here but I figured I would throw a couple more in here so you can get more of an idea where it's gone.
4) Home Improvement: $12,709.51
Well finally something we will actually see a return on. I mentioned the house which we bought for $400k in January of 2006 (brand new...we built it from the ground up.) We refi'd it in March of this year after it appraised at $470,000 to a 30 year fixed at 5.75 and included all our closing costs, insurance, etc (and had to pay off two ARM's..yeah...ouch) so we ended up having to borrow $405,000 to do that. The good news is the money above went to landscaping and some upgrades inside that we got our money back on and then some. It still hurts that we have such a large mortgage but at least this money didn't go to waste.)
5) Utilities: $9126.15
Electric, Propane gas (the highest), water/sewer, trash, cable, phone, etc. It equates to around $760/mo. I know it seems like a TON but it's really in the ballpark of what we budget for. Crazy isn't it.
OK so that's just the top 5! There are more...if I get some more time I might just post them. This is a wakeup call to anyone who doesn't budget. We did, then we didn't, now we are where we are. Yikes is about the only word I've got for you right now. !
Income and Spending in MS Money
June 9th, 2008 at 06:20 pm
June 9th, 2008 at 09:02 pm 1213045354
The good news is you make good coin. If you cut out the vacations and dial back the lifstyle, you should be able to pay off that debt in 2 years.
June 9th, 2008 at 10:49 pm 1213051769
June 9th, 2008 at 10:55 pm 1213052115
merch: That's the plan. We really needed to get refocused and get a huge reality check and I think it doesn't get any more "slap in the face" than those numbers. We never think about it when we're actually out and about but it's a heavy dose of reality right there.
Petunia: It's super sticker shock after the purchase!! Writing them down is a good thing too. I'm trying to finally use my OCD and ADD for good rather than evil with handwriting, Excel and Money. I figure the more I obsess (in a good way) about the debt the more I feel like wanting to see those numbers go down. As long as I don't lose my head I'm happy!
June 10th, 2008 at 05:35 am 1213076134
June 10th, 2008 at 06:01 pm 1213120876
It's painful!