nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Robert87

Stock transaction report for buys and sell during a selected timeframe

Find more posts tagged with

Reviewed

Status: Reviewed

Comments

J_Mike

Capital Gains are included in QMac's Tax Schedule Report - along with all other tax related info.

If desired you can customize the Tax Schedule Report to show only Capital Gains.
In the customize dialog under Categories - select Clear All.
Next scroll down and check the box for category Investments:Sell.
Set the desired time interval.
You can give the customized report a name (e.g., Capital Gains) and save the report for future reference.

Robert87

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

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

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:

Image: https://us.v-cdn.net/6031128/uploads/editor/90/h4t0hg3lmrge.png

Thank you,

Quicken Natalie

rrbatson

I see no "Vote count" triangle.

John_M

@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

@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?

Robert87

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

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

@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.

J_Mike

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.

Image: https://us.v-cdn.net/6031128/uploads/editor/i0/cu1ih785zu1z.png

Tom Tolles

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

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 Jasmine

Hello All,

The Community Support team regularly reviews long-standing posts and Ideas for relevancy and current interest. This Idea seems to have stalled and we would like to gauge the current interest in this request.

If you would like to see this idea implemented, please add your vote and a comment explaining how this idea would be beneficial for you. More information, including steps to vote and how to submit your own Ideas for future product features/improvements, is also available here.

Thank you,

Quicken Community Support Team

jacobs

I think a straightforward capital gains report should be a fundamental part of basic investment reports, none of which are offered yet in Quicken Mac. While it is possible to extract the information, it isn't easy or obvious how to configure. A Capital Gains report should exist in Quicken Mac.

jacobs

I'm just adding a note to this Idea post to clarify that this request has been partially implemented as of version 6.11 (December 2022). There is now a "Schedule D - Capital Gains and Losses" report to break out just capital gains from the complete Tax Schedule report. This is good!

Also requested above was the ability to see gains for retirement accounts, and this is easily do-able by clicking Edit > Accounts and selecting all or selected retirement accounts. Although capital gains in retirement accounts aren't taxable income, for anyone who wants to see it, it's available. This is good!

But…

There are several ways capital gains can be generated — gains/losses on sales of securities and capital gains paid by a security — and this report lists them separately. There is no bottom line total.
This report uses the "old" reports engine — the carry-over from the 2010-era Quicken Essentials for Mac — so it has such unwelcome features as totals and subtotals above data rather than below — which has been fixed in the "new" reports engine used for most Quicken Mac reports; columns can't be added or hidden; you can't click on a column heading to change the sort order… We need to see this (and the other tax reports) re-writtne using the "new" reports engine.
You can't narrow the report criteria to report on a single security (as requested above).
you can't see commissions on security sales (as requested above).