1. Actionstep
  2. Reports
  3. Billing Reports
  • Client Transactions Report

Client Transactions Report

Avatar
Dakota Martin
  • Updated

mceclip0.png

Overview

The Client Transaction Report shows a complete chronological history of the billing transactions that have occurred on a matter. The report includes time, expenses, invoices, payments, write offs and trust activity. This is useful to see a detailed history of transactions.

Accessing the Client Transactions Report

The Client Transactions Report can be accessed in Reports > Billing Reports.

Report Configuration Options

The report can be run with default setting. There are, however, various basic and advanced options to drill down to display only the most pertinent information for your purposes.

Basic

mceclip1.png

Date Range

The range defined for the display of items on the report. This will filter out any items dated outside of the defined range. The Date range dropdown offers default options:

  • Custom period
    • Uses the date picker fields to define the start and end dates of included report items
  • Month to date
    • From the beginning of the current month to today's date
  • Last month
    • From the first to last day of the previous month
  • This calendar year
    • From January 1st to December 31st of the current year
  • This calendar year to date
    • From January 1st to the current date
  • Last calendar year
    • From January 1st to December 31st of the previous year
  • Last calendar year to date
    • From January 1st of the previous year to the current month and day of last year
  • This financial year
    • From the financial year start date for your system to one year after
  • This financial year to date
    • From the financial start date for your system to the current date
  • Last financial year
    • From the financial start date for your system for last year one year after
  • Last financial year to date
    • From the financial start date for your system for last year to the current month and day of the year on which that financial year ends
  • Everything to date
    • Everything in the system to the current date
  • Everything
    • Everything, including future-dated items, in your system
Matter Dictates which matter or matter's are used for report information.

 

Advanced

mceclip2.png

Responsible lawyer Filters report to only show information for matters where the selected user is the responsible lawyer. Multiple responsible lawyers can be selected.
Client Filters report to only show information for matters where the selected contact is the client. Multiple clients can be selected.
Entry Type Filters the report to only show information of the selected entry types. 
Bill type Filters report to only show information for matters where the billing arrangement matches the selected value(s). Options include Hourly and Fixed fee.
Matter type Filters report to only show information for matters of the selected type(s).
Include inactive/closed matters Allows matters with a status of inactive or closed to display information on the report.

 

Producing the Client Profitability Report

mceclip7.png

On Screen (HTML) Displays the report on the current screen 
PDF Downloads the report in PDF format
MS Excel Downloads the report is xlsx format

 

Understanding the Output of the Client Transactions Report

Note: Using the three output options will generate the same information in the selected format. For the purposes of this explanation, we will use images from the On Screen (HTML) output.

 

Output Options (On Screen Only) and Header Information 

mceclip5.png

Date Range The range for which the report information is filtered. Only transactions within this range are displayed.
Additional info

Additional filter information will be displayed in the header when the options are selected. This information can include:

  • Matter
    • mceclip6.png
  • Responsible lawyer
    • mceclip8.png
  • Client
    • mceclip9.png
  • Entry type
    • mceclip10.png
  • Bill type
    • mceclip11.png
  • Matter type
    • mceclip12.png
  • Options
    • mceclip13.png
Reload This button will re-generate the report. This can be useful if changes are being made while viewing the report to see difference between before and after the changes.
Print This will launch your browser's print dialog. The behavior and display of the dialog is dependent upon your browser and workstation settings.
Excel Downloads the report in xlsx format
PDF Downloads the report in PDF format
Show settings button Displays the configuration options for the report. Once displayed, the configuration options can be hidden by selecting the Hide settings button.
Generated stamp Displays the name of the user who generated the report, as well as the date and time the report was generated.

 

mceclip0.png

Date Date associated with the table item
Entry type

Describes the type of entry. This column can include the following types of entries:

  • Time - Fixed fee
  • Time - Fixed fee - NB
  • Time - Fixed fee - NC
  • Time - Fixed fee - Hide
  • Time
  • Time - NB
  • Time - NC
  • Time - Hide
  • Expense - AP
  • Expense - WD
  • Expense
  • Trust receipt
  • Trust transfer AR
  • Trust AR
  • Trust payment
  • Trust transfer in
  • Trust transfer out
  • Trust bank transfer in
  • Trust bank transfer out
  • Trust other??
  • Invoice
  • Invoice write-up
  • Invoice write-off
  • Receipt cash
Details Provides a description of the entry, a timekeeper where appropriate, and a quantity and rate where appropriate. 
Amount The value of the entry
Bill The total of a bill - where the entry type is invoice
Cash The amount received on receipts and client payments
Inv # The invoice number associated with an entry
Trust amount Displays the amount an entry affected trust
Account The bank account associated with the entry

 

Return to top