Dealing with a large QIF file

[joe at the-harrington-house.com]

This is also my plan. I'm working on a cross reference plan before I try 
to import anything. I have a Quicken data file with complete 
transactions for all bank accounts, credit cards, and loans since Jan 1 
1990. I want to get it all into gnucash so I can archive the entire 
quicken system, but still be able to research the entire period. I'm 
setting up chart of account pre-import to include many banks and cards 
with closed accounts. Probably 80% of the accounts in the file are 
closed.

Joe


On 2017-12-24 20:23, D via gnucash-user wrote:
> Gnucash creates the accounts because you and the transactions used
> those accounts. Personally, I prefer having all that "clutter," since
> it represents what happened. Accounting is supposed to track what
> happened, after all.
> 
> Two points: first, you can hide accounts in the Chart of Accounts,
> which would allow these accounts to exist without disturbing your
> daily accounting work. Second, you can delete accounts, if that really
> is your goal; when you delete an account with transactions in it, you
> get a chance to move them all to an account of your choosing. (I
> propose that this would be easier than editing the QIF, as another
> suggests).
> 
> Personally, I'd keep the transactions and hide the accounts.
> 
> David
> 
> On December 25, 2017, at 5:47 AM, 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
> 
>    -------- Original Message --------
>    Subject: Re: Dealing with a large QIF file
>    From: Colin Law
>    To: Cliff McDiarmid
>    CC: gnucash-user at gnucash.org
> 
>      You should be able to export one account at a time from Quicken, I
>      think. Then import them one at a time.
>      Colin
>      On 24 December 2017 at 19:02, Cliff McDiarmid wrote:
>      > Hi
>      >
>      > I'm importing a large QIF file(a current a/c)about 6000 entries.
>      > There are about a dozen other a/c's from Quicken, now closed,
>      > associated with this large file. When importing, Gnucash seems 
> to
>      > want to create these defunct a/c's to 'balance the books'. I
>      assume
>      > there isn't any way of avoiding this. The whole thing looks like
>      it
>      > will be horrendous. I've imported some small credit card a/c's
>      already
>      > with success, but they were not any of these other closed
>      accounts.
>      >
>      > Any advice please.
>      > thanks
>      >
>      > Cliff
>      > _______________________________________________
>      > gnucash-user mailing list
>      > gnucash-user at gnucash.org
>      > 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.