Quicken for Mac
Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information:
Investment account holdings
how can I create a report listing holdings and values in investment accounts on mac?
Member, Windows Beta, Mac Beta
edited April 6
This report is, strangely, not available under "Reports" - but rather under the Portfolio view of your investment account.
Each investment account has a Portfolio and a Transactions tab at the top left. Select Portfolio. Then select the date (default today) that you want a list with values. In the dropdown below the value graph, towards the left, select "Portfolio Value". Finally, click on the small print icon below the value graph seen in this screenshot:
You will have a pop-up option to list the total for each security, or to list each individual basis lot in the report.
Unlike normal Report-reports, no live preview appears on your screen - instead, you get the Print dialog. To see a preview, rather than printing, go to the PDF button at the bottom left of that dialog and select Open in Preview.
Many of us hope that Quicken will move this report to the normal Reports workflow and behavior in a future update.
Quicken Windows and Mac subscription. Quicken user since 1990.
SuperUser, Mac Beta
At this time, oddly, you don't do it through the Reports section! Investment reports are generated from the Portfolio view.
Click on Investing (or Brokerage or Retirement) in the left sidebar.
Click on the Portfolio tab
Set the first filter to Portfolio Value
Set the second second filter to Group by Security or Group by Account, depending on what you want to see
The third filter lets you select which accounts to include (if different than what you clicked on in the left sidebar)
If you want the report as of a date other than today, such as the end of last month or last year, set the "as of" date in the upper right of the screen
Click on the columns icon if you want to adjust what columns appear in your report. Basics would be price ("Quote"), Shares, and Market Value. I typically want to see Cost Basis and Gain Loss, and there are various other options in the Columns dialog box.
Click on a column heading if you want the list in order other than alphabetically (such as by Market Value)
To print this as a report, click the Print icon. Generally you'll want the first Print option, which shows holdings without breaking down by lots, but there's an option for the latter if you need it.You can also click the Export button to export to a CSV file for further manipulation in a spreadsheet.
Changing the first filter between Portfolio Value, Performance, and Realized Gain gives you a significant variety of other ways to view your data; each have their own column options.
The biggest downside to the way this works is that if there are a few reports you want to generate routinely, there's no way to save the portfolio settings for several different configurations; you have to set up the filters each time. Once you're familiar with it, it's not hugely time-consuming, but I think most Quicken Mac users with investments look forward to a day when these cane be saved as reports without needing to configure them each time.
Quicken Mac Subscription • Quicken user since 1993
It looks like you're new here. If you want to get involved, click one of these buttons!
Alerts & Known Product Issues
Welcome to the Community!
Current Online Banking Issues
Before you Buy
Quicken for Windows
Quicken for Mac
Quicken on the Web