I'd suggest first figuring out what you want in this case, in terms of realizing gains vs not. In general (with some exceptions), most users want their journal to reflect their tax authority's views of the transaction. Of course, if you have multiple tax authorities who each view it differently, it gets complicated.
Making Beancount reflect either a realization or transferring the original cost basis are both possible and reasonably easy. On Monday, February 19, 2024 at 11:05:29 PM UTC-8 matt...@gmail.com wrote: Thanks this is helpful. I guess I was thinking that the gains would not be realized until the commodity was sold. But I supposed it at least makes it easier to realize the gains when exchanging. I was trying to think of a way to transfer the original cost basis, with it being converted somehow. On Monday 19 February 2024 at 14:24:32 UTC bl...@furius.ca wrote: It helps to think of it as all the steps that would be taken by your broker. Say on a transfer you realize the gains: plugin "beancount.plugins.auto" 2024-01-01 * "Add cash" Income:Misc Assets:CA:Brokerage:USAccount:Cash 1000.00 USD 2024-01-01 * "Buy BMO in US" Assets:CA:Brokerage:USAccount:BMO 2 BMO {90.00 USD} Assets:CA:Brokerage:USAccount:Cash 2024-02-18 * "Sell BMO, realized gain" Assets:CA:Brokerage:USAccount:BMO -2 BMO {90.00 USD} @ 94.19 USD Assets:CA:Brokerage:USAccount:Cash 2*94.19 USD Income:CA:Brokerage:USAccount:PnL 2024-02-18 * "Transfer cash equivalent" Assets:CA:Brokerage:USAccount:Cash -2*94.19 USD Assets:CA:Brokerage:CanadianAccount:Cash 2*127.03 CAD @ USD 2024-02-18 * "Sell BMO, realized gain" Assets:CA:Brokerage:CanadianAccount:Cash -2*127.03 CAD Assets:CA:Brokerage:CanadianAccount:BMO +2 BMO {127.03 CAD} It's not super convenient, but you can compress those last three transactions to 2024-02-18 * "Sell BMO, realized gain" Assets:CA:Brokerage:USAccount:BMO -2 BMO {90.00 USD} @ 94.19 USD Income:CA:Brokerage:USAccount:PnL -8.38 USD Assets:CA:Brokerage:CanadianAccount:BMO +2 BMO {127.03 CAD} Assets:CA:Brokerage:CanadianAccount:Cash 2*127.03 CAD @ USD Assets:CA:Brokerage:CanadianAccount:Cash -2*127.03 CAD If you prefer to provide the exchange rate instead it can fill in the P/L: 2024-02-18 * "Sell BMO, realized gain" Assets:CA:Brokerage:USAccount:BMO -2 BMO {90.00 USD} @ 94.19 USD Income:CA:Brokerage:USAccount:PnL Assets:CA:Brokerage:CanadianAccount:BMO +2 BMO {127.03 CAD} Assets:CA:Brokerage:CanadianAccount:Cash 2*127.03 CAD @ 0.74147 USD Assets:CA:Brokerage:CanadianAccount:Cash -2*127.03 CAD Granted it could be better, but it's possible. Thankfully you probably don't have a ton of these... (You could automate the generation of these with a plugin if you do.) On Mon, Feb 19, 2024 at 9:08 AM Martin Blais <bl...@furius.ca> wrote: (But to the straightforward question is: yes, it can.) On Mon, Feb 19, 2024 at 9:08 AM Martin Blais <bl...@furius.ca> wrote: It depends. What happens to your unrealized gain? Does this trigger a realization and stepping up of cost-basis? Or do you carry the unrealized gain to CAD? On Sun, Feb 18, 2024 at 10:11 PM Matt McCormick <matt...@gmail.com> wrote: Some commodities trade on multiple stock exchanges and can be exchanged. How can this transaction be properly recorded? For example: 2024-02-18 * "Transfer BMO" Assets:CA:Brokerage:CanadianAccount:BMO 1 BMO {127.03 CAD} Assets:CA:Brokerage:USAccount:BMO -1 BMO {} @ 94.19 USD This results in a "Transaction does not balance" error due to the different currencies. Is there a way this can be properly recorded? Thanks -- 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+...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/d6516c06-94ff-4066-862f-a8762f1a8b4fn%40googlegroups.com <https://groups.google.com/d/msgid/beancount/d6516c06-94ff-4066-862f-a8762f1a8b4fn%40googlegroups.com?utm_medium=email&utm_source=footer> . -- 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/8d740a50-53a9-4655-aa51-c0f051cae24an%40googlegroups.com.