Excess entries in Maturity Dates for Bonds and CDs report in taxable account

tlbenning

The Maturity Date report for the bond/CD ladder in my retirement account is perfect with one line for each security. The same report for my taxable account has multiple lines for each bond for which I've recorded a coupon payment. I use Enter Transactions - Income, enter amount as Misc, and select Interest Tax Exempt as category for those coupon payments.

Screenshot attached. Would love to get rid of all these extra entries. Thanks in advance for any advice.

q_lurker

While there are some problems with the Maturity Report, I have not seen that issue before.  I don't see it in my file. 

FWIW, it is not required that you use the MiscInc transactions to get the interest categorized as TaxFree.  If you have the security (bond) detail set as a Tax Free bond, appropriate reports (tax reports, etc.) will show the income under the _IntIncTaxFree category.  You might try that alternate approach to see if it clears your problem.  Perhaps for only a few such transactions to begin with.  

q_lurker

While there are some problems with the Maturity Report, I have not seen that issue before.  I don't see it in my file. 

FWIW, it is not required that you use the MiscInc transactions to get the interest categorized as TaxFree.  If you have the security (bond) detail set as a Tax Free bond, appropriate reports (tax reports, etc.) will show the income under the _IntIncTaxFree category.  You might try that alternate approach to see if it clears your problem.  Perhaps for only a few such transactions to begin with.  

tlbenning

Your suggestion does fix the report issue. Thanks very much. Would love to know why it fixes it.

Years ago I created an Interest-TaxFree-TripleTaxFree income subcategory to differentiate in-state from out-of-state bond income at tax time. I couldn't figure out how to create a _HiddenCategory so that's why I used the MiscInc entry.

I guess I still want that subcategory info worse than I want a pretty report.

Appreciate your response very much.