Interactive Brokers offers a full suite of robust reporting software for financial advisors to pull standard statements, create custom reports, enable automatic statement delivery, and provides access to IBKR’s PortfolioAnalyst.
To access the reporting features, open the left side menu and click to expand the Reporting menu. The advisor can access Statements, Flex Queries, Data Queries, Advisor Reports, Tax documents, and Other Reports.
Statements
The Statements page is where the advisor can run default or custom reports at any time and configure automatic delivery of these reports. Use the blue Add/Edit button at the top of the page to select the account or group of accounts the report will be run for. To generate any of the Default Statements, click the blue Run arrow and select the period, date, format, and language for the report.
Custom Statements
If the default statements do not meet the advisor’s needs, the advisor can create custom reports which can be edited, deleted, or run at any time. Click the plus sign in the right corner of the Custom Statements panel to configure a new report.
The advisor can enter a name for the report and select the sections to be included, such as Commission Details and Trades. Select any desired Section and Delivery Configurations and click Continue to review the custom report before clicking Create. The newly created report will be reflected in the Custom Statements panel.
Statement Delivery
Both Default and Custom Statements can be enabled for automatic delivery to the advisor. However, the advisor can only configure custom statements to be delivered directly to the client.
The Statements Delivery panel configures the delivery of the report to the advisor user, whereas if the advisor would like to deliver a custom report to the client, they must navigate to the Contact, select the Performance & Reports tab, and click the configure gear icon to the right of the Client Statements Delivery panel.
Flex Queries
The Flex Queries page allows the advisor to configure highly customized reports that are XML, CSV, or Text formatted statement files that let the advisor specify the exact data fields and the order in which the fields appear on the report.
A Flex Query is different from the default Activity Statement or a Trade Confirmation Report because advisors can customize a Flex Query at the field level, allowing the advisor to include and exclude detailed field information. Customized Activity Statements only allows the advisor to include and exclude entire sections and the Trade Confirmation Report cannot be customized.
For example, the advisor can create a custom Activity Flex Query by clicking the plus sign in the upper right corner of the Activity Flex Query panel. Enter a name for the query and select from the sections to be included, such as Open Positions.
Once a section is selected, a window will appear where the advisor can select the data columns to include in the report by checking the boxes to the left. The advisor can change the order that the data fields are displayed in the report by clicking and dragging the three horizontal lines to the right. Once the sections and data columns have been selected, the advisor can enter the desired delivery and general configuration settings for the report. Click Continue to review the Flex Query before clicking Create.
Similar to Custom Statements, the Flex Queries can be enabled for automatic delivery to the advisor.
Creating Groups
As mentioned earlier, reports can be run for a single client account at a time or for a group (or household) of accounts. Financial Advisors can manage their groups from the left side menu and expanding Administration & Tools and selecting the Groups tab. Existing groups can be edited by clicking the pencil icon or deleted by clicking in the blue trashcan icon.
Advisors can create a new group by clicking the Create New Group icon in the upper right corner, entering a name for the group, and selecting whether it is a private group.
Private groups will only be visible and editable by the user that created it, whereas public groups are visible to all users on the master advisor account. Afterwards, the advisor can click Add/Edit Group Members to select the client accounts to be included in the group.
Households
In addition, for accounts that meet the criteria, advisors can create Households where one member is selected as the head of household, and that client can log in with their username to view reporting and account details for all accounts within the household.
Please note that accounts linked within a household will remain separate, segregated customer accounts. Householding simply allows the head of household read-only access to reporting and certain account information for the other accounts in the household.
To view or create households, click the Household link in the upper left corner in the Groups screen. To add a new household, click the blue Create New Household button in the upper right-hand corner and enter a name for the household. Add the accounts similar to creating a new group and click Continue.
Once the new Household request is submitted electronically, the Establish Head of Household form will need to be completed. If changes are made to an existing household, the Change Head of Household form will need to be completed. The blank forms are located on the right side of the page and the forms contain instructions for how to complete them.
Tax Documents
The Tax Reports page can be opened from the left side menu, expand Reporting, and select Tax Documents. Use the Add/Edit account button at the top to select the desired account to view the tax forms for.
The advisor can generate the tax forms for an individual client account, or they can select the master advisor account to download a zip file for all the tax documents for all of their clients.
Clients of financial advisors can also login directly to their Client Portal to retrieve their tax forms. Clients are notified when the tax forms are ready and are typically available by the dates listed on our website.
PortfolioAnalyst
In addition to the reporting features reviewed thus far, advisors have access to IBKR’s PortfolioAnalyst. PortfolioAnalyst is a powerful analytical tool housed within Advisor Portal that consolidates, tracks, and analyzes the client’s complete financial performance. The next video lesson in this course will review the PortfolioAnalyst tool more in-depth.
Resources
Join The Conversation
If you have a general question, it may already be covered in our FAQs. If you have an account-specific question or concern, please reach out to Client Services.