• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Industries   Service Industries  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
113
beWbmyrfGr4yUOacwZ5xHE
Subscribe RSS
calitoyo
calitoyo
Questions asked: 3
Questions answered: 4
Points earned: 4
calitoyo
calitoyo
Questions asked: 3
Questions answered: 4
Points earned: 4
New Member
01/21/12 9:49am PST
Viewed by asker 01/21/12 11:46am PST

trust accounts; law firm client

US QuickBooks Pro for Windows

how do deal with trust accounts when dealing with retainers, invoices, applying payments to invoices from retainers and or making sure that it gets done

Solved!
Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
7 Replies
TomJones3
TomJones3
Questions asked: 5
Questions answered: 3
Points earned: 13
TomJones3
TomJones3
Questions asked: 5
Questions answered: 3
Points earned: 13
New Member
01/21/12 9:53am PST
The solution

As a retired attorney who used QB to track client trust accounts, I set each client up as a separate bank account, made deposits and withdrawals from each account separately, and then when the business was concluded with that client, closed out that bank account. If you need more detail than deposits and withdrawals, then set up each client as a separate QB company.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
10
 Report Abuse
 
 
 
calitoyo
calitoyo
Questions asked: 3
Questions answered: 4
Points earned: 4
New Member
01/21/12 10:22am PST

Hello Tom,

My name is Carlos, I am a freelance bookkeeper who is doing the books for a lawyer and I was wondering if I am doing it the right way. It is a little difficult to explain it in writting, but if you don't mind, maybe I give you my number so I can explain to you how I have been handdling the books and perhaps you can instruct me whether I should be doing it in a different way, or maybe I am doing it ok, or just needs a few changes.

Please advise.

Thanks!

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
TomJones3
TomJones3
Questions asked: 5
Questions answered: 3
Points earned: 13
New Member
01/21/12 1:51pm PST

 Carlos, please feel free to contact me. But, the easiest way to think of it is that client funds actually belong only to the client, so you cannot comingle the moneys with the attorney's funds. You need at least two separate actual bank accounts - one for the attorney's own funds, fees paid in, and to pay bills from. The second is for client funds ONLY - no attorney funds more than perhaps $100 to keep the account open during times when client funds are zero. 

As for client funds, you must keep an exact accounting of each dollar in and out. You can create a separate QB bank account for each client. Put client deposits into the actual client bank account, but account for them in the client's individual QB bank account. As you take dollars out, write checks against the QB account. 

To make it easier to account the actual bank account, I set up a separate QB bank account that I reconcile against the bank statements. To track that account, when making deposits to the client QB accounts, I a make an exact dollar deposit to the QB account that tracks to the actual bank account. That way, when I reconcile the actual account, I can track the "deposits" into the QB accounts by date and amount. 

I hope this is easy to follow. Please feel free to contact me at the above e-mail address for more info. 

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
Intuit Moderator
Intuit Moderator
Mod/Co-mod
qbteachmt
qbteachmt
Questions asked: 107
Questions answered: 43440
Points earned: 106584
Allstar, Accountant Community AllStar
01/22/12 9:51pm PST

Tom, your email address has been removed from your reply. If you want to be contacted, please complete your profile.

You can do trust accounting with one bank account, as everything in and out should also be tracked as a liability.

Search the forums, LauraD has posted her instructions lots of times for folks as reference.

If this post answers your question, please give a "thumbs up" or mark this Solved to let others know about it.

If you get an emailed Survey, please take a moment to follow up here, too. Thanks!
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
01/27/12 4:40pm PST
Latest post

Thanks, Michele  - I will follow up by posting my procedures here.

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
01/27/12 4:39pm PST

There are a few specific challenges with law firm accounting:

_Tracking advanced costs correctly when paid out of the Operating account
_Billing for those advanced costs to the client
_Tracking and billing for time, using as much or as little detail as required by the particular firm
_Tracking and billing for miscellaneous costs (phone, fax, copies, etc) that are not directly billable to the client ( $ for $ )
_And, most importantly, tracking and reporting the trust accounting to meet the requirements of the state/bar


For the trust accounting, you need to be able to answer the following 'tests' -

1) Does the trust bank account balance match the trust liability account balance?
2) Do you have a report listing each client's trust balance, the total of which equals the trust bank account balance?
3) Do you have a detailed ledger, for each client, which shows the specifics of the ins and outs of the trust monies? 

All of the above can be accomplished using QuickBooks, but specific procedures (see below) need to be followed and reports need to be created to meet the required standards.

Laura D

My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Advanced Certified ProAdvisor
Advanced Certified ProAdvisor
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks experts.
Certified ProAdvisor
Certified ProAdvisor
Certified ProAdvisors have successfully completed an extensive and rigorous QuickBooks certification program.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant community power users.
Allstar
Allstar
Advisory council of community power users.
ProAdvisor
ProAdvisor
Members of the QuickBooks ProAdvisor Program
Intuit Moderator
Intuit Moderator
Mod/Co-mod
Certified ProAdvisor - ES
Certified ProAdvisor - ES
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient Enterprise Solutions experts
Certified ProAdvisor - POS
Certified ProAdvisor - POS
These ProAdvisors have successfully completed extended training, distinguishing themselves as highly proficient QuickBooks POS experts
LauraD
LauraD
Questions asked: 153
Questions answered: 11826
Points earned: 21388
Allstar, Accountant Community AllStar
01/27/12 4:40pm PST

Trust accounting in QuickBooks is a little tricky and needs to be tracked using specific procedures in order to get good reporting for the Funds Held in Trust (escrow) detail by client.

Here is my general procedure for tracking trust accounts in QuickBooks (in QuickBooks Online version, the procedures are basically the same, except that you need to create sub-accounts to your liability account - 1 per client/matter ) -

Deposit the retainer/settlement check into the Trust/Escrow bank account, using a Funds Held in Trust (Escrow) liability account with the client name in the name field. I do this directly in the Make Deposit form, but you can enter a sales receipt, using an item which points to the liability account.

Then, write checks for any (non-law firm) disbursements of those funds, using the Funds Held in Trust (Escrow) account on the expense tab of that check - with the client name in the name field on that line. Or, if you want the detail of how those disbursements are made, create separate items, all pointing to that account, to indicate what that 'paid out' is for - Insurance, taxes, fees, etc.

Then, if applicable, invoice the client. . .for the professional fees (time or flat fee billings) and any advanced costs (previously paid out of the operating account) as separate items. . .

Then, cut a check from the Trust/Escrow bank account to the law firm, using the Funds Held in Trust (Escrow) account on the expense tab of that check - with the client name in the name field on that line.

Then, 'Receive payment', using the client name, and attach that payment to the open invoice.

Then, deposit the funds into the operating checking account, either directly from the payment, or via Undeposited Funds.

I have created a group of memorized reports to show the client trust activity and balances to use when reconciling/reporting client balances and/or the bank statement.

_I do not (usually) use items, invoices, or sales receipts for any activity directly involving the trust funds (although sometimes it is needed/useful, but needs to be setup and tracked specifically).

These are two completely separate areas of your business and the transactions need to be recorded as such. . .so much so that some law firms track their trust accounting in a separate QuickBooks file (although I don't see the need for that myself).

Note: There is no way to automatically show the trust balance on an invoice. You can, however, create a custom field, or enter a line in the description field, to notate the remaining trust fund balance. The amount will have to be manually entered on each invoice.

____________________________

Review the above procedure(s) step by step and confirm that this meets your state's regulations and reporting requirements.

If you still need help, I suggest that you contact someone directly for assistance.
You can search www.findaproadvisor.com if you want someone local.
Also - many of us work remotely and could be contacted via the info on our websites or profiles.

I hope this helps,

Laura D


                       
My motto:
Keep it as simple as you can. . .with only as much detail as you need.

When in doubt, make a backup first!!

*****
Laura Dion
Cents-able Bookkeeping, LLC

www.centsablebookkeeping.com
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
  • us quickbooks pro for w...
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
cwickw
3 mins ago
cwickw
replied to
URL for subpages
cwickw
7 mins ago
cwickw
replied to
Link not working
cwickw
8 mins ago
cwickw
just received a solution to
Link not working
ThreeBall
16 mins ago
ThreeBall
replied to
Cannot Restore from MobileM...
mmanju
27 mins ago
mmanju
replied to
receive a vendor refund check
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business