Skip to content
  • There are no suggestions because the search field is empty.

How to generate a report showing market value by client 

To access total market value by client:

  1. Navigate to TC Wealth > Reporting > Reports > Sponsored Holdings As At
  2. Select the date and click generate CSV, this will generate a report of each holding line by line
  3. In Excel, click Insert > PivotTable > From Table/Range > OK
  4. In the PivotTable Fields menu on the right, click the tick boxes next to "Account Name" and then "Market Value". This will provide one line per client showing total market value.