Let me show what balance I would like to get:
$104.17 Assets:Wallet
$15.83 Equity:Capital Losses
$-120.00 Equity:Opening Balances
-----------------------
$0.00
The algorithm to get such balance.
As we are converting everythign to $, $ values are left as is
and special care is only applied to BYR values.
1. At the initial date calculate $ cost of BYR values according to the
exchange rate at the initial date.
2. Every time a transaction changes BYR account, first revaluate BYR value
according to the excange rate
at this date. The diffenrece between previous $ cost of the BYR value
and its new $ cost
is balanced with Equity:Capital Losses account. This rule applies to
all BYR tranactions:
be it currency exchange or spendings.
3. At the end of the period revaluate the BYR values according to the
exchange rate at this time.
Balance the difference with Equity:Capital Losses.
This approach is an official guideline for accountin in my country, when
company has accounts in foreign currnicies.
And it works, I really lost these $15.83, because initially I was really
worth of $120 and now only of $104.17.
Here is my example journal commented accourding to this algorithm:
P 2012/08/10 01:18:00 $ BYR 10.00
2012/08/01 * Opening Balance
Assets:Wallet BYR 1200 ; $ 120 accoring to the exchange
rate at this date
Equity:Opening Balances
2012/09/01
;; Here we are going to touch BYR value. First revaluate it by the
current exchange rate of 11:
;; 1200/11 = 109.09.
;; The diff with the previous value (109.09 - 120 = -10.91) must be
balanced
;; with Capital Losses account by a fake posting:
;;
;; Equity:Capital Losses $10.91
;;
Assets:Wallet $50 @ BYR 11
Assets:Wallet
;;
;; Hint: BYR remaining value now is 650. 650/11 = $59.09
2012/10/01
;; Again, going to touch BYR. Revaluate it first by the current
exchagne rate:
;; 650/12 = $54.17. The diff with previous value is $59.09 - $54.17 =
$4.92.
;; Fake posting:
;; Equity:Capital Losses $4.92
;;
Assets:Wallet $50 @ BYR 12
Assets:Wallet
;;
;; Hint: BYR remaining value now is 50. 50/12 = $4.17
The balance repeated:
==========================================================================
$104.17 Assets:Wallet
$15.83 Equity:Capital Losses
$-120.00 Equity:Opening Balances
-----------------------
$0.00
Is it possible to have such a report from ledger?
Best regards,
- Anton
--
---
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/groups/opt_out.
