IB Flex Importer "witholding tax" Part 2

[Nirus2000]

@Nirus2000, I am really sorry about my mistake, I attached the incorrect file and make you all the trouble. I have now checked and please use the screen shoots and test file (ibkr_test) provided and import with "Interactive Brokers: Activity Flex Query in PP. IB importer test file.zip

Originally posted by @mixplus708 in https://github.com/portfolio-performance/portfolio/issues/4062#issuecomment-2157319469

[Nirus2000]

Okay, good! @mixplus708

Answer please the questions we ask you to understand and solve the problem. 👍🏻

Please start writing in complete sentences, substantive, correct and accurate. We are not clairvoyant and do not know everything about all bookings, booking types, essential features or how all banks in the world work or other additional unknown conditions.

• A problem begins with a concrete description.
• Provide a sample calculation. ( a + b = c ) or (a + b - c = d)
• Explain why?!?
• What is the difference between
  • GDV(US36242H1041) PAYMENT IN LIEU OF DIVIDEND - US TAX and
  • GDV(US36242H1041) CASH DIVIDEND USD 0.11 PER SHARE - US TAX
• What is the result so far... (calculation example + minimal example + screenshot)
• How is it correct... (if necessary with calculation example on the example file)
• Explain why?!?
• Why is this correct.
• Why like this and not like that...

We ask you to support us and provide essential information. Full, complete, comprehensible, substantial, mathematical....

[mixplus708]

@Nirus2000 I summarized the issue accordingly and hope I am clearer this time.

Description: The problem is the dividend transaction when accompany with the corresponding “payment in lieu” dividend will not match the taxes correctly via Interactive Brokers: Activity Flex Query.

Calculation and Why: DIVIDEND from GDV– 30% Withholding Taxes 10.86 = Credit Note USD 36.9 - 10.86 = USD 28.53 PAYMENT IN LIEU OF DIVIDEND from GDV – 30% Withholding Taxes = Credit Note USD 18.81 – 5.64 = USD 13.17

The difference between GDV(US36242H1041) CASH DIVIDEND USD 0.11 PER SHARE - US TAX and GDV(US36242H1041) PAYMENT IN LIEU OF DIVIDEND - US TAX : They are 2 parts of the same dividend payment from GDV where the later item is caused by some of my GDV share was lend out to others.

Results so far: In attached ibkr_test.xml file, when imported to PP,

1. the dividend payment of GDV will automatically match the taxes of USD 5.64. – Screenshot_1.
2. The Taxes for payment in lieu should be the USD 5.64 instead of USD 10.86 (USD 18.86 should be in point 1 above). Screeshot_2

The correct input: The correct import should be:

1. the dividend payment of GDV matches the taxes of USD 10.86.
2. The payment in lieu of GDV matches the taxes of USD 5.64

IB importer test file.zip

And thanks again for your helps.