Error in unrealized gains YTD reporting after transferring investments between Quicken accounts

Options
29 Year User
29 Year User Member ✭
edited December 2023 in Investing (Windows)

We changed investment firms in August of this year. The funds were "removed" and "added" from their respective Quicken accounts by downloaded "transaction updates". One firm removed the funds, and the other firm added the funds.

The cost basis for the funds under the old firm in Quicken did not transfer during this conversion, so we added the respective cost basis to each fund in the new firm Quicken account.

All of the old funds were subsequently sold in the new account and replaced with new funds.

The problem we are having is the funds we sold continue to show unrealized gains in the YTD Quicken transaction reports although we do not own these funds anymore.

We deleted the "removed" and "added" transactions and "transferred the shares" instead in Quicken from one account to the other and also ran the repair and validate file routine but still have the same issue.

Does anyone have a resolution to this problem?

I

Comments

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    Options

    So if you run, for example, an Income and Expense by Category report with "Include unrealized gains" selected and a period that runs through "today", then "click-through" the unrealized gains dollar amount on the report, you're seeing these old securities included on the report? Is that right? What Account is listed along side these old securities, the old Account or the new Account?

    If it's the old Account, you're sure that that Account is entirely empty? Does excluding the old Account from feeding information to the report make any difference? If it's the new Account then does a {Ctrl}-z in that Account, forcing a recalculation, do anything?

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Options

    Specifically, what “investment transaction reports”? In the basic Reports / Investing / Investment Transactions version, inclusion of unrealized gains is off (Advanced customization tab).

    Checking to include that selection produces a report that computes a new unrealized gain every day the price of a security changes. That pseudo-transaction would appear for days up until you sold off all the shares.

    If that is the report you are using, do you have a reason to be including the unrealized gains?

This discussion has been closed.

Categories