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: http://bit.ly/CommunitySSO

Are there ANY reports for securities?

ellyenne
ellyenne Member ✭✭
I can get transactions in 1 account by doing a "find", but I have the same security across multiple accounts! I can't find a report specifically for securities Transactions.
In Q2007 there was a portfolio page which had details including transactions - across all accounts. I can't find that in Q2020.
In Q2020, if I do a transaction report with the investment categories, it shows the security name in the Payee column, BUT VERY FRUSTRATINGLY it won't let me choose a security as a payee in the customization screen. If I do a report by Payee, it won't let me choose securities as payees.
It's annoying that I had to pay so much for such limited software.

Best Answers

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Accepted Answer
    A report of all transactions for a security across different accounts is easy to create. Click on the Investments group in the left sidebar and make sure the Security/Payee and Account columns are visible; click on Transactions, and in the Search box, type the name of the security. Your register is now displaying all transactions for the security. You can narrow the date range if you want. The register can then be printed or exported to Excel.

    At this time, reports in the Report section deal mostly with banking transactions. For reports on investments, you create them in the investment registers or portfolios. You can't do everything investors want, but you can create a lot of reports with the filters. The biggest problem is that unlike regular reports, you can't save your parameters; you have to set them each time.
    Quicken Mac Subscription • Quicken user since 1993
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Accepted Answer
    @ellyenne  Yes, unfortunately, learning Quicken Mac is an exercise in piecing together guide information scattered in different places, many of which aren't easy to find. ;)

    If you haven't tried printing from the portfolio screen yet, you might be surprised to see it does come out formatted just like other reports. (You can print to Preview or a PDF just to experiment with what you can do without wasting paper.)

    I believe the developers will eventually add investment reports to the Report section of the program, because many reports already can be created in the Portfolio, so much of the programming is already done. It's just not intuitive that it's not under Reports, and it's annoying that you can't set up and save a particular report to re-use easily.
    Quicken Mac Subscription • Quicken user since 1993

Answers

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Accepted Answer
    A report of all transactions for a security across different accounts is easy to create. Click on the Investments group in the left sidebar and make sure the Security/Payee and Account columns are visible; click on Transactions, and in the Search box, type the name of the security. Your register is now displaying all transactions for the security. You can narrow the date range if you want. The register can then be printed or exported to Excel.

    At this time, reports in the Report section deal mostly with banking transactions. For reports on investments, you create them in the investment registers or portfolios. You can't do everything investors want, but you can create a lot of reports with the filters. The biggest problem is that unlike regular reports, you can't save your parameters; you have to set them each time.
    Quicken Mac Subscription • Quicken user since 1993
  • ellyenne
    ellyenne Member ✭✭
    Thank you so much! I couldn't find anything about this in the help or instructions! Who knew that the sidebar could group stuff? And the portfolio is so well hidden!
    Still not a report, but at least I have sort of an overview.
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Accepted Answer
    @ellyenne  Yes, unfortunately, learning Quicken Mac is an exercise in piecing together guide information scattered in different places, many of which aren't easy to find. ;)

    If you haven't tried printing from the portfolio screen yet, you might be surprised to see it does come out formatted just like other reports. (You can print to Preview or a PDF just to experiment with what you can do without wasting paper.)

    I believe the developers will eventually add investment reports to the Report section of the program, because many reports already can be created in the Portfolio, so much of the programming is already done. It's just not intuitive that it's not under Reports, and it's annoying that you can't set up and save a particular report to re-use easily.
    Quicken Mac Subscription • Quicken user since 1993
  • ellyenne
    ellyenne Member ✭✭
    And, if you print it, then it does give you totals, but not subtotals. So, not terribly useful. But thanks for showing me this.
  • ukari
    ukari Member ✭✭
    Um...sorry, Quicken has dropped the ball on this. MSFT Money circa 2000 used to be able to do this. Been waiting 20 years for this feature.
  • ellyenne
    ellyenne Member ✭✭
    I still use Q2007 at work - the reporting is so much better. I did a set of highly customized Tax reports for an individual, her vineyard, and 6 JVPs & LLCs in 2 hours.
    Using Q2015 in Windows, the reports for my simple single non-profit took 3 hours. And using Q2020, my personal reports took 5 hours. Tricking it into giving me the info I want is so difficult compared to Q2007.
    I'm wondering if I can export the data to the older program to do the reports.
Sign In or Register to comment.