You don't mention which version of Timeslips you are running and that may make a difference, but try this.

Under Report, Clients, run the Client Info Listing report. It will contain a LOT of information on each client, but one of the fields is the Last Bill Date. Do not print it to paper or PDF, but "print" it to Excel. You should get a spreadsheet with each client on a row and each field in a column. Then either: 1) copy and paste the Nickname 1 and Date of Last Bill columns to a new sheet, or 2) delete all the extraneous columns so you are left with just the two you need.

Then you can sort the sheet by the Last Bill Date column to know how long ago you billed them.

Nancy Duhon, Esq.
Duhon Technology Solutions, LLC
Master Certified Consultant for Sage Timeslips
LawPay Partnered Consultant
Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
404-325-9779
[email protected]

This really works - thank you so much!  After some trial and error and printing to the screen, I discovered that the only field I needed to select in "Options" in order to have the last bill date show was "Show Arrangement Fields."  This eliminated a ton of info that I didn't need.  There were still some columns to delete in Excel, but not many - took me less than a minute to delete the unneeded columns.  So now I have a printable report showing just the client name and date of the last bill.  This will make it so much easier to clean up my active clients by changing their status to either inactive or closed (or just deleting some entirely).  Thank you again!

Hi crrlaw, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey

You cold also use the "Clients Not Billed" report as it is the reason it exists.