How To Set Up Trust Accounting in QBO Advanced (WIthout LeanLaw) QuickBooks Online for Law Firms - YouTube

Channel: LeanLaw

[6]
This video will cover how to setup and use trust accounting and QuickBooks Online. this is the hard way without LeanLaw.
[12]
I'm going to cover five areas: chart of accounts, deposits,
[17]
creating invoices,
[18]
Paying invoices, and trust account statements. First is the chart of accounts. I have a sample account, here.
[25]
We can see two bank accounts: my operating account or checking account,
[29]
And then I have my IOLTA bank account where I keep my client trust money.
[33]
It's marked as a detail type trust account. that's important. so that's our starting point, two bank accounts.
[39]
To prepare QuickBooks for trust accounting, we need to create the liability account.
[44]
That's detail trust account liabilities that we'll call Funds Health and Trust. This liability account, here
[52]
Balances out the bank account, and they always need to be in balance.
[56]
But we use the liability account to keep track of to which client we owe which money. So that's the chart of accounts.
[63]
Next we'll go over how to record a trust deposit. the first thing is to add a client:
[69]
there it is our sample client. the temptation here is to do a receive payment or maybe a credit memo
[76]
But that is not the way to do it. what we have to do is first prepare the chart of accounts,
[81]
So that there's a sub account under funds Held in Trust for that client.
[84]
So what we're going to do is create another liability account with the detail type of trust account liabilities.
[91]
We'll name it for the client, sample client.
[94]
And then the key thing is making it a sub account under the funds held in trust liability account.
[102]
We see here that we have a sub-account and as we take money from the clients,
[106]
Sub accounts will appear under the funds held in trust and we can immediately see how much money out of the bank account
[113]
We account for which client. so that's preparing us for receiving a retainer from that client.
[119]
Next we create a deposit and this will be a deposit into the IOLTA or trust account.
[126]
And then we say that it's received from our sample client.
[129]
And this is the key thing here: the account for this deposit line item needs to be the sub account
[136]
Under the sub-liability account that we just created. this is absolutely key to keep track of the money correctly.
[142]
So we set that here we say received retainer. say it was check in the amount of
[148]
$5,000 press save. all right, now
[152]
We can see here in our chart of accounts that we have five thousand dollars in our bank account and that we show five thousand
[158]
Dollars under the sample client, so it means that they have five thousand dollars in our trust account.
[163]
Let's quickly create another client, another client, and then we'll create an account for them under the liability account
[171]
sub account of funds held in trust. save.
[175]
Now, let's clear another deposit.
[178]
For this client, we now set the account to their account under funds held in trust. it's another retainer. Let's say we got
[187]
$2,000 from these guys, and now let's look here. We have a clearer picture of the trust account.
[192]
Seven thousand dollars total. two thousand from the other client and five thousand from the sample client. you still with me?
[199]
Next is invoices. Let's create an invoice from one of the clients.
[205]
First one, new transaction invoice and we create some work, and we have two thousand dollars worth work now.
[211]
We have five thousand dollars in the trust account, but it doesn't show up here.
[217]
So I create the invoice here, and now we have an invoice of two thousand dollars for this client.
[222]
And his balance is two thousand dollars owed.
[226]
in QuickBooks,
[227]
You can't see the trust balance and the account balance in the same place.
[231]
To see the trust balance you have to go over to the accounting tab and see that he has five thousand dollars available.
[237]
I'd like to put that on the invoice. the only option is to use the memo field, down here to say something like,
[244]
current retainer balance five thousand dollars balance after invoice payment three thousand dollars.
[250]
Now the client understands that this invoice will be paid through the trust account.
[254]
For every invoice, you will need to manually update the memo field. next is payment
[260]
So how do we pay the invoice? there's an open invoice here for two thousand dollars, and I want to pay it through the trust?
[266]
We do a check where we pick the client here, sample client,
[270]
And we pick the IOLTA account as the bank account, and then we add a line item, here.
[276]
Where we reference the liability account for that client, here and say payment of invoice, two thousand dollars,
[284]
client, sample client and done.
[287]
And then the second step we need to do is record a payment of the invoice.
[292]
So we say for example, check,
[295]
payment invoice
[296]
$2,000, save. let's look at what that did in terms of our balances. now
[302]
The sample client, here, his account balance is zero and when you go to the chart of accounts, the IOLTA bank account balance is
[310]
$6,000 and the operating account balance is
[314]
$2,000. we transfer
[316]
$2,000 essentially from the trust account to our operating account.
[320]
So now it's our money essentially. from the liability side we now see that the client's liability is down to $3,000. so he has
[328]
$3,000 left that we're holding in trust for this one. It's all accurate.
[333]
The key thing is to have those two transactions go in and then also we need to then transfer the money from our bank account.
[341]
So that's a payment.
[342]
It's two transactions. the final step is trust statements.
[346]
At any moment you have to be audit ready. that includes always being able to account for the money in the trust account and giving
[353]
detailed statements of
[355]
transactions for each client.
[357]
If you want to see the summary of all client balances for your trust account, you can click the chart of accounts
[362]
showing a list of
[364]
Liability sub accounts. if you want to see the detailed transactions for a specific client or matter, you just click on their liability account.
[372]
Now there are some rules that differ by state with regard to how money is received.
[377]
It's important to go over these rules with your accountant or bookkeeper.
[381]
And that's trust accounting in QuickBooks Online without the help of LeanLaw.