Quicken Mac: Creating Category Summary Report for Individual Securities and Reinvested Dividends/Cap

mistertheplague Member ✭✭✭
edited December 2018 in Investing (Mac)
As has been noted in other threads, for whatever reason QM17 will not recognize the following transactions in a stock Category Summary report: reinvested dividends, LT/ST capital gains, or reinvested LT/ST capital gains. 

It will register Dividend transactions, but if reinvested dividends and/or reinvested CG transactions download into QM from your brokerage (*cough* Vanguard) as a single transaction, rather than as separate Dividend/CG and Buy transactions, the stock report will not pick them up.

However, I discovered by accident that a customized summary report saved from the stock report will register these transactions as expected (why, I have no idea). I outlined the procedure to do that in this thread: https://getsatisfaction.com/quickencommunity/topics/reinvest-dividends-not-showing-up-in-reports-qui...

In a nutshell, clicking on any of the linked amounts in the stock report's Other subtotal section brings up a sub-report, in which you can re-enter your inputs and have the sub-report report properly. Still following? Just replicate what I did in the above thread.

But, that still leaves the following problem: how to run a report that isolates transactions from one or more, but not all, securities in an account.

For example, maybe I want to run a report that shows how much income our bond funds have produced this year in one of our taxable brokerage accounts (I mean who wouldn't, right?)

The accidental workaround outlined above still won't get you there. It's all of your securities or none. So I banged away at a solution for a few hours until I came up with a workaround to the workaround. It's inelegant, naturally, but it works. 

First, in the brokerage account register I arranged all transactions by Security/Payee. Then I multiple-selected all transactions for an individual security, right-clicked, and added the security's ticker symbol as a Tag. I did this for all securities in the account.

This procedure took 1/10 the time it's taken me to write this up (which may not be saying much, now that I think about it). Point is, it's fast.

Once you're finished, you should see something like this in the Tag field when you double-click a transaction:


Now when you go back to your customized summary report saved from the accidental workaround, you can select the various tags for your securities and the report will subtotal the transactions first by category, then by security symbol:


If you want to isolate transactions for one or more (but not all) securities -- like those bond funds, for instance -- deselect the tags for the securities you don't want in the report, and Bob's your uncle:



  • RickO
    RickO SuperUser, Mac Beta Beta
    edited April 2017

    Nice workaround to the workaround! Thanks for the thorough explanation. Hopefully they'll get the basic issue resolved in a future update.

    V4.5 is being released slowly now and has some reporting changes. Perhaps when you get it, you can test this functional area against the new reporting changes and see if it's improved.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • mistertheplague
    mistertheplague Member ✭✭✭
    edited April 2017
    Yeah I noticed some mention of report updates in the new release notes. I'll definitely test this area in the new release and (excuse the pun) report back.
  • Unknown
    Unknown Member
    edited December 2018
    Quicken said they would fix this bug on the latest version in Sept. I have been on the chat line for 2 hours with them today. They did not fix it. 
  • Unknown
    Unknown Member
    edited September 2017
    I am on Mac Version 4.6.6.  Reinvested dividends in one transaction do not show up.  Frustrating!
  • Unknown
    Unknown Member
    edited December 2018
    I have talked to them for over a year. They keep saying it will be in the next version. The latest version is out and it is not there. After 2 hours on the phone they said wait until the Quicken for Windows 2018 comes out in late October and buy it and use crossover or parallel . Quicken for windows has it working.  They said it will probably never be available on Quicken for Mac. I was able to do a sub report to show reinvested dividends. Very poor customer services. They would not refund my $$$ or discount the Windows version. 
  • Stephen Fisher
    Stephen Fisher Member ✭✭✭
    I've been working on this and the report results are confusing. I added Tags to all stocks in my US funds portfolio - for me this took a while because I have USstocks, CAN Pref stocks in US funds, CAN stocks in US funds, US bonds,  CAN bonds in US funds that all have to be distinguished for Canadian tax reporting.  

    Here's what happens: Under New Reports/Tags, I search on USstocks (for example) The screen now shows me USstocks that can be checked off.  I chose Select All.  And that group of USstocks tagged securities is correctly checked.  When I run the report ALL securities of all tags show up even tho I have carefully selected the option of Include Only Transactions with selected tags. 

    Let me say, Mr. the plague that I think you are a dedicated genius and I don't mean this as to have any negative implication for you.  You figured out a workaround for a shameful flaw in QM's reporting capabilities that I certainly was unable to solve.  But QM continues to undermine our attempts to get things done. [My 1986 DOS version of Quicken could report on Securities which I selected.]  Quicken should be guilt-ridden, conscious-stricken and repentant for this pathetic version of its Reporting features. :)
This discussion has been closed.