How to Clean Up Messy Reports in Seconds

Are your Interactive Brokers reports too cluttered to read? In this tutorial, we dive deep into the Operations Tab of "Trades to Sheets." We’ll show you how to filter out the noise and automatically transform complex trade records into a clean, 4-column Google Sheet:

Phase 1: Establish the Connection

Think of this as the "handshake" between your broker and your spreadsheet.

  • Select Destination: Choose the specific Google Sheet or Excel file where you want your data to live.

  • Identify Source: Input your IBKR Query ID to link your brokerage data.

  • Verify: Click Test Connections. Wait for the indicators to turn green to ensure the sync is active.

Entry settings
Entry settings

Phase 2: Configure Entry Settings (The Filters)

Use these settings to act as a "data bouncer," allowing only specific trades into your sheet.

Name Your Operation: Give it a clear title (e.g., Simplified USD Stocks).

Currency: Set to USD to exclude international trades.

Asset Class: Set to STK (Stocks) to ignore options or bonds.

Subcategory: Set to Common to filter out ETFs.

Level of Detail: Set to Execution to see only completed fills.

Import settings
Import settings

Phase 3: Setup Import & Styling

This step determines how the data is organized once it hits your spreadsheet.

Import Method: Choose Insert to ensure the newest trades always appear at the top.

Headers: Check Import Headers so your columns are clearly labeled.

Organization: Tick Sort before import and select Descending by Trade Date. This keeps your history chronological from newest to oldest.

Fields settings
Fields settings

Phase 4: Field Customization

Translate "Broker-speak" into plain English to make your dashboard readable.

Select Fields: Choose the essential data points: Symbol, Trade Price, Quantity, and Trade Date.

Rename Labels: Change the technical names to user-friendly titles:

Change Symbol to Stock Code

Change Trade Price to Price

Change Quantity to Qty

Change Trade Date to Date

Phase 5: Final Execution

Trigger the Sync: Click Reset Hash and then Force Run.

Review: Your spreadsheet will now automatically populate with a clean, formatted version of your trading history.

Pro Tip: Once this is set up, you never have to manually clean your data again. The "Force Run" is only needed for the initial setup; moving forward, the sync handles the heavy lifting.