How to have CD bank account show as Investing in Asset Allocation

Ps56k2

I've tripped over this before, but as I move cash into CDs - it is harder to see the overall "investment" asset allocation picture with regard to "cash".

Since the CDs are acquired thru normal banks, they appear as part of the bank account, along with Checking, Savings, MM, and CDs.

It's too bad that these investment type accounts can't be split off, as they really represent "investments" and not the usual "banking" type of accounts and transactions.

And yes.... you can "display" them as part of the lower list of accounts - Investments - but they are still considered part of the banking world.

jr7107

How about just buying T-bills or short term treasuries instead? Gets them into the portfolio view. Not advice, just a way of getting them into the allocation picture more effectively.

Ps56k2

jr7107 said:

How about just buying T-bills or short term treasuries instead? Gets them into the portfolio view. Not advice, just a way of getting them into the allocation picture more effectively.

I have a couple of Vanguard mutual funds for Total Bonds, Muni Bonds, and Intl Bonds.

And "cash" shows up from the various stock mutual fund internal allocations, but as I start doing a Ladder CD, would like it to be included as an "investment"... but guess not, since it comes thru the "banking" account download...

jr7107

Yeah, I get that you are dealing with a "non-broker" firm so the funds go into a different category. Can you ladder T-Bills through your broker to get the same result?

And on the "cash" view in Portfolio View when I aggregate it, I really have no idea how it is calculated.

Jim_Harman

@ps56k,  If you have a bank CD account that you want to treat as an investment, go to Account Details and click on the Display Options tab. Under Account Intent, choose Investment or Retirement as appropriate.

The account will move to the Investing section of the Accounts list and will also be available and selected by default in the Investing Asset Allocation report. It is classified as Cash. Make sure "No security (includes Cash)" is included in your security selections.

On the Investing > Asset Allocation screen, it is also available for selection as one of the accounts, but the CD money is included in your allocation only if you select "All securities" because there is no selection for No Security (includes Cash) in the selection list (a bug I think)

@jr7107, Cash in the Investing Portfolio views should be the total of the Cash Balances in your investing accounts plus the CD accounts if you have set their account intent to investing or retirement.

This appears to be a seldom-used feature of Quicken so I don't know what other impacts it might have.

[Sorry for all the edits] This applies to QWin Subscription. Cash in the Investing Portfolio views was handled differently in earlier versions. I think there was no line for it unless you grouped by Accounts.

jr7107

@Jim_Harman I did not think change the display options tab for account intent would move it to the portfolio view, also I haven't ever tested it. And re: cash in the portfolio view aggregated by something other than Account gets wacky with different currencies. I checked once and the Market Value was correct, I just didn't know how Q came up with the total but I trust it is correct.