Improper number of shares showing

Unknown
Unknown Member
edited May 2022 in Investing (Mac)
Premier 2018 Version 5.3.2
Certain investment transactions are entered completely but the share balance is not accurately reflected.  Any thoughts on how to update the holdings?

Comments

  • Unknown
    Unknown Member
    edited December 2017
    In one case, I know exactly where it went awry.  It simply doesn't add the last transaction.  The transaction is entered properly, but the shares don't factor in the total.  It happens on a number of other accounts, but the one I used as an example was the most obvious and glaring.
  • Unknown
    Unknown Member
    edited April 2018

    In one case, I know exactly where it went awry.  It simply doesn't add the last transaction.  The transaction is entered properly, but the shares don't factor in the total.  It happens on a number of other accounts, but the one I used as an example was the most obvious and glaring.

    Unfortunately the same thing.
  • Unknown
    Unknown Member
    edited December 2017

    In one case, I know exactly where it went awry.  It simply doesn't add the last transaction.  The transaction is entered properly, but the shares don't factor in the total.  It happens on a number of other accounts, but the one I used as an example was the most obvious and glaring.

    I followed your original instructions with more attention to the detail.  It seems as though the share balance had gotten out of whack along the way.  Must have incorrectly pulled some transaction when I converted from the Windows version.  Because it was qualified money, I simply added the shares back in to avoid having to search for the offending transactions.

    Thank you for your help.  I should have looked more closely from the beginning!
  • andyf0
    andyf0 Member ✭✭✭
    edited December 2017
    Version 5.4.3

    I have the same problem. The placeholder amount is showing an incorrect number of shares added which causes the total number of shares to be incorrect.

    This is one fund of a few that are affected. I chose it because there's only a couple of transactions on it.

    12/20/17 Reinvest Dividend Dodge & Cox 4.593 shares @ 45.765295
    10/23/17 Sell Dodge & Cox 4.481 shares @ 46.880161
    10/12/17 Add Shares Dodge & Cox +240.244 shares (to reach 240.244 on 12/21/17) - Placeholder

    The "to reach 240.244"  on 12/21 is the correct total number of shares currently, but if you subtract the "Sell" and add the "Reinvest" you get 240.356 which is shown as the total in the portfolio view. This causes the total account value to be incorrect.
  • andyf0
    andyf0 Member ✭✭✭
    edited December 2017
    andyf0 said:

    Version 5.4.3

    I have the same problem. The placeholder amount is showing an incorrect number of shares added which causes the total number of shares to be incorrect.

    This is one fund of a few that are affected. I chose it because there's only a couple of transactions on it.

    12/20/17 Reinvest Dividend Dodge & Cox 4.593 shares @ 45.765295
    10/23/17 Sell Dodge & Cox 4.481 shares @ 46.880161
    10/12/17 Add Shares Dodge & Cox +240.244 shares (to reach 240.244 on 12/21/17) - Placeholder

    The "to reach 240.244"  on 12/21 is the correct total number of shares currently, but if you subtract the "Sell" and add the "Reinvest" you get 240.356 which is shown as the total in the portfolio view. This causes the total account value to be incorrect.

    Deleting the placeholder and re-connecting just left me with .112 shares.

    Here's the math.

    As of today my brokerage reports total shares of 240.244 so the placeholder was adjusted to reflect this amount.

    But there was a sell of 4.481 shares and then a Reinvest Dividend of 4.593 shares.

    So (240.244 - 4.481 + 4.593) = 240.356 shares. This is what my total shares shows in Portfolio View. However, this is wrong, the true share total is 240.244 which leads me to believe the placeholder has been adjusted incorrectly to try and match todays balance.

    I believe that the amount of shares added in the placeholder along with all the transactions to date should match my total shares today. Somehow QC doesn't seem to do the math correctly.

    I have a few funds that are doing the same thing, but this has only been in the last few versions, it's been working fine for me since QC2015. It is only failing on funds that have downloaded transactions since the last few versions. Funds that are untouched are correct.
  • andyf0
    andyf0 Member ✭✭✭
    edited December 2017
    andyf0 said:

    Version 5.4.3

    I have the same problem. The placeholder amount is showing an incorrect number of shares added which causes the total number of shares to be incorrect.

    This is one fund of a few that are affected. I chose it because there's only a couple of transactions on it.

    12/20/17 Reinvest Dividend Dodge & Cox 4.593 shares @ 45.765295
    10/23/17 Sell Dodge & Cox 4.481 shares @ 46.880161
    10/12/17 Add Shares Dodge & Cox +240.244 shares (to reach 240.244 on 12/21/17) - Placeholder

    The "to reach 240.244"  on 12/21 is the correct total number of shares currently, but if you subtract the "Sell" and add the "Reinvest" you get 240.356 which is shown as the total in the portfolio view. This causes the total account value to be incorrect.

    Ah! I deleted the automatic placeholder and created my own placeholder manually. This worked and theoretically should continue to work. I don't understand why the automatic placeholder "floats" depending on the current balance assuming the downloads are accurate.
  • andyf0
    andyf0 Member ✭✭✭
    edited December 2017
    andyf0 said:

    Version 5.4.3

    I have the same problem. The placeholder amount is showing an incorrect number of shares added which causes the total number of shares to be incorrect.

    This is one fund of a few that are affected. I chose it because there's only a couple of transactions on it.

    12/20/17 Reinvest Dividend Dodge & Cox 4.593 shares @ 45.765295
    10/23/17 Sell Dodge & Cox 4.481 shares @ 46.880161
    10/12/17 Add Shares Dodge & Cox +240.244 shares (to reach 240.244 on 12/21/17) - Placeholder

    The "to reach 240.244"  on 12/21 is the correct total number of shares currently, but if you subtract the "Sell" and add the "Reinvest" you get 240.356 which is shown as the total in the portfolio view. This causes the total account value to be incorrect.

    Thanks! I'll have to keep monitoring and adjusting as needed.
This discussion has been closed.