Problems with Maturity Dates for Bonds and CDs Report

jldavid47 · August 2024

If you sell a portion of a bond investment, the report shows the initial full amount owned rather than the current amount. This is wrong. Both the register and the Investing tab show the current amount and so should the report. It could be made an advanced option but I just think it's wrong to report the data that way.

Also, if a bond is sold or called prior to the maturity date, it is shown on the report even though it is no longer owned. An advanced option needs to be added to only show bonds currently owned.

I reported this through "Report a Problem" in Quicken as well.

q_lurker · August 2024

You might review, vote for, and add on to this idea:

Bond Maturity report needs improvement [edited]

q_lurker

Jan 23, 2018

The Maturity Date report for bonds and CDs is structured more simply with fewer options than most Quicken reports. I suggest some enhancements to that report would benefit many users.

1) Add totals to the listed bonds and CDs to show both the total face value (@ $100/share for bonds, $1/share for CDS) and total current market value. (See:https://getsatisfaction.com/quickencommunity/topics/total-up-bond-shares)
EDIT: current link =
https://community.quicken.com/discussion/comment/19264219#Comment_19264219)

2) Correct the "NA" that reports as Purchase Date for some Bonds

3) Allow Subtotals By: Account, Security Type, Security (current format). Month, Quarter, or Year. The Month / Quarter / Year options would be using the maturity date.

4) Subtotal By Account should include the '+' expansion option for completeness and consistency with the difference being possibly different purchase dates.

5) Add a column option for Call Date (default to include)

6) Add a columns for Yield to Maturity (default to include)

The gist of this improvements should make the report more valuable to the user and more consistent with customization options in other reports.

jldavid47 · August 2024

There is a workaround to the above problem (and this doesn't mean it shouldn't be fixed in the Maturity Dates report). FWIW, the problem is even worse because the Value column gives you the "value" as if the original number of shares were still owned (i.e. it takes the original number of "shares" and multiplies it by the price. WRONG). There is only one way I found to work around this:

In the Investing tab, I created a view I called "Maturity Dates" with the display columns being "Quote/Price", "Maturity Date", "Shares", and "Market Value" which I sort by Maturity Date.

Since I want this information current and sorted by maturity date within each account, this fixes the issue for me. The shares and value are correct for those issues that have been partially called. Better than nothing.

Problems with Maturity Dates for Bonds and CDs Report

Comments

Bond Maturity report needs improvement [edited]

Welcome!

Quick Links

Categories