Clearwater Custom Fields User Guide
S O LU T I O N S
Custom Fields User Guide Clearwater’s Custom Field Manager (previously called the Custom Data Manager) allows clients to input their own custom fields and use those fields within reports throughout the website. This functionality is currently available for saving custom fields for accounts, securities, lots, and transactions. Custom field information can be added, viewed, and saved within the Custom Field Manager, which you can find under the Tools menu.
For more information about how to create custom fields, see the “Steps for Adding New Custom Fields” section below.
How to Use Custom Account Fields Every Clearwater account can be labeled with custom account information. These custom account fields can then be added into Accounting or Risk Exposure reports in order to compare account groupings such as:
• View a Balance Sheet report grouped by Country of Operations • View a Roll-Forward report grouped by Legal Entity • View a Trading Activity report grouped by Portfolio Manager
How to Use Custom Security Fields Some clients prefer to see different classifications for their data at a security level. These custom security fields can save information such as:
• Custom Security Types • Custom Asset Classes • Custom Market Sectors
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
How to Use Custom Lot Fields Custom lot fields are used whenever a distinct lot needs to be referenced (as opposed to every lot for a given security). These custom lot fields can be used to:
• • • •
Identify lots that were purchased for various trading strategies Identify lots that have been posted as collateral Identify lots that have been written-down or those that have specifically taken a credit loss write-down For Insurance Clients: track state deposits and asset segmentation
How to Use Custom Transaction Fields Custom transaction fields can be used to label characteristics of specific buys, sells, coupons, paydowns, maturities, equity dividends, and other transactions. These custom transaction fields can be used whenever additional granularity is necessary past lot-level data.
Steps for Adding New Custom Fields 1. Navigate to the Custom Field Manager and open the account dropdown menu. Select what level of data you would like to input.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
2. Click the “New Custom Field” button in the bottom-left corner of the Custom Field Manager.
3. Name your new custom field.
4. Input data within the web view or click the “Copy to Excel” button.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
5. Click Ctrl+C to copy the highlighted text within the popup window.
6. Open a new workbook in Excel.
7. Paste (click Ctrl+V) the data into your new workbook.
8. Enter the custom data you would like to see displayed on the website for the new custom field you created.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
9. Select all (click Ctrl+A) and then copy (click Ctrl+C) in Excel.
10. Return to the Custom Field Manager and click the “Paste from Excel” button.
11. Paste (click Ctrl+V) in the popup window.
10. Return to the Custom Data Manager and click the “Paste From Excel” button
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
12. Click the “OK” button. Your new custom field will appear within the Custom Field Manager and the newly-entered data will remain the color blue until the “Save” or “Discard Changes” button is clicked. The date selected in the Account Selector is irrelevant for new custom fields because the data will be saved for all time. However, manual changes can be made to the date, as will be explained in the “Editing Custom Fields” section below.
A Few Rules for Adding New Data: • • • • •
The basic “Identifier” or “ID” field for each type of custom field (account, security, lot, or transaction) must be included in the paste from Excel to the Custom Field Manager. New custom fields must first be created in the Custom Field Manager. New fields cannot be created in Excel and pasted into the Custom Field Manager. Users can sort and rearrange the rows in Excel in order to facilitate data entry. The Custom Field Manager will map the data correctly upon upload to ensure accuracy. Clients cannot add identifiers to the Excel file that are not in the Custom Field Manager. Any data associated with those additional Identifiers will not be entered. If an error occurs during the process, or if one of these rules is not followed, a message will display notifying the user how to successfully input data.
Editing Custom Field Information Custom field data can be edited in several ways within the Custom Field Manager. If only a few changes are needed, users with appropriate permissions can double-click on a line of data in the Custom Field Manager and edit it.
This will change the data from the start date selected in the “Account Selector” to perpetuity. The data prior to the date selected will remain the same as the original custom value. For larger changes, copy your custom field into Excel and make changes to the data for the custom field within Excel by following the process described earlier for entering new data.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
Deleting Custom Fields Custom fields can be permanently deleted from the Custom Field Manager by right-clicking on the column header in the Custom Field Manager and selecting the “Delete Column” option.
Deleting a custom field removes it from the addable columns list within the “Add Column” and “Edit Multiple Columns” tools, but it does not remove the custom field or its previously-saved data from any custom reports that have been saved with that custom field.
How Custom Fields Are Saved Custom fields are associated with a given account, identifier, lot, or transaction and will be the same wherever that information is displayed (i.e. once creating a custom field for a given security, that information will be the same across any account of yours that holds that security). This eases the data-entry process for users by removing the need to re-enter data for each account.
Additional Details for Partner Clients This custom field functionality also makes it possible for financial institution partners of Clearwater to add custom data and share it with their clients. All custom field information is saved at the client level. While it is not propagated down to sub-clients (users who receive Clearwater through a partner), the information can be shared with sub-clients through report sharing. For partners with numerous sub-clients, adding custom data created at the sub-client level will only be visible to users within that sub-client. To share custom data with all of your sub-clients, you need to add the custom fields through each individual sub-client’s Custom Field Manager. Custom fields created at the top-client level (i.e. your organization) will only be visible to users of that topclient. It is also possible for partners to simply share custom reports that include custom fields with their end users. This is an easy way to share the same custom fields with all sub-clients. However, the custom fields and data will only be visible on the shared report and will not be available within the “Add Column” tools to add to other reports. If you have any questions or would like further clarification on sharing custom fields with your clients, please contact your Clearwater Account Manager.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
Custom Fields User Guide Clearwater’s Custom Field Manager (previously called the Custom Data Manager) allows clients to input their own custom fields and use those fields within reports throughout the website. This functionality is currently available for saving custom fields for accounts, securities, lots, and transactions. Custom field information can be added, viewed, and saved within the Custom Field Manager, which you can find under the Tools menu.
For more information about how to create custom fields, see the “Steps for Adding New Custom Fields” section below.
How to Use Custom Account Fields Every Clearwater account can be labeled with custom account information. These custom account fields can then be added into Accounting or Risk Exposure reports in order to compare account groupings such as:
• View a Balance Sheet report grouped by Country of Operations • View a Roll-Forward report grouped by Legal Entity • View a Trading Activity report grouped by Portfolio Manager
How to Use Custom Security Fields Some clients prefer to see different classifications for their data at a security level. These custom security fields can save information such as:
• Custom Security Types • Custom Asset Classes • Custom Market Sectors
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
How to Use Custom Lot Fields Custom lot fields are used whenever a distinct lot needs to be referenced (as opposed to every lot for a given security). These custom lot fields can be used to:
• • • •
Identify lots that were purchased for various trading strategies Identify lots that have been posted as collateral Identify lots that have been written-down or those that have specifically taken a credit loss write-down For Insurance Clients: track state deposits and asset segmentation
How to Use Custom Transaction Fields Custom transaction fields can be used to label characteristics of specific buys, sells, coupons, paydowns, maturities, equity dividends, and other transactions. These custom transaction fields can be used whenever additional granularity is necessary past lot-level data.
Steps for Adding New Custom Fields 1. Navigate to the Custom Field Manager and open the account dropdown menu. Select what level of data you would like to input.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
2. Click the “New Custom Field” button in the bottom-left corner of the Custom Field Manager.
3. Name your new custom field.
4. Input data within the web view or click the “Copy to Excel” button.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
5. Click Ctrl+C to copy the highlighted text within the popup window.
6. Open a new workbook in Excel.
7. Paste (click Ctrl+V) the data into your new workbook.
8. Enter the custom data you would like to see displayed on the website for the new custom field you created.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
9. Select all (click Ctrl+A) and then copy (click Ctrl+C) in Excel.
10. Return to the Custom Field Manager and click the “Paste from Excel” button.
11. Paste (click Ctrl+V) in the popup window.
10. Return to the Custom Data Manager and click the “Paste From Excel” button
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
12. Click the “OK” button. Your new custom field will appear within the Custom Field Manager and the newly-entered data will remain the color blue until the “Save” or “Discard Changes” button is clicked. The date selected in the Account Selector is irrelevant for new custom fields because the data will be saved for all time. However, manual changes can be made to the date, as will be explained in the “Editing Custom Fields” section below.
A Few Rules for Adding New Data: • • • • •
The basic “Identifier” or “ID” field for each type of custom field (account, security, lot, or transaction) must be included in the paste from Excel to the Custom Field Manager. New custom fields must first be created in the Custom Field Manager. New fields cannot be created in Excel and pasted into the Custom Field Manager. Users can sort and rearrange the rows in Excel in order to facilitate data entry. The Custom Field Manager will map the data correctly upon upload to ensure accuracy. Clients cannot add identifiers to the Excel file that are not in the Custom Field Manager. Any data associated with those additional Identifiers will not be entered. If an error occurs during the process, or if one of these rules is not followed, a message will display notifying the user how to successfully input data.
Editing Custom Field Information Custom field data can be edited in several ways within the Custom Field Manager. If only a few changes are needed, users with appropriate permissions can double-click on a line of data in the Custom Field Manager and edit it.
This will change the data from the start date selected in the “Account Selector” to perpetuity. The data prior to the date selected will remain the same as the original custom value. For larger changes, copy your custom field into Excel and make changes to the data for the custom field within Excel by following the process described earlier for entering new data.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
S O LU T I O N S
Deleting Custom Fields Custom fields can be permanently deleted from the Custom Field Manager by right-clicking on the column header in the Custom Field Manager and selecting the “Delete Column” option.
Deleting a custom field removes it from the addable columns list within the “Add Column” and “Edit Multiple Columns” tools, but it does not remove the custom field or its previously-saved data from any custom reports that have been saved with that custom field.
How Custom Fields Are Saved Custom fields are associated with a given account, identifier, lot, or transaction and will be the same wherever that information is displayed (i.e. once creating a custom field for a given security, that information will be the same across any account of yours that holds that security). This eases the data-entry process for users by removing the need to re-enter data for each account.
Additional Details for Partner Clients This custom field functionality also makes it possible for financial institution partners of Clearwater to add custom data and share it with their clients. All custom field information is saved at the client level. While it is not propagated down to sub-clients (users who receive Clearwater through a partner), the information can be shared with sub-clients through report sharing. For partners with numerous sub-clients, adding custom data created at the sub-client level will only be visible to users within that sub-client. To share custom data with all of your sub-clients, you need to add the custom fields through each individual sub-client’s Custom Field Manager. Custom fields created at the top-client level (i.e. your organization) will only be visible to users of that topclient. It is also possible for partners to simply share custom reports that include custom fields with their end users. This is an easy way to share the same custom fields with all sub-clients. However, the custom fields and data will only be visible on the shared report and will not be available within the “Add Column” tools to add to other reports. If you have any questions or would like further clarification on sharing custom fields with your clients, please contact your Clearwater Account Manager.
accounting. compliance. performance. risk.
www.clearwateranalytics.com
