Bond Maturity report needs improvement [edited]

q_lurker
q_lurker SuperUser ✭✭✭✭✭
edited October 2021 in Reports (Windows)
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. 
9
9 votes

No Status · Last Updated

Comments

  • Lauren Babus
    Lauren Babus Member ✭✭
    edited June 2018
    These enhancements would be very useful as more users are purchasing individual bonds and want to monitor them as they do their equity purchases.
  • David H
    David H Member ✭✭
    edited June 2018
    A bond ladder report(Maturity Report) is a basic investment tool that should be available.
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    edited August 2019

    [removed]

    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.
    Quicken user since version 2 for DOS, now using QWin Premier Subscription on Win10 Pro.
  • RickDetroit
    RickDetroit Member ✭✭
    edited June 2018
    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.  
  • Savvy Investor
    Savvy Investor Member ✭✭
    edited June 2018
    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.
  • dstrempel
    dstrempel Member ✭✭
    > @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!
  • Joseph Arden
    Joseph Arden Member ✭✭
    YES! Please improve this report!!!
  • Doug N.
    Doug N. Member
    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.
  • Jeanne
    Jeanne Member ✭✭✭
    I'd like to agree with all suggestions, especially call date.
  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    This idea has gotten strongly positive comments from 9 different people, yet only 5 votes, including my own. What’s up with that?
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    edited September 2021
    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 Subscription on Win10 Pro.
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    edited October 2021
    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 Subscription on Win10 Pro.
  • David Roehl
    David Roehl Member ✭✭
    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.