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