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/e5228e5a-519a-4790-a2d3-af5d24527d3bn%40googlegroups.com.
