TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Keyboard Shortcuts
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

What is an IOLTA Account? – Excel for Lawyers Tutorial

by Joseph Brownell / Tuesday, October 08 2019 / Published in Excel 2019, Latest, Microsoft, Microsoft Excel Training for Lawyers, Office 2019, Office 365
What is an IOLTA Account? - Excel for Lawyers Tutorial: A picture of a simple IOLTA account ledger created in an Excel worksheet.

What is an IOLTA Account?: Overview

            The question “What is an IOLTA account?” is a question many new lawyers ask. Legal professionals use an IOLTA, or Interest on Lawyer’s Trust Account, to hold client funds separately from the funds of a law firm or individual lawyer. An IOLTA account is an interest-bearing checking account. The interest earned from all IOLTA accounts within a state is pooled together to help low-income individuals afford legal aid.

            Lawyers use an IOLTA account in three main situations. First being when a lawyer receives funds from a client to perform legal services. Second being when a lawyer receives funds from a settlement that they must pay to a client. Third being when a lawyer receives funds or is otherwise holding property for clients that the lawyer has not yet earned or must return at a later date. A lawyer cannot hold their funds and the client’s funds in the same account. Therefore, they use IOLTA accounts to separate these funds and hold smaller amounts of money from clients for a short span of time.

            An important note to make here is that if a lawyer intends to hold a large sum of money for a client, or intends to hold the funds for an extended period of time, the lawyer should NOT place those funds into an IOLTA account but should rather place the funds into an account to be held in trust for that particular client.

What is an IOLTA Account? - Excel for Lawyers Tutorial: A picture of a simple IOLTA account ledger created in an Excel worksheet.

What is an IOLTA Account? – Excel for Lawyers Tutorial: A picture of a simple IOLTA account ledger created in an Excel worksheet.

            Our Excel for Lawyers tutorial shows how to perform basic financial tracking of an IOLTA account within an Excel workbook. Note that while it shows how to perform the tracking of these funds using checkbook register style worksheets within a workbook, doing this does NOT typically satisfy ALL of the IOLTA reporting requirements needed by the individual states. You will still need to consult your own state’s Bar Association or counsel to ensure that you are tracking and reporting the IOLTA account funds in accordance with their guidelines.

            It is important to note each state has its own rules of professional conduct regarding handling client trust funds. You should consult your own state’s Bar Association or counsel to ensure your setup complies with your state’s rules. Failure to comply could result in penalties. You can also find more information and resources about IOLTA accounts at the following link: American Bar Association IOLTA Resources.

What is an IOLTA Account?: Video Lesson

            The following video lesson, titled “IOLTA Basics,” helps to answer the question “What is an IOLTA account?” This video lesson is from our complete Excel for Lawyers tutorial, titled “Mastering Excel Made Easy for Lawyers v.2019 and 365.”

Tagged under: answer, attorney, basic, course, excel, Excel 2019, Excel for Lawyers, help, how, how-to, information, IOLTA, IOLTA account, iolta basics, lawyer, learn, microsoft, Microsoft Office, Microsoft Office 2019, Microsoft Office 365, Office 2019, office 365, resources, teach, training, tutorial, What is an IOLTA account

About Joseph Brownell

What you can read next

Set Line Spacing and Paragraph Spacing in Word – Instructions
Using Flash Fill in Microsoft Excel 2013
A picture showing how to select files in Windows 11 in File Explorer using a selection marquee.
Select Files in Windows 11 – Instructions and Video Lesson

 

Recent Posts

  • A picture showing how to import files to the Organizer in Photoshop Elements by using the “Get Photos and Videos from Files and Folders” dialog box.

    Import Files to the Organizer in Photoshop Elements – Instructions

    Overview of How to Import Files to the Organize...
  • A picture showing how to create keyword tags in Photoshop Elements by using the “Create Keyword Tag” dialog box.

    Create Keyword Tags in Photoshop Elements – Instructions

    Overview of How to Create Keyword Tags in Photo...
  • A picture of a user applying Haze Removal in Photoshop Elements.

    Haze Removal in Photoshop Elements – Instructions

    Overview of How to Use Haze Removal in Photosho...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Go to mobile version
Sale! $49 All-Access 0 Days 7 Hours 26 Minutes 20 Seconds      $199 $49 Entire Library!
See Deal