Hi, Thank you very much, I got confused by this: https://docs.google.com/document/d/1dW2vIjaXVJAf9hr7GlZVe3fJOkM-MtlVjvCO1ZpNLmg/edit (Beancount - Comparison / Differences) which made me think that currency transactions should never use the cost functionality.
It looks like the average cost booking method has also been implemented in the mean time, so I can do it like this without having to bother about lots (which I don't care about) 2017-06-01 * Assets:CHF -30 CHF Assets:USD 20 USD { 1.5 CHF } 2017-07-01 price USD 1.7 CHF 2017-08-01 * Assets:USD -10 USD { * } @ 2 CHF Assets:CHF 40 CHF Income:USDTrading > Hi Patrick, > > in order to compute PnL, you need to provide cost instead of price: > > > 2017-06-01 * "Buy USD" > Assets:CHF -30 CHF > Assets:USD 20 USD { 1.5 CHF } > > 2017-07-01 price USD 1.7 CHF > > 2017-08-01 * "Sell USD" > Assets:USD -20 USD { 1.5 CHF } @ 2 CHF > Assets:CHF 40 CHF > Income:PnL > > > This way you could see a realized PnL of (2 CHF - 1.5 CHF) * 10 = 5 CHF > in the account Income:PnL. > > To compute unrealized PnL, you could enable a built-in plugin: > > > plugin "beancount.plugins.unrealized" "Unrealized" > > > This way you could see an unrealized PnL in Assets:CHF:Unrealized. > > > See official documentation for more information: > https://docs.google.com/document/d/1WjARst_cSxNE-Lq6JnJ5CC41T3WndEsiMw4d46r2694/edit > > > > 2017-09-18 11:14:22 patrick via Beancount <beancount@googlegroups.com>: >> Hi, >> >> I've now tried to search for this for quite a bit but somehow I'm not >> finding the right stuff or maybe not >> understanding it right and I hope someone can help me. >> >> I would like to separate the currency gains from other income and would like >> to also differentiate between realized and >> unrealized gain. >> >> Let's take the following example >> >> 2017-06-01 * "Buy USD" >> Assets:CHF -30 CHF >> Assets:USD 20 USD @ 1.5 CHF >> >> 2017-07-01 price USD 1.7 CHF >> >> 2017-08-01 * "Sell USD" >> Assets:USD -20 USD @ 2 CHF >> Assets:CHF 40 CHF >> >> >> • On 2017-07-01 I would have an unrealized currency gain of 4 CHF, how >> would I see this? >> • On 2017-08-02 I would have a realized currency gain of 10 CHF, how would >> I set this up to see this as income? >> >> >> One thing I found was >> http://www.mathstat.dal.ca/~selinger/accounting/tutorial.html >> >> Which looked quite interesting to me and seems to have a solution for this >> but I'm struggling with implementing some of >> the details of it. >> I think in my case the concept of "adjusted cost base" seems to be the >> simplest and make sense. >> >> So if I understood that correct I would need to do the following: >> >> 2017-06-01 * >> Assets:CHF -30 CHF >> Income:USDTrading 30 CHF >> Income:USDTrading -20 USD >> Assets:USD 20 USD >> >> 2017-07-01 price BTC 0.30 CHF >> >> 2017-08-01 * >> Assets:USD -20 USD >> Income:USDTrading 20 USD >> Income:USDTrading -30 CHF >> Income:USDTradingRealized -10 CHF >> Assets:CHF 40 CHF >> >> What I get out of this >> >> • If I take the balance of Income:USDTradingRealized with the current >> exchange rate this should reflect my unrealized >> gain >> >> >> A couple of things that confuse me >> >> • This feels somehow "wrong" as I'm no longer using the @ price annotation >> and have this price implicit in the >> difference between the amounts in one currency going into the USDTrading >> and and out of the USDTrading in the other >> currency. >> • I need to manually calculate the -10 CHF realized gain >> • Income:USDTradingRealized could actually be an income or an expense, >> depending on current exchange rates >> >> >> Can anyone help me with this or point me in the right direction? >> >> >> Thanks and Regards, >> Patrick >> >> >> >> -- >> 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 post to this group, send email to beancount@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/beancount/ >> 397c15c6-c5ea-4d9c-917f-60adf03344d4%40googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to beancount@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/5f13874e-ff52-f341-5f5f-ebbac817c978%40ch.tario.org. For more options, visit https://groups.google.com/d/optout.
signature.asc
Description: OpenPGP digital signature