Skip to main content
Level 3
December 19, 2020
Question

Search Clients havent prepared returns for 3 years

  • December 19, 2020
  • 5 replies
  • 30 views

Good morning;

Does anyone know how to search (and delete) clients that havent been filed (or efiled ) returns for the last 3 years?  I'm just trying to clean up my software

Thanks

This topic has been closed for replies.

5 replies

Just-Lisa-Now-
Intuit Community Champion
December 19, 2020

I only transfer clients into HB from the prior year when I start working on their return, keeps all the dead wood out of my current years Homebase and my HB is easier to manage.

Or prior to transferring any clients into 2020, go into PS 2019 and organize your HB by 'Last modified date'  (just click on the HB column heading) then you'll see all the people that you didnt work on all at one end of the list.  Delete all those dead end clients and then transfer whomever is left from 2019 into the 2020 tax year.

This wont help with the 3 year part, I dont know how you would take the 3 years into the scenario.

♪♫•*¨*•.¸¸♥Lisa♥¸¸.•*¨*•♫♪
Intuit Community Champion
December 19, 2020

You could run a query on "tax prep fee not calculated", but you would have to do for each year

Level 3
December 19, 2020

Maybe you can search year by year  with taxpaye ssn? Just a thought

Accountant-Man
Level 13
December 20, 2020

I delete the returns after 10/15 each year for those who have not returned. Then I don't have them on the pro formas the next year.

** I am "Elevating with Intention!"
Intuit Community Champion
December 21, 2020

Try looking at the status for those only transferred. You can go into the return and look at the 5 year history.... as an alternative you can create  a version of home base that shows a column for your total fees per client for each of last 3 years... if you didn’t invoice them, you probably (hopefully) didn’t prepare the return.

If at first you don’t succeed…..find a workaround