Use of lots for gains/losses when using multiple currencies

David T. sunfish62 at yahoo.com
Sat Dec 3 01:42:18 EST 2016


John,

Do you know whether this information is outlined anywhere in the documentation? Your description is particularly clear, and this subject does seem to come up rather regularly…

Cheers,
David

> On Dec 2, 2016, at 8:41 PM, John Ralls <jralls at ceridwen.us> wrote:
> 
> 
>> On Dec 1, 2016, at 4:17 PM, habesz85 <tamas.habon at gmail.com> wrote:
>> 
>> Hello guys,
>> 
>> I just started to adopt trading accounts, and lots in my personal
>> bookkeeping.
>> The reason is, I'm trading with securities, that have a different currency
>> than my base currency.
>> 
>> Let me explain my problem with a real life example;
>> 
>> My base currency: HUF
>> Trading currency involved: EUR
>> 
>> 1. I converted some HUF to EUR - for this I maintain a a separate EUR and
>> HUF technical investment acct
>> <http://gnucash.1415818.n4.nabble.com/file/n4687872/1.png> 
>> 
>> 2. I have bought Securities denominated in EUR - the security has a separate
>> account 
>> <http://gnucash.1415818.n4.nabble.com/file/n4687872/2.png> 
>> 
>> 3. some month later, I have sold the security with capital gains - I
>> received EUR for the securities, what I have transfered back to the EUR
>> Technical account
>> <http://gnucash.1415818.n4.nabble.com/file/n4687872/3.png> 
>> 
>> 
>> My problem - and this is hard to explain so hold tight;
>> 
>> After scrubbing the account with the lot function - Gnucash calculates me
>> the right ammount of capital gain BUT!!!! in the wrong currency. 
>> To be more exact - in my example, my capital gein is 186,55 EUR BUT!!!!
>> gnucash falsely assigns HUF to the ammount 186,55.
>> 
>> What strange to me is, that when I open the scrub menu, I see the value of
>> the security in HUF also, instead of EUR - it should be maintained in EUR.
>> <http://gnucash.1415818.n4.nabble.com/file/n4687872/4.png> 
>> 
>> Do you guys know the solution to this? 
>> 
>> PS: I have tried to maually overwrite the ammounts, did not work - it just
>> created orphan lines
> 
> 
> Tamás,
> 
> The first thing to check is that you have all of your Euro-denominated stock accounts under a Euro-denominated asset account. That's how GnuCash knows what currency to use for pricing when its generating transactions for you.
> 
> If you have a separate Euro-denominated brokerage account you could do it like this:
> 
> Assets:Investment:Brokerage-EUR                                                                               [Type Assets, Currency EUR]
> Assets:Investment:Brokerage-EUR:Stocks                                                                    [Type Assets, Currency EUR]
> Assets:Investment:Brokerage-EUR:Stocks:IShares Core MCSI World UCITS ETF  [Type Stock, Commodity UCITS ETF]
> Assets:Investment:Brokerage-EUR:Cash                                                                      [Type Bank, Currency EUR]
> 
> OTOH if you have only a Hungarian brokerage account in which you're holding EUR stocks you might do it this way:
> Assets:Investment:Brokerage                                                                                          [Type Assets, Currency HUF]
> Assets:Investment:Brokerage:Stocks-HUF                                                                     [Type Assets, Currency HUF]
> Assets:Investment:Brokerage:Stocks-EUR                                                                     [Type Assets, Currency EUR]
> Assets:Investment:Brokerage:Stocks-EUR:IShares Core MSCI Worlkd UCITS ETF [Type Stock, Commodity UCITS ETF]
> Assets:Investment:Brokerage:Cash-HUF                                                                       [Type Bank, Currency HUF]
> Assets:Investment:Brokerage:Cash-EUR                                                                       [Type Bank, Currency EUR]
> 
> Regards,
> John Ralls
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




More information about the gnucash-user mailing list