User-defined Reports

Last updated
Save as PDF

Product Help Banner.png

Transaction Reporter is a powerful but simple reporting tool that allows you to design your own reports.

Transaction Reporter

The fields required on the report are dragged from a picklist on to the report design. This includes user-defined fields (i.e. extra fields defined by you and attached to clients or investments). Transaction Reporter can:

Report on a single client or a selection of clients.
Sort a report on virtually any field.
Filter reports so that only particular records are included.
Export reports into MS Word or MS Excel.

Despite all this power Transaction Reporter is very intuitive, and unlike some tools does not require a consultant or programmer to write the reports. This also makes it suitable for ad hoc reporting.

Transaction Reporter can be used for:

Client lists including user-defined client fields.
A list of bank account balances across all clients.
Analysis of the performance of stocks recommended by different brokers.
To list securities that are held by at least one client but with no up-to-date price.
To report on the Trust Accounts Certificate Register.

Transaction Reporter ships with a selection of reports to help you get started.

MS Excel Reports

Transaction Reporter has an extra optional module to output reports directly into an Excel spreadsheet. This is referred to as Excel Reports. Without this module Transaction Reporter can export report data to a CSV (comma-separated variable) file that can be opened in Excel, but Excel Reports goes much further than this. Transaction Reporter supplies the raw data into hidden worksheets and the user formats this data in visible worksheets to produce an Excel report or chart.

The user can write their own spreadsheets or use templates supplied.

The templates supplied include:

PortfolioByRegion.xls. This is a Single-client report, which produces a pie chart showing the breakdown of a client's portfolio by region.
FundsUnderManagement.xls. This is a Cross-client Report, which produces a graph showing the three largest clients by market value as a proportion of total funds under management.

Once the spreadsheet has been designed an operator can run one of these Excel Reports as easily as running a report that is built into Trust Accounts. Some reports are designed to be run for a single client, like the PortfolioByRegion report; others are designed as cross-client reports like the FundsUnderManagement report.

There is also a facility to run a single report for multiple clients. The results can be printed directly or saved as separate spreadsheets, one for each client. So a user can produce PortfolioByRegion reports for several clients in a single operation.

Selecting and running standard reports

Select Reports from the top menu bar, Run User Reports and Cross-client or Single-client dependent upon the report you wish to run, then Excel Report.

This will open the Run Excel Report box, from here click the Select button beside Spreadsheet and then select CCH from the bottom of the Excel Reports box to display and choose the relevant report, in the screen shot below this is PortfolioByRegion.xls.

Once the report has been chosen the Select button will be activated, click on this and then the name of the report will appear on the Spreadsheet row in the Run Excel report box, click the Report button. A spreadsheet will be created.