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
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
