TWS Statements Webinar Notes

 

IB's statement format provides greater detail, easier viewing, and more flexibility. Highlights include:

• Expand and contract sections with click-down detail to view individual sections and collapse redundant detail.
• Profit and loss across all transactions, positions, and asset types calculated in two methodologies:
  • Realized and Unrealized (FIFO, LIFO and Maximize Losses)
  • Mark-to-Market (MTM)
• A performance summary by asset class that gives a quick view of an account's profitability.
• Opening and closing balances with links for easy access to balance change details.
• Calculation of FX translation gain/loss due to currency fluctuations for accounts with multiple currencies.
• New customizable statement templates that allow you to create and save statements with just the information and sections that you need.

Statements can be accessed through TWS from the View menu or separately through the Account Management, Reports Management section

• Multi-account structures (Advisor, Broker, Institutions) may select one or more accounts from the drop down box.
• Monthly statements are generally available by 5 business days after the close of a month.
• Annual statements available by January 31 under normal business circumstances.

Note: Different trading products can have different trading cut-off hours for statement purposes. For most products, the product trading hours' cut-off coincides with the exchanges' hours, but for some exchanges this might not be the case (e.g. CME equity and fixed income contracts have different cut-off hours).

Statement Archive Policy

We provide web-based access to the following account statements:

• Daily account statements for 1 year prior.
• Monthly account statements for the 2 prior years.
• Annual account statements for the 3 prior years.

Account statements older than this may be obtained for a processing fee of $100 for the first statement requested, plus $25 for additional statements requested at the same time.

 

You can select from two default formats for viewing statements, Full or Simple. We'll first take a look at the Full template and all available Statement sections. Later in this session we will discuss the Simple template as well as how you can create customized statement templates to select only those sections you need and choose how to view P&L - in either Realized & Unrealized or MTM format or both.

Our statements were designed from the top down with summary totals at the top of the statement, opening to greater detail in each section as you work towards the bottom. Hyperlinked fields provide quick access to corresponding detail sections.

 

Account Information

Account Information summarizes the account information with Customer type, trading permissions and base currency.

• account type (Individual, Advisor Master, Advisor Client, Institutional, etc.)
• account alias (Individual, Advisor Master, Advisor Client, Institutional, etc.)
• customer type (individual, partnership, etc.)
• account capabilities (cash or margin)
• trading permissions (stock, options, etc.)
• base currency of the account

 

Equity Summary in Base Currency

The Equity Summary shows all positions by asset class (stock, securities options, warrants and bonds), cash, and accruals for the current as well as the prior period. There are no open futures positions as each night the gain or loss for futures contracts settles into cash.

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

 

Equity Value Time Series

The Equity Value Time Series 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.
• Yearly statements a bar for each trading day of the year.

 

Mark-to-Market Performance Summary in Base

The MTM Performance Summary in Base shows profit and loss (P&L) by underlying and asset class.

The MTM calculations for the statement period show daily profit or loss - assuming all open positions and transactions are settled at the end of the day and new positions are opened the next day.

The MTM calculations are split to simplify the presentations: calculations for transactions during the statement period and calculations for positions open at the beginning of a day.

It also shows the internal rate of return for the statement period. To compute the IRR (Internal 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.

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.

 

Realized & Unrealized Performance Summary in Base

The most common method of determining P&L for stocks and options is First In, First Out (FIFO where closing transactions are matched to opening transactions and a profit or loss is realized when a position is closed. IB has added two new ways to declare your Tax Basis. Last in, First out (LIFO) and Maximize Loss. The Realized and Unrealized Performance Summary in Base shows Profit & Loss (P&L) by underlying and asset class in your chosen base currency.

• Open positions are marked-to-market and the P&L is UNREALIZED.
• REALIZED P&L is determined when closing the position by matching First In, First Out (FIFO), Last In, First Out (LIFO) and Maximize Loss transactions.
• To simplify tax reporting, the realized category splits gains and losses and displays long term, for positions held a year and a day, and short term positions held less than a year.

Commissions

• For MTM calculations, commissions are not included but are displayed as a separate line in the MTM Performance Summary.
• For FIFO, LIFO and Maximize Loss, commissions are included with the cost basis and sales proceeds to determine the realized and unrealized P&L.

 

Realized & Unrealized Performance Summary in Base

Month & Year to Date Performance Summary in Base displays MTD and YTD totals by underlying in base currency. The columns include MTM, Realized Short Term and Realized Long Term

 

Cash Report

The Cash Report section details how each period's cash balance changes from the beginning of the period to the end of the period. For those statements with multiple currencies, all currencies are detailed separately and 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 Cash and Ending Cash lines represent trade date balances. We also show settlement date balances which represent 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 always paid and received on settlement balances, accrued during the month and paid after month close. A complete explanation of how interest is calculated can be found on the Interest and Financing page.

Net Trades (Sales) is made up of the following components:

• Proceeds from Securities Trades.
• Futures Mark-to-Market Gains.
• CFDs Mark-to-Market Gains.
• Cash from Corporate Actions.

Net Trades (Purchases) contains the following:

• Purchase Price of Securities.
• Futures Mark-to-Market Losses.
• CFDs Mark-to-Market Losses.
• Cash from Corporate Actions.

Please note the following caveats related to the Net Trade Lines.

• Futures Options are available under two settlement styles; those that settle like securities, and those that settle like futures. Each style will be grouped into the proper category indicated above.
• All mark-to-market gains and losses for futures will be netted and applied either as a single mark-to-market gain or loss.

It should also be noted that because exchanges outside of the US and Canada allow for the cross margining of futures and cash settled options, all European and Asian cash settled futures will be reflected in the commodities account, whereas in the US and Canada they will be reflected in the securities account.

 

Change in Position Value

The change in position value section explains the changes in your position value from the beginning of the period to the end of the period.

• Changes in position value are due to transactions and changes in market prices.
• Details for these changes can be found in the Transaction and the Mark-to-Market P/L on Prior Period Positions sections.

 

Long Open Positions

This section shows all long open positions, the cost basis by lot, and 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 P&L 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 Realized/Unrealized Performance Summary section above.

 

Short Open Positions

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.

 

Trades

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.
  • Commissions are included with the cost basis and Realized profit or loss,
  • For MTM profit or loss, commissions are listed as a separate line in the Mark to Market Performance Summary above.

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.

• This section also shows a summary of how positions change from the beginning of the period to the end of the period for each asset class in the base currency.
  • The change for the period consists of new trades as well as MTM changes in the value of the position.
  • If positions are held in a non-base currency, there will also be a Position FX Translation Gain/Loss which reflects changes in value to the position due to a fluctuation in FX rates that are used to translate to the base currency.
  • The Futures section will begin and end with a value of zero since all MTM fluctuations are settled into cash at the end of each trading day.
  • Transaction amount, commissions/taxes, cost basis, Realized P&L and MTM P&L for non-base currencies are all converted to the base currency in effect on the day of the transaction.
  • If a trade uses a non-FIFO tax declaration, we will display in the Activity Statement either ML (maximize losses) or LI (LIFO) in the Trades table’s Code column.

 

Interest Accruals

Interest is paid and charged once a month after each month's close. During the month we accrue interest each day, and when interest is actually posted to the account, the daily accruals are reversed.

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

 

Codes

This section shows all the codes that are used in the statement to identify the activity in the account.

 

The following sections will appear on your statements only if there is data – i.e.: If your positions do not have dividends, the Dividend section will not appear.

 

Unbundled Commission Detail

Your total Unbundled Commission Details will include IB unbundled, exchange, clearing and regulatory fees.

 

Broker Interest Paid & Received

When interest is paid or received after the close of each month, it is reflected in the Broker Interest Paid and Broker Interest Received sections.

• This section is sorted by currency, translated to the base currency, and tied to the Mark-to-Market Performance Summary as well as the Cash Report.

 

Futures Price Adjustments

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

 

Price Adjustments

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 adjusted trade.
• A positive adjustment is debited to your account; a negative adjustment is credited.

 

Commission Adjustments

This section shows any Commission adjustments that were made to your account based on actual commission charges.

Mark to Market P/L on Previous Period Positions

This section is segregated by asset class and currency.

• Expand / contract for details by symbol.
• Just as in the Mark to Market Performance Summary section above, MTM profit and loss is calculated in two components:
  • MTM gains from trades during the statement period and
  • MTM gains or losses for positions that are carried into a new trading day.
• 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.

 

Withholding Tax

The Withholding Tax table displays Federal withholding tax on dividends, calculated for each currency based on tax rules for that country. The description for each line also displays the amount of tax per share.

 

Transaction Tax

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.

 

Corporate Actions

The Corporate Actions section is sorted by asset class and currency.

Dividends

The Dividends section lists all dividend payments by currency. Each currency total is also displayed in your base currency. If your positions do not have dividends this table will not appear.

Client Fees

Advisors and Brokers who charge their clients fees will have a Client Fee 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.
• 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.

 

Other Fees

The Other Fees section details miscellaneous charges, (overnight position fees for unbundled futures, notes, order cancel, withdrawal, telephone order, check, stop payment, bounced check, old statement, bust/adjust, market data, and minimum commission fees) is sorted by currency, is translated to the base currency in effect on the day of the fee, and ties to the Performance Summary as well as the Cash Summary.

 

Option Cash Settlements

• The option cash settlements shows the details of your index options, which settle in cash and not stock.

 

IBG Notes

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.

 

Deposits/Withdrawals

The Deposits/Withdrawals table shows all activity into and out of your account.

 

Payment in Lieu of Dividends

If you buy a dividend-paying stock on margin and we lend that stock, you will receive Payment in Lieu of Dividend instead of the dividend. This payment is treated as ordinary income for US tax purposes.

Change in Dividend Accruals

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.

 

Open Dividend Accruals

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.

 

Bond Interest Paid & Received

Bond interest is paid on a coupon date and reflects interest paid or received during the coupon period.

• If you purchase 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.
• 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.

 

Segregated Settled Stock Positions

This section displays the segregated quantity for long stock positions. This section only will appear in monthly statements for IB-Canada accounts

 

Exchange Rates

This section gives an overview of the exchange rates versus base currency for the report period.

 

Transfers

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.

• Symbol.
• Date of transfer.
• Type.
• Direction- In, Out, or From.
• Account - the account to which the position goes.
• Cash Amount - the value of the cash transfer.
• Quantity - the share or unit quantity. For a cash transfer this field is blank.
• Transfer Price - the price per share at which IB accepts the incoming transfer.
• Market Value- the Quantity x Transfer Price.

 

Notes/Legal Notes

The following sections are only relevant to customers with IBPrime or IBExecution Services.

 

Unsettled Transfers

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 Trades section on the trade date as a trade, and will be removed from the Trades 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 Trades 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.

 

Unbooked Trades

Institutional customers with IBExecution services that pre-trade allocate options trades will have an Unbooked Trades section.

• This section will detail option 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.

 

Incoming Trade Transfers

Institutional customers with IBPrime Services will have an Incoming Trade Transfers section.

• This section 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.

 

Outgoing Trade Transfers

Institutional customers with IBExecution Services will have an Outgoing Trade Transfers section.

• This section 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 Trades section.

 

When selecting the statements to view, notice there are now two default formats for viewing statements in the Template drop down, Full and Simple. You can also create and save customized statement templates with just the sections you need and with P&L in either Realized or MTM format or both.

In Account Management | Reports Management | Activity Statements:

Under View Statements select a template to view:

• Full Default is the complete statement with all activity and includes all information over a year, a month, or a date-range. Annual Statement is only available in Full default view.
• Simple Default allows you to see a simpler monthly or daily view that includes Realized details – but excludes Mark-to-Market Performance Summary and P&L, Change in Position Value, and MTM P&L on Prior Period Positions.
• Create and Edit Templates section allows you to specify the sections to include, the amount of detail and the P&L format you prefer.
  • Then save your layout to include in the Template list along with the Full Default and Simple Default templates.
  • Create as many custom templates as you need, and view your activity using any selected template at any time.

Once selected, a new browser window opens with your statement displayed in the requested format.

Hide Lot detail for positions, transactions and prior MTM – will consolidate transactions by order number.

 

You can view the statements in Excel:

• Store the HTML statement locally on your hard-drive by clicking the File menu and then choosing Save from the menu options.
• Once the file is saved locally, open Microsoft Excel and choose the HTML file that you saved.

 

Margin Report shows margin requirements for all open single and combination positions. The report displays Available Funds (to determine if you can put on a new trade) and excess liquidity (when depleted you risk liquidations).

In the TWS Account window you get real-time margin summary amounts. As of 16:15 ET each day we record your margin and equity information across all asset classes and exchanges for the Margin Report.

 

Margin Summary

• Breaks out security and commodity amounts for Equity with Loan Value, Net Liquidation Value and current Initial and Maintenance margin.

 

Margin Detail

• View Margin Detail for each open position, including combination positions.
• Margin for FX trades is broken out onto separate lines.
• Total line is displayed for each currency in which you hold a position, along with the total in your base currency.
• Margin requirements details by product can be found on the Interactive Brokers web site under Trading | Margin.

 

Real-time Trade Confirmations are available from Account Management. From the left navigation panel select Report Management, and then Trade confirmations.

Below is an example of a Trade Confirmations Report.

 

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.

For definitions of the specific fields in each section, see the Activity Statement Explanation by Section

 

 

Any symbols displayed are for illustrative purposes only and do not portray a recommendation.

Interactive Brokers LLC is a member of NYSE, FINRA, SIPC