Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Reinvested dividends showing up as dividend+purchase

Questions about updating prices or transactions in Fund Manager

Postby jc76fundman » Fri May 18, 2018 12:12 pm

When retrieving transactions from one particular financial institution, the retrieved transactions get logged in Fund Manager as an non reinvested dividend + subsequent purchase. I would prefer it get logged as a reinvested dividend.

I presume this is determined by the financial institution. Is there anything I can configure in Fund Manager to log it as a reinvested dividend?


Thanks

John

ps I am using:
Fund Manager 2014
Personal Version: 2014.13.8
Quote Module: 518
Transaction Module: 229
jc76fundman
 
Posts: 8
Joined: Sat Mar 24, 2018 12:07 pm

Postby Mark » Sun May 20, 2018 8:05 pm

Hi John,

There is an option in the current FM 2018 version in the transaction retrieve (Advanced Options...) dialog called "Record Matching Purchase/Distribution as Reinvestment" designed to handle this situation. I don't recall if that option was available in FM 2014, but you can look. If so, turn that on, and if the distribution is the same value and date as the purchase then FM will combine them into a single reinvestment instead of 2 separate distribution/purchase transactions.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jc76fundman » Fri Jun 01, 2018 9:52 am

I have upgraded to FM 2018 and retried downloading the transactions with ""Record Matching Purchase/Distribution as Reinvestment" enabled. The transactions are still being recorded as non reinvested dividend + purchase because my financial institution, in their infinite wisdom, has the date of the purchase two business days after the date of the dividend. So in one case, the distribution is on 4/30 and the buy is on 5/1. In another, the distribution is on 3/29 and the buy is on 4/2.
jc76fundman
 
Posts: 8
Joined: Sat Mar 24, 2018 12:07 pm

Postby Mark » Fri Jun 01, 2018 9:54 am

Hi jc76fundman,

Yes, that would prevent this feature from automatically recording them as a single reinvestment transaction. You could either manually change them, or leave them as separate distribution/buy transactions.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby jc76fundman » Fri Jun 01, 2018 11:40 am

Mark wrote:You could either manually change them,


Can you elaborate on this option? I see a "edit data" option when right clicking on a row on the "Preview Importing Transactions" dialog, but it appears to only open the Data Register which doesn't yet contain the transactions.

Is there an easy way to convert a purchase into a reinvested dividend or non reinvested dividend into a reinvested dividend? The only way that I know is to delete the entry in the Data Register and then readd the entry to the Data Register as a different data type. Is there an other options?

Thanks..
jc76fundman
 
Posts: 8
Joined: Sat Mar 24, 2018 12:07 pm

Postby Mark » Fri Jun 01, 2018 12:06 pm

Hi jc76fundman,

You'd have to do the manual entry after the transaction retrieval is complete. Use the Data Register. Note (or copy) the number of shares in the purchase and the purchase price. Delete the purchase transaction, and edit the distributed distribution transaction, and change it to "Reinvested", and then enter the shares/price, such that the total distribution value remains un-changed, and the shares were the number of shares from the deleted purchase. You should end up with no default cash transactions due to this distribution.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sspeed » Fri Nov 01, 2019 10:29 am

I'm having the same issue. I have the "Record Matching Purchase/Distribution as Reinvestment" option checked and all transactions are on the same date.

In my case it looks like Fidelity split out the distribution as Dividend received, Short-term cap gain and Long-term cap gain. Fund Manager then just takes all 3 and logs them as a Purchase.
sspeed
 
Posts: 13
Joined: Wed Oct 25, 2017 1:32 pm

Postby Mark » Fri Nov 01, 2019 2:09 pm

Hi sspeed,

For that option to work, the value/date of the distribution and purchase must match. So, if you have 3 different distributions, plus a single purchase summing those 3 distributions, that wouldn't be a match. It only works if you have a distribution for $X on date Y, plus a purchase for $X on date Y.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 13 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.
cron