Security reports inconsistency.

ajb328

All my CD's and Bond securities are displayed in "Maturity dates for Bonds and Cd's" report but some do not display in Asset Allocation reports, although the total dollar amount displayed in the reports is consistent with the actual brokerage amounts. I've tried multiple report filters and rechecked security "type" and "asset" class for the Asset Allocation reports. Still, certain CD's and Bonds dont display in the Asset Allocation reports.

Anyone else have this occur? Any suggestions?

Quicken Jasmine

Hello @ajb328,

Could you please provide a screenshot or two of what you are seeing? If needed, please refer to this Community FAQ for instructions on how to attach a screenshot. Alternatively, you can also drag and drop screenshots to your response if you are not given the option to add attachments.

Thanks!

Jim_Harman

The Asset Allocation report only includes securities and cash held in brokerage accounts, not CDs held in bank accounts, even if the Account intent is set to Investing.

Assuming your bonds and CDs are held in brokerage accounts, go to Tools > Security List and click on each bond and CD. Click on Edit details and under Asset class, pick the appropriate one - Domestic bonds, Global bonds, or Cash. Un-check the Download asset class box so Quicken does not try to change your selection.

q_lurker

I found one such anomaly in comparing the two reports in my file. The discrepancy turned out to be a bond that was “sold” early (called before maturity). It was listed in the maturity report even though I currently did not own it. That is a known flaw in the maturity report. The allocation report was correct in omitting that bond.

ajb328

As per q_lurker comment above I discovered the same anomaly when comparing reports. Even though I marked "called" securities as "hide" they would still show up in some reports. In the Maturity report, it seems that Quicken only looks at the maturity date and not a call or sold action even though the security is no longer present in the account. The asset allocation report DOES account for called (sold, deposited) securities which then shows accurate balances. However, the Maturity report does not account for securities which are sold or called prior to their designated maturity date thereby giving a false monetary total of securities, even if "hidden".

I found the "work around" is to change the maturity date to when a security is actually called or sold, which should be a present or past date, thereby removing a future maturity date, and thereby showing an accurate monetary total of the securities still held in the Maturity report. Once I did this the Maturity report total (exported to Excel since quicken doesn't total this report) agreed with my asset allocation report (which Quicken does total).

I suggest that Quicken caution users of the Maturity report that securities with a future maturity date will continue to show in the report in spite of that security being called or sold prior the designated maturity date.