Skip to main content
Level 1
November 20, 2020
Question

running a query

  • November 20, 2020
  • 2 replies
  • 19 views

I do not see the query for those paying the Net Investment Tax for 2017.  Is there such a query that I am missing?  Thanks.  Julie 3981

This topic has been closed for replies.

2 replies

IRonMaN
Level 15
November 20, 2020

I didn't go searching for it, but I trust your eyes and if you say you don't see it, I'm pretty confident it doesn't exist.

Slava Ukraini!
Level 7
November 20, 2020

Here's what to do -- I just asked myself the same question.

Select INDIVIDUALS as your home base view.

Then select column headings under "Homebase" from the menu

The choose AGI and dividends

Once you have those items in the home base view you can sort by AGI - looking at those with AGI over $250J.

Then review the list of AGI's > $250K and see who has significant dividends. If the dividends are large, then they likely have NII tax. Focus on those peeps. I'm going to send an email to those peeps and tell then of the opportunity (removing the NII) and the risk (my fee!).