Activity Download Instructions

Activity Downloads

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

In addition to the above download solutions, a number of other third-party providers offer portfolio management and tax reporting packages that integrate with our HTML downloads. Please contact the provider for further detail.

Download to Tradelog, Quicken or MS Money
Step 1: If you do not already have an IB Investment account in Quicken or Money, please create one and manually load your current positions. Enable the account for Online Access.
Step 2: Log in to Account Management through our Home Page and choose Activity Downloads (Report Management).
Step 3: Select accounts, dates and a format (Tradelog, Quicken or MS Money) and click the View/Download button.
Step 4: Map the download to your IB Investment Account.
Step 5: Go to the IB Investment Account within Tradelog, Quicken or Money and accept the transactions.

For complete instructions how to import your statement to Tradelog, please visit http://www.armencomp.com/tradelog/interactive_brokers.shtml.

Intuit and Money do not support multiple currencies at this time.

Save an HTML file for Import into Word or Excel
Step 1: Log in to Account Management section of the web site and choose the Activity Statements menu item (Report Management).
Step 2: Choose accounts, dates and a format of HTML/Web, and click the View/Download button.
Step 3: Once the complete statement has loaded in the page, go to the File menu of your browser and choose Save As. This will prompt you to save the file locally on your computer.
Step 4: Enter a file name and choose a location to save your statement.
Step 5: Upload the saved HTML file into MS Excel or MS Word.

Downloading to Captools
If you would like to import your IB statement into Captools Professional please visit http://www.captools.net/ to see the latest import instructions. (Please note that you will need the Captools Broker/Dealer Interface from Captools before you can follow the steps mentioned below. Contact Captools at http://www.captools.net/ for the interface details.):

 

View Schedule D/Gain Loss Summary Worksheet using TurboTax

Log into

Account Management

and choose Tax Forms (Report Management). Select TurboTax TXF Format from the drop down menu and click View Report.

 

Please note that the TXF import is only available on the TurboTax desktop product.

Minimum Activity Fee

Our accounts are designed for sophisticated traders and investors who regularly meet our required minimums. If you do not meet those minimums, we charge a monthly activity fee. Generally, we waive this fee for any month in which:

  • You have more than 100,000 USD in equity or
  • You generate more than 10 USD in commissions and fees

The monthly activity fee is based on commissions only and does not include fees related to third-party assessments such as market data subscriptions or order modification/cancellation fees.

We also pass through market data fees from the exchanges for any real-time market data service to which you subscribe.

If you have multiple accounts with us, IBKR will calculate the consolidated monthly commission generated across all linked accounts. If the consolidated commission exceeds the number of accounts multiplied by USD 10, the minimum activity fee will be waived. If the consolidated commissions are less than the required minimum, an activity fee is charged on an account-by-account basis. Or if the total assets for all related accounts is greater than the number of accounts multiplied by USD 100,000 then the fees are waived on all accounts.

Please visit our Required Minimums page to read more about our activity fees and waivers in detail.

Troubleshooting Tip - Unable to open IBKR Activity Statement from email link

Overview: 

In addition to posting Activity Statements to Client Portal, IBKR provides clients with the option of receiving statements via email (unsecured) by choosing this option from the Reports > Statements - Statement Delivery menu item in Client Portal. 

Background: 

There have been instances where certain clients who have elected this option receive the email but are unable to open the attachment containing the statement.  Once the email has been sent the handling of these attachments is administered not by IBKR but rather by the client's email service provider and/or their desktop security settings.  Oftentimes, a service provider will block access to email attachments in order to minimize the threat of a virus or malware being introduced or perhaps to manage bandwidth and internal disk space.  If this is the case, clients may wish to contact their service provider for assistance or change their email address.

Alternatively, clients are encouraged to access statements by logging in to the secure Client Portal from the website and selecting the Reports > Statements menu options.

How can I discontinue the issuance of duplicate copies of my trade confirmations and statements to my former employer?

In order to effect this change you will first need to update your employment by logging in to Client Portal, selecting the Settings > Account Settings menu and clicking the Configuration (Gear) icon next to Regulatory Information. From there you may modify your personal information including employment. If the nature of your prior employment also involved membership in an exchange, regulatory or self-regulatory organization or you were an associated person, affiliated person or employee of an exchange member. If these no longer hold true, you will need to change your answer to this question as contained within the Regulatory Info menu option also contained under Account Information.

Finally, please instruct your former employer to send an email to newaccounts@interactivebrokers.com in order to independently confirm this request to discontinue sending duplicate statements.  If your new employer is also a financial institution which, for in-house compliance purposes and/or as a result of regulatory mandate monitors the trading activities of their employees, they will need email a request to newaccounts@interactivebrokers.com in order to receive duplicate statements and trade confirms.

Understanding interest charges when the net cash balance is a credit

An account will be subject to interest charges despite maintaining an overall net long or credit cash balance under the following circumstances: 

1. The account maintains a short or debit balance in a given currency.

For example, an account maintaining a net cash credit balance equivalent to USD 5,000 comprised of a long USD balance of 8,000 and a short EUR balance equivalent to USD 3,000 would be subject to an interest debit based upon the short EUR balance.  There would be no offsetting credit on the long USD balance as it is less than the USD 10,000 Tier I level above which interest is earned.  

Account holders should note that in the event they purchase a security which is denominated in a currency that they do not hold in their account, IBKR will create a loan in that currency in order to settle the trade with the clearinghouse. If one wishes to avoid such loans and their associated interest charges, they would need to either deposit funds denominated in that particular currency or convert existing cash balances via the Ideal Pro (for balances of USD 25,000 or above) or odd lot (for balances less than USD 25,000) venue prior to entering into your trade. 

2. The credit balance is comprised  principally of proceeds from the short sale of securities. 

For example, an account maintaining a net cash credit balance of USD 12,000 which is comprised of a USD debit of 6,000 in the security sub-account (less the market value of any short stock positions) and a short stock market value credit of USD 18,000 would be charged interest on the Tier 1 debit of USD 6,000 and would earn no interest on the short stock credit as it falls below the USD 100,000 Tier I level.

3. The credit balance includes unsettled funds.

IBKR determines interest debits and credits solely based upon settled funds. Just as an account holder is not assessed interest charges on funds borrowed to purchase a security until such time that purchase transaction settles, the account holder will not receive an interest credit, or offset against a debit balance, on funds originating from the sale of a security until such time the transaction has settled (and IBKR has been credited funds by the clearinghouse).

 

How can I access historical statements and how will I obtain tax reports once my account has been closed?

Background: 

After an account has been closed, the account holder will continue to be provided access to Client Portal for the purpose of reviewing and printing historical statements along with historical as well as the following year's tax forms (once issued).  Access is provided using the same user name and password combination in place at the time of closing.  Accounts which were enrolled in the Secure Transaction Program will no longer need a security device to log into their account.

How will I know the transaction price of a mutual fund purchase or sale on any given day?

 

Individuals who purchase or redeem mutual fund shares receive the next computed share price following the fund's receipt of the transaction order. Mutual fund orders are accumulated during the day and are transmitted to the fund at 15:59 for pricing. Once the fund determines its net asset value as of the close, this price will be posted to your Daily Activity Statement and to the TWS.

 

Will the consolidated statement reflect the tax basis choices of client accounts?

Overview: 

Clients have the ability to select one of three tax basis methods, First in First Out (FIFO), Last in First Out (LIFO) and Max Losses.  The method selected will affect the P&L values which are posted on the statements.

In an advisor structure, where the advisor has the ability to create a consolidated statement, those P&L values posted will properly reflect the tax basis choice as these calculations are done independent of how a statement may be viewed.

Why does the Cash Report section of my Activity Statement reflect an internal transfer between securities and commodities?

For regulatory purposes IB is required to segregate the securities assets within your account from the commodities assets.  Those commodities assets may include the market value of options on futures positions plus any cash required as margin as a result of commodities futures and options on futures positions.  Periodically, the margin requirement on your commodities positions will be recomputed and should this requirement decline, cash in excess of that required as commodities margin will be transferred from the commodities side of your account to the securities side.  Likewise, should the commodities margin requirement increase, IB will transfer any available cash from the securities side to the commodities side.  As SIPC insurance is provided to assets on the securities side of your account but not the commodities, this periodic transfer is performed to ensure that your cash balance is afford the greatest protection possible. It should be noted that these cash movements represent journal entries within your account which serve to fully offset each other and therefore have no impact upon the aggregate cash balance within your account (see the Total column within the Cash Report section of the Activity Statement).

Why aren't the trades I made last night showing up on my daily statement?

Overview: 

What constitutes a trading session, or "day", varies depending on the product being traded.  This is especially true of futures/commodities. 

Background: 

IBKR provides daily statements that report all activity for an account each day.  Trades which occur after the official close of a day for a certain product would not be included in the previous day's statement.  To clarify, here is an example:

You are trading ES futures on 2/15/09.  The ES futures contract begins a new "day" at 15:30 CST.  All of your trades in ES futures prior to 15:30 CST will be shown on your 2/15/09 daily statement.  Those trades which occurred after 15:30 CST on 2/15/09, will not appear on the 2/15/09 daily statement, but rather on the 2/16/09 daily statement.  This is because after 15:30 CST, you are trading ES on the 2/16/09 trade date.  

Syndicate content