{"id":5730,"date":"2017-09-29T14:07:43","date_gmt":"2017-09-29T13:07:43","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=5730&#038;lang=en"},"modified":"2017-10-11T13:28:03","modified_gmt":"2017-10-11T12:28:03","slug":"outright-revaluation","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=5730","title":{"rendered":"Outright &#8211; Revaluation"},"content":{"rendered":"<p>On Batch operation (Accounting) menu, it is possible to launch &#8220;Outright revaluation&#8230;&#8221;.<\/p>\n<p>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.<\/p>\n<p>Here are some examples (Capital Currency = EUR) :<\/p>\n<p><strong>CASE 1 :\u00a0<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Currency (Buy)<\/th>\n<th width=\"15\">Transaction Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Buy)<\/th>\n<th width=\"10\">Currency (Sell)<\/th>\n<th width=\"15\">Value Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Sell)<\/th>\n<th width=\"100\"><span style=\"color: #205000;\">Gain (EUR)<\/span><\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">EUR<\/td>\n<td valign=\"top\">01\/01\/2018<\/td>\n<td valign=\"top\">0,8<\/td>\n<td valign=\"top\">1000000<\/td>\n<td valign=\"top\">GBP<\/td>\n<td valign=\"top\">31\/12\/2018<\/td>\n<td valign=\"top\">0,7<\/td>\n<td valign=\"top\">800000<\/td>\n<td valign=\"top\"><span style=\"color: #205000;\">142856,80<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Rates:<\/em><br \/>\n01\/01\/2018 &#8212; 1 EUR = 0,8 GBP \/ 1 GBP = 1,25 EUR<br \/>\n31\/12\/2018 &#8212; 1 EUR = 0,7 GBP \/ 1 GBP = 1,428571 EUR<\/p>\n<p><em>Calculate:<\/em><br \/>\n(800000 GBP * 1,428571) &#8211; 1000000 EUR\u00a0 = 1142856,8 EUR &#8211; 1000000 EUR<br \/>\n= 142856,80 EUR<\/p>\n<p>&nbsp;<\/p>\n<p><strong>CASE 2 :<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Currency (Buy)<\/th>\n<th width=\"15\">Transaction Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Buy)<\/th>\n<th width=\"10\">Currency (Sell)<\/th>\n<th width=\"15\">Value Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Sell)<\/th>\n<th width=\"100\"><span style=\"color: #960000;\">Loss (EUR)<\/span><\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">EUR<\/td>\n<td valign=\"top\">01\/01\/2018<\/td>\n<td valign=\"top\">1,2<\/td>\n<td valign=\"top\">1000000<\/td>\n<td valign=\"top\">USD<\/td>\n<td valign=\"top\">31\/12\/2018<\/td>\n<td valign=\"top\">1,3<\/td>\n<td valign=\"top\">1200000<\/td>\n<td valign=\"top\"><span style=\"color: #960000;\">76922.80<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Rates:<\/em><br \/>\n01\/01\/2018 &#8212; 1 EUR = 1,2 USD \/ 1 USD = 0,833333 EUR<br \/>\n31\/12\/2018 &#8212; 1 EUR = 1,3 USD \/ 1 USD = 0,769231 EUR<\/p>\n<p><em>Calculate:<\/em><br \/>\n(1200000 USD * 0,769231) &#8211; 1000000 EUR = 923077,20 EUR &#8211; 1000000 EUR<br \/>\n= &#8211; 76922,80 EUR<\/p>\n<p>&nbsp;<\/p>\n<p><strong>CASE 3 :<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Currency (Buy)<\/th>\n<th width=\"15\">Transaction Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Buy)<\/th>\n<th width=\"10\">Currency (Sell)<\/th>\n<th width=\"15\">Value Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Sell)<\/th>\n<th width=\"100\"><span style=\"color: #960000;\">Loss (EUR)<\/span><\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">GBP<\/td>\n<td valign=\"top\">01\/01\/2018<\/td>\n<td valign=\"top\">0,8<\/td>\n<td valign=\"top\">1000000<\/td>\n<td valign=\"top\">EUR<\/td>\n<td valign=\"top\">31\/12\/2018<\/td>\n<td valign=\"top\">0,7<\/td>\n<td valign=\"top\">1250000<\/td>\n<td valign=\"top\"><span style=\"color: #960000;\">178571<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Rates:<\/em><br \/>\n01\/01\/2018 &#8212; 1 EUR = 0,8 GBP \/ 1 GBP = 1,25 EUR<br \/>\n31\/12\/2018 &#8212; 1 EUR = 0,7 GBP \/ 1 GBP = 1,428571 EUR<\/p>\n<p><em>Calculate:<\/em><br \/>\n(1000000 GBP * 1,428571) &#8211; 1250000 EUR = 1142856,8 EUR &#8211; 1250000 EUR =<br \/>\n&#8211; 142856,80 EUR<\/p>\n<p>&nbsp;<\/p>\n<p><strong>CASE 4 :<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Currency (Buy)<\/th>\n<th width=\"15\">Transaction Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Buy)<\/th>\n<th width=\"10\">Currency (Sell)<\/th>\n<th width=\"15\">Value Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Sell)<\/th>\n<th width=\"100\"><span style=\"color: #960000;\">Loss (EUR)<\/span><\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">GBP<\/td>\n<td valign=\"top\">01\/01\/2018<\/td>\n<td valign=\"top\">0,615384<\/td>\n<td valign=\"top\">1000000<\/td>\n<td valign=\"top\">USD<\/td>\n<td valign=\"top\">31\/12\/2018<\/td>\n<td valign=\"top\">0,538461<\/td>\n<td valign=\"top\">1500000<\/td>\n<td valign=\"top\"><span style=\"color: #960000;\">835798.08<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Rates:<\/em><br \/>\n01\/01\/2018 &#8212; 1 GBP = 1,5 USD \/ 1 USD = 0,666667 GBP<br \/>\n31\/12\/2018 &#8212; 1 GBP = 1,857143 USD \/ 1 USD = 0,538461 GBP<\/p>\n<p><em>Calculate:<\/em><br \/>\n?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>CASE 5 :<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Currency (Buy)<\/th>\n<th width=\"15\">Transaction Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Buy)<\/th>\n<th width=\"10\">Currency (Sell)<\/th>\n<th width=\"15\">Value Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Sell)<\/th>\n<th width=\"100\"><span style=\"color: #205000;\">Gain (EUR)<\/span><\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">USD<\/td>\n<td valign=\"top\">01\/01\/2018<\/td>\n<td valign=\"top\">1,2<\/td>\n<td valign=\"top\">1000000<\/td>\n<td valign=\"top\">EUR<\/td>\n<td valign=\"top\">31\/12\/2018<\/td>\n<td valign=\"top\">1,3<\/td>\n<td valign=\"top\">8333333.33<\/td>\n<td valign=\"top\"><span style=\"color: #205000;\">64102.56<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Rates:<\/em><br \/>\n01\/01\/2018 &#8212; 1 EUR = 1,2 USD \/ 1 USD = 0,833333 EUR<br \/>\n31\/12\/2018 &#8212; 1 EUR = 1,3 USD \/ 1 USD = 0,769231 EUR<\/p>\n<p><em>Calculate:<\/em><br \/>\n833333.33 EUR\u00a0 &#8211; (1000000 USD * 0,769231) = 833333,33 EUR &#8211; 769231 EUR<br \/>\n= 64102,33 EUR<\/p>\n<p>&nbsp;<\/p>\n<p><strong>CASE 6 :<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Currency (Buy)<\/th>\n<th width=\"15\">Transaction Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Buy)<\/th>\n<th width=\"10\">Currency (Sell)<\/th>\n<th width=\"15\">Value Date<\/th>\n<th width=\"20\">Rate<\/th>\n<th width=\"100\">Amount (Sell)<\/th>\n<th width=\"100\"><span style=\"color: #960000;\">Loss (EUR)<\/span><\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">USD<\/td>\n<td valign=\"top\">01\/01\/2018<\/td>\n<td valign=\"top\">0,615384<\/td>\n<td valign=\"top\">1000000<\/td>\n<td valign=\"top\">GBP<\/td>\n<td valign=\"top\">31\/12\/2018<\/td>\n<td valign=\"top\">0,538461<\/td>\n<td valign=\"top\">666666.67<\/td>\n<td valign=\"top\"><span style=\"color: #960000;\">1819727.84<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>Rates:<\/em><br \/>\n01\/01\/2018 &#8212; 1 GBP = 1,5 USD \/ 1 USD = 0,666667 GBP<br \/>\n31\/12\/2018 &#8212; 1 GBP = 1,857143 USD \/ 1 USD = 0,538461 GBP<\/p>\n<p><em>Calculate:<\/em><br \/>\n?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On Batch operation (Accounting) menu, it is possible to launch &#8220;Outright revaluation&#8230;&#8221;. 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 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72,4,1],"tags":[],"class_list":["post-5730","post","type-post","status-publish","format-standard","hentry","category-accounting","category-demasy","category-non-classe"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5730"}],"version-history":[{"count":15,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5730\/revisions"}],"predecessor-version":[{"id":5803,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/5730\/revisions\/5803"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}