Quicken to GnuCash: Importing Quicken Accounts

If you read my background post on moving from Quicken to GnuCash, you'll know that Quicken was the last Windows App I depended on. And believe me, being 100% Linux feels great! To celebrate we'll begin a series of hands-on posts using GnuCash as a Linux Replacement for Quicken beginning with transferring our Quicken accounts to GnuCash.

Exporting from Quicken

We will be exporting our Quicken accounts individually as QIF files.

In the following window we'll select the account and what we want to export. As you can see on my QIF Export dialog window, I exported Transactions and the Account Category List only.

I viewed moving from Quicken to GnuCash as an opportunity to make a fresh start. If you've read any of my Linux Mint Upgrade posts, you  probably know I approach upgrades the same way. Think about it. Many of us have been using Quicken for almost 20 years! Wow! And if you're like me you may have accounts storing many years of transactions, so if you're interested in making your own fresh start, here's a tip.

Export the last year or two of transactions only. You can generate another QIF from Quicken as a backup if you ever need it.

The reason I'm suggesting exporting only recent transactions is because GnuCash will be zippier with a smaller XML database to manage, as any data handling application would be. Loading GnuCash will be particularly faster with a smaller database. I originally imported an account containing 13 years of transactions, then I started again and re-imported the account with only 2 years of transactions. GnuCash spin-up was noticeably faster. GnuCash will easily handle as many years as you feed it, but all I'm saying is that as a general rule, smaller is always better for application databases.

Creating GnuCash Accounts

Importing into GnuCash is just as easy as exporting from Quicken.

Select the file and GnuCash does the rest.

You can load multiple accounts during the same import session. Very cool.

You'll walk through a few additional import screens depending on the type of account and options selected, but each screen is easily understood even by non-CPAs like me.

The final result in GnuCash will look something like this.

 

Posted December 21, 2013 09:33 PM EST

More Like This Post