When you set up a security in Quicken it is possible to identify it as a bond and then further as a municipal bond. Municipal Bonds are almost always tax free income. When entering transactions for a given bond the income categories include Dividends and Interest. For Tax Free Income I always have to enter it as Miscellaneous Income and then further specify that it is investment income and then further as either tax free interest or tax free dividend. It has always puzzled me as to why I have go through this multi-choice method of entering the data rather than have all municipal income default to either Tax Free Interest or Tax Free Dividends. Any comments on this problem would be appreciated. I may have missed something along the way.
Tax Free Income
Dec 13, 2009
4 Replies
You can identify a security as "Tax Free"; for existing securities, select the security in the Security List and Edit - put a check in the "Tax Free" box. In most situations, Quicken will report the dividends and interest as tax free.
John & OP
This feature has stopped working [some what] in recent versions - not sure when.
Have tested this in QWin 2009 and 2010.
Example; Dividends paid by a security marked Tax Free report as regular dividends [taxable] in the tax reports - Tax Schedule Report and Sched B Report. They are simply co-mingled with regular taxable dividends. In earlier versions, these dividends were included in the tax reports but were subtotaled separately under a header which clearly identified them as tax free dividends. I have a pdf copy of a Tax Schedule Report for TY2002 [likely from QWin 2002 or 2003] which shows this correct treatment for the tax free dividends on a muni bond fund holding.
Interestingly, QWin's Investment Income Report does correctly identify and subtotal the tax free income separately.
As the OP indicated, the current work-around is to use a Miscellanous Inc entry and you can assign the "_DivIncTaxFree" category. The tax reporting is then correct.
Hi JM,
I ran a couple of tax reports and a couple of other reports (like the Income/Expense by Category report; and the Banking > Transaction) in Q2010 RPM, R3 (before I commented) and did not see the problem you report.
The tax reports excluded dividends and interest for Tax Free securitries (without my making any customizations).
I did see that there was no distinction in the Banking > Transaction report ... and (as I recall) other reports have always shown the "category" field as "_DivInc" or "IntInc", but when looking in reports such as the Income/Expense report, the amounts are reported under (what appears to be a pseudo-category ... though it is listed as an actual category) "_IntIncTaxFree or _DivIncTaxFree. When transaction details are available in reports, the category field shows as "_DivInc" and "_IntInc" but when subtotalled by category ... the main category name has the "_TaxFree" designation.
The Income/Expense by Category report correctly reported tax free interest in the "_IntIncTaxFree" "category".
When I look in the Tax Schedule report in Q2010, I do not see any tax free interest or tax free dividends (which I assume is correct) ... despite the fact that those "categories" are selected in the Customize dialog and the accounts that hold those tax free securities are selected to include in the report.
I don't understand why a report, subtotalled by Category, would show the heading of the category as "_IntIncTaxFree" while showing the Category field as "_IntInc". That's why I hedged my previous comment in this thread ... I don't fully understand what Quicken is doing with tax free securities.
My thanks to all who responded to my query on tax free income. It confirms pretty much what I have experienced all previous versions of Quicken. I am going to continue working with the suggestions given in the coming year and keep doing what I have been for the time being. It is really laborious and seems like it should be a rather simple software solution. I don't understand why Quicken hasn't addressed this problem fully in the past. Thanks again and I think we will revisit the issue after the beginning of next year.
Hooter
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required