How do I change the Net Worth report to include unrealized gains for a retirement account?

Unknown
Unknown Member
edited November 2018 in Investing (Windows)

Comments

  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    edited October 2018
  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited October 2018
    I'm confused.  When I run the Networth report, it shows the Market Value for my investment accounts.  Last time I checked, by definition, unrealized gain is the difference between Cost Basis and Market Value, which means that it is included in the Networth report, so why do you feel the need to "manually record the unrealized gain every quarter using the category _UnrlzdGain" ? 

    Wouldn't that overstate your networth?

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Unknown
    Unknown Member
    edited September 2018
  • Unknown
    Unknown Member
    edited September 2018
    splasher said:

    I'm confused.  When I run the Networth report, it shows the Market Value for my investment accounts.  Last time I checked, by definition, unrealized gain is the difference between Cost Basis and Market Value, which means that it is included in the Networth report, so why do you feel the need to "manually record the unrealized gain every quarter using the category _UnrlzdGain" ? 

    Wouldn't that overstate your networth?

    no, the account is used as a placeholder. No details It just has the statement balance.
  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited September 2018
    splasher said:

    I'm confused.  When I run the Networth report, it shows the Market Value for my investment accounts.  Last time I checked, by definition, unrealized gain is the difference between Cost Basis and Market Value, which means that it is included in the Networth report, so why do you feel the need to "manually record the unrealized gain every quarter using the category _UnrlzdGain" ? 

    Wouldn't that overstate your networth?

    So, you are not tracking the transactional data of the investment account in Quicken?

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    Maybe you could take a step back and explain what you want to track about this account besides the balance.



    Are you making deposits to the account or taking withdrawals?



    With this info, we can suggest ways to accomplish this short of ending all the actual holdings and transactions.
    QWin Premier subscription
  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    edited September 2018
  • Unknown
    Unknown Member
    edited September 2018
  • Unknown
    Unknown Member
    edited September 2018
    splasher said:

    I'm confused.  When I run the Networth report, it shows the Market Value for my investment accounts.  Last time I checked, by definition, unrealized gain is the difference between Cost Basis and Market Value, which means that it is included in the Networth report, so why do you feel the need to "manually record the unrealized gain every quarter using the category _UnrlzdGain" ? 

    Wouldn't that overstate your networth?

    Correct, see example in my response to Jim below,.
  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited September 2018
    splasher said:

    I'm confused.  When I run the Networth report, it shows the Market Value for my investment accounts.  Last time I checked, by definition, unrealized gain is the difference between Cost Basis and Market Value, which means that it is included in the Networth report, so why do you feel the need to "manually record the unrealized gain every quarter using the category _UnrlzdGain" ? 

    Wouldn't that overstate your networth?

    @Gary Rademan:  In your "response below", do you have some extra 0's on the last three lines.  I am hoping you will still have the ability ti edit that post if so.
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    QWin Premier subscription
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    QWin Premier subscription
  • volvogirl
    volvogirl Quicken Windows Other SuperUser ✭✭✭✭✭
    edited September 2018
    splasher said:

    I'm confused.  When I run the Networth report, it shows the Market Value for my investment accounts.  Last time I checked, by definition, unrealized gain is the difference between Cost Basis and Market Value, which means that it is included in the Networth report, so why do you feel the need to "manually record the unrealized gain every quarter using the category _UnrlzdGain" ? 

    Wouldn't that overstate your networth?

    No looks like he just put the comma in the wrong place on the first line. 100,000

    I'm staying on Quicken 2013 Premier for Windows.

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited September 2018
    QWin Premier subscription
  • Unknown
    Unknown Member
    edited September 2018
    Thanks Jim, you've been more than helpful. In a 401(k) I just care about the balance, so your suggestion Is even easier implement w/o having to worry about cost basis or for that matter interest. Not the solution I was expecting but I like it!
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    QWin Premier subscription
  • Unknown
    Unknown Member
    edited September 2018
This discussion has been closed.