Replacing Quicken

Since OS X Lion does not include the old Rosetta technology, it will not run Quicken 2007. So, I have been trying out replacements before I upgrade. Here is what I need:

  • I have Quicken data going back to 1993. A replacement needs to be able to import it all, the more intact the better.
  • I download transactions electronically from a number of financial institutions. I need to be able to continue doing this at least as well as Quicken does it.
  • I need fairly advanced investment management. Though I no longer invest in stocks, I have in the past, and want those trades preserved. I also need the ability to manage investments of instruments that are not traded on exchanges (so, for example, don’t have official symbols or price feeds and so on).
  • Obviously, it needs to be Lion combatible
  • Good-looking reporting is useful, but not required. Again, at least as good as Quicken is needed (though that is not saying much).
  • I want a decent, Mac-like user experience.
  • I do not care about syncing to mobile devices or the like.

One warning: the reviews below will be a bit stream-of-consciousness, as I write down observations as they occur to me.


If you are planning on doing a similar migration, make sure you export your Quicken data before you upgrade to Lion. You won’t be able to launch Quicken once you upgrade. Every app I tested can import a .qif file, so export on using File→Export→To QIF….

And, of course, back up everything, yadda, yadda, yadda.


There turn out to be a surprisingly large number of financial apps that run on the Mac, but I will only be testing some of them. Most I am rejecting because they seem small time, unsupported, weakly-ported and/or missing features. There are, however, some popular, realistic choices that I am passing on:

  • Quicken Essentials for Mac ($50) is the most recent version of Quicken for Mac; however, it is ridiculously underpowered compared to its predecessor, Quicken 2007. If it would do the job, I would have converted to it months ago.
  • Some suggest just running Quicken for Windows under an emulator, such as Parallels. Since financial applications are not particularly CPU intensive, this should work fine. While I do own a version of Parallels, I pretty much never run it. I’m not really interested in starting. (BTW, if you are a Parallels user, you need version 6 to run under Lion.)
  • A number of online options, such as, are available; however, I have no interest in uploading my financial life into the cloud, encrypted or otherwise. (Note: this also why I’m not including screen shots of my testing in this post.)
  • MoneyWell ($50) is an interesting application that I actually own (part of one bundle or another). It is a great (and great looking) little money management application, and does support electronic downloads, but doesn’t have investment features. If you don’t care about that, it may work for you.

This brings us to the serious contenders, in the order I happened to investigate them…


iBank iconMaker: IGG Software
Version Tested: 4.2.4
Price: $60 (30-day free trial)
Technology: Mac-only (Cocoa)
iUseThis users: 650

The import process was fairly painless and seemed to work well. I had to change a few account categories in a dialog provided for the purpose (e.g. changing loan accounts from “Liability” to “Loan”).

All accounts are listed in panel on the side. Account groups are allowed, which I really needed as I’ve collected a lot of accounts over the years (probably 100+). The grouping worked fine, but the UI only allows you to select (and, therefore, move) one account at a time, so making the groups was tedious, though only necessary once. It doesn’t seem to have a concept of “inactive” accounts either, so I had to build an “Inactive” account group and throw them all in there. Not the end of the world.

While direct connection to financial institutions is supported, it failed with odd errors for many of my accounts. The forum for the software showed many with the same errors, but no solution that worked for me. Some of this, I suspect, is because most of my accounts use more than just username/password for security (e.g. extra “site image” pages, sites that send a confirmation code as a text page that you have to enter, even cryptographic keyfobs). User error may also play a part, as it looks like some sites require you to change settings on the destination web site (and, in some cases, pay a fee) to support direct connection.

So, I fell back to what I had to do with Quicken: login to the sites manually and download my transactions. I’m used to this, so don’t consider it a deal breaker (though direct download would be nice). Importing these transactions is actually a bit smoother than in Quicken.

As mentioned, some of my investments don’t have official price feeds, so the balance in those accounts initially showed up as zero. After some tinkering, I found it is possible to manually enter a price for these instruments, which is about as much as I can expect. Armed with a price, the balance became correct.

One drawback I notice is that investment accounts don’t seem to have a column containing a running total of shares, just value. That is an annoying omission, so much so that I wonder if I’m just missing some mechanism to display it.

Loan information was not transferred over, so I had to set that up by hand. The accounts were all there, just not linked together with proper payment information. Setting this up is straightforward and provides a good “pending transaction” ability to see when payments are due. I needed to make some of these transactions show up in the past, which took a couple of tries to get right, but nothing too severe.

No import is perfect, but it did seem that any non-ideal situation I ran into was easily corrected, usually by the action I naturally tried first, which is a good UI in action.

Conclusion: As the first of these applications I tried, iBank set a pretty high bar. I could easily see myself using it, and it will be the one to beat.

Liquid Ledger

Liquid Ledger iconMaker: Modeless Software
Version Tested: 2.3.3
Price: $40 (60-day free trial)
Technology: Mac-only (Cocoa)
iUseThis users: 11

The import of my 3MB .qif file took over three hours to complete (contrasted to less than a minute from all the other apps). It does seem to have imported correctly. Also, it automatically groups accounts into folders in its sidebar, very similarly to the way I had to do it manually in the others. You can still can only select one account at a time, though (this is particularly irritating here, because if you select a folder, it displays the combined transactions from all accounts in the folder, so you know the UI has the ability to display multiple accounts at once, but just doesn’t for no reason). No way to hide inactive accounts, either.

I generally hate toolbars in any application, but this one is particularly bad. Five buttons, one of which is a color picker. Really? The only thing remotely useful is the search field, but fortunately, it isn’t useful enough to force me to keep the toolbar visible. It does include an option to hide it, which I used almost immediately.

The Income & Expenses section is quite nice, sort of like smart folders showing transactions based on what Quicken calls Categories, rather than Accounts.

The software recommended that I save a SQL version of my data, as it would better handle my large number of transactions. Not only faster saving, but a much smaller file (~6MB vs. 36MB). Interesting.

Importing transactions from institutions is…not great. Unlike Quicken and iBank, there is no interface for matching what is being imported with the existing ledger. It is easy to re-import transactions, duplicating them, but not so easy to undo the duplication.

After a few minutes of looking, I don’t see any way to update security prices. I also don’t see any features for calculating/scheduling loan payments. That’s a big problem for me, as I don’t want to calculate principal vs. interest each time.

Investment features exist, but seem fairly sparse. It doesn’t have the concept of “Move Shares In” that Quicken does, for example, though it allows entry of transactions in a sort of “warning” mode, allowing the destination to remain empty (as it would in an MS transaction).

It can handle split transactions (where one transaction might be distributed among a number of accounts), but does so using a semi-modal popup dialog. Functional, but…meh. Modal dialogs are generally bad these days.

Pretty much nothing in the application is right-clickable, in spite of a number of menus being sensitive to what is selected. That’s sort of old-school Mac, from the dumb one-button mouse days. Apparently, I don’t work that way anymore.

Conclusion: If this were the only choice, it would be tolerable, but some of the others are more feature-rich. The lack of loan support and more advanced investment features is a problem for me.


Money iconMaker: Jumsoft
Version Tested: 4.0.1
Price: $19, until end of July (free 15-day trial)
Technology: Mac-only (Cocoa)
iUseThis users: 236

I got this one as part of the most recent Mac SuperBundle (and you can, too, if you hurry). It is possible that this application is the best day-to-day money management software in existence. I wouldn’t know, though, because it screwed up my import pretty badly.

After taking about 10 minutes to import, the end result was a totally blank window. After quitting and relaunching, my information showed up. Sort of. The main overview has a section called “Top Categories”. For some reason, every entry in this section was the abbreviation of a state, most of which I’ve never lived in. Looks to me like the import might have put the wrong column in the Category field.

A bigger problem is that some of my investment account transactions are missing share quantities. That is really bad.

Performance was really, really bad. I got the distinct impression that Money was not prepared for the number of transactions I have. When resizing, for example, the window would not redraw for several seconds.

Conclusion: The problems seen right away with this application meant I rejected it before really getting to the heart of it. It simply failed at preserving my old data, so no point in continuing.


iFinance iconMaker: Synium Software
Version Tested: 3.2.8
Price: $30 (30-day free trial)
Technology: Mac-only (Cocoa)
iUseThis users: 99

I’ve liked other applications from Synium (particularly MacFamilyTree), so was anxious to look at this one.

Getting started was not quite as clean as some of the other applications. Most put an option to import from Quicken right in your face the first time you launch them. While iFinance also puts an “options for starting” window up, and some of of these options do involve importing, an option to import from a .qif file isn’t on the window. I assumed that I needed to create a blank database, then choose some sort of Import menu option, which turned out to be the case. Oddly, the only progress during the import was the spinning beach ball. No progress bar or anything like that.

Unfortunately, after the import, I’m also missing information from some of my investment accounts. All of Quicken’s “Move Share” transactions seem to have just been dropped on the floor and are missing. The vast majority of transactions are missing descriptions.

The interface is also garish and annoying. As an example, each transaction has a brightly colored amount (white text in a red or green aqua-like button) and has a colored circle for “Category”. This circle is a representation of the account(s) on the other end of the transaction, but there is no text in the list. Just the colored circle. The system has taken my hundred or so accounts and assigned them unique shades, but the color alone doesn’t help me. The detail view shows the actual name of the account (and their colors), but, uh…no.

A quick tour of some of the reports shows them to be more graphic intensive than some of the other applications, but clearly not built for the large number of accounts I have, which make the legend dominate the screen.

Conclusion: Like Money, this one fails at my first basic requirement for data integrity, so doesn’t merit further looking.

Money Dance

Money Dance iconMaker: The Infinite Kind
Version Tested: 2011
Price: $50 (free trial allowing unlimited import, but only 100 hand-entered transactions)
Technology: Java-based
iUseThis users: 215

This is a Java application and, though it does a much better job of being Mac-like than many Java apps, it still shows. The buttons are in non-standard places, the widgets are not standard, background colors are a bit off. Redraws of windows are a bit clunky. Some dialog fields don’t respond to cut and paste commands. And so on. While much of that is cosmetic, it causes me to cringe enough that it is a distraction, so counts as a strike against Money Dance.

The import was quick, but my net worth is off. Looking through the accounts, I see some have additional transactions and some have transactions that are missing. Some moves between a credit line and various investment accounts might be getting double counted for some reason. I should say that these import mistakes are less severe than those made by Money and iFinance. I get the impression that I could correct them with an hour or so of tinkering. Looks like the mistakes are more in the area of account linkages, rather than data actually missing. I’d bet that people without transactions as esoteric as mine would have a better outcome.

The import grouped my accounts in a mostly reasonable way (and, you can remove unused accounts from the sidebar without deleting them, unlike in these other applications), but you cannot group accounts in arbitrary folders.

Split transactions use a modal popup technique even uglier than Liquid Ledger’s. Investment accounts do provide a running share balance, though.

Setting up direct connect to financial institutions was pretty much the same story as iBank, suggesting that the problems may be on the bank end. Importing files manually works, but doesn’t have any “matching” process before confirming transactions, so creating duplicates seems pretty easy.

Conclusion: Money Dance seems powerful, moreso than most of the other candidates, if a little clunky. The import mistakes are troublesome, but not necessarily fatal. For every feature it has that I actually use, though, iBank seems to do the same thing in a cleaner fashion.

SEE Finance

EDIT: I didn’t hear about SEE Finance until someone mentioned it in the comments. See what I have to say about it there.


My top two choices are iBank and Money Dance, in that order, with Liquid Ledger running a distant third. A longer test period and more experience may force me to change my mind, but I am going to use iBank for now. Some things about it still bug me, but it has more to like than the others. Reading comments about the various apps on forums and such suggest that iBank has, historically, had stability/corruption problems, causing many to bail on it in favor of Money Dance. The dates on these comments, though, suggest that this hasn’t happened lately. I’m about to find out.

Let me know how your own switchover goes.

A reminder to European executives

To European executives:

When traveling in the United States, please remember one thing: porn is not real. No matter how much films from San Fernando Valley may lead you to believe otherwise, the maid does not magically want to have sex with you, no matter how naked you are. The pizza delivery guy is just there to deliver pizza. There is no sex in the champagne room.

As a European executive, you are likely rich, powerful and, well…European. Most American cities have no shortage of sluts and boy toys who may be happy to have some meaningless sex with you, but you need to go out and find them. They will not be delivered to your door.

At least, not for free.

Forced medicine

A woman in Massachusetts was just found guilty of attempted murder for withholding cancer medication from her autistic son, who has since died. Go read that article for the specifics. No, really. Go ahead. I’ll wait.

OK, so, there are a number of question raised by this case, some of them moral/ethical questions, some of them legal. But, before the sound and fury about this case (which I predict will only last about three days in the mainstream press) abates, I want to concentrate on this question: instead of withholding the drugs for her own reasons, suppose the woman withheld the drugs because she could not afford them. Would she then still have been found guilty of attempted murder?

I suspect a lot of people would say no, reasoning that a jury would find that, even if she wanted to provide the drugs, she couldn’t get them anyway, thus absolving her of the responsibility.

Now, suppose you agree with that. What this verdict then means is this: the state can now force you, under penalty of imprisonment, to consume medication if you can afford it. It is no longer your choice to consume life-saving medication, or to make that choice for your children. If you can afford it, you must purchase and use it, or go to jail. At least, this is true when (as is typically the case) your children are assumed not to be able to make legally binding choices for themselves.

Or, maybe it doesn’t mean that. Instead, maybe it means that the state now considers there to be a legal difference between choosing to consume life-saving medication for yourself vs. making that choice for your children. But if it isn’t the parent’s choice, whose choice is it? The only other possibilities are the child or the state. If it is the child’s choice, then the child has just been given a legal mandate to control the spending of others for his own benefit (“Ma, the doc gave me a prescription for a new Audi. Pony up!”), and if the others don’t like it, they can go to jail. If it is the state, then the state is now making medical and moral choices for its citizens. Neither of these two alternatives is all that palatable.

Another thing bothers me about this case. The state charges that Kristen LaBrie caused the death of the child by withholding the meds. The child is dead because, as the state would have you believe, his medicine was withheld. Then why is the state charging her with attempted murder? If you believe the state, then isn’t it full-on successful 100% genuine murder?

It’s likely that the attempted murder charge was used because it has a much lower burden of proof for the state, and the prosecutor didn’t think he could make a full murder charge. If that is the reason, then it suggests that this whole case is some sort of political wet dream agenda from the D.A.’s office. “Sorry Ms LaBrie. Nevermind that your son was autistic, had leukemia and died, you need to go to prison so that I can prove something to someone, somewhere.” The whole thing sickens me.

I may have more to say about this later. Right now, my neighborhood watch officer is telling me it’s time to take my soma.

The Last Shuttle

When the space shuttle Atlantis returns from its final mission later this year, the space shuttle program will officially be over. A group of documentarians from the San Diego Aerospace Museum are trying to capture the last days of the program in a film called The Last Shuttle, using a number of different technologies. They have started a Kickstarter project to raise some of the money to do this. They are a bit far from their goal, but still have a couple days left. I’ve kicked some money their way. Please do the same.

Rebuilding a RAID

A while ago, I showed how to build a 1TB backup RAID in ten minutes. But what happens when a drive in this RAID goes bad? This is easy enough to deal with, but contains a few landmines along the way that can get you if you are not careful.

A few weeks back, I upgraded my backup RAID to use quiet, cool, 2TB disks. After working for a few days, one of the disks started throwing SMART alerts, which (in this case) signaled imminent failure. Soon enough, the drive became non-responsive. (This often happens with commodity components like drives or RAM: either they fail right away, or not at all.) As the drive was still under warranty, I got a replacement drive and swapped it into the RAID, and now all is well.

But, back up a bit. What do you actually see when this happens, and what do you need to do? Well, first of all, remember that the R in RAID stands for “redundant”. The whole point is that if one disk fails, the data remains safe on the remaining disk. At first glance, the RAID looks totally fine. If you run Disk Utility, though, it will tell you that the RAID is “degraded”, like so:

Missing disk

Note that if you have a problem, one of the disks might say “Damaged” or some other status instead of “Missing”, but the idea is the same. So, first land mine: you might be tempted to remove this damaged disk from the RAID set in Disk Utility. Do not do this. Instead, you want to get this disk out of the machine entirely, leaving the software part of the RAID alone for the moment.

Which brings us to the second land mine: how do you know which disk to remove? In the list of disks on the left of the Disk Utility screen, if you click on one of the disks, it should tell you what bay contains the drive at the bottom of the screen. If you still can’t tell, take a look at the RAID information for something like “disk1s2” on the damaged drive. Then run System Profiler. In the “Hardware: Serial-ATA” section, you should be able to find the matching “BSD Name” for the drive and figure out which bay the disk is in.

Once you know what bay to empty, turn off Time Machine, then shut down the machine and remove the drive (follow the link mentioned at the start of this post for how to do this). I should point out that, if you need to, once the disk is removed, you can restart the machine and use it for a while. The RAID will still be degraded, but will function with one disk if needed. (I ran in this state for a while while waiting for my replacement drive.)

Once the disk is removed, you have a couple of choices: you can try to repair the disk, or you can replace it. If you want to try repairing the disk, you should do so using a totally different machine. The reason for this is that once a disk has RAID information put on it, there is a chance that it will try to sync with other RAID disks as soon as it is put on a system with them, which could blow the information away.

One tool that helps immensely in messing with drives and moving them around is something like the NewerTech Voyager Q. This is a box that has several different kinds of disk interface on the back (USB, FireWire, eSATA) and a slot on top into which a SATA disk can be plugged, without messing with screws and mounting brackets and such. It’s totally worth the $70.

Anyway, however you do it, mount the drive on a different box and try to repair it. In my case, this didn’t work, and I had to replace the drive. If you must do so, it is crucial that you get a drive with the same capacity as the good drive in the RAID. Ideally, you want the same exact model of drive.

So, now that you have either a repaired or new disk, you hit the most important land mine: if you try to install this disk into your RAID, and it has some residual RAID information on it, it may hose your data. So, you need to reformat the drive before you add it in. Again, this is best done on a totally different machine. Being paranoid, I reformatted mine to FAT, then reformatted again to HFS, doing a single pass zeroing out of the data.

Now, install the drive into the main machine and startup. Once you are up and running, launch Disk Utility again. Get to the RAID section. As far as the software knows, the old drive it knew about is still missing, so you’ll see something much like the screenshot above.

If you click on the “Missing” part of the RAID in the UI, the buttons at the bottom should change to “Delete” and “Demote”. You should avoid the first one entirely, and only use “Demote”. This will pull the bad disk out of the RAID, but leave the original disk as part of the RAID.

You can now also drag the new disk into the RAID list:

Dragging in new disk

Once both of these are done, click the parent item in the RAID list. One of the buttons on the bottom will change to “Rebuild”. Hit this button. You will get a confirmation dialog:


Click “Rebuild”, and then watch the progress:


Rebuilding takes hours, so read a book or something. Once it is done, the RAID should be just how you left it, but in full working order. Turn Time Machine back on and away you go.

How to trim a budget

Matthew Yglesias summarizes Stan Collender’s thoughts on cutting budgets like so:

…the key thing for any fiscal adjustment plan to say on the cut side isn’t really how much money you’re cutting, it’s what things do you want the government to stop doing. Once you name the things, you can total up the savings. Then you can either say you’ve cut enough, or else you can go back and name more things.

So with that in mind, here is what I’d like my government to stop doing, in no particular order. I want the government to stop…

The Cato Institute has very detailed thoughts about what they want the government to stop. The New York Times also offers and interactive method for playing with what stopping certain things will save. What do you want the government to stop doing?

(Hat tip to MN for pointing me to the original article.)