Statements & Reports


Activity Statements

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.

IB mails quarterly statements to all Financial Advisor client accounts except Hedge Fund client accounts. These statements are mailed to the client's residential address and to the business address of clients who are organizations.

Notes:
  • 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.
Activity Statement Explanation by Section
Click on a bar(s) below or use the Expand All/Contract All links below for more information.

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 Net Asset Value (NAV) in Base Currency section 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 account’s 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 Net Asset Value (NAV) 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. Wash sales are also accounted for in the FIFO 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.

Wash Sales

For wash sales, the disallowed loss is included in the respective Realized S/T Loss or L/T Loss columns.


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

Wash Sales

For wash sales, the disallowed loss is included in the respective Realized Short Term MTD/YTD or Long Term MTD/YTD columns..


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 Net Asset Value (NAV) In Base Currency section, MTM Performance Summary section, Futures Price Adjustments section, and Corporate Actions section.



Displayed in Settled Activity statements, this section shows the daily debits, credits and balance for securities and commodities for the period covered by the report.



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.

Wash Sales

For lots that have been adjusted for a loss disallowed, the value LD will appear in the Code column. For other types of lots, nothing will be displayed in the Code column. In the Open column, the holding period time is displayed instead of the open time. For default lots they are the same; for lots that have been adjusted for a loss disallowed, the holding period will be the date/time of the original lot. For the loss disallowed lots, the cost basis has been adjusted by the amount disallowed (and thus also cost price).


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.

Wash Sales

For lots that have been adjusted for a loss disallowed, the value LD will appear in the Code column. For other types of lots, nothing will be displayed in the Code column. In the Open column, the holding period time is displayed instead of the open time. For default lots they are the same; for lots that have been adjusted for a loss disallowed, the holding period will be the date/time of the original lot. For the loss disallowed lots, the cost basis has been adjusted by the amount disallowed (and thus also cost price).


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.

Wash Sales

For wash sales, the Realized P/L column will contain the net realized amount, including loss disallowed. Also, Closed Lots now appears in place of Open for closed lots for default election. For Maximize Losses or LIFO tax basis election, VSP (Versus Purchase Date) appears.


Your total Unbundled Commission Details will include IB unbundled, exchange, clearing and regulatory fees. This section is available in daily statements for individual accounts and single account structures only. It is not available for multiple account structures.


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 Trades 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 transaction’s 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 paid 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 Net Asset Value (NAV) In Base Currency 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 Templates

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.

Customized Templates

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.

Customized Templates

Activity Downloads

We provide the ability to download your Activity Statements into the following software:

Advent
Captools
Interactive Advisory Software

Downloading to Advent

We provide Advent Custodial Data as a direct feed to Advent. This option is not available on the Activity Downloads page in Account Management and must be requested. Currently, only stocks, options, bonds and futures data is available for Advent Custodial Data, which IB converts to USD.

If you would like to import your IB statements into Advent, contact Advent to request a data feed. After Advent processes your request, they will contact IB to link your account to the Advent data feed.

For more information about Advent Custodial Data, visit http://www.advent.com/solutions.

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.) Note that Captools downloads are also available for IB individual accounts.

Downloading to Interactive Advisory
Software (IAS)

You can request downloadable IB statement files for IAS. The following files are available for your IAS Activity Download in a single zipped file:

  • Record - List of accounts.
  • Security Info - All securities or new securities as of the date in the file name.
  • Price - All closing prices for the date in the file name.
  • Transaction - All transactions that occurred or cleared on the date in the file name.

Contact your IB Sales Representative to request downloadable statement files for IAS.

All amounts in your IB statements are converted to your account's base currency. For more information about IAS software, visit http://www.iassoftware.com.

PortfolioCenter®

   

Downloading to PortfolioCenter

You can request downloadable IB statement files for PortfolioCenter from Schwab Performance Technologies. Download Activity Statements from the Activity Downloads page in the Report Management menu in Account Management.

Select one of the following files for your PortfolioCenter Activity Download, or choose to download all of the files in a single zipped file:

  • Security - All securities or new securities as of the date in the file name.
  • Portfolio - All portfolios or new portfolios as of the date in the file name.
  • Price - All closing prices for the date in the file name.
  • Transaction - All transactions that occurred or cleared on the date in the file name.
  • Position - All positions as of the close of business for the date in the file name (used to establish initial positions).
  • Reconciliation – All positions as of the close of business for the date in the file name (used to check position balances)

The following guidelines apply to IB statement data downloaded to PortfolioCenter:

  • All amounts are converted to your account's base currency.
  • The following asset classes are included: stocks, options, bonds, bills and funds.
  • The output files will contain data for all of the Advisor's client account IDs, but will not include the Advisor account ID.

If you would like to import your IB statements into PortfolioCenter, please visit https://schwabpt.com/products/portfoliocenter/. Contact your IB Sales Representative to request downloadable PortfolioCenter files.

   

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.


PortfolioCenter is a product of Schwab Performance Technologies, a subsidiary of The Charles Schwab Corporation.
Quarterly Summaries

Professional advisors and their clients can view the Brokerage Account Quarterly Activity Summary, which is a simplified quarterly statement containing activity summaries of the advisor client's account. Each quarter, advisor clients receive a hard-copy of the summary by mail. Quarterly summaries are available for download as a PDF file under the Report Management section in Account Management.

Section-by-Section Explanation

Click on a bar(s) below or use the Expand All/Contract All links below for more information.
Account Information

The Account Information section summarizes the account holder name address, account number, financial advisor name and address, 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).

Net Asset Value (NAV) In Base Currency

The Net Asset Value (NAV) in Base section shows NAV totals 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. 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.

Current Account Positions

The Current Account Positions section shows the symbol, description, quantity and current price at the end of the quarter of all positions in your account, sorted by asset type and base currency.

Transactions Summary

The Transactions Summary section shows the total number of trades and total number of shares or contracts bought and sold for each asset class in the quarter. This section does not appear if you had no transactions in the quarter.

Year to Date Performance Summary in Base

The Year to Date Performance Summary in Base section shows year-to-date mark-to-market, and realized short and long term performance for each asset class in your account and totals for all asset classes.

Cash Report

The Cash Report section details how the quarter'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.
Change in Position Value

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 sorted 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.

Other Information

The Other Information section includes information about your financial advisor and advisor fees.

Codes

The Codes section displays abbreviations used in the summary and their meanings.

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.
Margin Reports

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 180 days.

Please note that class breakdowns for Portfolio Margin accounts are not currently available.

Margin Report Explanation by Section
Click on a bar(s) below or use the Expand All/Contract All links below for more information.

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.

Margin Report Availability by Account Type
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.
Real-Time Trade Confirms

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.

 

TWS

 

Notes:
  1. Any stock or option symbols displayed are for illustrative purposes only and are not intended to portray a recommendation.
FlexQuery

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. You can also add default queries for both Activity and Trade Confirmations Flex queries and edit them to create your own Flex queries. There are two default queries available for Activity Flex queries (one for Trades and one for Positions), and one default query for Trade Confirmations. These are available in Account Management.

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.

Activity Flex

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:

  1. Begin of file row (for each account ID in report)
  2. End of file row (for each account ID in report)
  3. Begin of section row (for each section in report)
  4. 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 Net Asset Value; trade date basis
EQUS Net Asset Value; 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:
BOF Begin file
BOA Begin account
BOS Begin section (i.e., Trades, Positions, etc.)
HEADER Header row (i.e. column headers, the fields enabled for the report)
DATA Data row
EOS End of section
EOA End of account
EOF End of file

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

 

Click on a bar(s) below or use the Expand All/Contract All links below for more information.

  • 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
  • SLB Cash Collateral
  • Stock
  • SLB Direct Securities Borrowed
  • SLB Direct Securities Lent
  • Options
  • Bonds
  • Notes
  • Interest Accruals
  • Soft Dollars
  • Dividend Accruals
  • Total
  • Account ID
  • Asset Class
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Underlying Symbol
  • 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
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Underlying Symbol
  • 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
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • 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
  • Deposits
  • 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
  • Fees Receivable
  • Fees Receivable Securities
  • Fees Receivable Commodities
  • Payment in Lieu
  • Transaction Tax
  • Withholding Tax (IRS or other tax authority directs us to withhold for a customer)
  • IRA Withholding
  • 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

  • Account ID
  • Report Date
  • Date
  • Activity Description
  • Debit
  • Credit
  • 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
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Report Date
  • 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
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Report Date
  • Trade Date
  • Trade Time
  • Settle Date Target
  • Transaction Type (Exchange Trade, Book Trade, Trade Correct, Trade Cancel, Frac Share, Frac Share Cancel)
  • 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
  • Strike
  • Expiry
  • Put/Call
  • Buy/Sell
  • 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
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Trade ID
  • Report Date
  • Trade Date
  • Trade Time
  • Settle Date Target
  • Transaction Type
  • 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
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Stage (Pending, Received, Confirmed, Transmitted)
  • Trade Date
  • Target Settlement
  • Direction (To or From)
  • Instruction Name
  • Quantity
  • Trade Price
  • Trade Amount
  • Trade Amount in Base
  • Transaction ID

  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date/Time
  • Settle Date
  • Exchange
  • Broker Name
  • Broker Account
  • Quantity
  • Trade Price
  • Trade Amount
  • Trade Amount in Base
  • Commission
  • Commission in Base
  • Tax
  • Transaction ID
  • Code

  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date/Time
  • Quantity
  • Trade ID
  • Total Commission
  • Broker Execution Charge
  • Broker Clearing Charge
  • Third Party Exchange Charge
  • Third Party Clearing Charge
  • Third Party Regulatory Charge
  • Account ID
  • Currency
  • Asset Cass
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Original Date
  • Adjust Date
  • Quantity
  • Multiplier
  • Original Price
  • Adjust Price
  • Original Amount
  • Adjust Amount
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date
  • Price
  • Prior MTM Profit and Loss

  • Account ID
  • Currency
  • FX Rate To Base
  • Date
  • Description
  • Revenue
  • Expense
  • Net Revenue
  • Trade ID
  • Level of Detail
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Underlying Symbol
  • Report Date
  • Date/Time
  • Amount
  • Quantity
  • FIFO Realized Profit and Loss
  • MTM Profit and Loss
  • Report Date

  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date
  • Type
  • Direction (To or From)
  • Account
  • Cash Transfer
  • Quantity
  • Transfer Price
  • Position Amount
  • Position Amount in Base
  • P/L Amount
  • P/L Amount in Base
  • Code

  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • 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)  

  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date
  • Received
  • Paid
  • Total
  • Transaction ID
  • Account ID
  • Currency
  • Asset Class
  • Conid
  • Description
  • Date/Time
  • Amount
  • Commissions
  • Account ID
  • Currency
  • From Date
  • To Date
  • Starting Accrual Balance
  • Interest Accrued
  • Accrual Reversal
  • Ending Accrual Balance
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Type
  • Transaction ID
  • Exchange
  • Quantity
  • Fee Rate %
  • Collateral Amount
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date
  • Transaction ID
  • Activity Description
  • Type
  • Exchange
  • Quantity
  • Fee Rate %
  • Collateral Amount
  • Mark Quantity
  • Mark Prior Price
  • Mark Current Price
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Value Date
  • Start Date
  • Type
  • Exchange
  • Quantity
  • Fee Rate %
  • Fee
  • Carry Charge
  • Ticket Charge
  • Total Charges
  • Code
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Date
  • Ex Date
  • Pay Date
  • Quantity
  • Tax
  • Fee
  • Gross Rate
  • Net Amount
  • Code
  • Account ID
  • Currency
  • Asset Class
  • FX Rate To Base
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • Ex Date
  • Pay Date
  • Quantity
  • Tax
  • Fee
  • Gross Rate
  • Gross Amount
  • Net Amount
  • Asset Class
  • Symbol
  • Description
  • Conid
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying Conid
  • 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

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.

Confirmation Flex Configuration

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.

Confirmation Flex Configuration

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.

Confirmation Flex Configuration

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
  • Currency
  • Asset Class
  • Symbol
  • Description
  • ConID
  • Security ID
  • CUSIP
  • ISIN
  • SEDOL
  • Underlying ConID
  • Transaction Type
  • Multiplier
  • Strike
  • Expiry
  • Put/Call
  • Trade ID
  • Order ID
  • Original Trade Price
  • Original Trade Date
  • Original Trade ID
  • Order Time
  • Date/Time
  • Report Date
  • Settlement Date
  • Exchange (for Transactions) / Instruction Name (for Transfers)
  • Buy/Sell
  • Quantity
  • Price
  • Amount
  • Commission
  • Commission Currency
  • Tax
  • Code
  • Order Type
Flex Web Service

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.

FlexStatements web service
  1. 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.

  2. 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.

  3. 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
    Sample code

    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:
    Sample code

  4. Note: Programmatic access requires the User-Agent HTTP header to be set. Accepted values are: Blackberry or Java.

  5. 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
    Sample code

    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:
    Sample code

    Note: Programmatic access requires the User-Agent HTTP header to be set. Accepted values are: Blackberry or Java.

Value at Risk Summary

This report computes your Value at Risk (VAR) at 99, 99.5 and 100%[1] 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.

Value at Risk

Notes:

  • [1] A loss at the 100% confidence interval is not intended to suggest that there is no possibility of a loss in excess of that computed, but rather reflects the projected loss at the 100th percentile or, worst case, among the discrete set of market scenarios considered via a large-scale Monte Carlo simulation.
Stress Test Report

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.

Stress Test Report

 

You do not have the Adobe Flash player plugin installed. Interactive Brokers utilizes flash throughout our website to enhance your experience. We recommend you click here to download the plugin.
Advisor Fee Cap

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 Fee Cap
Advisor & Broker Client Summary 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 client’s 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 client’s 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.

Advisor Fee Cap

Please select an account and date and click the Download button.

Advisor & Broker Summary Report Explanation by Section

Account Information

Advisor Fee Cap

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

Advisor Fee Cap

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

Advisor Fee Cap

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

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.

Revenue and Expense Summary

Please select an account and date and click the Download button.

Broker Client Revenue and Expense Summary Report Explanation by Section

Account Information

Revenue and Expense Summary 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

Revenue and Expense Summary Data

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.

Broker Exception Report

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.

Broker Exception Report

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

Broker Exception Report
Statement Delivery

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.

Statement Delivery
PortfolioAnalyst

PortfolioAnalyst lets you analyze the performance of your account portfolio online by creating and saving customizable HTML and presentation-ready PDF reports based on a set of measurement criteria and optionally comparing the data to selected industry benchmarks. You can also create single-page Comprehensive Snapshot PDF reports suitable for presentation. Once you create and save reports, you can run, edit or delete them. You access PortfolioAnalyst from the Report Management menu in Account Management.

PortfolioAnalyst Customizable HTML Reports

To use PortfolioAnalyst, you first select what kind of report you want to create - customizable HTML or PDF reports - then enter settings for the report and save and run it. PortfolioAnalyst settings for customizable HTML reports include:

  • Name: Enter a name for the template. This is the name that appears on the list of existing report templates on the PortfolioAnalyst page in Account Management.
  • Time Period: Select Daily, Monthly or Quarterly, then select a beginning and ending time period. The report output will analyze data for each day, month or quarter in the time period you specify. Analysis results include data available from January 2008 to the present. The maximum Daily time period is 60 days.
  • Account: If you are a Master account user responsible for client or sub accounts, you can select one or more accounts whose performance you want to analyze.
  • Performance Measure: Select one of these percentage value 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.
  • Select Report: Select one or more reports to include in your PortfolioAnalyst output:
    • Account Overview
    • Allocation by Asset Class
    • Benchmark Comparison: You can select up to three benchmarks for your comparison.

The reports are described below.

For complete instructions, see the PortfolioAnalyst topic in the Account Management Users' Guide.

PortfolioAnalyst Customizable HTML Report Output

PortfolioAnalyst output can contain one or more of the following reports, depending on which reports you selected when you set up the template.

Account Overview

The Overview report displays the general settings for your PortfolioAnalyst report, including your account name and number, account alias if you have one, your base currency, and the specified time period. This section also displays the net performance of your portfolio for the specified time period, including the beginning and ending Net Asset Value (NAV), the return percentage based on your selected performance measurement (TWR or IRR). A color-coded bar chart plots NAV over time, and a companion color-coded line chart plots the return percentage (TWR or IRR) over the same time scale.

The Overview report also includes additional performance statistics. The Performance Statistics section displays the following values:

  • 1 Month Return: One-month return percentage based on your selected performance measurement (TWR or IRR).
  • 3 Month Return: Three-month return percentage based on your selected performance measurement (TWR or IRR). You will only see this value if the time period in the template is at least six months.
  • Best Return: The best return percentage (TWR or IRR) and the day, month or quarter in which it occurred.
  • Worst Return: The worst return percentage (TWR or IRR) and the day, month or quarter in which it occurred.

PortfolioAnalyst Overview section

Allocation by Asset Class

The Asset Allocation report displays a color-coded bar chart and a table that show the NAV of all assets in your portfolio by asset type (cash, stocks, options, etc.) and total NAV for each day, month or quarter in the specified time period. The bar chart plots NAV over time (day, months or quarters).

PortfolioAnalyst Asset Allocation section

Benchmark Comparison

The Benchmark Comparison report displays a color-coded line chart comparing the return percentage (TWR or IRR) of your portfolio with that of the selected benchmarks. This section also displays a table of the same values. The line chart plots return percentage over time (days, months or quarters).

PortfolioAnalyst Benchmark Comparison section

PortfolioAnalyst Customizable Detailed PDF Reports

Customizable Detailed PDF Reports are presentation-ready PDF reports with a cover sheet, a table of contents and multiple pages. Customizable Detailed Reports can contain any of the following reports:

  • Account Overview: Same as Customizable HTML Reports
  • Allocation by Asset Class: Same as Customizable HTML Reports
  • Open Position Summary: This report shows all current open positions in the selected account(s). The report output shows two pie charts: the five positions that have the highest market value, and the five positions with the highest unrealized P/L. The output also displays a table of all open positions sorted by product, then currency, then symbol. The table includes the quantity, closing price, current market value, unrealized P/L, the percent of your total Net Asset Value for that position and the current value and unrealized P/L in your account’s base currency.
  • Benchmark Comparison: Same as Customizable HTML Reports; you can select up to three benchmarks for your comparison.

Comprehensive Snapshot PDF Reports

PortfolioAnalyst includes a Comprehensive Snapshot PDF report, which is a single-page report that displays graphs and charts representing the account's return, Net Asset Value (NAV), asset allocation and distribution of returns. PortfolioAnalyst settings for Comprehensive Snapshot PDF reports include:

  • Name: Enter a name for the template. This is the name that appears on the list of existing report templates on the PortfolioAnalyst page in Account Management.
  • Time Period: Select Daily, Monthly or Quarterly, then select a beginning and ending time period. The report output will analyze data for each day, month or quarter in the time period you specify. Analysis results include data available from January 2008 to the present. The maximum Daily time period is 60 days.
  • Account: If you are a Master account user responsible for client or sub accounts, you can select one or more accounts whose performance you want to analyze.
  • Performance Measure: Select one of these percentage value 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.

The report output is described below.

Comprehensive Snapshot PDF Report Output

The Comprehensive Snapshot includes the following sections:

  • Account Information: Displays your account name and number, account alias if you have one, your base currency, account type and the specified time period.
  • Return Over Time: Displays a line chart showing the account's return percentage over the specified time period.
  • Net Asset Value: Displays a bar chart showing the account's Net Asset Value over the specified time period.
  • Distribution of Returns: Displays a bar chart showing the range of return percentage for each day, month or quarter in the specified time period and the number of times the return performance fell within that range for the entire period.
  • Key Statistics: Displays several statistics for the specified time period, including beginning and ending NAV, one- and three-month return percentages, the best return and the worst return and the months in which they occurred..
  • Asset Allocation: Displays two pie charts, one representing the account's asset allocation at the beginning of the specified time period and one representing the account's asset allocation at the end of the specified time period.

The following illustration shows a typical Comprehensive Snapshot report.



Please send your questions/feedback to portfolioanalyst@interactivebrokers.com.

Statement Release Notes

Click on a date or topic in the table below to access the associated Release Notes.

 

 

Statements and Reports Release Notes:
June 23, 2010


 

Statements and Reports Release Notes



February 2, 2010


November 9, 2009


October 12, 2009



August 26, 2009




July 7, 2009


May 18, 2009

 

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.