Bug 343256 - Import of Quicken QIF file ignores transaction type NReinvInt
Summary: Import of Quicken QIF file ignores transaction type NReinvInt
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.7.1
Platform: Microsoft Windows Microsoft Windows
: NOR wishlist
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-25 00:12 UTC by Jeff
Modified: 2019-08-30 15:54 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 4.8.1,5.0.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jeff 2015-01-25 00:12:37 UTC
Quicken provides a transaction "Action" of "Reinvest - Income Reinvested".  When exported to a QIF file, this becomes a transaction type "ReinvInt" for a QIF record containing the line "NReinvInt".  When importing these records into KMyMoney, no transactions are created. I don't see any errors. Here's an example QIF record that does not import:

D12/31/94
NReinvInt
YScudder Cash Investment Trust
I1
Q91.52
U91.52
T91.52
Msum of 1994
^



Reproducible: Always

Steps to Reproduce:
1. Export Quicken "Reinvest - Income Reinvested" transactions to QIF
2. Import the QIF into KMyMoney
3.

Actual Results:  
Transactions are not created.  I don't recall whether the import result dialog told me about any "could not create transaction" problems, but if so I did not notice it.

Expected Results:  
I would have expected A) the transactions to be imported, possibly converted to "Reinvest Dividend" since you don't have a "Reinvest Interest" activity, or B) something to catch my attention that records were not imported, or C) support the Reinvest Income transaction type.


I have these transactions in Money Market and Fixed Income funds.  Aren't those considered interest income for tax purposes?  I suppose I could have coded them wrong in Quicken, but it would be nice if KMyMoney supported the Quicken transaction types.
Comment 1 allan 2015-01-25 01:28:15 UTC
For the transaction to be treated as an investment, it should be prefixed "!Type:Invst", or it will appear as checking.
That aside, I'll need to look more closely as things seem amiss.  I tried editing it to intinc, but i think the decimal handling went wrong.  I'll try again when the sun's up.
Allan
Comment 2 allan 2015-02-07 11:48:36 UTC
(In reply to Jeff from comment #0)
> Quicken provides a transaction "Action" of "Reinvest - Income Reinvested". 
> When exported to a QIF file, this becomes a transaction type "ReinvInt" for
> a QIF record containing the line "NReinvInt".  When importing these records
> into KMyMoney, no transactions are created. I don't see any errors. Here's
> an example QIF record that does not import:
> 
> D12/31/94
> NReinvInt
> YScudder Cash Investment Trust
> I1
> Q91.52
> U91.52
> T91.52
> Msum of 1994
> ^

I'm afraid there is no support in KMM for  "Reinvest - Income Reinvested" transactions.  I've
therefore changed this to a wishlist item.

><snip>
> Expected Results:  
> I would have expected A) the transactions to be imported, possibly converted
> to "Reinvest Dividend" since you don't have a "Reinvest Interest" activity,
> or B) something to catch my attention that records were not imported, or C)
> support the Reinvest Income transaction type.

"Reinvest Dividend" is used with stocks/shares, where the income is used to purchase
additional stocks/shares.  I take it that in your case, the interest is added to the existing
money balance.

If so, it may be that Intinc is better suited.  I'll look into that.  No, that won't do as the 
income is distibuted, not reinvested.  Back to "Reinvest Dividend".

> I have these transactions in Money Market and Fixed Income funds.  Aren't
> those considered interest income for tax purposes?  I suppose I could have
> coded them wrong in Quicken, but it would be nice if KMyMoney supported the
> Quicken transaction types.

When you export these transactions from Quicken, do they show as in your example, with
 I1
Q91.52
U91.52
T91.52
or are those from your own editing?  More to the point, what parameters you get from
your Money Market or Fixed Income fund?
Comment 3 Jeff 2015-02-07 16:13:04 UTC
I cut that record right out of my Quicken exported QIF file. It is not edited.  But it is from 1994, so I don't know exactly what the fund reported to me.  I almost certainly entered that transaction by hand in 1994.  In later years in that account that income starts getting reported as reinvest dividend.  So I could easily have chosen the wrong type when I entered it.  But it is a type that Quicken supports and exports.
Comment 4 allan 2015-02-07 22:33:06 UTC
(In reply to Jeff from comment #3)
> I cut that record right out of my Quicken exported QIF file. It is not
> edited.  But it is from 1994, so I don't know exactly what the fund reported
> to me.  I almost certainly entered that transaction by hand in 1994.  In
> later years in that account that income starts getting reported as reinvest
> dividend.  So I could easily have chosen the wrong type when I entered it. 
> But it is a type that Quicken supports and exports.

What I was thinking about was whether or not those parameters were supplied to you
or whether you added them for the purposes of the import.  I was trying to find what
was generally needed for a reinvint, but if as you say they now get reported to you as
reinvdiv, which works -at least for you - then converting to reinvdiv may be an acceptable solution.
Comment 5 Thomas Baumgart 2017-01-07 21:14:39 UTC
Git commit c2900877f7cb1a8571ba4eeccf6b13e7b72583f8 by Thomas Baumgart.
Committed on 07/01/2017 at 21:07.
Pushed by tbaumgart into branch '4.8'.

Add support of ReinvInt transaction to QIF file import

This change adds support for the QIF 'reinvint' investment transaction.

This also needs to be added to the KF5 branch.
REVIEW: 129639
FIXED-IN: 4.8.1
CCMAIL: mark@azu.ca

M  +4    -1    kmymoney/converter/mymoneyqifreader.cpp

https://commits.kde.org/kmymoney/c2900877f7cb1a8571ba4eeccf6b13e7b72583f8