CCH Transaction Reporter 2.30
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.