Step-by-Step Guide to Creating a Flex Report in Interactive Brokers

Sign in to your Interactive Brokers account.

Open Performance & Reports → Flex Queries, or navigate directly using the Reports page.

In the Activity Flex Query table, click the + button to create a new query.

Enter a name for your report in the required Query Name field.

In the Sections table, select:

Cash Transactions → Dividends, Payment in Lieu of Dividends, Withholding Tax, 871(m) Withholding, Other Income, Brokers Interest Received, Bond Interest Paid, Bond Interest Received, Detail

Then click Select All → Save.

Next, in the Sections table, select:

Corporate Actions → Detail

Click Select All → Save.

Then select:

Grant Activity → Detail

Click Select All → Save.

Next, select:

Trades → Closed Lots, Execution (include Execution if you traded options)

Click Select All → Save.

Set Display Account Alias in Place of Account ID? to Yes.

Click Continue → Create → OK.

You should now see a row with the query name you specified earlier. Click the arrow to the right of the query and select Run.

In the dialog window, choose Period → Custom Date Range and specify the reporting period you want to generate. In most cases, this will be one calendar year.

Click Run and wait for the report to be generated.

Download the resulting XML file and proceed to the next step.