Each depositor insured to at least $250,000 per insured bank



Home > Deposit Insurance > Are My Deposits Insured? > Deposit Broker's Processing Guide




Deposit Broker's Processing Guide
VI. Broker Input File Requirements

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:

  1. Data must be in an ASCII-flat, tab delimited file. The requested media is diskette/compact disc.
  2. All files must contain 19 columns (i.e., a tab must be included, even if the field is blank).
  3. 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

  1. Ending a record after the Principal column (column 18) (i.e., not including a tab when the Sub-Broker Indicator is blank).
  2. Non-DO broker including CUSIP in the Non-DO file (column 4).
  3. Including column headings on the first line.
  4. Providing miscellaneous information at the bottom of the file.
  5. 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.
  6. 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).
  7. Including currency symbols in the Principal (e.g., "$" or comma). The decimal point must be present.
  8. 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 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.
  1. Must be blank.
02 Account Number Account Number at failed institution.
  1. Column cannot be blank. Data is required.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
03 Customer Account Number Broker assigned customer account number.
  1. Column can be blank.
  2. Variable Length but cannot exceed 16 characters.
  3. Must be AlphaNumeric Data Type.
04 CUSIP Not applicable. Only used for DO broker submissions.
  1. Must be blank.
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.
  1. Column cannot be blank. Data is required. Use "999999999" if the primary account holder does not have a Tax ID.
  2. Fixed Length of 9 characters.
  3. Must be Integer Data Type.
06 Tax ID Code Code indicates corporate (TIN) or personal tax identification number (SSN).
  1. Column cannot be blank. Data is required.
  2. Fixed Length of 1 character.
  3. Must be AlphaNumeric Data Type.
  4. Value must be "S" or "T". Use "S" if the primary account holder does not have a Tax ID.
07 Name 1 Full name of owner line 1 as it appears on the broker's records.
  1. Column cannot be blank. Data is required.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
08 Name 2 Full name of owner line 2 as is appears on the broker's records.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
  4. If Country, column 15, is "USA", value must be a valid 2-character US postal code (e.g., FL for Florida, IA for Iowa, etc.). If Country, column 15, is not "USA", value must be blank.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 9 characters.
  3. Must be AlphaNumeric Data Type.
  4. If Country, column 15, is "USA", value must be Integer, Fixed Length, 5 or 9 characters, or field must be blank.
15 Country Country code as it appears on the customer's statement.
  1. Column cannot be blank. Data is required.
  2. Fixed Length of 3 characters.
  3. Must be a valid 3-character ISO code for the nation (e.g., USA for United States of America, AIA for Anguilla, etc.).
16 Province Province as it appears on the customer's statement.
  1. Column can be blank.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
17 IRA Code Code or flag indicating the type of IRA account.
  1. Column can be blank.
  2. Variable Length but cannot exceed 1 character.
  3. If present, value must be "Y".
18 Principal Principal balance of the customer's account as of the institution failure date.
  1. Column cannot be blank. Data is required.
  2. Variable Length but cannot exceed 15 characters with 2 digits of precision.
  3. Must be Numeric Data Type.
19 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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 1 character.
  3. If present, value must be "Y".

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.
  1. Column cannot be blank. Data is required.
  2. Fixed Length of 4 characters.
  3. Must be Integer Data Type.
  4. Must be the same on all records in the file.
02 Account Number Not applicable. Only used for Non-DO broker submissions.
  1. Must be blank.
03 Customer Account Number Broker assigned customer account number.
  1. Column can be blank.
  2. Variable Length but cannot exceed 16 characters.
  3. Must be AlphaNumeric Data Type.
04 CUSIP CUSIP Number.
  1. Column cannot be blank. Data is required.
  2. Variable Length but cannot exceed 15 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column cannot be blank. Data is required. Use "999999999" if the primary account holder does not have a Tax ID.
  2. Fixed Length of 9 characters.
  3. Must be Integer Data Type.
06 Tax ID Code Code indicates corporate (TIN) or personal tax identification number (SSN).
  1. Column cannot be blank. Data is required.
  2. Fixed Length of 1 character.
  3. Must be AlphaNumeric Data Type.
  4. Value must be "S" or "T". Use "S" if the primary account holder does not have a Tax ID.
07 Name 1 Full name of owner line 1 as it appears on the broker's records.
  1. Column cannot be blank. Data is required.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
08 Name 2 Full name of owner line 2 as is appears on the broker's records.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 40 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
  4. If Country, column 15, is "USA", value must be a valid 2-character US postal code (e.g., FL for Florida, IA for Iowa, etc.). If Country, column 15, is not "USA", value must be blank.
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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 9 characters.
  3. Must be AlphaNumeric Data Type.
  4. If Country, column 15, is "USA", value must be Integer, Fixed Length, 5 or 9 characters, or field must be blank.
15 Country Country code as it appears on the customer's statement.
  1. Column cannot be blank. Data is required.
  2. Fixed Length of 3 characters.
  3. Must be a valid 3-character ISO code for the nation (e.g., USA for United States of America, AIA for Anguilla, etc.).
16 Province Province as it appears on the customer's statement.
  1. Column can be blank.
  2. Variable Length but cannot exceed 20 characters.
  3. Must be AlphaNumeric Data Type.
17 IRA Code Code or flag indicating the type of IRA account.
  1. Column can be blank.
  2. Variable Length but cannot exceed 1 character.
  3. If present, value must be "Y".
18 Principal Principal balance of the customer's account as of the institution failure date.
  1. Column cannot be blank. Data is required.
  2. Variable Length but cannot exceed 15 characters with 2 digits of precision.
  3. Must be Numeric Data Type.
19 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.
  1. Column can be blank.
  2. Variable Length but cannot exceed 1 character.
  3. If present, value must be "Y".

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.

Back to Table of Contents



Last Updated 10/27/2004 bdclaims@fdic.gov