Dealing with a large QIF file

John Ralls jralls at ceridwen.us
Mon Dec 25 14:28:16 EST 2017



> 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”.

Regards,
John Ralls



More information about the gnucash-user mailing list