How To
CCH Transaction Reporter 2.30
CCH Trust Accounts
Transaction Reporter is an optional module for Trust Accounts. It is used for cross-client reports and for producing client reports in Word and Excel (called Excel Reports). This release contains the following changes:
Compatibility with Trust Accounts 2020.1
Trust Accounts 2020.1 supports the use of a full SQL connection string. Transaction Reporter 2.30 also supports this.
Updated Help file format
The old Transaction Reporter Help file was not accessible on Windows 10. An updated Help file has been included.
New fields added
The following new fields have been added:
- ClientPerfSecTWCRAnnual – Client time-weighted capital return on securities annualised
- ClientPerfSecTWCRPeriod – Client time-weighted capital return on securities in the period
- ClientPerfSecTWTRAnnual – Client time-weighted total return on securities annualised
- ClientPerfSecTWTRPeriod – Client time-weighted total return on securities in the period
- ClientPropNetIncome – Client total net income from properties
- ClientSecAddnAmount – Client total acquisitions of securities
- ClientSecDispAmount - Client total disposal proceeds of securities
- ClientSecNetIncome - Client total net income from securities
- ClientSecOpMV - Client opening market value of securities
- ClientSecOpCost - Client opening cost of securities
- ClientSecProfit - Client profit on disposal of securities
- InvActive – Has holding or income in the period (Y/N)
- InvAddnAmount – Total of acquisitions
- InvAddnUnits – Units acquired
- InvDispAmount – Total of disposals
- InvDispUnits – Units disposed
- InvFundPerfSecTWCRAnnual – Fund time-weighted capital return on securities annualised
- InvFundPerfSecTWCRPeriod – Fund time-weighted capital return on securities in the period
- InvFundPerfSecTWTRAnnual – Fund time-weighted total return on securities annualised
- InvFundPerfSecTWTRPeriod – Fund time-weighted total return on securities in the period
- InvFundSecAddnAmount - Fund total acquisitions of securities
- InvFundSecClCost - Fund closing cost of securities
- InvFundSecClMarketValue - Fund closing market value of securities
- InvFundSecDispAmount - Fund total disposal proceeds of securities
- InvFundSecNetIncome - Fund net income from securities
- InvFundSecOpCost – Fund opening cost of securities
- InvFundSecOpMarketValue – Fund opening market value of securities
- InvFundSecProfit - Fund profit on disposal of securities
- InvHomeTax – Domestic tax (fixed a fault)
- SecNondistributor – A non-reporting fund (Y/N)
- SecREIT – Security is a REIT (Y/N)
- TranAccIncDate – Transaction accrued income date
- TranContraNomCode – Transaction contra nominal a/c code (fixed a fault)
- TranUnitsAny – Transaction quantity on additions or disposals
Notes:
- Some fields are only relevant to certain reports.
- A FundPerformanceReport has been added to the Investment Ledger Master Reports which uses the new performance fields.
Downloading and Installing
To download the software (Wolters Kluwer login required), visit the Non Central suite download page and select Transaction Reporter
Related documents
Linking to clients in CCH Central
This document provides instructions on how to link and unlink clients from CCH Central in the CCH Trust Accounts system. To link a client, the user must select the client, click "Edit," then "Link," and choose the appropriate client from Central. Once linked, certain fields become non-editable in Trust Accounts. To unlink a client, the user clicks the "Unlink" button, which restores editability but deletes any accounting periods in Central. Key fields updated from Central include client name, address, and contact details.
Database Parameters
Various features in Trust Accounts are optional. To set up many of these, from the Activities menu select System Management, and then Database Parameters.
Data Parameters
Various features in Trust Accounts are optional. To set up many of these, from the Activities menu select System Management, and then Database Parameters.
Database Parameters
Database Parameters
Passwords
Passwords