Position transfer in IBKR HU->IRL - mismatched value

Support Issues
1

Hi,

I imported the transaction history from IBKR, in which I had the account moved from Hungary to Ireland, and therefore a transfer of shares occurred. I noticed that the values of the incoming and outgoing transfer differ significantly, although in my opinion (IMO) they should be identical (here for example 9 shares of ALB).

image
image1920×2273 518 KB

I traced the corresponding rows in the source CSVs and in both the amount is 774,27 (respectively + and -).

HU:

ClientAccountID AccountAlias Model CurrencyPrimary FXRateToBase AssetClass SubCategory Symbol Description Conid SecurityID SecurityIDType CUSIP ISIN FIGI ListingExchange UnderlyingConid UnderlyingSymbol UnderlyingSecurityID UnderlyingListingExchange Issuer IssuerCountryCode Multiplier Strike Expiry Put/Call PrincipalAdjustFactor ReportDate Date DateTime SettleDate Type Direction TransferCompany TransferAccount TransferAccountName DeliveringBroker Quantity TransferPrice PositionAmount PositionAmountInBase PnlAmount PnlAmountInBase CashTransfer Code ClientReference TransactionID LevelOfDetail PositionInstructionID PositionInstructionSetID SerialNumber DeliveryType CommodityType Fineness Weight
Uxxxxx USD 1 STK COMMON ALB ALBEMARLE CORP 4347 US0126531013 ISIN 12653101 US0126531013 BBG000BJ26K7 NYSE ALB US 1 2024-09-24 2024-09-23 2024-09-23;20:26:00 2024-09-24 INTERCOMPANY OUT \– U14878223 \-9 0 -774,27 -774,27 0 0 0 815099853 TRANSFER 0 0

IRL:

ClientAccountID AccountAlias Model CurrencyPrimary FXRateToBase AssetClass SubCategory Symbol Description Conid SecurityID SecurityIDType CUSIP ISIN FIGI ListingExchange UnderlyingConid UnderlyingSymbol UnderlyingSecurityID UnderlyingListingExchange Issuer IssuerCountryCode Multiplier Strike Expiry Put/Call PrincipalAdjustFactor ReportDate Date DateTime SettleDate Type Direction TransferCompany TransferAccount TransferAccountName DeliveringBroker Quantity TransferPrice PositionAmount PositionAmountInBase PnlAmount PnlAmountInBase CashTransfer Code ClientReference TransactionID LevelOfDetail PositionInstructionID PositionInstructionSetID SerialNumber DeliveryType CommodityType Fineness Weight
Uxxxxx USD 1 STK COMMON ALB ALBEMARLE CORP 4347 US0126531013 ISIN 12653101 US0126531013 BBG000BJ26K7 NYSE ALB US 1 2024-09-24 2024-09-23 2024-09-23;20:26:00 2024-09-24 INTERCOMPANY IN \– U9478223 9 0 774,27 774,27 0 0 0 3106237838 TRANSFER 0 0

As a result, in the summary I get an inflated return on investment. Is this an application bug or am I missing something?

2

Hi, transfer data are imported exactly as provided by IBKR.

Generally, it’s best to remove (or not import) these transfer transactions in order to preserve the correct FIFO ordering.

  • go to the Interactive Brokers account level,
  • filter only Transfer-type transactions (from the Show all (Pokaż wszystko) menu above the table),
  • sort by the transaction column — they will then be ordered by date
  • select all transfers from the migration period and delete them
3

Thanks, Rafał, for the quick reply :slight_smile:

I’m actually unsure whether they were imported exactly as provided by IBKR. Because in the CSV files downloaded from IBKR I can find entries with this transfer (matching the date and asset symbol), and there the incoming and outgoing transfer amounts are equal (respectively 774.27 and -774.27), while Capitally shows +1021 and -798.39 for those same dates.

The amount of $1021 appears in the last row for the purchase of these shares (there it happens to be correct), but maybe that’s just a coincidence…

Even if the workaround of deleting the transfers would help here, I have another case where I transferred AT&T shares from mBank. 11 August 2022 – 54 shares for $974.16.

[image]

In the CSV that same entry has an amount of $972.54. I can’t delete this transfer. If it’s taken directly, it should be identical (?), right?

ClientAccountID AccountAlias Model CurrencyPrimary FXRateToBase AssetClass SubCategory Symbol Description Conid SecurityID SecurityIDType CUSIP ISIN FIGI ListingExchange UnderlyingConid UnderlyingSymbol UnderlyingSecurityID UnderlyingListingExchange Issuer IssuerCountryCode Multiplier Strike Expiry Put/Call PrincipalAdjustFactor ReportDate Date DateTime SettleDate Type Direction TransferCompany TransferAccount TransferAccountName DeliveringBroker Quantity TransferPrice PositionAmount PositionAmountInBase PnlAmount PnlAmountInBase CashTransfer Code ClientReference TransactionID LevelOfDetail PositionInstructionID PositionInstructionSetID SerialNumber DeliveryType CommodityType Fineness Weight
Uxxxx USD 1 STK COMMON T AT&T INC 37018770 US00206R1023 ISIN 00206R102 US00206R1023 NYSE 1 2022-08-11 2022-08-11 2022-08-11 2022-08-11 FOP IN -- 91299863 901 54 0 972,54 972,54 0 0 0 343581605 TRANSFER 0 0
4

I’m trying to upload a screenshot regarding AT&T, but the site refuses to accept media files…

5

Ok, if it’s different in the file, then there might be a bug in handling transfers from IBKR, or something may have changed in the files. If you can, please send me a sample file (a fragment from just that one day is enough) to support@mycapitally.com – I’ll check it and fix it.

If you have only this one transfer, you can of course adjust the transaction manually without waiting for the fix.