[Kmymoney-devel] [kmymoney4] [Bug 332282] New: qif import with splits duplicates transactions

[Allan]

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 at kde.org
>            Reporter: chris at 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