How to create transaction report for securities

wpott1991

I want to create a report that includes all dividends paid to me last year and subtotal by security. How do I do that? There is no securities tab in the transaction report in my 2020 Mac version. Securities aren’t listed among payees (obviously I suppose). The only thing I’ve been able to do is sort the transactions list in my brokerage account, but I’d still have to add each securities transactions by hand. There must be a better way.

jlgg

I believe you can use the legacy Tax Report for this. If you want to include accounts that are not taxable, you can select them in the customization window. The report will subtotal all dividends received by security. You can also customize the report to exclude any other taxable events leaving just dividend income. The report is printable.

I hope the developers realize the unique features of this particular legacy report and don't remove it in the future in favor of newer reports that are not as powerful.

wpott1991

Your export suggestion was exactly what I ended up doing. It took several more steps than the reports I did in Q2007 (I finally gave up and moved to Q2020 a few months ago). However, there are a few advantages given the greater flexibility of Excel. Also, using the command-shift-T shortcut after selecting the cell just below the end of the amounts column instantly totals the amounts. So, it’ll do for now.
Still, why in the world Q2020 for Mac doesn’t have a securities tab in its reports template totally escapes me.
Your thoughts?

[Deleted User]

It would be nice to have.
In particular a report that shows total  Cost/ total Value and all dividends paid since security was bought

wpott1991

Thanks very much for the history lesson. I never even tried Quicken Essentials. Q2007 actually fit my needs pretty well all these years. (I’ve used Quicken since 1991 myself.) But corruption increasingly crept into my ever larger file (since 2002) and now have no choice. Here’s hoping new Quicken finally catches with Q2007. Thanks again.

jlgg

I believe you can use the legacy Tax Report for this. If you want to include accounts that are not taxable, you can select them in the customization window. The report will subtotal all dividends received by security. You can also customize the report to exclude any other taxable events leaving just dividend income. The report is printable.

I hope the developers realize the unique features of this particular legacy report and don't remove it in the future in favor of newer reports that are not as powerful.

wpott1991

Worked like a charm. Thanks!