How do I generate a capital gains report for my stock transactions (Q Mac)

Robert87 Member ✭✭
edited March 2020 in Investments (Mac)
Stock transaction report for buys and sell during a selected timeframe
19 votes

New · Last Updated

Best Answer


  • Robert87
    Robert87 Member ✭✭
    Thankyou for your reply my quicken for Mac does not show a clear all or a sell selection, are you on a Mac or windows thanks

    Used quicken for 30 years on Mac just switched over from quicken for Mac 2007
  • Robert87
    Robert87 Member ✭✭
    In the portfolio view on the New Mac Quicken there is no column that allows you to track dividends paid, like the old quicken 2007. As a result your total gain does not include cash dividends paid, which over the years can be quite substantial. New to this quicken, does anyone know of a work around. Called support but they were no help at all. Maybe just got the wrong person.
  • Quicken_Natalie
    Quicken_Natalie Moderator mod
    edited January 2020
    Hello @Robert87,

    Thank you for bringing this to the attention of the Community!

    I went ahead and turned this discussion into an Idea thread so that other users are able to vote on it. Our developer's review Idea threads to get an idea of what people would like Quicken to offer.

    Be sure to add your vote by clicking on the gray triangle right above the current vote count, located in the blue box at the beginning of this thread:
    Thank you,

    Quicken Natalie

  • rrbatson
    rrbatson Member
    I see no "Vote count" triangle.
  • John_M
    John_M Member ✭✭✭✭
    @rrbatso Go to the top of this post and click on the triangle there. I voted for this, so it now shows 1 rather than 0.
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    @Robert87  If you're talking about dividends paid in cash, then they show up in the Amount column, as they increase your account balance. If you're talking about reinvested dividends, turn on the Invest Amt column in your register. This shows the dollar value of transactions (such as reinvested dividends) which don't affect your account's cash balance. Is that what you're looking for?
    Quicken Mac Subscription • Quicken user since 1993
  • Robert87
    Robert87 Member ✭✭
    No I am looking for the posted gain or loss on an open or closed position to include all dividends paid along with capital gain or loss. You can then get a true indication. If xyz stock is up $1000 dollars but has also paid $300 in dividends .... your total return us $1300.
    I have used many previous versions of quicken for mac ending with QM2007s.
    The investment and reporting side of the old quicken is what I miss dearly.
  • km-nm
    km-nm Member ✭✭
    Unfortunately, the Tax Schedule report doesn't work for capital gains held in retirement accounts. So a separate Capital Gains report really would be useful.
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    @km-nm  Just curious: why do you care about the specific amount of capital gains in a retirement account? I understand wanting to see the overall performance of your investments, but I'm not sure why one would need to see capital gains specifically.
    Quicken Mac Subscription • Quicken user since 1993
  • J_Mike
    J_Mike SuperUser ✭✭✭✭✭
    km-nm said:
    Unfortunately, the Tax Schedule report doesn't work for capital gains held in retirement accounts. So a separate Capital Gains report really would be useful.
    Another place to see Capital Gains/Losses is in the Portfolio View of an account or account group. See screenshot. This works for Retirement Accounts.

    The Realized Gains view shows YTD gains.losses for the calendar year of the date specified. Example - to dee gains for 2019, set the Date of the display to 12/31/2019.

    QWin & QMac (Deluxe) Subscription
    Quicken user since 1991

  • Tom Tolles
    Tom Tolles Member ✭✭
    it seems silly that Quicken cannot give you the information requested by Robert87. You should be able to run a report, over any arbitrary time frame (assuming that the data exists in quicken) for a given investment (like a dividend paying stock) that shows starting value (or investment), cash flows and type during the time frame (such as dividends), and the ending value or sale price. The MS Excel function "XIRR" does a great job calculating the IRR of a series of Cashflows. Quicken should either do the same, or at least let you easily export a series of cash flows for given investment so that you do it yourself.
  • adsoft2015
    adsoft2015 Mac Beta Beta
    I agree that you can get to "some" of this information in the Tax Schedule, but it makes sense to create a set of these reports under the Investments category. I would add to this, that we should also be able to see COMMISSIONS when I run this report. I'd like to know who much I'm paying in commission fees over time. Since we track this information in Quicken it's only fair I should be able to report on it.
    Quicken user since 1992... Version 1!