Interactive Brokers

• The "Sync now" button loads the new trades, dividends and corporate actions since the last sync. You do not download or upload a file.
• You load the earlier years in one step: IBKR gives the data of the current year and of the four years before it.
• After each sync, you see what was added: the new trades, the trades that Taxify already had, and the trades that you deleted.
• You can use the manual and the automatic import together. Taxify finds a trade that it already has and does not save it again.

1. 1.The automatic import uses the same Activity Flex Query as the manual import. If you have one already, use it.
2. 2.If you do not have one, create it with steps 1 to 3 of the manual import guide: the sections and the settings are the same. The format must be XML.
3. 3.You do not need to change the Period of the query. For each sync, Taxify sets the days of the statement itself.
4. 4.Find the Query ID. It is the number of the query that IBKR shows next to its name in the Flex Queries list. If you do not see it there, open the details of the query (the i icon).

Open the manual import guide (the sections and the settings of the Flex Query)

1. 1.In the IBKR Client Portal, open Performance & Reports → Flex Queries.
2. 2.Find the Flex Web Service Configuration part and open its settings.
3. 3.Enable Flex Web Service Status and save the settings.
4. 4.Click Generate A New Token. Set the validity and the IP address as the table below shows, and generate the token.
5. 5.Copy the token. Also write down the date until which it is valid: Taxify shows the date and warns you before the token expires.

When you generate the token, set:

Flex Web Service Status

enabled

Should Expire After

the longest validity in the list (the default is only 6 hours)

Valid For IP Address

empty – no IP address restriction

1. 1.In Taxify, open Accounts and select your Interactive Brokers account. If you do not have one yet, create it.
2. 2.Go to the Settings tab, to the IBKR sync part.
3. 3.Enter the Flex Query ID, the token and the date until which the token is valid.
4. 4.Click "Connect and test". Taxify asks IBKR for the statement of the last 7 days and saves nothing.
5. 5.Check the result of the test: the access, the account number, the level of detail and the Transfers section. If the Flex Query holds several IBKR accounts, select the one that the Taxify account belongs to.

1. 1.After a good test, Taxify offers the years that it can load. The years that you have not uploaded yet are selected.
2. 2.Keep the earlier years selected. With the FIFO method, a sale is matched with the oldest purchase, which can be several years old.
3. 3.Click "Load the selected years". Taxify loads one year after the other; the Import tab shows the progress.

1. 1.On the Import tab, click "Sync now".
2. 2.Taxify loads the days since the last sync. The page shows the progress and the result at once.
3. 3.The result shows the new trades and dividends, the trades that Taxify already had, and the warnings, if any. The sync history is below the result.

• IBKR issues the token for the period that you select. The default is only 6 hours, so select the longest option in the list.
• Taxify shows the date when the token expires. 14 days before that date, it warns you on the account page and on the account card.
• When the token expires, the sync stops. The loaded trades stay. Generate a new token in IBKR and save it in Taxify; the Query ID does not change.

• Each sync starts 7 days before the end of the one before it. Thus Taxify also catches the trades that IBKR corrects later.
• A trade that Taxify already has is skipped. This is also true for the trades of the files that you uploaded by hand.
• A trade that you deleted in Taxify stays deleted. The sync does not overwrite a trade that you edited.
• If IBKR cancels or corrects a trade later, Taxify warns you and lists the trades. It does not delete anything – you decide.
• If new trades belong to a year with a locked tax report, Taxify warns you. The locked report does not change.
• The IBKR statement holds the data of closed trading days. The trades of today can appear only in the sync of the next day.
• IBKR usually prepares the statement in a few seconds, and longer for a full year. Keep the page open; if you close it, Taxify continues on your next visit to the account.

The token expired

Generate a new token with the longest validity in IBKR, and save it in Taxify on the Settings tab.

IBKR did not accept the token

Probably you generated a new token since, which cancelled the old one, or you did not copy all of the token. Save a valid token in Taxify.

The token is limited to an IP address

Generate a new token and leave the Valid For IP Address field empty.

IBKR does not know a Flex Query with this ID

Check the Query ID. The query must be an Activity Flex Query in XML format, saved in your login.

The Flex Web Service is off

In Flex Web Service Configuration, enable Flex Web Service Status.

The Flex Query holds several IBKR accounts

In the connection test, select the account that the Taxify account belongs to. Or create a separate query for each account.

The trades do not have the level of detail EXECUTION

In the Trades section of the Flex Query, set levelOfDetail to EXECUTION, and test the connection again.

IBKR did not give the statement now

IBKR is busy for a moment. Try the sync again later.