Dealing with a large QIF file

Cliff McDiarmid cliffhanger at gardener.com
Tue Dec 26 05:23:04 EST 2017


        Sent: Monday, December 25, 2017 at 7:28 PM
   From: "John Ralls" <jralls at ceridwen.us>
   To: cliffhanger at gardener.com
   Cc: gnucash-user <gnucash-user at gnucash.org>
   Subject: Re: Dealing with a large QIF file
   > On Dec 24, 2017, at 4:58 PM, cliffhanger at gardener.com wrote:
   >
   > Thanks . Yes one can import one at a time but this cheque ac from
   Quicken is huge and has references to other card accounts as categories
   within it. These accounts don't exist anymore and gnucash is trying to
   create them as part of the import. This is something I'd like to avoid.
   Hope this makes sense. Cliff
   >
   >The simplest way would be to pick some recent date, perhaps the
   beginning of last year, set the account’s opening balance to whatever
   it was on that date, and import only the transactions after >that date.
   >You could also use a plain-text editor on the QIF file and use
   search-and-replace to convert all of the closed CC accounts to a single
   account, perhaps named “Old Credit Cards”.

   Thanks again for all the thoughts.   Me thinks this data transfer is
   going to take some time.

   regards

   Cliff


More information about the gnucash-user mailing list