|
|||
Statements & Reports
Activity Statements are generated on a daily, monthly, and yearly basis for all accounts. They are available in HTML format on our website under the Report Management section in Account Management. Our Activity Statements offer the following features:
- Expandable and contractible sections with click-down detail.
- Performances summary by asset class for a quick view of an account's profitability.
- Profit and loss across all transactions, positions, underlying instrument and asset class, under First In, First Out (FIFO), Last In, First Out (LIFO), Maximize Losses and Mark-to-Market (MTM) calculation methods.
- Details of change in position value for the statement period.
- Calculation of FX translation gains and losses for accounts with multiple currencies.
In addition to our standard Activity Statement, we offer customers the ability to create and save customized statement templates. These templates allow our customers to exclude information that may be irrelevant to them. Lastly, we offer a number of special download formats for integration with third-party applications.
You may opt to receive statements by email (unsecured) by choosing this option from the Email Statements menu item under Account Management. Click here to view our Statement Archive policy. Different trading products may have different trading cut-off hours for statement purposes. For most products, the trading hours cut-off coincides with exchange hours, but in some instances this might not be the case (e.g. CME equity and fixed income contracts have different cut-off hours). Daily statements are generally available by 05:00 ET, monthly statements 5 business days after the close of a month, and annual statements by January 31 under normal business circumstances.
- Please note that changes to the tax basis methodology apply to the current tax year 2009 and on. They do NOT affect 2008 tax calculations.
Margin reports show margin requirements for single and combination positions,
and display both available and excess liquidity. Each day at 16:15 ET we record
your margin and equity information across all asset classes and exchanges. Note
that because information on your statements is displayed "as of" the
cut-off time for each individual exchange, the information in your margin report
may be different from that displayed on your statements.
You can access your margin reports under the Margin Report menu item (Report Management) within Account Management. The Margin Report includes the following features:
- Expandable and contractible sections with click-down detail.
- Margin summary in base currency that shows equity with loan value, net
liquidation, and initial and maintenance margin requirements as of 16:15
ET.
- Margin detail for any open positions and FX trades sorted by currency.
- Margin Reports are available for the prior 90 days.
Please note that class breakdowns for Portfolio Margin accounts are not currently available.
Real-time trade confirmations are available under the Trade Confirmations menu item (Report Management) within Account Management/Statements for all executions for one prior year and from the start of the current year up through your most recent trades.
The trade confirmations are listed separately by asset class, then sorted by currency and action (bought or sold), as shown in the following sample Trade Confirmation report.

- Any stock or option symbols displayed are for illustrative purposes only and are not intended to portray a recommendation.
Our FlexQuery tool allows you to create multiple, customized report templates for Activity Statements and Trade Confirmations. Use the easy-to-follow design wizard to specify the exact fields you want to view in your report, the time period you want the report to cover, the order in which you want the fields to display, and the display format, TEXT or XML, in which you want to view your report.
You can create multiple templates with different fields for each statement.
All of your templates are stored in Account Management, and displayed for
selection from a drop-down list each time you run a report.
Report Outputs
Both format outputs can be exported to other applications for sorting and analysis. Customers with some programming knowledge may want to use the XML output format, and read the exported data into an XML reader or a customized programming application. Customers with less programming knowledge can choose the text format, and export their data into an text-friendly application such as Excel or Word.
Flex queries are first created and stored, and can then be run at any time through Account Management. If you wish to run your Flex query in an automated application without logging into Account Management, you may do this by using our FlexWeb Service utilizing an HTTPS protocol.
To start creating customized FlexStatements, log into Account
Management,
open the Report Management section, and chose Activity Flex and/or Trade
Confirms
Flex.
This report computes your Value at Risk (VAR) at 99, 99.5 and 100% confidence levels, using Principle Component Analysis. Because of the complexity of the calculations involved this report is completed overnight and is only available once a day. Those customers requiring real-time VAR should use the Risk Navigator in TWS which uses a simpler computation methodology. This report is based on account and, where applicable, subportfolios, and supports consolidated data for Advisor and Broker client accounts. Once generated from within Account Management, the Value at Risk Summary report displays in the web browser and contains expandable and collapsible sections.
To access the Value at Risk report, log into Account Management and go to Report Management. Below is an example of the VAR report.

All customer Activity Statements and Trade Confirmations are accessible from our secure Account Management server under Report Management. Customers who would also like to receive reports via email can specify delivery settings by logging into Account Management and selecting Delivery Settings under the Report Management menu. Please note that you will only be able to specify delivery settings for Activity Statement and/or Trade Confirmation Flex queries if you have created Flex statements.
You can also enable email or FTP delivery of daily and monthly activity statement customized templates. You must specify the Account ID, activity period (daily or monthly) and delivery format (HTML/WEB or PDF) when you create the customized template to see the templates on the Delivery Settings page in Account Management.
Simply check the box next to the statement(s) you would like to receive via email. Registration is immediate, and you will receive daily statements beginning the next business day, and monthly statements within the first week following the end of the month.
To change the Email Address of Record, go to the User Management/Email Address page in Account Management.
Activity and Trade Confirmations Flex query output can be encrypted by selecting the Encryption check box on the Delivery Settings page. This option is grayed out by default. To enable it and encrypt your Activity and/or Trade Confirmations Flex query output, contact your IB Sales Representative.
Note: FTP delivery for Flex statements is also available. Institutions requiring this service should contact their IB Sales Representative to set up this process.
For more information on how to use the Delivery Settings page, see the Delivery Settings topic in the Account Management Users' Guide.

PortfolioAnalyst allows investors to evaluate the performance of their IB portfolio based on a set of portfolio and measurement criteria that can be saved and run at any time. To use PortfolioAnalyst, you first create an analysis which contains the portfolio definitions and measures you wish to view, then save and run the analysis. You access PortfolioAnalyst from the Report Management menu in Account Management. Once you create and save analyses, you can run, edit or delete them. For complete instructions, see the PortfolioAnalyst topic in the Account Management Users' Guide.
PortfolioAnalyst includes two types of analyses:
- Time Series Charts
- Cumulative Performance Table
Time Series Charts
Time Series Charts let you analyze the monthly and quarterly performance of your entire portfolio or part of your portfolio based on specific asset classes or ticker symbols and using a set of predefined dollar- or percentage-based performance measures and range of dates. Results of analyses include data available from January 2008 to the present, and are displayed both as a color-coded chart and in table format.
When you create a Time Series Chart analysis, you define settings for several options, which are described below.
- Filter By Filter youre the data to analyze by account, asset classes, or symbol. If you are an Advisor or Broker Master, select one or more accounts to analyze, including master and client accounts. Choose to view results for multiple accounts as a consolidated set of results or separately for each account.Performance results for multiple asset classes and multiple symbols are consolidated across all selections.
- Measures - Select one or more of these performance measures:
- Market Value - Select this dollar value measure to view the closing value of selected assets, selected ticker symbols or the entire account at the end of each period in the analysis results.
- Cost Basis - Select this dollar value measure to view the original value of an asset for tax purposes (the purchase price). This value is used to determine the capital gain, which is equal to the difference between the asset's cost basis and the current market value.
- Mark-to-Market - Mark-to-market (MTM) is a method of valuing positions and determining profit and loss which is used by IB for TWS and statement reporting purposes. Under MTM, positions are valued in the Market Value section of the TWS Account Window based on the price they would currently realize in the open market. Positions are also valued using the MTM method for statement purposes and it is one of the methods by which profit or loss is computed. Select this dollar value measure to view Mark-to-Market values in the analysis results, which include corporate actions, commissions, dividends, interest and other fees. Interest and other fees are calculated for the entire account only; they are not included in analyses for selected assets or symbols. The value of an asset based on the price it would currently realize in the open market.
- Time-Weighted Return (TWR) TWR measures the percent return produced over time independent of contributions or withdrawals.TWR eliminates the impact of the timing of fund cash flows and isolates the portion of a portfolio's return that is attributable solely to the manager's actions. TWR is typically used for public fund managers because they normally do not control cash flowing into or out of their funds.
- Internal Rate of Return (IRR) IRR measures the discount rate that equates the cost of an investment with the cash generated by that investment. IRR accounts for the timing and magnitude of fund cash flows. IRR is typically used for private fund managers because they normally exercise a degree of control over the amount and timing of fund cash flows.
Select one of these percent-based performance measures:
- Benchmarks - Optionally, you can compare your performance results against one or more industry benchmarks.
- Frequency and Starting Date Select monthly or quarterly results, and the starting date of the period over which portfolio performance is to be analyzed. The period of analysis always ends at the current date (month-to-date, quarter-to-date). Analysis results include data available from January 2008 to the present.
The following image shows the results of a typical Time Series Chart analysis.

Cumulative Performance Table
Cumulative Performance Tables let you analyze the cumulative market value and cost basis of your entire portfolio based on specific asset classes or ticker symbols using a set of predefined percentage-based performance measures and an ending date. The results are displayed in a table and include percentage-based performance measures for the last one month, three months and life of the account from as early as January 2008 through the specified end date.
When you create a Cumulative Performance Table analysis, you define settings for several options, which are described below.
- Filter By Filter youre the data to analyze by account, asset classes, or symbol. If you are an Advisor or Broker Master, select one or more accounts to analyze, including master and client accounts. Choose to view results for multiple accounts as a consolidated set of results or separately for each account.Performance results for multiple asset classes and multiple symbols are consolidated across all selections.
- Measures - Select one of the following measures.
- Time-Weighted Return (TWR) TWR measures the percent return produced over time independent of contributions or withdrawals.TWR eliminates the impact of the timing of fund cash flows and isolates the portion of a portfolio's return that is attributable solely to the manager's actions. TWR is typically used for public fund managers because they normally do not control cash flowing into or out of their funds.
- Internal Rate of Return (IRR) IRR measures the discount rate that equates the cost of an investment with the cash generated by that investment. IRR accounts for the timing and magnitude of fund cash flows. IRR is typically used for private fund managers because they normally exercise a degree of control over the amount and timing of fund cash flows.
- Ending Date Select the month and year of the ending date for the analysis. Analysis results include data available from January 2008 to the specified ending date.
The following image shows the results of a typical Cumulative Performance Table analysis.

Please send your questions/feedback to portfolioanalyst@interactivebrokers.com.
Click on a date or topic in the table below to access the associated Release Notes.
Statements and Reports Release Notes:
November 9, 2009
- Value at Risk Summary Reports Updated
- Broker Revenue and Expense Summary Report Added
- Activity Statements and Flex Queries: Changes to Stock Borrow Data
- Activity Statements and Flex Queries: Withdrawal Fees
- Activity Flex and Trade Confirms Flex Query Trades Sections
- Data in Flex Queries Now Presented in Raw Form
- Trade Confirmation Reports and Flex Queries Show Forex Commissions in Base Currency
Statements and Reports Release Notes
Note: Any symbols displayed are for illustrative purposes only and do not portray a recommendation.
PortfolioCenter is a product of Schwab Performance Technologies, a subsidiary of The Charles Schwab Corporation.

The Account Information summarizes the account name, account alias, account number, account type (i.e. Individual, Advisor Master, Broker Consolidated, etc.), customer type (i.e. individual, partnership, etc.), account capabilities (cash or margin), trading permissions (i.e. stock, options, etc.) and the base currency of the account (AUD, CAD, CHF, EUR, GBP, HKD, JPY and USD).

The equity summary shows all positions by asset class (stock, securities options, warrants and bonds), cash, and accruals for the current and prior period. Current totals are split between long and short amounts. Customers can click on the current or prior period amounts for further details on how the balances are derived. All non-base currency amounts are converted to the base currency at the close of period rate. Please note that there are no open futures positions, as the gain or loss for futures contracts settles into cash each night.
This section displays a bar chart time series of a long and short equity balances by asset class in an accounts base currency. Daily statements show the opening and closing balances, monthly statements a bar for each trading day of the month, and yearly statements a bar for each trading day of the year.
When printing the Equity Value Time Series in HTML format, please ensure your browser is configured to print background colors and images.
Firefox
1. Click menu item: File > Page Setup
2. Ensure "Print Background (colors & images)" is enabled
3. Click "OK"
Internet Explorer
1. Click menu item: Tools > Internet Options
2. Click on the "Advanced" tab
3. Scroll down to "Printing" settings
4. Ensure "Print background colors and images" is enabled
5. Click "Apply"
The MTM Performance Summary shows profit and loss (P&L) by underlying and asset class. It also shows the internal rate of return for the statement period. To compute the Time Weighted Rate of Return we use a time-weighted average calculation method. This takes initial investment and cash flows, weighting each cash flow for its time period, and computes a return rate for the statement period. For an example of how this figure is calculated, see Time-Weighted Method#3: The Microsoft Excel way. This table does include Bonds, Bills, and Notes but not Forex. Users that hold those positions should have that in mind when looking at the Total P&L and Internal Rate of Return.
MTM P&L shows how much profit or loss was made over the statement period,
regardless of whether positions are open or closed. There is no concept of
matching opening and closing transactions under this methodology. MTM calculations
assume all open positions and transactions are settled at the end of each day
and new positions are opened the next day. MTM calculations are split for purposes
of simplification: calculations for transactions during the statement period,
and calculations for positions open at the beginning of any day. As an example,
assume the following:

Reported on MTM Statement

The Realized and Unrealized Performance Summary in Base shows Profit & Loss by underlying and asset class. An alternative to the MTM profit and loss calculations are calculations where closing transactions are matched to opening transactions and a profit or loss is realized when a position is closed. Open positions are marked-to-market and the resulting profit or loss is unrealized. To determine the realized profit or loss an assumption needs to be made as to which opening transaction should match the closing transaction. There are a number of methods for determining this: First In, First Out (FIFO), Last In, First Out (LIFO), Average Cost, and Specific Lot. For our realized and unrealized profit and loss statement calculations we utilize FIFO, LIFO or Maximize Losses, which ensures that your losses are maximized for tax purposes by matching the closing trade to the opening position that will produce the greatest dollar loss. FIFO is the most common accounting method.
Using the assumption from the MTM examples above, the daily Realized statements would look as follows:

Reported on Realized Statement
Because all positions in the example were closed, the Total Realized Gain is equal to the Grand Total MTM Gain. To simplify tax reporting the realized category splits gains and losses, as well as long term and short (long term is for positions held a year and a day, and short term everything else), into separate categories. The unrealized category splits gains and losses into separate categories.
It should be noted that commissions are not netted for MTM calculations and are included as a separate line in the MTM Performance Summary. For FIFO, LIFO or Maximize Losses, commissions are netted from the cost basis and sales proceeds to determine the realized and unrealized P+L.
Month & Year to Date Performance Summary in Base displays MTD and YTD totals by underlying in base currency. It includes MTM, Realized Short Term and Realized Long Term
The Cash Report section details how each period's cash balance changes from beginning to end. For statements with multiple currencies, all currencies are detailed and then totaled in the Base Currency Summary section. Because FX translation rates change from period to period, there will be differences in the translated base currency balances. This difference is reflected in the Cash FX Translation Gain/Loss line.
Starting and Ending Cash lines represents trade date balances. We also show settlement date balances representing cash that has been received from a clearing organization (i.e. if you sell stock today you will not receive the proceeds for three days). Interest is calculated based upon settlement balances (adjusted settled balances in the event an account holds short stock positions), accrued during the month and paid after the close of the month. For a complete explanation of how interest is calculated, see our IB Interest Calculation Method page.
Three lines that merit further explanation in the Cash Report are Cash Settling MTM, Net Trades (Sales) and Net Trades (Purchase).
Cash Settling MTM shows mark-to-market gains and losses for Futures and CFDs, as well as Options that settle into cash.
Net Trades (Sales) is made up of the following components:
- Proceeds from Stocks, Options, Bonds, T-bills and Forex.
- Cash received from Corporate Actions.
and Net Trades (Purchases) contains the following:
- Purchases for Stocks, Options, Bonds, T-bills and Forex.
- Cash paid due to Corporate Actions.
This section is a ledger that displays all cash-related transactions for the given statement time period. It displays the open and closing cash balances and all cash activity (credits and debits) that occurred as single line items.

The soft payments show how much has been paid to your soft dollar vendors. This information will display only if you are participating in IB's Soft Dollar Program. For more information about soft dollars, see the IB Soft Dollars Commission Program highlights.
The change in position value section explains the changes in your position from the beginning of the period to the end of the period. This section is broken down by asset class and currency, but the Base Currency per asset class will always be displayed at the top of the section. Changes in position value are due to transactions, changes in market prices, and with multiple currencies translation gains and losses to the base currency. Details for these changes can be found in the Equity Summary in Base section, MTM Performance Summary section, Futures Price Adjustments section, and Corporate Actions section.
This section shows all long open positions, Cost Basis by lot, the FIFO, LIFO or Maximize Loss Unrealized Profit or Loss, and the Percentage of Equity. Positions are segregated by asset type, currency and symbol. The Cost Basis, Closing value, and Unrealized PNL for positions in a non-base currency are also translated to the base currency using the exchange rates that were in effect on the day of the opening transaction. The Unrealized Profit or Loss calculated in this section will be used in the MTM Performance Summary section above. This section also summarizes totals in your base currency at the asset level and displays this as a new total line.
To see more detail for an underlying, click the plus sign (+) next to the ticker symbol to display all data.
This section shows all short open positions, Cost Basis by lot, the Unrealized Profit or Loss, and the Percentage of Equity. Positions are segregated by asset type, currency and symbol. The Cost Basis, Closing value, and Unrealized PNL for positions in a non-base currency are also translated to the base currency using the exchange rates that were in effect on the day of the opening transaction. The Unrealized Profit or Loss calculated in this section will be used in the MTM Performance Summary section above. This section also summarizes totals in your base currency at the asset level and displays this as a new total line.
To see more detail for an underlying, click the plus sign (+) next to the ticker symbol to display all data.
The trades section shows all trades, segregated by asset type and currency. Realized and MTM profit and loss is shown for all realized (closed) trades. For the purpose of cost basis and Realized profit or loss, commissions are netted. For MTM profit or loss, commissions are not netted and are included as a separate line in the MTM Performance Summary above.
Lot detail for closing positions, if applicable, will be signified with a plus sign (+) next to the symbol which can be expanded.
Note: IB offers three ways to declare your Tax Basis (FIFO, LIFO and Maximize Losses). For more information please visit Tax Basis page in Account Management Users Guide.
Your total Unbundled Commission Details will include IB unbundled, exchange, clearing and regulatory fees. This section is available in daily statements only.
Institutional customers with IBPrime Services will have an Incoming Trade Transfers section which details the trades that have been executed away with a third-party broker and are coming in to IB for clearing and custody. The trades are sorted by asset class and date.
Institutional customers with IBExecution Services will have an Outgoing Trade Transfers section which details the trades that have been executed at IB and are given-up to to third-party brokers for clearing. The destination of the trade is listed in the Instruction field. Give-up trades will also appear in the Transactions section.
This section shows any price adjustments that were made to your account based on actual execution prices of your futures. Each adjustment transaction includes the trade date, underlying symbol, and amount.
This section shows any price adjustments that were made to your account based on actual execution prices. Each adjustment transaction includes the trade date, quantity, price and trade amount for both the original and the adjusted trade.
This section shows any Commission adjustments that were made to your account based on actual commission charges
Institutional customers with IBExecution or IBPrime Services will have an Unsettled Transfer section which details DVP, NSCC, CMTA, and GUS trade give-ups into and out of our broker. For give-up transactions the trade will appear from the day of trade until the day of settlement broken into trade date sections and sorted by the stage of the give-up process. Give-up trades will also appear in the Transaction section on the trade date as a trade, and will be removed from the Transaction section on the settlement date as a transfer. Take-up trades appear from the day of notification until the day of settlement. They will also appear in the Transaction section on the date of trade notification. Give-up and Take-up trades appear together and are differentiated by a To (Give-up) or a From (Take-up) indicator in the Direction column.
Institutional customers with IBExecution services that pre-trade allocate options trades will have an Unbooked Transactions section. This section will detail options and Single Stock Futures trades that are immediately given up to a third-party broker and that are not booked into your account before being given-up. This section is for informational purposes only.
As discussed in the MTM Performance Summary section above, MTM profit and loss is calculated in two components: MTM gains from transactions during the statement period and MTM gains or losses for positions that are carried into a new trading day. The following example will illustrate this:

This section is segregated by asset class and currency. Prior MTM profit or loss not in the base currency is translated to the base currency at the exchange rate in effect on the day of the prior period calculation.
To see more detail for an underlying, click the plus sign (+) next to the ticker symbol to display all data.
The Withholding Tax section shows any required tax withholdings. In rare cases, local tax authorities will require us to withhold taxes.
A broad-based Transaction Tax is triggered by various types of transactions and is imposed either as a percentage of a transactions full value, or as a flat fee.
The Corporate Actions section is sorted by asset class and currency.
The Dividends section lists all dividend payments by currency. Each currency total is also displayed in your base currency. In addition, each line shows the price per share, the applicable currency and the income type (for example, Ordinary Dividend).
Advisors and Brokers who charge fees to their clients will have a Client Fees section on the master account statement. Commission or wrap fee revenues from the client are reflected in the Revenue column, and commission expenses paid to IB for execution and clearing services are reflected in the Expense column. The net is the profit made by the advisor or broker.
The Client Fees section is summarized by account. Advisors and Brokers can view expenses and revenues for each account on a separate line in the statement. In HTML/WEB-formatted daily statements, each account is expandable and collapsible. In HTML/WEB- or PDF-formatted monthly and annual statements, only the summaries are displayed. This section is segregated by currency and ties to the Performance Summary and the Cash Summary. Fees in a non-base currency are translated to the base currency using the conversion rate in effect on the day of the fee.
The Other Fees section details miscellaneous charges, is sorted by currency, translated to the base currency in effect on the day of the fee, and tied to the Performance Summary as well as the Cash Summary.
The option cash settlements section shows the details of your index options that settle in cash.
Customers that hold IBGNotes will have an IBGNotes section in their statement. This section shows the Date the notes were purchased or sold, a Description of the action taken, the Amount, as well as the Commissions that the holder of the notes has received for the statement period.
The Deposits/Withdrawals table shows all cash transactions into and out of your account.

If you buy a dividend paying stock on margin and we lend that stock, you don't receive dividends but instead receive a payment in lieu of dividends. This is treated as ordinary income.

Interest is paid and charged once a month after each month's close. We accrue interest daily during the month. When interest is actually posted to the account, the daily accruals are reversed. Interest accruals are presented for each currency held and are translated to the base currency using the conversion rates in effect at the time of the transaction. Interest accruals are a balance sheet item and reflected in the Equity Summary at the top of the statement.

This section shows the amount of interest paid on long cash balances. It is only available for daily statements and statements that cover a range dates and is enabled by request.

This section shows the amount of interest charged on cash balances. It is only available for daily statements and statements that cover a range dates and is enabled by request.

This section shows the amount of interest paid on short sale proceeds cash balances. It is only available for daily statements and statements that cover a range dates and is enabled by request.

Interactive Brokers makes an extensive list of stocks available for shorting. Customers who short stock pay a fee expressed as a reduced interest on the sale proceeds. For more information about shorting stocks, see the Shortable Stocks page.
This section of the Activity Statement displays daily shorted stocks and the associated borrow rates and fees. It is enabled by request.

This section shows all open borrow contracts for Portfolio Margin customers with Stock Borrow/Loan activity on the AQS® stock loan and borrow marketplace. Data includes the symbol, exchange, quantity, fee rate % and collateral amount and is sorted by currency.

This section shows all borrow activity for Portfolio Margin customers with Stock Borrow/Loan activity on the AQS® stock loan and borrow marketplace. Data includes the symbol, date, description, exchange, quantity, fee rate % and collateral amount and is sorted by currency.

This section shows details of direct borrow fees for Portfolio Margin customers with Stock Borrow/Loan activity on the AQS® stock loan and borrow marketplace. Data includes the value date, symbol, exchange, start date, quantity, collateral amount, fees and charges and is sorted by currency.
This section displays the change in dividend accruals for the period. At the top of the section is the Starting Dividend Accruals in Base Currency, followed by a list of accrued dividends sorted by currency and underlying symbol. At the bottom of this section is the Ending Dividend Accruals in Base Currency. The postings (with code Po) are done for new accrual additions to the account. The reversals (with code Re) are done for the following three reasons: correction in dividend accruals, cancellation in dividend accrual, and reversal due to payout in cash. Dividend Accruals are a balance sheet item and reflected in the Equity Summary in Base Currency at the top of the statement.
This section displays all the open dividend accruals that will be paid out on the Pay Date. The dividends are listed by currency and underlying symbol.
This is the interest that is actually paid after the close of the month. Interest that has been accrued during the month is backed out of the Interest Accruals section at the time of recognition of interest paid. This section is sorted by currency, translated to the base currency, and tie to the Mark-to-Market Performance Summary as well as the Cash Report.
This is the interest that is actually received after the close of the month. Interest that has been accrued during the month is backed out of the Interest Accruals section at the time of recognition of interest received. This section is sorted by currency, translated to the base currency, and tie to the Mark-to-Market Performance Summary as well as the Cash Report.
Bond interest is paid on a coupon date and reflects interest paid during the coupon period. If you purchase a bond in the middle of a coupon period, you will owe the previous owner of the bond interest for the period in which you do not own the bond. Bond Interest Paid reflects the amount paid to the previous owner of the bond. The total number in this section is backed out of the Dividends column in the MTM Performance Summary section at the time of recognition of interest paid. This section also ties to the Cash Report section.
Bond interest is paid on a coupon date and reflects interest paid during the coupon period. If you sell a bond in the middle of a coupon period, the new owner of the bond will owe you interest for the period you owned the bond. The total number in this section is backed out of the Dividends column in the MTM Performance Summary section at the time of recognition of interest received. This section also ties to the Cash Report section.
This section displays the segregated quantity for long stock positions. This section only will appear in monthly statements for IB-CA accounts
This section gives an overview of the exchange rates versus base currency for the report period.
Position transfer to or from another broker will be reflected in the Account/Brokerage Transfers section. Common securities transfer systems include ACATs in the U.S. and ATONs in Canada.
This section displays the security ID for stocks and bond as well as expiry and other identifying information for options and futures and is organized by asset class.

Customized Statement Templates
To ensure that your Activity Statement presents the data that is most important to you, we provide several ways to view your statement through Account Management. To see all of your activity over a year, a month, or a date-range of weeks/days, select Full Default from the Template list. The Full Default is the complete statement and includes all information. It is the only template that supports Yearly Period. To see a simpler monthly or daily view that includes details (but excludes Mark-to-Market Performance Summary and P&L, Change in Position Value, and MTM P&L on Prior Period Positions), select Simple Default from the Template list.

Use the four selection areas to define exactly what you want to see. First select a template, then specify:
- The Account (or accounts) whose activity you want to view.
- The Time Period, defined by start and end dates, over which the report should run.
- The display Format in which you want to view your statement.
For example, you might elect Simple Default as the template for your personal Account, choose Daily and Last Business Day as the time period, and specify HTML as the display format. Account Management then compiles the specified data for the defined time period, and opens a new browser window with your requested report. If you would like to view activity for a different date, simply re-select the time period, click View, and see your revised report immediately. Multiple account managers who want to create a consolidated statement for two or more accounts can press and hold the Shift key to select multiple accounts.
To customize your statement even further, use the Create and Edit Templates section of the page. This feature allows you to specify the sections, amount
of detail and P&L format you prefer, and save your layout as a named report
template, which displays in the Template list along with the Full Default and
Simple Default templates. You can create as many custom templates as you wish,
and view your activity using any of these templates at any time. You can also specify delivery settings for the template, including Account ID, period of activity (daily or monthly) and delivery format (HTML/WEB or PDF), then enable email or FTP delivery of the customized template on the Delivery Settings page in Account Management.

Activity Downloads
We provide the ability to download your Activity Statements into the following software:
In addition to the above download solutions, a number of other third-party providers offer portfolio management and tax reporting packages that integrate with our HTML downloads. Please contact the provider for further detail.
| Step 1: | If you do not already have an IB Investment account in Quicken or Money, please create one and manually load your current positions. Enable the account for Online Access. |
| Step 2: | Log in to Account Management through our Home Page and choose Activity Downloads (Report Management). |
| Step 3: | Select accounts, dates and a format (Tradelog, Quicken or MS Money) and click the View/Download button. |
| Step 4: | Map the download to your IB Investment Account. |
| Step 5: | Go to the IB Investment Account within Tradelog, Quicken or Money and accept the transactions. |
For complete instructions how to import your statement to Tradelog, please visit http://www.armencomp.com/tradelog/interactive_brokers.shtml.
Intuit and Money do not support multiple currencies at this time.
| Step 1: | Log in to Account Management section of the web site and choose the Activity Statements menu item (Report Management). |
| Step 2: | Choose accounts, dates and a format of HTML/Web, and click the View/Download button. |
| Step 3: | Once the complete statement has loaded in the page, go to the File menu of your browser and choose Save As. This will prompt you to save the file locally on your computer. |
| Step 4: | Enter a file name and choose a location to save your statement. |
| Step 5: | Upload the saved HTML file into MS Excel or MS Word. |
Downloading to Captools
| If you would like to import your IB statement into Captools Professional please visit http://www.captools.net/ to see the latest import instructions. (Please note that you will need the Captools Broker/Dealer Interface from Captools before you can follow the steps mentioned below. Contact Captools at http://www.captools.net/ for the interface details.): |
| Log into Account Management and choose Tax Forms (Report Management). Select TurboTax TXF Format from the drop down menu and click View Report. Please note that the TXF import is only available on the TurboTax desktop product. |
Activity Statement Availability by Account Type
| Individuals | One statement for each Individual Account. |
| Advisors | Clients can access their statements electronically. Advisors can view statements for their advisor accounts, client accounts, and a consolidated statement including some or all accounts. |
| Mutual and Hedge Funds | Investment Managers can view statements for their master account, fund accounts, and a consolidated statement including some or all accounts. |
| Trading Groups | Supervisory Users can view statements for the master account, sub accounts if applicable, and a consolidated statement including some or all accounts. Sub users can view statements for their sub accounts. |
| Fully and Non-Disclosed Broker | Clients can access their statements electronically. Brokers can view statements for the master account, client accounts, and a consolidated statement including some or all accounts. |
| Omnibus Brokers | Statements will be provided for the long, short, master, and consolidated accounts. |
| Financial Advisor (Client) | 1.37MB | |
| Financial Advisor (Master Consolidated) | 578KB | |
| Friends & Family (Consolidated) | 132KB | |
| Fund Advisor (Consolidated) | 525KB | |
| Hedge Fund (Master) | 72KB | |
| IB Execution | 717KB | |
| IBPrime | 193KB | |
| I Broker (Consolidated) | 1.69MB | |
| Individual | 138KB | |
| Pool Master | 389KB | |
| Single Hedge Fund | 111KB | |
| SLT Master (Consolidated) | 285KB |
The Account Information section summarizes the account name, account number, account type (i.e. Individual, Advisor Master, Broker Consolidated, etc.), customer type (i.e. individual, partnership, etc.), account capabilities (cash or margin), trading permissions (i.e. stock, options, etc.) and the base currency of the account (AUD, CAD, CHF, EUR, GBP, HKD, JPY and USD).
The Margin Summary section breaks out security and commodity amounts for Equity with Loan Value, Net Liquidation Value and current Initial and Maintenance margin requirements. The values are calculated as follows:
| Securities Account |
Commodities Account |
Total | |
| Equity with Loan Value | Total cash value + stock & bond value + interest payable/receivable | Total cash value + commodities option value |
Sum of both columns |
| Net Liquidation Value | Total cash value + stock & bond value + securities options value + interest payable/receivable |
Total cash value + commodities options value |
Sum of both columns |
| Initial Margin | Initial margin requirement (in base currency) |
Initial margin requirement (in base currency) | Sum of both columns |
| Available Funds | Equity with Loan Value - Initial Margin |
Net Liquidation - Initial Margin |
Sum of both columns |
| Maintenance Margin | Maintenance margin requirement (in base currency) |
Maintenance margin requirement (in base currency) |
Sum of both columns |
| Excess Liquidity | Equity with Loan Value - Maintenance Margin |
Net Liquidation - Maintenance Margin |
Sum of both columns |
All non-base currency amounts are converted to the base currency. For more details on these calculations, refer to the Account Information Window topic in the TWS Users' Guide. For more information on how initial and maintenance margin values are calculated, see the Margin Overview page on the IB website.
The Margin Detail section shows the quantity, price, initial and maintenance margin requirements for each open position, sorted by currency. At the end of the detail report, one total line is displayed for each currency in which you hold a position, along with the total in your base currency. In addition, margin for FX trades is broken out onto separate lines as shown below.
The Portfolio Margin Details section includes the Base Currency Summary, which displays the total for each group level as the maximum value between the Margin and Extreme values for each Group item (Portfolio, Product, Class). This section also includes detailed sections for each group level (Portfolio, Product, Class), showing offset, quantity, margin and extreme values for each open position, sorted by currency.
This table provides an aggregate margin overview by exchange, for all assets that are margined by Standardized Portfolio Analysis of Risk (SPAN) only. The Initial and Maintenance values show the total of all margin from all account segments, i.e. security, commodity etc, in the currency of the exchange. For your convenience, totals are also displayed in base currency.
| Individuals | One report for each Individual Account. |
| Advisors | Advisor clients may access statements electronically with their Username and Password. Advisors may also access their client's statements through Account Management, print them, and send them to the client. |
| Institutions | Only a consolidated statement is available for the master account. |
| Fully and Non-Disclosed Broker | Clients access their statements electronically. Brokers can view statements for the master account and client accounts. |
| Omnibus Brokers | Only a consolidated statement is available for the master account. |
Activity Flex Configuration Details
This section gives you the ability to name your report and choose your output format, either text or XML. Customers with some programming knowledge may want to choose the XML format, and then read exported data into an XML reader or a customized programming application.
Customers with less programming knowledge may want to choose the text format, and export their data into a text-friendly application such as Excel or Word. In addition, clients need to select their preferred delimiter or separator, such as the comma, pipe or tab. The delimiter tells the receiving application how to separate pieces of information.
Example: If you want to make the report readable in Excel, choose the Text Format, and depending upon your preference, select the comma, pipe or tab as the delimiter. If you manage several accounts and want to include more than one account in the report, you have two options.
- Select ALL to include all sub accounts as separate sections, in a format similar to selecting multiple accounts. The report will then include multiple Beginning of File/End of File (BOF/EOF) tags.
- Select CONSOLIDATED to include all sub accounts in a merged format. The report will then include a single Beginning of File/End of File (BOF/EOF) tag.

These options are useful for machine readable files (i.e., files that are processed by a program rather than opened up in a Excel for viewing). For a detailed explanation about Text Output options, please click the three sections below called Include Header and Trailer Records, Include Column Headers and Include Section Code and Line Descriptor
When enabling header and trailer records, there will be the following rows added to your report:
- Begin of file row (for each account ID in report)
- End of file row (for each account ID in report)
- Begin of section row (for each section in report)
- End of section row (for each section in report)
Row layouts:
| Begin of file row: | |
| Column 1: | "BOF" |
| Column 2: | Account ID |
| Column 3: | Number of sections contained in the report (i.e. if your flex is for Account Information and Equity Summary, this will have 2) |
| Column 4: | Report from date |
| Column 5: | Report to date |
| Column 6: | Report generation date and time (i.e., 20071106;110031 is November 6, 2007 11:00:31 AM ) |
| Column 7: | Report engine build number (currently defaulted to 100) |
| Column 8: | Statement engine build number (currently defaulted to 100) |
| End of file row: | |
| Column 1: | "EOF" |
| Column 2: | Account ID |
| Begin of section row : | |
| Column 1: | Section code (See list below) |
| Column 2: | "BOS" (Line descriptor) |
| Column 3: | Section description |
| End of section row : | |
| Column 1: | Section code (See list below) |
| Column 2: | "EOS" (Line descriptor) |
| Column 3: | Record checksum (i.e., Number of records in section) |
| Column 4: | Amount checksum (Varies based on section: Transactions uses NetTradeMoney, Positions uses PositionValue, others default to 0) |
When enabled, the Section code and Line descriptor columns will prefix your selected fields. Section codes are 4 characters. The possible section codes are as follows:
| Section Codes: | |
| ACCT | Account Information |
| EQUT | Equity Summary; trade date basis |
| EQUS | Equity Summary; settlement date basis |
| FIFO | FIFO Performance Summary in Base |
| MTMP | (MTM Performance Summary in Base) |
| PLUI | Profit and Loss by Underlying Instruments |
| CRTT | Cash Report; trade date basis |
| CRTS | Cash Report; settlement date basis |
| CPOV | Change in Position Values |
| POST | Positions; trade date basis |
| POSS | Positions; settlement date basis |
| TRNT | Transaction Activity; trade date basis |
| TRNS | Transaction Activity; settlement date basis |
| USTR | Unsettled Transfers |
| UBTR | Unbooked Transactions |
| ADJU | Adjustments |
| PPPO | Prior Period Positions |
| CORP | Corporate Actions |
| TRFR | Transfers |
| RATE | Conversion Rates |
| CDIV | Change in Dividend Accruals |
| ODIV | Open Dividend Accruals |
| CFDC | CFD Charges |
| TIER | Tier Interest Details |
| HTOB | Hard to Borrow Details |
| DVPT | Incoming/Outgoing Trade Transfers |
| UNBC | Unbundled Commission Details |
| IBGN | IBG Notes |
| CTRN | Cash Transactions |
The possible line descriptors are:
| Line Descriptors: | |
| BOS | Begin of section row |
| HEADER | Header row (i.e. column headers, the fields enabled for the report) |
| DATA | Data row |
| EOS | End of section row |
Include Column Headers Detail
If you select Include Column Headers, the data will populate with
the appropriate headers.
Date Configuration Section
Define the time period your report will cover. Choose from a specific period (i.e. last business day) or define a range using a starting and ending date.

How to Include and Set the Order for Fields in your Report General Overview
Use the Fields Available list to add the desired data fields to your customized report. Select a field and then click the right-pointing green arrow to move the available field into the Fields Included list.
To remove a field from your report, select the field in the Fields
Included list, and click the left pointing arrow to put it back into the Fields
Available list.
The field in the Included list will display on your report in the order in
which they are listed, descending from top to bottom. You can change the
order of these fields by selecting a field and using either the UP or DOWN
arrow
below the list to move the field.

Below is a list of all configurable report sections and the fields available within each.
For definitions of the specific fields in each section, see the Activity Statement Explanation by Section
- Account ID
- Currency
- Name
- Account Alias
- Account Type (Individual, Institutional, Advisor)
- Customer Type
- Account Capabilities (Cash, Reg T Margin or Portfolio Margin)
- Trading Permissions (Stock, Options, Futures etc)
- Account ID
- Report Date
- Cash
- Stock
- Options
- Bonds
- Notes
- Interest Accruals
- Soft Dollars
- Dividend Accruals
- Total
- Account ID
- Asset Class
- Symbol
- Description
- Conid
- Previous Close Quantity
- Previous Close Price
- Close Quantity
- Close Price
- Transaction MTM Profit and Loss
- Prior Open MTM Profit and Loss
- Corporate Actions MTM Profit and Loss
- Commissions
- Dividends
- Total
- Asset Class
- Symbol
- Description
- Conid
- Realized Short Term Profit
- Realized Short Term Loss
- Realized Long Term Profit
- Realized Long Term Loss
- Total Realized Profit and Loss
- Unrealized Profit
- Unrealized Loss
- Total Unrealized Profit and Loss
- Total FIFO Profit and Loss
- Account ID
- Description
- Data
- Debit
- Credit
- Balance
- Asset Class
- Symbol
- Description
- Mark-to-market MTD
- Mark-to-market YTD
- Realized S/T MTD
- Realized S/T YTD
- Realized L/T MTD
- Realized L/T YTD
- Account ID
- Currency
- From Date
- To Date
- Starting Cash
- Client Fees
- Commissions (for advisors/brokers this also includes fees per trade unit)
- Billable Commissions
- Deposit/Withdrawals
- Account Transfers
- Internal Transfers
- Dividends
- Broker Interest Paid and Received
- Bond Interest Paid and Received
- Cash Settling MTM
- CFD Charges
- Net Trades Sales
- Net Trades Purchases
- Other Fees
- Payment in Lieu
- Transaction Tax
- Withholding Tax (IRS or other tax authority directs us to withhold for a customer)
- FX Translation Gain/Loss
- Ending Cash (starting cash plus all the change in cash described above. This balance reflects cash from completed transactions and does not include cash which has not yet been settled by the clearing house).
- Ending Settled Cash (the actual delivered or received cash from a clearing house to IB. For US stocks it takes 3 business days to settle, and for US options 1 business day to settle).
- Avg Credit Balance
- Avg Debit Balance
- Currency
- Asset Class
- Prior Period Value
- Transactions
- MTM Prior Period Positions Profit and Loss
- MTM Transactions Profit and Loss
- Corporate Actions
- Account Transfers
- FX Translation Profit and Loss
- Future Price Adjustments
- Settled Cash
- End of Period Value
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Report Date
- Security ID
- Cusip #
- ISIN #
- SEDOL #
- Quantity
- Multiplier
- Mark Price
- Position Value
- Open Price
- Cost Basis Price
- Cost Basis Money
- FIFO Unrealized Profit and Loss
- ConID
- Side
- Level of Detail
- Open Date Time
In this section you have the ability to view the trades by Order, Execution and /or Closed Lots level of detail, with Executions being the default. You can select one or more levels of details, which allows you to differentiate between Order, Execution and Closed lots data lines in your statement.
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Trade ID
- Report Date
- Trade Date
- Trade Time
- Settle Date Target
- Transaction Type (Exchange Trade, Book Trade, Trade Correct, Trade Cancel, Frac Share, Frac Share Cancel)
- Security ID
- Cusip #
- ISIN #
- SEDOL #
- Exchange
- Quantity
- Trade Price
- Multiplier
- Trade Money
- Taxes
- IB Commission
- IB Commission Currency
- Close Price
- Open/Close Indicator
- Notes/Codes
- Cost Basis
- FIFO Realized Profit and Loss
- MTM Profit and Loss
- ConID
- IB Order ID
- Exchange Order ID
- Order Time
- Original Trade Price
- Original Trade Date
- Original Trade ID
- Original Order ID
- Level of Detail
- Change in Price
- Change in Quantity
- Net Cash
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Trade ID
- Report Date
- Trade Date
- Trade Time
- Settle Date Target
- Transaction Type
- Security ID
- Cusip #
- ISIN #
- SEDOL #
- Exchange
- Quantity
- Trade Price
- Multiplier
- Trade Money
- Taxes
- IB Commission
- IB Commission Currency
- Close Price
- Open/Close Indicator
- Notes/Codes
- Cost Basis
- FIFO Realized Profit and Loss
- MTM PNL
- Broker Name
- Broker Account
- Away Broker Commission
- Regulatory Fee
- Direction
- Delivered/Received
- Net Trade Money
- Net Trade Money in Base
- Net Trade Price
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Stage (Pending, Received, Confirmed, Transmitted)
- Trade Date
- Target Settlement
- Direction (To or From)
- Instruction Name
- Quantity
- Trade Price
- Trade Amount
- Trade Amount in Base
- Cusip #
- ISIN #
- Transaction ID
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date/Time
- Settle Date
- Exchange
- Broker Name
- Broker Account
- Quantity
- Trade Price
- Trade Amount
- Trade Amount in Base
- Commission
- Commission in Base
- Tax
- Cusip #
- ISIN #
- Transaction ID
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date/Time
- Quantity
- Total Commission
- Broker Execution Charge
- Broker Clearing Charge
- Third Party Exchange Charge
- Third Party Clearing Charge
- Third Party Regulatory Charge
- ConID
- Security ID
- Trade ID
- Account ID
- Currency
- Asset Cass
- Symbol
- Description
- Orig Date
- Adjust Date
- Quantity
- Multiplier
- Orig Price
- Adjust Price
- Orig Amount
- Adjust Amount
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date
- Price
- Prior MTM Profit and Loss
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date/Time
- Amount
- Quantity
- FIFO Realized Profit and Loss
- MTM Profit and Loss
- Account ID
- Currency
- Description
- Date
- Revenue
- Expense
- Net Revenue
- Trade ID
- Account ID
- Currency
- Asset Class
- Symbol
- Date
- Type
- Direction (To or From)
- Account
- Cash Transfer
- Quantity
- Transfer Price
- Position Amount
- Position Amount in Base
- Account ID
- Currency
- Symbol
- Description
- Date/Time
- Amount
- Type (Withholding Tax,Dividends,Payment In Lieu Of Dividends,Other Fees,Deposits & Withdrawals,Broker Interest Paid,Broker Interest Received,Bond Interest Paid,Bond Interest Received,Futures Price Adjustments,Commission Adjustments)
- Security ID
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date
- Received
- Paid
- Total
- ConID
- Transaction ID
- Account ID
- Currency
- Asset Class
- Description
- Date/Time
- Amount
- Commissions
- Account ID
- Currency
- Interest Type
- Value Date
- Tier Break
- Balance Threshold
- Securities Principal
- Commodities Principal
- Rate
- Securities Interest
- Commodities Interest
- Total Interest
- Code
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Value Date
- Quantity
- Price
- Value
- Borrow Fee Rate
- Borrow Fee
- Code
- Security ID
- Currency
- Asset Class
- Symbol
- Type
- SLB Position ID
- Exchange
- Quantity
- Fee Rate %
- Collateral Amount
- Currency
- Asset Class
- Symbol
- Description
- Date
- SLB Position ID
- Type
- Exchange
- Quantity
- Fee Rate %
- Collateral Amount
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date
- Ex Date
- Pay Date
- Quantity
- Tax
- Fee
- Gross Rate
- Net Amount
- Code
- Account ID
- Currency
- Asset Class
- Symbol
- Description
- Date
- Ex Date
- Pay Date
- Quantity
- Tax
- Fee
- Gross Rate
- Gross Amount
- Net Amount
- Asset Class
- Symbol
- Description
- Security ID
- Multiplier
- Expiry
- Type
- Strike
- maturity
- Issue Date

This section gives you an overview of the foreign currency exchange rate relative to your base currency.
- Date/Time
- From Currency
- To Currency
- Rate
Confirmation Flex Configuration Details
General Configuration
This section gives you the ability to name your report and choose your output format, either text or XML. Customers with some programming knowledge can choose the XML format and then read exported data into an XML reader or a customized programming application.
Customers with less programming knowledge can choose the text format and
export their data into a text-friendly application such as Excel or Word.
In addition
clients need to select their preferred delimiter or separator Comma,
Pipe or Tab. The delimiter tells the receiving application how to separate
pieces
of
information.
Example: If you want to make the report readable in Excel, chose Text
Format, and, depending upon your preference, Comma, Pipe or Tab as the
delimiter.
If you manage several accounts and want to include more than one of them
in the
report, press and hold the Shift (or Ctrl) key while you select the account
numbers.

Date Configuration Section
Define the time period your report will cover. Choose from a specific period (i.e. last business day) or define a range using a starting and ending date.

How to Include and Set the Order for Fields in your Report General Overview
Use the Fields Available list to add the desired data fields to your customized report. Select a field and then click the right-pointing green arrow to move the available field into the Fields Included list.
To remove a field from your report, select the field in the Fields Included list, and click the left pointing arrow to put it back into the Fields Available list.
The fields in the Included list will display on your report in the order in which they are listed, descending from top to bottom. You can change the order of these fields by selecting a field and using either the UP or DOWN arrow below the list to move the field. When you have completed designing your report, click the Save Query button at the bottom of the page.

Real-time trade confirmations are available for all executions from the
start of the year up through your most recent trades.
Below is a list of specific fields in the Trade Confirms section
Trade Confirms Configuration
- Account ID
- Base Currency
- Asset Class
- Symbol
- Description
- ConID
- Security ID
- Multiplier
- Strike
- Expiration
- Put/Call
- Trade ID
- Trade Date/Time
- Trade Settlement Date
- Exchange (for Transactions) / Instruction Name (for Transfers)
- Buy/Sell
- Quantity
- Price
- Amount
- Commission
- Tax
- Code
- Opening (an opening trade is marked as True, while a closing
trade is marked as False. This value is
currently only available for Option trades).
Flex Web Service allows IB customers to access pre-configured Flex Queries via the HTTPS protocol, without logging into Account Management. This feature enables customers to write automated client software in their preferred language which can request previously defined FlexStatement queries in real-time.

- Enabling the Flex Web Service
To enable the FlexWeb Service for an account, log in to Account Management and click on the link labeled “Flex Web Service” under the Report Management menu. Clicking this link will enable the Flex Web Service for the account.
Before obtaining a token, it is important to check that the Service Status is Active. If the status is set to Suspended, simply click the link to reactivate.
- Obtaining the token
You will receive a token on the same screen confirming that the Flex Web Service has been enabled. This token will be used to:
1) Initiate a Flex request, and
2) Retrieve a Flex report
The token is valid for a 6 hour period by default, after which time you must obtain a new token through Account Management. You have the option of increasing the time frame for which a Flex Token is valid. The token can also be attached to a specific IP address for greater security.
- Initiating an automated Flex Web Service request
To initiate a Flex automated request you will need the following information:
1) Initial URL: https://www.interactivebrokers.com/Universal/servlet/FlexStatementService.SendRequest
2) Token: Obtained above
3) Flex Query ID: The ID generated when creating a Flex query.
Query Format
You will get a XML response from IB, which containing the following information:
a. Reference Code
If the request was successful, the XML response will contain a numeric reference code. This code will be used to retrieve the generated Flex query. If the request was unsuccessful you will get back “INVALID REQUEST” (without the quoted) as the code.
b. Response URL
This is the URL to be used to retrieve the Flex report.
Sample XML response:
- Retrieving the Flex Report
In order to retrieve the Flex data you will need the following information:
1) Response URL: This is the URL you received as part of the response when you placed the request.
2) Reference Code: This is the code you received as part of the response when you placed the request.
3) Token: This will be the same validation token used to initiate the Flex request.
4) Service version: For Activity Flex or Confirmation Flex, this should be set to 2. For Legacy Flex, this can be left blank or set to 1.
Query Format
You will receive the Flex data as the response if the request was successful. Otherwise, you will receive a XML based response informing you that the request was invalid.
Sample XML response if the request was unsuccessful:
This report calculates margin requirements for a 30% up and down move in the underlying.
To access the Stress Test report, log into Account
Management and go to Report
Management. Below is an example of the Stress Test Report.

Interactive Brokers caps the amount of fees an advisor can charge a client, up to a maximum of 25% of the client’s average equity in a given year. The Advisor Fee Cap report displays the amount of available fee cap by client.
To access this report, log into Account Management and go to Report Management. Below is an example of the Advisor Fee Cap report.

Advisor & Broker Summary Report Overview
The Advisor & Broker Summary Report is a snapshot of client balances and performance over a one-day period. Each day at 16:15 ET we would record the margin and equity information across all asset classes and exchanges. At 20:20 ET, we record the commissions and cash balances. Because information on your clients statements is displayed as of the cut-off time for each individual exchange, it should be noted that information on your client summary report may not equal information on your clients statements.
To access the Advisor & Broker Summary Report, log into Account Management and Report Management. Below is an example of how to create the report and the different sections, which are displayed.

Please select an account and date and click the Download button.
Advisor & Broker Summary Report Explanation by Section
Account Information

The Account Information summarizes the account name, account number, account type (i.e. Individual, Advisor Master, Broker Consolidated, etc.), customer type (i.e. individual, partnership, etc.), account capabilities (cash or margin), trading permissions (i.e. stock, options, etc.) and the base currency of the account (AUD, CAD, CHF, EUR, GBP, HKD, JPY and USD).
Client Summary Overview

This section gives a total summary of all accounts. The Client Summary Overview section breaks out security amounts for Total Commissions Paid, Equity with Loan Value, Net Liquidation Value and current Initial and Maintenance margin requirements. For details per account, see the below Client Summary section.
For more information on how the different fields are calculated, see the Margin Reports and Margin Report Explanation by Section on our website. To see how initial and maintenance margin values are calculated, see the Margin Overview page on the IB website.
All non-base currency amounts are converted to the base currency. For more details on these calculations, refer to the Account Information Window topic in the TWS Users' Guide.
Client Summary

The Client Summary section shows Total Commission Paid, Equity with Loan Value, Net Liquidation Value, Trade Cash Value, Settled Cash Value, Initial Margin, Available Funds, Maintenance Margin, Excess Liquidity, and Total MTM P&L per account.
Broker Client Revenue and Expense Summary Report Overview
Broker Masters only can run this report to view a snapshot of client daily, month-to-date and year-to-date expenses, revenues, net revenue, gross margin and aggregate client MTM.
To access the Broker Client Revenue and Expense Summary Report, you must be a Broker Master. Log into Account Management and Report Management. Below is an example of how to create the report and the different sections, which are displayed.

Please select an account and date and click the Download button.
Broker Client Revenue and Expense Summary Report Explanation by Section
Account Information

The Account Information summarizes the account name, account number, account type (i.e. Individual, Advisor Master, Broker Consolidated, etc.), customer type (i.e. individual, partnership, etc.), account capabilities (cash or margin), trading permissions (i.e. stock, options, etc.) and the base currency of the account (AUD, CAD, CHF, EUR, GBP, HKD, JPY and USD).
Revenue & Expense By Product Overview

These sections give a snapshot of client daily, month-to-date and year-to-date revenue and expenses by product. Each section shows expenses, revenues, net revenue, gross margin and aggregate client MTM.
Introducing Broker Exception Report
This report provides snapshots of your top 40-performing clients, over different time periods and based on specific criteria. View Daily, Month-to-Date (MTD) and Year-to-Date (YTD) reports of your top 40 Highest Commissions customers, top 40 Highest P/L customers, and top 40 Lowest P/L customers. Daily reports also include the top 40 Highest Equity customers.
To access this report, log in to Account Management and go to Report Management. Below is an example of the Introducing Broker Exception Report.

Define the time period your report will cover and click the View button.



Expand All Info
Contract All Info