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