In order to facilitate the processing of your customer information, the FDIC requires that certain data be submitted electronically.
The following tables contain the data layout, format, required data, and additional information (where applicable). Please adhere to the following when constructing your data file:
- Data must be in an ASCII-flat, tab-delimited file. The requested media is an electronically uploaded file, USB/thumb drive or DVD.
- All files must contain 19 columns (i.e., a tab must be included, even if the field is blank).
- Do not include column headers or summary lines. The file must contain only investor/sub-broker records.
Failure to comply with these requirements could delay the processing of your customers' information. Please note the following are examples of common mistakes made when preparing the data file:
Common Mistakes
- Ending a record after the Principal column (column 18) (i.e., not including a tab when the Sub-Broker Indicator is blank).
- Non-DO broker including CUSIP in the Non-DO file (column 4).
- Including column headings on the first line.
- Providing miscellaneous information at the bottom of the file.
- Leading zeroes of Tax ID (column 5) and Zip (column 14) being dropped. Usually this is caused by exporting from Excel and formatting the field as something other than Text.
- Missing cents in Principal (column 18). This usually occurs when exporting from Excel and formatting the field as something other than Text (e.g., Currency, Special, or Custom).
- Including currency symbols in the Principal (e.g., "$" or comma). The decimal point must be present.
- Including double-quotes around fields.
If you are a deposit broker acting as an agent for others and you have placed funds in account(s) at the failed institution in your company's name, FDIC considers you a Non-DO broker. Non-DO brokers placed funds directly in accounts at the institution. If you have Non-DO brokered accounts at the failed institution, please use the Non-DO Broker Submission File format.
If you are a deposit broker acting as an agent for others and you have placed funds in CUSIPs through the Depository Trust Company (DTC), FDIC considers you a DO broker. DO brokers do not place funds directly in accounts at the failed institution, but instead place funds with DTC who then opens an account at the failed institution. If you are a DO broker participating in a CUSIP under DTC at the failed institution, please use the DO Broker Submission File format.
NOTE: A single deposit broker acting as an agent for others can be both a Non-DO and a DO broker at the same failed institution. In this instance, the deposit broker would have placed funds in accounts directly at the institution AND would have placed funds in CUSIPs under the DTC at the institution. Two separate file submissions (one Non-DO Broker Submission and one DO Broker Submission) would need to be submitted for this institution.
Non-DO Broker Submission File
The file format and field descriptions of the fields contained in the Non-DO Broker Submission File are contained in the table below. Deposit brokers will submit investor and sub-broker information in an electronic format. The file must be submitted in the format specified below:
Non-DO Broker Submission File Format
Col | Field Name | Description | Validation Rules |
---|---|---|---|
01 | Broker Number | Not applicable. Only used for DO broker submissions. |
|
02 | Account Number | Account Number at failed institution. |
|
03 | Customer Account Number | Broker assigned customer account number. |
|
04 | CUSIP | Not applicable. Only used for DO broker submissions. |
|
05 | Tax ID | Taxpayer identification number of the primary account holder. It is usually the customer's SSN (no hyphens). The Tax ID should be for the investor. The broker's Tax ID should not be used for all of the investors. |
|
06 | Tax ID Code | Code indicates corporate (TIN) or personal tax identification number (SSN). |
|
07 | Name 1 | Full name of owner line 1 as it appears on the broker's records. |
|
08 | Name 2 | Full name of owner line 2 as is appears on the broker's records. |
|
09 | Address 1 | Address line 1 as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
10 | Address 2 | Address line 2 as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
11 | Address 3 | Address line 3 as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
12 | City | Address city as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
13 | State | State postal abbreviation as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
14 | Zip | Address zip as it appears on the customer's statement (no hyphens). The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
15 | Country | Country code as it appears on the customer's statement. |
|
16 | Province | Province as it appears on the customer's statement. |
|
17 | IRA Code | Code or flag indicating the type of IRA account. |
|
18 | Principal | Principal balance of the customer's account as of the institution failure date. |
|
19 | Interest | Accrued interest balance of the customer’s account as of the institution failure date. If left blank, the account balance accrued interest will be proportionately applied. Leave column blank if investment account type is CD’s at failed bank. |
|
20 | Sub-broker Indicator | A "Y" (yes) indicates the customer is a broker for others (as opposed to an individual investor). The sub-broker record should only be included if the sub-broker's investors are not included in the file. Additional information is provided below. |
|
Sub-broker Indicator (additional information)
The sub-tier broker should be included as a sub-broker record in the first-tier broker's submission file only if the sub-tier broker's investors are not included in the first-tier broker's submission file. In this case the sub-broker indicator value should be "Y" on the sub-tier broker's record in the first-tier broker's submission file.
If the first-tier broker's submission file contains the sub-tier broker's investors, the sub-tier broker should not be included as a sub-broker in the file, as the sub-tier broker's investors represent the total of the sub-tier broker's investment. In this case the sub-broker indicator value should be blank on all of the investors as they are not sub-brokers. In this instance, including the sub-tier broker's record would be double-counting the sub-tier broker's investment.
DO Broker Submission File
The file format and field descriptions of the fields contained in the DO Broker Submission File are contained in the table below. Deposit brokers will submit investor and sub-broker information in an electronic format. The file must be submitted in the format specified below:
DO Broker Submission File Format
Col | Field Name | Description | Validation Rules |
---|---|---|---|
01 | Broker Number | DTC assigned broker participation number. |
|
02 | Account Number | Not applicable. Only used for Non-DO broker submissions. |
|
03 | Customer Account Number | Broker assigned customer account number. |
|
04 | CUSIP | CUSIP Number. |
|
05 | Tax ID | Taxpayer identification number of the primary account holder. It is usually the customer's SSN (no hyphens). The Tax ID should be for the investor. The broker's Tax ID should not be used for all of the investors. |
|
06 | Tax ID Code | Code indicates corporate (TIN) or personal tax identification number (SSN). |
|
07 | Name 1 | Full name of owner line 1 as it appears on the broker's records. |
|
08 | Name 2 | Full name of owner line 2 as is appears on the broker's records. |
|
09 | Address 1 | Address line 1 as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
10 | Address 2 | Address line 2 as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
11 | Address 3 | Address line 3 as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
12 | City | Address city as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
13 | State | State postal abbreviation as it appears on the customer's statement. The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
14 | Zip | Address zip as it appears on the customer's statement (no hyphens). The address information should be for the investor. The broker's address should not be used for all of the investors. |
|
15 | Country | Country code as it appears on the customer's statement. |
|
16 | Province | Province as it appears on the customer's statement. |
|
17 | IRA Code | Code or flag indicating the type of IRA account. |
|
18 | Principal | Principal balance of the customer's account as of the institution failure date. |
|
19 | Interest | Not applicable. Only used for NON-DO broker submissions. |
|
20 | Sub-broker Indicator | A "Y" (yes) indicates the customer is a broker for others (as opposed to an individual investor). The sub-broker record should only be included if the sub-broker's investors are not included in the file. Additional information is provided below. |
|
Sub-broker Indicator (additional information)
The sub-tier broker should be included as a sub-broker record in the first-tier broker's submission file only if the sub-tier broker's investors are not included in the first-tier broker's submission file. In this case the sub-broker indicator value should be "Y" on the sub-tier broker's record in the first-tier broker's submission file.
If the first-tier broker's submission file contains the sub-tier broker's investors, the sub-tier broker should not be included as a sub-broker in the file, as the sub-tier broker's investors represent the total of the sub-tier broker's investment. In this case, the sub-broker indicator value should be blank on all of the investors as they are not sub-brokers. In this instance, including the sub-tier broker's record would be double-counting the sub-tier broker's investment.