Stock Split Creating Problems with Quicken Reports

This problem has been previously identified by other users, but it does not appear to have been addressed by Quicken. There is clearly a bug, related to how Quicken calculates the value of a security that previously underwent a stock split for certain reports. The value of the security will be correct in the actual account, the holdings report for the account, and the left-hand column will show the correct value for that account. However,
for certain reports such as Net Worth and Portfolio Value, Quicken calculates the wrong balance for certain stocks/mutual funds that previously underwent a stock/mutual fund split (such as Apple, e.g.) For whatever reason, when Quicken calculates the balance for the security for those reports, it ignores the stock split, and calculates the balance by the number of shares you would have had if the split never occurred.
Does anyone know if Quicken plans on addressing this bug?

Answers

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Check the price history of the security that split.  Frequently, the change in value gets posted to Q on the Ex-dividend date rather than the actual split date.  This is the responsibility of the Quote provider, not Q, and Q can't do anything about it.
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭✭
    Also, check the stock prices for the week or so immediately prior to the date the split occurred.  Again, the Quote provider has been known to download incorrect prices for that time period...prices that would have been if the stock had split a week or so earlier.  Again, this is a Quote provider issue, not a Quicken issue although it could be argued that Quicken should be working with the Quote provider to stop doing that.
    Another issue is that the brokerages determine what data is downloaded and what kind of transactions are downloaded.  Some will download the splits as Split transactions but others will download them as Delete and Add transactions while others will download them as Sell and Buy transactions.  Which transactions are downloaded can have a big impact on Cost Basis and on whether or not a split ends up being reported in Quicken as a taxable event.  Quicken has no control over that, as well.
    A good example of these 2 issues and the resolution can be found at https://community.quicken.com/discussion/comment/20194610#Comment_20194610.
    I have had 4 securities splits and 1 security reverse split over the last year or so.  Every one of them needed to be fixed in one way or another.  Each split scenario was unique so there is no simple uniform fix for it.  And none of the issues was because of Quicken.
    If you have a specific split issue that you want resolved, let us know and perhaps we or someone else will be able to assist you in that.
    (QW Premier Subscription: R39.23 on Windows 10)
This discussion has been closed.