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 that can be filtered by:

• 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

To access the Operating Bank Journal report:

1. Go to Reports > Banking >Operating Bank
2. Click the dropdown arrow to select the view for the Operating Bank Journalthat 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).
   • op - All activity for any or all operating accounts during a specified period.
   • register - Operating Register

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What is the Trust Bank Journal report?

Operating Bank Journal report shows all trust bank entries that can be filtered by:

• 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

To access the Trust Bank Journal report:

1. Go to Reports > Banking >Trust Bank
2. Click the dropdown arrow to select the view for the Trust Bank Journalyou 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).
   • trust - All activity for any or all trust accounts during a specified period.
   • register - Trust Register

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What is the Transfer Journal report?

Transfer Journal report shows all transfer entries from and to all bank accounts that can be filtered by:

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

To access the Transfer Journal report:

1. Go to Reports > Banking >Transfer
2. Click the dropdown arrow to select the view for the Transfer Journal 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.

   • transfer - Shows all transfers made during a specified period for any or all bank account(s). Changes made to entries are not shown.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What report shows Client, File and Vendor listing?

Contacts report lists clients, file and vendor details with the available filters:

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

To access the Contacts report:

1. Go to Reports > Contact > Contacts
2. Click the dropdown arrow to select the view you need:
   • 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.
   • 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.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What is the Ledger report?

Ledger report shows details, transactions, and all entries made to a file and can be filtered by:

• 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

To access the Ledger report:

1. Go to Reports > Contact > Ledger
2. Click the dropdown arrow to select the view you need:
   • 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 - 
   • costanalysissummary - 
   • expenses -
   • expensesint - 
   • 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 client contact files.
   • taf listing - 
   • 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 -
   • top billed disbs - 
   • top billed fees - 
   • wip detail - Shows unbilled charges by file; how long the file(s) have been open, and 

     details of all entries.

   • wip matter - 
   • wip summ - Provides a Work in Progress summary by fee earner of unbilled charges.
   • wip+ar+trust - 

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

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

The Receivables report is used to review billing-related transactions. It is particularly useful for reconciling finalized invoices, glance of receivables and payments applied as well the breakdown of the invoice with different filter options:

• 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

To access the Receivables report:

1. Go to Reports > Receivables > Receivables tab.
2. Click the dropdown arrow to select the view you need:
   • billcosts -
   • 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
   • by client - Creates the Receivables by Client (AR by Client) report that shows all accounts receivable balances by contact and file for the selected time period
   • by lawyer - Shows all accounts receivable balances by fee earner for the selected time period.
   • byclntsum - 
   • top billed fees - 
   • top total ar -
   • top total billed - 

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What report shows adjustments made to an invoice?

The Adjustment Report shows any adjustments made to an invoice and can be filtered by:

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

To access the Adjustment report:

1. Go to Reports > Receivables >Adjustment
2. Click the dropdown arrow to select the view you need:
   • 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.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What report shows payments or collections to an invoice?

The Payment Report shows any payments made to an invoice and can be filtered by:

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

To access the Payment report:

1. Go to Reports > Receivables >Payment
2. Click the dropdown arrow to select the view you need:

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

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

   • summaries - 

   • top fees paid -

   • top paid - 

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

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 select the view you need:
   • 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.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

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 to generate the Payment Listing, it shows all the payables that have been paid or partially paid.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

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 select the view you need:
   • 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 Ledger lists the history of a vendor and their transactions, including payables and payments posted to the vendor, including payments made through Trust and Operating cheques.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What report shows time and fee entries?

The Time Report shows all dockets, or time and fees entered in the system and can be filtered by:

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

To access the Time report:

1. Go to Reports > Other >Time
2. Click the dropdown arrow to select the view you need:
   • 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.

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.

What report shows costs or disbursements?

The Expense Report shows all client or file expenses (soft costs) and disbursements (hard o entered on the system or time and fees entered in the system and can be filtered by:

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

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.

4. Select the output under Generate to.

5. Click Play.

What report can show changes made to entries?

The Audit Trail Report tracks all changes made to entries, including those that were entered, modified, or deleted. The report can be filtered by:

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

To access the Audit Trail report:

1. Go to Reports > Other > Audit Trail.
2. Click the dropdown arrow to select the view you need:
   • 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

3. Set the required report parameters.

4. Select the output under Generate to.

5. Click Play.