Assistance with Aged A/R Balances and Timekeeper Reports

Two questions here:

1. On the Aged A/R Balances Report, is there a way to keep clients with credit balances from showing up, so only amounts owed to our office appear on the report? Or alternatively is there a way to group the data so that all debit balances are together with a total, and all credit balances are together with a total?

2. How can I set up a timekeeper activity report that shows a breakdown of how each timekeeper spent their billable hours in a given time period, in terms of tasks? I.e. Timekeeper A had 30 total billable hours; 5 hours spent on Estate Planning; 15.5 hours on Real Estate; 1 hour Correspondence, etc.

Thanks!

  • 0
    1. If you have negative numbers in your A/R report, it is an indication that you may not be using the Client Funds function correctly. Are these negative numbers prepaid retainers that are being worked against? Are those retainers being deposited in your IOLTA account? A/R should only show activity related to your Operating Account.

    As a quick work around, you can filter the report for only clients who have at least a $.01 balance (effectively filtering out the negative numbers.

    2. Take a Slip Summary report. Filter it for date range, time slips (vs. expense slips), only billable slips. Sort it by Timekeeper, then by Activity. That should give you what you ask for.
  • 0 in reply to Nancy Duhon
    Thanks for your assistance. Your recommendations for the A/R report worked perfectly. However the Slip Summary Report is giving me far more information than I'm seeking. Hoping you can provide followup advice!

    I used to use Timeslips for Macs in the 90's and we were able to run a report called something like "Timekeeper Activity Report" that was simple- 1 or 2 pages. It showed only each timekeeper, how many hours they billed that month, and how their time was broken down by task. The report I got from your suggestions was way longer and shows much more information.
  • 0 in reply to Law Office of David Hellman
    Look under the Options button on the lower left right before you print it to see what can be suppressed.