Maturity dates for bonds and cd report segmented by month/year due

ajb328

Anyone figure out how to generate a report which shows the month and year that bonds and CD's are due which also shows the total dollar amount for a month/year?

I do run the standard report for Bond and Cd maturities but the bonds/CD's are listed numerically per the month/year due in a contiguous fashion. I want a report that shows total dollar amount due per particular month/year.

Quicken Kristina

Hello @ajb328,

To assist with this, please provide more information. What kind of bonds are you tracking in Quicken (US I Bonds, US EE Bonds, etc.)? How are you tracking them in your Quicken? Are you recording the bond information manually? If so, what method are you using to track the bonds' value?

Also, I'd recommend taking a look at the Idea post, linked below, requesting improvements to the Bond Maturity report:

https://community.quicken.com/discussion/7673644/bond-maturity-report-needs-improvement-edited

If this is something you'd like to see added to Quicken, please add your vote! Ideas that get enough votes may be implemented in the future!

I look forward to your reply!

ajb328

Quicken Kristina, I track US Treasuries, agency paper, munis, corporate bonds, CD's - typical fixed income securities with maturity dates. After purchase I use the Quicken securities report to add information that will fuel the bond/CD report. However, although the maturity dates are displayed in the current report I want a sub total current value of bonds/CD's by year/month due. This helps decide where new current funds should be allocated according to year/month due which keeps the bond ladder balanced according to future maturity dates. This should be a fairly simple fix as all the information needed is already in the current report except the sub totals I am requesting.

Thanks

q_lurker

@ajb328

You said at first "I want a report that shows total dollar amount due per particular month/year."

Now you said "I want a sub total current value of bonds/CD's by year/month due."

I would have interpreted "total dollar amount due" as matured or face value receivable in that month. Asking for "current value" is different and is what the current report presents: Value = current fair market value based on current quote for the bond. The current report does not present the matured or face value of the bond (a shortcoming).

Which is it you are really wanting subtotaled? (Seems to me both should be totaled when the report would be subtotaled by "Maturity Date Month".)

Also, please add your 'vote' to the idea cited above. Up at the original idea, the little up arrow in the yellow banner.

ajb328

Which ever value Quicken uses to create the current report is acceptable. It's more critical to me that I can see how much I have in bonds/cd's in a particular month and year. As my items mature the cash is deposited in an account. I then want to reinvest based upon yield and duration and also how a selection impacts my bond/cd ladder. Whether the report shows purchase price, par value or current value is not that critical to me. What I would like is a total amount shown for a particular year/month of already invested instruments. I imagine that in order to do this Quicken must read the maturity date field from the "securities" report. I can't find a report that reads this field. However, I did find that by using "other" info from the securities report, that is, Goals field and selecting "income" i can generate an "allocation" report which isolates the type of instruments. But, no value subtotal per year/month. I'm grateful that Quicken did come up with the Maturity report which I requested many years ago. Been using Quicken since V1.0. It keeps improving and I couldn't live (easily) without it as I manage my own portfolio.

Thanks for your input. I hope I've clarified

q_lurker

Thanks for the clarification. It is not a big deal to me personally, but I would most likely be interested in the face (par) values of the bonds maturing in the month. Short of Quicken assuming the $100 / ‘share’ for a bond and $1 / ‘share’ for a CD, the database does not have that explicit par value. I know of nothing wrong with that assumption, but it is still an assumption.

The other place to access the maturity date field is with a customized portfolio view (ctrl-u), but that still lacks the subtotaling you are after. You can group by Security Type to get all the bonds together. Either the portfolio view or the report can be taken to an Excel sheet for additional processing.