Bond Maturity report needs improvement [edited]
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.
Comments
-
These enhancements would be very useful as more users are purchasing individual bonds and want to monitor them as they do their equity purchases.1
-
A bond ladder report(Maturity Report) is a basic investment tool that should be available.3
-
I had already voted for this idea [removed]. I think it's a good idea and don't know why they would reject it so quickly.[removed]
Quicken user since version 2 for DOS, now using QWin Premier (US) on Win10 Pro.
0 -
I totally agree with your requested enhancements. All are solid suggestions that will benefit most fixed income investors by making this report more useful. Especially since fields like "call date" and "yield to maturity" are already in the security data record anyway. And fixing that "NA" problem on purchase date - that's the issue I was researching that brought me to this thread this morning. But your suggestions are all excellent - thanks for posting. Quicken - please consider addressing this.0
-
While these recommended enhancements are all valuable and important, there is a fundamental problem with the current Maturity Dates for Bonds and CDs report which also needs to be addressed. The report, as it exists now, includes fixed-income investments which are no longer owned if their maturity date is in the future. This situation can happen because a bond is sold prior to maturity or because it is called prior to maturity. It should be a rather straightforward fix to remove fixed-income securities no longer owned from this report.6
-
> @q_lurker said:
> 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)
>
> 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.
Yes PLEASE!1 -
YES! Please improve this report!!!1
-
STRONGLY recommend adding Call Date as a column in the report. For anyone holding bonds for more than a few years, the Call Date is much more important right now than the maturity date.0
-
I'd like to agree with all suggestions, especially call date.0
-
This idea has gotten strongly positive comments from 9 different people, yet only 5 votes, including my own. What’s up with that?0
-
q_lurker said:This idea has gotten strongly positive comments from 9 different people, yet only 5 votes, including my own. What’s up with that?Looks like it got migrated from GetSat. (See link in OP.) Comments would migrate, but votes wouldn't. I don't even remember what my now-redacted comment above used to say.There's another bug in this report which hasn't yet been mentioned. The title reads "All Dates" even when "Show future maturity dates only" is checked (which, in my case, is always).
And as long as we're fantasizing about this report, how about adding "Yield to Worst", the lower of Yield to Maturity and Yield to Call.Quicken user since version 2 for DOS, now using QWin Premier (US) on Win10 Pro.
1 -
And another bug in this report (which has been mentioned elsewhere but not in this thread) is that bonds & CDs continue to appear even after they've been redeemed. This caught me today; the report showed a bond maturing on 12/1/21 but it had been called back in 2016. I had to manually remove the maturity date to make it disappear from the report.
Edit: I see this was mentioned above.Quicken user since version 2 for DOS, now using QWin Premier (US) on Win10 Pro.
2 -
Not sure if there is something more recent on this, but wouldn't it be nice if a bond/CD has a cusip, Quicken actually brought in the correct bond class, maturity date, call date, etc.0
-
Strongly agree with adding "Call Date" for bonds to the CD/Bond Maturity Report and as an option in Portfolio view.0
-
Novice bond buyer here....good ideas!
In addition to @q_lurker features, I would like to see a configurable cashflow graph option in the report so that I can see value v. maturity date, as I build a bond portfolio. This will help see better what cash will be available soon to fund living expenses, invest in equities, keep in cash or roll to a new bond.
Example...
2 -
It would be helpful if the Maturity Report for Bonds and CDs report, also displayed CUSIP and YTM. btw... In one case, I saw Symbol = CUSIP. Typically, Symbol is shown as blank. Not sure which way is correct.0
-
One other problem with the "Maturity Report for Bonds and CD's" - where is this report getting the purchase date from? All the purchase dates are wrong. Some of them even show dates prior to when I opened the brokerage account from where I purchased the CD's. Any one else notice this problem?
2 -
Quicken bug squashers please note - another problem with the Maturity Dates for Bonds and CDs report:
When transferring Bonds from one brokerage account to another, the Purchase Date reported for the transferred Bonds shows the date of the Bonds' transfer to the new account.
The correct date to report is the original Bond Purchase Date.
0 -
I agree with the enhancements listed here. I for one, regularly copy the report to my clipboard and paste it in an Excel worksheet to total the bonds. However, I believe that the following foibles need to be addressed so people can reliably access the basic functionality, and should be addressed before adding new features:
(1) If the original transaction purchasing the investment did not have a maturity date, adding a maturity date to the investment is not sufficient to make the new bond or CD appear on the report. The original purchase transaction must first be deleted and then reentered.
(2) If a bond or CD is purchased in one account, and then transferred to another account via a "remove shares" and "add shares", "purchases" will be included in the report, one for each account.
(3) If a one-off version of the report is created, for instance to exclude an account containing ghost investments, as in (2), then a newly purchased bond or CD will appear only in the original report, not in the one-off.
(4) Two lots with the same CUSSIP will be combined in holdings but appear as separate bonds in the report. This wouldn't be such a problem if it weren't necessary to repeatedly reconcile the report against Holdings because of (1) - (3).
Harry0
