Yes, IBKR actually confirmed exactly this to me: in the opening transactions, fees get included in the cost bases. not so in the closing transactions. This seems the standard, so rather a general thing than a IBKR-specific issue.
What would be the beancounter's way of handling this? I dont know anything better than manually resolving the "No position matches" errors one at the time by matching and correcting the cost bases. Since my personal investment style does not involve too many individual trades this works for me, but i assume this gets out of hand quickly for more active folks? How is everyone else going about this? On Thursday 9 May 2024 at 04:27:35 UTC+2 just...@gmail.com wrote: This is (probably, I've never looked at what FlexQuery reports) IBKR adding the transaction costs to the cost basis (which is how US tax accounting works). So when you buy something it will have a (very slightly) higher cost basis than whatever the order execution said. On Saturday, April 13, 2024 at 3:30:58 PM UTC+7 nugget....@gmail.com wrote: Hi everyone I recently closed some positions I held at InteractiveBrokers, for which i have a nice API-based ingestion pipeline to beancount. However I noted lots of "No position matches"-Errors. Turns out, the reported cost basis / Trade prices of the closed positions are very slightly off (by a handful of USD-cents) the reported cost basis at purchase. As a result, beancount can't match the lots. 1. Has anyone dealt with this specific issue with IBKR before? 2. What would be your best practice? 1. change the cost basis reported at opening time to match the cost basis at closing time? 2. change the cost basis reported at closing time to match the cost basis at opening time? 3. ...? Below a sample pair of transactions, as i obtain them via the FlexQuery API.note the $172.74 vs. $172.86 Thanks for any hints! nugget 2022-04-08 * "VBR" "BUY 3 VBR @ 172.74 USD" Assets:Invest:IB:VBR 3 VBR {172.74 USD, 2022-04-08} Assets:Invest:IB:USD -518.22 USD ... 2024-03-04 * "VBR" "SELL -3 VBR @ 183.81 USD" Assets:Invest:IB:VBR -3 VBR {172.86 USD, 2022-04-08} @ 183.81 USD -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/bb14c5ac-e98c-4d6f-9bca-f5934044b93an%40googlegroups.com.