Clearwater Analytics Tri Party Reconciliation File Requirements
Each day, Clearwater performs a detailed data aggregation, reconciliation and validation process comparing data from the investment manager’s trading platform to custody bank feeds as wells as to Clearwater’s independent accounting and reporting system. The tri-party reconciliation process ensures that data is validated in order to provide same day position and cash balance reporting. The tri-party reconciliation process pairs trades from the client’s or client’s asset manager’s trade order management system to custody data. These trades are reconciled against each other, and the custodians’ positions to ensure all trades were booked properly by the custodian. Additionally, Clearwater independently error checks each trade for accurate accrued, factors, proceeds calculations and more.
Plain text formats such as CSV and fixed-width
For security purposes, Clearwater requires the use of industry-standard encryption on any files transmitted using unsecured transfer protocols. E-mail lacks adequate security to serve as a long-term data transmission method. We currently support the following means of data transfer: a) SSH FTP (SFTP): Files may be pushed to or pulled by Clearwater (pushed to Clearwater preferred). b) Plain FTP with PGP-encrypted files: Files may be pushed to or pulled by Clearwater. c) FTP over SSL (FTPS): Files must be pulled by Clearwater. While end of each business day is standard, Clearwater will work with you to determine the best time for file transmission. Clearwater is willing to evaluate other transmission methodologies as needed. Clearwater will work with you on file specifications and development. We highly recommend that you provide files that are already available via your trading platform to reduce any development burden on your side. Clearwater will then conduct any custom development to ease the integration on our side.
A trading file containing buys and sells is the only required file from the client’s trade order management system. While the ability to provide all data points below will result in a more automated and timely process and are strongly recommended, we have indicated the minimum requirements.
Data Point (X indicates required field) X
X X X
Account Number Custody Account Number CUSIP * ISIN* Ticker* Alternate Security Identifier* Alternate Identifier Description
X
Accrued Interest
X
As Of Date
X
Commission Counterparty‡ Currency Description
Event Factor Fees Maturity Date Price X X X
Principal Proceeds Settle Date
X
Trade Date Trading ID
X X
Transaction Type Units
Description The Clearwater account number provided by your Account Manager. The account number utilized by your custodian.
Type of security identifier used and security type. This field is required if CUSIP is not available. The amount of Accrued Interest agreed to be paid (or received) on the. The effective date of the file. In standard use, this will be equal to both the current business day and the Trade Date. Any commission included in the calculation of proceeds. The local currency of the trade. The 3 character ISO 4217 standard currency codes should be used (Ex. USD, CAD, or CNY). Asset description, trade tracking number, or any additional information helpful for easy reference when clarification or notification is needed. Description to indicate if this is the original trade, rebook, or cancellation. The percentage of the original principal that is left to be distributed, as represented by a numerical factor. Any additional fees (excluding commission) included in the calculation of proceeds. The Final Maturity date for the security. This field is required if a CUSIP is not available. Insert the full price into this field. Clearwater can support up to 16 digits of precision without rounding. The amount of Principal agreed to be paid (or received). Total proceeds of the trade. Date format of MM/DD/YYYY should be utilized. Be sure to include year on all transactions. Date format of MM/DD/YYYY should be utilized. Be sure to include year on all transactions. A unique ID for each original trade. A cancellation or rebook should have the same ID as the original trade. Each trade should be designated as either BUY or SELL. Un-Factorized units for the trade.
* At least one of ISIN, CUSIP, ticker, or alternate security identifier is required. An alternate identifier must be unique within the portfolio and may be used when no publicly registered identifier exists for an asset. ‡ Counterparty is required for Schedule D reporting.
Data Point (X indicates required field) X
X X X
X
Account Number Custody Account Number CUSIP * ISIN* Ticker* Alternate Security Identifier* Alternate Identifier Description As Of Date Currency Current Coupon Rate Current EOD Market Price Current EOD Market Value Description
Factor Factorized Units Maturity Date X
Units
Description The Clearwater account number provided by your Account Manager. The account number utilized by your custodian.
Type of security identifier used and security type. This field is required if CUSIP is not available. The effective date of the file. In standard use, this will be equal to both the current business day and the Trade Date. The local currency of the trade. The 3 character ISO 4217 standard currency codes should be used (Ex. USD, CAD, or CNY).
Asset description, trade tracking number, or any additional information helpful for easy reference when clarification or notification is needed. The percentage of the original principal that is left to be distributed, as represented by a numerical factor. Any additional fees (excluding commission) included in the calculation of proceeds. The Final Maturity date for the security. This field is required if a CUSIP is not available. Un-Factorized units for the trade.
* At least one of ISIN, CUSIP, ticker, or alternate security identifier is required. An alternate identifier must be unique within the portfolio and may be used when no publicly registered identifier exists for an asset.
Plain text formats such as CSV and fixed-width
For security purposes, Clearwater requires the use of industry-standard encryption on any files transmitted using unsecured transfer protocols. E-mail lacks adequate security to serve as a long-term data transmission method. We currently support the following means of data transfer: a) SSH FTP (SFTP): Files may be pushed to or pulled by Clearwater (pushed to Clearwater preferred). b) Plain FTP with PGP-encrypted files: Files may be pushed to or pulled by Clearwater. c) FTP over SSL (FTPS): Files must be pulled by Clearwater. While end of each business day is standard, Clearwater will work with you to determine the best time for file transmission. Clearwater is willing to evaluate other transmission methodologies as needed. Clearwater will work with you on file specifications and development. We highly recommend that you provide files that are already available via your trading platform to reduce any development burden on your side. Clearwater will then conduct any custom development to ease the integration on our side.
A trading file containing buys and sells is the only required file from the client’s trade order management system. While the ability to provide all data points below will result in a more automated and timely process and are strongly recommended, we have indicated the minimum requirements.
Data Point (X indicates required field) X
X X X
Account Number Custody Account Number CUSIP * ISIN* Ticker* Alternate Security Identifier* Alternate Identifier Description
X
Accrued Interest
X
As Of Date
X
Commission Counterparty‡ Currency Description
Event Factor Fees Maturity Date Price X X X
Principal Proceeds Settle Date
X
Trade Date Trading ID
X X
Transaction Type Units
Description The Clearwater account number provided by your Account Manager. The account number utilized by your custodian.
Type of security identifier used and security type. This field is required if CUSIP is not available. The amount of Accrued Interest agreed to be paid (or received) on the. The effective date of the file. In standard use, this will be equal to both the current business day and the Trade Date. Any commission included in the calculation of proceeds. The local currency of the trade. The 3 character ISO 4217 standard currency codes should be used (Ex. USD, CAD, or CNY). Asset description, trade tracking number, or any additional information helpful for easy reference when clarification or notification is needed. Description to indicate if this is the original trade, rebook, or cancellation. The percentage of the original principal that is left to be distributed, as represented by a numerical factor. Any additional fees (excluding commission) included in the calculation of proceeds. The Final Maturity date for the security. This field is required if a CUSIP is not available. Insert the full price into this field. Clearwater can support up to 16 digits of precision without rounding. The amount of Principal agreed to be paid (or received). Total proceeds of the trade. Date format of MM/DD/YYYY should be utilized. Be sure to include year on all transactions. Date format of MM/DD/YYYY should be utilized. Be sure to include year on all transactions. A unique ID for each original trade. A cancellation or rebook should have the same ID as the original trade. Each trade should be designated as either BUY or SELL. Un-Factorized units for the trade.
* At least one of ISIN, CUSIP, ticker, or alternate security identifier is required. An alternate identifier must be unique within the portfolio and may be used when no publicly registered identifier exists for an asset. ‡ Counterparty is required for Schedule D reporting.
Data Point (X indicates required field) X
X X X
X
Account Number Custody Account Number CUSIP * ISIN* Ticker* Alternate Security Identifier* Alternate Identifier Description As Of Date Currency Current Coupon Rate Current EOD Market Price Current EOD Market Value Description
Factor Factorized Units Maturity Date X
Units
Description The Clearwater account number provided by your Account Manager. The account number utilized by your custodian.
Type of security identifier used and security type. This field is required if CUSIP is not available. The effective date of the file. In standard use, this will be equal to both the current business day and the Trade Date. The local currency of the trade. The 3 character ISO 4217 standard currency codes should be used (Ex. USD, CAD, or CNY).
Asset description, trade tracking number, or any additional information helpful for easy reference when clarification or notification is needed. The percentage of the original principal that is left to be distributed, as represented by a numerical factor. Any additional fees (excluding commission) included in the calculation of proceeds. The Final Maturity date for the security. This field is required if a CUSIP is not available. Un-Factorized units for the trade.
* At least one of ISIN, CUSIP, ticker, or alternate security identifier is required. An alternate identifier must be unique within the portfolio and may be used when no publicly registered identifier exists for an asset.
