[GNC] Import from Quicken to GnuCash not Working

[Kalpesh Patel]

Once you have gone through below mentioned reply, you might want to review my prior posts on it at https://www.mail-archive.com/gnucash-user@gnucash.org/msg40455.html which is likely to provide good pointers for migration.


-----Original Message-----
From: Keld Sorensen <keldsorensen at gmail.com> 
Sent: Monday, September 23, 2024 9:39 AM
To: Joseph Keithley <joeyiii57 at gmail.com>
Cc: Tom R <tom.route36 at gmail.com>; gnucash-user at gnucash.org; Ken Farley <farleykj at gmail.com>
Subject: Re: [GNC] Import from Quicken to GnuCash not Working

Obviously, Quicken will do what they can to avoid customers switching away from their software!

While a technically correct Quicken file is a good starting point for an import into GnuCash, it is worth remembering that Quicken uses "single entry".
This means that even a technically good file may hide all kinds of problems that will rear their ugly heads in the double entry method.

Even the best of Quicken files is likely to have many issues from this and other sources, which will require careful editing after an import.

These issues beget the question of whether it is worth the effort to import a Quicken file.
Prior to importing from Quicken, it is worth the users time to better understand double entry by reading up on all the help material. This will also make the "edit" session easier after the import.

Starting "from scratch" with a GnuCash file has many advantages.
One such advantage is the consistent use of double entry to minimize risk of accounting errors in the future.



On Mon, Sep 23, 2024 at 4:01 AM Joseph Keithley <joeyiii57 at gmail.com> wrote:

> You could try checking the integrity of your Quicken file first by 
> running one of the "Validate and Repair" options in the "File" menu 
> under "File Operations".  Sometimes parts of the qdf file gets corrupted and the repair
> procedure may point you to various issues within your data.    I broke my
> qdf file into individual accounts by year before I imported them (30+ 
> years and roughly 100 different accounts).  That was the only way I 
> could get gnucash to import my complete data without crashing.  
> Unfortunately it was a few years back and I don't exactly remember 
> what import settings and options I chose.
>
> The only help I can offer is that you can import one year at a time 
> and then save the file to create a backup file.  Then import the next 
> year and save the file as a new backup file.  Keep up the process 
> until one of the imports crashes.  At least then you can narrow down 
> what year of data is causing the issue and you will have a backup up 
> file of all the prior imports.  Since the qif file is a simple text file you can open the "bad"
> qif file in notepad and look through the file for errors.  You can 
> also skip that "bad" file and continue the process with the remaining 
> files just to get as much imported as possible.
>
> On Mon, Sep 23, 2024 at 4:15 AM Tom R <tom.route36 at gmail.com> wrote:
>
>
>