On Fri, May 07, 2021 at 05:51:22PM +0000, James Cook wrote: > On Sun, May 02, 2021 at 06:45:40PM +0100, Caesar Schinas wrote: > > > > > > > On 2 May 2021, at 17:35, James Cook <[email protected]> wrote: > > > > > >> I’ve played with manually “converting” the currencies using “currency > > >> accounts” as described at > > >> https://beancount.github.io/docs/beancount_v3.html#currency-accounts-instead-of-a-single-conversion > > >> > > >> <https://beancount.github.io/docs/beancount_v3.html#currency-accounts-instead-of-a-single-conversion>, > > >> but so far I haven’t managed to convert that currency loss to an actual > > >> loss instead of having it show up as a gain (negative expense or income > > >> value). > > > > > > Can you show an example? > > > > Hmm, well here’s what I’ve got so far… > > The `Equity:Exchange` entries are redundant except to be more specific > > about what’s going on, and could functionally be dropped if the commented > > exchange rates were uncommented. > > Functionally the only change from where I started is the > > `Equity:FXGainLoss` entry. > > > > option "inferred_tolerance_default" "GBP:0.005" > > option "inferred_tolerance_default" "USD:0.005" > > plugin "beancount.plugins.auto_accounts" > > > > 2020-03-31 * "Buy 11 shares of Square" > > Assets:GB:Freetrade:GIA:Cash -482.60 GBP ;@ 1.23390 USD > > Equity:Exchange:GBP 482.60 GBP > > Equity:Exchange:USD -595.48 USD > > Assets:GB:Freetrade:GIA:SQ 11 S_SQ {54.13456 USD} > > > > 2020-11-16 * "Sell 11 shares of Square" > > Assets:GB:Freetrade:GIA:SQ -11 S_SQ {54.13456 USD} @ 175.81000 > > USD > > Equity:Exchange:USD 1933.91 USD > > Equity:Exchange:GBP -1467.08 GBP > > Assets:GB:Freetrade:GIA:Cash 1467.08 GBP ;@ 1.31820 USD > > Income:Investments:PnL -977.88 GBP @ 1.31820 USD > > Equity:FXGainLoss -37.47 GBP @ 1.31820 USD > > > > > > Note that I haven’t yet managed to drop the @ exchange rates on the last > > two postings, even with the `Equity:Exchange` accounts. > > And I haven’t really decided if `Equity` is the right place for that > > `FXGainLoss` account, but it certainly doesn’t make sense to me anywhere > > else or it appears to one a profit, when in fact it’s a loss (albeit a loss > > which is already accounted for in the posting to `Income:Investments:PnL`, > > so all I’m really trying to do is ‘discard’ it to make the entry balance…) > > > > I don't think I completely understand what you're doing. E.g. I'm not > sure where 977.88 GBP comes from. > > I'm certainly no expert, but how I would account for this depends on > which country I'm doing my taxes for. (My plugin tries to do both at > once, at the cost of some added complexity.)
I should emphasize I don't know for sure this is correct. I'm assuming the US wants you to convert each buy and sell to USD at the time of transaction, and similar for UK, because that makes sense to me. (If I'm wrong about the US, someone should let me know soon...) -- James -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/20210507175612.guhg2mmb7zdilj3i%40moth.falsifian.org.
