• You've already voted on this page
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
04/19/2013 at 09:23AM PDT
HTML Generator Sample Page

Need to verify a charge from Intuit? You can now retrieve the last 90 days of your Intuit order history from the QuickBooks Support Site

We are working on making some changes to the forums, in an effort to make valuable information more accessible. If you have 10-15 minutes, we would love to get your input through this survey. 

70
113
bcw8FOabyr4jZHacfA8pyY
Subscribe RSS
   
QBfreak
QBfreak
Questions asked: 17
Questions answered: 30
Points earned: 40
QBfreak
QBfreak
Questions asked: 17
Questions answered: 30
Points earned: 40
Contributor
12/04/10 6:25pm PST
Viewed by asker 01/18/11 10:14am PST

Trust Accounting: General Journal Entries for expenses using accrual accounting?

US QuickBooks Premier

For trust accounting (IOLTA or otherwise), what are the General Journal Entries to recognize an expense, create an accounts payable for the expense, and pay for the expense?

My customer has a Client Trust Account (asset) and a Client Trust Liability Account (other current liability). When I record a cash disbursement to a third party, I debit (decrease) the Client Trust Liability Account and credit (decrease) the Trust Account. But before the cash disbursement, I must first recognize the liability for the expense. I want to debit (increase) the Messenger Fee Expense account for example, and credit (increase) an accounts payable account. But now I'm stuck because my first entries do not affect my Accounts Payable account that recognizes the expense (matching principle). Where am I going wrong here? Am I supposed to have three journal entries? What are they?

I found what seems to be a solution from LauraD.   I think this is what Laura is saying, but I'm not sure. 

1. ENTER THE BILL

Debit: Expense                              $100
        Credit: Client’s A/P                                  $100

2. PAY THE BILL

Debit: Client Trust Liability            $100
       Credit: Client Trust Balance                     $100

3. ENTER A CREDIT FOR EACH PAID BILL (USING THE A/P OFFSET ACCOUNT) AND APPLY THE CREDIT TO THE BILL

Debit: Client's A/P                          $100
       Credit: A/P Offset                                      $100

Is this right? And if so, does this comply with GAAP or any official statement from FASB?

Anyone know how to get LauraD's take on this? Thanks.

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
5 Replies
qbteachmt
qbteachmt
Questions asked: 113
Questions answered: 53515
Points earned: 131605
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: 113
Questions answered: 53515
Points earned: 131605
Allstar, Accountant Community AllStar
12/05/10 11:58am PST

You don't use Journal Entries when customer and vendor names are required as part of the transactions. You use the real functions:

Enter Bill - this is how you will enter that services or goods were purchased from others. You can use Write Check, if you paid it at the time of the service. Otherwise, Enter Bill is followed at a later date by Pay Bill.

Either method works for you to enter on the Expenses or Items tab, then select the client's name, and the checkmark indicates Billable to the client.

The Trust account is not an Asset, it is a bank account.

The Liability account is the offset for amounts in the trust bank account.

Once entries are billable back to clients, you can use Statement Charge or Invoice. Both methods allow you to use Add Time & Costs, and pick up the entries marked billable to this client. Using an Invoice allows you to pick up all the pending charges onto one form that is dated for due date tracking. Statement charges and invoices both hit AR.

Then, you have open charges in AR for the client. Here Laura and I have differing methods for satisfying the AR with trust funds and reducing the liability account. Laura likes to write a check in QB from the trust account, made payable to the client, using the liability account on the expenses tab. On the actual check, make it payable to the firm. Use it to Receive Payment for the client name against the invoice or open charges.

I use an Other charge type of item to manage liabilities. You can read about this in the Help system. Search on Trust accounts, Customer Deposits or Prepayments or Retainers.

As long as every transaction that hits the liability account has the client name associated with it, you have an auditable account.

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
 
 
 
QBfreak
QBfreak
Questions asked: 17
Questions answered: 30
Points earned: 40
Contributor
12/05/10 5:17pm PST

Thank you for that great answer. I'm new to Quickbooks (less than 30 days). I'm used to doing it the old school way with general journal entries—pre-computer days. I do want to use QB's functions. For learning purposes, I am curious what the journal entries look like when you use the functions above vs Laura's method.

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: 154
Questions answered: 12242
Points earned: 22281
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.
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant 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: 154
Questions answered: 12242
Points earned: 22281
Allstar, Accountant Community AllStar
01/14/11 7:08pm PST

I would not enter bills for client expenses which are paid out of trust funds.  If the trust funds are there, simply pay them.

Keep it simple.

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
 
 
 
qbteachmt
qbteachmt
Questions asked: 113
Questions answered: 53515
Points earned: 131605
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: 113
Questions answered: 53515
Points earned: 131605
Allstar, Accountant Community AllStar
01/17/11 9:58pm PST

For any transaction in QB, open it. Then, use Ctl+Y to see the journal view of the data flow.

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.
1
Reply to this Answer
 Report Abuse
 
 
 
LauraD
LauraD
Questions asked: 154
Questions answered: 12242
Points earned: 22281
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.
Allstar
Allstar
Advisory council of community power users.
Accountant Community AllStar
Accountant Community AllStar
Advisory council of Accountant 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: 154
Questions answered: 12242
Points earned: 22281
Allstar, Accountant Community AllStar
01/23/11 6:32pm PST
Latest post

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 -

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).

____________________________

Review the above procedure(s) step by step.

If you still need help, you might want to contact someone directly for personal help.

Many of us do this as a business 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
  • quickbooks premier
  • 2011: accountant
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
cwwang
3 mins ago
cwwang
posted
account for llc franchise t...
in: QuickBooks for Mac
M3tech2
22 mins ago
M3tech2
replied to
QB DB-only install creates ...
in: QuickBooks Networking & Use...
jlm41
24 mins ago
jlm41
posted
Government auditor asking f...
in: Reports & Report Center
rc4kids
26 mins ago
rc4kids
posted
remote access waffle screen...
in: QuickBooks Performance Issu...
SURFERTOM99
31 mins ago
SURFERTOM99
replied to
Quickbooks pro 2013 crashes
in: QuickBooks Performance Issu...
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
© 2013 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