Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Subtotal the number of shares in the Cap Gains Report

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
1 votes

New · Last Updated


  • NotACPA
    NotACPA SuperUser, Windows Beta Beta
    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: R32.12 on Windows 10)
Sign In or Register to comment.