Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

Search Clients havent prepared returns for 3 years

Level 1

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

Labels (1)
0 Cheers
5 Replies 5
Level 15
Level 15

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♥¸¸.•*¨*•♫♪
Level 11
Level 11

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

Level 2

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

0 Cheers
Level 11

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'm still a champion... of the world! Even without The Lounge.
Level 8
Level 8

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.

0 Cheers