Duplicate Accounts created when using QIF Import

Derek Atkins warlord at MIT.EDU
Tue Jul 10 12:12:50 EDT 2007


What are the "account types" of the paired accounts?

-derek

Quoting Carl Moller <cmoller at ece.ualberta.ca>:

> Thanks for your reply.
>
> 1) currencies are set to "default" and the default is CAD
> 2) the entry gets duplicated exactly on the same tree, just with the 
> last name with a 2 appended.
> For example:
> ^
> D02/16/2005
> T-1200.00
> MCHEQUE CLEARING - DEBIT;
> ^
> is mapped to:
>  "Assets:Current Assets:Current Assets Carl: PCF Savings" in the 
> screen where it asks to map the memo to the account.
>
> Then, the following duplicate account gets created instead of going 
> into the correct one:
>  "Assets:Current Assets:Current Assets Carl: PCF Savings 2" again, 
> with the generic QIF import error.
>
> Any ideas?
> Thanks.
> Carl
> PS Can you help me to post this back to the group?
>
>
> Derek Atkins wrote:
>> Generally this duplication happens if:
>>
>> 1) your currencies dont match, or
>> 2) the account types dont match.
>>
>> For example, if the QIF thinks the account is an Income account
>> and you try to make it an Asset account, it'll create a second
>> tree.  Take a look at the two trees and compare the account types
>> and the currencies..
>>
>> -derek
>>
>> Carl Moller <cmoller at ece.ualberta.ca> writes:
>>
>>> I am using the QIF Import utility and coming up with some rather 
>>> strange behaviour.
>>> 1) I load the import function and select my qif file. It asks for 
>>> an account name. I select "Forward".
>>> 2) I don't load any other files (just testing here)
>>> 3) "Match QIF accounts with GnuCash accounts": I select my account 
>>> manually: Current Assets: Current Assets Carl: PCF Vacation
>>> 4) Match QIF categories with GnuCash accounts; there is nothing 
>>> here to select. so I go "Forward"
>>> 5) Match payees/ memos to GnuCash accounts: Here I select
>>>    Income:Interest Income Carl: Savings
>>>     for the "INTEREST" memo. and
>>>    Assets: Current Assets Carl: PCF Chequing
>>>      for the "TRANSFER IN" memo.
>>>    I hit "Forward" and "Apply"
>>>
>>> and here is where things get all messed up.
>>> Now I have a bunch of new accounts created:
>>>   -> Current Assets: Current Assets Carl:PCF Chequing 2 - with a 
>>> description: QIF Import: Name conflict with another account.
>>> -> Current Assets: Current Assets Carl:PCF Vacation 2 - with a 
>>> description: QIF Import: Name conflict with another account.
>>> -> Income: Carl's Income:Interest Income Carl: Savings Interest 2 - 
>>> with a description QIF Import: Name conflict with another account.
>>>
>>> So am I doing something wrong here or is this just a bug?
>>> Thanks for your help!
>>> Regards,
>>> Carl
>>>
>>>
>>> _______________________________________________
>>> 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.
>>>
>>>
>>
>
>
>



-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available



More information about the gnucash-user mailing list