Close Navigation
Learn more about IBKR accounts

Reporting Integration

Interactive Brokers Reporting Integration Tool Guide

This guide provides information for Interactive Brokers clients requesting a reporting data feed from the IBKR generic reporting interface for purposes of integrating that data with third-party software. We provide, on request, reporting data for the following, each in a separate file:

  • P&L
  • Position
  • Security
  • Account
  • Activity
  • Cash Report
  • NAV

Reporting Integration Process

Integrating your IB reporting data with third-party software includes the following steps:

  • Request a reporting data feed from Interactive Brokers by sending an email to reportingintegration@interactivebrokers.com.
  • Interactive Brokers prepares the requested files.
  • The data files are transmitted to the customer via FTP. See Transmitting Files for detailed instructions.
  • You integrate the reporting data files with third-party software.

Reporting File Types

You can choose to receive any of the following types of reporting files.

Start of day (SOD) reporting file types:

  • Account – Contains general account information, including Account ID, Title, etc.
  • Activity – Contains all trade activity, transfers, dividends, etc. as of the report date.
  • Cash Report – Contains cash balances in total, and for the securities and futures segments of your account.
  • NAV Report – Contains the Net Asset Value (NAV) of all positions by asset class (stock, securities options, warrants and bonds), cash and accruals.
  • P&L  – Contains mark-to-mark and short-term (ST) and long-term (LT) realized and unrealized profit and loss information for your account.
  • Positions – Contains positions (including cash and accrual balances) as of the report date.
  • Securities – Contains detailed security information for all assets traded or held.

End of day (EOD) reporting file types:

  • Trade Confirms – Contains trade activity.

See File Layouts for detailed descriptions of the contents of each type of file.

Requesting a Reporting Data Feed

When you request a reporting data feed from Interactive Brokers, your email must contain the following information:

  • Include the text “I would like to integrate my Interactive Brokers reporting data with _______.” Fill in the blank with the name of the software vendor.
  • The software vendor’s contact information.
  • Your Interactive Brokers Account ID.
    If you are a Master Account User (for example, a Financial Advisor), include the Account IDs of all of the client and/or sub accounts for which you would like reporting data.
  • The Reporting File Types you are requesting.
  • Delivery information: Tell us how you want the files delivered. IB can host the files on our FTP/sFTP site, can upload them to your FTP/sFTP site, or can make them available for download. Include your PGP Public Key for file encryption. See Transmitting Files for detailed instructions.
  • Selected options. See Configuring Reporting Data Files for detailed instructions.

Note that the date of the reporting data is always the last business day. Typically there is no data available for New Year’s Day.

File Naming Convention

By default, all reporting data files are text files (*.txt). You can use a different file name extension (for example, *.csv) as long as you include it with your configuration options. Regardless of the type of reporting file you choose to receive, the file name follows this convention:

<AccountID>_<FileType>_<AsOfDate:yyyyMMdd>.txt

where:

  • <AccountID> is your Interactive Brokers Account ID. This can be replaced by a Third-Party Account Reference, if provided. See Configuring Reporting Data Files for more information on including a Third-Party Account Reference.
  • <FileType> is the type of reporting file: Account, Activity, Positions, or Securities.
  • <AsOfDate:yyyyMMdd> is the “as of” reporting date, in the format yyyymmdd. This is always the last business day.

Examples

U000000_Activity_20100317.txt

This example uses an IB Account ID (U000000), Activity as the file type, and a reporting date of March 17, 2010 (20100317).

XYZCorp_Bookkeeping_20100317.txt

This example uses a Third Party Account Reference (“XYZCorp”) instead of your IB Account ID, a custom value of “Bookkeeping” for the file type (instead of Activity), and a reporting date of March 17, 2010 (20100317)

Configuring Reporting Data Files

When you request IB reporting data, you can configure the features listed below. You must include your configuration options in your request email so that we can create the files correctly.

  • File Type: You can choose one or more of these file types: Account, Activity, Cash Report, NAV, P&L, Positions, Securities, and Trade Confirms.
    If you choose the Activity file, you can also include summarized trade data. You can summarize trade data by symbol – for each symbol, there will be one record for buys and one record for sells, if applicable. For advisors and brokers, client fees are also summarized at the account level.
  • If you choose the Positions file, you can choose additional levels of detail called Tax Lots and/or Open Dividend Accruals.
  • Preferred Version – This is the version of the report fields. The default is 1.0. As we update our report fields, the Version will also be updated (for example, 1.0 will be updated to 1.1).
  • Field Delimiter – Specify pipe or comma. If a data field contains a delimiter character, the data will be wrapped in double quotes. This option is required.
  • Date Format – Indicates how dates will appear in the report data. The default date format is yyyymmdd but you can specify whatever date format you prefer. For example, you could request that the date format be mmddyyyy.
  • Number Format – Indicates how numbers will appear in the report data. The default number format is ###0.#########.
  • Third Party Account Reference – If you provide this information, it will be used in the file names and header records instead of your IB Account ID. This option is not required.
  • Include Header/Trailer Records – Specify whether or not you want header and trailer records included in the report data. If you want header and trailer records, they will be included in ALL reporting file types.
  • Include Column Header – Specify whether or not you want column headers included in the report data files.
  • Use PGP Encryption for FTP/sFTP- Required for the reporting data files. You must provide IBKR with your Public Key and files will be encrypted using the key.
  • File name extension – Specify the file name extension of your data files. For example, *.csv. The default value is *.txt.

You do not have to request all of the above configuration options. The default value will be used for any configuration option you do not request.

Use line feed (LF) as the end-of-line character.

Transmitting Files

Report data files can be delivered via FTP or sFTP (or Web Service is alternatively available), options outlined below:

  • IBKR hosted Plain FTP (port 21 with PGP encryption)
    • IB will provide host, username, password.
    • You will provide IB with a PGP public key.
  • IB hosted sFTP (port 22 with PGP encryption)- uses key-based authentication
    • IB will provide host, username, and directory
    • You will provide IB with RSA key for key-based authentication and IP address(es) you will be connecting from.
  • Third-party hosted Plain FTP (port 21 with PGP encryption)
    • You will provide host, username, password, directory.
    • You will provide IB with PGP public key.
  • Third-Party hosted sFTP (with PGP encryption). You will provide IBKR with-
    • Host, username, directory, port.
    • IB will provide RSA key (for key-based authentication) and IP address to white-list.
  • Web Service
    • We will provide additional details via email.

Tell us in your request email to reportingintegration@interactivebrokers.com your delivery preference and we will assist with setting up the configuration.

If you request delivery of report data files as downloadable files, the files will be available from the Activity Downloads page, which you access from the Third-Party Reports menu in Client Portal.

File Layouts

This chapter describes the layout of each reporting file. The following topics are included:

Start of day (SOD):

End of day (EOD):

The Version column in the file layout tables indicates the version number when a field first appeared.

See Sample Files in the next chapter for samples of reporting files.

Account File Layout

Some items in the Account file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
File TypeAlphanumeric1.0Account (configurable)
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

Account Record

ColumnTypeVersionComments
TypeAlphanumeric1.0D
AccountIDAlphanumeric1.0Account number
AccountTitleAlphanumeric1.0Full account title
StreetAlphanumeric1.0Street address
Street2Alphanumeric1.0Additional street address
CityAlphanumeric1.0City
StateAlphanumeric1.0State
ZipAlphanumeric1.0Postal code
CountryAlphanumeric1.0Country
AccountTypeAlphanumeric1.0Values will be one of:
– Individual (Single)
– Institution Master
– Institution Client
– Advisor Master
– Advisor Master Consolidated
– Advisor Client
– Broker Master
– Broker Master Consolidated
– Broker Client
– Fund Advisor (also known as Fund Investment Manager)
CustomerTypeAlphanumeric1.0Values will be one of:
– Individual
– Joint
– Trust
– IRA
– Corporate
– Partnership
– Limited Liability Corporation
– Unincorporated Business
– IRA Traditional Rollover
– IRA Traditional New
– IRA Traditional Inherited
– IRA Roth New
– IRA Roth Inherited
– IRA SEP New
– IRA SEP Inherited
BaseCurrencyAlphanumeric1.0Base Currency of the account
MasterAccountIDAlphanumeric1.6 
VanAlphanumeric1.6Virtual Account Number
CapabilitiesAlphanumeric1.7Account Capabilities: Cash, Margin, Portfolio Margin
TradingPermissionsAlphanumeric1.7Asset class Note: Excluded from versions 1.98 and above.
AliasAlphanumeric1.8Account alias
PrimaryEmailAlphanumeric1.9Email address
DateOpenedAlphanumeric1.92Date account was opened (date format configurable)
DateClosedAlphanumeric1.92Date account was closed (date format configurable)
DateFundedAlphanumeric1.98Date account was funded (date format configurable)
IBExecutionAlphanumeric1.97 
IBPrimeAlphanumeric1.97 
AccountRepresentativeAlphanumeric1.98Account Representative
DefaultTaxBasisElectionAlphanumeric1.992DefaultTaxBasisElection
Values are:
– FI (First In, First Out)
– LIFO (Last In, First Out)
– ML – Maximize Losses
– HC – Highest Cost tax lot-matching method
– MLG – Maximize Long-Term gain tax lot-matching method
– MLL – Maximize Long-Term loss tax lot-matching method
– MSG – Maximize Short-Term gain tax lot-matching method
– MSL – Maximize Short-Term loss tax lot-matching method
– SL – Specific Lot tax lot-matching method
IBKREntityAlphanumeric1.992 

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

Activity File Layout

Some items in the Activity file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
File TypeAlphanumeric1.0Activities (configurable)
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

Activity Record

ColumnTypeVersionComments
TypeAlphanumeric1.0D
AccountIDAlphanumeric1.0Account number
ConIDNumeric1.0Internal unique identifier for all asset types.
Full asset information can be found in the Security File Layout. Empty for Asset Type CASH.
SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
SymbolAlphanumeric1.0Empty for Asset Type CASH
BBTickerAlphanumeric1.91Bloomberg ticker
BBGlobalIDAlphanumeric1.94Bloomberg Global ID. Note: Limited to 1.94-1.993
FIGIAlphanumeric1.994Bloomberg Global ID. Note: Limited to 1.994 and greater
SecurityDescriptionAlphanumeric1.9Description of the security
AssetTypeAlphanumeric1.0For more information, see Asset Types.
CurrencyAlphanumeric1.0Currency of the asset
BaseCurrencyAlphanumeric1.0Base currency of the account
TradeDateAlphanumeric1.0CCYYMMDD (date format configurable)
Note: Clearing trade date (per local exchange) in versions 1.993 and greater
TradeTimeAlphanumeric1.9Time of the trade, in HH:mm:ss format Note: Limited to version 1.9-1.992
DateTimeAlphanumeric1.993The Execution Date and Time (CCYYMMDD HH:mm:ss)
SettleDateAlphanumeric1.0CCYYMMDD (date format configurable)
OrderTimeAlphanumeric1.99 CCYYMMDD HH:mm:ss (date format configurable)
TransactionTypeAlphanumeric1.0For more information, see Transaction Type.
ImpactsCashAlphanumeric1.994Values will be Y or N
QuantityNumeric1.0Note the following regarding sign:
If buy 100 = 100
If sell 100 = -100
If cancel buy = 100
If cancel sell = -100
UnitPriceNumeric1.0 
GrossAmountNumeric1.0Quantity * Price (V1.1 or earlier)
-Quantity * Price (V1.2 or later) 
Note that this is a general formula and does not consider multipliers or notional price (futures), bond pricing (/100), etc.
SECFeeNumeric1.0 
CommissionNumeric1.0Negative amount indicates commission charged.
Positive amount indicates commission rebate.
For Forex trades, the commission is reported in base currency.
TaxNumeric1.0 
NetNumeric1.0Total cash received or delivered.
Not included on Forex trades.
For Futures and CFDs, this is the transaction MTM.
NetInBaseNumeric1.0Total cash received or delivered.
For Futures and CFDs, this is the transaction MTM.
RealizedPLNumeric1.994Realized profit or loss in local currency
RealizedPLInBaseNumeric1.994Realized profit or loss in base currency
TradeIDAlphanumeric1.0Trade ID, unless cancel or correction, then it is the original Trade ID
TaxBasisElectionAlphanumeric1.0For trades, represents the tax basis election.
Values are:
– FI (First In, First Out)
– LIFO (Last In, First Out)
– ML – Maximize Losses
– HC – Highest Cost tax lot-matching method
– MLG – Maximize Long-Term gain tax lot-matching method
– MLL – Maximize Long-Term loss tax lot-matching method
– MSG – Maximize Short-Term gain tax lot-matching method
– MSL – Maximize Short-Term loss tax lot-matching method
– SL – Specific Lot tax lot-matching method
DescriptionAlphanumeric1.0Activity description
FXRatetoBaseNumeric1.1Conversion rate from asset currency to base currency.
ContraPartyNameAlphanumeric1.2For DVP records that represent the contra broker.
ClrFirmIDAlphanumeric1.3For DVP records, the contra broker’s ID.
ExchangeAlphanumeric1.5Included for trades.
MasterAccountIDAlphanumeric1.6The Account ID of the master account.
VanAlphanumeric1.6Virtual Account Number
AwayBrokerCommissionNumeric1.93The away broker’s commission charge.
OrderIDAlphanumeric1.93The IB Order ID.
ClientReferenceAlphanumeric1.95Client note entered by cashiering.
TransactionID 1.96The IB TransactionID.
ExcecutionIDAlphanumeric1.99The IB ExecutionID.
CostBasisAlphanumeric1.99The basis of an opening trade is the inverse of proceeds plus commission and tax amount. For closing trades, the basis is the basis of the opening trade.
FlagAlphanumeric1.99For more information, see Flag Codes
ActionIDAlphanumeric1.992The IB ActionID
LevelofDetailAlphanumeric1.992Executions, Symbol Summary, Orders
OrderTypeAlphanumeric1.994
OrderReferenceAlphanumeric1.994
BrokerageOrderIDAlphanumeric1.994

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

Cash Report File Layout

This optional file type contains cash balances in total, and for the securities and futures segments of your account. This information is similar to what is displayed in the Cash Report section of activity statements.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
File TypeAlphanumeric1.0Account (configurable)
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

Cash Report Record

ColumnTypeVersionComments
TypeAlphanumeric1.0D
AccountIDAlphanumeric1.0Account number
ReportDate 1.96CCYYMMDD (date format configurable)
CurrencyAlphanumeric1.0Currency
BaseSummaryAlphanumeric1.0Is this your base currency (Y or N)
Change in Insured Bank DepositNumeric1.0Changes in amount swept in Insured Bank Deposit Program by currency.
LabelAlphanumeric1.0Description of the item. This matches the line labels in an activity statement.
TotalNumeric1.0Total cash balance of your account.
SecuritiesNumeric1.0Cash balance in the Securities segment of your account.
FuturesNumeric1.0Cash balance in the Futures (Commodities) section of your account.
IBUKLNumeric1.0Cash balance in your IB-UKL account.
PAXOSNumeric1.991Cash balance in your account held at Paxos.

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

Position File Layout

Some items in the Positions file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
File TypeAlphanumeric1.0Positions (configurable)
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

Position Record

ColumnTypeVersionComments
TypeAlphanumeric1.0D for position summary, or
L for tax lot
O for Open Dividend Accruals
AccountIDAlphanumeric1.0Account number
ConIDNumeric1.0Internal unique identifier for all asset types. Full asset information can be found in the Security File Layout.
Empty for Asset Type CASH, INTACC and DIVACC.
SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
SymbolAlphanumeric1.0Empty for Asset Type CASH, INTACC and DIVACC
BBTickerAlphanumeric1.91Bloomberg ticker
BBGlobalIDAlphanumeric1.94Bloomberg Global ID Note: Limited to 1.94-1.993
FIGIAlphanumeric1.994Bloomberg Global ID Note: Limited to 1.994 and greater
SecurityDescriptionAlphanumeric1.9Description of the security
AssetTypeAlphanumeric1.0For more information, see Asset Types.
CurrencyAlphanumeric1.0Currency of the asset
BaseCurrencyAlphanumeric1.0Base currency of the account
QuantityNumeric1.0Note the following regarding sign:
If Long 100=100
If Short 100=-100
QuantityInBaseNumeric1.0Applies only for Asset Type CASH
As of Trade Date. Positive quantity indicates long; negative quantity indicates short.
CostPriceNumeric1.0Average cost price in currency of the asset
CostBasisNumeric1.0Cost basis in the currency of the asset
CostBasisInBaseNumeric1.0Cost basis in the base currency of the account
MarketPriceNumeric1.0Current market price in the currency of the asset
MarketValueNumeric1.0Current market value in the currency of the asset
MarketValueInBaseNumeric1.0Current market value in the base currency of the account
UnrealizedPLNumeric1.994Unrealized profit or loss in local currency
UnrealizedPLinBaseNumeric1.994Unrealized profit or loss in base currency
OpenDateTimeAlphanumeric1.0For tax lot rows, the open date and time. Only applies to tax lot rows.
FxRateToBaseNumeric1.1Conversion rate from asset currency to base currency.
ReportDateAlphanumeric1.4CCYYMMDD Data On Record As-Of Date (date format configurable)
SettledQuantityNumeric1.5Populated for cash records only.
SettledQuantityInBaseNumeric1.5Populated for cash records only.
MasterAccountIDAlphanumeric1.6Account ID of the master account.
VanAlphanumeric1.6Virtual Account Number
AccruedIntNumeric1.93The amount of interest accrued on bonds. Populated for the BOND asset category where available.
OriginatingOrderIDNumeric1.94Order ID of the originating order
MultiplierNumeric1.96Multiplier of position
ActionIDAlphanumeric1.994

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

P&L File Layout

This optional file includes mark-to-mark and short-term (ST) and long-term (LT) realized and unrealized profit and loss information for your account.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
File TypeAlphanumeric1.0PL
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

PL Record

ColumnTypeVersionComments
AccountIDAlphanumeric1.0Account number
InternalAssetIDNumeric1.0Internal unique ID for the asset type.
SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
SymbolAlphanumeric1.0Empty for asset type CASH
BBTickerAlphanumeric1.91Bloomberg ticker
BBGlobalIDAlphanumeric1.94Bloomberg Global ID Note: Limited to 1.94-1.993
FIGIAlphanumeric1.994Bloomberg Global ID Note: Limited to 1.994 and greater
SecurityDescriptionAlphanumeric1.0Security name
AssetTypeAlphanumeric1.0For more information, see Asset Types
CurrencyAlphanumeric1.0Currency of the asset
ReportDateAlphanumeric1.0CCYYMMDD (date format configurable)
PositionMTMNumeric1.0Position mark-to-market profit or loss in local currency
PositionMTMInBaseNumeric1.0Position mark-to-market profit or loss in base currency
TransactionMTMNumeric1.0Transaction mark-to-market profit or loss in local currency
TransactionMTMInBaseNumeric1.0Transaction mark-to-market profit or loss in base currency
RealizedSTNumeric1.0Realized short-term profit or loss in local currency
RealizedSTInBaseNumeric1.0Realized short-term profit or loss in base currency
RealizedLTNumeric1.0Realized long-term profit or loss in local currency
RealizedLTInBaseNumeric1.0Realized long-term profit or loss in base currency
UnrealizedSTNumeric1.0Unrealized short-term profit or loss in local currency
UnrealizedSTInBaseNumeric1.0Unrealized short-term profit or loss in base currency
UnrealizedLTNumeric1.0Unrealized long-term profit or loss in local currency
UnrealizedLTInBaseNumeric1.0Unrealized long-term profit or loss in base currency
FXRatetoBaseNumeric1.992Conversion rate from asset currency to base currency.

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

Security File Layout

Some items in the Security file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
File TypeAlphanumeric1.0Securities (configurable)
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

Security Record

ColumnTypeVersionComments
TypeAlphanumeric1.0D
ConIDNumeric1.0Internal unique identifier for all asset types.
AssetTypeAlphanumeric1.0For more information, see Asset Types.
SecurityIDAlphanumeric1.0ISIN for US and nonUS securities
SymbolAlphanumeric1.0Empty for Asset Type CASH
CUSIPAlphanumeric1.99 
BBTickerAlphanumeric1.91Bloomberg ticker
BBTickerAndExchangeCodeAlphanumeric1.91Bloomberg ticker + exchange code
BBGlobalIDAlphanumeric1.94Bloomberg Global ID. Note: Limited to 1.94-1.993
FIGIAlphanumeric1.994Bloomberg Global ID Note: Limited to 1.994 and greater
DescriptionAlphanumeric1.0Security Name
UnderlyingSymbolAlphanumeric1.0For derivatives
UnderlyingCategoryAlphanumeric1.97For derivatives
UnderlyingSecurityIDAlphanumeric1.97For derivatives
UnderlyingPrimaryExchangeAlphanumeric1.97For derivatives
UnderlyingConIDAlphanumeric1.98For derivatives
MultiplierNumeric1.0 
ExpirationDateAlphanumeric1.0CCYYMMDD Option or Future expiration date (date format configurable)
OptionTypeAlphanumeric1.0P for Put, C for Call
OptionStrikeNumeric1.0Strike price
MaturityDateAlphanumeric1.0Bond maturity date
IssueDateAlphanumeric1.0Note issue date
PrimaryExchangeAlphanumeric1.96The exchange the security is listed on (stocks only).
CurrencyAlphanumeric1.96Currency of the asset
SubCategoryAlphanumeric1.97Available for stocks
IssuerAlphanumeric1.98Security issuer
Delivery MonthAlphanumeric1.99 
PrincipalAdjustFactorAlphanumeric1.992IB calculated principal adjustment for bonds

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

Trade Confirms File Layout

Some items in the Activity file layout are identified as configurable. For more information about configuring these items, see Configuring Reporting Data Files.

Header Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0H
Acct RefAlphanumeric1.0The IB account number (configurable)
Trade ConfirmsAlphanumeric1.0Activities (configurable)
Run DateAlphanumeric1.0CCYYMMDD System Date (date format configurable)
Run TimeAlphanumeric1.0HH:MM:DD in 24 hour format System Clock Time
As of DateAlphanumeric1.0CCYYMMDD Data On Record As-Of Date (date format configurable)
VersionNumeric1.0Version of the file layout used.

Activity Record

ColumnTypeVersionComments
TypeAlphanumeric2.0D
AccountIDAlphanumeric2.0Account number
ConIDNumeric2.0Internal unique identifier for all asset types. Full asset information can be found in the SOD Security File Layout.
Empty for Asset Type CASH.
SecurityIDAlphanumeric2.0ISIN for US and nonUS securities
CUSIPAlphanumeric2.0 
SymbolAlphanumeric2.0Empty for Asset Type CASH.
BBTickerAlphanumeric2.0Bloomberg ticker
FIGIAlphanumeric2.0Bloomberg Global ID
SecurityDescriptionAlphanumeric2.0Security Name
AssetTypeAlphanumeric2.0For more information, see Asset Types.
CurrencyAlphanumeric2.0Currency of the asset
BaseCurrencyAlphanumeric2.0Base currency of the account
MultiplierAlphanumeric2.0 
StrikeNumeric2.0Strike price
ExpirationAlphanumeric2.0CCYYMMDD Option or Future expiration date (date format configurable)
PutCallAlphanumeric2.0P for Put, C for Call
TradeDateAlphanumeric2.0CCYYMMDD (date format configurable)
TradeTimeAlphanumeric2.0Time of the trade, in HH:mm:ss format
SettleDateAlphanumeric2.0CCYYMMDD (date format configurable)
TransactionTypeAlphanumeric2.0For more information, see Transaction Type.
QuantityNumeric2.0Note the following regarding sign:
If buy 100 = 100
If sell 100 = -100
If cancel buy = 100
If cancel sell = -100
UnitPriceNumeric2.0 
GrossAmountNumeric2.0Quantity *Price* Multiplier
CommissionNumeric2.0Negative amount indicates commission charged.
Positive amount indicates commission rebate.
For Forex trades, the commission is reported in base currency.
BrokerExecutionCommissionNumeric2.0The total amount of IB execution charge applied to the trade.
BrokerClearingCommissionNumeric2.0The total amount of IB clearing charge applied to the trade.
ThirdPartyExecutionCommissionNumeric2.0The total amount of third party execution charges applied to the trade.
ThirdPartyClearingCommissionNumeric2.0The total amount of third party clearing charges applied to the trade.
ThirdPartyRegulatoryCommissionNumeric2.0The total amount of third party regulatory charges applied to the trade.
OtherCommissionNumeric2.0The total amount of other charges applied to the trade.
CommissionCurrency 2.0The currency denomination of the commission.
TaxNumeric2.0 
ExchangeAlphanumeric2.0Exchange trade was executed
TradeIDAlphanumeric2.0Trade ID, unless cancel or correction, then it is the original Trade ID
OrderIDAlphanumeric2.0The IB Order ID.
DescriptionAlphanumeric2.0Activity description
ClrFirmIDAlphanumeric2.0For DVP records, the contra broker’s ID.
ContraPartyNameAlphanumeric2.0For DVP records that represent the contra broker.
BrokerAccountAlphanumeric2.0For DVP records that represent the contra broker account.
DirectionAlphanumeric2.0For DVP records
TransferredCommissionAlphanumeric2.0For DVP records
TransferredSECFeesAlphanumeric2.0For DVP records
MasterAccountIDAlphanumeric2.0The Account ID of the master account.
VanAlphanumeric2.0Virtual Account Number
ExecutionIDAlphanumeric1.992IB ExecutionID
NetCashAlphanumeric1.992Total Cash received or delivered

Trailer Record

ColumnTypeVersionComments
Record IDAlphanumeric1.0T
Record CountNumeric1.0Including header and trailer

Asset Types

The following table lists all of the asset types referenced in the Activity, Positions, and Securities file layouts.

CodeVersionDescription
BILL1.0Treasury Bills
BOND1.0Bonds (includes corporate and municipal)
CASH1.0Forex
CFD1.0Contracts for Differences
CMDTY1.0Gold or silver (Metals)
CRYPTO1.0Cryptocurrency
DIVACC1.1Dividend Accrual Balance
FOP1.0Future Options
FSFOP1.0Options on Futures (Futures Style)
FSOPT1.0Options (Futures Style)
FUND1.0Mutual Funds
FUT1.0Futures
FXCFD1.0Contract for Difference on forex
FXFWD1.0FX Forwards
IBGNOTE1.0IB Notes
INTACC1.1Interest Accrual Balance
IOPT1.0Structured Products
OPT1.0Equity and Index Options
STK1.0Stocks (includes ADR, ETF)
WAR1.0Warrants

Activity Codes

Transaction Type: The following table lists all of the transaction type codes referenced in the Activity file layouts.

CodeVersionDescription
ADJ1.0Adjustments, including:
– Client Fees
– Commission Adjustments
– Option Cash Settlements
– Position MTM (Futures, CFDs)
– Price Adjustments (Futures, CFDs)
ASSIGN1.0Assignment
BUY1.0Buy
CA1.0Cancel
CFD1.0CFD Interest and Fees
CINT1.0Credit Interest on cash balances
CO1.0Correct
CORP1.0Corporate Actions including splits, mergers, acquisitions, etc.
Summary of the corporate action will be included in the Description field
COVER1.0Cover Short
DCARD1.0Debit/Prepaid Card Activity
DEL1.0Transfer of Securities (outgoing)
DEP1.0Deposit of Funds (including cash transferred in)
DEPH1.0Deposits on Hold
DINT1.0Debit Interest on cash balances and hard to borrow fees
DIV1.0Dividends
DIVACC1.1Dividend Accrual Activity
DIVR1.0Dividend Reinvestment
DVPCA1.2Cancelled DVP
DVPIN1.2Incoming DVP
DVPOUT1.2Outgoing DVP
EXE1.0Exercise
EXP1.0Expire
FRTAX1.0Foreign Tax Withholding
GEA1.0Expiration or Assignment resulting from offsetting positions
INSDEP1.97Insured Bank Deposit Interest
INSDEPACC1.97Insured Bank Deposit Interest Accrual
INSDEPXFR1.97Insured Deposit Transfer
INTACC1.1Interest Accrual Activity
INTP1.0Investment Interest Paid (from Bonds, Notes)
INTR1.0Investment Interest Received (from Bonds, Notes)
MFEE1.0Management Fee
OFEE1.0Other Fees including market data, order cancellations, etc.
PIL1.0Payment in Lieu of Dividends
REC1.0Receipt of Securities (incoming)
SCOM1.0Settled Commission
SELL1.0Sell
SHORT1.0Sell Short
STAX1.0Sales Tax (Canada PST/GST/HST)
TTAX1.0Transaction tax records that are reported separately from trades (i.e., daily trading charges).
WITH1.0Withdrawal of Funds (including cash transferred out)

Flag Codes

Flag related to Corporate Action transaction type (CORP) and Unbooked Trades referenced in the Activity file layouts.

Flag Codes Description
ORAsset Purchase
BCBond Conversion
BMBond Maturity
CDCash Dividend
HDChoice Dividend Delivery
HIChoice Dividend Issue
CCContact Consolidation
CAContract Soulte (a type of cash settlement)
COContract Spin Off
CSContract Split
CIConvertible Issue
CPCoupon Payment
DWDelist Worthless
DIDividend Rights Issue
EDExpire Dividend Right
FAFee Allocation
FSForward Split
GVGeneric Voluntary
ICIssue Change
FIIssue Forward Split
TCMerger
PCPartial Call Issue
RSReverse Split
PIShare Purchase Issue
SOSpin Off
SDStock Dividend
RISubscribable Rights Issue
SRSubscribe Rights
TMTbill Maturity
TITender Issue
UBUnbooked Trades
UEUnknown Event
TOVoluntary Conversion

Currency

Available currencies that can populate in data files:

Currency FieldDescription
AUDAustralian Dollar
GBPBritish Pound
CADCanadian Dollar
CNHChinese Offshore Yuan
CZKCzech Koruna
DKKDanish Krone
EUREuro
HKDHong Kong Dollar
HUFHungarian Forint
ISLIsraeli Shekel
JPYJapanese Yen
KRWKorean Won
MYRMalaysian Ringgit
MXNMexican Peso
NZDNew Zealand Dollar
NOKNorwegian Kroe
PLNPolish Zloty
SARSaudi Riyal
SGDSingapore Dollar
ZARSouth African Rand
SEKSwedish Krone
CHFSwiss Franc
TRYTurkish Lira
AEDUnited Arab Emirates Dirham
USDUnited States Dollar

Sample Files

Please reach out to reportingintegration@interactivebrokers.com to request the latest sample files.

IBKR Campus Newsletters

This website uses cookies to collect usage information in order to offer a better browsing experience. By browsing this site or by clicking on the "ACCEPT COOKIES" button you accept our Cookie Policy.