Community Homepage
Discussions
Categories
Quicken for Mac
Quicken Lifehub
Quicken Mobile
Quicken on the Web
Quicken for Windows
Support
Quicken Classic
Quicken Simplifi
Getting Started
Community Training FAQs
Using and Improving the Community
Announcements & Alerts
Announcements
Alerts, Online Banking & Known Product Issues
Product Ideas
Connect and Engage
The Community Meetup
The Water Cooler
The Lounge
Beta
Home
Quicken Classic for Mac
Investing (Mac)
Investment account holdings
GCC
how can I create a report listing holdings and values in investment accounts on mac?
Find more posts tagged with
Accepted answers
MontanaKarl
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.
All comments
MontanaKarl
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.
jacobs
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.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Best Of
