QIF import duplicate question

Derek Atkins warlord at MIT.EDU
Thu Jan 25 14:08:59 EST 2007


FYI, I just tested this with 2.0 and when you load the two QIF files
separately (as two different imports) it properly suggests that the
second transaction is a duplicate match for the first.  So if you actually
mark is as a duplicate you wont get it twice.

-derek

Quoting "James A. de Haseth" <jdehaseth at snappydsl.net>:

> I am having a bit of trouble with duplicate entries in an import from
> QIF files.  In the old app, which was quasi double-book accounting, I
> could pay a credit card from my checking account, so the checking
> account may have a QIF entry:
>
> D01/01/2006
> N101
> Cx
> T-100.00
> PVISA
> LLiability:Credit Cards:VISA
>
> and an appropriate record is created in the checking account and a
> payment is created in the VISA account.
>
> On the other hand the VISA QIF has an entry:
>
> D01/01/2006
> NPayment
> Cx
> T100.00
> PVISA
> LAssets:Current Assets:Checking
>
> so, a record is created in the VISA and checking accounts.
>
> The first QIF entry creates 101 for the check number in both accounts,
> which makes no sense in the VISA register, and the second one creates
> Payment records in both accounts, which makes no sense in the Checking
> account.
>
> The duplicate record clear does nothing to fix this.  If I delete the
> bad record in the respective accounts (very tedious for umpteen accounts
> and 10 yrs of data!) the right records are not linked.  Only the
> original records in the primary account (101 in Checking and Payment in
> VISA) are reconciled.
>
> Clearly I'm missing something.  Is there a way out of this mess? I'd
> like to retain linkage between the records and avoid duplicates.
>
> (BTW I'm using GC 2.0.4, built on Fedora Core 5.)
>
> Many thanks,
>
> Jim
>
> _______________________________________________
> 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