nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to include bank CDs in asset allocation report

ecNuknon4DVs

I have a bank Certificate of Deposit that I would like to include in my asset allocation report. It is listed in the "Banking" section of my account list. The Asset Allocation Report only seems to allow assets from the "Investing" and "Retirement" sections of the account list. How can I include my CD assets in this report?

Find more posts tagged with

Accepted answers

Sherlock

To make the CD registers available to the report, open the CD register, press Ctrl + Shift + E, select the Display Options tab, and select Investment or Retirement in the Account intent pull-down menu, and OK.

Sherlock

ecNuknon4DVs said:

Thanks very much. Progress. I was able to categorize it as an Investment, and it is now selectable on the Accounts tab of the Asset Allocation Report. However, the money in the CD does not show up in the report. Is there something else I need to do?

If you haven't already, I suggest you check No Security (includes Cash): open the report, press, Alt + C, select the Securities tab, check No Security (includes Cash), and select OK

All comments

Sherlock

ecNuknon4DVs

Thanks very much. Progress. I was able to categorize it as an Investment, and it is now selectable on the Accounts tab of the Asset Allocation Report. However, the money in the CD does not show up in the report. Is there something else I need to do?

UKR

I'm guessing ... if the savings account with your CD now shows in the Asset Allocation report, the amount of cash invested in CDs should show lumped in as "-Cash-" with all other cash balances in other investment accounts.

The only workaround I can think of, if you wish to see all your CDs held in bank savings accounts individually, would be to create a manual investment account and then "Buy" securities, Type = CD, and transfer (internally in Quicken only) the purchase price from the CD savings account (so as not to bloat your net worth)

ecNuknon4DVs

Thanks but the money from the CD does not appear in the report at all, even though it is selected in the Accounts tab of the Customize Asset Allocation window. Also, listed next to the CD on this page is "Bank" whereas my mutual funds are all listed as "Invest". On the separate register CTRL-SHFt-E sceen the Account Type is listed as "Savings". The Account Type for my mutual funds is listed as "Brokerage". it is not clear to me how one would change the Account Type.

UKR

You can't change account types.

The Asset Allocation report works off of individual securities as recorded in investment accounts.
What you see now, with the money held in savings accounts, is as good as it gets ... unless ... you follow my workaround advice and (within Quicken only) shift your money into CD securities held in a manual investment (brokerage) account. That will make the report show the CDs as proper investments.

Sherlock

ecNuknon4DVs said:

Thanks very much. Progress. I was able to categorize it as an Investment, and it is now selectable on the Accounts tab of the Asset Allocation Report. However, the money in the CD does not show up in the report. Is there something else I need to do?

If you haven't already, I suggest you check No Security (includes Cash): open the report, press, Alt + C, select the Securities tab, check No Security (includes Cash), and select OK

ecNuknon4DVs

Okay, thanks for your help. Will try the workaround and see how it looks.

ecNuknon4DVs

Checking the "no security" box did the trick. Thanks to you both!

Ps56k2

ecNuknon4DVs said:

Checking the "no security" box did the trick.

Just following along on the topic.....
- Moved a Bank CD over to the "Investment" display area.
- Brought up the --> Reports --> Investing --> Asset Alocation
- Made sure the "no security" was checkmarked

Don't see the bank CD listed in the text report,
or reflected as part of any graph line item.

Sherlock

ps56k said:

ecNuknon4DVs said:

Checking the "no security" box did the trick.

Just following along on the topic.....
- Moved a Bank CD over to the "Investment" display area.
- Brought up the --> Reports --> Investing --> Asset Alocation
- Made sure the "no security" was checkmarked
-
Don't see the bank CD listed in the text report,
or reflected as part of any graph line item.

The bank CD should appear as Cash if you include the account in the report.

Ps56k2

Sherlock said: The bank CD should appear as Cash if you include the account in the report.

yeah... tnx - it was there - just thought it might be possible to drill down and see the Cash components, but without the correct attributes, not really avail -

ecNuknon4DVs

Yes, it shows up in the Cash amount. For me this was fine, since what I want is a summary by investment category, e.g. 50 / 50 bonds (&cash) / stocks.

Ps56k2

Do you also have any mutual funds or ETFs ?
If so, the "cash" will then be biased by the "asset mix" of those mutual funds or ETFs,
and not actually reflect the usual liquidity of your banking "cash" - but of course would reflect any cash-like holdings such as bond funds or MM funds, etc

ecNuknon4DVs

Understood, thanks. The Asset Allocation report does list all the sources of the cash, e.g., this mutual fund or that.

Ps56k2

yes.... but the "Cash" line item has no further breakdown or detail...

so the bank CDs are hidden inside that overall line item... along with other bits.
It is interesting to go back to the Settings,
and one by one UN-check the included Accounts - to see the effect on "Cash" -