Skip to main content
CCH Software User Documentation

CCH Trust Accounts: Transaction Reporter and MS Excel Reporting Training




This course is  an introduction to Transaction Reporter and demonstrate its ability to mine data held in CCH Trust Accounts and produce reports in Microsoft Excel. 
This course provides training in the creation of reports using CCH Transaction Reporter by the extraction of data from CCH Trust Accounts to produce reports In MS Excel and MS Word presentations. 

Course Duration: This course consists of two onsite or online sessions. Each session will last up to 3 hours.

Key Objectives

  • Produce reports from the data held in CCH Trust Accounts
  • Produce a client list including data held in the user defined database
  • Format reports to change the appearance of fields within the report
  • Provide an analysis of cross client investments
  • Produce graphs showing the largest clients by market value as a proportion of total funds under management
  • Produce a pie chart showing the breakdown of a client’s portfolio by region
  • Format data in the MS Excel worksheets to produce an MS Excel report, chart and tables of figures

Course Contents

Session 1 Session 2
  • Accessing Transaction Reporter
  • About Report Levels
  • The Report View Modes
  • Working in Preview Mode
  • Working in Design Mode
  • Working with Formulae
  • More Advanced Formulae
  • Working With Additional Fields
  • Working with User Defined Database Fields
  • The Report Design Area
  • MS Excel reporting to produce graphs, pie charts and tables of figures
  • Formatting, and set up of automatic embedded reports in a MS Word document
  • Running reports for a single client or across all clients
  • Running reports for multiple clients in a single operation, producing one spreadsheet or document for each


Attendees should adhere to the Training session Guidelines.

All attendees should have a good understanding of CCH Trust Accounts and MS Excel.

Who is this course designed for?

CCH Users

CCH Champions



Useful Resources

  • eLearning courses - online courses that provide you with an overview and insight into our software
  • Bitesize videos - Compliance and Non-Compliance - showing you how to use features (and also some specific focused areas) of our software 
  • Webinars - sessions for you to attend and learn from



  • Was this article helpful?