IOLTA Audit

SOLVED

My client was randomly selected for a state audit of his IOLTA account. We followed their instructions and sent what we felt was more info than they asked for, but the auditor believes there is a $22,000 discrepancy in the selected months (I show a $7.86 discrepancy, which is an IOLTA interest sweep and we stated that).

Apparently we failed on the three point reconciliation. I ran a Funds Running Balance report from Timeslips and the IOLTA register with all detail from Quickbooks and cross checked everything. 

I have googled the info and came up with a document from my state (CT) and one from Trust Books. It sounds like I should do an Excel or even handwritten reconciliation to get the third point of reference. 

If anyone is familiar with IOLTA accounts I’d appreciate some input so we can resolve it to the states satisfaction.
Thanks so much
  • +1 in reply to D1D
    verified answer

    Whew, okay, let's see what I can answer based on this new information.

    v2017 is no longer available from Sage because that version is no longer supported. Many of the consultants have the old downloads in our libraries.  You can contact one of us about it.

    What version was he running? What version are you running? Remember that as a general rule, once a database has been opened/converted into a higher version that it cannot then be reaccessed by a lower version.

    Unclear what your scenario is from your post.

    As for the 3 errors.  You say "I have 3 checks that were payments on account and deposited into the Operating account correctly." That is just slightly confusing to me because usually when I see the words 'to account' or 'from account' that is a tell tale that the payment is going in or out of the trust/funds account.

    Are you saying they were just paying their bill? I.e., paying what they already owed as an A/R?  If so, then yes, it should have been deposited into Operating and posted as a regular PAY- Payment Thank You A/R transaction.

    Sounds like instead they were posted as Payments To Account into the Timeslips funds account. Okay, I can then understand why this would be "wrong." But it should leave you with $$$ in the funds account to apply to the billed charges as a PFA - Payment from Account. So it confuses me when you next say "All three clients are paid in full. I would think this is all set, but I have no entries in Timeslips showing the sweep of these funds out of the funds account and am unsure how to show that correctly. The clients do show a zero balance."

    Were the payments ALSO entered as A/R transactions? How did the balance get to zero without a payment?

    If they were double entered as an A/R transaction as well as a Funds Transaction, and you just need to empty the funds without affecting the zero A/R balance, I would use a Withdrawal transaction to remove the funds and leave A/R alone along with a nice description detailing the error and how the Withdrawal is being put in to adjust for it.

    Beyond that, this thread is getting a bit complicated to handle as a bulletin board thread.

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

  • 0 in reply to Nancy Duhon

    Hi Nancy, thanks for taking the time to reply. If you are suggesting we can talk, I am up for that.

    The three checks (they were done at the same time), yes they were paying their bill and *I* mistakingly posted it as Client Funds in Timeslips. And you gave me the clue I needed. While I put them in TS as payment to funds, and marked them on our sheet as payment to funds, I must've figured out my error and ALSO did a payment to account for each of those clients. I have no notes or emails about this so I can't explain why I didn't back out the funds entries right then.

    Two clients now have zero balances on AR, which is correct, but they are showing that they have funds. I will reverse those payments with a very detailed explanation.

    This gave the third client a double payment though, which I can see on the next set of bills. So I'll need to do the same and explain to the client, who thankfully is a good client and it wasn't a large payment. But still not a good error to make :( 

    I really think that clears up the most confusing part of my issues.

    I can deal with the IT stuff later, I just need to have a handle on these reports.

    Speaking of which, I was able to create a report that gave me the Funds Transaction listing in a format I liked, except I lost it in the crash. But I have a copy and can create it again.

    Now, is there any way to do a running total of ALL client payments, both AR and Funds? All the history reports I tried last week seemed to just print bills. Literally, a line by line list of all activity by client?

    Thanks again, I really appreciate your help!

  • 0 in reply to D1D

    <edit> I was able to reverse the ones who have the funds balance in error, but the third client who still does work with him, has a zero balance in both Funds and A/R at the moment. Reversing the wrongly entered entry would put their funds in the negative. Will this cause issues in Timeslips? Either way I do have the documentation for the review board.