basic math BUG in investment reports in quicken doesn't add up when using transaction exchange rate

questionsforever
questionsforever Quicken Canada Subscription Member ✭✭✭✭

How can this software produce reports where even the numbers don't add properly?

The middle stock, the 2nd column is the price per share of $54.318 using transaction exchange rate. And the last line is the 'balance. which shows 2460.64. This obviously should not be the transaction exchange rate as it is the actual price per share on the date of the report.

But 43 x 54.318 = 2335.67! It isn't even showing the proper addition of the balance. How is this possible? If i uncheck transaction exchange rate it shows 2335 (but the cost basis in the other columns is then incorrect).

Clearly, just some basic reasoning would suggest that cost basis should be correct with transaction exchange rate checked AND the final balance should be simply the US dollar cost basis * today's exchange rate * # of shares. This is a BUG.

Comments

  • Arctic Hare
    Arctic Hare Quicken Windows Subscription SuperUser ✭✭✭✭

    @questionsforever the moderators who monitor this community will - occasionally - note and report major issues, you should not rely on this forum as a bug reporting mechanism. The Community is intended to be a user-to-user forum, not a communications channel to the Quicken development team… which is who needs to receive your report!

    I recommend you use the "Report a Problem" feature that is built into Quicken (Help —> Report a Problem) to report this issue. It may also be helpful to contact phone or chat support and draw this issue to their attention. For better or worse, posting about the bug here is unlikely to get the information to where it needs to go. Posting here is useful to draw the attention of other users, but not very useful in terms of initiating any kind of resolution. Hope this helps!

  • Quicken Kristina
    Quicken Kristina Quicken Windows Subscription Moderator mod

    Hello @questionsforever,

    To assist with this issue, please provide more information. Which investment reports are you seeing this in? If you are customizing the report, what customization options are you selecting?

    I look forward to your response!

    Quicken Kristina

    Make sure to sign up for the email digest to see a round up of your top posts.

  • questionsforever
    questionsforever Quicken Canada Subscription Member ✭✭✭✭
    edited December 9

    It is the Portfolio Value report.

    I am selecting CAD currency (the original securities are in USD).

    I am selecting transaction exchange rate.

    I am selecting the specific investment account.

    And that's it, the rest is the defaults.

    Essentially the final 'balance' column seems to be modified by the transaction exchange rate tick box, however, this is not correct because the BALANCE represents the value of the security using the exchange rate on the date of the report (fair market value). ONLY the cost basis column should calculate the cost basis using the transaction exchange rate. All the other columns should still continue to use the report date exchange rate. This is intuitively correct since only the cost basis differs based on the purchase date of each lot held.

    Even stranger, I have two accounts. When I run this report on ONE investment account in CAD, the balance column does NOT CHANGE when using transaction exchange rate. Which is correct behaviour. The OTHER investment account in CAD, the one above, does change the balance column when this box is ticked or unticked. This is totally impossible to fathom as clearly this balance column should not be changing.

  • Quicken Kristina
    Quicken Kristina Quicken Windows Subscription Moderator mod
    edited December 13

    Thank you for your reply,

    With that additional information, I was able to replicate the issue and have forwarded it to the proper channels to be further investigated. Thank you also for helping us investigate the issue by sending us a problem report with the log files attached. While you will not receive a response through this submission, these reports will help our teams in further investigating the issue. The more problem reports we receive, the better.

    We apologize for any inconvenience!

    Thank you.  

    (CTP-11726)

    Quicken Kristina

    Make sure to sign up for the email digest to see a round up of your top posts.