1. technology and computing
2. software
3. databases

CBRS User Guide
Cost Basis Reporting Service
CBRS
User Guide
March 2015
1
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Table of Contents
1
ABOUT THIS USER GUIDE ......................................................................................... 6
2
GENERAL INFORMATION........................................................................................... 7
2.1 SCOPE OF THE SYSTEM: TRANSFER OF INFORMATION ONLY .......................................... 7
2.2 BASIC FUNCTIONALITY: INPUT ..................................................................................... 7
2.2.1 INPUT RECORD CONTENT INDICATOR TYPES .......................................................... 9
2.2.2 ORIGINAL ASSET AND TAX LOT RECORDS FORM A “PACKAGE” ................................ 10
2.2.3 “PACKAGE” RULE APPLIES TO CORRECTED RECORDS TOO ..................................... 10
2.2.4 EXCEPTIONS TO “PACKAGE” RULE: FIRM REJECT AND REQUEST RECORDS ............. 10
2.2.5 ASSOCIATION OF ASSET AND TAX LOT RECORDS .................................................. 10
2.3 BASIC FUNCTIONALITY: OUTPUT ................................................................................ 11
2.3.1 OUTPUT AVAILABLE THROUGH BOTH AUTOMATED CONNECTION AND W EBDIRECT .... 12
3
ELIGIBILITY FOR CBRS ............................................................................................ 13
3.1 USER ELIGIBILITY ..................................................................................................... 13
3.1.1 COST BASIS USER MASTER FILE ......................................................................... 13
3.2 ASSET ELIGIBILITY ................................................................................................... 19
3.2.1 BOTH COVERED AND NONCOVERED SECURITIES ARE ELIGIBLE .............................. 19
4
APPLICATION INPUT AND OUTPUT ........................................................................ 20
4.1 INPUT AND OUTPUT TIMING ....................................................................................... 20
4.2 GENERAL RECORD LAYOUT INFORMATION ................................................................. 20
4.2.1 FILLER FIELDS .................................................................................................... 22
4.3 USING CBRS FOR COST BASIS INFORMATION IN NON-US CURRENCY ........................... 22
4.4 INPUT GENERAL INFORMATION .................................................................................. 22
4.4.1 TRANSFER CONTROL NUMBER ............................................................................ 22
4.4.2 FIRM REJECT RECORD ....................................................................................... 24
4.4.3 FIRM NUMBER AND TYPE VS. CUSTOMER ACCOUNT NUMBER FIELDS ..................... 24
4.4.4 CONTRA FIRM NUMBER ...................................................................................... 26
4.4.5 CONTRA FIRM TYPE ........................................................................................... 26
4.4.6 NUMERIC FIELDS ................................................................................................ 28
4.4.7 ASSET CATEGORY FIELD ..................................................................................... 29
4.4.8 SUM OF THE TAX LOT QUANTITIES MUST MATCH THE ASSET QUANTITY ..................... 29
4.4.9 OPTIONAL FIELDS ............................................................................................... 29
4.4.10
BORROWED POSITION CODE ........................................................................... 29
4.4.11
ACATS ASSET SEQUENCE NUMBER ................................................................ 31
4.5 OUTPUT GENERAL INFORMATION .............................................................................. 31
4.5.1 DISTRIBUTION SIDE ............................................................................................ 32
4.5.2 COST BASIS CONTROL NUMBER .......................................................................... 32
4.5.3 SYSTEM REJECTS .............................................................................................. 32
4.5.4 SYSTEM ACTION FIELD ....................................................................................... 33
4.5.5 SYSTEM REJECT REASON FIELD .......................................................................... 33
4.5.6 STATUS FIELDS.................................................................................................. 34
4.5.7 EXAMPLE OF SYSTEM CHANGED ......................................................................... 34
4.5.8 EXAMPLE OF SYSTEM REJECTED......................................................................... 34
4.5.9 OUTPUT DROPPED RECORDS ............................................................................. 35
2
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4.5.10
5
LPA NUMBER AND LPA TYPE.......................................................................... 35
BEST PRACTICES ..................................................................................................... 37
5.1 RESOLVE ISSUES WITH THE CONTRA PARTY ................................................................ 37
5.2 FIRMS SHOULD BOTH SUBMIT AND RECEIVE RECORDS.................................................. 37
5.3 WHEN SHOULD A FIRM SEND THE CBRS RECORD? ..................................................... 37
5.4 CORRECTED RECORD .............................................................................................. 37
5.4.1 SOME SCENARIOS ABOUT CORRECTED RECORDS .................................................. 38
5.5 FIRM REJECT AND REQUEST RECORDS ..................................................................... 38
5.6 DO NOT REQUEST BASIS FOR LOTS RECEIVED WITH UNKNOWN BASIS ............................ 40
5.7 SUBMITTING AND RECEIVING NONCOVERED ACCOUNTS AND NONCOVERED SECURITY
TYPES .............................................................................................................................. 40
5.8 COVERED FIXED INCOME ASSETS THAT WERE TRANSFERRED IN 2014 ........................... 40
5.9 THE CBRS QUANTITY SHOULD EQUAL THE ORIGINAL ASSET TRANSFER QUANTITY, I.E.
AVOID FRACTIONAL SHARES ............................................................................................... 41
5.10 POPULATING CBRS RECORDS FOR ACATS RECLAIM OR FAIL REVERSAL TRANSACTIONS
41
5.11 SENDING A CBRS RECORD FOR AN ASSET HELD IN MULTIPLE CURRENCIES ................... 42
5.12 SENDING COST BASIS FOR AN INVALID CERTIFICATE ..................................................... 42
5.13 FIELD SPECIFIC BEST PRACTICES ............................................................................. 42
5.13.1
TRANSACTION TYPE (A/T) ............................................................................... 43
5.13.2
TRANSFER CONTROL NUMBER (A/T) ................................................................ 43
5.13.3
ALTERNATE CONTROL NUMBER (A/T) .............................................................. 43
5.13.4
ASSET DESCRIPTION (A/T) .............................................................................. 43
5.13.5
ASSET CATEGORY (A) .................................................................................... 44
5.13.6
TRANSFERRING BASIS ON RIGHTS OR WARRANTS .............................................. 44
5.13.7
RECEIVER CUSTOMER ACCOUNT NUMBER (A/T) ............................................... 44
5.13.8
DELIVERER CUSTOMER ACCOUNT NUMBER (A/T) ............................................. 44
5.13.9
TOTAL POSITION QUANTITY/TAX LOT QUANTITY (A/T) ....................................... 44
5.13.10 DATE TRANSFER WAS INITIATED AND SETTLEMENT DATE OF TRANSFER (A) ........ 44
5.13.11 DISPOSITION METHOD USED (A) ...................................................................... 45
5.13.12 SHARES TO COVER SHORT INDICATOR (A) ....................................................... 45
5.13.13 NONCOVERED/PENDING INDICATOR (T) ............................................................ 45
5.13.14 TAXES REPORTED BY ISSUER/TRANSFER AGENT (T) ......................................... 46
5.13.15 GIFTED OR INHERITED INDICATOR (T) ............................................................... 47
5.13.16 FAIR MARKET VALUE AS OF DATE OF GIFT (T) .................................................. 47
5.13.17 POSITION CODE (T) ........................................................................................ 47
5.13.18 POSITION CODE FOR OPTIONS (T) .................................................................... 47
5.13.19 POPULATING ACQUISITION DATE OF TAX LOT FIELD WHEN DATE IS UNKNOWN (T) 47
5.13.20 ORIGINAL ACQUISITION DATE FOR W ASH SALE ADJUSTMENT (T) ....................... 48
5.13.21 WASH SALE ADJUSTMENT AMOUNT (T) ............................................................ 48
5.13.22 EXCHANGE RATE (T) ...................................................................................... 48
5.13.23 TAX LOT ORIGINAL COST (T) ........................................................................... 49
5.13.24 TAX LOT CURRENT COST (T) .......................................................................... 49
5.13.25 ZERO BASIS INDICATOR (T) ............................................................................. 50
5.13.26 TAX LOT ORIGINAL UNIT PRICE (T) .................................................................. 50
5.13.27 EMPLOYEE PLAN SHARES INDICATOR (T) ......................................................... 50
5.13.28 FIELDS FOR FIXED INCOME ELECTIONS (T) ........................................................ 50
3
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5.13.29
5.13.30
5.13.31
5.13.32
5.13.33
5.13.34
5.13.35
5.13.36
6
FILE INPUT AND OUTPUT VIA COMMON DATA TRANSFER SERVICE (CDTS) ... 58
6.1
6.2
6.3
6.4
6.5
6.6
6.7
6.8
7
PURCHASE/ DIVIDEND REINVESTMENT INDICATOR (T) ....................................... 51
MARKET DISCOUNT (T) ................................................................................... 51
BOND PREMIUM (T) ........................................................................................ 53
ACQUISITION PREMIUM (T) .............................................................................. 54
ACCRUED OID (T) .......................................................................................... 55
LAST ADJUSTMENT DATE (T) ........................................................................... 57
CARRYOVER OFFSET FUTURE USE(T) ............................................................ 57
DISALLOWED CARRYOVER OFFSET (T)............................................................. 57
GENERAL INFORMATION ........................................................................................... 58
FILE INPUT .............................................................................................................. 58
FILE OUTPUT: TRANSACTION MRO ........................................................................... 59
FILE OUTPUT: COST BASIS USER MASTER FILE MRO ................................................ 60
LIMITS ON WHEN OUTPUT FILES AND DATA ARE AVAILABLE............................................ 60
INPUT AND OUTPUT TIMING ....................................................................................... 60
CBRS APPLICATION OUTPUT HEADER ...................................................................... 61
CBRS APPLICATION OUTPUT TRAILER ...................................................................... 61
CBRS AND WEBDIRECT ........................................................................................... 62
7.1 WEBDIRECT W ORKFLOW .......................................................................................... 62
7.2 LOGGING ON TO THE SYSTEM .................................................................................... 62
7.3 CREATING TRANSACTIONS ........................................................................................ 62
7.4 WORKING WITH PENDING TRANSACTIONS .................................................................. 67
7.4.1 ADDING MORE ASSETS TO A TRANSACTION .......................................................... 67
7.4.2 ADDING MORE TAX LOTS TO A TRANSACTION ....................................................... 71
7.4.3 LISTING AND SEARCHING PENDING TRANSACTIONS............................................... 74
7.5 DELETING TRANSACTIONS ........................................................................................ 78
7.5.1 DELETING TRANSACTIONS FROM THE TRANSFER LIST............................................ 78
7.5.2 DELETING TRANSACTIONS FROM THE TRANSFER INFORMATION UPDATE PAGE......... 79
7.6 EDITING TRANSFER INFORMATION, ASSET RECORDS, AND TAX LOT RECORDS ............. 81
7.6.1 VIEWING AND UPDATING TRANSFER INFORMATION ................................................ 81
7.6.2 VIEWING AND UPDATING ASSETS......................................................................... 84
7.6.3 DELETING ASSETS ............................................................................................. 86
7.6.4 VIEWING AND UPDATING TAX LOTS ...................................................................... 92
7.6.5 DELETING TAX LOTS .......................................................................................... 95
7.7 WORKING W ITH BATCHES ...................................................................................... 101
7.7.1 SENDING A BATCH TO DTCC ............................................................................ 101
7.7.2 VIEWING A SENT BATCH ................................................................................... 103
7.8 VERIFYING THAT YOUR FILE W AS SENT SUCCESSFULLY (USING THE CONFIRMS UTILITY)
105
7.9 RESENDING A BATCH ............................................................................................. 107
7.10 UPLOADING RECORDS TO CBRS ............................................................................ 108
7.10.1
OVERVIEW OF THE UPLOAD PROCESS ............................................................ 108
7.10.2
START W ITH THE MOST RECENT SPREADSHEET TEMPLATE ............................. 112
7.10.3
FOR EARLIER VERSIONS OF MS EXCEL ........................................................... 113
7.10.4
SPREADSHEET TEMPLATE COLUMN HEADERS .................................................. 114
7.10.5
THE SPREADSHEET AT A GLANCE .................................................................. 115
4
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.6
TIPS ............................................................................................................ 117
7.10.7
ADDING AN ASSET W ITH ONE TAX LOT .......................................................... 118
7.10.8
ADDING AN ASSET W ITH MULTIPLE TAX LOTS ................................................. 119
7.10.9
ADDING MULTIPLE ASSET RECORDS .............................................................. 120
7.10.10 ADDING AN ASSET W ITHOUT A TAX LOT (FIRM REJECT AND REQUEST RECORDS
ONLY)
122
7.10.11 EXAMPLE SPREADSHEETS ............................................................................. 123
7.10.12 UPLOADING THE SPREADSHEET ..................................................................... 127
7.10.13 DISPLAYING RECORDS UPLOADED VIA SPREADSHEET ..................................... 130
7.10.14 MODIFYING UPLOADED INFORMATION............................................................. 130
7.10.15 VERIFYING THAT YOUR FILE W AS SENT SUCCESSFULLY (USING THE CONFIRMS
UTILITY) 131
7.10.16 REVIEWING AND CORRECTING SPREADSHEET ERRORS ................................... 133
7.11 SEARCHING CBRS TRANSACTIONS ......................................................................... 135
7.11.1
QUICK SEARCH ............................................................................................. 136
7.11.2
ADVANCED SEARCH ...................................................................................... 140
7.11.3
DISPLAYING ASSET AND TAX LOT DETAILS ....................................................... 142
7.12 SEARCHING FOR A CBRS USER .............................................................................. 144
SEARCHING FOR AN ACTIVE CBRS ACCOUNT................................................. 144
7.12.1
7.12.2
SEARCHING FOR AN INACTIVE CBRS ACCOUNT .............................................. 146
7.13 DOWNLOADING COST BASIS FILES .......................................................................... 148
7.14 SIZE LIMIT FOR TRANSACTION DOWNLOAD FILES ...................................................... 155
7.15 TIME FRAMES FOR FILES AND DATA AVAILABILITY ..................................................... 156
7.16 WEBDIRECT DATA ENTRY ON WEEKENDS AND HOLIDAYS ............................................ 156
8
JOINING THE SERVICE ........................................................................................... 157
8.1
8.2
9
MULTIPLE OUTPUT FILE SET-UP .............................................................................. 157
CBRS BILLING ...................................................................................................... 157
USER TESTING ........................................................................................................ 159
9.1 TESTING DATA INPUT .............................................................................................. 159
9.2 TESTING DATA OUTPUT ........................................................................................... 160
9.2.1 DETAILS ABOUT TESTING THE DAILY DEPOSIT FILE FOR TRANSFER AGENTS ......... 160
9.2.2 CANNED TRANSACTION OUTPUT FILE .................................................................. 161
10 APPENDIX A: LIST AND DESCRIPTION OF FILE IDENTIFICATION NUMBERS . 162
10.1 CBRS INPUT SYS ID NUMBERS .............................................................................. 162
10.2 LIST OF CBRS OUTPUT FILE IDENTIFICATION NUMBERS ............................................. 162
10.3 DESCRIPTION OF THE CBRS OUTPUT FILES.............................................................. 162
11 APPENDIX B: LIST OF VALID CHARACTERS FOR CBRS ................................... 164
12 DISCLAIMER AND COPYRIGHT NOTICE............................................................... 165
5
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
1 About this User Guide
The enhanced Cost Basis Reporting Service (CBRS) mitigates potential endless paper trails, added
costs and more operational risk associated with transferring cost basis information manually. The
previous version of CBRS allowed financial firms to pass customer cost basis information on assets
transferred through DTCC's Automated Customer Account Transfer Service (ACATS). The current
service extends its efficiencies and capabilities to equity transfer agents and issuers, mutual funds,
custodian banks and broker/dealers to pass cost basis information—from one financial firm to
another—for all assets transfers.
This User Guide provides details of CBRS and its functionality. Also included in this User Guide
are general descriptions of businesses processes and information flow in CBRS. The guide assumes
that the user has prior securities industry experience and a basic knowledge of cost basis
terminology and processing, and of Microsoft Excel.
Changes made since the previous edition are highlighted in red.
Version
3.0
4.0
4.1
Date
Sept.2013
Sept.2014
March
2015
Author
Lydia Midwood
Janice DiTore
Janice DiTore
Notes – Sections edited
Source document
Additions to Sections 3.1; 4.4; 5.8; 5.13; 7.12;7.13
Sections 3.2.2; 5.8; 5.13.30-36
6
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
2 General Information
The Depository Trust & Clearing Corporation (DTCC) initially launched the Cost Basis Reporting
Service (CBRS) in 2003 to enable firms to pass cost basis on assets transferred via the Automated
Customer Account Transfer Service (ACATS). In October 2008, the United States Congress passed
a law requiring firms to not only report cost basis information to investors and the U.S. Internal
Revenue Service, but to also pass cost basis information between financial intermediaries when
assets move from one firm to another.
As a result, DTCC enhanced CBRS to help firms comply with this legislation. DTCC works with a
cross functional committee with members from different segments of the industry: broker-dealers,
banks, transfer agents, mutual fund companies, and service bureaus to define the system’s
functionality and record layouts. Since many different parties are affected by the legislation, DTCC
seeks the input of these parties to make sure the system meets their cost basis passage needs.
CBRS supports the passage of cost basis in many different types of asset transfers, such as
Depository Trust Company (DTC) deliver orders, DTC deposits and withdrawals, and
ACATS/FundSERV and Networking transactions, in addition to supporting basis transfers for
ACATS transfers as it did in the previous version of the system. System capabilities include
enhanced functionality over the internet: firms can perform the same tasks via WebDirect that are
available via the computer to computer connection.
2.1
Scope of the System: Transfer of Information Only
CBRS supports the transfer of cost basis information from one financial intermediary to another.
CBRS does not tell users what transactions trigger the need to pass cost basis, or when to send the
basis. CBRS does not provide any reconciliation capabilities between expected and received
records. Also, CBRS does not calculate cost basis.
2.2
Basic Functionality: Input
CBRS has two input record types: Asset records and Tax Lot records. A firm submits an Asset
record for each asset for which it needs to pass cost basis information. The Asset record must have
at least one, but can have many, associated Tax Lot records. Tax Lot records contain detailed cost
basis information for each Asset record.
CBRS receives the cost basis records from a computer to computer automated connection or
through data input via the internet-based DTCC WebDirect.
For the most part, the record types correspond to the deliverer and receiver of the security in the
transaction that triggered the need to pass cost basis. The deliverer of the security submits an
Original or Corrected record, and the receiver of the security submits a Firm Reject or a Request
record, as needed. The one exception is the transfer of a short position (See Figure 2 for
information flow on the transfer of a short position).
7
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Figure 1 illustrates how cost basis information flows through CBRS when the original transfer was
the transfer of a long position.
Figure 1. How information flows on the passage of cost basis on the transfer of a long position.
8
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
When a short position moves from one firm to another, the deliverer of the short position is the
receiver of the security, and the receiver of the short position is the deliverer of the security. Also,
the deliverer of the short position passes the cost basis to the receiver of the short position. Figure 2
illustrates the information flow of the transfer of cost basis for a short position.
Figure 2. How information flows on the passage of cost basis on the transfer of a short
position.
2.2.1 Input Record Content Indicator Types
CBRS input records have four different types: original, corrected, firm reject, and request. The
Asset record includes all four types, and the Tax Lot record has only original and corrected record
types.
•
•
•
Original asset record/Original tax lot record: the primary record used to transfer the cost
basis information.
Corrected asset record/Corrected tax lot record: a submitter can use the corrected record
type to tell the receiver the cost basis information has changed since the original record was
sent.
Firm reject record (Asset level only): the receiver of the cost basis can use this type of
record to let the submitter of the cost basis know that there is a problem with the
information. The firm reject record is different from a system reject—a system reject occurs
when some of the submitted information is rejected by the CBRS software. For example, if
the submitter populates one of the date fields with 01/35/2012, CBRS will reject the record
because a date of January 35, 2012 is not possible.
9
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
Request record (Asset level only): the asset receiver can use this type of record to request
cost basis from the asset deliverer.
The table below summarizes the relationship between the asset deliverer and receiver for a long
position and the CBRS record submitter and receiver.
Record content type
Original
Corrected
Firm reject
Request
Record submitter
Asset deliverer
Asset deliverer
Asset receiver
Asset receiver
Record receiver
Asset receiver
Asset receiver
Asset deliverer
Asset deliverer
2.2.2 Original Asset and Tax Lot records form a “package”
The Asset record and its corresponding Tax Lot record(s) are a package. The Original and
Corrected Asset data in the input file must consist of the Asset record followed by at least one Tax
Lot record. CBRS rejects back to the submitter any Asset record not followed by a Tax Lot
record(s). Tax Lot records that do not follow an Asset record are assigned a separate Cost Basis
Control Number and rejected by the system. The sum of the tax lot quantities must equal the
quantity of the asset record, or CBRS rejects the package.
2.2.3 “Package” rule applies to Corrected records too
A submitter must send all the tax lots for a corrected record, even if only one tax lot is corrected.
For original and corrected records, the submitter must always send an asset record with all its
corresponding tax lot records. CBRS looks at the asset and tax lot records as a package. If the
package is not intact, CBRS rejects it.
2.2.4 Exceptions to “Package” rule: Firm Reject and Request records
The Firm Reject and Request record content types exist only at the asset level, not the tax lot level.
For these two record content types, there are no corresponding tax lot records.
2.2.5 Association of Asset and Tax Lot Records
For all types of assets except options (Asset Category = OPT) and for all Transaction Types except
41 = Direct Presentation, CBRS establishes the association between the Asset and the Tax Lot
record when the contents of these fields on the two records are equal:
•
•
•
•
•
•
•
Transfer Control Number
Contra Firm Number
Contra Firm Type
Submitting Firm Number
Submitting Firm Type
Receiver Customer Account Number
Deliverer Customer Account Number
10
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
•
•
ISIN Country Code
ISIN Security Issue ID
ISIN Security Check Digit
For option assets, CBRS establishes the association between the Asset and the Tax Lot record when
the contents of these fields on the two records are equal:
•
•
•
•
•
•
•
•
•
•
•
•
Transfer Control Number
Contra Firm Number
Contra Firm Type
Submitting Firm Number
Submitting Firm Type
Receiver Customer Account Number
Deliverer Customer Account Number
Put/Call Indicator
Option Symbol
Option Expiration Date
Option Strike Price Integer
Option Strike Price Decimal
For Transaction Type 41 = Direct Presentation when the asset is not an option, CBRS establishes
the association between the Asset and the Tax Lot record when the contents of these fields on the
two records are equal:
•
•
•
•
•
•
•
•
•
•
2.3
Transfer Control Number
Contra Firm Number
Contra Firm Type
Submitting Firm Number
Submitting Firm Type
Receiver Customer Account Number
Deliverer Customer Account Number
ISIN Country Code
ISIN Security Issue ID
ISIN Security Check Digit, unless ISIN Security Issue ID is blank. In this case, CBRS uses
the Asset Description instead of the ISIN Country Code, ISIN Security Issue ID, and ISIN
Security Check Digit to associate the Asset and Tax Lot record.
Basic Functionality: Output
CBRS edits the input data, runs an end-of-day batch process to validate and produce output files,
and returns the validated data to the appropriate firms. Below are the steps CBRS takes to produce
its output:
1. Four times a day, CBRS collects all of the input files available at that time and runs a
preliminary data edit process. During this cycle processing the system performs the
following tasks:
11
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
a.
b.
c.
d.
Assigns a unique Cost Basis Control Number to each asset and its tax lots
Validates that the contra firm is a valid CBRS user
Validates that the submitting firm is a valid CBRS user
Performs other basic validation of the input fields, such as editing of the input record
length, and verifying that each field value contains valid and printable characters
e. Based on this validation, the system may preliminarily accept the records, reject
them, or drop them
2. After 4:00 PM, CBRS runs an end-of-day batch process. At this time the system performs
an in-depth edit of cost basis data received today by applying all established validation rules.
3. CBRS sends accepted cost basis records to the submitting and contra firm.
4. CBRS sends rejected cost basis records to the submitting firm only.
2.3.1 Output available through both automated connection and WebDirect
Output files are available through both the automated computer-to-computer connection and/or via
WebDirect. Regardless of how a submitter enters data into the system, the entire receiver’s data is
in one file that is available for retrieval via either of the methods.
•
Please note that the data is not automatically available through both methods: users must
subscribe to either.
12
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
3 Eligibility for CBRS
3.1
User Eligibility
Each user that participates in CBRS is assigned a CBRS Account Number. DTCC will link existing
DTC, NSCC or transfer agent numbers to the CBRS account number. CBRS data submitted by or
to an ineligible user is rejected.
All financial intermediaries subject to the new IRS regulations are eligible to apply to use CBRS,
including users who are not currently members of any service offered by one of DTCC’s affiliate
companies.
3.1.1 Cost Basis User Master File
To assist firms in identifying eligible users, the Cost Basis User Master File is available on a daily
basis by 11 PM eastern time. This file lists eligible CBRS counterparties: by referring to this file
before submitting a record, CBRS users can significantly reduce the number system rejects caused
by cost basis records sent to ineligible counterparties.
The record layout for the Cost Basis User Master File is located on the DTCC Learning website at:
https://dtcclearning.com/learning/clearance/topics/cbrs/documentation.html
The Machine Readable Output (MRO) file is a flat file. The WebDirect download file is a *.csv file.
The Cost Basis User Master File has a CDTS header. It does not have a CBRS application header
or CBRS application trailer.
Record Layout fields
The record layout for the Cost Basis User Master File has the following fields (please see the
section below titled “Active/Inactive functionality” for a further explanation of how the various
fields in the User Master File should be used):
•
•
•
CBRS User Account Number: Each user who signs up for CBRS is assigned a CBRS User
Account Number. However, in most cases this is not the primary number that identifies a
firm. The Active Firm Number, which corresponds to a firm’s DTC Participant Number,
NSCC Participant Number, or Transfer Agent Number, is the number to use in the
Receiving and Submitting Firm Number fields in CBRS data input and output. The only
time the CBRS User Account Number is the primary identification number of a firm is when
that firm is not a DTC Participant, nor an NSCC Participant, nor a Transfer Agent.
CBRS Account Name: this field contains the name of the user.
Active Firm Number: the number of the CBRS user who is the active user of the system
(the user’s DTC, NSCC, or Transfer Agent (TA) number; or CBRS account number if the
user does not have a DTC, NSCC, or TA number) This is the primary number that identifies
13
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
•
•
•
•
•
the Receiving and Submitting Firms in CBRS data input and output (See the Receiving and
Submitting Firm Numbers section below for more information). The Cost Basis Steering
Committee, that advises DTCC on the design on the system, recommended that firms be
able to use their existing DTC Participant, NSCC Participant, or Transfer Agent Numbers
when processing data in CBRS. This number varies based on Active Firm Type:
o When Active Firm Type is NSCPRT, this number is the NSCC Participant Number
o When Active Firm Type is DTCPRT, this number is the DTC Participant Number
o When Active Firm Type is AGTNBR, this number is the Transfer Agent Number
o When Active Firm Type is CBRACT, this number is the CBRS User Account
Number
Active Firm Type: the type that corresponds to the Active Firm Number. Because there is
some overlap between NSCC Participant Numbers, DTC Participant Numbers, and Transfer
Agent Numbers, this file includes an Active Firm Type so the system can determine the
type of number populated in the Active Firm Number field. Values:
o AGTNBR = Transfer Agent
o DTCPRT = DTC Participant
o NSCPRT = NSCC Participant
o CBRACT = CBRS-only user
CBRS Account Start Date: the date the firm is eligible to participate in CBRS in the
production environment.
Exempt Recipient Accounts Indicator with two values: Y/N. This field allows CBRS
users to indicate whether they want retirement accounts excluded from the basis they
receive. The field values mean the following:
o Y: Exclude retirement accounts from basis sent to this user
o N: Do not exclude retirement accounts from basis sent to this user. ‘N’ is the
default value for this field.
Search Firm Number: the number of the CBRS user associated with the Active Firm
Number. In most cases, this number is the same as the Active Firm Number. In the
instances when an active CBRS user has assumed cost basis responsibility for a CBRS user
who has become inactive, this number is the number of the inactive Firm (the inactive user’s
DTC, NSCC, or Transfer Agent (TA) number; or CBRS account number if the user does not
have a DTC, NSCC, or TA number).
Search Firm Type is the type that corresponds to the Search Firm Number. Values:
o AGTNBR = Transfer Agent
o DTCPRT = DTC Participant
o NSCPRT = NSCC Participant
o CBRACT = CBRS-only user
o DTCOCC = DTC Participant who is also an OCC Member
o DTCFED = DTC Participant who is also a FED Member
In the instances when an active CBRS user has assumed cost basis responsibility for another
CBRS user who has become inactive, this type is the type of the inactive Firm.
Active/Inactive Indicator: indicates whether the record corresponds to an active or inactive
CBRS user.
o If the user is active, a CBRS user can populate the Contra Firm Number and
Contra Firm Type fields with either the Active Firm Number and Active Firm
Type or the Search Firm Number and Search Firm Type.
14
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
o
If the user is inactive, a CBRS user must populate the Contra Firm Number and
Contra Firm Type fields with the Active Firm Number and Active Firm Type.
CBRS system rejects records sent to the Search Firm Number and Search Firm
Type in this scenario.
Active/Inactive functionality
The CBRS User Master File’s active/inactive functionality helps to reduce the manual processing
that occurs when a user becomes ineligible for CBRS when its CBRS account closes as the result of
events such as a merger or bankruptcy.
When a user becomes ineligible for CBRS and another user assumes the ineligible user’s accounts,
the active/inactive functionality allows an active CBRS user to indicate that it should receive CBRS
records on behalf of an inactive user. This functionality works in the case where one user assumes
responsibility for all of another user’s accounts: it does not work in the case where one user’s
business goes to two or more other users.
A CBRS user can use the Search Firm Number/Type combination as the first place to look for the
number of a CBRS contra party. Once a user locates the contra party’s number, that user looks to
the Active/Inactive indicator. If the contra party is active, a user can send the CBRS record either to
the Search Firm Number and Type combination, or to the Active Firm Number/Type combination.
If the contra party is inactive, the user must send the CBRS record to the Active Firm
Number/Type.
For an active CBRS user, the value in the CBRS Account Effective Date field corresponds to the
date the account becomes eligible for processing in the production environment.
For an inactive CBRS user, the value in the CBRS Account Effective Date field corresponds to the
first date that the inactive record is valid.
Examples
For example, Firm A goes out of business, and Firm B assumes all of Firm A’s accounts. Because
Firm A has gone out of business, it is removed from the CBRS User Master File. Once this new
functionality is in place, Firm A can become an “Inactive” record, and Firm B is the associated
“Active” record. For each inactive record, a contra party should send CBRS records to the active
user.
The following examples illustrate the different scenarios that can occur in the new version of the
Master File. In these examples, as for all CBRS users, type AGTNBR = Transfer Agent (TA), type
DTCPRT = DTC participant, type NSCPRT = NSCC participant, and type CBRACT indicates a
CBRS user who does not have a DTC, NSCCPRT, or TA number (i.e. a “CBRS-only user”).
15
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
CBRS
User
Account
Number
000ZZZZ1
000ZZZZ2
000ZZZZ3
000ZZZZ4
000ZZZZ4
000ZZZZ5
000ZZZZ5
000ZZZZ6
000ZZZZ6
000ZZZZ7
000ZZZZ7
000ZZZZ8
000ZZZZ8
000ZZZZ9
000ZZZZ9
000ZZZZ9
CBRS
Account
Name
Example 1
Example 2
Example 3
Example 4
Example 4
Example 5
Example 5
Example 6
Example 6
Example 7
Example 7
Example 8
Example 8
Example 9
Example 9
Example 9
Active
Firm
Number
AAA
BBBB
CCCCC
DDDD
DDDD
FFFF
FFFF
ZZZZ6
ZZZZ6
ZZZZ7
ZZZZ7
HHHHH
HHHHH
LLL
LLL
LLL
Active Firm
Type
DTCPRT
NSCPRT
AGTNBR
DTCPRT
DTCPRT
NSCPRT
NSCPRT
CBRACT
CBRACT
CBRACT
CBRACT
AGTNBR
AGTNBR
NSCPRT
NSCPRT
NSCPRT
CBRS
Account
Effective
Date
1/1/2011
1/2/2011
1/3/2011
1/4/2011
8/1/2012
1/5/2011
8/5/2012
1/6/2011
8/6/2012
1/7/2011
8/7/2012
1/8/2011
8/8/2012
1/9/2011
8/9/2012
8/10/2012
Exempt
Search
Search
Recipient Firm
Firm
Accounts Number Type
N
AAA DTCPRT
Y
BBBB NSCPRT
N
CCCCC AGTNBR
N
DDDD DTCPRT
N
EEE DTCPRT
Y
FFFF NSCPRT
Y
YYYY1 CBRACT
N
ZZZZ6 CBRACT
N
XXXX2 CBRACT
N
ZZZZ7 CBRACT
N
GGG NSCPRT
N
HHHHH AGTNBR
N
JJJ AGTNBR
N
LLL NSCPRT
N
MMM NSCPRT
N
NNN NSCPRT
Active/
Inactive
A
A
A
A
I
A
I
A
I
A
I
A
I
A
I
I
Examples 1 - 3 are CBRS users who do not have a relationship with an inactive Firm Number.
They are Active records only with no corresponding inactive records. The expectation is that most
CBRS users will only have Active records.
Example 4 is a CBRS user who is a DTC participant, DDDD, who has assumed the cost basis
responsibility for a retired CBRS user who is a DTC participant, number EEE. DDDD is the active
user, and ‘EEE’ is the inactive user. All CBRS records intended for EEE should be sent to DDDD.
Example 5 is a CBRS user who is an NSCC participant, FFFF, who has assumed the cost basis
responsibility for a retired user who is a CBRS-only user, YYYY1. FFFF is the active user, and
YYYY1 is the inactive user. All CBRS records intended for YYYY1 should be sent to FFFF.
Example 6 is a CBRS-only user, ZZZZ6, who has assumed the cost basis responsibility for a retired
user who is a CBRS-only user, XXXX2. ZZZZ6 is the active user, and XXXX2 is the inactive user.
All CBRS records intended for XXXX2 should be sent to ZZZZ6.
Example 7 is a CBRS-only user, ZZZZ7, who has assumed the cost basis responsibility for a retired
user who is a NSCC participant, GGG. ZZZZ7 is the active user, and GGG is the inactive user. All
CBRS records intended for GGG should be sent to ZZZZ7.
Example 8 is a CBRS user who is a Transfer Agent, HHHHH, who has assumed the cost basis
responsibility for a retired user who is a Transfer Agent, JJJ. HHHHH is the active user, and JJJ is
the inactive user. All CBRS records intended for JJJ should be sent to HHHHH.
16
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Example 9 is a CBRS user who is an NSCC Participant, LLL, who has assumed the cost basis
responsibility for two NSCC participants—MMM and NNN. LLL is the active user, and MMM
and NNN are the inactive users. All CBRS records intended for MMM or NNN should be sent to
LLL.
To set up an inactive record:
The user who is the active member must instruct DTCC to set up a new inactive record (a.k.a.
Alternative Account). The active user must submit the DTCC Alternative Account Instruction
using the template provided on the DTCC.com website.
By default, an inactive record expires 18 months after it is set up, unless the member specifies an
end date . In its instructions to DTCC, an active user can request the inactive record to remain on
the Master File for a longer amount of time, if necessary.
 Note: The Account Numbers on the User Master File output have leading zeroes.
? If a fund has a ‘Y’ in the Exempt Recipient Accounts Indicator (meaning the fund does not
want to receive basis for retirement accounts), but a firm sends a record with basis for a
retirement account to the fund, does CBRS pass system reject the record back to the firm?
CBRS does not reject a record in this scenario. CBRS does not have any system edits based
on the Exempt Recipient Accounts Indicator. In the case described in this question, CBRS
passes the record to the fund.
? If I send a CBRS record to an inactive user, what will happen? CBRS system rejects a
record sent to a user designated as Inactive on the CBRS User Master File. What System
Reject Reason does CBRS use in this case? On the Transaction Machine Readable Output
(MRO), CBRS populates the System Reject Reason field with the value 01 = Invalid Field,
and populates the AO Contra Firm Number Status field with the value 2 = Error. The
combination of these values indicates that the submitter has populated a field with an invalid
value, and the status field indicates which field contains the invalid value (in this case, the
Contra Firm Number on the Asset record).
? Is it possible for a CBRS only user to be the active user for an inactive NSCC, DTC, or TA
number? The CBRS User Master File has been designed to allow an active CBRS only user
(type CBRACT) to have corresponding inactive records that are NSCC participants, DTC
participants, or Transfer Agents (types NSCPRT, DTCPRT, and AGTNBR, respectively).
Please note that the type CBRACT is a receiver on a limited number of Transaction Types, so
a CBRS only user may not be able to receive a record sent to it on behalf of the inactive DTC,
NSCC, or TA number.
? I only know the OCC number of my contra. How do I find the CBRS active user number?
The CBRS User Master File has been designed to allow an active CBRS user to have
corresponding inactive record user identifiers for their OCC account numbers. Use the
Search Firm Type DTCOCC to find the active CBRS user number.
17
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
? I only know the FED number and short name combination of my contra. How do I find the
CBRS active user number?
The CBRS User Master File has been designed to allow an active CBRS user to have
corresponding inactive record user identifiers for their FED account number and associated
short names. Use the Search Firm Type: DTCFED to find the active CBRS user number.
? I’m looking for a CBRS user who was on the CBRS User Master File last week, but is not
there today. What happened? How can I send cost basis to this user? If a user is no longer
on the CBRS User Master File, it has become ineligible to send and receive records via CBRS.
A variety of things could have happened; maybe the firm went out of business, or merged with
another firm. If the contra firm or fund is not on the CBRS User Master File, you cannot send
CBRS records to them: you need to send cost basis through an alternate, manual method.
Receiving and Submitting Firm Numbers

If a firm has a DTC Participant Number, NSCC Participant Number, or a
Transfer Agent Number, that number is the number to use in the Submitting or
Contra Firm Number field in CBRS. If a firm has none of the numbers above, the
CBRS User Account Number is the number to use in the Submitting or Contra Firm
Number field.
Each firm that participates in CBRS is assigned a CBRS User Account Number. As mentioned
above, for most users the CBRS User Account Number is not the primary number used to identify
the firm in CBRS data input and output. As applicable, the CBRS User Account Number is related
to an existing DTC Participant Number, NSCC Participant Number, or Transfer Agent Number
based on the logic below. This relationship allows users to identify themselves and other firms
using numbers with which they are already familiar.
The Contra and Submitting Firm Number must follow the following logic:
• A user who is a DTC Participant uses its DTC Participant Number
• A user who is an NSCC Participant uses its NSCC Participant Number
• A user who is both a DTC Participant and NSCC Participant uses its DTC Participant
Number
• An equity transfer agent/issuer who has a Transfer Agent Number uses this number
• All other firms use their CBRS User Account Number
While the CBRS User Account Number will not often be the number used to identify the firm as a
submitter and receiver of CBRS records, users are advised to make a note of their CBRS User
Account Number for use in communicating with DTCC about system and billing inquiries.
? If a user has a DTC number or Transfer Agent number, can I send records to it using its
CBRS number? No. For users who have DTC or Transfer Agent (TA) numbers, you must
send basis to the DTC or TA number and the appropriate firm type.
18
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
? Some transfer agents (TAs) have multiple TA numbers. If I am sending a CBRS record to a
TA, does the TA number have to be the specific TA number assigned to that ISIN Security
Issue ID (CUSIP)? No. For CBRS records to or from a transfer agent, CBRS does not check
that the Submitting or Contra Firm Number is the correct TA number for the CUSIP on the
record.
While CBRS does not perform an edit between the TA number and the CUSIP number, it does
on some occasions populate the TA number in the Contra Firm Number field based on the
CUSIP. For Original and Corrected records where a TA is the receiver (Transaction Types 36
= DWAC Withdrawal and 37 = Withdrawal by Transfer (WT)), and Firm Reject and Request
records where a TA is the receiver (Transaction Types 26 = DWAC Deposit, 27 = Certificate
Deposit, and 28 = DRS Profile/DO), CBRS automatically populates the Contra Firm Number
field with the number for the transfer agent who corresponds to the ISIN Security Issue ID
(CUSIP) number on the record.
If this transfer agent number is eligible for CBRS, CBRS passes the record to the agent
(assuming the record passes all other system rules and edits). If the transfer agent number is
not eligible for CBRS, CBRS populates the number on the output back to the submitting
broker-dealer, so the broker knows where to send the cost basis using some other method.
? I work at a broker-dealer, and have had some rejects in CBRS records that I’ve sent to a
transfer agent (TA) who I know is eligible for CBRS. Why are these rejects happening? Some
TAs have multiple TA numbers. There are some cases where not all TA numbers for a given
TA are eligible for CBRS.
For Example, a TA has three numbers: 12345, 23456, and 34567. The TA has made numbers
12345 and 23456 eligible for CBRS, but not 34567. A broker-dealer sends a request record
for cost basis on a deposit on CUSIP 123456789. The broker-dealer populates the ISIN
Security Issue ID (CUSIP) field with 123456789, which happens to correspond to TA number
34567. CBRS automatically populates the Contra Firm Number field with TA number 34567,
and then rejects the record because 34567 is not eligible for CBRS—even though the same TA
has two other numbers that are CBRS eligible. Best Practices suggest that TAs should make
all their TA numbers eligible for CBRS, to prevent this system reject.
3.2
Asset Eligibility
All assets are eligible for the submission of cost basis information.
3.2.1 Both Covered and Noncovered Securities are Eligible
CBRS supports the passage of cost basis on both covered and noncovered securities. The Tax Lot
Input record includes a Noncovered/Pending Indicator field that the submitter can use to indicate
that a lot is noncovered.

If the Noncovered/Pending Indicator is left blank, the lot is considered covered.
19
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4 Application Input and Output
4.1
•
•
Input and Output timing
Input: for today’s processing date, firms can submit CBRS records between 8 PM ET
yesterday (the previous processing day) and 4 PM ET today.
o Files submitted between 8 PM ET yesterday and 4 PM ET today should have today’s
date in the header
o Files with today’s header date, submitted between 4 PM and 8 PM today, are
processed with tomorrow’s processing date
o Files with tomorrow’s header date, submitted between 4 PM and 8 PM today, are
rejected by CDTS
Output: for today’s processing date, CBRS transaction output and the Daily Deposit File for
Transfer Agents is available by 9 PM ET today. The Cost Basis User Master File is
available by 11 PM ET today

This schedule applies to input and output through both the automated computer to
computer connection, and via WebDirect
4.2
General Record Layout Information
The CBRS record layouts, both input and output, can be found on the CBRS documentation section
of DTCC Learning website:
https://dtcclearning.com/learning/clearance/topics/cbrs/documentation.html
The column headings for the record layouts are:
Column Name
Field Name
Length
Start
End
Type
Opt/Req/Cond
Comments
Definition
The name of the field
The length of the field, in bytes
The position where the field starts
The position where the field ends
The type of the field:
A/N = Alphanumeric
NUM = Numeric
Indicator that specifies whether the field is optional, required, or conditionally
required:
OPT = optional field
REQ = required field
COND = conditionally required, depending upon values in other fields
A brief field description, possibly including format, valid values, conditional
requirements, general use rules, and/or best practices
Notes on the record layouts:
20
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
1. All input fields must contain printable and allowed characters; otherwise CBRS will overlay
the input with asterisks, ‘*’, and reject the record. The CBRS printable and allowed
characters are all lower/upper case letters and numbers, and certain symbols.
2. Alphanumeric fields may contain any character in the EBCDIC computer character set
except for unprintable characters such as Low-Value, High-Value, COMP-3 fields, etc. See
Appendix B for the list of valid characters for CBRS.
3. Numeric fields may include digits (0-9) only.
4. When a field is required:
a. If a list of values is provided, the field must contain a value from that list
b. An alphanumeric field without a specified list of possible values may have any
alphanumeric value, except spaces
c. A numeric field without a specified list of possible values may contain any digit
except zero (0)
5. When a field is optional:
a. An alphanumeric field with a specific list of possible values must have one of those
values or blank
b. An alphanumeric without a specific list of possible values may have any value
including spaces
c. A numeric field without a specific list of possible values may contain numeric digits
(0-9) or spaces
6. All dates in the layouts have the format CCYYMMDD (except where otherwise indicated),
where:
a. CC = Century
b. YY = Year
c. MM = Month
d. DD = Day
For example, December 31, 2011 is 20111231 in CBRS format.
The Quantity fields support up to four decimal places. Decimals greater than four places in the
quantity fields are truncated.

Please note that the position of the decimal point can float. The record layouts state:
"Position of decimal denoted by a ',' (comma). Up to four decimal places will be supported
before truncation occurs." The following list shows examples of how the share quantity fields
can look on the CBRS output file:
•
•
•
•
000000000001234,5
00000000001234,56
0000000001234,567
000000001234,5678
The Cost fields support up to two decimal places. Decimals greater than two places in the cost
fields are truncated.
21
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4.2.1 Filler fields
Filler fields are required because the filler tells the system the position of the fields in the record.
Also, when fields are marked as “optional,” this means that the value in the field is optional, but the
submitter is required to provide spaces in place of the value to keep the position of the other fields
in the correct place. The filler at the end of the record is required as well: the filler at the end of the
record layout extends the length of the record to the required 1,000 bytes. A submitted record that
is more or less than 1,000 bytes in length will be system rejected.
? When DTCC removes a field from the CBRS record layouts and turn it into filler, what
happens if a submitter populates this field? Once a field has been removed from the record
layouts, and turned into a filler field, the CBRS application does not look at this field. The
data populated in this field by the submitter is not included in the CBRS output. DTCC
recommends that the submitter space out these bytes: a submitter who does not space out
these bytes may encounter a problem in the future if the bytes are reused for a different field.
4.3
Using CBRS for cost basis information in non-US Currency
All cost fields in CBRS are denominated in US Dollars only. However, on the Tax Lot level, there
are two fields—ISO Currency Code and Exchange Rate—that allow a submitter to tell the receiver
that the submitter held the cost basis on its system in a different currency, and converted the cost
basis to US Dollars to transfer it.
When transferring basis for a lot purchased in a foreign currency, please note the following:
• For lots whose acquisition date has been adjusted as the result of a wash sale, the exchange
rate should be the rate as of the date in the “Original Acquisition Date for Wash Sale
Adjustment” field.
• The exchange rate is the rate that the delivering firm captured on the date the security was
purchased. The currency that the trade settled in is the currency that the cost basis should be
recorded in.
• The deliverer provides the exchange rate so that the receiver can calculate the gain/loss in
the currency separately from the gain/loss in the security.
4.4
Input General Information
4.4.1 Transfer Control Number
Users must enter a Transfer Control Number for each CBRS transaction submitted to the system.
This Transfer Control Number should be the same as the control number used to identify the asset
transfer that triggered the need to pass cost basis. All cost basis output includes this Transfer
Control Number for reference. CBRS rejects any cost basis record that does not have a Transfer
Control Number.
22
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide

In the Asset Input and Tax Lot Input records, the value in the Transfer Control Number
field should be left justified.
? If the transfer control number has less than 30 bytes, does the submitter have to follow the
transfer control number with spaces or zeros? CBRS accepts either one.
? For some CBRS transaction types, I should use the IMS TID number as the Transfer
Control Number. I know this number is available on the DTFPART file, but is there a way
to manually look up the IMS TID number? You can look up a DTC transaction’s IMS TID
number through the ART function in PBS. Begin by selecting a transaction. After you click
on the transaction, you see the screen below. The IMS TID is located at the bottom of the
‘Activity Details’ section of the screen. The IMS TID is not available in PTS.
? For Transaction Type 01 = ACATS, the Transfer Control Number should be populated with
the 14-byte ACATS control number from the original transfer. However, the ACATS Control
Number that we receive in positions 683-702 on the Fund/SERV 018 record (an ACATS
Transfer) is 20 bytes. Should I truncate the field down to 14 bytes? How do I know what the
ACATS Control Number is? The first fourteen bytes of the ACATS Control Number on the
Fund/SERV record are the ACATS Control Number. The last six bytes are the ACATS Asset
Sequence Number (which is used to identify that particular mutual fund asset in the ACATS
transfer).
Notes about populating the Transfer Control Number for Transfer Agent Transactions:
•
For deposit Transaction Type 27 = Certificate Deposit, a Transfer Agent can choose to
receive the CBRS Daily Deposit File. The Transfer Control Number is the Reference ID,
ARF, or CID number that was submitted on the original deposit.
23
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
•
•
For deposit Transaction Type 26 = DWAC Deposit, use the 26 byte Reference ID that you
see on CDWC as the CBRS Transfer Control Number.
For Transaction Type 37 = Withdrawal by Transfer (WT), use the first 30 bytes of the 37
byte reference number on the RSATFX file (for FAST) or on the upper right had corner of
the Transfer Assignment Control Form (TACF) (for non-FAST).
For Transaction Type 28 = DRS Profile/DO, use the first 30 characters of the customer
account number received via the DRSPRO file.
4.4.2 Firm Reject Record
A firm sends a “firm reject” record when, for various reasons, the firm cannot apply the received
cost basis to its books. This situation is different from a “system reject.” A system reject occurs
when the CBRS system rejects a record because it does not comply with the system’s rules, such as
when a date field has a value of 1/35/2012, which is not a valid calendar date.
Information flow for a “firm reject” record:
1. A user receives a CBRS record that it cannot apply to its books.
2. This user submits an asset record, with the value 03 = Firm reject record in the Record
Content Indicator field.
At this point the receiver of the firm reject record decides whether to respond. CBRS does
not require a response to a firm reject. If the receiver of the reject chooses to respond, the
information flow continues with step 3.
3.
To correct the error, the receiver of the reject responds with an asset record with the
value 02 = Corrected asset record in the Record Content Indicator field, and its
corresponding tax lots. At least one of these tax lots must also be corrected (value 02 =
Corrected tax lot record in the Record Content Indicator field).
4.4.3 Firm Number and Type vs. Customer Account Number fields
The Submitting Firm Number and Submitting Firm Type should always correspond to the user
sending the CBRS record. The Receiving Firm Number and Receiving Firm Type should always
correspond to the user receiving the CBRS record. The Deliverer Customer Account Number
should always correspond to the user who delivered the asset transfer, and the Receiver Customer
Account Number should always correspond to the user who received the asset transfer. Another
way to think of it is the Deliverer Customer Account Number corresponds to the user who is
delivering the cost basis, and the Receiver Customer Account Number corresponds to the user who
is receiving the cost basis.

Note for the transfer of a short position: the Deliverer Customer Account Number is
the account from which the short position is being transferred. The Receiver Customer
Account Number is the account that is adding the short position to its books and is thus
receiving the Proceeds as required by the regulations. Therefore, in this context, the fields
24
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
‘deliverer’ and ‘receiver’ account numbers correspond to the account delivering and
receiving the short position, not the account delivering or receiving the long shares.
Examples
This example shows how an original record is sent after the transfer of a long position. Scenario:
customer’s long position is transferred from Firm A to Firm B.
1. Firm A delivers shares to Firm B.
2. Firm B establishes the customer’s long position on its books.
3. Firm A sends cost basis to firm B (Original asset and tax lot(s) records).
This example shows how a request record, followed by an original record, are sent after the transfer
of a short position. Scenario: customer’s short position is transferred from Firm A to Firm B.
1. Firm B delivers shares to Firm A.
2. Firm B establishes the customer’s short position on its books.
3. Firm A accepts the shares.
4. Firm B sends Firm A a borrow Request record (a Request asset record with the value of
B = Borrowed in the Position Code field).
5. In response to the borrow request record, Firm A should send the proceeds to Firm B
(Original asset and tax lot(s) records).
There are four types of records that may be sent through CBRS. The following describes how each
should be used:
•
Original record – used to initially send cost basis to the contra-firm
•
Corrected record – used to send corrected basis when previously sent basis is deemed to be
incorrect
•
Firm Reject record – used in cases where the contra-firm receives basis for which it cannot
match to a received asset
•
Request record – used to request basis if it was not received on an asset transfer within 15
days or as a borrow request for long shares delivered to cover the transfer of a short position
The table below shows how these fields should be filled out for each record type. This table applies
to both long and short positions.
Record Type
Submitting Submitting Contra
Firm
Firm Type Firm
Number
Number
Contra
Firm
Type
Original
Corrected
Firm Reject
Request
Firm A
Firm A
Firm B
Firm B
Firm B
Firm B
Firm A
Firm A
Firm A
Firm A
Firm B
Firm B
Firm B
Firm B
Firm A
Firm A
Deliverer
Customer
Account
Number
Firm A
Firm A
Firm A
Firm A
Receiver
Customer
Account
Number
Firm B
Firm B
Firm B
Firm B
25
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4.4.4 Contra Firm Number
For Original and Corrected records where an Issuer/Equity Transfer Agent (TA) is the receiver
(Transaction Types 36 = DWAC Withdrawal and 37 = Withdrawal by Transfer (WT)), and Firm
Reject and Request records where a TA is the receiver (Transaction Types 26 = DWAC Deposit, 27
= Certificate Deposit, and 28 = DRS Profile/DO), CBRS automatically populates the Contra Firm
Number field with the number for the transfer agent who corresponds to the ISIN Security Issue ID
(CUSIP) number on the record. If this transfer agent number is eligible for CBRS, CBRS passes the
record to the agent (assuming the record passes all other system rules and edits). If the transfer
agent number is not eligible for CBRS, CBRS populates the number on the output back to the
submitting broker-dealer, so the broker knows where to send the cost basis using some other
method.
? If a broker-dealer has received a deposit from a transfer agent, does CBRS automatically
solicit the cost basis information from the transfer agent? No, CBRS does not automatically
solicit the cost basis information. Instead, when the broker-dealer sends the transfer agent a
request asset record for the cost basis on the deposit, CBRS follows the process described
above.
4.4.5 Contra Firm Type
CBRS needs the Submitting and Contra Firm Type fields because of the occasional overlap between
DTC, NSCC, and Transfer Agent numbers. In order for firms to use their existing participant
numbers, and not a CBRS Account Number, as an identifier in CBRS input and output records, the
CBRS application needs the Firm Type to be able to properly identify the submitting and contra
users where an overlap exists. Please see the tables below to clarify the relationship between the
Contra Firm Type and the various Transaction Types (these rules are in the input record layouts).
For the Original and Corrected Records
If the Transaction Type is:
01 = ACATS
02 = Free DTC Deliver Order (non-ACATS)
03 = Valued DTC Deliver Order
04 = Conversion
05 = Mutual Fund Transfer (non-ACATS)
[change of broker-dealer]
06 = FED
07 = Physical Movement Settlement
08 = OCC Transfer (non-ACATS)
09 = Non-Domestic Depository (Foreign)
10 = Other
26 = DWAC Deposit
27 = Certificate Deposit
28 = DRS Profile/DO
36 = DWAC Withdrawal
Contra Firm Type must be:
DTCPRT; NSCPRT
DTCPRT
DTCPRT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT
DTCPRT
DTCPRT
AGTNBR
26
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
37 = Withdrawal by Transfer (WT)
41 = Direct Presentation
46 = Fund to Firm Mutual Fund Transfer
51 = Firm to Fund Mutual Fund Transfer
56 = Networking Transaction
57 = Manual Mutual Fund Transfer
AGTNBR
AGTNBR; CBRACT; DTCPRT
DTCPRT; NSCPRT
DTCPRT; NSCPRT
DTCPRT; NSCPRT
CBRACT; DTCPRT; NSCPRT
For the Firm Reject and Request Records
If the Transaction Type is:
01 = ACATS
02 = Free DTC Deliver Order (non-ACATS)
03 = Valued DTC Deliver Order
04 = Conversion
05 = Mutual Fund Transfer (non-ACATS)
[change of broker-dealer]
06 = FED (non-ACATS)
07 = Physical Movement Settlement
08 = OCC Transfer (non-ACATS)
09 = Non-Domestic Depository (Foreign)
10 = Other
26 = DWAC Deposit
27 = Certificate Deposit
28 = DRS Profile/DO
36 = DWAC Withdrawal
37 = Withdrawal by Transfer (WT)
41 = Direct Presentation
46 = Fund to Firm Mutual Fund Transfer
51 = Firm to Fund Mutual Fund Transfer
56 = Networking Transaction
57 = Manual Mutual Fund Transfer
Contra Firm Type must be:
DTCPRT; NSCPRT
DTCPRT
DTCPRT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
DTCPRT; NSCPRT; CBRACT
AGTNBR
AGTNBR
AGTNBR
DTCPRT
DTCPRT
AGTNBR; CBRACT; DTCPRT
DTCPRT; NSCPRT
DTCPRT; NSCPRT
DTCPRT; NSCPRT
CBRACT; DTCPRT; NSCPRT
The comments in the record layouts explain the roles of the submitter and contra firms by dividing
the transaction types into the following categories:
•
Firm to Firm:
01 = ACATS
02 = Free DTC Deliver Order (Non-ACATS)
03 = Valued DTC Deliver Order
04 = Conversion
05 = Mutual Fund Transfer (Non-ACATS) [change of broker-dealer]
06 = FED (Non-ACATS)
07 = Physical Movement Settlement (Non-ACATS)
08 = OCC Transfer (non-ACATS)
09 = Non-Domestic Depository (Foreign)
10 = Other
27
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
Firm & Transfer Agent:
o Agent submits/firm receives CBRS original/corrected record:
26 = DWAC Deposit
27 = Certificate Deposit
28 = DRS Profile/DO
o Firm submits/agent receives CBRS original/corrected record:
36 = DWAC Withdrawal
37 = Withdrawal by Transfer (WT)
o Either Agent submits/firm receives or Firm submits/agent receives CBRS
original/corrected record:
41 = Direct Presentation
•
Firm & Fund (In-kind Mutual Fund Transfers):
o Fund submits/firm receives CBRS original/corrected record:
46 = Fund to Firm Mutual Fund Transfer [via ACATS Fund/SERV interface; also
known as PTF, Position Transfer Fund ACATS transfer type]
o Firm submits/fund receives CBRS original/corrected record:
51 = Firm to Fund Mutual Fund Transfer [via ACATS Fund/SERV interface; also
known as PTF, Position Transfer Fund ACATS transfer type]
o Either fund submits/firm receives or firm submits/fund receives CBRS
original/corrected record:
56 = Networking Transaction
? In the case when an equity transfer agent/issuer is either the submitter or receiver of CBRS
records, does the system verify that Submitting or Contra Firm Type and Number is the right
transfer agent for that CUSIP, or just verify that the firm is an eligible CBRS User? CBRS
checks that the transfer agent is an eligible CBRS user; it does not confirm that the Firm
Number is the correct number for the CUSIP in that record. However, CBRS does populate
the Contra Firm Number in most cases when a transfer agent is the receiver. Please see the
Asset and Tax Lot Input record layouts for the rules for when CBRS populates the Contra
Firm Number.
4.4.6 Numeric fields
? In numeric fields, do I have to zero fill all the bytes before the actual number? For
example, in the Total Position Quantity field, if I send an asset record for 45.53 shares should
I send ‘00000000000045,53’ or can I send spaces instead of zeroes? You can send either
one. You can send 45,53 and CBRS adds leading zeroes; or you can send
00000000000045,53.
28
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4.4.7 Asset Category field
? Should the value in the Asset Category field be left justified with a space to the right if it is
a three letter code? In other words, the field is four bytes long, but for Asset Category EQU,
should the EQU be left justified with a space after the value or right justified with a space
before the value? The 3-letter value should be left justified, otherwise CBRS rejects the
record. So, for EQU, the submitter should populate the Asset Category field with ‘EQU_’
where the underscore represents a space.
4.4.8 Sum of the tax lot quantities must match the asset quantity
As discussed in an earlier section, an Asset record and its corresponding Tax Lot record(s) are a
package. The sum of the tax lot quantities must equal the quantity of the corresponding asset
record, or CBRS rejects the package.
CBRS sums the tax lot quantities and compares this sum to the value in the Total Position
Quantity field in the associated asset record. When calculating the total tax lot quantity, CBRS
adds the quantity of each long tax lot (value L = Long in the Position Code field), and subtracts the
quantity of each short tax lot (value S = Short in the Position Code field).
The number in the Total Position Quantity field on the asset record is considered to be positive
when the value in the asset record’s Position Code field is L = Long. The number in the Total
Position Quantity field on the asset record is considered to be negative when the value in the asset
record’s Position Code field is S = Short .
CBRS compares the Total Position Quantity on the asset record to the sum of the values in the
Tax Lot Quantity fields for the corresponding tax lot records, and rejects the record if the
quantities do not match.
4.4.9 Optional fields
? If an optional field is not filled in on the asset or tax lot input, what will be in that field on
the transaction output? The quantity and price fields will have zeros in them, other fields will
be blank.
4.4.10 Borrowed Position Code
The value “Borrowed” is only valid for a request record (Record Content Indicator = 04). This is
a rare situation that can occur when a short position is delivered outside of a standard ACATS
transfer. Figure 3 shows the steps for when a Borrowed value would be used.
29
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Figure 3. Information flow with a Borrowed position code
In step 4, when the Blue firm sends the proceeds of the short to the Yellow firm, he/she can use
either the Tax Lot Current Cost field or the Tax Lot Original Cost field, depending on the type of
asset. The Tax Lot Input record layout lists the rules for which cost field should be used for which
Asset Category type.
30
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4.4.11 ACATS Asset Sequence Number
CBRS includes the ACATS Asset Sequence Number on the Asset Input record layout as a result of
industry discussions about how to match cost basis to an asset transferred through ACATS which is
identified by a User CUSIP. A submitter and receiver may use a different User CUSIP to identify a
particular asset, such as a restricted security. The ACATS Asset Sequence Number is another data
element to help the receiver match an asset transferred through ACATS to the cost basis received
via CBRS.
The date 07/26/2012 in the rule in this field is based on the day before this field was added to the
CBRS code in the Production environment. The ACATS Asset Sequence Number is not required
for ACATS transfers whose ‘Date Transfer was Initiated’ or ‘Settlement Date of Transfer’ occurred
before the field was available in Production because some CBRS users may not have stored this
number in the past.
? What happens if I populate the “ACATS Asset Sequence Number” field for a transfer whose
settlement date is before 7/26/2012? If you populate the ACATS Asset Sequence Number for
a transfer whose settlement date is before 7/26/2012, CBRS validates that the field is a 6-byte
numeric field. If the value in the field passes that validation (and there are no other problems
with the record), CBRS passes the record to the receiver. If the value in the field does not
pass the validation, CBRS system rejects the record.
? What should I populate in the ACATS Asset Sequence Number field for transaction types
other than 01 = ACATS? For transaction types other than 01 = ACATS, the submitter should
leave this field blank. If you populate this field for a transaction type other than 01 = ACATS,
CBRS will space out the field and pass the record.
4.5
Output General Information
Firms receive a variable length Transaction Machine Readable Output (MRO) file via CDTS
(Output Product ID #02400264). A download of CBRS MRO files is available through WebDirect.
Firms using the WebDirect CBRS Inquiry function can download the CBRS transaction output file
to Excel (Output Product ID #02401663). Firms can download a daily end-of-day CBRS
transaction output file that will be available on WebDirect (Output Product ID #02401664).
The Cost Basis Transaction MRO output record layout is 1,500 bytes, which is 500 bytes longer
than the Asset and Tax Lot input record layouts. The output is longer because of a number of fields
that CBRS adds to the output after it processes the input. Further details about these additional
fields follow below.
CBRS sends all accepted cost basis data to eligible recipients. CBRS validates each field to ensure
that it meets the established validation rules. CBRS passes the cost basis data to the receiving firms
and does not verify the accuracy of the data submitted.
The Cost Basis Transaction MRO has three main components. The first component is a set of
CBRS system-generated output fields. The second component is a set of status fields for the Asset
and Tax Lot records received from the input file. The third component is the actual Asset and Tax
31
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Lot data fields that contain the cost basis information validated by the CBRS system. CBRS returns
the Asset and Tax Lot records to firms in the same sequence it received them: Asset record first, and
then all of the associated Tax Lot records.
The CBRS output includes both the records that a user submits, and the records that it receives from
other users. In the output, users can also see the submitted records that CBRS rejected. Each record
in the Cost Basis Transaction MRO file has a System Action field that labels the record as
Accepted, Modified, or Rejected.
? What are the primary keys for the Transaction MRO file? There is no primary key on the
file. The Cost Basis Control Number uniquely identifies a CBRS transfer which consists from
1 to many records (1 Asset record plus zero to many Tax Lot records that correspond to the
asset). To create uniqueness in your database you need to add a column, such as a sequence
number. The combination of these two columns creates a unique key within the table. If you
store the information in more than one table you need to identify your self-created keys in a
manner consistent with your database structure.
4.5.1 Distribution Side
The Distribution Side field on the MRO file corresponds to whom CBRS is sending the file. For
system rejected records, this field has a value of S = Submitting Participant, because only the
submitter receives system rejected records. For records successfully processed through CBRS, this
field has a value of B = Both Receiving and Submitting Participant, because CBRS sends
successfully processed records to both the submitting and receiving firm. The Cost Basis
Transaction MRO file also has a Distribution Firm Number and Distribution Firm Type. These
fields have the firm number and type for the user receiving the file.
4.5.2 Cost Basis Control Number
CBRS assigns a Cost Basis Control Number that uniquely identifies each Asset and associated Tax
Lot record(s). This number appears only on the Cost Basis Output sent to each firm. The Cost
Basis Control Number format is CCYYDDDCBNNNNNNNN (date + CB + eight digit number).
CBRS assigns the Cost Basis Control Number to each submitted asset.
All Tax Lot records associated with a particular Asset have the same Cost Basis Control Number as
that Asset.
The only exception is when a firm submits Tax Lot record(s) without a corresponding Asset record.
In this case CBRS assigns a separate Cost Basis Control Number to each Tax Lot record, and then
rejects it. Also, CBRS assigns a unique Cost Basis Control Number to rejected Cost Basis records
(Asset and their associated Tax Lot records) for identification purposes.
4.5.3 System Rejects
CBRS validates each field to ensure that it meets the established validation rules. If a record does
not pass these rules, CBRS rejects the record. CBRS returns rejected transactions, both asset and
32
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
tax lot records, only to the submitting firm. The intended receiver of the cost basis information does
not know the submitter attempted to deliver the information if the transaction is system rejected.

If CBRS rejects an Asset record, it also rejects all corresponding Tax Lot records. If
CBRS rejects one Tax Lot record, it also rejects all of the Tax Lot records and the associated
Asset record.
CBRS uses two fields to identify the error on a record: the System Action Code field and the
System Reject Reason field. For more information, please read the field descriptions below.
4.5.4 System Action field
The System Action field is in the beginning section of the output record of both the Asset or Tax
Lot record. The System Action field indicates if each record on the input file was accepted,
rejected, or modified. The values for the field are:
•
•
•
1 = System Accepted - Transaction submitted correctly
2 = System Modified - Transaction submitted correctly and modified by CBRS
3 = System Rejected - Transaction submitted incorrectly
Successfully passed records have a value of either 1 = System Accepted or 2 = System Modified
in the System Action field. System Modified means CBRS has changed a field in the record. For
more detail, see the bullet below on the System Changed value in the Status field.
4.5.5 System Reject Reason field
The System Reject Reason field specifies the reason that CBRS rejected the record(s). If the
System Action code is a ‘3’, the System Reject Reason field indicates the applicable reason.
The System Reject Reasons and their explanations are listed below.
•
•
•
•
•
•
•
01 = Invalid Field – one or more fields in the record has violated system rules
02 = Associated Record is Invalid – on an Asset record, this code indicates that one or
more of the associated tax lot records has violated system rules; on a Tax Lot record, this
code indicates that the associated asset record has violated system rules
03 = Invalid Length Record – the record does not conform to the 1,000 byte length
required by the record layout
04 = Invalid Physical Sequence – asset record not present – the Tax Lot record does not
have an associated Asset record
05 = Invalid Physical Sequence – tax lot record(s) not present – the Asset record does not
have an accompanying Tax Lot record
07 = Invalid Accumulated Quantity – the sum of the Tax Lot Quantity fields does not
equal the Total Position Quantity field on the associated Asset record
09 = No Corrected Tax Lot present for corrected Asset Input – an Asset Record with the
value ‘02 = Corrected asset record’ in the Record Content Indicator field does not have at
33
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
•
least one associated Tax Lot record with the value ’02 = Corrected tax lot record’ in its
Record Content Indicator field
10 = Invalid Physical Sequence – Tax Lot invalid with Asset Input reject or request –
an Asset record with either ‘03 = Firm reject record’ or ’04 = Request record’ in the Record
Content Indicator field has an associated Tax Lot record
Space = Not rejected – CBRS has not rejected the record
Note: numbers ‘06’ and ‘08’ are not currently in use.
4.5.6 Status Fields
On the output, each submitted field has a corresponding status field. This field indicates if the
value in the submitted field is valid, system changed, or error. A space is also a possible value for
this field: the space occurs if the field is an optional field, the submitter does not populate the field,
and the field does not have a default value.
CBRS populates the status fields for all records on the Transaction MRO file. For the records
where you are the contra party, the status is 0 = Valid, 1 = System Changed, or [space] which
indicates that this field was not populated by the submitter. If a submitted field does not pass CBRS
system rules, the status for that field is populated with a value of 2 = Error. When you are the
contra party, you do not receive a status field which has a value of 2 = Error, because CBRS rejects
a record that has an error in it and returns it to the submitter. CBRS does not pass a system rejected
record to the contra party.
? What if a submitter sends a corrected tax lot with an original asset record—what is the
system reject reason in this case? The System Reject Reason is 01 = Invalid Field, and the
TO Record Content Indicator Status value is 2 = Error.
4.5.7 Example of System Changed
System Changed appears in a Status field when CBRS changes a submitted value in a field.
For example, on the Tax Lot Input record, there is a Certificate Number field. This field is
allowed for only two transactions: 27 = Certificate Deposit and 41 = Direct Presentation. If a
submitter populates this field for any other transaction type, CBRS replaces the submitted value
with spaces and continues to process the record. In this case, the TO Certificate Number Status
field has a value of 1 = System Changed. You can refer to the record layouts to see the various
occasions where CBRS might modify submitted data.
4.5.8 Example of System Rejected
When an asset or tax lot record is rejected, CBRS rejects the asset record and all its accompanying
tax lots. CBRS treats an asset record and its tax lots as a package: when one piece is rejected, the
entire package is rejected.
34
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The example below illustrates what the MRO can contain when an asset record is rejected, but the
tax lot record conforms to system rules:
•
•
•
In this example, the CBRS “package” has one asset record and one accompanying tax lot
record. The asset record is rejected because the submitting firm populated the Settlement
Date of Transfer field with 20110135 (20110135 is the CBRS format for January 35,
2011). CBRS rejects the record because January 35, 2011 is not a valid calendar date. The
tax lot record passes system rules and edits with no errors.
On the Cost Basis Transaction MRO file for the asset record, the System Action field has
a value of 3 = System Rejected. The System Reject Reason field has a value of 01 =
Invalid Field. The AO Settlement Date of Transfer Status has a value of 2 = Error.
This combination of fields tells the submitter that the record is rejected, and why. (Other
fields on the MRO are populated as well, this example highlights fields related to the reject.)
On the Cost Basis Transaction MRO file for the accompanying tax lot record, the System
Action field has a value of 3 = System Rejected. The System Reject Reason field has a
value of 02 = Associated Record is Invalid. There are no 2 = Error values for the tax lot
record Status fields because it passes system rules and edits. This combination of fields
tells the submitter that record is rejected because of a problem with the associated record.
(Other fields on the MRO are populated as well, this example highlights fields related to the
reject.)
4.5.9 Output Dropped Records
CBRS drops a transaction in the rare occasion when a submitter enters their firm number
incorrectly, and CBRS does not recognize the submitter. In this case, CBRS rejects the record
because the submitter is invalid. However, CBRS cannot return the record to the submitter because
the incorrect submitter number does not match the submitter’s actual number, so CBRS does not
know where to return the record.
4.5.10 LPA Number and LPA Type
A Transfer Agent uses its LPA number as the deliverer of the DRS DO, and its Transfer Agent
number as the Submitting Firm Number on the CBRS record. Broker-dealers and banks who
receive cost basis from a transfer agent for Transaction Type 28 = DRS Profile/DO benefit from
having the LPA number on the transaction output because they can use the LPA number to more
easily match the DRS Profile/DO asset transfer to the CBRS record for that transfer.
On the MRO file, CBRS provides the Limited Participant Account (LPA) number for cost basis
passed on Direct Registration System (DRS) Profile/Deliver Order (DO) transactions. There are
two fields on the Transaction MRO file, LPA Number and LPA Type. ‘LPA Type’ is always
‘DTCPRT’. The LPA Number is the LPA number that a transfer agent uses to send DRS DO
transactions through DTC. CBRS populates these two fields only for original and corrected asset
and tax lot records, for Transaction Type 28 = DRS Profile/DO. Otherwise, both fields will contain
spaces.
In order for CBRS to populate the LPA Number in this field, DTCC’s Account Administration
department sets up a relationship between a transfer agent’s Transfer Agent (TA) number that is
35
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
currently eligible for CBRS, and it’s LPA Number. This functionality applies only to Transfer
Agents who are eligible for CBRS and have a Limited Participant Account number.
Transfer Agents who would like to opt out of this functionality should contact the Client Account
Representative Team at RMsupport@DTCC.com.
36
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5 Best Practices
This section contains Best Practices for CBRS as defined by various industry groups. These Best
Practices are not enforced by system rules, but instead are guidance to the users of CBRS on how to
handle certain situations and populate certain fields. While CBRS cannot enforce these Best
Practices with system rules, these guidelines help all CBRS users process the submitted and
received data in a consistent way.
5.1
Resolve issues with the contra party
If a firm has received cost basis data from a submitting firm that it cannot apply or did not expect,
the firm should contact the contra party directly. Similarly, if a firm does not receive cost basis
information that it is expecting, the firm should contact the contra party directly. DTCC is not able
to access firm data to respond to inquiries.
5.2
Firms should both submit and receive records
If a firm is a CBRS user, the firm should submit cost basis information, not just receive cost basis
information. CBRS users are expected to participate on both sides and for all transaction types.
While CBRS users are expected to participate on both sides, some firms may have limitations on
which transaction types they can submit. Firms with these limitations are expected to receive all
transaction types supported by CBRS, either through an automated computer to computer
connection or via WebDirect.
5.3
When should a firm send the CBRS record?
Send an Original record on the day after the item settles. If it is not possible to send the CBRS
record(s) the day after settlement, send them as soon as possible after settlement.
Send a Corrected record within fifteen days of knowing that the record needs to be corrected.
Send a Firm Reject record within two business days, except for a certificate deposit. For a
certificate deposit, if a firm receives partial shares from the Transfer Agent, wait to send the reject.
A receiver of an asset should wait at least fifteen days after the asset has been received before
sending a Request record to the deliverer of the asset.
5.4
Corrected Record
From the submitter’s point of view, the first time it sends basis, the submitter should send an
original record. If the basis on a particular lot changes after the original record is sent, the submitter
should send a corrected record. From the receiver’s point of view, if a contra party receives
corrected basis but has not first received original basis for the lot, it should treat the basis as original
37
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
and apply the basis appropriately (i.e. a contra party should not firm reject a corrected record that
does not have a corresponding original record).
? Which fields, when changed, should prompt the submitter to send a corrected record? Any
field that has been changed should be sent as a correction. If the data element is important
enough to be changed, it is important enough to re-send.
If you replay the basis on your books, and everything stays the same, do not send a
corrected record to the receiver. If you replay the basis on your books and anything is
different, send a corrected record to the receiver.
5.4.1 Some scenarios about corrected records
? For example, a fund sends a CBRS record that is system rejected by CBRS. When the fund
resubmits the record, marked as corrected, does CBRS accept the record? In other words
does CBRS have any edits in place to check that an original record passed through
successfully before a corrected record can be sent? No. CBRS does not confirm that a
corrected record has a corresponding preceding original record.
In that case, would a firm reject a corrected record back to the fund because it hasn’t received
an original record? Best Practices suggest that a receiver should not firm reject a corrected
record that does not have a corresponding original record(s). A receiver should be prepared to
accept either an original or corrected record.
? What about this scenario: a fund sends a CBRS record, it passes CBRS edits and is sent to
the receiving firm, and then the firm responds with a firm reject record. When the fund
responds with a corrected record, would the firm accept the corrected record, even though
they did not accept the original record? Yes. The receiving firm should accept the corrected
record. These Best Practices hold true regardless of what type of CBRS user is the submitter
or receiver: these same Best Practices apply to broker-dealers, funds, banks, and equity
transfer agents/issuers.
5.5
Firm Reject and Request Records
The scenarios below describe the Best Practices for the different Record Content types. In each
example, Firm A has transferred an asset to Firm B, and now needs to pass the cost basis for that
transferred asset.
•
•
•
Firm A sends an original record to Firm B. Some of the data is incorrect, so Firm B sends a
firm reject record to Firm A. Firm A responds with a corrected record.
Firm B has not received cost basis from Firm A. Firm B sends a request record to Firm A.
Firm A responds with an original record.
Firm A sends an original record to Firm C. Firm C is not the correct receiving firm for this
record, so it sends a firm reject record to Firm A. Firm A responds by sending an original
record to Firm B.
38
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Note that in the last example above, while CBRS does not require Firm C to send a Firm Reject, it
would be helpful for Firm C to Firm Reject the record so Firm A knows there is a problem. CBRS
does not reject the record if it passes all of the system rules and edits, so the only way Firm A
knows there is a problem with the record is if Firm C rejects it.
A user can also firm reject corrected records. Let’s look at an example, using the same Firm A,
Firm B, and Firm C as above:
•
Firm A sends a corrected record to Firm C. Firm C is not the correct receiving firm for this
record, so it sends a firm reject record to Firm A. Firm A responds by sending a corrected
record to Firm B.
A firm reject is not an appropriate response to a firm reject record or a request record. Best
Practices recommend that a firm disregard a firm reject or request record that it has received in
error.
? Can a CBRS user send a corrected record without first sending an original record?
CBRS does not reject a corrected record that was not preceded by an original record, but the
contra party may not accept the corrected record in this scenario. Best Practices say do not
send a corrected record unless you have first sent an original record.
The following Best Practices apply to many of the fields in the Firm Reject and Request record
content types (full list below):
If Record content indicator is 03 = Firm reject record, then the fields below should be populated
with the value on the Original asset record or Corrected asset record received.
If Record content indicator is 04 = Request record, then the fields below should be populated with
the value on the original transfer that triggered the need to pass cost basis.
List of fields where these two Best Practices apply:
•
•
•
•
•
•
•
•
•
•
•
•
•
Receiver Customer Account Number
Deliverer Customer Account Number
ISIN Country Code
ISIN Security Issue ID (CUSIP number)
ISIN Security Check Digit
Put - Call Indicator
Option Symbol
Option Expiration Date
Option Strike Price Integer
Option Strike Price Decimal
Asset Description
Asset Category
Total Position Quantity
39
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
•
•
•
5.6
Date Transfer was Initiated
Settlement Date of Transfer
Position Code
Shares to Cover Short Indicator
Do not request basis for lots received with unknown basis
A receiving firm should not request basis from a submitting firm if the receiver receives lots that
have unknown basis. Here are two examples:
•
•
5.7
Firm A sends cost basis to Firm B on a transfer of 300 shares of XYZ. Firm A
sends an asset record for 300 shares, and two tax lots, one for 100 shares and one for
200 shares. The tax lot for 100 shares has a cost amount associated with it, but the
200 share lot has an unknown cost amount. The records pass CBRS processing, so
Firm B receives all of this information.
o Best Practices say that Firm B should not request information on the 200
share lot that has unknown cost. A firm should use a request record only
when it has not received any information at all.
Firm A sends an ACATS transfer to Firm B that contains 10 assets. Firm A sends
CBRS records to Firm B, but only for 9 assets.
o In this case, Firm B should send a request record for the one asset for which it
did not receive a CBRS record.
Submitting and receiving noncovered accounts and noncovered security
types
Below are the Best Practices about submitting and receiving data for noncovered accounts and
noncovered security types:
•
•
5.8
From the submitter’s perspective:
1. If you have cost basis, send it
2. If you do not have cost basis, do not send anything (e.g., do not send a record
that says the lot is noncovered and has unknown cost basis)
From the contra party’s perspective:
1. Do not send a request record for an noncovered account or an noncovered
security type
2. If you receive basis for an account that is noncovered, do not reject it
3. If you receive basis for a security that you think is noncovered, do not reject
it
Covered fixed income assets that were transferred in 2014
The regulations for the transfer of fixed income assets became effective on January 1, 2015.
However, a CBRS user may receive basis on a fixed income asset in 2014 which the submitter has
marked as covered. When a CBRS user receives cost basis for fixed income assets in 2014 which
are marked as covered, the receiver needs to determine whether to consider those assets covered.
40
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5.9
The CBRS quantity should equal the original asset transfer quantity, i.e.
avoid fractional shares
In the previous version of CBRS, some firms sent an asset transfer for a round lot, and then follow
up in CBRS with a quantity that includes fractional shares. To avoid this discrepancy, the quantity
transferred through CBRS should equal the quantity of the original asset transfer that triggered the
need to pass cost basis. If the original asset transfer did not have fractional shares, neither should
the CBRS record.
? If there is a corporate action during an ACATS transfer, what happens in CBRS? Scenario:
100 shares of an asset are transferred via ACATS. During the ACATS transfer, there is a
stock dividend for 2 shares. In ACATS, the deliverer should send a residual balance of 2
shares. In CBRS, the deliverer should send a CBRS record for 100 shares, and then another
CBRS record for 2 shares. This answer follows the best practice that the CBRS quantity
should always equal the quantity of the asset transfer.
5.10 Populating CBRS records for ACATS reclaim or fail reversal transactions
Follow these steps for populating the Submitting Firm, Contra Firm, Deliverer Customer Account
Number, and Receiver Customer Account Number fields for ACATS reclaim (RCL) or fail reversal
(FRV) transactions:
The Submitting Firm is the firm submitting the CBRS record (and is the delivering firm of the asset
in ACATS). The Contra Firm is the firm receiving the CBRS record (and is the receiving firm of
the asset in ACATS). The Deliverer Customer Account Number is the account number at the firm
delivering assets in the "original" ACATS transfer, and the Receiver Customer Account Number is
the account number at the firm receiving assets in the "original" ACATS transfer. Both customer
account number fields do not correspond to the "new" Deliverer/Receiver Customer Account
Number for the FRV or RCL.
For example, Firm 789 submits a TIF for a full transfer to Firm 123. Firm 123 delivers the assets to
Firm 789. (For the purpose of this example, the transfer contains only long assets.) Later, Firm 123
submits a fail reversal or a reclaim to Firm 789. Firm 789 sends the asset to 123 in response. The
customer account number at Firm 123 is 10203, and the customer account number at Firm 789 is
70809. The following table illustrates how CBRS records should be populated for the full transfer,
and the fail reversal or reclaim.
41
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
ACATS
CBRS
Deliverer
Customer
Account
Number
Receiver
Customer
Account
Number
Record
Type
Submitting
Firm
Contra
Firm
Deliverer
Cust.
Account
Number
Receiver
Cust.
Account
Number
789
10203
70809
Original
123
789
10203
70809
123
789
10203
70809
Corrected
123
789
10203
70809
789
123
789
10203
70809
Firm
Reject
789
123
10203
70809
FUL
789
123
789
10203
70809
Request
789
123
10203
70809
FRV/
RCL
123
789
123
10203
70809
Original
789
123
10203
70809
FRV/
RCL
123
789
123
10203
70809
Corrected
789
123
10203
70809
FRV/
RCL
123
789
123
10203
70809
Firm
Reject
123
789
10203
70809
FRV/
RCL
123
789
123
10203
70809
Request
123
789
10203
70809
Transfer
Type
TIF
Submitter
Asset
Asset
Deliver
Receiver
FUL
789
123
FUL
789
FUL
5.11 Sending a CBRS record for an asset held in multiple currencies
? Do I send multiple asset records for the same security if I hold the security in different
currencies? Remember that the quantity of the asset record should correspond to the quantity
of the original transfer that triggered the need to pass cost basis. You can indicate at the tax
lot level which lots are held in a currency other than US Dollars.
5.12 Sending cost basis for an invalid certificate
? If a transfer agent receives a deposit for 100 shares consisting of two 50 shares certificates,
and only one certificate can be processed at this time (e.g., one of the certificates is invalid),
how should cost basis be returned? Best Practices suggest that, since in this case a transfer
agent can only re-register 50 shares, it would only pass basis on the 50 shares that are reregistered.
5.13 Field Specific Best Practices
After each field name below: (A) indicates a field on the Asset Input; (T), a field on the Tax Lot
Input; and (A/T), a field on both the Asset and Tax Lot Input.
42
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5.13.1 Transaction Type (A/T)
CBRS users should not firm reject a record based solely on a mismatched Transaction Type. If a
user receives a record with a Transaction Type it does not recognize, the user should examine other
criteria in the record to match an asset transfer
Transaction type 05 = Mutual Fund Transfer (non-ACATS) [change of broker-dealer] is for brokerto-broker transfers, and requests for this transaction type should not be sent to a fund.
5.13.2 Transfer Control Number (A/T)
If transaction type is 02 = Free DTC Deliver Order (Non-ACATS), or 03 = Valued DTC Deliver
Order; this field should be the IMS Transaction ID number (16 bytes) as specified on the original
transaction processed at DTC.
If transaction type is 26 = DWAC Deposit, 27 = Certificate Deposit, 28 = DRS Profile/DO, 36 =
DWAC Withdrawal, 37 = Withdrawal by Transfer (WT); this field contains a reference ID number
whose values and number of bytes changes depending on the original transaction processed at
DTC. The CBRS Transfer Control Number should equal the reference ID for DAMP Deposits at
DTC.
If transaction type is 41 = Direct Presentation; this field should be 26 characters:
Julian Date (3 bytes: DDD) + Participant Number (5 bytes) + Customer Account Number (18 bytes)
If transaction type is 46 = Fund to Firm Mutual Fund Transfer or 51 = Firm to Fund Mutual Fund
Transfer; this field is the FundSERV control number. Firms should use the Fund/SERV Control #
from the ACATS Fund/SERV Statistics File, and add the letters ‘CATS’ to the front of it, in order
to match the number that Funds should provide in this field.
If transaction type is 56 = Networking Transaction, then the control number is the Networking
control number
For all other transaction types, 04 = Conversion, 05 = Mutual Fund Transfer (Non-ACATS), 06 =
FED (non-ACATS), 07 = Physical Movement Settlement, 08 = OCC transfer, 09 = Non-Domestic
Depository, 10 = Other, 57 = Manual Mutual Fund Transfer; this field is the control number agreed
upon by the contraparties involved in the original securities transaction.
5.13.3 Alternate Control Number (A/T)
For Transaction Types 46 = Fund to Firm Mutual Fund Transfer or 51 = Firm to Fund Mutual Fund
Transfer, populate this field with the ACATS Control Number.
5.13.4 Asset Description (A/T)
Populate this field for all records.
43
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5.13.5 Asset Category (A)
 Take care to populate this field accurately.
This value should correspond to the asset
category for the transferred security. This is an important field that drives validation rules
for the rest of the record.
5.13.6 Transferring basis on rights or warrants
A deliverer should only pass basis for warrants or rights that were purchased for cash. Cost Basis
allocated under rule 305 or 307 should not be transferred; instead, it should be re-allocated back to
the underlying security.
5.13.7 Receiver Customer Account Number (A/T)
If a firm does not have a receiver customer account number, Best Practices suggest entering the
words “not provided” in this field. For ACATS items this Best Practice does not apply—a
submitting firm does have a receiver customer account number for assets transferred through
ACATS.
5.13.8 Deliverer Customer Account Number (A/T)
The submitter should populate this field for Transaction Type 04 = Conversion.
5.13.9 Total Position Quantity/Tax Lot Quantity (A/T)
? How do I populate the quantity fields for fixed income and options? For example, if I
transfer 10 option contracts at 100 shares per contract, should I populate the quantity field
with 10 or 100? For an option, the submitter should populate the quantity field with the
number of contracts. So, in this example, the submitter should populate the quantity field with
‘10’. For fixed income, if I transfer 10 bonds with a total face value of 10,000, should I
populate the quantity field with 10 or 10,000? For a fixed income asset, the submitter should
populate the quantity field with the asset’s face value. In this example, the submitter should
populate the quantity field with 10,000.
5.13.10
Date Transfer was Initiated and Settlement Date of Transfer (A)
Best Practices define the Settlement Date of Transfer, in general, as the day the position leaves the
submitter’s books.

For options transferred through ACATS, the submitter should populate the Settlement
Date of Transfer with the ACATS settlement date. For options transferred at the Options
Clearing Corporation (OCC) outside of ACATS, the submitter should populate the
Settlement Date of Transfer with the date the option settled at the OCC.
44
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide

For covered fixed income transferred through the Federal Reserve, the submitter should
use the date the transfer settled at the Fed to populate the Settlement Date of Transfer.
While the Date Transfer was Initiated may not be known for the underlying transfer, the
Settlement Date of Transfer should be known. One or the other of these dates is required. Best
Practices suggest that the Settlement Date of Transfer will be used for most records.
5.13.11
Disposition Method Used (A)
The field has a limited list of values of potential disposition methods. As it states in the record
layouts, the list of values for this field are not exhaustive—there are other methods that firms use.
The field is also Optional, and not all firms use it. For firms who do use it, the field could provide
value-added information for the underlying customer. Best Practices suggest that firms should try
to use the field on a best-efforts basis.
5.13.12
Shares to Cover Short Indicator (A)
This field is used in the following example:
A customer moves to Firm A, and requests that Firm A delivers shares to Firm B to cover a
short at Firm B. When Firm A sends the cost basis, populating the Shares to Cover Short
Indicator with the Y value tells Firm B that the intent is to close out the short.
Sometimes in this situation, Firm B establishes a new position, has both a short account and a long
position on its books, and awaits customer instructions. This field eliminates this last step.
5.13.13
Noncovered/Pending Indicator (T)
If field is left blank, the receiver will consider the lot covered if the Position Code is L = Long. If
the Position Code is S = Short, the covered status of the position is not determined until the shares
are acquired.
Examples of when a submitter would use the Noncovered account value or the Pending value:
• Noncovered account: an Noncovered account can be either an account belonging to an
exempt recipient (such as a C Corporation) or an exempt account (such as a retirement
account)
• Pending: an account can be pending because the asset is a part of an Employee Stock Plan,
or because the submitter is waiting for cost basis information from a prior firm
• Certificate in Customer Name: this field should be used to indicate that a certain tax lot is
restricted or physical. These shares are always noncovered from the broker-dealer’s
perspective: the Transfer Agent has responsibility for the cost basis. The broker may have
the basis on its books, but if so, it has been provided by the customer.
45
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
For example, a broker-dealer receives a transfer of 1,000 shares of ABC, 300 restricted
shares 700 cash shares. The broker-dealer segregates the restricted shares from the cash
shares. When the contra party sends cost basis to the broker-dealer through CBRS, it uses
this new indicator to mark the 300 shares as noncovered using the “Certificate in Customer
name” value. When the broker-dealer receives the cost basis, it knows to apply the basis for
these 300 shares to the 300 restricted shares in the transfer. Without this indicator, the
receiver would not know what basis to apply to the restricted shares.
Please note that the submitter should not use the 01 = Noncovered lot value in this situation.
Shares may be noncovered for other reasons. If the shares are noncovered because they are
restricted or physical, the submitter needs to use the value “Certificate in Customer Name”.
? What are some examples of when different values in the “Noncovered/Pending Indicator”
would be used?
o “Noncovered lot.” A noncovered lot could occur in this scenario: a customer
transfers 300 shares of equity XYZ, containing two tax lots, one lot of 100 shares,
purchased on 05/29/2009, and one lot of 200 shares purchased on 06/01/2011. The
lot of 100 shares was purchased before the IRS regulations came into effect for
equities so this lot is uncovered. The lot of 200 shares was purchased after the IRS
regulations came into effect for equities, so this lot is covered. When passing cost
basis on this customer transfer, the record for the lot of 100 shares would have a
value of “Noncovered lot” in the “Noncovered/Pending Indicator”.
o “Noncovered account.” An example of a Noncovered account is a retirement
account.
o “Pending.” “Pending” could occur in this scenario: A customer transfers an asset
from Firm A to Firm B. A month later, the same customer transfers an asset from
Firm B to Firm C. Firm B is obligated to send cost basis to Firm C, but has not yet
received the basis from Firm A. Firm B sends the lots to Firm C, marked as
“Pending.” Firm B sends corrected records to Firm C once it has received the cost
basis from Firm A.
? Scenario: I send a CBRS transaction to a contra party that includes a lot that is pending
(i.e. has a 03 = Pending value in the Noncovered/Pending Indicator) because I am waiting for
basis from the prior firm. When I received that basis, and then send it on to the contra party,
do I send an original record or a corrected record? In this scenario, you should send a
corrected record.
5.13.14
Taxes Reported by Issuer/Transfer Agent (T)
In some cases the issuer/transfer agent does the 1099-B reporting. This field allows the
issuer/transfer agent to tell the broker-dealer that it has already done the 1099-B reporting for a
given tax lot, in order to avoid both parties reporting the information.
? Does the Taxes Reported by Issuer/Transfer Agent field apply only to the current year’s tax
reporting? No. There can be circumstances where the reorg event affects multiple years.
46
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5.13.15
Gifted or Inherited Indicator (T)
The gifted and/or inherited information in CBRS cannot be cross-referenced with the value in the
Gift/Donation Indicator in ACATS. The gifted and/or inherited information in CBRS is used to
establish the value of the tax lot. The gift indicator in ACATS is used to tell the receiver that the
deliverer is sending a transfer where the account titles do not match, and the deliverer or requestor
is aware of this discrepancy.
It is always recommended to deliver gifted or inherited securities and not request them through
ACATS. However, if you do not abide by this rule and request an inherited or gifted security, it is
the obligation of the receiver to step up the basis.
? What is the significance of the 03 = Inherited, then Gifted value in the Gifted or Inherited
Indicator on the Tax Lot Input record layout? This value exists because of its impact on the
holding period for the lot. Gifted shares have a short term holding period, inherited shares have
a long term holding period. If an investor gifts inherited shares, the lot should keep its long
term holding period. For example, an investor inherits shares. The same investor then gives
these shares to his daughter. In this case, populate the Gifted or Inherited Indicator field with
the value 03 = Inherited, the Gifted, in order to inform the receiver of the CBRS record that the
lot should keep its long term holding period.
? Where on CBRS can I indicate the date of inheritance? The submitter does not enter the date
of inheritance, as in the date the shares were inherited. Instead, the submitter should enter the
date of death of the decedent in the Acquisition Date of Tax Lot field.
5.13.16
Fair Market Value as of Date of Gift (T)
The submitter should populate this field if the value is known for a gifted security.
 For bonds, should be unadjusted for amortization or accretion. Basis adjustments should
be made for all other security types
5.13.17
Position Code (T)
In this field, transfer agents and mutual funds should default to L = Long position.
5.13.18
Position Code for options (T)
? When I am submitting a record to CBRS, how do I differentiate between writing the call
and buying the call? You can indicate whether you bought the call or wrote the call using
the ‘Position Code’ field to label the tax lot as either Long or Short.
5.13.19
Populating Acquisition Date of Tax Lot field when date is unknown (T)
47
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
How a submitter populates the Acquisition Date of Tax Lot field varies depending on the scenario.
Below are the two scenarios:
A. When the acquisition date and the cost basis are both unknown
1. Populate the Noncovered/Pending Indicator field with the appropriate value for the
lot. Populating this field tells the receiver that the lot is noncovered or pending.
2. Do not populate any date or cost fields
3. Populate the Zero Basis Indicator with the value 02 = Unknown
B. When the acquisition date is unknown and the cost basis is known
1. Populate the Noncovered/Pending Indicator field with the appropriate value for the
lot. Populating this field will tell the receiver that the lot is noncovered or pending.
2. Best Practices suggest you can a date of 01/01/1901* (19010101 in CBRS record
layout format) to signify an unknown date.
3. Populate the cost field(s) as applicable
*Note—the date 01/01/1901 can mean different things:
• If the lot is noncovered, 01/01/1901 can mean various dates or unknown date
• If the lot is covered, 01/01/1901 means various dates
? When can 01/01/1901 mean various? Best practices suggest that IRS regulations allow the
grouping of lots (covered lots into one group, noncovered lots into another group) for lots older
than five years for mutual funds and shares in a DRP plan. So in this context, when lots are
grouped together, the 01/01/1901 date can mean various.
5.13.20
Original Acquisition Date for Wash Sale Adjustment (T)
The submitter should populate this field if the tax lot is the result of a wash sale. If the Original
Acquisition Date for Wash Sale Adjustment is submitted, then the Wash Sale Adjustment Amount
must also be populated.
5.13.21
Wash Sale Adjustment Amount (T)
The Wash Sale Adjustment Amount is commonly referred to as the Disallowance Amount. The
Wash Sale Adjustment Amount represents the disallowed loss from a wash sale, which has been
added to the Tax Lot Current Cost.
In the event that the Wash Sale equals zero for a fixed income security, then the Wash Sale
Adjustment Amount field must be populated with zero, blanks are not accepted in this scenario.

Neither the Tax Lot Original Cost, nor Tax Lot Current Cost basis of a fixed income
security should be adjusted for the disallowed loss resulting from a wash sale.
 The Wash Sale Adjustment Amount should be applied to the Tax Lot Original Cost,
and Tax Lot Current Cost basis for the disallowed amount when assets are not fixed
income.
5.13.22
Exchange Rate (T)
48
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
This field should be the spot exchange rate used for converting the Tax Lot Current Cost as of the
acquisition date of the tax lot. The rate is the amount of local currency equal to one dollar. For
example, if ISO Currency Code = JPY, the value in this field is 86,4428 for acquisition date
12/01/2009.
5.13.23
Tax Lot Original Cost (T)
In this field, the submitter should include total original cost for asset backed securities.
In the event of a wash sale for an equity security, the Tax Lot Original Cost should be
adjusted for the Wash Sale Adjustment Amount.

For covered fixed income securities, do not adjust the Tax Lot Original Cost for
corporate actions.
 The Tax Lot Original Cost should be populated for asset backed securities.
 If you are not amortizing or accreting a bond, the original cost and current cost for that
bond could be the same.
5.13.24
Tax Lot Current Cost (T)
If Position Code is S = Short and the security is covered by the legislation, this field should equal
the gross proceeds of the short position.
For lots using average cost, populate this field with the pro-rata average cost.
This field includes this Best Practice: “For a noncovered average cost mutual fund position with at
least one lot with unknown basis, populate this field with the actual current cost for each lot with
known basis.”
This means that the submitter should populate this field with the actual current cost for the lot
without consideration for averaging. For example, a submitter has three lots. The submitter should
populate the Tax Lot Current cost fields for the lots as follows:
Tax lot quantity Tax lot cost
100
$700
200
$2,000
50
unknown
Value in the
Tax Lot Current Cost field
$700
$2,000
$0, with a value of
02 = Unknown in the
Zero Basis Indicator field
49
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The submitter should not average all three lots together, and then populate the Tax Lot Current
Cost field for each lot with its corresponding portion of the average.
Best Practices indicate that a submitter should send the cost of the individual lot. However,
sometimes the average cost is the only value that is known. In that case the submitter should send
the average cost value in the Tax Lot Current Cost field. If neither the individual cost of the lot nor
the average cost of the lot is known, the submitter should send the lot with unknown cost.
? How do I indicate a negative value in the Tax Lot Current Cost field?
CBRS does not accept negative numbers.

If you are not amortizing or accreting a bond, the original cost and current cost for that
bond could be the same.
 Adjust the Tax Lot Current Cost field for fixed income securities in the event of wash
sales, corporate actions, return of principal, OID, accretion, amortization as of the settlement
date of the transfer.
5.13.25
Zero Basis Indicator (T)
? When would a firm use the value 01 = True Zero? A submitter could use the value 01 =
True Zero in dealing with rights, or the return of capital.
5.13.26
Tax Lot Original Unit Price (T)
Populate for a mortgage-backed security, if known.
5.13.27
Employee Plan Shares Indicator (T)
If this field is populated, a third party—not the submitter—should provide the cost basis for the tax
lot.
5.13.28
Fields for fixed income elections (T)
The table below describes how a submitter should fill out the five fields related to fixed income
elections, if the submitter is following the defaults outlined in the IRS regulations.
 Please note that ‘default’ refers to the regulations, and not to a CBRS system default.
CBRS does not automatically populate any of these fields.
Election
Default per
IRS regulations
50
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Election to Accrue Market Discount using a constant yield
N
Election to Include Market Discount in Income currently
N
Election to treat all Interest as OID
N
Election to Amortize Premium
Y
Spot Rate election for interest accruals with respect to a covered debt
instrument denominated in a currency other than the U.S. dollar
N
5.13.29
Purchase/ Dividend Reinvestment Indicator (T)
The IRS default value for the Purchase / Dividend Reinvestment Indicator is P= purchase.
5.13.30
Market Discount (T)
Market Discount information if applicable, should be included in the cost basis submissions for only
CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities,
Municipals and Zeroes.
 Below is a summary of Best Practices applicable to populating the Market Discount
field.
Market Discount
Situation
Election to include
market discount in
income currently is not
made
Include
Market
Discount in
Income
Election
No
Market Discount
Amount should be 0.00
Market Discount is
deferred.
Current Cost
Note: Should not include wash sale
adjustments or disallowed carryover
amount
Current Cost should not include any
accretion of Market Discount
51
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
No
Amount should reflect
the accreted Market
Discount from
acquisition date to
settlement date of
transfer.
Amount should reflect
the accreted Market
Discount from the
settlement date of
acquisition to the date
of revocation
Yes or No
Because current
inclusion is
presumed with
the Al Income
as OID
election, the
election may be
populated with
either Y or N.
Amount should reflect
the Market Discount
accreted through the
settlement date of the
transfer
Current Cost should include the
amount of accreted Market Discount
from settlement date of acquisition to
the settlement date of transfer
Revocation of All OID
Election - Does not
allow for revocation of
current inclusion
Yes
Amount should reflect
the accreted Market
Discount through the
settlement date of the
transfer
Current Cost should only reflect the
amount accreted through the
settlement date of transfer
Default of debt
instrument purchased at
a market discount
Current Inclusion
election is not made
No
Amount should be 0.00
Current Cost should not include any
accretion of Market Discount
Yes
Amount should reflect
the accreted Market
Discount through the
settlement date of the
transfer
Current cost should reflect the
Market Discount amount accreted
through the settlement date of the
transfer
Election to include
market discount in
income currently is
made
Election to include
market discount in
income currently is
revoked
Treat All Interest as
OID Election is Made
(Election to include
market discount in
income currently is
presumed) **
Default of debt
instrument purchased at
a market discount Current Inclusion
election is made
Yes
Current Cost should include the
amount of accreted Market Discount
from acquisition date to the
settlement date of transfer
Current Cost should include the
accreted Market Discount from
settlement date of acquisition to the
date of revocation
52
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Default of debt
instrument purchased at
a market discount All
OID election is made
Yes or No
Because current
inclusion is
presumed with
the Al Income
as OID
election, the
election may be
populated with
either Y or N.
Amount should reflect
the accreted Market
Discount through the
settlement date of the
transfer
Current cost should reflect the
Market Discount amount accreted
through the settlement date of the
transfer
** If the election to include income currently is not made, there is no additional impact if the All Income as
OID election is made
5.13.31
Bond Premium (T)
Bond Premium information if applicable, should be included in the cost basis submissions for only
CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities,
Municipals and Zeroes.
 Below is a summary of Best Practices applicable to populating the Bond Premium
field.
Bond Premium
Situation
Broker Default
to Amortize
Amortize
Bond
Premium
Election
Yes
Bond Premium
Amount should reflect
amortized Bond
Premium from
acquisition date to the
date of the last interest
payment (last interest
payment date since
amortization is only
allocable to interest
payments)
Current Cost
Note: Should not include wash sale
adjustments or disallowed carryover
amount
Current Cost adjusted for the amount of
amortized Bond Premium from
acquisition date to the date of last interest
payment (i.e. last interest payment date
since amortization is only allocable to
interest payments)
53
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Client
Notification to
not amortize
No
Revocation of
notification to
not amortize
Yes
Interest as OID
election = Y **
Yes
Default of debt
purchased at a
Bond Premium
with the default
to amortize
Yes
5.13.32
For bonds purchased in
the year the election is
made or thereafter, this
amount should be 0.00.
For bonds purchased in the year the
election is made or thereafter, Current
Cost should be unadjusted for any Bond
Premium
For bonds purchased in a
year prior to the election,
this amount should be
the amount of amortized
Bond Premium from the
settlement date of
acquisition to the date of
the notification to not
amortize
For bonds purchased in a year prior to the
election, Current Cost should be adjusted
by the amount of amortized premium
from the date of acquisition to the date of
the notification to not amortize
Amount of amortization
from the date of
revocation to the
settlement date of
transfer
Amortization amount
through the settlement
date of the transfer
(Because All income as
OID is on an accrual
basis, amortization is
done daily, not based on
interest payment dates)
Current Cost adjusted for the amount of
Bond Premium amortized from the date
of revocation to the settlement date of
transfer
Amount of amortized
Bond Premium from
settlement date of
acquisition to the date of
the last interest payment
received
Cost adjusted for the amount of
amortized Bond Premium from date of
acquisition to the date of the last interest
payment received
Current Cost includes amortization
amount through the settlement date of the
transfer (Because All income as OID is
on an accrual basis, amortization is done
daily, not based on interest payment
dates)
Acquisition Premium (T)
Acquisition Premium information if applicable, should be included in the cost basis submissions for
only CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed
Securities, Municipals and Zeroes.
 Below is a summary of Best Practices applicable to populating the Acquisition
Premium field.
54
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Acquisition Premium
Situation
No Applicable
Election
Default of debt
purchased at an
acquisition
premium
5.13.33
Acquisition Premium
Current Cost
Note: Should not include wash sale
adjustments or disallowed carryover
amount
Amount of acquisition premium
accreted from the settlement
date of acquisition through the
settlement date of transfer
Cost adjusted for the amount of
acquisition premium accreted from the
settlement date of acquisition through the
settlement date of transfer
For OID bonds purchased at par
or at a bond premium, this
amount should be 0.00 or equal
to the amount of accrued OID
For OID bonds purchased at par or at a
bond premium, this amount should be
0.00 or equal to the amount of accrued
OID
Amount of acquisition premium
accreted from the settlement
date of acquisition through the
settlement date of transfer
Cost adjusted for the amount of
acquisition premium accreted from the
settlement date of acquisition through the
settlement date of transfer
Accrued OID (T)
Accrued OID information if applicable, should be included in the cost basis submissions for only
CD’s, Commercial Paper, Corporates, Foreign Debt, Governments, Mortgage Backed Securities,
Municipals and Zeroes.
 Below is a summary of Best Practices applicable to populating the Accrued OID field.
55
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Accrued Original Issue Discount (OID)
Situation
Election to treat all
income as OID is
not made
Interest as
OID Election
No
Accrued OID
Amount of OID
accreted from the
settlement date of
acquisition through the
settlement date of
transfer
For OID Bonds
purchased at par or at a
bond premium, this
amount should either be
0.00 or equal to the
amount of acquisition
premium
Election to treat all
income as OID is
made
Yes
Amount of OID
accreted from the
settlement date of
acquisition through the
settlement date of
transfer
Current Cost
Note: Should not include wash sale
adjustments or disallowed carryover
amount
Current Cost adjusted for amount of
OID accreted from the settlement
date of acquisition through the
settlement date of transfer
For OID Bonds purchased at par or at
a bond premium, there is no basis
adjustment for OID (OID =
Acquisition premium so they offset
each other)
Current Cost should be adjusted by
the amount of accreted OID
The amount should not
include interest
payments, accretion of
Market Discount, Bond
Amortization or
amortization of
Acquisition Premium
Default of debt
issued at an
Original Issue
Discount
Amount of OID
accreted from the
settlement date of
acquisition through the
settlement date of
transfer
Amount of OID accreted from the
settlement date of acquisition through
the settlement date of transfer
56
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5.13.34
Last Adjustment Date (T)
The Last Adjustment Date occurs when the last basis adjustment was made to account for Bond
Premium, Acquisition premium, Market Discount or OID
 For OID bonds purchased at a premium, this date should be the last date as of which the
bond premium was amortized (Acquisition premium and OID nets to 0.00 so the relevant
date is the last interest payment date used for amortization of bond premium)
 For OID bonds purchased at a market discount where market discount is deferred, this
date should be the settlement date of the transfer as this is the last date as of which OID was
accreted
 In the instance where the current inclusion election was revoked, this date should reflect
the date of revocation (i.e. when accretion of Market Discount stopped). In all other
instances, this should be the settlement date of the transfer.
5.13.35
Carryover Offset Future Use(T)
This field will not be used. If Carryover Offset this field is populated, it will be overlaid with
zeroes and passed.
5.13.36
Disallowed Carryover Offset (T)
The amount of Amortized Bond Premium to be carried over to the date of disposition (The
Current Cost basis should NOT be adjusted by this amount). The Carryover Offset amount must
be carried over until the disposition of the asset.
 This occurs in the instance where debt purchased at a Bond premium is not amortized
and then in a later year, the client revokes the decision.


For example; if a client elects to not amortize in year 1, then subsequently changes their
election to amortize going forward, the year 1 amortization would be placed in the Carryover
Offset field.
The Carryover Offset is sometimes also called “Excess Bond Premium.”
57
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
6 File Input and Output via Common Data Transfer Service
(CDTS)
6.1
General Information
The Common Data Transfer Service, or CDTS, is DTCC's proprietary file input and output
management system. It enables DTCC and its participants to securely and reliably automate the
exchange of files over a network link. Once a secure network connection is configured, minimal
set-up is required to automate inbound and outbound file transfers. Two industry standard file
transfer protocols are supported, FTP and Connect:Direct (NDM). DTCC operations staff actively
monitors these systems and addresses any failed transmissions. Both systems are available in the
test and production environments.
o Input: The transaction input has a CDTS input header and CDTS input trailer.
o Output: The transaction output has a CDTS output header, and a CBRS application output
header, and a CBRS application output trailer. There is no CDTS output trailer.
o The table below shows the order of the header, transaction records, and trailer in the file:
Input
Output
CDTS input header CDTS output header
CBRS records
CBRS application header
CDTS input trailer CBRS records
CBRS application trailer
For questions about CDTS, please call the Customer Support Hotline at 888-382-2721, option 6,
then option 7, then option 2.
6.2
File Input
CBRS uses only variable length input files. There are no fixed length input files. The CBRS input
cut-off time is 4:00 PM ET.
 The Input SYSID for CBRS input files is 36708.
A CDTS input header record is required. It is the first record in any file transmitted. The CDTS
input trailer record is also required, and is the last record in any file transmitted.
The record layouts for the CDTS input header and trailer records (named Datatrak Header and
Trailer in the layout) can be found on the dtcc.com website at:
http://dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/public-documents.aspx
? The asset and tax lot input records are always 1,000 bytes. The transaction output is
always 1,500. Why are these records “variable?” While it may not be apparent in the
current record layouts, the records have variable functionality built into them for future
58
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
expansion. For now, the asset and tax lot input records are always 1,000 bytes long, and the
transaction output record is always 1,500 bytes long. In the future, the record layouts can be
expanded to as large as 4,000 bytes. We have left this extra room to allow for more fields,
in case they become necessary in future versions of the system. This possible expansion
gives the records the “variable” designation. We do not make the records 4,000 bytes today
because we do not want to take up disk space that we do not need.
NSCC’s Automated Customer Account Transfer Service, or ACATS, uses this functionality,
so we’ll look at ACATS as an example. Here’s what the Record Length field looks like in
the variable ACATS Asset Input record layout:
Field Name Length Start
End
Type
Record
Length
6
NUM
4
3
Opt/Req/ Comments
Cond
REQ
Asset Type
Option
Mutual Fund
Insurance
Foreign
All Others
Record Length
497
550
1700
831
431
These different lengths illustrate the use of a variable record. The length of the record varies
based on the type of asset in the record. CBRS is not currently using this functionality, but
has the option to use it in the future if the need arises.
? Can a firm send multiple files to CBRS during the day? Yes. You can send multiple files
each day, through both the computer to computer connection and WebDirect. CBRS
combines all the input and processes it at the end of the day, and sends the output in one file.
? If my firm does not have any CBRS transactions to submit to DTCC on a given day, can I
send an empty file? Yes, you can send an empty file with only a CDTS header. You can
also not send any file at all.
6.3
File Output: Transaction MRO
A CBRS application header record is the first record in the CBRS transaction MRO file. See below
for the CBRS application header and trailer record layouts.
 The Output Product ID for the CBRS Transaction MRO is 02400264.
The record layout for the CDTS output header record (named the Autoroute Header in the layout)
can be found on the dtcc.com website at:
http://dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/public-documents.aspx
? If my firm does not have any CBRS transaction output for a given day (meaning my firm
is not the submitter or receiver of any CBRS records), will I receive a transaction output
59
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
file? The answer is yes if you are set up to receive an empty file. When you set up your
access to CBRS, you can ask to receive an empty CBRS transaction output file in this
situation. The file will contain only a CDTS header.
6.4
File Output: Cost Basis User Master File MRO
The Cost Basis User Master File MRO does not have an application header. The file has a CDTS
header. The record layout for the CDTS output header record (named the Autoroute Header in the
layout) can be found on the dtcc.com website at:
http://dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx
 The Output Product ID for the Cost Basis User Master File MRO is 02561666.
6.5
Limits on when output files and data are available
Files are stored in WebDirect for four business days.
DTCC can retransmit files for fourteen calendar days.
Data is available for viewing on WebDirect screens, using the Cost Basis Inquiry screen, and
downloading to an Excel spreadsheet, for twenty-five business days.
After the twenty-five business day window has passed, DTCC will not be able to provide
CBRS data to users. Users are responsible for storing their data on a long-term basis.
6.6
•
•
Input and Output timing
Input: for today’s processing date, firms can submit CBRS records between 8 PM ET
yesterday and 4 PM ET today.
o Files submitted between 8 PM ET yesterday and 4 PM ET today should have today’s
date in the header
o Files with today’s header date, submitted between 4 PM and 8 PM today, are
processed with tomorrow’s processing date
o Files with tomorrow’s header date, submitted between 4 PM and 8 PM today, are
rejected by CDTS
Output: for today’s processing date, CBRS transaction output and the Daily Deposit File for
Transfer Agents is available by 9 PM ET today. The Cost Basis User Master File is
available by 11 PM ET today.
 This schedule applies to input and output through both the automated computer to
computer connection, and via WebDirect.
60
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
6.7
CBRS Application Output Header
A CBRS application header record is the first record in any CBRS MRO file transmitted. The
following is the layout of this application header:
CBRS APPLICATION OUTPUT HEADER
Description
Length Start End
Record Type
1
1
1
Record Length
4
2
5
AutoRoute Product ID
8
6
13
File Description
30
14
43
Distribution Side
4
44
47
Processing Date
Multi-Cycle Indicator
Multi-Cycle Nbr.
Variable-Length Record
Indicator
Future Use
6.8
Type
A/N
A/N
A/N
A/N
A/N
8
1
4
1
48
56
57
61
55
56
60
61
A/N
A/N
A/N
A/N
19
62
80
A/N
Comments
‘H’
‘61’ – Variable Length
02400264
Cost Basis Transaction MRO
Last four digits of the distribution
firm’s CBRS Account ID number
CCYYMMDD
Single Cycle = [space]
Zeroes
Variable Length = ‘*’
Spaces
End of Record
CBRS Application Output Trailer
A CBRS application trailer record is the last record in any CBRS MRO file transmitted. The
following is the layout of this application trailer:
CBRS APPLICATION OUTPUT TRAILER
Description
Length Start End
Record Type
1
1
1
Record Length
4
2
5
AutoRoute Product ID
8
6
13
File Description
30
14
43
Distribution Side
4
44
47
Type
A/N
A/N
A/N
A/N
A/N
Processing Date
Multi-Cycle Indicator
Multi-Cycle Nbr.
Variable-Length Record
Indicator
Item Count
8
1
4
1
48
56
57
61
55
56
60
61
A/N
A/N
A/N
A/N
9
62
70
A/N
Future Use
10
71
80
A/N
Comments
‘T’
‘70’ – Variable Length
02400264
Cost Basis Transaction MRO
Last four digits of the distribution
firm’s CBRS Account ID number
CCYYMMDD
Single Cycle = [space]
Zeroes
Variable Length = ‘*’
Transmission count (includes Header
and Trailer)
Spaces
End of Record
61
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7 CBRS and WebDirect
7.1 WebDirect Workflow
To use CBRS via WebDirect, the secure Internet portal, you must follow a series of steps. At the
most basic level, these steps are:
1. Create transactions.
2. Submit transactions to a batch.
Note: Please be aware that transactions submitted to a batch have not yet
been sent to DTCC.
3. Send your batches of transactions to DTCC.
4. Download files.
In addition to the steps above, your workflow may involve steps such as editing data, searching or
deleting transactions, or uploading a spreadsheet. This guide contains information on these steps, as
well as all CBRS functionality available on WebDirect.
7.2
Logging on to the system
To access the screen to log into CBRS over the internet through WebDirect, go to:
https://portal.dtcc.com
After you have logged in:
To use CBRS in the production environment, click on
under the “Available Production Products” section.
To use CBRS in the testing environment, click on
under the “Available PSE, PSE2, and PTE Products” section.
If you have trouble logging on to the system, contact DTCC Customer Support, 1-888-382-2721.
7.3
Creating Transactions
You can create either an asset or a tax lot record.
An asset record can be one of the four possible record content types: original, corrected, firm reject,
or request. A tax lot record can be either an original record or a corrected record.
62
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
A transaction refers to all assets that have the same transfer control number. Some transfer types,
such as an ACATS transfer, can have multiple assets per transfer control number. Other transfer
types, such as a free deliver order, have one asset per transfer control number. Each asset can
include one or more tax lots.
Assets are required for all transactions. Tax lots are required for transactions with a record content
type of either original or corrected.
Note: When you submit transactions in CBRS (after creating new transactions or modifying
existing transactions), you are creating or modifying pending transactions that must then be
sent to DTCC. For more information, see Sending a Batch to DTCC.
Note: You can also create transactions via spreadsheet upload. For more information, see
The Spreadsheet Upload Process.
63
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
1. On the CBRS home page, under Transaction Inputs, click Cost Basis Input.
64
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Reporting Service page appears. The Transfer Information section of this page is
pictured below.
2. Enter all the information you have regarding the transaction.
Note: Required fields are identified with a red asterisk (*).
3. In the Asset Information section, enter information for the first asset for this transaction.
65
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4. Enter information for the first tax lot for this asset.
Note: The tax lot input screen automatically appears when, in the Asset Record Content
Indicator field, you choose 01 = Original asset record or 02 = Corrected asset record. If
you choose 03 = Firm reject record or 04 = Request record, the tax lot input screen will
not appear. There are no tax lots associated with the Firm reject or Request record types.
5. If you have more than one tax lot for this asset, click the More Tax Lots radio button and click
Submit.
The transaction page reappears, with the transaction and the asset information already
populated.
6. Enter the additional tax lot information.
Repeat steps 5 and 6 for each tax lot associated with this asset.
7. If you have more than one asset for this transaction, finish entering the tax lot information. Then
click the More Assets radio button and click Submit.
The transaction page reappears, with the transaction information already populated.
8. Enter the additional asset information.
9. Enter the tax lot information as described in steps 4 through 6 for the next asset.
10 Repeat steps 7 through 9 as needed until you have entered all the asset and tax lot information
. for this transaction.
Notes:
•
You must finish entering all the asset and tax lot information associated with the transaction
before clicking Submit the final time.
•
You cannot add additional asset or tax lot information for a transaction by editing an existing
Cost Basis record. For details on adding additional asset or tax lot information to a transaction,
see Adding More Assets to a Transaction or Adding More Tax Lots to a Transaction.
11 Click Submit.
.
The "Previous transaction was processed successfully" message appears on the Cost Basis
Reporting Service screen.
66
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
After you submit the transaction, CBRS adds it to the previously submitted transactions (if any
exist). After you are finished entering all transactions, follow the steps to send the batch to
DTCC. For more information, see Sending a Batch to DTCC.
CBRS processes all the files at the same time at the end of the day.
7.4 Working with Pending Transactions
7.4.1 Adding More Assets to a Transaction
If you have already entered a transaction and need to enter another asset, follow the steps shown
below.
Note: When you submit transactions in CBRS (after creating new transactions or modifying
existing transactions), you are creating or modifying pending transactions that must then be
sent to DTCC. For more information, see Sending a Batch to DTCC.
67
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
1. On the CBRS home page, under Transaction Inputs, click Cost Basis Input.
68
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Reporting Service page appears.
2. Enter the same information you already entered about this transaction.
Note: Required fields are identified with a red asterisk (*).
3. Enter information for the additional asset for this transaction.
4. Enter information for the first tax lot for this asset.
Note: The tax lot input screen automatically appears when, in the Asset Record Content Indicator
field, you choose 01 = Original asset record or 02 = Corrected asset record. If you choose 03 =
Firm reject record or 04 = Request record, the tax lot input screen will not appear. There are no
tax lots associated with the Firm reject or Request record types.
69
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5. If you have more than one tax lot for this asset, click the More Tax Lots radio button and click Submit.
The transaction page reappears, with the transaction and the asset information already populated.
6. Enter the additional tax lot information.
Repeat steps 5 and 6 for each tax lot associated with this asset.
7. If you have more than one asset to add to this transaction, finish entering the tax lot information. Then
click the More Assets radio button and click Submit.
The transaction page reappears, with the transaction information already populated.
8. Enter the additional asset information.
9. Enter the tax lot information as described in steps 4 through 6 for the next asset.
10. Repeat steps 7 through 9 as needed until you have entered all the additional asset and tax lot information
for this transaction.
Note: You must finish entering all the asset and tax lot information associated with the
transaction before clicking Submit the final time.
11. Click Submit.
The "Previous transaction was processed successfully" message appears on the Cost Basis Reporting
Service page.
After you submit the transaction, CBRS adds it to the previously submitted transactions. After you are
finished entering all transactions, follow the steps to send the batch to DTCC. For more information, see
Sending a Batch to DTCC.
CBRS processes all the files at the same time at the end of the day.
70
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.4.2 Adding More Tax Lots to a Transaction
If you have already entered a transaction and need to enter another tax lot, follow these steps:
1. On the CBRS home page, under Transaction Inputs, click Cost Basis Input.
The Cost Basis Reporting Service page appears.
71
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
2. Enter the same Transfer Information you already entered about this transaction.
Note: Required fields are identified with a red asterisk (*).
3. Enter the Asset Information that you already entered for this asset.
4. Enter the additional tax lot information for this asset.
Note: The tax lot input screen automatically appears when, in the Asset Record Content Indicator
field, you choose 01 = Original asset record or 02 = Corrected asset record. If you choose 03 =
Firm reject record or 04 = Request record, the tax lot input screen will not appear. There are no
tax lots associated with the Firm reject or Request record types.
72
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5. If you have more than one additional tax lot for this asset, click the More Tax Lots radio button
and click Submit.
The transaction page reappears, with the transaction and the asset information already populated.
6. Enter the additional tax lot information.
Repeat steps 5 and 6 for each tax lot associated with this asset.
Note: You must finish entering all the asset and tax lot information associated with the
transaction before clicking Submit the final time.
7. Click Submit.
The "Previous transaction was processed successfully." message appears on the Cost Basis
Reporting Service page.
After you submit the transaction, CBRS adds it to the previously submitted transactions. After
you are finished entering all transactions, follow the steps to send the batch to DTCC. For more
information, see Sending a Batch to DTCC
.
CBRS processes all the files at the same time at the end of the day.
73
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.4.3 Listing and Searching Pending Transactions
You can display transactions that you have submitted but have not yet sent to DTCC. You can
either list all existing transactions, or you can use search criteria to display specific transactions.
After displaying a set of transactions, you can view, update, or delete transfer information, assets,
and tax lots for those transactions.
To list all pending transactions
1. From the CBRS home page, under Data Review/Send, click Summary.
74
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Summary page appears.
2.
Click List.
The Transfer List page appears, displaying all current pending transactions.
75
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
To search pending transactions
1.
From the CBRS home page, under Data Review/Send, click Summary.
2. The Summary page appears.
3. Click Search.
76
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Search page appears.
4. Using the fields provided, type and select your search criteria.
5.
Click either Search button.
The Transfer List page appears, displaying the transactions that match your selection
criteria.
Notes:
To view, update, and delete transfer information for transactions displayed on the Transfer
List page click the corresponding link in the Item Number column. For more information,
see Viewing and Updating Transfer Information.
To view, update, and delete asset and tax lot information for transactions displayed on the
Transfer List page click the corresponding link in the Number Of Assets column. For more
information, see Viewing and Updating Assets and Viewing and Updating Tax Lots.
77
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.5 Deleting Transactions
You can delete transactions from the Transfer List page or the Transfer Information Update page.
7.5.1 Deleting transactions from the Transfer List
1. Display the transactions you want to work with.
You can use the search function to search for specific pending transactions or the list
function to list all pending transactions. If you choose List, skip to step 3. If you use Search,
continue on to the next step.
For more information, see Listing and Searching Pending Transactions.
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
78
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Transfer List page appears.
3. Click the check box next to one or more transactions. To select all transactions, click the
Select All checkbox.
4. Click Delete.
Note: When you click Delete, the transfer information and all associated assets and tax lots
are deleted.
7.5.2 Deleting transactions from the Transfer Information Update page
1. Display the transactions you want to work with.
You can use the search function to search for specific pending transactions or the list
function to list all pending transactions. If you choose List, skip to step 3. If you use Search,
continue on to the next step.
For more information, see Listing and Searching Pending Transactions.
79
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
The Transfer List page appears.
3. Click the Item Number link for the transaction you want delete.
80
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Transfer Information Update page appears.
4. Click either Delete button.
Note: When you click Delete, the transfer information and all associated assets and tax lots
are deleted.
7.6 Editing Transfer Information, Asset Records, and Tax Lot Records
7.6.1 Viewing and Updating Transfer Information
You can view and update the transfer information for transactions you have submitted but have not
yet sent to DTCC.
Note: When you submit transactions in CBRS (after creating new transactions or modifying
existing transactions), you are creating or modifying pending transactions that must then be
sent to DTCC. For more information, see Sending a Batch to DTCC.
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
81
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
The Transfer List page appears.
3. Click the Item Number link for the transaction you want to work with.
82
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4. The Cost Basis Transfer Information Update page appears.
5. To update the transfer information, modify the appropriate information displayed and click
Submit.
Note: You cannot modify the following fields on the Transfer Information Update page:
•
Submitting Firm
•
Contra Firm Type
•
Asset Record Content Indicator
•
Transaction Type
83
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.6.2 Viewing and Updating Assets
For transactions that you have submitted but have not yet sent to DTCC, you can view and update
the assets assigned to those transactions.
Note: When you submit transactions in CBRS (after creating new transactions or modifying
existing transactions), you are creating or modifying pending transactions that must then be
sent to DTCC. For more information, see Sending a Batch to DTCC.
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
84
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Transfer List page appears.
3. Click the link in the Number Of Assets column for the transaction you want to work with.
The Assets List page appears.
4. On the Assets List page, click the Asset Number for the asset that you want to modify.
85
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Asset page appears.
5. Modify the asset details as needed, and click Submit.
7.6.3 Deleting Assets
You can delete assets via the Assets List page or via the Update Asset page.
Notes:
•
•
•
When you delete an asset, any tax lots associated with that asset are also deleted.
You cannot delete the last asset for a transaction.
When you submit transactions in CBRS (after creating new transactions or
modifying existing transactions), you are creating or modifying pending transactions
that you must then send to DTCC. For more information, see Sending a Batch to
DTCC.
86
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
To delete assets via the Assets List page
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
87
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Transfer List page appears.
3. Click the link in the Number Of Assets column for the transaction you want to work with.
The Assets List page appears.
4. Click the check box next to one or more assets. To select all assets, click the Select All
checkbox.
5. Click Delete.
88
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
To delete assets from the Update Asset page
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
89
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Transfer List page appears.
3. Click the link in the Number Of Assets column for the transaction you want to work with.
The Assets List page appears.
4. Click the link in the Asset Number column for the transaction you want to work with.
90
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Asset page appears.
5. Click Delete.
Note: When you click Delete, the transfer information and all associated assets and tax lots
are deleted.
91
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.6.4 Viewing and Updating Tax Lots
For transactions that you have submitted but have not yet sent to DTCC, you can view and update
the tax lots assigned to assets for those transactions.
Note: When you submit transactions in CBRS (after creating new transactions or modifying
existing transactions), you are creating or modifying pending transactions that must then be sent
to DTCC. For more information, see Sending a Batch to DTCC.
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
92
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Transfer List page appears.
3. Click the link in the Number Of Assets column for the transaction you want to work with.
The Assets List page appears.
4. On the Assets List page, click the link in the Number of Tax Lots column for the asset that
you want to modify.
93
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Tax Lot List page appears.
5. Click the link in the Tax Lot Number column for the tax lot that you want to work with.
The Cost Basis Tax Lot page appears.
6. Modify the tax lot details as needed, and click Submit.
94
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.6.5 Deleting Tax Lots
For transactions that you have created but have not yet sent to DTCC, you can delete the tax lots
assigned to assets for those transactions.
You can delete tax lots via the Tax Lot List page or via the Cost Basis Tax Lot page.
You cannot delete the last tax lot for a transaction.
Note: When you submit transactions in CBRS (after creating new transactions or modifying
existing transactions), you are creating or modifying pending transactions that must then be
sent to DTCC. For more information, see Sending a Batch to DTCC.
To delete tax lots via the Tax Lot List page
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
95
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
The Transfer List page appears.
3. Click the link in the Number Of Assets column for the transaction you want to work with.
96
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Assets List page appears.
4. On the Assets List page, click the link in the Number of Tax Lots column for the asset that
you want to modify.
The Tax Lot List page appears.
5. Click the checkbox next to one or more tax lots. To select all tax lots, click the Select All
checkbox.
6. Click Delete.
97
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
To delete tax lots via the Cost Basis Tax Lot page
1. Display the transaction you want to work with.
You can use the list function to list all pending transactions, or you can use the search
function to search for specific pending transactions. For more information, see Listing and
Searching Pending Transactions.
If you choose List, skip to step 3. If you use Search, continue on to the next step.
The Cost Basis Search page appears.
2. Using the fields provided, type and select your search criteria and then click either Search
button.
98
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Transfer List page appears.
3. Click the link in the Number Of Assets column for the transaction you want to work with.
The Assets List page appears.
4. On the Assets List page, click the link in the Number of Tax Lots column for the asset that
you want to modify.
99
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Tax Lot List page appears.
5. Click the link in the Tax Lot Number column for the tax lot that you want to work with.
The Cost Basis Tax Lot page appears.
6.
Click Delete.
100
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.7 Working With Batches
7.7.1 Sending a Batch to DTCC
When you submit transactions in CBRS (after creating new transactions or modifying existing
transactions), you are creating pending transactions that must then be sent to DTCC. You can send
your pending transactions to DTCC as a single batch.
1. On the CBRS home page, under Data Review/Send, click Send.
101
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Send page appears.
2. Click the check box in the Select column next to the product that you want to send.
Note: To display a list of transactions in a batch, click the Cost Basis link in the Product
column.
3. Click Submit.
4. Wait for the message informing you that the batch was sent to Datatrak.
If you do not receive this message, resend the batch.
For more information, see Resending a Batch.
102
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.7.2 Viewing a Sent Batch
You can view the transfer information, asset, and tax lot details for transactions you have sent to
DTCC.
1. On the CBRS home page, under Data Review/Send, click Sent Batches.
103
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Sent Batches page appears.
2. Click the link in the Batch Number column for the batch you want to view.
The Sent Batch page appears with a list of products that were sent in that batch.
3. Click a product to view (in this case, Cost Basis).
The Cost Basis List page appears, displaying the basic information about the transactions.
4. Click the link in the Item Number column for the Cost Basis Transfer Information page that you
want to view.
or
Click the link in the Number Of Assets column for the Cost Basis Search List Assets page that
you want to view.
104
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.8 Verifying That Your File Was Sent Successfully (Using the Confirms Utility)
After sending data to DTCC, you can use the Confirms utility to verify that the file was sent
successfully.
1. After sending your data, make a note of the batch number displayed on the page.
For more information on sending batches, see:
Sending a Batch to DTCC
Uploading the Spreadsheet
2. Return to the portal page (that is, the page that displays the production products that are
available to you).
3. Under Available Production Products, click Utilities.
105
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The File and Report Utilities page appears.
4. Click Confirms.
You should see a link displaying the batch you have submitted. This tells you your batch
was submitted.
5. To see if your batch was accepted, click the link.
The Confirm Display page appears, providing details about your data submission.
CBRS displays either ACCEPTED or REJECTED in the lower-left corner.
106
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.9
Resending a Batch
1. On the CBRS home page, under Data Review/Send, click Sent Batches.
107
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Sent Batches page appears.
2. Find the correct batch number to resend.
3. Click the appropriate check box in the Re-Send column.
4. Click Re-send.
The Sent Batches page appears with a "Batch Number: xxxxxxxxx was resent" message.
7.10 Uploading Records to CBRS
As an alternative to using the Transaction Input pages of the CBRS web interface (see Creating
Transactions), you can submit your cost basis records to CBRS by: 1) entering your asset and tax lot
records into an MS Excel spreadsheet, and then 2) uploading that spreadsheet to CBRS via the web
interface.
Notes:
•
Your spreadsheet cannot exceed 1000 rows.
• CBRS supports MS Excel 2007 or later (.xlsx). Spreadsheets created with earlier versions
may not work.
7.10.1 Overview of the Upload process
Start by downloading the most recent version of the spreadsheet template.
108
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
For more information, see Start With the Most Recent Spreadsheet Template.
1. Enter your new assets and tax lots.
For more details, see Preparing the Upload Spreadsheet and Example Spreadsheets.
109
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
2. Save the spreadsheet as an Excel Workbook file.
3. On the CBRS Upload page, submit the upload spreadsheet you have created.
For more information, see Uploading the Spreadsheet.
110
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4. If the system rejects your spreadsheet, investigate and correct the errors, and submit the
spreadsheet again.
For more information, see Reviewing and Correcting Upload Errors.
5. If the system accepts your spreadsheet, the Batch Confirm page appears. For the purpose of
future inquiries, make a note of the batch number assigned to your upload.
For more information, see Verifying That Your File Was Sent Successfully (Using the
Confirms Utility).
.
111
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.2 Start With the Most Recent Spreadsheet Template
To prepare spreadsheets for upload, make sure you have the latest version of the spreadsheet
template.
1. From the Cost Basis Reporting Service home page, under CBRS Upload, click CBRS
Upload Tool.
The CBRS Upload page appears.
2. In the Spreadsheet Template section, click the Click to download Spreadsheet Template
link.
Your computer's response depends on which browser software you are using and how that
browser is configured. In the most typical setup, you are prompted to either open or save the
file.
112
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
3. To open the file, click Open.
4. To save the file, click Save.
After you have downloaded and saved the spreadsheet template (see Start With the Most Recent
Spreadsheet Template), you are ready to create new spreadsheets containing new asset and tax lot
records.
7.10.3 For earlier versions of MS Excel
Note: CBRS supports MS Excel 2007 or later (.xlsx). Spreadsheets created with earlier versions
may not work.
If you are using a pre-2007 version of MS Excel to create your spreadsheet, you may see a message
regarding MS Excel versions when you open the template.
If you see this message, click OK to continue opening the template.
When you save your spreadsheet, save it in compatibility mode (Click Save As, then choose the
compatibility mode option).
113
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.4 Spreadsheet Template column headers
After you open the spreadsheet template, you will notice that it is color-coded.
The table below shows what each color signifies.
Headings for asset record fields have a blue
background.
Headings for required asset record fields
have a blue background with red text.
Headings for tax lot record fields have a
beige background.
To display hints for a column, move your mouse over any column heading with a red triangle in the
upper-right corner.
114
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.5 The Spreadsheet at a Glance
Here are the key points you need to understand when setting up your spreadsheet:
• Enter asset details on the left side of the spreadsheet, under the blue column headings. Enter
tax lot details on the right side of the spreadsheet, under the beige column headings.
•
Enter an asset and the first tax lot for an asset on the same row.
115
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
Use the rows below an asset to add any additional tax lots for that asset.
116
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
Add additional assets and tax lots as needed.
7.10.6 Tips
• Do not insert rows above row 3 (the column headings).
• Do not modify the order of the columns.
• Do not modify the format of the columns.
• Your spreadsheet can have a maximum of 1000 rows.
• Use the drop-down menus where available.
• For date fields, the required format is MM/DD/YYYY. For example, enter January 3, 2011,
as "01/03/2011" (without the quotes).
• For participant ID fields, leading zeros are not required. For example, you can enter
000000123 as simply 123.
• Not all fields are required.
• Some fields are conditional; that is, data from one field may influence whether another field
is required. Please consult the CBRS Record Layouts and the CBRS User Guide on the
DTCC Learning website for more information about required and conditional fields.
117
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.7 Adding an Asset With One Tax Lot
In this case, you'll enter both the asset and tax lot details on the first row. The asset information
appears under the blue headings on the left half of the spreadsheet; the tax lot information appears
under the beige headings on the right half of the spreadsheet.
1. In the CBRS Record Type column of the first row, use the drop-down menu to select A (for
Asset).
2. Type all of the applicable asset information in the asset columns, identified by the column
headings with a blue background.
3. In the same row, scroll to the right and under the beige column headings, type the tax lot
details.
118
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.8 Adding an Asset With Multiple Tax Lots
When you are entering an asset with more than one tax lot, you will enter the additional tax lot
information below the first tax lot.
1. Type the first asset and tax lot in the first row.
See Adding an Asset With One Tax Lot above for more details.
2. For each additional tax lot, do the following:
a. In the CBRS Record Type column, use the drop-down menu to select T (for additional tax
lots).
Note: Please note that the asset fields in this row now appear in blue. Because the asset
fields for the additional tax lots are the same as the original asset, you should not retype this
information.
b. Scroll to the right side of the spreadsheet, and under the beige columns, type the
information for the next tax lot.
119
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
c. Repeat steps a and b for each additional tax lot.
7.10.9 Adding Multiple Asset Records
You may have a number of assets to upload, some with just one tax lot, some with multiple tax lots.
1. Type the first asset and tax lot in the first row.
See Adding an Asset With One Tax Lot above for more details.
2. For each additional asset, do the following:
a. In the CBRS Record Type column, use the drop-down menu to select A (for Asset).
b. Type all of the asset information in the asset columns, identified by the column headings
with a blue background.
c. In the same row, scroll to the right side of the spreadsheet, and under the beige column
headings, type the information for the first tax lot.
3.
For each additional tax lot within a specific asset, do the following:
a. In the CBRS Record Type column, use the drop-down menu to select T (for additional
Tax lots).
Note: Please note that the asset fields in this row now appear in blue. Because the asset
fields for the additional tax lots are the same as the original asset, you should not retype this
information.
b. Scroll to the right side of the spreadsheet, and under the beige columns, type the
information for the next tax lot.
c. Repeat these steps for each additional tax lot.
120
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
121
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.10
Adding an Asset Without a Tax Lot (Firm Reject and Request Records
Only)
If you are submitting firm reject or request records, you can add an asset record on the spreadsheet
without a tax lot. For more details, see the CBRS User Guide and Record Layouts.
1.
Enter the first asset record and tax lot in the first available row:
a. In the CBRS Record Type column, use the drop-down menu to select A (for Asset).
b. Type all of the asset information in the asset columns, identified by the column headings
with a blue background.
122
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.11
Example Spreadsheets
The examples below demonstrate completed spreadsheets for various scenarios.
7.10.11.1
Example One: An Asset With One Tax Lot
The asset information and tax lot information all appear on the same row. The blue headings
indicate asset fields; the beige headings indicate tax lot fields.
This is the left side of the spreadsheet, with one asset entered:
This is the right side of the same spreadsheet, with the one tax lot entered:
123
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.11.2
Example Two: An Asset With Multiple Tax Lots
The asset and the first tax lot appear on one row, followed by the additional tax lots on subsequent
rows.
For the additional tax lots, the asset fields are filled with blue, indicating this information is the
same as the first asset record and should not be retyped.
This is the left side of the spreadsheet, with one asset entered and multiple tax lots added:
Below is the right side of the same spreadsheet, showing the tax lot details added under the beige
column headings. Note that the first tax lot appears on the same row as the asset; each additional tax
lot appears on the rows below.
124
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.11.3
Example Three: Multiple Asset Records
Each new asset includes one tax lot record on the same row. Additional tax lot records appear on
subsequent rows.
Here is the asset side of a spreadsheet with multiple assets:
125
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Here is the tax lot side of a spreadsheet with multiple assets:
126
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.12
Uploading the Spreadsheet
After you have prepared your spreadsheet (see Preparing the Upload Spreadsheet), you can upload
it via the CBRS web interface. CBRS processes the records you upload at the end of the day.
1. From the Cost Basis Reporting Service home page, under CBRS Upload, click CBRS
Upload Tool.
The CBRS Upload page appears.
2. Click Browse.
3. Locate the spreadsheet on your computer and select it.
127
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4.
Click Submit.
CBRS validates your spreadsheet for the following:
1) File type (must be .xls or .xlsx)
2) Number of rows (must be less than 1000)
3) CBRS Record Type (must be A, for asset, or T, for tax lot)
4) Submitting Firm Number and Submitting Firm Type (must match your firm)
If all of the records on your spreadsheet do not pass the validation described above, CBRS
rejects your spreadsheet and displays a rejection error message.
128
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
If the system accepts your spreadsheet, the Batch Confirm page appears. For the purpose of
future inquiries, make a note of the batch number assigned to your upload.
When your records reach CBRS, it performs additional validations and produces output to
you at the end of the day.
Note: After CBRS produces this output, you can use the Cost Basis Inquiry feature that
evening or the next business day to view your records. You can also use this feature to
research any errors that may have resulted from the validations performed at the end of the
day. After you successfully submit your spreadsheet, you cannot view your records until the
end-of-day processing has been completed.
For more information, see Reviewing and Correcting Upload Errors.
129
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.13
Displaying Records Uploaded via Spreadsheet
After end-of-day processing, CBRS produces its transaction output to various files, such as the
Transaction End of Day (EOD) Download file. You can use this file to see the records you
submitted, as well as the records you received.
You can also use the Cost Basis Inquiry search function to verify that the records you submit via
spreadsheet upload have made it to the CBRS database. For example, you can create a search using
"System Rejected" or "System Accepted" as selection criteria, as shown in the image below. For
detailed instructions on how to search your records on the CBRS database, see Searching CBRS
Transactions.
Note: When you submit CBRS transactions via spreadsheet upload, those records go
directly to the CBRS mainframe database. You cannot view or modify these records in
pending status as you can with transactions that you enter via manual data entry on the Cost
Basis Input page.
7.10.14
Modifying Uploaded Information
To modify details for any records that you have already uploaded, simply resubmit those records on
a new spreadsheet. You cannot use the Transaction Input pages of CBRS web interface to edit the
records you have uploaded via spreadsheet. For more details, see Preparing the Upload Spreadsheet.
Note: Because these records have already been submitted to the CBRS mainframe database, you
should resubmit your records using the code for corrected records ("02") in the Record Content
Indicator column.
130
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.15
Verifying That Your File Was Sent Successfully (Using the Confirms
Utility)
After sending data to DTCC, you can use the Confirms utility to verify that the file was sent
successfully.
1. After sending your data, make a note of the batch number displayed on the page.
For more information on sending batches, see:
Sending a Batch to DTCC
Uploading the Spreadsheet
2. Return to the portal page (that is, the page that displays the production products that are
available to you).
3. Under Available Production Products, click Utilities.
The File and Report Utilities page appears.
131
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
4. Click Confirms.
You should see a link displaying the batch you have submitted. This tells you your batch
was submitted.
5.
To see if your batch was accepted, click the link.
The Confirm Display page appears, providing details about your data submission.
CBRS displays either ACCEPTED or REJECTED in the lower-left corner.
132
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.10.16
Reviewing and Correcting Spreadsheet Errors
7.10.16.1
Errors You Will See Immediately Upon Submission
When you upload transactions via spreadsheet, CBRS immediately checks for the following:
1) File type (must be .xls or .xlsx)
2) Number of rows (must be less than 1000)
3) CBRS Record Type (must be A, for asset, or T, for tax lot)
4) Submitting Firm Number and Submitting Firm Type (must match your firm)
When the errors shown above are found, CBRS displays an error message on the web interface.
To correct the errors, modify the information as needed on your spreadsheet and repeat the upload
process.
Note: Because these records have not yet been submitted to the CBRS mainframe database,
you should resubmit your records using the code for original records ("01") in the Record
Content Indicator column.
7.10.16.2
Errors You Will See After End-of-Day Processing
For transactions on spreadsheets that pass the initial validation, CBRS performs additional
validations at the end of the day. During end-of-day processing, CBRS checks for badly formatted
data, incorrect or missing data, etc.
To see any errors generated by end-of-day processing, you can look at the Transaction End of Day
(EOD) download file. You can use this file to see the records you submitted as well as the records
you received.
133
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
You can also use the Cost Basis Inquiry search to display errors generated by end-of-day
processing. For example, to display all of your transactions that were system rejected, you can
create a search that specifies a System Status of "System Rejected" (see the image below).
When you display the CBRS Asset Detail or the CBRS Tax Lot Detail pages, CBRS provides
details about the error condition that you need to correct.
Here is an example of the CBRS Asset Detail page for an asset record with errors:
134
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Here is an example of the CBRS Tax Lot Detail page for a tax lot record with errors:
For more information on how to use the Cost Basis Inquiry, see Searching CBRS Transactions.
For more information on System Reject Reason and Status codes, please see the CBRS User Guide
and the CBRS Record Layouts on the DTCC Learning website.
To correct the errors, upload a spreadsheet containing the corrected records. You can upload only
the transactions you want to correct, or you can upload all of your transactions.
Note: Because these records have already been submitted to CBRS, you should resubmit your
records using the code for corrected records ("02") in the Record Content Indicator column.
7.11 Searching CBRS Transactions
You can search the Cost Basis Reporting System database in two ways:
• Quick Search: Specify a CBRS control number
• Advanced Search: Enter a combination of search criteria
You can display only those transactions for which your firm is either the submitter or receiver.
The transactions that match your search criteria appear on the bottom half of the page. When a
transaction has more than one asset, CBRS displays each asset on a separate row.
After displaying your search results, you can display details for specific assets and for the tax lots
associated with those assets.
Cost Basis Inquiry screens, including the download function, may not be available when the
application is processing records. This processing occurs four times per day, at approximately 9:15
AM, 11:15 AM, 1:15 PM, and 4:15 PM eastern time. At these times you may not be able to use the
inquiry or inquiry download functions. The screens automatically become available again when
135
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
processing is complete. If you encounter an error at approximately these times, please wait and try
your inquiry again at a later time.
7.11.1 Quick search
1. On the CBRS home page, under Transaction Inquiry, click Cost Basis Transaction
Inquiry.
136
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Transaction Inquiry page appears.
2. In the Quick Search section, type the CBRS Control Number.
3. Click Search.
The Cost Basis Transaction Inquiry page updates to display your search results, one row for
each asset found for the transaction(s) that match your search criteria.
4. To download data associated with the transaction displayed, click the selection box(es) for
specific assets and then click Download Selected Items.
Your data will become available for download via the Data Files page. For more
information, see Viewing Cost Basis Files.
137
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
5. To view the data associated with a displayed transaction, click the CBRS Control Number
link next to that transaction.
The CBRS Asset page appears.
6.
From the CBRS asset page, you can view either the detailed asset record or the associated
tax lot(s).
To view the detailed asset record, click Asset Details.
To view the associated tax lot(s), click a link in the Tax Lot Sequence Number column.
When you click Asset Details, the CBRS Asset Detail page appears. To export this data to
Excel, click Export to Excel.
When you click a link in the Tax Lot Sequence Number column, the CBRS Tax Lot Detail
page appears. To export this data to Excel, click Export to Excel.
138
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
139
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.11.2 Advanced search
1. On the CBRS home page, under Transaction Inquiry, click Cost Basis Transaction
Inquiry.
140
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Cost Basis Transaction Inquiry page appears.
2. Using the fields provided in the Advanced Search section, enter your search selection
criteria.
3. Click Search.
141
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
CBRS displays your search results in the lower portion of the page. CBRS displays one row
for each asset found for the transactions that match your search criteria.
4. To download data associated with the transaction displayed, click the selection box(es) for
specific assets and then click Download Selected Items.
Your data will become available for download via the Data Files page.
It takes approximately 15 to 60 minutes to create the file, depending on the amount of data
in the request.
For more information, see Downloading Cost Basis Files.
7.11.3 Displaying asset and tax lot details
1. Complete either a quick search or an advanced search.
See above for details. Note that CBRS displays one row for each asset found for the
transactions that match your search criteria.
142
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
2. On the Cost Basis Transaction Inquiry page, in the search results section, in the row for the
asset that you are interested in, click the CBRS Control Number.
The CBRS Asset page appears. The CBRS Asset page displays information for the asset you
chose, along with a list of tax lots submitted for that asset.
3. To download data associated with the tax lots displayed, click the selection box(es) for
specific tax lots and then click Download Selected Items.
Your data will become available for download via the Data Files page.
It takes approximately 15 to 60 minutes to create the file, depending on the amount of data
in the request.
For more information, see Downloading Cost Basis Files.
4. From the CBRS Asset page, you can display additional asset details or tax lot details:
•
•
To display additional asset details, click Asset Details. The CBRS Asset Detail page
appears, displaying additional asset details, including the edit status for each field.
Note: To open an Excel spreadsheet displaying the information on the Asset Details
page, click Export to Excel.
To display tax lot details, in the Tax Lot List section, click the link in the Tax Lot
Sequence Number column for the tax lot that you are interested in. The CBRS Tax
Lot Detail page appears, displaying additional tax lot details, including the edit status
for each field.
Note: To open an Excel spreadsheet displaying the information on the CBRS Tax
Lot Detail page, click Export to Excel.
143
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.12 Searching for a CBRS User
7.12.1 Searching for an Active CBRS Account
1. On the CBRS home page, under Data Inquiry, click Cost Basis User Inquiry.
The Cost Basis User Inquiry page appears.
2. You must type the Firm Number and select the Firm Type.
144
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
3.
Click Search.
The Cost Basis User Inquiry page updates to display your search results. The results
display the Active Firm that matches your search criteria.
145
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.12.2 Searching for an Inactive CBRS Account
1.
On the CBRS home page, under Data Inquiry, click Cost Basis User Inquiry. When the
Firm Number is not known, then populate the Firm Number with the Inactive account
number known and select the appropriate Firm Type.
2. If the inactive account is a FED number and short name combination being used to find the
active CBRS Account number, then populated the Account number with the Fed number
and select one of the associated Fed Short Names from the pull down menu.
146
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
3. The results returned will display the CBRS Account number
147
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.13 Downloading Cost Basis Files
You can view and download reports. You can also download data sets that you have requested via
the Cost Basis Inquiry page. For more information, see Searching CBRS Transactions.
If your firm subscribes to AutoRoute products for direct delivery of machine readable output
(MRO) files, then you cannot take the Web MRO.
1. On the CBRS home page, under CBRS Output, click Cost Basis Output Files.
148
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Data Files page appears.
2. In the drop-down menu provided, select the firm number and firm type.
3. Click Submit.
CBRS displays the following reports, depending on which files you have subscribed to
receive:
•
Transaction Request WebDirect Download: Firms can use the transaction inquiry
function to search and view specific transactions using various criteria, such as ISIN,
transfer control number, or Transaction Type. They can then download these requested
transactions to Excel. This file contains these specifically requested transactions in Excel
format.
•
Transaction End of Day (EOD) Download: This file contains all transactions for the
current processing day in Excel format. It contains the same information provided in the
Transaction Machine Readable Output (MRO) report for that day.
149
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
•
Cost Basis User Master File WebDirect Download: This file provides a listing of the
firms that are active users of CBRS in tilde-delimited format for converting to Excel.
•
Daily Deposit File for Equity Transfer Agents: For equity transfer agents only. This file
contains the deposits for that Transfer Agent for that day, so they know for which deposits
they can expect to send cost basis. The file is available through WebDirect or on the
mainframe for retrieval via the Data Transmission Facility (DTF) function DPCBRS.
•
Daily Reorg Deposit File for Equity Transfer Agents: For equity transfer agents only.
This file contains the reorg deposits for that transfer agent for that day, so they know for
which reorg deposits they can expect to send cost basis. The file is available through
WebDirect or on the mainframe for retrieval via the Data Transmission Facility (DTF)
function DRCBRS.
Note: The Transaction Request Download file contains the data you downloaded using the
quick search or advanced search functions (see Searching CBRS Transactions). After you
request the download, it takes approximately 15 to 60 minutes to create the file, depending
on the amount of data in the request.
9. Click the File Name of the file or report that you want to download.
150
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Internet Explorer prompts you to either open or save the file.
4.
Click Save.
151
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The Internet Explorer Save As dialog window appears.
5.
Use the navigation tools to select a location on your system for the file.
6.
In the Save As window, perform these steps:
a. Using the navigation tools provided, choose a location on your system to store the file. For
example, you can choose to save the file on your desktop.
b. In the File name field, you can leave the existing file name or enter a new one.
c, In the Save as type field, leave the type set to ".mro."
d. Click Save.
152
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.
To open the file in MS Excel, follow these steps:
a. Launch MS Excel.
b. Under the Office button, click Open, and then navigate to the location on your system where you
have saved the file.
Note: In the Open window, in the Files of type: field, select "All Files(*.*)."
c. After locating your file, select it and then click Open.
153
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The MS Excel Text Import Wizard - Step 1 of 3 window appears.
8.
To finish importing the file, follow these steps:
a. In the Original data type section, choose Delimited and click Next.
154
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The MS Excel Text Import Wizard - Step 2 of 3 window appears.
b. In the Delimiters section, de-select Tab, then select Other, and type a ~ (tilde) in the space
provided.
c. Click Finish.
The downloaded file opens in MS Excel.
9.
If you wish, save and name the file on your system.
7.14 Size Limit for Transaction Download Files
CBRS will produce the Transaction Request and Transaction EOD (end of day) Download files
only when the number of records (combined asset and tax lot records both received and submitted)
per file is less than 3,000.
If a file exceeds this size, CBRS will not create it.
Note: Firms that expect to exceed this maximum need to be able to take in the Transaction Machine
Readable Output (MRO) file (Autoroute #02400264 in Production and #02980264 in Test).
155
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
7.15 Time Frames for Files and Data Availability
Files are stored in WebDirect for four days.
Data is available for viewing on WebDirect screens, using the Cost Basis Inquiry screen, and
downloading to an Excel spreadsheet, for twenty-five business days.
After the twenty-five business day window has passed, DTCC will not be able to provide
CBRS data to users. Users are responsible for storing their data on a long-term basis.
7.16 WebDirect data entry on weekends and holidays
Data entered on a weekend or holiday is processed by CBRS on the next valid processing date.
For example, a user submits CBRS records via WebDirect on Memorial Day, Monday, May 28.
CBRS holds these submitted records, and processes them on Tuesday, May 29. The records
submitted on Monday are a part of the output produced on Tuesday.
156
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
8 Joining the Service
All financial intermediaries are eligible to apply to use CBRS, including firms who are not currently
members of any DTCC subsidiary. Instructions on how to open a CBRS Account, and the
necessary forms, are available on DTCC’s website at:
http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx
http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx
The forms required to become an eligible user of CBRS depends on a firm’s existing relationship
with DTCC. The instructions specify the forms that are required in each situation (DTC Participant,
DTC Limited Participant utilizing the Direct Registration Service, NSCC Participant, or no
relationship to any DTCC subsidiary).
? What date should I put as the effective date in the Service Add letter? The effective date in
the Service Add letter is the date your firm will be ready to use CBRS in the production
environment. This is not the date when your firm will start testing. After you complete the
new account process, you will hear back from DTCC that you are eligible to use CBRS. As
soon as you are eligible and have set up your access to the system, you can start testing. You
can test any time up to when you start in Production, and also past that date as well. There is
no end date for testing. As of the effective date, the user will be on the CBRS Master File in
Production. Counterparties expect that if you are on that Master File, at a minimum you are
able to accept the records sent to you.
? I am a Transfer Agent and would like to make my LPA number eligible for CBRS. How do I
do that? You need to follow the CBRS New Account process to make the LPA number
eligible for CBRS, even if you have one or more Transfer Agent numbers that are already
eligible for CBRS. Please see the CBRS User Documentation webpage for the New Account
Instructions and forms:
http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx
8.1
Multiple Output File Set-up
If your company has both a broker-dealer side and a mutual fund company side, with different
participant numbers, you can receive separate output files for the different numbers. The standard
set-up is to receive one file, but if you prefer to receive two files please contact your relationship
manager and DTCC will adjust the set-up accordingly.
8.2
CBRS Billing
Fees for CBRS records are charged per Asset record. There is no charge for Tax Lot records.
157
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
Because CBRS is a service offering of DTCC Solutions LLC, the CBRS invoice is issued separately
from an NSCC or DTC invoice. System users receive one invoice per CBRS account. If a firm has
multiple CBRS accounts, it receive multiple CBRS invoices; for example, if a firm has three CBRS
accounts, it receives three CBRS invoices.
DTCC distributed CBRS invoices on the 7th business day of the month.
Invoices are available via email and through DTCC’s online billing system. Please contact your
Relationship Manager for questions about your CBRS bill.
? How do I pay for CBRS? A company that has a settlement account uses its settlement
account to pay the balance on its CBRS invoice. A company that does not have a settlement
account pays by wire: wire instructions are on the invoice.
158
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
9 User Testing
Users must complete the CBRS new account forms to become eligible for the service in both
testing and production.
To be an eligible CBRS user, a firm needs to complete all the required CBRS new account forms
and return them to DTCC. The CBRS new account instructions and forms are located at the
following link:
http://www.dtcc.com/clearing-services/equities-clearing-services/cbrs/client-center/publicdocuments.aspx
DTC Participants can expect to receive their new CBRS account in approximately three to five
business days after DTCC has received the forms. All other firms are subject to additional
compliance screening which extends the amount of time to establish a new account. In these cases,
DTCC’s Account Administration group will contact each firm as it moves through the approval
process.
Once a user establishes its CBRS account and connectivity to the system (either via computer to
computer connection, WebDirect, or both), there are multiple resources available to test data input
and output to CBRS.
? How do I know which CBRS users are eligible to test? The version of the CBRS master file
(whose technical name is the “Cost Basis User Master File”) that is available in the test
environment lists all CBRS users who are eligible to test. The master file has a column named
“CBRS Account Start Date.” This date corresponds to the date the CBRS user is eligible to
use the service in the production environment. All CBRS users who are on the master file in
the testing environment are eligible to test.
9.1
Testing data input
A user can test data input by using three different counterparties: itself; test accounts, or a testing
partner.
To test with itself, a firm uses its Firm Account Number from the Cost Basis User Master File (or
CBRS User Account Number if it does not have a Firm Account Number) as both the Submitting
Firm Number and Type and Receiving Firm Number and Type in the CBRS input record layouts
(both Asset and Tax Lot records). Some Transaction Types have requirements for Submitting Firm
Type and Contra Firm Type, so if you test with yourself, you will only be able to test the
Transaction Types that permit your Firm Type.
To test with a test account, a firm uses its Firm Account Number from the Cost Basis User Master
File (or CBRS User Account Number if it does not have a Firm Account Number) as the Submitting
Firm Number and a test account number as the Receiving Firm Number in the CBRS input record
layouts (both Asset and Tax Lot records).
159
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
The CBRS test accounts are:
•
•
•
•
•
DTC Participant: 00008608 DTCPRT
DTC Participant: 00008610 DTCPRT
NSCC Participant: 00000122 NSCPRT
NSCC Participant: 00000123 NSCPRT
Transfer Agent: 00036165 AGTNBR
o The test Transfer Agent account has two CUSIPs associated with it: 99999X037 and
99999Z024
To test with a testing partner, a user can locate a partner on the list of eligible CBRS users on the
Cost Basis User Master File. Once a user has found a testing partner, it uses its Firm Account
Number from the Cost Basis User Master File (or CBRS User Account Number if it does not have a
Firm Account Number) as the Submitting Firm Number, and uses the testing partner’s Firm
Account Number (or CBRS User Account Number if it does not have a Firm Account Number) as
the Contra Firm Number in the CBRS input record layouts (both Asset and Tax Lot records).
Firms can test the following DTC transactions in the testing environment (the “U region”):
• Deposits
• Branch Deposits
• DWAC (to test a DWAC, a broker-dealer should coordinate the test with a transfer agent,
so the agent can approve the test transactions)
It is not possible to test DRS or Withdrawal by Transfer (NWT1 or RWT1) transactions in the U
region.
9.2
Testing data output
CBRS transaction output and the Daily Deposit File for Transfer Agents are available by 9 PM ET.
The Cost Basis User Master File is available by 11 PM ET. On the CBRS transaction output, a firm
receives the records it submitted, and the records it received from a testing partner, if applicable. 1
9.2.1 Details about testing the Daily Deposit File for Transfer Agents
When a Transfer Agent joins CBRS, it can request to receive the Daily Deposit File for Transfer
Agents through DTF, by having signed on to the DPCBRS function using their M or N sign-on.
Transfer agents will also be able to download this file through WebDirect.
DTCC will create two different versions of the Daily Deposit File in the testing environment. On
Mondays, the contents of the file will be the data submitted to Production on the previous Friday.
On Tuesday through Friday, the contents of the file will be the deposit transactions submitted
1
There is one situation when a firm does not receive a submitted record on the transaction output file. CBRS drops a
transaction on the rare occasion when a submitter enters their firm number incorrectly, and CBRS does not recognize
the submitter. In this case, CBRS rejects the record because the submitter is invalid. However, CBRS cannot return the
record to the submitter because the incorrect submitter number does not match the submitter’s actual number, so CBRS
does not know where to return the record.
160
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
through the testing environment over the course of the previous week, if any. Please note that in
order for a deposit to appear on the file on Tuesday through Friday, a DTC participant must enter a
deposit through the testing environment. A transfer agent should arrange to have a DTC participant
testing partner enter deposits into the testing environment for a CUSIP or CUSIPs specific to that
agent.
The following table illustrates the timing of the contents of the Daily Deposit file for testing:
For Production Data:
Week 1
Week 2
Monday
Tuesday
Wednesday
Thursday
Friday
DTC Participants
enter deposits into
Production
Deposits from the
previous Friday
(not the other four
days in Week 1) are
in the file
DTC Participants
enter deposits into
Production
No production
data in file
DTC Participants
enter deposits into
Production
No production
data in file
DTC Participants
enter deposits into
Production
No production data
in file
DTC Participants
enter deposits
into Production
No production
data in file
Monday
Tuesday
Wednesday
Thursday
Friday
DTC Participants
enter transactions
into Test
No test data in file
DTC Participants
enter transactions
into Test
File contains test
data from all five
days in Week 1
DTC Participants
enter transactions
into Test
File contains test
data from all five
days in Week 1
DTC Participants
enter transactions
into Test
File contains test
data from all five
days in Week 1
DTC Participants
enter transactions
into Test
File contains test
data from all five
days in Week 1
For Test Data:
Week 1
Week 2
9.2.2 Canned transaction output file
Four versions of a canned transaction output file are available in the testing environment. A canned
file contains static data that firms can use for testing. The canned output file serves as a sample of
what CBRS transaction output looks like. The four versions correspond to the kind of firm
receiving the file: there is one file for a broker-dealer, one for a transfer agent, one for a bank, and
one for a mutual fund company. The contents of the different versions, such as the Transaction
Types, vary based on the kind of receiver. When requesting the canned file, please indicate the
number that corresponds to your user type:
•
•
•
•
02991797 for a bank
02991798 for a broker-dealer
02991119 for a mutual fund
02991796 for a transfer agent
.
161
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
10 Appendix A: List and description of file identification
numbers
10.1 CBRS input SYS ID numbers
The input SYS ID numbers for CBRS are # 36708 for Production, and # 46708 for the Participant
Services Environment (PSE) for testing.
10.2 List of CBRS output file identification numbers
The table below contains a list of the various CBRS and CBRS-related files, and their file
identification numbers, a/k/a product numbers.
File
Transaction Machine Readable Output (MRO)
Transaction Request Download
Transaction End of Day (EOD) Download
Cost Basis User Master File Machine Readable Output (MRO)
Cost Basis User Master File WebDirect Download
Daily Deposit File for Transfer Agents WebDirect Download
Daily Reorg Deposit File for Transfer Agents WebDirect
Download
Test
Number
02980264
02981663
02981664
02981666
02981667
02981649
N/A
Production
Number
02400264
02401663
02401664
02561666
02561667
02401649
02401912
The canned file for testing has different numbers depending on what type of user is receiving the
file. When requesting the canned file, please indicate the number that corresponds to your user
type:
•
•
•
•
02991797 for a bank
02991798 for a broker-dealer
02991119 for a mutual fund
02991796 for a transfer agent
10.3 Description of the CBRS output files
Transaction Machine Readable Output (MRO). For computer to computer connection users.
This file contains all CBRS transaction output for the firm for the current processing date. (While
this file is intended for computer to computer connection users, it is also available for WebDirect
users to download using the CBRS Output Files function.)
Transaction Request WebDirect Download. For WebDirect users. Firms can use the
“transaction inquiry” function to search and view specific transactions using various criteria, such
162
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
as ISIN, Transfer Control Number, or Transaction Type. They can then download these requested
transactions to Excel. This file contains these specifically requested transactions in Excel format.
Transaction End of Day (EOD) Download. For WebDirect users. This file contains all
transactions for the current processing day in Excel format. It contains the same information
provided in Transaction Machine Readable Output (MRO) for that day.
Cost Basis User Master File Machine Readable Output (MRO). For computer to computer
connection users. This file provides a listing of the firms that are active users of CBRS in MRO
format. (While this file is intended for computer to computer connection users, it is also available
for WebDirect users to download using the CBRS Output Files function.)
Cost Basis User Master File WebDirect Download. For WebDirect users. This file provides a
listing of the firms that are active users of CBRS in tilde-delimited format for converting to Excel.
Daily Deposit File for Equity Transfer Agents. For Equity Transfer Agents only. This file
contains the deposits for that Transfer Agent for that day, so they know for which deposits they can
expect to send cost basis. The file is available through WebDirect, or on the mainframe for retrieval
via Data Transmission Facility (DTF) function DPCBRS.
Daily Reorg Deposit File for Equity Transfer Agents. For Equity Transfer Agents only. This
file contains the reorg deposits for that Transfer Agent for that day, so they know for which reorg
deposits they can expect to send cost basis. The file is available through WebDirect, or on the
mainframe for retrieval via Data Transmission Facility (DTF) function DRCBRS.
163
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
11 Appendix B: List of valid characters for CBRS
'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I',
'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R',
'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z',
'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r',
's', 't', 'u', 'v', 'w', 'x', 'y', 'z',
'1', '2', '3', '4', '5', '6', '7', '8', '9',
'0',
'!', '@', '#', '$', '%', '&', '*', '(',
')', '-', '_', '+', '=', '~', '{', '}',
'¢', '\', ':', ';', '"', '<', '>',
',', '.', '?', '/', ' ', "'", '`'.
164
DTCC non-Confidential Green
Version 4.1 , dated March 2015
CBRS User Guide
12 Disclaimer and Copyright Notice
The primary purpose of this User Guide is to familiarize members with the Cost Basis Reporting
Service product offered by DTCC. This guide is not intended to serve as a legal document. No
statement in this guide should be construed as a legally binding rule or regulation, or as creating an
obligation on the part of DTCC or any person. In addition, any time schedules or time requirements
set forth herein are subject to change without notice. This service is governed by applicable Rules,
Procedures, and Service Guides for the Cost Basis Reporting Service, which contain the full terms,
conditions, and limitations applicable to this service.
Copyright © 2012
165
DTCC non-Confidential Green
Version 4.1 , dated March 2015