retrieving reinvested dividends transactions

[oscarhobson]

When retrieving transactions from fidelity and mystreetscape, I'm getting reinvested dividends transactions that are not considered matching purchase/distribution as reinvestment, I think because of the way the data is supplied. I'm wondering if other users have encountered this situation and how they've dealt with it. The transactions come in as

Date Type Investment Name Shares Price Total
7/30/10 Buy fidelity mutual fund 5.318 15.760 83.81
7/30/10 Dist fidelity mutual fund <blank> <blank> 83.81

so I'm figuring Fund Manager does not consider them as matching because the number of shares and price are absent on the Dist transaction. The transactions look like the following on a csv file downloaded:

Trade Date,Action,Symbol,Security Description,Security Type,Quantity,Price ($),Commission ($),Fees ($),Accrued Interest ($),Amount ($),Settlement Date
07/30/2010, DIVIDEND RECEIVED, FNMIX, FIDELITY NEW MARKETS INCOME,Cash,,,,,,87.89,
07/30/2010, REINVESTMENT, FNMIX, FIDELITY NEW MARKETS INCOME,Cash,7.486,11.74,,,,-87.89,


Could this be changed so that they are considered "matching", or would this mess up other cases ? And/or alternately could there be some means in the preview window to "force" them to be considered a matching purchase/distribution ?


Thanks, Oscar Hobson

[Mark]

Hi Oscar,

Are you retrieving or importing that CSV file? The option to combine Purchase + Distribution into a Reinvestment is only available when retrieving or importing an OFX/QFX file.

If you are retrieving, make sure you have the option "Record Matching Purchase/Distribution as Reinvestment" checked.

If you are retrieving, and you have this option checked, and they aren't getting combined, please take a look at the transactions as retrieved. Do they show up in the same investment, with the same date/amount in Fund Manager? If so, and they aren't getting combined, you can send me your "ofxretr.txt" file in your user's Application Data \ Fund Manager folder, and I can take a closer look.

[oscarhobson]

Hi Mark,

I was doing a retrieve from Fidelity (though the same thing happens on my retrieves from mystreetscape), sorry if I confused the issue. Did have the option "Record Matching Purchase/Distribution as Reinvestment" checked. It shows in the preview pane as 2 transactions, one a buy and one a dist. They end up in Fund Manager as the same: a buy is recorded and a distribution is recorded. I will email you the ofxretr.txt file. Thanks for looking into this.

Oscar Hobson

[Mark]

Hi Oscar,

If it matches/combines them, it should show as a single Reinvestment in the Preview pane. I'll take a look at your file when you send it, and let you know what I find.

[tommcg]

Hi Mark, I have also encountered this several times. My ofxretr.txt file just contains five bytes that say "ERROR", but I import my .qfx file instead of retrieve it directly. My ofxmemtrandump.txt file looks like it contains some relevant records. Note the two transactions are not back-to-back. There is some unrelated interest income transaction between the two that I excluded below. Import OFX with "record matching purchase/dist as reinv" checked results in two separate transactions.

Code: Select all


16:     Account:   LPL.COM - xxxxxxxx
        Type:      Dividend
        CUSIP:     746888205
        Name:      PUTNAM GLOBAL (746888205)
        Symb:      PUTBX
        Date:      6/30/2010 (1)
        Memo:      PUTNAM GLOBAL UTILITIES FUND CLASS B   063010... AS OF 6-30
        Units:     0.000000 (0)
        Price:     0.000000 (0)
        Total:     347.880000 (1)
        Fees:      0.000000 (0)
        Numer:     0.000000 (0)
        Denom:     1.000000 (0)
        Cursym:
        BankType:  No

18:     Account:   LPL.COM - xxxxxxxx
        Type:      Buy
        CUSIP:     746888205
        Name:      PUTNAM GLOBAL (746888205)
        Symb:      PUTBX
        Date:      6/30/2010 (1)
        Memo:      PUTNAM GLOBAL UTILITIES FUND CLASS B
        Units:     34.858000 (1)
        Price:     9.979919 (1)
        Total:     -347.880000 (1)
        Fees:      0.000000 (0)
        Numer:     0.000000 (0)
        Denom:     1.000000 (0)
        Cursym:
        BankType:  No



Please let me know if you would like the raw QFX file for further inspection.

Thanks.

[Mark]

Hi tommcg,

Yes, if you could email me the raw QFX file that would be a big help. If I can reproduce the problem here, then I'm sure we can fix it.

[Mark]

Hello Oscar and tommcg,

I believe we've found the problem here. There was a bug when the buy was reported with a negative for the total, as in your example tommcg. This problem will be fixed for the 10.7 release. If either of you would like to test out a 10.7 pre-release, please drop us an e-mail.