Asset Classes

Free investment financial education

Language

Multilingual content from IBKR

Close Navigation
Learn more about IBKR accounts

Reporting Tools

Lesson 6 of 8
Duration 5:59
Level Beginner
Close Navigation

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

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.

4 thoughts on “Reporting Tools”

  • Martin Blais

    Is there a way to schedule a Flex report to be produced at regular intervals? e.g. monthly, or weekly?

  • Jameel Emamdee

    Good day
    I am trying to revert my margin trading account to a cash account. My equity plus cash are below the threshold required. Problem is that to revert to a cash account I have to convert all currencies to USD. After doing so there remains a few residual Canadian pennies that is not being removed from my account . I have tried repeatedly to change my account to cash but due to the residual Canadian pennies cannot do so.
    Please rectify as I cannot buy any shares only sell.

    • Interactive Brokers

      Hello, thank you for reaching out. You can view this FAQ for instructions to convert your account type from a Margin type account to a Cash type account: https://www.ibkr.com/faq?id=40340296

Leave a Reply

Disclosure: Interactive Brokers

The analysis in this material is provided for information only and is not and should not be construed as an offer to sell or the solicitation of an offer to buy any security. To the extent that this material discusses general market activity, industry or sector trends or other broad-based economic or political conditions, it should not be construed as research or investment advice. To the extent that it includes references to specific securities, commodities, currencies, or other instruments, those references do not constitute a recommendation by IBKR to buy, sell or hold such investments. This material does not and is not intended to take into account the particular financial conditions, investment objectives or requirements of individual customers. Before acting on this material, you should consider whether it is suitable for your particular circumstances and, as necessary, seek professional advice.

The views and opinions expressed herein are those of the author and do not necessarily reflect the views of Interactive Brokers, its affiliates, or its employees.

Disclosure: PortfolioAnalyst

The projections or other information generated by PortfolioAnalyst regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect actual investment results and are not guarantees of future results. Please note that results may vary with use of the tool over time.

Disclosure: Risk Navigator

The projections or other information generated by the Risk Navigator tool regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect actual investment results and are not guarantees of future results. Please note that results may vary with use of the tool over time.

Disclosure: Probability Lab

The projections or other information generated by the Probability Lab tool regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect actual investment results and are not guarantees of future results. Please note that results may vary with use of the tool over time.

Disclosure: Tax-Related Items (Circular 230 Notice)

The information in this material is provided for informational purposes only and does not constitute tax advice and cannot be used by the recipient or any other taxpayer to avoid penalties under any federal, state, local or other tax statutes or regulations, or to resolve any tax issue.

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.