Reporting Tools

Study Notes:

Interactive Brokers offers a full suite of robust reporting software for investors to pull standard statements, create custom reports, enable automatic statement delivery, and provides access to IBKR’s PortfolioAnalyst. 

To access the reporting features, select Performance & Reports along the top of the page. The investor can access Statements, Flex Queries, Tax documents, Other Reports, and PortfolioAnalyst.

Interactive Brokers’ Statements

The Statements page is where the investor can run default or custom reports at any time and configure automatic delivery of these reports. To generate any of the Default Statements, the investor can click the blue Run arrow and select the period, date, format, and language for the report. 

Interactive Brokers’ Custom Statements

The investor can create custom reports which can be edited, deleted, or run at any time. They can click the plus sign in the upper right corner of the Custom Statements panel to configure a new report. 

The investor 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. 

Interactive Brokers’ Statement Delivery

Both Default and Custom Statements can be enabled for automatic delivery to the investor. Automatic delivery can be configured by clicking the configure gear icon in the corner of the Statements Delivery box. 

Interactive Brokers’ Flex Queries

The Flex Queries page allows the investor to configure highly customized reports that are XML, CSV, or Text formatted statement files that let the investor specify the exact data fields and the order in which the fields appear on the report. A Flex Query is different from the Custom Statements because investors can customize a Flex Query at the field level, allowing them to include and exclude detailed field information. Customized Statements only allow the investor to include or exclude entire sections of the report instead of the individual data fields.

For example, the investor 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 investor can select the data columns to include in the report by checking the boxes to the left. The investor can also 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 investor 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.

Other Reports

Under the Performance & Reports menu, the Other Reports section contains Risk Reports that monitor risk and forecast portfolio performance using the Margin, Stress Test, and Value at Risk reports. There are also the three Supplemental reports:

1. Account Confirmation Letter is a digital letter that confirms the individual has an account with Interactive Brokers.
2. Tax Lot Holding Period Change report will show the tax lots changing from short-term to long-term in the selected time frame, and 
3. The Transaction Cost Analysis report tracks the quality of the investor’s orders’ transaction prices versus market conditions either at the time the orders were submitted or after the trade executes.

Interactive Brokers’ Tax Documents

Tax forms can be retrieved from the Performance & Reports menu by selecting Tax Documents. The investor will use the dropdown menu to select the tax year they wish to generate the tax form for. 

Investors are notified when the tax forms are ready and are typically available by the dates listed on our website.

Interactive Brokers’ PortfolioAnalyst

In addition to the reporting features reviewed thus far, investors have access to IBKR’s PortfolioAnalyst. PortfolioAnalyst is a powerful analytical tool housed within Client Portal that consolidates, tracks, and analyzes the investor’s complete financial performance. The PortfolioAnalyst reports can be used to compare the portfolio’s allocation and performance to over 300 benchmarks and they contain GIPS verified returns. If a standard benchmark does not provide an adequate basis for comparison, investors can also create custom benchmarks with multiple indexes or by weighting multiple ETFs. The investor can also link their external investment, checking, savings, annuity, incentive plan, and credit card accounts to understand their current financial state and plan for their future. 

For more information on the PortfolioAnalyst and its reporting capabilities, please see the dedicated Traders’ Academy course on PortfolioAnalyst

Resources:

Reporting Guide & Sample Reports

Tax Reports & Dates