CCH Trust Accounts: 2024.2

Trust Accounts

All sites need to install Trust Accounts, as it is the core application.  The method used depends on a) whether the user is a new user or an existing user, and b) whether the data is running on a C-Tree database or a SQL Server database. New users should refer to Installing Trust Accounts for New Users. Existing users, C-Tree or SQL Server, should refer to Installing Trust Accounts for Existing Users.

Note: The Trust Accounts programs are usually installed just once on a network drive with each workstation having a shortcut to the programs on the network.

Transaction Reporter

Transaction Reporter is a reporting tool used for a variety of reports, but not for final accounts.  It can be purchased as a separate add-on to Trust Accounts. Transaction Reporter is installed directly on to each user’s workstation. The programs do not reside on the network.  Refer to Installing Transaction Reporter.

CCH Accounts Production

CCH Accounts Production is a new accounts formatter that is installed with CCH Central. If you are still converting from the Viztopia Formatter to CCH Accounts Production, you need both programs installed. To install CCH Accounts Production the user needs to install CCH Central. This is documented in the CCH Userdocs website under the Central Suite Installer. It is not discussed further here.

Telekurs

SIX Financial is a Swiss company that supplies securities data, e.g. share prices or the history of the dividends that companies have paid.  The company was formerly called Telekurs and these instructions, and the CCH software, still use the earlier name. If you have subscribed to the Telekurs data feed then you need to install the Telekurs software. The Telekurs software is usually installed on just one workstation.

Installing the Software on the Network

1. SQL Server Version only.  Installation of the SQL Server version of Trust Accounts is usually carried out by CCH.  However if further technical information is required then please ask your CCH Installation Engineer.  Two points need to be noted:

1. When the SQL Server version is installed an empty copy of the C-Tree data files is also installed.  The location it is installed to is used as the location of the Accounts Production files.

2. There is an entry in the WTRUMP.INI file in the Trust Accounts programs directory, e.g.

[Folders]

DataFiles=X:\WTRUMP\DATA

This entry should refer to the same directory in which the empty copy of the C-Tree data files is installed.  It is required because temporary files and the files used for Accounts Production are usually held in the directory used for the database files.  But with SQL Server, the database files may not be visible to the workstation.  So an alternative location needs to be specified for these files.

2. C-Tree Version only.  Install Trust Accounts on to the network.  The recommended directory for the programs is WTRUMP and for the data is WTRUMP\DATA.  A mapped drive should be used for installing Trust Accounts on a network e.g. X:\WTRUMP.  Some users prefer to use UNC names e.g. \\X SERVER\WTRUMP.  However this can give problems accessing the Viztopia Formatter.  Obviously the location for the programs should be a directory that is accessible to all users.

Accessing the Data for the First Time

1.    Now access the blank data using the option on the Start Menu for Trust Accounts, which was created by the network install routine.  For the SQL Server version Steps 2 to 5 below will already have been done as part of the network install routine.

2.    C-Tree only.  Select the default database.  You are asked to enter a Telcode.  The entry of this code enables the product licensing.  The relevant Telcode will have been supplied with the documentation accompanying the release.  Enter the Telcode and press Return. 

Should you encounter any difficulties with the Product Licensing please contact CCH Customer Care and Support.

3.    At this stage certain standard information should be imported from import files supplied by CCH using the option File > Import:

S6SECCOM.IMP	Sundry information:
	Country codes.  These two character ISO country codes are used for the country of Registration and Quotation when setting up Securities or when the securities are imported from the Exshare data feed.
	Stock names. These indicate the denomination of the Security, e.g. Ordinary 25p shares.
	Geographical areas.  These are used for sorting investment schedules.
	Currency codes.  The more common three character ISO currency codes, e.g. USD for US dollars.  See S6CURR.IMP below.
	Movement codes.  CCH's standard movement codes, e.g. SRG for Sale of Rights.
	Various other codes used by the securities datafeed.
S6RPI.IMP	UK CGT Retail Price Index (UK users only).
	UK Tax Credit Rates
S6CURR.IMP	Currency codes.  A full list of the ISO currency codes.  Only the more common ones are in S6SECCOM.IMP.  Do not import unless needed.

 

4.     In addition there are import files available for the CCH Client Classes.  Each file creates a client class and a master chart for use with CCH Accounts Pages.  If required then note

• If the client class already exists then it should be edited to a different number before importing
• When this file is imported set Duplicated Records to be Updated.  Otherwise some fields on the client class referencing nominal accounts need to be edited afterwards.

The import files available are:

S6TRUST.IMP	CCH Trust Master Chart.  Creates Client Class 001 for use with the CCH Trust Pages.
S6PROB.IMP	CCH Probate Master Chart.  Creates Client Class 002 for use with the CCH Probate Pages.
S6CHARTY.IMP	CCH Charity Master Chart.  Creates Client Class 003 for use with the CCH Charity Pages.
S6LTDCO.IMP	CCH Limited Company Master Chart.  Creates Client Class 004 for use with the CCH Limited Company Pages.
S6PEN.IMP	CCH Pension Master Chart.  Creates Client Class 005 for use with the CCH Pension Pages.

Alternatively, client classes can be set up manually.  This is documented in Help under About Trust Accounts Desktop > Menubar > Activities > Common/shared data > Client classes > Procedure to Add a Client Class Manually.

5.    Set up the Database Parameters.  These are found under Activities > System Management > Database Parameters.  The main ones are:

Default Year End	The year is assumed to end on 5th April (the UK tax year end).  This setting is used to provide default dates for tax reports and for reports that include multiple clients.  The dates can always be overridden when the report is run.
System Default Currency	Press F2 to select from a picklist.  For UK users this should be GBP, for Irish users EUR.  This setting is used as the default currency in several circumstances.  It must not be left blank.
Pricing Range in Days	This determines how far back the system looks for a security price or an exchange rate.  If prices are received monthly then 30 days is a reasonable setting.

6.   Security Code Type.  Securities can be accessed by SEDOL code, ISIN code or a user-defined code.  The current setting for the Security Code Type can be seen in Database Parameters on the Data Feed tab.  On a new database it is set to ISINs.

To change the Security Code Type proceed as follows:

• Exit Trust Accounts and run QTRUMP32.EXE, which is located in the Trust Accounts programs folder.  This is a single-user version of Trust Accounts.
• Select Tools > Securities Parameters.
• Select one of:
  • Set security codes to user-defined (no conversion)
  • Set security codes to ISINs (no conversion)
  • Set security codes to SEDOLs (no conversion)

There are other options for an automatic conversion.  But these are not relevant at this stage, as no securities yet exist on the database.

The security code type that is used depends on whether a data feed is in use and, if so, which one:

No data feed	The Security Code Type can be SEDOL code, ISIN code or a user-defined code.  If a code other than ISINs is required then follow the steps above to change it.
Telekurs	The Security Code Type must be ISINs.  On a new database this is already set.
Interactive Data (Exshare)	The Security Code Type can be either SEDOLs or ISINs.

 

7.   Loading Securities.  The securities are now added.  How this is done depends on the data feed in use.

1.   No Data Feed.  Some users add securities as they go along, i.e. as they set up the clients.  Others have a list of securities that they will need and set them up all at once.  Some users have a list of securities in a text file or spreadsheet and import them automatically.  However this requires assistance from CCH.

2.   Telekurs Feed.  Load the Telekurs software as explained in a later section below.  Then follow the steps in Trust Accounts Help under Telekurs Data Feed Overview to load the securities.

3.   Exshare Feed with SEDOLs.  If the Exshare feed is being used with SEDOLs the procedure is as follows:

• Change the Security Code Type to SEDOLs as explained above.
• Load the Exshare data files.  The option is in QTRUMP32.EXE and is Tools > Data Feed.  The Help on this option explains what to do.

4.   Exshare Feed with ISINs.  Just load the data files as the default code type is ISINs.  The option is in QTRUMP32.EXE and is Tools > Data Feed.  The Help on this option explains what to do.

A final point is that some users prefer only to have the securities on their securities list that are actually in use.  If this is required then the usual approach is to load all the securities as explained above, then add the client data and finally to delete the securities that are not in use.  There is a program to automatically delete the securities that are not in use.  Contact CCH Customer Care and Support for details.

Setting Up Shortcuts

On each workstation that needs to access Trust Accounts:

1. Go into Windows Explorer and find the directory on the network where Trust Accounts is installed.
2. Find the file WTRUMP32.EXE on the list of files.
3. Right-click it and select Send To > Desktop (create shortcut).  The Trust Accounts icon will now be added to the desktop.
4. Exit Explorer and go to the Desktop.  You may need to minimise other windows to do this.  Right click the Trust Accounts icon and select Rename.  Change the name of the icon from WTRUMP32 to Trust Accounts.

Upgrade (SQL Server Only)

The procedure is as follows:

1. All users should exit from Trust Accounts
2. Backup the Trust Accounts data, both that in the SQL Server database and anything in the DataFiles location in WTRUMP.INI.  The DataFiles location is the location of temporary files and Accounts Production files.  This location is specified in WTRUMP.INI in the Trust Accounts programs directory under [Folders] where it says DataFiles=.
3. Install Trust Accounts on to the network.  The directory name for the software should be the location where the programs existed before.  The directory name for the data should be the DataFiles location in WTRUMP.INI (and not the actual location of the SQL Server database files).
4. Access Trust Accounts in the usual way.  If required, the system will upgrade the data.
5. This completes the upgrade.

Upgrade (C-Tree only)

1. All users should exit from CCH Trust Accounts
2. Backup the CCH Trust Accounts data.
3. Install CCH Trust Accounts on to the network.  The directory name for the software should be the location where the programs existed before.
4. Select Start > Run and in the command line type
   
   X:\WTRUMP\QTRUMP32
   
   if the network drive for CCH Trust Accounts is X:.  This starts a special conversion only mode of CCH Trust Accounts.  At the end, if user names have been set up, you are asked to login.  Log in if requested, and then exit CCH Trust Accounts.
    
5. This completes the upgrade.  Backup the upgraded data and access CCH Trust Accounts in the usual way.  This time the client list appears as usual.

Entering a new Telcode if needed

If a new Telcode (PIN Number) is issued it can be entered as follows:

1. In Trust Accounts select File > Info.
2. Press “.”, i.e. press the full stop character.
3. The new Telcode is requested.  Enter this from the accompanying documentation.
4. Click OK.  If it is invalid you are given an opportunity to re-enter it.  If the Telcode is accepted exit completely from Trust Accounts.
5. Re-enter Trust Accounts, select File > Info and check that the licensed options look correct.

Installing Transaction Reporter on each Workstation

For each workstation proceed as follows:

1. Download Transaction Reporter from the CCH Software Download Centre and run the downloaded file.
2. Enter the Destination Folder for Transaction Reporter.  Its default, C:\Program Files\Solution 6\Reporting is usually correct, unless you wish to install Transaction Reporter on to a different drive.  Do not install Transaction Reporter on to a network drive.
3. The Setup asks for the location of the Trust Accounts programs.  Select the location of the programs on the network.  This is used by Transaction Reporter to check licensing.
4. The programs are then copied on.
5. If DLLs in the Windows\System directory need to be updated you may be asked to confirm that they should be overwritten.  Also you may be asked to restart the workstation at the end of the Installation, in which case do so.
6. Test Transaction Reporter by going into Trust Accounts and then into Reports > Design Reports > Clients Report. The following message appears:
   "Unable to find S6RD.exe.  Do you wish to browse for this file?"
7. Click Yes and browse to C:\Program Files\Solution 6\Reporting or whichever directory Transaction Reporter was installed into.  This message only appears the first time a user accesses Transaction Reporter.
8. You should now be taken into Transaction Reporter.

Installing the Telekurs Software

1. The Telekurs software is separate from CCH Trust Accounts and is installed on a standalone PC.  Normally only one PC is set up to run the Telekurs update.
2. Download the Telekurs software from the CCH Software Support Download Centre and run the downloaded file. If it is not already installed then this option installs it.  If this is an update then running the Telekurs install gives options to uninstall or update the old version.  Select the option to update it. 
3. The install requests the Telekurs software directory.  This must be on the local workstation.  The default is C:\Telekurs.
4. The install requests the Telekurs data directory.  This directory can contain a substantial amount of data and there should be at least 2Gb free disk space available.  If only one user is going to run the Telekurs data feed this can be on the local workstation, e.g. C:\Telekurs\Data.  If more than one user is going to run it, it should be on the network.
5. After the Telekurs software has been loaded, Database Parameters needs to be set up and the first download performed.  This is described in the Trust Accounts Help under Telekurs Data Feed Overview.