How to generate a Quicken report

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?
--


Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
"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).
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
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.
On 2017-07-12 13:37:36 +0000, John Pollard said:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
"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).
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 2017-07-18 14:07:01 +0000, John Pollard said:

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.
--


Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.