Transactions
The Trades -> Transactions tab shows all raw bookings from the two IBKR Flex imports that are not trade executions. You get every cash movement on your account at a glance - grouped by type and converted to EUR at the daily rate (fxRateToBase from IBKR).
Which booking types do you see?
| Type | Source (Flex XML) | Tax treatment (DE) |
|---|---|---|
| Dividend | CashTransaction type="Dividends" | Investment income (bucket Dividends, fully taxable) |
| Payment in Lieu | CashTransaction type="Payment In Lieu Of Dividends" | Like a dividend but no DBA credit |
| Withholding tax | CashTransaction type="Withholding Tax" | Creditable up to 15 % DBA rate |
| Deposit | CashTransaction type="Deposits & Withdrawals" (positive) | Not a tax event - audit only |
| Withdrawal | same (negative) | Not a tax event |
| Interest paid | CashTransaction type="Broker Interest Paid" | Deductible expense (bucket Other) |
| Interest received | CashTransaction type="Broker Interest Received" | Investment income (bucket Other) |
| Interest accrual | InterestAccrualsCurrency (BASE_SUMMARY) | Aggregated entry |
| FX conversion | FxTransaction | Private sale, only taxable if held > 1 year (§ 23 EStG) |
| FX fee | CashTransaction type="Trans Currency" | Deductible expense |
| Other fee | CashTransaction type="Other Fees" | Deductible expense |
| Stamp/SEC fee | TransactionTax | Deductible expense (usually cents) |
| Corporate action | CorporateAction (spin-off, split etc.) | Spin-off triggers cost basis = 0 |
| Other cash | unclassified CashTransactions | Fallback |
Note: trade executions (open/close options, stock trades) are not shown here but under Trades -> History. Double-booking would be misleading.
Filters
- Period: defaults to year-to-date. You can go back as far as your
Flex query covers (typically 365 days).
- Type: show only one booking type (e.g. dividends only).
- Symbol: show only bookings for a given ticker (e.g. only CMCSA
dividends + withholding tax).
Summary box
Above the list you see for the selected period:
- Per type: count + sum in EUR (signed).
- Net: sum of all types - this is your **cash change from
bookings** (trades are separate).
What if the list is empty?
- **Did you create the Transactions query and enter the ID in
settings?* See the Set up the IBKR Flex import* help topic.
- Are the right sections ticked in the query? Mandatory:
Cash Transactions, Cash Report, Commission Details, Transaction Tax, Interest Accruals, Forex P/L Details.
- Synced already? Cron runs at 06:30 + 18:30 UTC. To trigger now:
Settings -> IBKR data import -> click "Import trade history".
- Period correct? The filter defaults to YTD - if your latest
bookings were last year, change the start date.
Re-import & idempotency
Re-imports are idempotent: known bookings (same transactionID + event_type) are skipped, new ones are added. You can re-run imports any time without risking duplicates.