Federal/state tax expense downloaded in investment accounts missing from category reports

Bob@63
Bob@63 Member ✭✭
edited October 2018 in Investing (Mac)
Running Q-Mac 2018 v. 5.4.4 (Build 54.21024.100), I notice that tax withholding expenses in Vanguard investment accounts don't roll up into summary year-end expense-category reports. The transaction amounts download correctly, but I do have to manually assign the correct tax expense category to the taxes Vanguard withholds from my retirement account distributions. However, when I run year-end summaries for income & expenses, the withheld taxes from the investment account distributions don't appear in the total tax paid for the year.

There are various ways to work around this, but they involve manually transferring the gross distribution to my banking account, then charging each withholding amount (again manually) to the bank account. Very cumbersome and time-consuming and obviously non-optimal. 

Any insights from Quicken on when this issue might be fixed? 

Comments

  • RickO
    RickO SuperUser, Mac Beta Beta
    edited October 2018
    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • John Burgess
    John Burgess Member ✭✭
    edited January 2018
    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.
  • Unknown
    Unknown Member
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    This is exactly what I do. Note the TXF export to TurboTax (or other Tax Apps) is broken. It includes all investment accounts even the non-taxable ones. So the TXF file would probably include your Federal and State withheld taxes but it also include all dividend and sells of securities. Not good. It makes the TXF export nearly impossible to use especially when you have hundreds of sells in your retirement account(s).
  • Bob@63
    Bob@63 Member ✭✭
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Here is a shot of one recent withholding transaction for a distribution from an IRA. It was downloaded as shown, with one exception: The category, as downloaded, was Tax:Fed, which I assume is a Quicken category I don't use. I changed the category to the custom one I use for this type of withholding: Taxes:CA Income Tax:RJR:IRA. image
  • Bob@63
    Bob@63 Member ✭✭
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    @John Burgess: Yes, it's an IRA account, but I'm puzzled by your comment about understanding why IRAs are excluded from tax reports. Or perhaps you aren't clear about how IRAs work. The money in them is indeed taxable, however it's tax-deferred until the money is actually withdrawn (or distributed). The owner of an IRA (or his or her heirs) will eventually pay that tax at the ordinary rate for the tax year in which the distribution is made, as well as penalties if the owner hasn't reached age 59-1/2. 

    Ordinarily, financial-services providers require withholding of applicable federal and state/local income taxes at the time the distributions are made. 

    I do hope the coders at Quicken have employed a higher degree of sophistication in writing the software for handling IRA accounts.  :-) 
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Bob, which report are you using? Are you using the Tax Schedule report? I do concur that a Misc Exp transaction in a taxable category in an IRA account fails to show up in the Tax Schedule report while the same transaction in a brokerage account does show up. That does seem problematic, but perhaps there's some reason it was designed this way. You may want to report it via menu Help > Report a Problem.

    Another option for you is to use the Category Summary or one of the New Reports. These transactions do show up in those reports. 
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Bob@63
    Bob@63 Member ✭✭
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Rick, I'm not using the Tax Schedule report. The particular report I'm generating is a Year-to-Date income and expense report, created at New Report ==> Summary Report ==> By Category, Interval = Month, with the date range set at 1/1/2017-12/31/2017. However, I am pretty certain that categorized expense charges recorded in any investment accounts are not rolled up in any reports, custom or standard.

    The only workaround I've been able to come up with so far would be to enter the withholding charges manually as deductions from the gross proceeds of the distribution when they are transferred into my bank savings account. Those charges then scroll up into any reports I might need to generate through Quicken. 

    I've been hoping that Quicken Marcus or some other Quicken employee would acknowledge the need for a fix at some point, but of course I understand Quicken doesn't often provide such guidance. 

    I appreciate you offering your expertise. I took your advice to report it as a bug or design flaw via Help ==> Report a Problem. 
     
  • John Burgess
    John Burgess Member ✭✭
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    Perhaps I wasn’t clear. Dividends, interest and capital gains within an IRA are not taxable, so for that reason IRAs are not included in Quicken’s annual tax reports.

    Distributions are taxable, but because of th above if you record the tax on the IRA side of the transfer it isn’t included in the report, thus the accommodation to transfer the whole amount and record the tax in the non-qual account.
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Hi Bob,

    Thanks for providing the exact report you are using. You are not likely to get a response here from a Quicken employee. You can contact Quicken Support if you want. However, I don't think there's a bug or design flaw with respect to this report.

    Here's a transaction that I entered in an IRA account that's pretty much identical to yours:

    image

    And here's Category Summary by Month report, generated in the same manner as yours:image

    As you can see, the transaction is included in the report. 

    Thinking about what might be happening with yours, I'd like you to try this: Open the report then click on the Customize button. Then click each tab (Accounts, Categories, Tags and Payees) and click NONE. (Yes, NONE, not ALL). Click OK and then check if the amount is now included in the report.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    It turns out that it's not the Tax Schedule report that's giving Bob problems and so the whole discussion about including/excluding IRA transactions is moot.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Bob@63
    Bob@63 Member ✭✭
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    All correct. The problem here is that Vanguard (and I’ll wager most major financial-services companies) perform the actual withholding and report it to the government — and that’s reflected in the transaction downloaded from Vanguard. The work-arounds of recording the transaction in a banking account is not only time-consuming and cumbersome, they don’t reflect reality. Thanks for your comments on the subject.
  • Unknown
    Unknown Member
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    I commented early about Export Tax Report being a problem. I just found out that you can generate a TXF file in two ways. One is from the File menu "Export Tax Report..." and the other is from within the "Tax Schedule" under Reports. On the Mac you should only use the TXF file generated from within the "Tax Schedule" Report. The one generated from under the File menu contains items from non-taxable Retirement accounts.
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    Good observation and nice catch!
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Bob@63
    Bob@63 Member ✭✭
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Rick, you're a masterful trouble-shooter. That works perfectly. The report now appears to include all transactions, including the custom ones set up for recording withholding from retirement accounts.

    However, I hope you'll forgive me for being mystified about Quicken's controls for setting custom report parameters. Why does a report filter set to include/exclude transactions according to various parameters return ALL transactions only when NONE is selected for all parameters. Maybe I'm being obtuse here, but that strikes me as exactly contrary to what I would expect. Am I misunderstanding the workings of the filter controls? I'm happy with your solution, but it still seems reasonable to me that a report returning ALL transactions, regardless of Account, Category or Payee, would be set to ALL for each of those parameters in the date range. 

    Or should I just accept that I'm never going to pass the qualifications test for joining the Quicken product-design team? 
  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    ALL only gives you transitions for which one of the checked items matches something in the transaction. This is almost the same, but NONE will give you different results in these cases:

    1) ACCOUNTS: ALL and NONE are equivalent (because every transaction is part of some account)

    2) CATEGORIES: ALL and NONE are equivalent, because there's an item "Uncategorized" in the list which gets check when you choose ALL.

    3) PAYEES: ALL and NONE are almost equivalent, except that ALL will exclude transactions with a blank payee field (because "No Payee" is not in the list). This is, of course, a rare situation and so rarely causes a problem.

    4) TAGS: This is where the trouble lies. Because there's no "Untagged" option in the list, when you click ALL you do not include every transaction that has at least one Tag, but you excluded untagged transactions. Since users usually have many untagged transactions, this causes frequent problems and confusion.

    We've been lobbying for Quicken to include an Untagged item in the Tags customization list. I've been told that a redesign of the customization screen is being designed. So hopefully this will be fixed fairly soon. 

    In the mean time, just click NONE, NONE, NONE, NONE.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • J_Mike
    J_Mike SuperUser ✭✭✭✭✭
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    @RickO et. al.

    Re Item 3) PAYEES

    Another factor that comes into play here involves investment transactions.
    Security names appear to be in a separate database field - separate from Payees.
    Thus, selecting All Payees excludes transactions involving securities.

    Example; Dividend income from securities will be excluded if the user selects All Payees. It is included when the user selects None.
    QWin & QMac (Deluxe) Subscription
    Quicken user since 1991

  • RickO
    RickO SuperUser, Mac Beta Beta
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Ah, good point.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • Bob@63
    Bob@63 Member ✭✭
    edited January 2018
    RickO said:

    How are the tax withholdings shown in the Vanguard account? Please post a screenshot of one of the transactions, opened for edit,

    Oy, vey. I'm beginning to get a glimmer of understanding of how massively complex a challenge Quicken faces in creating a robust product experience for its customers -- each of whom seems to want something different. Meanwhile, your efforts are tremendously helpful in deepening my understanding of the product.

    It's very much appreciated. 
  • John Burgess
    John Burgess Member ✭✭
    edited January 2018

    Is it an IRA account? What I’ve done with Ira withdrawals is enter a transfer to my taxable brokerage acct, and use splits on the table side to record the withholding. Not intuitive, but since IRAs are not taxable, I can understand why they are excluded from tax reports.

    @bob - I agree that doing the tax recording on the non-qual account is a hack, and that financial institutions ( I have Ally and Fidelity) do it correctly, in the IRA. Maybe quicken will fix it someday. [ is anybody listening? ]


    @bruceG - thanks for pointing out that there are two _different_ TXF exports. I’ll have to remember that!!
This discussion has been closed.