Mac 2018: Category Summary Report/Investments: category

Unknown

Mac 2018:  When I run a Category Summary Report, the  "Investments" categories required for transactions in brokerage accounts are not reported.  These  categories do appear in Tax Schedule reports, so I know they are registering. But why do "required" Categories NOT appear in Category Summary reports?

RickO

In the customize dialog, click NONE for Categories, Tags and Payees and see if they show up then.

Quicken Harold

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

David Barron

Thanks for replies.
Something very strange is happening with Category Summary Reports. I checked None for categories last night and it worked: only the Investment transactions came up in the Report. I was able to add other Categories to the report and save it.
Today, checking None brings up ALL Categories in the report, while only some of the Categories have been checked automatically in the Category list.  But NOW, if I check  Investments in the Category list, I get a correct report, which I could not get yesterday.
This obviously needs some work.
Tony

RickO

David Barron said:

Thanks for replies.
Something very strange is happening with Category Summary Reports. I checked None for categories last night and it worked: only the Investment transactions came up in the Report. I was able to add other Categories to the report and save it.
Today, checking None brings up ALL Categories in the report, while only some of the Categories have been checked automatically in the Category list.  But NOW, if I check  Investments in the Category list, I get a correct report, which I could not get yesterday.
This obviously needs some work.
Tony

You probably had some other filtering going on in the customization dialog the first time.

Clicking NONE will always get you everything: for Categories, Payees, Accounts, and especially for Tags. If you want just certain categories, always click NONE then checkmark the categories you want included.

Northbynortheast

Quicken Harold said:

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

I can't get the category report to show realized capital gains as income.  Everything else is there (salary, interest, dividends).   Like Tony, I see the gains in the Tax Schedules, so I know they are there.  In QM2007, realized gains were included on the income statement.  I'm using QM18, just imported from QM2007.  

RickO

Quicken Harold said:

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

That's because realized capital gains are not a category, but rather a computation based on sales vs cost basis. You can find them in the Tax Summary report. Note: not to be confused with capital gain distributions.

Northbynortheast

Quicken Harold said:

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

I have found them in Tax Summary.  However, I can't get an accurate calculation of income without capital gains.  I guess I can add them to my report by hand with a pencil, but that seems like a giant step backwards.  Any suggestions?

RickO

Quicken Harold said:

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

You ought to be able to get all you need in the Tax Schedule report. But if not, you can export that part to CSV and the other part from the Category Summary to CSV and then put them together in Excel or Numbers.

Northbynortheast

Quicken Harold said:

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

Thanks.  The data is all there.  I just want to combine it into one income report.  I know I can export it an then combine it myself in Excel, but that defeats the purpose of Quicken.  Also a giant step backwards.  QM2007 did all this automatically.

Unknown

If you are using a transfer for the income from one account to the other, they both show up in the category one as a plus and one as a minus, so they cancel each other out and don't report. I'm having the same problem and I'm not sure how to fix it.

smayer97

Julie Fleming said:

If you are using a transfer for the income from one account to the other, they both show up in the category one as a plus and one as a minus, so they cancel each other out and don't report. I'm having the same problem and I'm not sure how to fix it.

Currently, reports do not handle transfers effectively.

You can add your VOTE to Ability to Include or Exclude Transfers on Reports.

First, click on the underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THIS feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

While you are at it, you may want to add your VOTE to related IDEAS found on the List of Requests for Report Related Features. Click on the underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

Unknown

RickO said:

In the customize dialog, click NONE for Categories, Tags and Payees and see if they show up then.

This is the most counter intuitive solution, it works, but is counter intuitive.  You would think that selecting all items would give you everything.

smayer97

RickO said:

In the customize dialog, click NONE for Categories, Tags and Payees and see if they show up then.

You can add your VOTE to Add Selection Criteria for -No Category- and -No Tag- on Reports.

First, click on the underlined link above to go there, then click VOTE at the top of THAT page, so your will vote count for THIS feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version.

While you are at it, you may want to add your VOTE to related IDEAS found on the List of Requests for Report Related Features. Click on the underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)

RickO

RickO said:

In the customize dialog, click NONE for Categories, Tags and Payees and see if they show up then.

mattebury... the dev team is aware of this and an upcoming release will revamp the customization dialogs so that it is no longer counterintuitive. I don't have any knowledge about the date for this to be released.

Unknown

Quicken Harold said:

Hi Tony, appreciate your question.

While investigating your question, I did make some changes to just providing the Investments categories in my report:



Although I don't have investments, you can turn all the categories off but the Investments.. 

I would try to make this change in your summary, and send us a screen shot of the results if you would.

Many thanks in advance.

Respectfully,
~ Quicken Harold.

Agreed that realized gains and unrealized gains should appear in category and budget summaries if those categories are checked on.  That's how 2007 worked.  CanQuicken Harold respond?