[GNC] Import from Quicken to GnuCash not Working

[Ernie Wakamatsu]

First, apologies if I repeat anything old here.

Secondly, apologies again for not taking notes when I jumped ship from Quicken (Reckon) to GC last year.  I encountered the same issues as well when GC would terminate a QIF import without any apparent error message.  To overcome the situation, I did the following hack.


  1.
 Imported by accounts. This made deciphering QIF commands easier
  2.
If an import failed, I investigated the QIF commands.  If memory doesn't fail me, there were some commands which were not complete or formatted differently (sorry I didn't keep notes) than the documented QIF commands or expected by GC
  3.
I also had to setup my investment securities and things first, before I imported investment accounts

That is it in a nutshell.  As you can tell, I hacked my way through, but glad I made the switch.

Hope this helps,


________________________________
From: gnucash-user <gnucash-user-bounces+etwakaoz=gmail.com at gnucash.org> on behalf of Kalpesh Patel <kalpesh.patel at usa.net>
Sent: 24 September 2024 01:51
To: 'Keld Sorensen' <keldsorensen at gmail.com>; 'Joseph Keithley' <joeyiii57 at gmail.com>
Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>; 'Ken Farley' <farleykj at gmail.com>
Subject: Re: [GNC] Import from Quicken to GnuCash not Working

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:
>
>
>


_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.