Subtotal the number of shares in the Cap Gains Report

ChicagoGuy Member ✭✭✭
edited June 2021 in Investments (Windows)
It would be helpful if the number of shares column was subtotaled in the Cap Gains report. If I think there might be a discrepancy with a ST/LT for a security my broker is reporting, it helps to be certain we at least match on the # of shares in their report vs my Quicken report
2 votes

New · Last Updated


  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    Unless you direct the brokerage differently, they are probably using FIFO to pick which lots of the security to sell when you give a sell order.
    Unless you and the brokerage select the exact same shares to sell, there's almost always going to be a difference between what they show and what Q shows.
    Also, unless you've sold only 1 security, the sum of the shares sold is going to be a pretty meaningless figure.
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • keithjca
    keithjca Member
    I think having the number of shares per security would be helpful on a report.
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭✭
    edited May 2020
    I agree that having the option to subtotal by security (showing not just the cumulative shares, but also the cumulative cost basis, gross proceeds and gain/loss numbers) would be very helpful.  For people who manually enter their Sch D data into their tax returns (like I do) it is really helpful to have those totals so the securities purchase and sales dates can be entered as "Various" instead of needing to enter each and every transaction individually.  When reinvested dividends are involved, entering the individual lots involved in a securities sale can be quite onerous.
    @ChicagoGuy and @keithjca - If you support this suggested improvement, be sure to vote for it above (especially if you are the one who proposed it).  The more votes, the greater the likelihood that Quicken will make this change.
    (QW Premier Subscription: R47.15 on Windows 11)
  • Quicken Anja
    Quicken Anja Moderator mod

    Hello All,

    This idea seems to have fallen stagnant and due to the age of the request and lack of user votes/comments, will be archived within the next 7 business days.

    If you would like to see this idea kept alive and considered for possible future implementation in Quicken, be sure to 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

    -Quicken Anja
  • mshiggins
    mshiggins SuperUser ✭✭✭✭✭
    Having a subtotal of shares sold by short term vs. long term would be helpful. As it is now, I run the capital gains report and export it to excel so I can sum up the shares. Not having to take the extra steps every time I want to look at capital gains would be a time saver.
    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the  Quicken Windows FAQ list
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Jut to be clear about this Idea (as I understand it), the report currently provides for a subtotal by ST/LT or a subtotal by Security (among others.  The subtotal by Security currently totals Proceeds, Cost, and Gain/Loss, but does not total the number of shares.  The original 'idea' (apparently) asked for that share total.  

    Supplemental to that getting a secondary subtotal seems to be desirable - first by ST/LT and then within those groupings, by security with that secondary subtotal also showing total of shares (and presumably Proceeds, Cost, and Gain/Loss).  (It is not clear to me if that was part of the original idea or not.)  The 'idea' of a secondary subtotal in reports has been presented elsewhere and this is a good specific example of when that would be worthwhile.