Hello ledger community,
I'm trying to find the best way to use ledger to track my transactions, and
to calculate capital gains/losses. Is it possible to book commodities in
one currency, sell them in another on a later date, and providing have
ledger correctly calculate the capital gains/losses? For example, in this
made-up transaction, last June I sold 0.75 BTC I'd bought with USD in the
US for euros. You can see below that the bitcoin was actually from two
different purchase lots:
P 2014-11-28 EUR 1.245128 USD
P 2016-06-01 EUR 1.12 USD
P 2016-06-03 EUR 1.14 USD
2016-06-03 * Sell BTC via bitsquare
Assets:Checking:FrenchBank 363.75 EUR
Assets:Crypto:Bitcoin -0.53443347 BTC {482.79 USD} [2014-11-28] @
485.00 EUR
Assets:Crypto:Bitcoin -0.21556653 BTC {531.93 USD} [2016-06-01] @
485.00 EUR
Income:CapitalGains
Where I run ledger bal on that entry, the output ignores the Income account
entirely, as follows:
-0.75000000 BTC
363.75 EUR Assets
363.75 EUR Checking:FrenchBank
-0.75000000 BTC Crypto:Bitcoin
--------------------
-0.75000000 BTC
363.75 EUR
Its as if it doesn't see the lot price information, and therefore doesn't
calculate the capital losses of 53.61 USD.
If I manually convert the euros to dollars as shown below, the bal report
correctly calculates my capital gains (losses).
P 2014-11-28 EUR 1.245128 USD
P 2016-06-01 EUR 1.12 USD
P 2016-06-03 EUR 1.14 USD
2016-06-03 * Sell BTC via bitsquare
Assets:Checking:FrenchBank 319.08 USD
Assets:Crypto:Bitcoin -0.53443347 BTC {482.79 USD} [2014-11-28] @ 425.44
USD
Assets:Crypto:Bitcoin -0.21556653 BTC {531.93 USD} [2016-06-01] @ 425.44
USD
Income:CapitalGains
-0.75000000 BTC
319.08 USD Assets
319.08 USD Checking:FrenchBank
-0.75000000 BTC Crypto:Bitcoin
53.61 USD Income:CapitalGains
--------------------
-0.75000000 BTC
372.69 USD
So, how does ledger deal with commodity lot currencies? Is there a way I
can use my price file of conversion rates to tell ledger to convert the
lots with the rate of their lot purchase date, so that capital gains and
losses get calculated by ledger? Or are inventory bookings limited to
records kept within the same currency (which is my understanding of how
beancount deals with reducing lots)?
--
---
You received this message because you are subscribed to the Google Groups
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
