This post has been closed and is not open for comments or answers.
Quicken Community Home Page

Q 2012 Deluxe Tax Summary Report is missing specific Federal Tax payments

Since updating from Q2011 to Q2012 in early November, my Tax Summary Report does not pick up any Federal Tax payments made after the update.  I have used both Chat and Phone in the help system to try to resolve this.  They had me create a new Quicken file, create a new account in that file, then make the 5 tax payments for 2011 from that account.  When creating a Tax Summary Report, it sees none of those payments - even though the "tech" in India says he does it on his system and it works OK.  We also went through the standard "check all the settings routine" to ensure they weren't dealing with a computer idiot.  More than an hour wasted doing that!  I refused to give them access to my system to troubleshoot for perfectly obvious reasons.  Let me now add further information.  I have re-loaded Q2012 and completed all updates.  The problem remains.  Next, I changed a Federal Tax payment that was appearing in the Summary Report to a different, non-tax related category.  Ran the report and it was, naturally, not there.  Went back to the entry and changed it back to Federal Tax, ran the report again, and it is still not there!  If I run a Usage report from either the Category list, or the Payee list for Federal Tax Category, or US Treasury Payee, all of the payments appear in both reports - no problem!  I am left to conclude at this point that something in Q2012 is excluding any Federal Tax payments made or entered in Q2012.  I should also add that payments made for State Taxes at the same time, and Contributions made at the same time, from the same account do appear as normal in the Tax Summary Report.  My primary concern is getting this problem resolved in order to complete my taxes accurately.  I have used this program and the Tax Summary Report for over 20 years to do my taxes - now I am wondering if I have been missing any data all those years?
    A friend of mine just had this problem.  Through trial-and-error, we determined that if he used Custom Dates, and specified a Start Date of 12/31/2010 (and an end date of 12/31/2011) he could get these items to display.  BUT, if he chose a Start date of 1/1/2011, the items did NOT display.  Looks like Quicken 2012 has a flaw in its implementation of January 1.
    • I am having the same exact problem as Dave58.  The workaround identified by OhioPM is the only thing that worked for me.  Clearly there is a problem with the Tax Schedule Report using 1/1/2011 or any starting date in 2011.  You must use a starting date prior to 1/1/2011 for the W-2:Fed withholding items to appear on the report.
    • I'm having this same problem and it caused my CPA and I to do my taxes wrong!!  Fortunately, we caught it today (4/17/2012) on the last day to file.  

      Intuit, I'm not very happy about this.  It seems to be a bug in Quicken.  I made 2 quarterly Tax:Fed category tax payments in 2011 and one in Jan 2012 (as is normal).  If I run a Tax Summary or Tax Schedule report for 2011 it omits listing the two payments made in 2011 but includes the payment made in 2012!!!  Just the opposite of what it should report.

      Why is a 2011 report listing activity in 2012? !

      My database Verifies.  My Tax Line assignments are identical.  I'm running Q2012 on Win7.

      I count on Quicken to help me manage my finances - I need to be able to trust it more than this!!!

      PS:  The security question for this post is "What planet are we on?".   I think I know the answer but I'm starting to wonder.  :)
    • Don't know if this thread has been resolved... but I noticed I had the same problem when generating
      a tax report for 2012. Same boat as the orginal poster... upgraded to Q2012, etc.

      I was able to get the transactions to show up by doing the following:

      1) changing the tax line assignment to a different category (from self withholding to qtr estimated)
      2) AND by changing the date (added 1 day)

      Interesting also...
      When I change the tax line assignment back to the original category, the
      transaction still shows up in the tax summary report

      BUT

      if I move the date back to the original date, I lose the item in the
      tax summary report.

      I would say that I'm disappointed in this bug... I've used Quicken for many years and
      over many upgrade cycles, and I've never had this problem.
    • Oh, one more thing... If I just changed the date by itself, the transactions don't show up....
      I needed to change the tax line assignment and date together...
    • I am having the same problem getting my estimated tax payments to show up in a Tax Summary report.  If I use custom dates for the report and set it to 1/1/2102 to 12/312012, only a payment in January shows up, not the ones I made in September and December.  If I set the custom dates to 1/1/2012 to 1/1/2013, then all my estimated tax payments show up in the report.  I too am using Quicken Home and Business 2012 R 7.  Very weird.  It makes me distrustful of all my other tax summary report items.
    Like Tamara, I have tried to replicate your problem [Q2012 RPM R4 U.S.] and can not.

    Something I don't recall you saying you've tried is to create a New test Quicken file, setting up the minimum accounts/categories, etc., and trying to recreate the problem in the New Quicken file.


    "You are exactly correct. Even though I changed the Tax Line Item in the Category list, it did not necessarily change the Tax Line Item in each individual transaction entry in the register.

    I have never changed the tax line item of an individual transaction. But to check on this, I tried the following:

    --Created two transactions using the same category that had the "Form 1040 Federal estimated tax, qtrly" tax line item assigned.
    --Manually modified one of those transactions in the register, to have no tax line item assigned.
    --Modified the category in the Category List to have no tax line item assigned. Now neither actual transaction had a tax line item.
    --Modified the category in the category List to have the "Form 1040 ..." tax line item again. Now the transaction that had never had its tax line item modified in the register has the "Form 1040 ..." tax line item (re)assigned. While the transaction that I manually modified to have no tax line item ... still has no tax line item.

    My conclusion is that modifying the tax line item of an individual register transaction assigns a tax line item that takes precedence over the tax line item in the Category List ... from that point on.

    It doesn't seem like that explains your problem, but if it does, there's no need to read on.

    I can't recall if this was mentioned already, but you can use the Banking > Transaction report to list transactions and their Tax Line items.


    "then selected the "More actions" button to the right of the transaction line. On that menu, I selected the "Tax Line Item Assignment" pick and changed that to the same item as the category list".

    But, I would not expect that to cause the Category List tax line item to change, or to change the tax line item assigned to other transactions. Also see above.


    There are a couple of incorrect assumptions in your posts.

    First: a validate will not find or correct every possible data corruption.

    Your problem could still be caused by some corruption even though you've run a Validate. I believe some users have reported that a super-Validate solved a problem that a plain Validate did not. You could try that, though I don't think that will guarantee to find/fix every possible corruption either.

    Second: the account in which a transaction is recorded definitely can affect whether the transaction appears in the Tax Summary report (and other reports). The Tax Summary report excludes tax-deferred accounts, by default. Not saying either of your accounts is necessarily tax-deferred, just that the account can matter.

    Third: there is no relationship between the "Usage" report initiated from the Category List and the Tax Schedule report. For example: the Usage report doesn't care whether the category has a tax line item asigned or whether the transactions it lists have the same tax line item as the Category List has, and it doesn't care whether a transaction is recorded in a tax-deferred account. There's no reason to believe that every transaction that appears in the Usage report will appear in every other report.

    The main reason for noting these is that it seems they may lead the discussion away from the need to find the conditions that create the problem.
    • Thanks for the input NoWayJose!  Welcome to the hunt!
      This is my second try at responding to you - I submitted the first one , answered the security question, it went away and never posted - just isn't my day.
      Please see my original post this thread, third sentence regarding creating a new data file, etc.  It didn't work either.

      I think that your testing confirms JM's suggestion that there may be a "linking" problem in the Fed Tax Category.  Now, how to confirm that, and better yet will it fix my problem.

      I understand that non-tax accounts will not appear in tax related reports.
      I think I now understand some of how the report process works - Correct me if I am wrong.  The Usage report in the Category List will report every instance of the use of a particular Category across Accounts within the data file regardless of tax status.  The same is true for the Payee report in the Payee List.  Now - Tax Reports depend on the "White Checkmark" placed in a transaction by selection of a Tax Line Item to delimit items which will appear in the report - Correct?  So, if there is something that is keeping the "Checkmark" from being recognised (either a data file corruption or program fault) then that item will never appear in the report.  Correct?

      Thanks again for your insightful input!
    I am a great fan of Carlos Santana - in particular a song called Black Magic Woman.  Well, she must live at my house because the problem is now gone!
    How?
    I deleted all of the Federal Tax payments from last year, then reentered them, made sure that the Tax Line Item in the Category List and the Tax Line Item in the transaction line itself were identical.  Then I ran both the Tax Schedule and the Tax Summary Reports - voila!  All transactions were right where they should be!
    Why - I think is has something to do with ensuring that the Tax Line Item in the Category list and the Tax Line Item in the actual transaction are identical - I think that a difference between these two (maybe a software linking problem as suggested by JM, or perhaps something missed when converting the file from Q2011) is the culprit.
    For all those who follow me looking for an answer:

    Make sure to check that both of those Tax Line Items are identical!

    For those who answered or commented, Thank You All very much!  I have learned a lot in this exercise, not the least of which is "Patience is a virtue".  I'm off to do my taxes.  Cheers!
    • Actually, I think that when you change the tax line item assignment in a transaction, that it makes sense for Quicken to assume you no longer want the tax line item assignment in that transaction to be controlled from the Category List.

      So I don't agree that Quicken's behavior in that case indicates any software problem.
    What Category was used on the tax payments?
    Does that Category have Tax Related checkmarked when you Edit it from the Category List?
    If so, what is the Tax Line item associated with that Category?

    I cannot duplicate what you report when I use a Category associated with Form 1040 - the selection I made was Form 1040:Estimated Tax, Qtrly - and my transactions show up just fine.
    • As further information regarding my Tax Summary Report problem - I have tried creating new Categorys that I relate to Federal Tax payments and then use that category to attempt to get the payment to show in the Tax Summary Report - no change.  Also, I am somewhat encouraged that I am not whistling in the wind by the other entries in the Community Forums which express the same difficulty that I am having.  How about it Intuit?
    • Tamara,

      Response keyed to your sentence lines:

      The Category used is Taxes:Federal, one of several sub-categorys including State, OASDI, etc.

      Yes, all entries have the red tax related check mark.

      The Tax Line item can be either Form 1040:Federal estimated tax, qrtrly, or W2:Federal tax withheld, self.

      You comment is what makes this problem so insidious - It might have something to do with updating from Q2011 to Q2012 prior to entering the Fed tax data - what is so baffling is the State data and Contributions all seem OK.  I am Available to discuss this in detail over the phone if you think that would help - and Thanks! for answering my plea!
    • It has nothing to do with the product version, since I've tested in all currently supported versions (and some that have been discontinued) with the same data file, but has everything to do with the actual tax line assignment.

      If you're saying that using the tax line assignment of Form 1040:Federal estimated, qtrly on the Category you used on your tax payments isn't resolving the issue of those payments not showing up, then you may be looking at a data issue; this tax line works fine in data files other than yours.

      However, if you're saying that you're expecting the transactions to appear when they use a tax line assignment not intended for use on the Tax Summary report, then we need to address why those tax line assignments aren't supposed to show up here.

      As for personal support contact, I am not a Quicken Support agent.  I'm an Analyst who investigates defects.  So far, I'm not seeing a defect in what you're reporting.  If you provide a case number from one of your support contacts on this issue, I can see if maybe I'm missing a detail not provided here that will help me see that defect.
    • Regarding the version, I didn't have this problem in previous versions of Q using the same data file either.  Since I don't know anything about the internals of the Tax Summary software I am unable to say where the problem may lie.  In the code, in my data file, or some other anomaly not yet considered.  

      If it is a data issue, what do you mean by that?  Is it possible that something is amiss in my data file that isn't being detected by the Validate process?  Also, all of the tax line assignments that I use I have been using for years without difficulty - why now?  

      And, repeating myself from my original post - Why can I do a report in the Category list or in the Payee list on these transactions and have them all appear there without a problem - leads one to believe that there is something funky going on in the Tax Summary section.  

      Lastly, you know as an analyst that just because you can't reproduce the problem there doesn't mean it doesn't exist.  I wish it would go away, but it won't - read the other posts from people having the same results - search on tax summary.  I unfortunately deleted the e-mails from my experience with India because I saw it as a lost cause.  Thanks!
    • * When I refer to a data issue, I mean something that would be resolved by Validate & Repair.  Data issues are problems with actual data - transactions, etc. - that has become unstable due to damage to the file structure.

      * Tax Summary is a simple report of data within your Quicken file and is not a separate software application.

      * Reports rely on specific conditions being met within data in order to be accurate.  The Tax Summary report, for example, looks for Tax Related flags (#1) and for the Tax Line Item (#2) associated with the Categories used on transactions.  Certain Tax Line Items may not report to the Tax Summary but will report to the Tax Schedule, depending on how you've setup your file.  If you don't see the information you're expecting to see on the Summary, run the Tax Schedule report to see if the data appears there - the issue may be as simple as correcting the Tax Line Assignment for the Category.

      * Yes, I'm very aware that just because I cannot duplicate something doesn't mean that it doesn't exist.  Without the proper Steps To Duplicate or appropriate troubleshooting being performed beforehand, it also means it could very easily NOT be a defect, but rather a usage or perception issue (which could also be due to "defect" of design of the area in question).  Until I have exact steps, I can't make that determination.

      * Lastly, I apologize that you were frustrated by your Support experience.  We're aware of many of the failings in the Support channel and work daily to try to improve that experience.

      To determine what you need to do to get past the issue with the Tax Summary report (from your original post):

      1.  Run the Tax Schedule report, which lists the transactions by Tax Form usage, to see if the tax payments appear there.

      2.  If those tax payments don't show up on the Schedule report, confirm the Tax Line Assignment for the Category (or Categories) you used on those transactions.

      3.  If they have an appropriate tax form association, such as I advised earlier on this thread, confirm if they are Transfers or not.

      4.  If they're Transfer transactions, try changing the setting of the Schedule (and/or Summary) report to "Include All" through Customize > Advanced.  Generally, Transfers are not considered as Spending or Income, as they're simply a record of moving funds from one account to another, which is why they're not typically shown on a Tax report.
    • I can't help but quote from Alice in Wonderland, "This keeps getting curiouser and curiouser!"

      Thanks again for your very detailed response Tamara - and for not giving up on me!  This has been a good learning experience so far, but I still haven't reached the goal of correcting the problem.

      First, let me respond to your latest answer, and then I will follow that with my latest results:

      I think we can rule out the "data issue" as I have run Validate on this file twice during this troubleshooting process, and it comes up clean.

      I understand your explanation of how the Tax Summary report works in selecting items for the report.  I'm not sure what you mean by "Certain Tax Line Items may not report to the Tax Summary but will report to the Tax Schedule, depending on how you've setup your file.", but that may take us off on a path with has nothing to do with my problem - ie we know that my problem is related to Fed Tax payments which should logically appear in both reports.

      Thanks for sticking with trying to find the source of this problem.  Re "Until I have exact steps, I can't make that determination."  I am doing my best to get you there.
      No need to apologize for India, we all know how that works - I used to have a buggy Dell computer!

      Now to my latest findings:

      I ran the Tax Summary as suggested - the missing data remained missing.  I then went to the Category list and edited both the Federal Tax and State Tax lines to use the Tax Line Item for Fed Estimated and State Estimated tax respectively.  Then I went to each of the tax entries (these are in two different accounts, but that shouldn't make any difference) and selected it, then selected the "More actions" button to the right of the transaction line.  On that menu, I selected the "Tax Line Item Assignment" pick and changed that to the same item as the category list (if it was different).  Then I exited the program, restarted it, re-checked a couple of those transactions to make sure they didn't "change", and then ran both Tax Reports.  Boo - No joy - the missing transactions are still missing!  

      To reiterate, the missing transactions (2) are Fed Tax estimated Payments, one made in April, and one made in Dec last year, in two different accounts.  The one made in April originally appeared just fine in the report until I deleted it, and then reentered it.  Thats when it disappeared from the Tax Summary and I was trying to prove that the problem was related to Fed Tax entries made in Q2012, not in Q2011.  That sorta makes the case for that theory in my mind.  At this point, I am ready to manually record these transactions, delete them, and then reenter them to see if they all go away as I suspect they will.

      Also, could you address why these transactions will appear just fine in a "Usage" report generated from the "Usage" column of the Category list?  Or, why they appear normally in the report done on the US Treasury Payee in the Payee list?  I can't get wrapped around why part of the reporting "sees" these transactions, but other parts don't?

      Thanks again for hanging in there!
    • From above post:
      "Then I went to each of the tax entries (these are in two different accounts, but that shouldn't make any difference) and selected it, then selected the "More actions" button to the right of the transaction line. On that menu, I selected the "Tax Line Item Assignment" pick and changed that to the same item as the category list (if it was different)."

      This observation is puzzling to me. If I am following correctly, you made the change in tax line assignment by editing the category in the Category List. You then found that this editing did not carry forward when you checked the category tax line assignment via the individual register transactions??

      Editing the category in the Category List alone should suffice to effect desired changes.

      Does this point to some sort of linking problem in the underlying data base?
    • JM,

      Thanks for jumping in here, I can use all the help I can get.

      You are exactly correct.  Even though I changed the Tax Line Item in the Category list, it did not necessarily change the Tax Line Item in each individual transaction entry in the register.  I just didn't watch it that close to be able to tell if that was true for the "missing" entries, but it sure was true for some of those which have never been "missing".  Perplexing!

    Similar questions other people found helpful: