Dealing with a large QIF file

Cliff McDiarmid cliffhanger at gardener.com
Mon Dec 25 06:53:07 EST 2017



   Sent: Monday, December 25, 2017 at 3:23 AM
   From: D <sunfish62 at yahoo.com>
   To: "cliffhanger at gardener.com" <cliffhanger at gardener.com>, "Colin Law"
   <clanlaw at gmail.com>
   Cc: "Gnucash Users" <gnucash-user at gnucash.org>
   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, 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
   > [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


More information about the gnucash-user mailing list