How to generate a Quicken report

"Gary" wrote

I consolidated my various accounts into one broker last year. Since doing so, I have noticed some irregularities in some of my investments ... there have been unexplained decreases in value since the transfers. So I want to generate a report that shows the net worth each asset for each year to hopefully understand why these changes occurred.

Quicken Premier 2017 is my current tool. Is there a report showing the net worth of each asset at the end of each year ignoring the fact that that asset might have been housed in different brokers in different years?

--------------------------------------------------------

Reports > Investing > Portfolio Value & Cost Basis

You can customize that report to choose which securities appear, and to select a time interval (Yearly, is one of the choices).

Thank you, John. This is a report I have frequently used, but in another context. It didn't dawn on me that it woud work for this. All I have to do now is edit the output, removing the cost basis colums, because I cannot see the discontinuities in net worth year to year wih cost basis reported as every other column.

Again, thank you. I'll do it today.

"Gary" wrote

Thank you, John. This is a report I have frequently used, but in another context. It didn't dawn on me that it woud work for this. All I have to do now is edit the output, removing the cost basis colums, because I cannot see the discontinuities in net worth year to year wih cost basis reported as every other column.

---------------------------------------------------------

You should be able to export the report to Excel and remove the Cost Basis column there.

I Interpreted your original request as wanting to see just one report row for each security, and the Portfolio vs Cost Basis report is the only report I know that would do that with the other criteria you specified.

But the Net Worth report might also be of some help. Even though the Net Worth report will group by account, it can show the value of individual securities (in each account) at intervals of your choosing.

Reports > Net Worth and Balances > Net Worth _ Customize to "Hide Graph". _ Customize to display the desired "Interval". _ Customize to include only the pertinent investment accounts and securities. _ On the Display tab of the Customize dialog, put a check mark in "Account Detail" (this will display the individual securities in each account).

Thanks again. But in the case of the Net Worth report, because (as you note) securities are split by account, it is harder to see the discontinuities. But no problem, your first solution was perfect.