Q2010 Premier Tax Attribute / Tax Report Problems

Jan 23, 2010 4 Replies

I recently upgraded from Q2007 Premier to Q2010 Premier. Most of my recent data entries (which I suspect is place where Q attaches tax line attributes) were under Version R3. I have updated to R5, but encounter the same problems. FYI, my Q usage goes back to Q for DOS.



In running Tax Reports for 2009, my last Mortgage Interest entry is for November (entered under Q2007), some (but not all) Foreign Tax entries (for withholding on dividends) for December are missing, and all deposits to a particular bank account are showing up as uncategorized tax transactions. Tax free dividends paid at any time during 2009 by a mutual fund no longer get listed (they formerly were listed under the caption "Div. income, non-taxable"). There could be additional issues; but it is early in the year as I start work on my taxes.



Opening Categories -- I see that Mortgage Interest, Foreign Taxes and _DivIncTaxFree [and _TaxEx Dividend] show a Tax Checkmark and are linked to the correct Tax Lines. But, a number of Bank Deposit Accounts and Investment Accounts (taxable brokerage, taxable mutual funds, IRAs and 401(k)s) also display a Tax Checkmark and a link to a variety of Tax Lines. Fortunately most of these are closed accounts.



Opening Accounts / Tax Schedule Info -- I have deleted any tax lines. But the Categories still show the Tax Checkmark and the the link.



Going to my specific mortgage payments, I find that entries input under Q2007 or earlier, show a Tax Checkmark next to the Interest Line (in the Splits screen), but my December and January payments under Q2010 show no tax linkage.



Right clicking on the checkbook entry and selecting the Tax Line Assignments produces the following error message: "This transaction has splits, open the splits window and access the Tax Line Assignment dialog from there." Following those instructions, right clicking does not show any option to attach Tax Line Assignments to a split entry.



The transaction screens for investment accounts do not reflect any tax attributes. The foreign tax transactions are entered as MiscExp as the action and Tax:Foreign as the category. I can discern no obvious difference between those entries that make it to my Tax Report and those that do not. The mutual fund dividends are entered as reinvested dividends, with no place to reflect any tax attributes or to select the category. [I have always presumed that Q used the checked tax exempt button in the Securities screen to determine whether the interest is taxable or tax exempt.]



Tax Category Auditor is showing no problems. If instead of running a Tax Schedule Report, I run the similar but not identical Tax Summary Repport, many of the problems go away -- all mortgage payments show up, all foreign tax withholding and tax exempt interest (but mixed with taxable interest under the category "_DivInc").



I can live with unwanted transfers showing up as uncategorized tax entries. But missing mortgage interest and taxes paid is a serious problem. A major reason for using Quicken is to avoid my having to remember the tax consequences of 1,000+ transactions each year.



Am I the only one experiencing this issue? Or is it early in the tax year and no one else has focused on their 2009 tax reports?



Thanx for any thoughts.


I don't think I have the answer, just a couple of comments.

Quicken should exclude tax-free securities and tax-deferred accounts from the Tax Reports.

Instead of right-clicking a split line entry, select it and click the "Edit" button, to see the option for Tax Line Item Assignment. I don't believe this option (to see the Tax Line Item Assignment) has ever been available in investment accounts.

There was a bug (can't recall which Quicken versions) that removed tax line item assignments from loan transactions that were entered using the "Make Payment" button on the "View Loans" window. It looks like Q2010 R5 no longer has that bug; but I suspect that if the Tax Lines were removed in previous versions/releases, R5 wouldn't put them back.

Thanx for pointing out the obvious. As split lines are directly editable, it never occurred to me to click on the Edit button. With my February mortgage payment coming up, we will see if R5 fixes this bug.

I would agree that tax-deferred accounts (IRA's, 401(k)'s etc) should generally be excluded from tax reports. That is readily accomplished by excluding those accounts when setting up the report. [I said "generally" as I am still adding to those accounts, and have not started withdrawals. ]

But Form 1040 has required listing tax-exempt income on line 8b for the last 10+ years. So I would think that including mutual fund tax exempt dividends in Tax Reports is appropriate, whether intermixed with taxable dividends as Q 2010 does in the Tax Summary Report or broken out in a separate report (my personal preference) as Q2007 and earlier versions did.

That leaves my problems with Foreign Taxes not getting picked up everytime, and why transfers to certain accounts are showing tax attributes when they should not.

Don't know about the foreign taxes.

Transfers into and out of accounts are assigned Tax Line Items on the Overview tab of the account. If you click the "Options" button on the Account Attributes pane there, you will get a choice to "Set tax attributes".

John--

FYI, Q 20110 Premier version R5 now recognizes the mortgage interest Tax Attribute when using the Loan Wizard to input mortgage payments.

As to your comment immediately above, that was the 1st thing I looked at when I discovered that Tax Attributes were being assigned to transfers into and out from certain accounts. Of course once Quicken sets Tax Attributes on reconciled transactions, there is no fast way to unset them. Fortunately most of the problem affects old transactons which are unlikely to cause current problems. So it is an annoyance mostly.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required