Reports FAQ

In this article:

• What is the Operating Bank Journal report?
• What is the Trust Bank Journal report?
• What is the Transfer Journal report?
• What report shows Client, File and Vendor listing?
• What is the Ledger report?
• What report shows billings and outstanding balances or accounts receivables (AR)?
• What report shows adjustments made to an invoice?
• What report shows payments or collections to an invoice?
• What report shows my accounts payable?
• What report shows payments applied to payables?
• What report shows all transactions to vendors? 
• What report shows time and fee entries?
• What report shows costs or disbursements?
• What report can show changes made to entries?

What is the Operating Bank Journal report?

Operating Bank Journal report shows all operating bank entries.

To access the Operating Bank Journal report:

1. Go to Reports > Banking >Operating Bank
2. Click the dropdown arrow to select op (Operating Bank Journal), or another view that you need:
   • cash in - A list of all payments with a payment method of cash that exceeds a specific amount that have come in from any or all operating accounts in the selected duration.
   • history - All activity plus any changes made to the entries during a specified period for any or all operating account(s).
   • register - Operating Register

3. Set the required report parameters such as:

   • Date
   • Bank Account
   • Entry Number
   • Amount Over
   • Flow of Funds (In, Our or Both)
   • Reference (Receipt or Cheque Number)
   • Received From/Paid To
   • Payment Method

4. Select the output under Generate to.

5. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What is the Trust Bank Journal report?

Trust Bank Journal report shows all trust bank entries.

To access the Trust Bank Journal report:

1. Go to Reports > Banking >Trust Bank
2. Click the dropdown arrow to select trust (Trust Bank Journal),or another view that you need:
   • cash in - A list of all payments with a payment method of cash that exceeds a specific amount that have come in from any or all trust accounts in the selected duration.
   • history - All activity plus any changes made to the entries during a specified period for any or all trust account(s).
   • register - Trust Register

3. Set the required report parameters such as:

   • Date
   • Bank Account
   • Entry Number
   • Amount Over
   • Flow of Funds (In, Our or Both)
   • Reference (Receipt or Cheque Number)
   • Received From/Paid To
   • Payment Method

4. Select the output under Generate to.

5. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What is the Transfer Journal report?

Transfer Journal report shows all transfer entries from and to all bank accounts.

To access the Transfer Journal report:

1. Go to Reports > Banking >Transfer
2. Click the dropdown arrow to select transfer (Transfer Journal), or another view that you need:
   • history - Transfer history plus any changes made to the entries during a specified period for any or all bank account(s).

   • op f to f - File-to-file transfers made to any or all operating accounts during the specified date range.

   • op to op - All operating-to-operating bank transfers for any or all accounts during the specified date range.

   • op to tr - All operating-to-trust transfers by specified date or account.

   • payments - Shows any entries where operating retainer monies were applied against receivables within the specified date range.

   • tr f to f - File-to-file transfers made to any or all trust accounts during the specified date range.

   • tr to op - Displays all trust-to-operating transfers by date or account.

   • tr to tr - All file-to-file transfers made to the trust account for the range specified.

3. Set the required report parameters such as:

   • Date
   • Bank Account
   • Type (Transfer type)
   • Entry Number
   • Reference (Receipt or Cheque Number)

4. Select the output under Generate to.

5. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows Client, File and Vendor listing?

Contacts report lists clients, file and vendor details.

To access the Contacts report:

1. Go to Reports > Contact > Contacts
2. Click the dropdown icon to open the Contacts Options window.
3. Click the View field and select the type of Contacts report that you need from the following options:
   • active files - Creates the All Active Files report that lists contacts (clients) with active files. 
   • all - Creates the All Contacts report that lists all types of contacts and their associated files, if any.
   • all files - Creates the All Files report that lists contacts with their files regardless of the file status that includes lawyers assigned, Area of Practice and Rate Group.
   • clients- Creates the All Clients Without Files Listed report that lists contacts (clients) details without the file's information.
   • closed files - Creates the Closed Files report that displays all contacts with closed files.
   • other - Creates the Other Contacts report that lists all contacts who are not clients, no files and not vendors.
   • vendor - Create the Vendors report that lists all vendors.

4. Set the required report parameters such as:

   • Open Date (Range)
   • Closed Date (Range)
   • File
   • Responsible Lawyer
   • Either Individual, Group Contact or both
   • Contact
   • Area of Practice
   • Department
   • Contact Tag
   • Casefile Tag

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What is the Ledger report?

Ledger report shows details, transactions, and all entries made to a file.

To access the Ledger report:

1. Go to Reports > Contact > Ledger
2. Click the dropdown icon to open the Ledger Options window.
3. Click the View field and select the type of Ledger report that you need from the following options:
   • cash in - Creates a Cash In report that lists all files that have received a cash payment over a specified amount.
   • client wip - Creates the Client WIP, Billing and Collection Summary that shows files' WIP, Billings, Collections and Adjustments.
   • client wip referral - Creates the Client WIP, Billing and Collection Summary that shows files' WIP, Billings, Collections and Adjustments with Referral Sources.
   • costanalysis - Displays all details of costs entered for a file separated into columns: "Soft" for Soft Costs, "Advanced" for Hard Costs (except Payables), "Payables" for any payables entered with a file, "Tot. Hard" which adds the Advanced + Payable columns and marks with a check if the entry has been billed. 
   • costanalysissummary - Displays totals of costs entered for a file separated into columns: "Soft" for Soft Costs, "Advanced" for Hard Costs (except Payables), "Payables" for any payables entered with a file, and "Tot. Hard" which adds the Advanced + Payable columns. 
   • expenses - Displays any hard or soft cost expense entered within the date range specified. 
   • expensesint - Displays any soft or hard cost entered and unbilled as of the date range specified plus the daily interest calculated based on an annual rate specified at the bottom of the Selections page. 
   • fee - Produces a Fee Listing report showing files that have time/fees against them.
   • ledger - A detailed Client Ledger report of all clients contact files.
   • ledger tr - Generates a Trust Ledger report that shows all contacts and files with an 

     associated trust balance plus a detailed view of all trust transactions that 

     have occurred. 

   • listing tr - Produces a Trust Listing report which provides all contacts and files that 

     have a trust balance associated with them.

   • summary - Creates a Client Summary for Files with Balances report of all client contacts.
   • summaryall - Creates a Client Summary for All Files report of all clients contact files.
   • taf listing - Displays all the Trust Administration Fees that have been charged for the period entered by Area of Law, Responsible Lawyer and Date. 
   • tl cash in - A Trust Listing report that displays any files that received a cash payment into the trust bank over a specified amount
   • top all fees - Displays client's total fees entered within the date range, ranked from highest to lowest. By default, 100 clients are displayed but this can be changed at the bottom of the Selections page. 
   • top billed disbs - Displays client's total disbursements entered within the date range specified that have since been billed, ranked from highest to lowest. By default, 100 clients are displayed but this can be changed at the bottom of the Selections page. 
   • top billed fees - Displays client's total fees entered within the date range specified that have since been billed, ranked from highest to lowest. By default, 100 clients are displayed but this can be changed at the bottom of the Selections page. 
   • wip detail - Shows unbilled charges by file; how long the file(s) have been open, and 

     details of all entries.

   • wip matter - Displays balances of each file/matter that has unbilled time/fees as well as disbursements. 
   • wip summ - Provides a Work in Progress summary by fee earner of unbilled charges and retainers.
   • wip+ar+trust - Displays what is outstanding and unbilled for trust, retainers and accounts receivables along with displaying the unbilled time/fees/expenses for each matter. 

4. Set the required report parameters such as:

   • Date range
   • File
   • Contact
   • Responsible Lawyer
   • Working Lawyer
   • File Introducing Lawyer
   • Area of Practice
   • Referral
   • Billing Group
   • Tax Group
   • Interest Group
   • Rate Group
   • File Group
   • Department
   • Tag

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows billings and outstanding balances or accounts receivables (AR)?

The Receivables report is used to review billing-related transactions. It offers different views and particularly useful for reconciling finalized invoices, locating a client or file using just the invoice number, glance of receivables and payments applied and breakdown of the invoice.

To access the Receivables report:

1. Go to Reports > Receivables > Receivables tab.
2. Click the dropdown icon to open the Receivables Options window.
3. Click the View field and select the type of Receivables report that you need from the following options:
   • billcosts - Shows all invoices created during the date range, and breaks out the fees, hard/soft costs, taxes, amount paid, amount outstanding.
   • billed co - Shows all invoices by contact and file along with the collecting fee earner. 
   • billed cr - Displays all invoices by contact and file along with the credit fee earner.
   • billings - Creates the Billings Journal that shows all invoices created during the specified date range. Most useful in finding files or clients using an invoice number only.
   • by client - Creates the Receivables by Client (AR by Client) report that shows invoices with accounts receivable balances.
   • by lawyer - Shows all accounts receivable balances by fee earner for the selected time period.
   • byclntsum - Shows AR summarized by contact, will break out the amount by invoice, but without invoice details. Shows aging, owing total and Trust/retainer amount.
   • top billed fees - Displays only billed fees this is based on billing date rather than invoice status.
   • top total ar - Displays client's total outstanding billed balances within the date range, ranked from highest to lowest. By default, 100 clients are displayed but this can be changed at the bottom of the Selections page.
   • top total billed - Displays top total invoiced/billed amounts per client across files.

4. Set the required report parameters such as:

   • Invoice date range
   • Invoice #
   • File
   • Collecting Lawyer
   • Credit Lawyer
   • Contact
   • Responsible Lawyer
   • Area of Practice
   • Department
   • File Introducing Lawyer
   • Referral
   • Balances as of Current Date, End Date or Billed Date
   • Billing Group
   • Tax Group
   • Interest Group
   • Rate Group
   • File Group
   • Tag

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows adjustments made to an invoice?

The Adjustment Report shows any adjustments made to an invoice.

To access the Adjustment report:

1. Go to Reports > Receivables >Adjustment
2. Click the dropdown icon to open the Adjustment Options window.
3. Click the View field and select the type of Adjustment report that you need from the following options:
   • adjustment - Creates the Adjustment Listing that lists all invoice adjustments by order of entry.
   • by client - Adjustment Listing that lists all invoice adjustments by contact.

   • summaries - Lists all invoice adjustments and summaries.

4. Set the required report parameters such as:

   • Date
   • Invoice #
   • File
   • Collecting
   • Credit
   • Contact
   • Responsible
   • File Introducing
   • Area of Practice
   • Department
   • Billing Group
   • Tax Group
   • Interest Group
   • Rate Group
   • File Group
   • Tag (File)

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows payments or collections to an invoice?

The Payment Report shows any payments made to an invoice.

To access the Payment report:

1. Go to Reports > Receivables >Payment
2. Click the dropdown icon to open the Payment Options window.
3. Click the View field and select the type of Payment report that you need from the following options:

   • by client - Creates the Payment Allocation report that displays payments applied to client invoices by contact.

   • payment - Payment Allocation report that shows how each invoice payment was applied to fees, costs, taxes and interests.

   • summaries - Displays all payments for the selected parameters, the summary is broken down by Payment by Responsible /Collecting/Area of Practice/Time of Billing/Area of Practice/Current and Payment of Case Referral Summary showing the details of fee/Hard Cost/Soft cost along with taxes and percentages. 

   • top fees paid - Displays the top client that made the highest payment to fees - the default is top 100 but can be changed.

   • top paid - Displays top paying clients and total collected fees, (not billed amounts).

4. Set the required report parameters such as:

   • Date
   • Invoice #
   • File
   • Collecting
   • Credit
   • Contact
   • Responsible
   • Area of Practice
   • Department
   • File Introducing
   • Referring User (File)
   • Referring Contact (File)
   • Referral Source (File)
   • Referring User (Client)
   • Referring Contact (Contact)
   • Referral Source (Contact)
   • Billing Group
   • Tax Group
   • Interest Group
   • Rate Group
   • File Group
   • Tag (File)

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows my accounts payable?

The Payables Report shows the payables listing or outstanding accounts payable (AP).

To access the Payables report:

1. Go to Reports > Payables >Payables
2. Click the dropdown arrow to open the Payables Options window.
3. Click the View field and select the type of Payables report that you need from the following options:
   • discount - Creates a Discount Listing that identifies payables with the potential to be discounted based on the terms of the vendor.
   • futuredue - A list of payables arranged by their due date from the vendor.
   • overdue - Lists the payables owed to vendors that are past due.
   • payable - Creates a Payable Listing that provides a list of all outstanding payables.
   • purchases - A list of all payables including paid and unpaid.

4. Set the required report parameters such as:

   • Entry Date
   • Vendor
   • Reference
   • Tag
   • Due Date
   • GL account
   • Payable Status (Paid, Unpaid or Both)
   • Entry Number
   • Aging
   • Include operating out entries
   • Include trust out entries
   • Vendor Total Payments Amount Over
     NOTE:  Enabling the Include operating out entries will also show payables that were not actually entered but because a payment was made to the vendor. 

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows payments applied to payables?

The Payment Listing shows the payments made to accounts payable (AP).

To access the Payment Listing report:

1. Go to Reports > Payables >Payment
2. Click the dropdown arrow to select the payment view that will generate the Payment Listing, it shows all the payables that have been paid or partially paid.

3. Set the required report parameters such as:

   • Entry Date
   • Vendor
   • Reference
   • Tag
   • Entry Number
   • Bank Account
   • Payments Amount Over
   • Include operating out entries
   • Include trust out entries
     NOTE:  Enabling the Include operating out entries will also show any payments made to vendors regardless of if it's for a payable entry or not. 

4. Select the output under Generate to.

5. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows all transactions to vendors? 

The Vendor Report shows all entries related to vendors including payables, and payments made to the vendor.

To access the Vendor report:

1. Go to Reports > Payables >Vendor
2. Click the dropdown arrow to open the Vendor Options window.
3. Click the View field and select the type of Vendor report that you need from the following options: 
   • vendor - A Vendor Ledger that lists the history of a vendor and their transactions, including payables and payments posted to the vendor.
   • ven+t+o - A Vendor Ledgerlists the history of a vendor and their transactions, including payables and payments posted to the vendor, including payments made through Trust and Operating cheques.

4. Set the required report parameters such as:

   • Entry Date
   • Vendor
   • Reference
   • Tag
   • Include operating out entries
   • Include trust out entries

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows time and fee entries?

The Time Report shows all dockets, or time and fees entered in the system.

To access the Time report:

1. Go to Reports > Other >Time
2. Click the dropdown arrow to open the Time Options window.
3. Click the View field and select the type of Time report that you need from the following options:
   • daily time - Creates the Daily Time Listing report showing time entries by entry date for the selected time range.
   • ebill - Creates the eBilling Listing showing time entries by entry date that are part of an electronic bill (ebill).
   • time - Creates the Time Listing report that shows the hours, rate, and total amount for all time listings for the selected date range and the user who made the entry.

4. Set the required report parameters such as:

   • Date
   • File
   • Fee Earner
   • Entry Number
   • Contact
   • Task
   • Area of Practice
   • Status (Billed or Unbilled)

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report shows costs or disbursements?

The Expense Report shows all client or file expenses (soft costs) and disbursements (hard costs) entered on the system.

To access the Expense report:

1. Go to Reports > Other > Expense
2. Click the dropdown arrow to select the expense view to generate the Client Cost Listing, it shows all expenses or soft costs made.

3. Set the required report parameters such as:

   • Date
   • File
   • Fee Earner
   • Entry Number
   • Contact
   • Task
   • Area of Practice
   • Status (Billed or Unbilled)

4. Select the output under Generate to.

5. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.

What report can show changes made to entries?

The Audit Trail Report tracks all changes made to various data entries such as trust, operating, invoices, payables, journal entries, time and expense. The report will display when an entry was actually recorded, modified, or deleted. Audit Trail report does not track changes made to client and file details such as changing the number, or name.

To access the Audit Trail report:

1. Go to Reports > Other > Audit Trail.
2. Click the dropdown arrow to open the Audit Trail Options window.
3. Click the View field and select the type of Audit Trail report that you need from the following options:
   • audit - Creates the Audit Trail report of all entries and any changes made to them, plus the user, date, and status of the entry.
   • by entry - Provides all entries and any changes made to them, plus the user, date, and status of the entry. The entries will be listed in the order they were entered.
   • op cash in - Produces entries and changes by date, user, and status of all entries created or modified in the operating account.
   • tr cash in- Produces entries and changes by date, user, and status of all entries 

     created or modified in the trust account

4. Set the required report parameters such as:

   • Entry #
   • Reference (Cheque or Receipt #)
   • Entry Date
   • Entry User
   • File
   • Received From/Paid To
   • Amount Over
   • Flow of Funds (In and Out)
   • Journal Source

5. Select the output under Generate to.

6. Click Play.

   NOTE:  If you need to find a specific entry, use the search/find function of the browser, hold CTRL key and press F then search for the information that you have.