On Batch operation (Accounting) menu, it is possible to launch “Outright revaluation…”.
This process calculates revaluation for all Outright transactions, booked and not booked. According to the currency rate at outright value date, gain or loss appears on the general ledger entry generated for revaluation.
Here are some examples (Capital Currency = EUR) :
CASE 1 :
| Currency (Buy) | Transaction Date | Rate | Amount (Buy) | Currency (Sell) | Value Date | Rate | Amount (Sell) | Gain (EUR) | |
|---|---|---|---|---|---|---|---|---|---|
| EUR | 01/01/2018 | 0,8 | 1000000 | GBP | 31/12/2018 | 0,7 | 800000 | 142856,80 |
Rates:
01/01/2018 — 1 EUR = 0,8 GBP / 1 GBP = 1,25 EUR
31/12/2018 — 1 EUR = 0,7 GBP / 1 GBP = 1,428571 EUR
Calculate:
(800000 GBP * 1,428571) – 1000000 EUR = 1142856,8 EUR – 1000000 EUR
= 142856,80 EUR
CASE 2 :
| Currency (Buy) | Transaction Date | Rate | Amount (Buy) | Currency (Sell) | Value Date | Rate | Amount (Sell) | Loss (EUR) | |
|---|---|---|---|---|---|---|---|---|---|
| EUR | 01/01/2018 | 1,2 | 1000000 | USD | 31/12/2018 | 1,3 | 1200000 | 76922.80 |
Rates:
01/01/2018 — 1 EUR = 1,2 USD / 1 USD = 0,833333 EUR
31/12/2018 — 1 EUR = 1,3 USD / 1 USD = 0,769231 EUR
Calculate:
(1200000 USD * 0,769231) – 1000000 EUR = 923077,20 EUR – 1000000 EUR
= – 76922,80 EUR
CASE 3 :
| Currency (Buy) | Transaction Date | Rate | Amount (Buy) | Currency (Sell) | Value Date | Rate | Amount (Sell) | Loss (EUR) | |
|---|---|---|---|---|---|---|---|---|---|
| GBP | 01/01/2018 | 0,8 | 1000000 | EUR | 31/12/2018 | 0,7 | 1250000 | 178571 |
Rates:
01/01/2018 — 1 EUR = 0,8 GBP / 1 GBP = 1,25 EUR
31/12/2018 — 1 EUR = 0,7 GBP / 1 GBP = 1,428571 EUR
Calculate:
(1000000 GBP * 1,428571) – 1250000 EUR = 1142856,8 EUR – 1250000 EUR =
– 142856,80 EUR
CASE 4 :
| Currency (Buy) | Transaction Date | Rate | Amount (Buy) | Currency (Sell) | Value Date | Rate | Amount (Sell) | Loss (EUR) | |
|---|---|---|---|---|---|---|---|---|---|
| GBP | 01/01/2018 | 0,615384 | 1000000 | USD | 31/12/2018 | 0,538461 | 1500000 | 835798.08 |
Rates:
01/01/2018 — 1 GBP = 1,5 USD / 1 USD = 0,666667 GBP
31/12/2018 — 1 GBP = 1,857143 USD / 1 USD = 0,538461 GBP
Calculate:
?
CASE 5 :
| Currency (Buy) | Transaction Date | Rate | Amount (Buy) | Currency (Sell) | Value Date | Rate | Amount (Sell) | Gain (EUR) | |
|---|---|---|---|---|---|---|---|---|---|
| USD | 01/01/2018 | 1,2 | 1000000 | EUR | 31/12/2018 | 1,3 | 8333333.33 | 64102.56 |
Rates:
01/01/2018 — 1 EUR = 1,2 USD / 1 USD = 0,833333 EUR
31/12/2018 — 1 EUR = 1,3 USD / 1 USD = 0,769231 EUR
Calculate:
833333.33 EUR – (1000000 USD * 0,769231) = 833333,33 EUR – 769231 EUR
= 64102,33 EUR
CASE 6 :
| Currency (Buy) | Transaction Date | Rate | Amount (Buy) | Currency (Sell) | Value Date | Rate | Amount (Sell) | Loss (EUR) | |
|---|---|---|---|---|---|---|---|---|---|
| USD | 01/01/2018 | 0,615384 | 1000000 | GBP | 31/12/2018 | 0,538461 | 666666.67 | 1819727.84 |
Rates:
01/01/2018 — 1 GBP = 1,5 USD / 1 USD = 0,666667 GBP
31/12/2018 — 1 GBP = 1,857143 USD / 1 USD = 0,538461 GBP
Calculate:
?
