https://bugs.kde.org/show_bug.cgi?id=332282
--- Comment #2 from allan <agande...@gmail.com> --- Please see comments interspersed below. On 18/03/14 13:25, Chris J. Kiick wrote: > https://bugs.kde.org/show_bug.cgi?id=332282 > > Bug ID: 332282 > Summary: qif import with splits duplicates transactions > Classification: Unclassified > Product: kmymoney4 > Version: 4.6.3 > Platform: Ubuntu Packages > OS: Linux > Status: UNCONFIRMED > Severity: normal > Priority: NOR > Component: general > Assignee: kmymoney-devel@kde.org > Reporter: ch...@kiicks.net > > Importing a QIF file with a split transaction that transfers to another > account > results in duplicate transactions in the target account. The transacations > are > not matched, even though they have the same date, amount, account, etc. This > results in balances being way off when importing data from quicken. > > > > Reproducible: Always > > Steps to Reproduce: > 1. file:import:QIf...: select Qdatabug.QIF, default profile, "Other > application", OK. > 2. Go to Acct2 register, note duplicate transaction, and that balance is > double > what it should be. > 3. > Actual Results: > Two transactions for $1850 in Acct2, which are obviously the same. > > Expected Results: > The transactions should have been matched. > > Qdatabug.QIF: > !Option:AutoSwitch > !Account > NAcct1 > TBank > DFirst account > $0.00 > ^ > NAcct2 > TBank > Dsecond account > $12,502.01 > ^ Not sue what is the purpose of the '$' line. The '$' is supposed to refer to a split or transfer entry. > !Clear:AutoSwitch > !Option:AutoSwitch > !Account > NAcct1 > DFirst account > TBank > ^ > !Type:Bank > D7/25' 3 > U15,460.62 > T15,460.62 > CX > POpening Balance > L[Acct1] > ^ > D8/ 8' 3 > U-1,850.00 > T-1,850.00 > N102 > PSomebody > L[Acct2] > ^ > !Account > NAcct2 > Dsecond account > TBank > ^ > !Type:Bank > D8/ 8' 3 > U1,900.00 > T1,900.00 > CX > PSomebody > L[Acct1] > S[Acct1] > $1,850.00 > SAnother:category > Erefund > $50.00 > ^ The L[Acct1] line indicates a transfer to account Acct1. Similarly for the S[Acct1] in a split. These are the cause of your duplication. They signify a transfer to Acct1, which is what happens with your file. The two transactions will not match in KMyMoney because they occur in different accounts, and also because they are both import transactions. KMyMoney will match only a manual entry against an imported one, in the same account. This is one of the weaknesses in the QIF format, in that there is no unique id for each transaction, so no sure-fire way to match. The problem of entries for the same transaction in a transfer operation is a general problem. See http://en.wikipedia.org/wiki/Quicken_Interchange_Format for a suggestion on how to avoid this problem. However, even that does not produce what is needed. I think you need to keep the Acct2 entry referring to the transfer and delete the Acct1 entry with the check number, adding the check number afterwards. Allan -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ KMyMoney-devel mailing list KMyMoney-devel@kde.org https://mail.kde.org/mailman/listinfo/kmymoney-devel
