To your last question I would suggest doing those two in small chunks covering limited date intervals, perhaps a month at a time.
The reason I suggest that is because it is best to examine each transaction individually when matching to existing, as it is too easy to lose track of where you are at in a large file. David C On Mon, Dec 25, 2017 at 5:53 AM, Cliff McDiarmid <[email protected]> wrote: > > > Sent: Monday, December 25, 2017 at 3:23 AM > From: D <[email protected]> > To: "[email protected]" <[email protected]>, "Colin Law" > <[email protected]> > Cc: "Gnucash Users" <[email protected]> > Subject: Re: Dealing with a large QIF file > >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, [email protected] 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: [email protected] > 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 > > [email protected] > > [1]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. > _______________________________________________ > Thanks to all for all the advice. I'm seeing clearer now. I will > probably keep the accounts and hide them. > > One other thing, does anyone know, is it best to import all the > accounts in one go? I have about 32 of them, but only two have over > 6000 entries. > > Cliff > > References > > 1. https://lists.gnucash.org/mailman/listinfo/gnucash-user > _______________________________________________ > gnucash-user mailing list > [email protected] > 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 [email protected] 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.
