Schedule D Report Totals

jl747
jl747 SuperUser ✭✭✭✭✭
edited March 24 in Reports (Windows)

Shouldn't the Schedule D Capital Gains/Loss report Totals be the same?
It is deducting the Loss twice.

How do I fix this within Quicken if possible or is it a bug?

Sale of some Mutual Funds

Thanks for any suggestion.

Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

Tagged:

Answers

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭

    Check your transaction list. Maybe the loss was recorded twice, once when the security was sold and again as a distribution.

    QWin Premier subscription
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭

    What version of Quicken? My old R48.8 does not include the _RlzdGain line under Cap Gain Distributions. Don't know why you are seeing that line there. Appears to me your OVERALL TOTAL should be the $13,915.48 value and the Cap Gain Distribution total value should be the $15,636.28.

  • jl747
    jl747 SuperUser ✭✭✭✭✭
    edited February 19

    @Jim_Harman

    Single transaction.

    @q_lurker

    My Quicken version R54.16

    Would using Specific Lots make this happen. (Original sale)

    Because I just sold the balance and I am seeing this also in this years report.

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭

    Would using Specific Lots make this happen. (Original sale)

    Shouldn’t, as far as I know.

    Would fall into the bug category (seems to me) if anyone else can confirm it.

  • jl747
    jl747 SuperUser ✭✭✭✭✭

    @q_lurker

    I agree.
    Lets see if anyone else can confirm this problem.

    Thanks

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭

    One thing you could try would be to delete and re-enter the transaction.

    QWin Premier subscription
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭

    And for troubleshooting you could also use FIFO to see if that is what is different.

    I did look at mine and it doesn't have this problem, but I'm using FIFO.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • Ps56k2
    Ps56k2 SuperUser ✭✭✭✭✭

    weird - I'm not even showing the Realized Gain line item - and there are stocks & mutual funds - buy/sell -

    QWin - R54.16 - Win10

  • jl747
    jl747 SuperUser ✭✭✭✭✭

    Well tried re-entering them as FIFO and no change.

    Tax Planner shows Cap Gains/Loss total of $13,915.48.

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • Chris_QPW
    Chris_QPW Member ✭✭✭✭

    Then I would try Validate & Repair and doing Ctrl+Z in the account.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • jl747
    jl747 SuperUser ✭✭✭✭✭

    @Chris_QPW

    Tried Validate, Super Validate and Ctrl+Z no change.

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭

    Access your category list (Ctrl-Shift-C) and include hidden categories. For the _RlzdGain category, what is the associated tax line? It should be blank.

  • jl747
    jl747 SuperUser ✭✭✭✭✭
    edited February 19

    @q_lurker

    Shows Schedule D.

    Can not be edited. Merge and Hide only option.

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • Chris_QPW
    Chris_QPW Member ✭✭✭✭

    Hold Ctrl+Shift and right click on the category → Edit. Mine is like what @q_lurker suggested.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • jl747
    jl747 SuperUser ✭✭✭✭✭

    @Chris_QPW

    Thanks that worked.
    Did not know that you could do that.

    Learned something new.

    Thanks to all.

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • mshiggins
    mshiggins SuperUser ✭✭✭✭✭

    Curious, how did _RlzdGain category get a tax line associated?


    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • jl747
    jl747 SuperUser ✭✭✭✭✭

    @mshiggins

    If you are asking me I have no idea.

    Quicken Windows Business & Personal (Subscription) - Using the latest version -Windows 10 Pro

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭

    Curious, how did _RlzdGain category get a tax line associated?

    Not pointing a finger @jl747 but I believe some users have (inappropriately) forced that assignment in order to have some reports or planner actions to come out the way they want.

This discussion has been closed.