How can we help?

Understanding the IBKR transaction log

Understanding the IBKR transaction log

My IBKR trades are not appearing in Sharesight

If sold trades are still showing as active, or recent trades are missing, check your token first. Your IBKR token expires once a year and Sharesight stops syncing silently when it does. Check your transaction log below for a "Token is expired" status — if you see it, renew your token. Trades missed during expiry will be automatically recovered once renewed.

For a full checklist of other reasons trades may not match, see Why your portfolio doesn't match your broker.


This article applies to the Interactive Brokers integration only

What is the transaction log?

The transaction log shows the status of trades import by date.

Import date: the date Sharesight sync your trade from Interactive Brokers

Broker: the name of the broker

Status: is either Successful or Unsuccessful

Details: A description of the status


Where can I access transaction log?

You can access it from:

  1. Go to Sharesight account
  2. Click on Settings tab
  3. Click Integrations
  4. Click Transaction log.

Transaction log status and description

StatusDetailsHeader
SuccessfulNo. of trades importedOne or more trades have been imported. Click view to see the transaction details.
UnsuccessfulNo. of trade failedOne or more trades are not imported.
UnsuccessfulToken or query ID is invalidEither the token or the query ID is incorrect.
UnsuccessfulNo valid trades to import for (IBKR Account ID)No trade made for the day. This is not an integration issue or error.
UnsuccessfulToken is expiredYour token needs renewing. Here's how.

Token or query ID is invalid

Make sure both token and query ID (you can locate them in Connections page or go Account > Connections) match what is in your Interactive Brokers account.

In your IBKR account, go to:

  1. Performance & Reports
  2. Third Party Reports
  3. Third-Party Services (gear icon)
  4. Select Sharesight
  5. Save
  6. Copy paste Token & Query ID into Sharesight (Account > Connections > Edit connection)

Still need help?

If your token is renewed but trades are still not syncing, contact our support team.

Last updated 14th May 2026