How To Automatically Create Custom Documents With Clio Templates

Simple Document Automation with Clio

One great feature about Clio – but often underutilized – is Clio’s simple and easy document automation process.  This article will show you, step-by-step, how to do simple and easy document automation in Clio.  I highly recommend you open up Clio and walk through this tutorial yourself in real-time.  If you don’t already have a Clio account, you can register for a free trial here.

Step 1: Figure Out What Custom Data (“Fields”) You’ll Be Using.

First, you’ll need to understand what data you plan to use in your document.  A piece of data is called a “field,” and you fill in “fields” every time you create a new matter or contact; all that information you enter into Clio becomes a field.  Frequently used fields include client names, client addresses, matter numbers, and the like.  It can also include insurance claim numbers, bail bond amounts, spouse’s names, and more.  To see what fields already exist in your Clio database, go to Settings > Documents.  You can view the complete list of available fields there.

Clio Settings data-srcset= Documents for checking list of template fields” width=”720″ height=”479″>

Clio Template Fields

Now, compare that list to the custom data you’ll need for your document automation.  Use Ctrl + F (Windows) or Command + F (Mac) to search the list for any fields you plan to use.  If they’re all there, you can skip Step 2.  But, if you need any custom fields, make those in Step 2.

Step 2: Set Up Clio Custom Fields.

Custom fields are one of the tools that make Clio’s document automation extremely powerful.  You can automatically drop any data you like into a Clio-generated document.  If the data isn’t already in your fields list (which we checked in Step 1 above) – such as an executor or personal representative – you’ll create a custom field.  For each custom field that you’ll need, do the following.

In Clio, click Settings > Custom Fields:

Clio Settings - Custom Fields

Now, click the green “Add” button in the upper right.

Clio Custom Fields - Add

Enter the name of your custom field, and the type of information that will go there.  For example, if you are adding the field Personal Representative, the “Type” will be “Contact Select,” because you’ll be selecting the Personal Representative from your Clio contacts.

How To Add Clio Custom Fields

There are a few additional options:

  • Default: Use this if you want this field to appear in every new matter you create.
  • Required: Use this if you also want it to be required for every matter.  Note that, if you check this box, you should also check “Default,” or else you may get errors when trying to create matters.

Repeat this step for each custom field you’ll need.

Step 3: Prepare Your Document Template.

Now that we have all the custom data we’ll need, it’s time to prepare our template.  To do this, go back to your list of document fields in Settings > Documents.  Keep that window open.

Now, move into Word (or Excel or PowerPoint for the appropriate document type), and open the document that will be your template.  Type out your letter, cover sheet, contact form, or whatever the particular document is.

Now, click back to Clio.  Find the field you want to insert, and click the little clipboard icon next to it to copy that field to your computer’s clipboard.  Pro tip: Having trouble finding the filed you need in that long list?  In Clio, type Ctrl + F (Windows) or Command + F (Mac) to search the list.

 

Using Clio Custom Fields In Word Templates

Go back to your Word doc. Place your cursor where you want the field data to appear in your letter, and click Ctrl + V (Windows) or Command + V (Mac) to paste the field’s placeholder.

Clio Document Automation With Word - Where To Click

Repeat this process for each piece of custom information in your document.

Clio Custom Automated Document in Word

Now, save your document as a Word document (.doc or .docx – do not save as a template, .dot or .dotx).

Step 4: Upload Your Template To Clio

Once you’ve inserted all your form fields using the process above, upload the doc back to Clio.  To do this, click back over to Clio, and click Documents > Templates.  Then click the green “Add” button.

Upload automated document template from Word to Clio

Choose your file, and select your document category.  Click Save.

Upload automated document template to Clio

You document is ready for future use!

Step 5: Automatically Generate Custom Documents In Clio!

Despite the number of steps above, when you walk through it, you’ll find that the document preparation process is pretty efficient, and goes pretty quickly.  Which is good, because it means it won’t be long until you’re using your custom documents.  To do so:

Click Documents > Clio.  Click the little arrow next to “New,” and click “Document from template.”

How to create a new automated custom document in Clio

Select your template, matter, and output format (PDF, Word, or both).  Click “Create.”

How to create an automated custom Word or PDF in Clio

When the document is ready, Clio will tell you to refresh your browser. You can do that, but it’s usually easier to go straight to the matter for which you just generated the document. To go straight there, type the first few letters/numbers of the matter number into the search box at the top, then click the matter when it appears.

It's easiest to access automated Clio Word and PDF documents from the specific matter

In the matter, click Documents > Clio.  Click the folder that matches the document category you selected above.

How to access custom automated work and pdf documents in Clio

Click the name of the document to download a copy and review or edit.  Or, if it’s ready to go, click “Share” to send the document straight to the client via Clio’s secure portal, or by email.

How do you use document automation in Clio?  Engagement letters, wills, powers of attorney, corporate resolutions, articles of incorporation, operating agreements, contracts, licenses…. Pretty much anything you re-generate based on old documents is a great candidate for document automation in Clio.

Want to give Clio a free spin?  Get your free trial account here.

Reconciling Client Trust Accounts In Clio

Performing an ethics-compliant, three-way trust accounting reconciliation in Clio is easy when done correctly.

Step 1: Ensure Your Individual Clio Trust Balances Match Your Bank Statement

First, make sure you’ve received your bank statement for the month.  Reconciling with Clio works best when you receive a paper or PDF bank statement, rather than a download of transaction listings.  Using the actual bank statement, it is easier to compare balances.

Print a Trust Listing Report.  In Clio, select the tab for Reports, then click Trust Listing.  Settings for the report should be as follows:

  • Uncheck “Show clients with zero balance”
  • Select the button for “All Clients”
  • Select Practice Area: All
  • Select Date Range: Custom: Leave the start date blank, and set the end date as the date of your statement
  • Output Format: CSV
  • Click “Generate Report”

The report will automatically download, and you can typically find it in your downloads folder.  Move it to your trust reconciliation file, and save it there.  Now open it.

If you have more than one trust account, you’ll have to delete all the other trust accounts from this report, so that only the trust balances for the account you’re reconciling remain.  If you don’t have more than one trust account, skip this paragraph.  To do this, sort Column B (the Account column) A > Z.  (Place your cursor in Column B; click the Data tab; and click the screen-shot-2016-11-22-at-10-22-12-ambutton.)  Delete all lines in the spreadsheet that contain any account other than the one currently being reconciled.  Do you agree with me that it would be nice if Clio’s report feature would let us select a certain account so we don’t have to do this deletion step?  Please email them and let them know.

In Cell E1, enter the following formula: =SUM(D:D)  Hit enter.  The number Excel spits out in the cell should equal the Ending Balance on your bank statement.  When it does, the first of your three reconciliations is complete.

Step 2: Ensure Your Bank Account Activity Report Matches Your Bank Statement.

Print a Bank Account Activity Report.  In Clio, select the tab for Reports, then click Bank Account Activity.  Prepare your report with the following settings:

  • Trust Accounts: Select “Specific Account,” and choose the correct account
  • Select Practice Area: All
  • Select Date Range: Last Month (unless your bank statement doesn’t run with the calendar month, in which you’ll select “Custom” and enter the same dates as your bank statement)
  • Check the box for “Include Opening Balance”
  • Do not check the box for “Display Matter to Matter Transfer Transactions”
  • Output Format: PDF

Click “Generate Report” to download it, move it to your reconciliations folder, and open it.  Ensure that the opening balance matches the opening balance on your bank statement.  Ensure the closing balance also matches your statement.  Finally, check to ensure that all transactions showing on your bank statement appear on your report (which they should, if the opening and closing balances match).

Step 3: Ensure Your Bank Account Activity Report Balance Matches Your Trust Ledger Balance

If you’ve performed the two steps above and the ending balances match, then this step is already complete: compare the total balance on your Trust Ledger Report (which was calculated in Cell E1 in Step 1) with the ending balance in your Bank Account Activity Report.  When these two balances match, your three-way reconciliation is complete.

Not currently using Clio?  Try it for free.

Skepsis would love to perform your monthly trust reconciliations for you, whether or not you’re using Clio.  Please email email us at [email protected].  Gain more great insights by subscribing to our newsletter below.