Skip to main content
Interactive Brokers (IBKR) is a brokerage platform supporting stocks, options, futures, currencies, bonds, and funds. Sure connects to IBKR using its Flex Web Service, which lets you export account data through a configured Flex Query. See Transaction history and import limits for initial sync defaults, history limits, and options for older transactions.

​
What is imported

Sure imports the following data from an IBKR Flex report:
  • Holdings with current prices and quantities
  • Cost basis per position
  • Trades, dividends, commissions, and cash deposits or withdrawals
Historical activity is limited to the date range configured in your Flex Query. Sure imports full current holdings plus up to the last 365 days of activity.

​
Setting up Interactive Brokers

​
Step 1: Create an Activity Flex Query in IBKR

  1. In your IBKR Client Portal, navigate to Performance & Reports → Flex Queries.
  2. Click the + icon in the Activity Flex Query section to create a new query.
  3. Name the query (for example, “Sure Sync”).
  4. Enable the following sections and fields:
Account Information: Account ID, Currency Cash Report:
  • Options: None
  • Fields: Currency, Ending Cash
Cash Transactions:
  • Options: Dividends, Deposits & Withdrawals, Detail
  • Fields: Amount, Conid, Currency, FX Rate To Base, Report Date, Transaction ID, Type
Change In Position Value Summary: Currency, End Of Period Value Net Asset Value (NAV) in Base:
  • Options: None
  • Fields: Currency, Report Date, Total
Open Positions:
  • Options: Summary
  • Fields: Asset Class, Conid, Cost Basis Price, Currency, FX Rate To Base, Mark Price, Quantity, Report Date, Security ID, Security ID Type, Side, Symbol
Trades:
  • Options: Execution
  • Fields: Asset Class, Buy/Sell, Conid, Currency, FX Rate To Base, IB Commission, IB Commission Currency, Quantity, Symbol, Trade Date, Trade ID, TradePrice, Transaction ID
  1. Set the following query configuration options:
  1. Save the query and note your Query ID.

​
Step 2: Generate a Flex Web Service token

After saving the query, use the gear icon in the Flex Web Service Configuration section of the Flex Queries page to generate an access token. Copy this token.

​
Step 3: Add the connection in Sure

  1. Go to Settings → Providers.
  2. Find the Interactive Brokers section.
  3. Paste your Query ID and Token into the form fields and save.
  4. Sure begins syncing and discovering your IBKR accounts.

​
Step 4: Set up accounts

After the first sync, discovered IBKR accounts appear in the setup queue. Click Set up accounts in the provider panel to select which brokerage accounts to link and confirm the linkage. You can also link a discovered IBKR account to an existing manual investment account if you already have one in Sure.

​
How balances work

Sure anchors your IBKR account balance on the date of the Flex report, not the date of the sync. The NAV (Net Asset Value) comes from the equity summary in your Flex report and is recorded as of that report’s date. Holdings imported alongside it are also written on that same date. If IBKR delivers a statement with a date older than the most recent balance already on record, Sure records that statement as a historical reconciliation entry on its own date and leaves the newer balance in place. This preserves balance history without walking the account’s reported value backwards. A balance write failure is logged to Settings → Debug against the connection so you can identify and diagnose it.

​
Limitations

  • Historical activity is limited to the report window of your Flex Query. Sure imports up to 365 days of activity based on the query’s configured period.
  • Only investment (brokerage) accounts are supported. Cash accounts and other account types are not imported from IBKR.

​
Troubleshooting

​
No accounts discovered after syncing

If Sure reports no accounts discovered, check that your Flex Query includes the Account Information section with Account ID and Currency enabled. Run a manual sync from Settings → Providers after updating the query.

​
Credentials need attention

If the connection shows a “Credentials need attention” status, your Query ID or Token may have expired or been revoked. Generate a new token from the Flex Web Service Configuration section in IBKR and update the connection in Sure.

​
Only manual investment accounts can be linked

When linking a discovered IBKR account to an existing account, the existing account must be a manual investment account without an existing provider link. Convert the account to manual first if needed.

​
Balance shows unexpected cash or looks incorrect after sync

If your account balance or cash position looks wrong after a sync, the most likely cause is a mismatch between the NAV date in your Flex report and the date Sure recorded it on. This was a known issue that has been fixed: Sure now anchors the balance on the Flex report’s own date rather than the sync date. Run a manual sync from Settings → Providers to pull a fresh report and recalculate the balance.