Quicken Classic Premier R61.17: Lifetime Overview Report Error

aks948a21

Reports->Net Worth & Balances ->Lifetime Overview Report Un-realized gain double click number does not match

When double clicking the un-realized gain for a particular year (2024 in this case) in the Lifetime Overview Report (Under Reports->Net Worth & Balances), the summary number of the details does not match the number in the main screen for the 2024 number. In the screenshots, the number is positive in the main report for 2024 un-realized gain while double-clicking 2024, the summary of the detail is a negative number.

I have reported the issue by submitting the sanitized file copy through the Help→Report a Problem…

NotACPA

There's something else going on here. Looking at your 2nd graphic, you have multiple securities shown with 0.0000 shares, yet they have unrealized gains.

How is that possible if you no longer own the securities? They should be either realized gain or loss and not appear in the graphic at all where you selected only "Unrealized"?

SO, have you tried re-calculating your investment accounts and/or validating your data file? Take a backup before attempting either option.

Also, in the 2nd graphic, have you tried manually summing the Unrealized column to see what it adds to?

aks948a21

Thanks for the suggestions. Let me address them..

I did not do any special selection in the second image. It is a double click of the data for un-realized gain number in 2024 from the first image. So, all the points you are raising regarding zero units are valid and I cannot explain [you raise a good point that I did not even consider].

yes, I had super validated the quicken file and rebuilt the investing lots a few weeks ago.

The sum of the individual lines in the second image adds up to the negative total in the summary in the second image.

Your points gave me an idea → I tried to validate the second image with the data from the Reports→Investing→Investing Income (and selected un-realized gains in the customize the report "Advanced tab" and 2024 as the year. The total showing up for the un-realized gain in this report is not exactly the same as the amount listed in the first image for 2024 un-realized gain - though at least they are both positive and within 6% of each other. Now when I go security by security un-realized gain for image 2 (on the lifetime overview report) to the detail from the investing income report, I notice the following:

a) The zero share units still have values in both the reports

b) The main difference causing the gap between the image 1 and image 2 un-realized total values for 2024 and also between image 2 and the investing income report is because of two stock options that I exercised in 2024. In the lifetime overview detail, those un-realized values show up way negative that throws off the sum in image 2.

So back to my original point, the sum of the detail of the un-realized gains in the lifetime overview report [shows up as negative in image 2] does not match the number in the summary in image 1. So, the exercise of the two stock options is causing some odd behavior in this report when you try to get the details behind the un-realized gains.

Jim_Harman

Do you have any option transactions or short sales? They sometimes cause reporting problems if they are not closed out properly.

aks948a21

Thanks @Jim_Harman. As I mention in my response to @NotACPA observations, I had multiple same-day exercise and sell transactions related to the two separate stock options.

To your point, I exited these two options completely [the account register shows zero units remaining] and there were no other transactions for stock options other than for those two. These positions were executed correctly since the Q tax reports in 2024 matched the 1099 that I received for those two options. And it is these two options that are causing the un-realized gain value in image 2 [ which is a double click of the unrealized 2024 gain value from image 1] to go way negative and not match the positive value from image 1.

So, the exercise of the two stock options is causing some odd behavior in this report when you try to double-click to get the details behind the un-realized gains.

q_lurker

I'll start by offering that Unrealized Gain has always been flaky in my opinion. Where I have seen it presented, the programming has taken it on a day by day calculation.

So in an effort to understand the calculation here, I dug deep into this Overview for one security. For this security, I bought in 2020, bought a little more in 2023, and sold early in 2024. Looking at the Unrealized Gain of the overview for each of 2020 through 2024, the security appeared in the Unrealized gain detail and the value per year met the right ma5,260.52th == Current year ending value less prior year ending value = that year's unrealized gain with an adjustment for the additional shares bought in 2023.

Up to 12/31/23, the holding had accumulated $5,260.52 of gain, all unrealized at that point spread inconsistently across the 4 years. Sum of the 4 years of annual unrealized gains = 12/31/23 value less the basis of the two lots.

In the first days of 2024 up to my point of sale, the security lost $86.81 in value at which point I sold the shares realizing a gain of $5,173.71.

When I look at the Overview quick-zoom for 2024 with both Realized Gain and Unrealized Gain tabulated, I see:

• Shares = 0 (right I sold all the shares)
• Realized Gain = $5,174 (right, and consistent with cap gains report)
• Unrealized Gain = ($5,261); a negative value

What the program did upon the sale was to decrease the Unrealized Gains by the amount of the Realized gains = $5,173.71. That decrease in combination with the YTD unrealized gain (a loss) of $86.81 led to the total unrealized gain (a loss) for 2024 for that security of $5,260.52. That brought the total accumulated unrealized gain from 2020 through 2024 to $0; as it should be. So even though I ended 2024 with zero shares, the overview shows a significant unrealized loss for that security. Counterintuitive at first glance, but logical as it should be if you dig deeper.

As a one line summary, when you sell a security the Realized gain value contributes as an opposite value in the Unrealized gain column.

@aks948a21 That does not directly explain why you were seeing a positive (black) value in one place and a negative (red) value in another, but it will perhaps give you some direction to look deeper into those two stock options you spotted. Adding the Realized Gain column to the Quick Zoom may help.

aks948a21

Thanks @q_lurker. Your analysis addresses @NotACPA's question of why there could be un-realized gains for a security with zero units in a particular year.

In the quickzoom (double-click of the 2024 un-realized gain value in the lifetime overview report), I also manually selected (check marked) the realized gains option as well. The realized gain sum in the quick zoom matched the 2024 realized gain number from the lifetime overview report. But, the un-realized gain number still stayed the same negative number in the quick zoom for 2024 while the un-realized gain number for 2024 in the lifetime overview report is positive.

Please note that my analysis (from my Feb 9 note above) with the Q investment income report with the un-realized gains in the customize the report "Advanced tab" checked handled the stock options correctly in terms of the un-realized gains for 2024.

So to sum, one would expect that the lifetime overview un-realized gain number (for the 2024 that I selected) would match the 2024 quickzoom un-realized gain number. On top of that, they do not even have the same sign. Looks like the lifetime overview report on the quickzoom is doing something odd with un-realized gains when it comes to the stock options.