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

Question

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.

q_lurker · Answer

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.

ajb328 · Answer

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 · Answer

@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.