portfolio value report by account *and* year???

Unknown

I am trying to get a report of portfolio holdings by account *AND* year. I can't seem to find a way to do that. Does anyone have any suggestions.

Basically I need to show end of year holdings (funds, stocks, FMV) for several years across all (or many) accounts. I can do it one year and one account at a time, but I have quite a few accounts. 

I would be happy for a workaround involved importing into excel and mangling that.

The  Portfolio Value and Basis report with a year as the interval is close to what I need, but it has no account info, it combines holdings from all accounts.

The Portfolio Value reports is also close. It lets one subtotal by Account, but it only does one date.


Quicken Premier 2018 R6.12
Windows 10

Bob_L

What about the account balances report with interval set to year?

J_Mike

Try the Net Worth Report.
In the Customize > Display  dialog. check Account detail
This report gives you the summary by account at yearly intervals.

Jim_Harman

For a report that shows holdings by account on a specific date (12/31/xx for example):
Go to Investing/Portfolio
At the top, click Customize to name the view and pick the columns, accounts, and securities you want to include
Group by accounts
Select the date
Set the column widths you want

If you want to see your tax lots as of that date, click on Options and de-select Show closed lots (showing closed lots is currently broken) and at the bottom click Expand all

To print, go to File/Print portfolio

You will have to do a separate report for each year, but at least you get all the accounts together.

Jim_Harman

JM said:

Try the Net Worth Report.
In the Customize > Display  dialog. check Account detail
This report gives you the summary by account at yearly intervals.

That's good if all you need is the value of each holding, not number of shares or other info. Also on the Advanced tab, make sure Include unrealized gains is checked

Unknown

Bob L said:

What about the account balances report with interval set to year?

Thanks but that doesn't include securities holdings. That is just what I want with all the holdings grouped under each account (like sub-categories in the spending/income reports).

Unknown

JM said:

Try the Net Worth Report.
In the Customize > Display  dialog. check Account detail
This report gives you the summary by account at yearly intervals.

Yes, I want share amounts also. However, this is better than nothing.

Thank  you for pointing out the account detail checkbox hiding in the options. I had not found that. I had found the port values and cost basis report, which is the same thing plus the cost basis (which I didn't need).

Unknown

Jim Harman said:

For a report that shows holdings by account on a specific date (12/31/xx for example):
Go to Investing/Portfolio
At the top, click Customize to name the view and pick the columns, accounts, and securities you want to include
Group by accounts
Select the date
Set the column widths you want

If you want to see your tax lots as of that date, click on Options and de-select Show closed lots (showing closed lots is currently broken) and at the bottom click Expand all

To print, go to File/Print portfolio

You will have to do a separate report for each year, but at least you get all the accounts together.

Thank you. Also a good suggestion. Very obscure and the export options are marginal (ancient). As you point out still not what I'm looking for.

Jim_Harman

Jim Harman said:

For a report that shows holdings by account on a specific date (12/31/xx for example):
Go to Investing/Portfolio
At the top, click Customize to name the view and pick the columns, accounts, and securities you want to include
Group by accounts
Select the date
Set the column widths you want

If you want to see your tax lots as of that date, click on Options and de-select Show closed lots (showing closed lots is currently broken) and at the bottom click Expand all

To print, go to File/Print portfolio

You will have to do a separate report for each year, but at least you get all the accounts together.

If you are exporting to Excel, I recommend the .PRN option. Save the file with an extension of CSV and you can open it directly in Excel.

You could do one export for each year then cut and paste to make a big text or Excel file with all the data.