Home
entries friends calendar user info <1000 words Previous Previous Next Next
Brian's irrelevant scribblings - All personal finance software totally sucks ass
blah, blah, blog
sinnabor
[info]sinnabor
Add to Memories
Tell a Friend
All personal finance software totally sucks ass
And not in a good way.

I've been trying to get my 401(k) transactions into either Quicken or MS Money, so I can do some rough analysis on it. It shouldn't be that hard.

Both programs characterize a 401(k) account as a simple investment account: having both a cash side, and an investments side. When you buy a stock, the money necessary for the purchase comes from the cash side. It makes perfect sense for brokerage accounts, because that's how they work.

But 401(k) accounts take all their money from your paycheck, and it's often not even mentioned as showing up in the account, just the purchases are. When I download the past 9 years worth of transactions from Fidelity (2 years at a time, because that's all they support), they provide only the investment purchases... which makes it look like all those purchases came from the cash side, and put the cash side of the account into a big fat hole.

The solution? Well, I can manually enter 9 years worth of paycheck contributions. Which I did. (On a yearly basis.)

Except that that's not enough. Every single dividend also generated a blob of cash (not recorded) and a share purchase (recorded) for the exact same amount. So I have to add all those manually too.

So, fine, whatever, if I just have Quicken list out all the dividend transactions, I can print them and manually re-enter them as cash additions. Except that Quicken 2006 has a bug, and can't separate those transactions from the rest. Leaving me to scroll through the list and copy them one-by-one to new entries at the bottom.

Augh.

Intuit's web site has useful help topics like "How do I enter a transaction?" and "What great offers do you have for me?" but doesn't answer the useful questions like "Why does Quicken 2006 Mac have almost nothing changed since Quicken 2002 Mac?" and "Who are the losers who work on this thing?"

Tags: ,

Comments
skullbunny From: [info]skullbunny Date: August 8th, 2005 02:56 am (UTC) (Link)
You may need a financial planner to help you do all this stuff. Not sure how much they charge, but they probably have better software :)
sinnabor From: [info]sinnabor Date: August 8th, 2005 04:02 pm (UTC) (Link)
I bet they just use spreadsheets instead. I'm thinking about it.

But getting a financial planner to take care of the books is like paying a mechanic to clean your car. I'll get it mostly in order first, then get expert help for the tricky parts.
ranger1 From: [info]ranger1 Date: August 8th, 2005 05:41 am (UTC) (Link)
Yeah, the Mac version has sucked increasingly in recent years. It's sad. I used to like Quicken. Did someone put a curse on them?
sinnabor From: [info]sinnabor Date: August 8th, 2005 04:09 pm (UTC) (Link)
Heh. I know where that user icon comes from. I'm such a geek.

They have no competition. So, of course, they do only as much work as necessary to keep you from not buying next year's copy. It's irritating, but a standard business behavior, and could even be considered financially responsible.

I wonder how hard it would be to whip up a basic accounts package in Cocoa? Obviously doing their weird online stuff would be hard, but all the basic importing/balancing doesn't seem difficult.
arkanjil From: [info]arkanjil Date: August 8th, 2005 04:29 pm (UTC) (Link)

it wasn't till after I dissed quicken with many snarks

that I found out that one of R.s good friends is one of thier developers... I've considered asking for his help on a non-existant problem, just to make nice with him.

I've been using Money to track my 401k since 99, using a slush to hold the withdrawels until they were applied. Messy,b ut it worked, up until my company switched from measuring the amounts from stock to 'units'- and then switched back again...

Last I looked, my 401k account as tracked by Money and the statements I insist on still getting by mail differ by about 100k; I really haven't the heart to fix it, much less swap the fiscal tracking functions to the mac (Quicken still gives me hives...). I've heard that there is(was) an open sourced account manager that could seriously give Quicken a run for it's money, tho I've yet to find a link...
realaustinman From: [info]realaustinman Date: August 8th, 2005 12:33 pm (UTC) (Link)
The whole iMartyr-dom thing aside, Intuit are pretty unresponsive when it comes to bugs.

I reported one a few years ago where if you delete a currency (I wasn't going to travelling to Ghana any time soon), they have some table pointers that get off. Still ain't fixed, but they've added plenty of little reminders to use their bill-pay service. Meh.

When I set up my paycheck in Q2005, it transfers the cash for the 401K with each paycheck. Is there a particular reason you've not set up your paycheck in Quicken?
sinnabor From: [info]sinnabor Date: August 8th, 2005 04:05 pm (UTC) (Link)
I expect a big part of the problem is just that they have no competition in the realm of Macintosh personal financial software. Microsoft certainly isn't going to develop Money for the Mac anytime soon. (Not that MS Money is all that fabulous anyway.)

I resisted setting up the online stuff for ages. I mean, if the point was to fact-check the statements from the bank, then importing data directly from the bank just circumvents the entire check. But I'm getting too lazy to enter everything by hand. I just hadn't realized you could set up your paycheck that way.
7 comments or Leave a comment
profile
Brian R. Smith
User: [info]sinnabor
Name: Brian R. Smith
Website: <1000 words
calendar
Back June 2009
123456
78910111213
14151617181920
21222324252627
282930
page summary
tags