The 401(k) program we switched to this year happens to have been a step backward as far as support for exporting transactions. In talking with Alan about it, he said he’d downloaded a program to convert the CSV they export into a QIF. In looking at the QIF format, I just decided to whip up something to do the conversion for me. This converts the export from MVP Plan Administrators to QIF and imports successfully into Quicken for Mac 2007.
#!/usr/bin/perl
#based on: http://en.wikipedia.org/wiki/QIF
open(INH, "< ". $ARGV[0]);
open(OUTH, ">". $ARGV[0]. ".qif");
print OUTH '!Account
NDavid\'s New 401k
TInvst
^
!Type:Invst
';
<INH>
while (<INH>) {
chop;
chop;
s/\$//g;
@vals = split /,/;
if ($vals[3] eq 'RECEIVABL') {
next;
}
print OUTH "D" . $vals[0] . "\n";
print OUTH "N" . $vals[5] . "\n";
print OUTH "Y" . $vals[4] . "\n";
print OUTH "T" . $vals[9] . "\n";
print OUTH "I" . $vals[8] . "\n";
print OUTH "Q" . $vals[7] . "\n";
print OUTH "M" . $vals[6] . "\n";
print OUTH "^\n";
}
close OUTH;
Known issues:
- You still need to go through and mark Dividend transactions as such.
- Doesn’t handle Sells very well, especially when these are to cover fund fees
Related posts
EJinnovations, run by an college friend of mine and one of the few people in the CS program I highly respected, has released a new piece of software to help the Chef in all of us. The software dwarfs the competition with killer features like recipe slideshows, printing of shopping lists, and recipe sharing. They now offer a free-trial download so you can get to know the software in the kitchen and see how it works. I’d highly recommend you try it out.
Related posts
Part 1
Part 2:
I love my new MacBook.
Related posts
I’ve been Linux-only on the desktop for 4 years now. And now, I’m considering adding Windows back to my daily life. Linux provides an excellent environment to do many of the things I do:
- web - Web Browse
- remote administration - Use a terminal
- services - Run servers
- video - Transcode, edit, convert, and Backup DVD’s
- music - Listen to music
A few things Linux hasn’t done well and why I’m considering adding a second OS to my desk here (alongside Linux):
- Money Management - GNUCash is the closest thing here, but doesn’t hold a candle to the financial institution integration MS Money and Quicken can offer
- audible.com - my audible.com content forces me to boot into Windows every few months to add new audio books to my iPod mini
- Music - I’ve made limited use and I’d like to make more use of services like Rhapsody.com, Napster.com, or Yahoo Music to have a wider variety of music to listen to.
There are a few ancillary things that don’t necessitate daily Windows usage, but I do need them occasionally:
- Harmony Remote - make my Harmony remote do new things
- Some multimedia stuff, CNN Video - most of this is going to Flash anyway
Wow, that’s a pretty short list. I had in my head that there were more things I wanted from Windows. Maybe I’ll suck it up and work with GNUCash!
On that note, recently solved things that used to suck about Linux on the desktop:
- Flash 9 - Like it or not, Linux is all about choice, now you have the option of running Flash 9 on Linux.
- DVD Backups: This has gotten easier and easier on Windows; I just tried an amazing piece of Linux software called Thoggen which backs up DVD’s to my hard-drive-based media server with a surprisingly few number of clicks.
- Music Management - Rhythmbox and the new player Banshee have made music management and playback much more manageable on Linux. Keep up the great work!
- Network Manager - the network manager makes wireless/wired connection management a cinch. I highly recommend it!
Related posts
