Close Navigation

Mass Upload Guide

Overview

Mass Upload is a streamlined process designed for Advisors and Brokers looking to efficiently transfer 20+ client accounts to Interactive Brokers (IBKR). This process eliminates the need to complete individual applications by enabling bulk account opening through specialized workbooks.

Workbook Structure

IBKR provides dedicated workbooks for each supported account type:

Account TypeSub Types
IndividualIndividual
JointJoint Tenants
Tenants by Entirety
Joint Tenants with Rights of Survivorship
RetirementTraditional IRA
Rollover IRA
SEP IRA
Roth IRA
Inherited IRA
Roth Inherited IRA
TrustRevocable
Testamentary
Irrevocable
ERISA Plan Trust
Other
Self Managed Super Fund
OrganizationsCorporation
LLC
Partnership

Each workbook contains multiple sheets that correspond to different application components, allowing for comprehensive data collection in a structured format.

Note: UTMA and UGMA accounts are not supported via Mass Upload. These application types can be created within your Advisor/Broker Portal > “Add Account”.

Audience

IBKR’s Mass Upload is available by request to Registered Advisors and Introducing Brokers only. This service is designed specifically for advisors and brokers conducting bulk account migrations.

Minimum Requirements

Due to the structured nature of the process—with separate workbooks required for each account type—we typically require a minimum of 20 accounts per workbook/upload to ensure operational efficiency.

  • For submissions falling below this threshold, the IBKR hosted application offers a more streamlined and efficient solution.

Key Benefits

Bulk Account Creation

Create client account applications efficiently in bulk.

Prefilled Client Applications

Streamline the client onboarding experience with prefilled applications using the comprehensive data provided in your Mass Upload workbook.

Getting Started

We understand that migrating client accounts can often be complex. To assist with this transition, we have a designated Mass Upload team (massupload@interactivebrokers.com) that will support you throughout the process. To begin your Mass Upload migration, please follow the preliminary steps listed below.

Preliminary Steps

  1. Send an email to massupload@interactivebrokers.com with the following:
    • Firm Name
    • Firm Role (i.e. Registered Investment Advisor OR Introducing Broker)
    • IBKR Account Number (if available)
    • Brief overview on migration including expected number of accounts by type, AUM, and timeline.
  2. A representative from our Mass Upload team will schedule a 30-minute introductory call to assess your migration needs and review the process.
  3. Mass Upload team will provide you with IBKR’s Mass Upload workbooks and confirm the next steps to begin the Mass Upload process.

Workflow

PhaseStepDescription
Phase 1: Data Preparationa) Workbook CompletionCounterparty completes the Mass Upload workbooks with comprehensive client data required for client account creation.
b) Secure Data SubmissionCounterparty provides the completed Mass Upload workbooks to IBKR via email.
– If IBKR requires any clarification regarding the submitted data, the Mass Upload support team will contact you directly.
– Mass Upload Support Team: massupload@interactivebrokers.com

Important: Ensure all mass upload workbooks are password-protected before sending via email.
Phase 2: Data ProcessingWorkbook ProcessingOnce Mass Upload workbooks have been completed in good order, the Mass Upload team processes the provided workbooks under your IBKR Master Account using the information provided in each workbook.

Workbooks are processed within 1-3 business days.
Credential GenerationOnce IBKR processes the workbooks, IBKR will provide file that contains account credentials.

File will contain the following:
– Client ID (Established by Counterparty)
– IBKR Account Numbers
– Unique Usernames
– Temporary Passwords  
Phase 3: Client OnboardingCredential DistributionCounterparty distributes the IBKR account credentials to their respective clients.
Application CompletionClients log in to IBKR’s Hosted Application using their provided credentials to:

1. Complete remaining application steps
2. Submit their application for final review and approval  

Information provided in IBKR’s Mass Upload workbooks will be pre-filled in IBKR’s Fully Electronic Application. This means, the more information provided in the workbook, the less the client will be prompted to complete within the IBKR Hosted Application.  

Fully Disclosed/Advisor Clients

Supported Accounts

  • Individual
  • Joint
  • Retirement
  • Trust
    • Revocable
    • Testamentary
    • Irrevocable
    • SMSF
    • ERISA Plan Trust
  • Organization
    • Corporation
    • LLC
    • Partnership

Note: UTMA and UGMA accounts are not supported via Mass Upload. These application types can be created within your Advisor/Broker Portal > “Add Account”.

ACATS Transfer Considerations

Holding Period

  • Funds transferred via ACATS are subject to a 10-day holding period
    • Important: Clients will not be able to withdraw funds during this 10-day period.

Required Minimum Distributions (RMD)

  • Special attention must be paid to RMD (Required Minimum Distribution) expectations for IRA accounts being transferred to IBKR. If ACATS instructions are included in your Mass Upload workbook, ACATS requests will be triggered as soon as the client account has been approved and opened at IBKR. It is recommended that RMDs be completed prior to ACATS requests.

Security Transfers

If you plan to include ACATs instructions in your Mass Upload workbooks, we strongly recommend providing massupload@interactivebrokers.com with a comprehensive list of assets that will be transferred to Interactive Brokers. Our Mass Upload team will verify these assets in our system to ensure all securities can be accepted by IBKR, preventing potential transfer delays or rejections.

  • Note: Master Limited Partnerships (MLP’s) must be liquidated prior to transfer

Fee Configuration Details

For Advisor Clients, the client will be prompted to acknowledge Client Fees when completing the online application, avoiding the need for users to log-in after the client account has been opened.

Online Steps

In this section we cover the client experience for completing the online portion of account opening following the initial upload. Estimated completion time: 10 minutes or less.

What Clients Will Need:

  • Email access
  • User ID and temporary password (provided by their advisor/broker)
  • Mobile device (optional)

Important Notes:

  • The online workflow will vary depending on account type (Individual, Joint, IRA, Organization, or Trust)
  • If white-label branding is enabled, clients will see your firm’s logo and branding throughout the application; otherwise, IBKR branding will appear
  • Client information entered in the mass upload workbook will be pre-populated in the online application
  • Clients will have the ability to update or make changes to any fields that were provided via Mass Upload and appear as pre-populated fields within the online application

  1. Set Password and Complete Email Verification (Optional)
    • Upon accessing IBKR Portal, user will be prompted to enter temporary password (that was included in the response file) + set new password.

      IBKR will send email confirmation toke to verify the identity. Email will be branded with your company logo and return email address.

      Sample email

      Password change has been processed.
    • Option 2: Set Password Post Approval
      • Counterparty will direct user to IBKR’s Password Reset Tool to set password.
      • User enters IBKR username and date of birth.
      • IBKR will send SMS token to verify identity.
      • User will set password and complete email verification.
  2. User completes remaining application steps.
    • Application will be pre-filled with information that was included in the XML file to create the account.
    • Screen 1: About You
    • Screen 2: Configure Your Trading Account
    • Screen 3: Agreements and Disclosures
    • Screen 4: Application Status

Set Password and Complete Email Verification (Optional)

  • Upon accessing IBKR Portal, user will be prompted to enter temporary password (that was included in the response file) + set new password.

    IBKR will send email confirmation toke to verify the identity. Email will be branded with your company logo and return email address.

    Sample email

    Password change has been processed.
  • Option 2: Set Password Post Approval
    • Counterparty will direct user to IBKR’s Password Reset Tool to set password.
    • User enters IBKR username and date of birth.
    • IBKR will send SMS token to verify identity.
    • User will set password and complete email verification.
    • Application will be pre-filled with information that was included in the XML file to create the account.

Screen 1: About You

Screen 2: Beneficiary Information

  • Individual Beneficiary
  • Entity Beneficiary

Screen 3: Configure Your Trading Account

Screen 4: Review & Sign Agreements

Screen 5: Application Status

  1. Set Password and Complete Email Verification (Optional)
    • Upon accessing IBKR Portal, user will be prompted to enter temporary password (that was included in the response file) + set new password.

      IBKR will send email confirmation toke to verify the identity. Email will be branded with your company logo and return email address.

      Sample email

      Password change has been processed.
    • Option 2: Set Password Post Approval
      • Counterparty will direct user to IBKR’s Password Reset Tool to set password.
      • User enters IBKR username and date of birth.
      • IBKR will send SMS token to verify identity.
      • User will set password and complete email verification.
      • Application will be pre-filled with information that was included in the XML file to create the account.

Screen 1: About You (Primary Holder)

Screen 2: About You (Secondary Holder)

  • Primary Holder can create a Username and Password for the Secondholder

Screen 3: Configure Your Trading Account

Screen 4: Review & Sign Agreements

Screen 5: Application Status

Set Password and Complete Email Verification (Optional)

  • Upon accessing IBKR Portal, user will be prompted to enter temporary password (that was included in the response file) + set new password.

    IBKR will send email confirmation toke to verify the identity. Email will be branded with your company logo and return email address.

    Sample email

    Password change has been processed.
  • Option 2: Set Password Post Approval
    • Counterparty will direct user to IBKR’s Password Reset Tool to set password.
    • User enters IBKR username and date of birth.
    • IBKR will send SMS token to verify identity.
    • User will set password and complete email verification.
    • Application will be pre-filled with information that was included in the XML file to create the account.

Screen 1: About You

Screen 2: Trustee Information

  • Individual Trustee

  • Entity Trustee

Screen 3: Settlors/Grantor Information

  • Individual Settlor/Grantor
  • Entity Settlor/Grantor

Screen 4: Tax Classification

Screen 5: Beneficiary Information

  • Individual Beneficiary
  • Entity Beneficiary

Screen 6: Regulatory Information

Screen 7: Configure Your Trading Account

Screen 8: Confirm Your Tax Residence

Screen 9: Confirm Your Tax Residence

Screen 10: Affiliation

Screen 11: Review and Sign Agreements

Screen 12: Application Status

Workbook Completion

Required Data

Below fields reflect the minimum information that IBKR requires to create accounts using mass upload. It is important to note that the more complete the Mass Upload workbook is, the less information your client will be required to provide in the IBKR Hosted Application.

Required Fields

Tab NameRequired FieldsOptional Fields
Account InformationEmail Address
Prefix
Residential Country
Legal Residence State
Base Currency
IRA Type (Required for IRA)
SYEP
Alias
IRA Type (Not required for Individual and Joint)
Customer InformationSalutation
Name (First, Last)
Country of Birth
Residence Address (Street, City, State/Province, Country, Zip)
Margin (Margin/Cash)
Date of Birth
Gender
Marital Status
Citizenship
Tax Residency Country
Tax Number
Document (Type, Issuing Country, Number)
Market Data Status

Phone (Number, Type, Country)
Mailing Address Mailing
Street Address
City
State/Province
Country
Zip
Employment Information Employment Type
Occupation
Name of Employer
Employer Address (Street, City, State/Province, Country, Zip)
Source of Wealth Source of Wealth
Used to Fund Account
Percentage
Financial Information Investment Objective(s)
Estimated
Net Worth
Estimated Liquid Net Worth
Annual Net Income
Trading Experience
Trading PermissionsTrading Permissions 
Advisor Wrap FeesAdvisor Wrap Fees (Financial Advisor Clients Only) 
ACATS Customer Account at Broker
Broker ID
Broker Name
Transfer Scope (Full)  
Has Margin Loan
Holds Options Positions
Holds Short Positions
IRA Type
IB Account ID
Signature
Transfer Type
Authorize to Remove Funds
Tab NameRequired FieldsOptional Fields
Account Information
Email Address
Prefix
Residential Country
Legal Residence State
Base Currency
IRA Type (Required for IRA)
SYEP
Alias
IRA Type (Not required for Individual and Joint)
Customer Information
Salutation
Name (First, Last)
Country of Birth
Residence Address (Street, City, State/Province, Country, Zip)
Margin (Margin/Cash)
Date of Birth
Gender
Marital Status
Citizenship
Tax Residency Country
Tax Number
Document (Type, Issuing Country, Number)
Market Data Status

Phone (Number, Type, Country)
Mailing Address
 Mailing
Street Address
City
State/Province
Country
Zip
Employment Information
 Employment Type
Occupation
Name of Employer
Employer Address (Street, City, State/Province, Country, Zip)
IRA Individual Beneficiaries
 Beneficiary Type
Relationship
Ownership %
Salutation
Name (First, Last)
Residence Address (Street, City, State/Province, Country, Zip)
Date of Birth
Country of Citizenship
Document (Type, Issuing Country, Number)
IRA Entity Beneficiaries
 Beneficiary Type
Relationship
Ownership %
Trust Name
Execution Date
Article of Will
Salutation
Executor Name (First, Last)
Entity Address (Street, City, State/Province, Country, Zip)
IRA Decedent
 Salutation
Decedent’s Name (First, Last)
Inheritor Type
Date of Birth
Date of Death
Country
Document (Type, Issuing Country, Number)
Source of Wealth
 Source of Wealth
Used to Fund Account
Percentage
Financial Information
 Investment Objective(s)
Estimated
Net Worth
Estimated Liquid Net Worth
Annual Net Income
Trading Experience
Trading Permissions
Trading Permissions 
Advisor Wrap Fees
Advisor Wrap Fees (Financial Advisor Clients Only) 
ACATS
 Customer Account at Broker
Broker ID
Broker Name
Transfer Scope (Full)  
Has Margin Loan
Holds Options Positions
Holds Short Positions
IRA Type
IB Account ID
Signature
Transfer Type
Authorize to Remove Funds
Tab NameRequired FieldsOptional Fields
Account Information
Email Address
Prefix
Residential Country
Legal Residence State
Base Currency
IRA Type (Required for IRA)
SYEP
Alias
IRA Type (Not required for Individual and Joint)
Joint Account Type & OwnershipJoint Account Type
First Holder
Ownership %
Second Holder
Ownership %
Customer Information
Salutation
Name (First, Last)
Country of Birth
Residence Address (Street, City, State/Province, Country, Zip)
Margin (Margin/Cash)
Date of Birth
Gender
Marital Status
Citizenship
Tax Residency Country
Tax Number
Document (Type, Issuing Country, Number)
Market Data Status

Phone (Number, Type, Country)
Second Holder Information
Salutation
Name (First, Last)
Country of Birth
Residence Address (Street, City, State/Province, Country, Zip)
Postal Code
Date of Birth
Gender
Marital Status
Country of Citizenship
Tax Residency Country
Tax Number
Document (Type, Issuing Country, Number)  
 Phone (Number, Type, Country)
Mailing Address
 Mailing
Street Address
City
State/Province
Country
Zip
Second Holder Mailing Address
 Mailing
Street
Address
City
State/Province
Country
Zip
Employment Information
 Employment Type
Occupation
Name of Employer
Employer Address (Street, City, State/Province, Country, Zip)
Source of Wealth
 Source of Wealth
Used to Fund Account
Percentage
Financial Information
 Investment Objective(s)
Estimated
Net Worth
Estimated Liquid Net Worth
Annual Net Income
Trading Experience
Trading Permissions
Trading Permissions 
Advisor Wrap Fees
Advisor Wrap Fees (Financial Advisor Clients Only) 
ACATS
 Customer Account at Broker
Broker ID
Broker Name
Transfer Scope (Full)  
Has Margin Loan
Holds Options Positions
Holds Short Positions
IRA Type
IB Account ID
Signature
Transfer Type
Authorize to Remove Funds
Tab NameRequired Fields           Optional Fields
Trust Information  Trust Name
Type of Trust
Date Trust Was Established
Formation Country
Formation State
Registration Country
Email
Trust Address (Street, City, State/Province, Country, Zip)
Registration/Tax/Gov’t ID
Tax ID
Type
Mailing Address Mailing Address (Street, City, State/Province, Country, Zip)
Associated Individuals Type
Beneficiary %
Name (First, Last)
Email
Can Sign Documents
Registered with NFA (NFA Number)
Employer Details (Occupation, Job Title)
Residence (Street, City, State, Country, Zip)
Phone Number
Date of Birth
Country of Citizenship
Document (Type, Country, ID Number)
Associated Entities Type
Beneficiary %
Name
Document (Type, Country, ID Number)
Formation (Type, Country)
Registered with NFA (NFA Number)
Business Address (Street, City, State, Country, Zip)
Phone Number
Entity Employees Name (First, Last, Middle, Suffix)
Can Sign Documents
Registered with NFA (NFA Number)
Email Address
Financial Information Investment Objective(s)
Estimated Net Worth
Estimated Liquid Net Worth
Annual Net Income
Trading Experience
Source of Wealth Source of Wealth
Used to Fund Account
Percentage
Account InformationPrefix
Base Currency
Margin
Capability
Alias
User Privilege
Multicurrency
IRA Type (Not applicable)
SYEP
Trading PermissionsTrading Permissions 
Advisor Wrap FeesAdvisor Wrap Fees (Financial Advisor Clients Only) 
ACATS Customer Account at Broker
Broker ID
Broker Name
Transfer Scope (Full)
Has Margin Loan
Holds Options Positions
Holds Short Positions
IRA Type
IB Account ID
Signature
Transfer Type
Authorize to Remove Funds
Tab NameRequired Fields           Optional
Account Information  Email Address
Prefix
Residential Country
Legal State Residence
Base Currency
Alias
IRA Type (Not Required)
SYEP  
Organizational InformationOrganizational Type
Type of Trading
US Tax Classification
Name
Business Description
Formation Country
Address (Street, City, State/Province, Country, Zip)
Margin
Identification (Number, Country)
Phone (Number, Type, Country)
Market Data Status
Tax (Residency Country, Tax Number)
Authorized Person Title Code
Salutation
Name (First, Last)
Email
Residence (Street, City, State/Province, Country, Zip)
Phone (Number, Type)
Date of Birth
Country of Birth
Tax (Residency Country, Tax Number)
Document (Type, Country of Issuance, Number)
Employment (Type, Occupation, Employer Address)
Associated Persons Association Type
Ownership %
Salutation
Name (First, Last)
Address (Street, City, State/Province, Country, Zip)
Phone (Number, Type, Country)
Tax (Residency Country, Number)
Document (Type, Country of Issuance, Number)
Employment (Type, Occupation, Employer Address)
Associated Entities Entity Name
Ownership %
Business Address (Street, City, State/Province, Country, Zip)
Phone (Number, Type, Country)
Formation (Country, Type)
Exchange (Symbol, Code)
Tax (Country, Number)
Signatory Name (First, Last)
Source Of Wealth Source of Wealth
Used to Fund Account
Percentage
Financial Information Investment Objective(s)
Estimated Net Worth
Estimated Liquid Net Worth
Annual Net Income
Trading Experience
Trading PermissionsTrading Permissions 
Advisor Wrap FeesAdvisor Wrap Fees (Financial Advisor Clients Only) 
ACATS Customer Account at Broker
Broker ID
Broker Name
Transfer Scope (Full)
Has Margin Loan
Holds Options Positions
Holds Short Positions
IRA Type
IB Account ID
Signature
Transfer Type
Authorize to Remove Funds

Spec

Please refer to our Mass Upload Workbook Specification below. We have included separate drop down menus for each tab in IBKR’s Mass Upload workbook for your reference.

ColumnFieldDescriptionValue Type
ACustomer ID
required
Customer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String
BEmail Address
required
Email Address of the associated individualString
CPrefix
required
Prefix is used to generate the client’s username. The Prefix must be five to six lowercase characters (alphabetical only)

IBKR will use the prefix provided to append three random numbers when generating the client’s username
String
DResidential Country
required
Country which the applicant resides

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
ELegal Residence State
required
State/Province which the applicant resides

IBKR requires the State/Province’s 3166-2 ISO Code
3166-2 ISO Code
FBase Currency
required
Base Currency of the client’s accountAvailable currencies can be found here.
GAliasAccount Alias lets you define an alias for the account. For example, you might want to define an account alias that is easier to remember than your account ID

If you create an account alias, it will appear on account statements, the account management portal and TWS
String
HIRA TypeOnly required for IRA AccountsTraditional
SEP
Traditional Rollover
Roth Traditional
Inherited Roth
Inherited
ISYEP
required
The Stock Yield Enhancement Program (SYEP) provides customers with the opportunity to earn additional income on fully paid securities by permitting IBKR to lend out those securities to third parties

IBKR Reference: https://ibkb.interactivebrokers.com/zh-hans/node/1838
Yes
No

Account Information – Sample

ColumnFieldDescriptionValue Type
ACustomer ID
required
Customer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String
BSalutation
required
Salutation of the applicantMr.
Mrs.
Ms.
Dr.
Mx.
Ind.
CFirst Name
required
Legal first name of the applicant String; max characters 50
DLast Name
required
Legal last name of the applicantString; max characters 50
EMiddle InitialMiddle initial of the applicantString; max characters 50
FSuffix
Suffix of the applicantString
GDate of Birth
required
Date of birth of the associated individualYYYY-MM-DD
HCountry of Birth
required
Country where the individual was born3 Digit ISO Code
IGender
required
Gender of the individualMale
Female
JMarital Status
required
Marital status of the applicantSingle
Married
Widowed
Divorced
KDependents
required
Number of dependents for the account holderNumber
LHome Street Address
required
Street which applicant residesString; Max characters 200
MCity
required
City which the applicant residesString; Max characters 100
NState/Province
required
State/Province which the applicant resides

IBKR requires the State/Province’s 3166-2 ISO Code
3166-2 ISO Code
OCountry
required
Country which the applicant resides

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
PZip
required
Postal / Zip code

For countries that do not provide postal code, please enter “00000″
String; Max characters 20
QPhone NumberPhone Number for the applicantString; max characters 18
RPhone TypePhone Number Type for the applicant. Mobile phone number is requiredMobile
Home
SPhone CountryCountry which phone number is associated to

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
TCountry of Citizenship
required
Country of Citizenship for the applicant

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
UTax Residence Country
required
Tax Residency information of the associate individual

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
VTax Number
required
Tax Identification Number of the applicantString
WDocument Type
required
Identification Document Type

Document Type must be “SSN” for US Citizens
SSN
National Identity Card
Alien Identification Card Passport
Driver’s License
XIssuing Country
required
Issuing country of the ID Document3 Digit ISO Code
YDocument Number
required
ID Document NumberString
ZMargin
required
Type of margin rules to be applied to the accountCash
Margin
AAMarket Data Status
required
Market Data Subscriber of the applicantNon-Professional Professional

Customer Information – Sample

ColumnFieldDescriptionValue Type
ACustomer IDCustomer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String
BMailing Street AddressStreet address for the applicant’s mailing addressString; Max characters 200
CCityCity for the applicant’s mailing addressString; Max characters 100
DState/ProvinceState/Province of the applicant’s mailing address

IBKR requires the State/Province’s 3166-2 ISO Code
3166-2 ISO Code
ECountryCountry of the applicant’s mailing address

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
FZipPostal / Zip code of the applicant’s mailing addressString; Max characters 20

Mailing Address – Sample

ColumnFieldDescriptionValue Type
ACustomer IDCustomer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String
BEmployment TypeEmployment status of the applicantEmployed
Self-Employed Unemployed
Retired
Student/Intern
At-Home Trader Homemaker
COccupationOccupation of the applicant 
DName of EmployerName of the applicant’s employerString
ENature of Employer Business/ActivitiesNature of Business for the applicant’s employer

Validations can be found on “Sheet 1” of the Workbook
 
FEmployer AddressStreet which the employer is locatedString; Max characters 200
GCityCity which the employer is locatedString; Max characters 100
HState/ProvinceState/Province which the employer is located

IBKR requires the State/Province’s 3166-2 ISO Code
3166-2 ISO Code
ICountryCountry which the employer is located

IBKR requires the country’s 3 Digit ISO Code
3 Digit ISO Code
JZipPostal / Zip code for the employerString; Max characters 20
KAdditional Sources of IncomeAdditional Sources of Income for the Applicant 
LDescriptionDescription of additional sources of income String
MPercentagePercentage of additional sources of income String

Employment Information – Sample

ColumnFieldDescriptionValue Type
ACustomer IDCustomer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String  
BInvestment ObjectiveInvestment Objectives of the Applicant Eligibility for Trading Permissions will vary based on the Investment Objectives.
This cannot be hard coded

To Trade All Products:
Growth + Trading Profits + Speculation + Hedging
Growth + Speculation + Hedging
Growth + Speculation
Growth + Trading Profits
Hedging + Trading Profits
Speculation + Hedging
Speculation + Hedging + Trading Profits

Bonds Only:
Preservation of Capital only

Income + Preservation of Capital + Growth= cannot include Options or Forex

Income + Preservation of Capital + Growth + Hedging= cannot include Options  

Description:
Preservation of Capital: Seek maximum safety and stability for your principal by focusing on securities and investments that carry a low degree of risk.
Income: Generate dividend, interest or other income instead of, or in addition to, seeking long-term capital appreciation.
Growth: Increase the principal value of your investments over time rather than seeking current income. Investor assumes higher degree of risk.
Trading Profits: Increase the principal value of your investments by using shorter term trading strategies and by assuming higher risk.
Speculation: Substantially increase the principal value of your investments by assuming substantially higher risk to your investment capital.
Hedging: Take positions in a product in order to hedge or offset the risk in another product.  
Preservation of Capital
Income
Growth
Trading Profits
Speculation
Hedging  
FEstimated Net WorthThe total value of all assets owned by the applicant, less what they owe (including all mortgages and debts). Applicant’s Net Worth cannot be less than their Liquid Net Worth

Minimum value accepted is 101; maximum value accepted is 50000001
Number  
GEstimated Liquid Net WorthThe total value of any assets the applicant owns that can be quickly converted into cash

Minimum value accepted is 101; maximum value accepted is 5000001
Number
HAnnual Net IncomeThe total amount of the applicant’s earnings for one year minus any taxes or other deductions taken from their pay. These other deductions could include health insurance, retirement contributions, court ordered judgements or support payments

Minimum value accepted is 0; maximum value accepted is 1000001
Number
IYears of Trading ExperienceYears of experience the applicant has trading this specific product

Note: Should be provided for each Product requested in the “Trading Permissions” tab
Number
JNumber of Trades per YearAverage number of trades per year placed by the applicant for the specified product

Note: Should be provided for each Product requested in the “Trading Permissions” tab
Number
KKnowledge LevelKnowledge level the applicant has trading this product

Note: Should be provided for each Product requested in the “Trading Permissions” tab
Good
Limited
Extensive

Financial Information – Sample

ColumnFieldDescriptionValue Type
ACustomer IDCustomer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String
BSource of WealthSource of the applicant’s Wealth the applicant is using to fund the account

Note: Applicants can have multiple sources of wealth, but Percentage across all sourceOfWealth must = 100%.  

If Employment Type = EMPLOYED OR SELFEMPLOYED, then “Income” must be listed as a Source of Wealth but does not need to be “Yes” for “Used to Fund Account”
Allowance
Disability
Income
Inheritance
Interest
Market
Profit
Other
Pension
Property
CUsed to Fund AccountIs the source used to fund the account? Yes/NoYes
No
DPercentagePercentage of funds used to fund the applicant’s account

Percentage is not required IF usedForFunds=”false”
Number
EDescriptionDescribe source of funds. Only required if Source of Wealth is “Other”String

Source of Wealth – Sample

ColumnFieldDescriptionValue Type
ACustomer ID
required
Customer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String  
BPermissionTrading Permissions requested for the client account 

Trading Permissions – Sample

ColumnFieldDescriptionValue Type
ACustomer ID
required
Customer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String  
BStrategy
required
No Fees: Automated fees will not be applied to the client account  

Automated: Fees will be billed to the client’s account with blanket client authorization. Fees will be specified in the “Type” and “Maximum Fee” columns.

Template: Assign a pre-defined fee template to a client account. Fee Templates will need to be created in your Advisor Portal.   Disclaimer: Fee schedule will automatically be applied once the account is opened and funded
No Fees
Automated
Template
CType  If the “Strategy” was Automated, then specify the automated Fee Type

Annual Flat Fee M – Entered as an annualized amount, applied on a monthly basis (apportioned by 252 days).

Percent of Equity Q – Entered as an annualized percentage, applied on a Quarterly basis.

Percent of Equity M – Entered as an annualized percentage, applied on a Monthly basis.

Percent of Profit – A fixed percent is applied to the mark-to-market P&L (positive or negative) at the end of each year.

Percent of Profit Q – A fixed percent is applied to the mark-to-market P&L (positive or negative) at the end of each year.
Details  

If “Strategy” is Template, then provide the Name of the fee template being applied. Data is case and space sensitive. The feesTemplateName must match the name of the template which was previously created in the advisor/broker portal.
Details
Annual Flat Fee M
Percent of Equity Q Percent of Equity M Percent of Profit
Percent of Profit Q    

For Template Name; String
DMaximum Fee Automated Fee Percentage

Required IF “Strategy” = “Automated”
Number

Advisor Wrap Fees – Sample

ColumnFieldDescriptionValue Type
ACustomer IDCustomer ID is a unique identifier used to map customer information to each unique client account. The Customer ID should match across all completed workbook tabs

Alphanumeric characters only
String
BCust. AccT at BrokerClient account number at sending institutionString
CBroker IDDTC Number of the sending institutionNumber
DBroker NameName of the sending institutionString
ETransfer ScopeACATS Transfer Scope

Type will always be “Full”
Full
FHas Margin LoanIndicate if the client has a Margin Loan at the sending institutionYes
No
GHolds Options PositionsIndicate if the client holds Options Positions at the sending institutionYes
No
HHolds Short PositionsIndicate if the client holds Short Positions at the sending institutionYes
No
IIRA Type Only required for IRA AccountsTraditional
SEP
Traditional Rollover
Roth Traditional
Inherited Roth
Inherited
JIB Account IDIBKR Account Number of the client account that is initiating the transfer.

Only in required if the client maintains an IBKR Account #
String
KSignatureMust match the First Name, Middle Initial (if applicable), Last Name, Suffix (if applicable) entered on the “Customer Information” Tab

Signature is case and space sensitive
String
LTransfer TypeMethod used to initiate the transfer

Must be “ACATS”
ACATS
MAuthorize to Remove FundsIndicate if you authorize for IBKR to remove unsupported Mutual Funds

Yes = If unsupported mutual funds are found in the incoming account, IBKR will settle all supported positions and leave behind the unsupported mutual fund.

No = If unsupported mutual funds are found in the incoming account, IBKR will reject the entire ACAT and you can then address unsupported positions before resubmitting the transfer.  
Yes
No

ACATS – Sample

Excel Workbook Encryption

All Mass Upload workbooks provided to Interactive Brokers must be encrypted with a Password. To secure your Mass Upload workbook prior to submission, please use the steps outlined here.

Password Protect an Excel Workbook – Workflow:

Step 1: Select File > Info.

Step 2: Select the Protect Workbook box and choose Encrypt with Password.

Step 3: Enter a password in the Password box, and then select OK.

Step 4: Confirm the password in the Reenter Password box, and then select OK

For any questions regarding this process, please contact massupload@interactivebrokers.com.

What to Expect

Steps After Workbook Completion

Once you have completed your Mass Upload Workbooks, please follow these steps:

Step 1: Share your Mass Upload workbook with massupload@interactivebrokers.com

  • Workbooks shared with Interactive Brokers should be encrypted (See “Encrypt Excel Spreadsheets” for the proper steps of encryption)

Step 2: A representative will review your workbooks and provide any necessary comments or adjustment recommendations

Step 3: After properly formatted workbooks have been approved, a representative will initiate the Mass Upload process

  • Please note: Mass Upload processing typically takes 1-3 business days

Step 4: Once accounts have been successfully uploaded under your Master Account, the Mass Upload team will provide you with a response file that contains:

  • Customer ID
  • Client Name
  • IBKR Account Number
  • Username
  • Temporary Password

Step 5: Upon receiving the response file, you will proceed with distributing client account credentials to your end-users through your secure communication channels.

  • IBKR does not deliver client account credentials directly to your end-users.

Step 6: End-users will then be prompted to log-in to the IBKR Hosted Application to complete all remaining application fields. See “IBKR Hosted Application (Samples)” for samples on the IBKR Hosted Application

  • Fields passed to IBKR in the Mass Upload workbook will be pre-filled for the end-user to confirm.
  • IBKR’s Application will reflect the counterparty’s branding (logo, company name, color theme) IF white branding is configured.

Documentation Required

KYC – Trulioo Verification

Real-time Trulioo identity verification is processed immediately upon application submission for supported countries. If Trulioo verification is unsuccessful OR if the applicant resides in a country where Trulioo verification is not supported, additional Identity and Address verification documentation will be required for account approval.

Trulioo is supported for applicants that reside in following countries
ArgentinaChinaMalaysiaRussian FederationTurkey
AustraliaDenmarkMexicoSingaporeUnited Kingdom
AustriaFranceNetherlandsSouth AfricaUnited States
BelgiumGermanyNew ZealandSpain 
BrazilIrelandNorwaySweden 
CanadaItalyPortugalSwitzerland 

Other Countries:

  • Identity and Address verification will always be required for approval.

If Trulioo is NoMatch, IBKR will prompt the user to Au10Tix to complete verification.

Retirement Accounts

A Spousal Consent Form is required when two conditions are met: (1) the IRA Account Holder’s Marital Status is “Married” AND (2) the IRA Account Holder has designated someone other than their spouse (husband or wife) as the Primary Beneficiary. The Spousal Consent Form documents the spouse’s acknowledgment and consent to the non-spousal beneficiary designation.

Inherited IRA’s

For all Inherited IRA Accounts, IBKR requires submission of the original IRA Decedent’s Death Certificate.

Document Submission – Options

Counterparties will have two options to submit Documentation Required for client account approval for accounts created using Mass Upload:

Option 1: Application Status Page (IBKR Hosted Application)

Clients will have the ability to submit any required documentation in the “Application Status” page the IBKR Hosted Application (Final Application Page).  

  • To submit required documentation, clients can select “Upload” and select the file they wish to submit to IBKR

Option 2: Advisor/Broker Portal

Supporting documentation can be uploaded directly through the IBKR Advisor/Broker Portal. Please find steps below:

  1. Log-in to your Advisor/Broker Portal
  2. Select “Contacts & Accounts”
  3. Select “Accounts”
  4. Select “Pending – Additional Tasks” next to the Contact’s Name
  5. Select “Upload Document”

Servicing Your Clients

White Branding

The IBKR systems including Registration, Client Portal, and Emails can be customized (free of cost) to reflect your company branding including logo, company name, and theme file.

Instructions to configure White Branding:

Viewing Client Account Statuses

After clients complete the IBKR Hosted Application and submit their application for review and approval, you can track client account statuses and view Registration tasks directly within your Advisor/Broker Portal.

Steps to View Pending Registration Tasks:

  1. Log-in to your Advisor/Broker Portal
  2. Select Menu in the top left corner > Contacts & Accounts
  3. At the top of the page next to Pending – Additional Tasks select the Red Pill displaying the number of tasks.
    Image of the pending additional tasks notification in portal.
  4. The page displays accounts with pending registration tasks.Click the three horizontal dots () to show all pending tasks for a specific account.

Service Contacts

Mass Upload

For any Mass Upload Related Questions, please reach out to our Mass Upload team directly.

Professional Services

For any client account related questions, Advisors should reach out to our Financial Advisor Services (FAS) Team directly. Introducing Brokers should reach out to our Professional Services team directly.  

Contact NamePhone Number
Financial Advisor Services (Registered Investment Advisors)United States: 1 (866)694-2757
Non-US: +1 203 618 7791
Professional Services (Introducing Brokers)United States: 1 (866)694-2757
Non-US: +1 203 618 7791

IBKR Onboarding

For any questions related to the IBKR Advisor and Broker Portal, please reach out to our Onboarding Team directly.

IBKR Campus Newsletters

This website uses cookies to collect usage information in order to offer a better browsing experience. By browsing this site or by clicking on the "ACCEPT COOKIES" button you accept our Cookie Policy.