# SAP Foreign Currency Valuation (F.05) Gain/Loss Calculator > Source: https://netray.co/tools/sap-foreign-currency-valuation-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Estimate the unrealized exchange rate gain or loss when SAP revalues open foreign currency items at the period-end rate. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP FICO consultant - Group accountant - Treasury analyst ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Open item amount (foreign currency) **Key:** amount_fc **Type:** number **Default:** 250000 **Min:** 0 **Step:** 1000 **Unit:** FC #### Rate at posting (local per 1 FC) **Key:** orig_rate **Type:** number **Default:** 83.1 **Min:** 0 **Step:** 0.01 **Unit:** local/FC #### Closing rate (local per 1 FC) **Key:** closing_rate **Type:** number **Default:** 84.25 **Min:** 0 **Step:** 0.01 **Unit:** local/FC #### Item type **Key:** kind **Type:** select **Default:** 1 **Options:** ##### Receivable / asset **Value:** 1 ##### Payable / liability **Value:** -1 **Outputs:** #### Book value in local currency **Key:** book_lc **Expr:** amount_fc * orig_rate **Format:** currency #### Value at closing rate **Key:** reval_lc **Expr:** amount_fc * closing_rate **Format:** currency #### Change in local value **Key:** diff **Expr:** reval_lc - book_lc **Format:** currency #### Unrealized gain (+) / loss (-) **Key:** gain_loss **Expr:** kind * diff **Format:** currency **Primary:** true **Description:** Receivables gain when the foreign currency strengthens, payables lose. #### Rate movement **Key:** rate_move **Expr:** (closing_rate - orig_rate) / orig_rate * 100 **Format:** percent #### Gain or loss per 1 FC **Key:** per_unit **Expr:** kind * (closing_rate - orig_rate) **Format:** decimal **Chart:** #### Unrealized gain or loss vs closing rate **Type:** line **X:** closing_rate **From:** 78 **To:** 90 **Steps:** 40 **Series:** - gain_loss **Disclaimer:** Rates are quoted as local currency per one unit of foreign currency. Valuation method, rate type, key date and reversal posting in SAP determine real postings. This is an estimate for one item. ## Content **Intro:** At period end SAP revalues open foreign currency receivables, payables and balances at the key date exchange rate and posts unrealized differences, which are usually reversed on the first day of the next period. This calculator shows the size and direction of that adjustment for one item or a representative balance, so you can check posting proposals and plan P&L impact. **Sections:** #### How to use it **Body:** Enter the open amount in the document currency, the exchange rate it was posted at and the closing rate, both as local currency per one unit of foreign currency. Choose receivable or payable. The primary result is the unrealized gain or loss. The chart shows how the result moves as the closing rate changes, which is useful when treasury asks what a one percent currency swing means for the quarter. **Bullets:** - Check the rate type used in the valuation run, such as M or a corporate rate - Convert quote direction if the exchange rate table shows the inverse - Run on totals of an account only if the average posting rate is sensible #### The formula **Body:** Revaluation difference = foreign amount * (closing rate - posting rate). For receivables and assets, an increase in the foreign currency value is a gain. For payables and liabilities, the same increase is a loss because you owe more in local terms. SAP runs the foreign currency valuation (transaction F.05 in classic accounting and the valuation run in the new general ledger) per valuation area and method, posts to configured gain and loss accounts and, optionally, to adjustment accounts on the balance sheet. #### Reading the result **Body:** The sign matters more than the size: confirm your receivable gain posts to the unrealized gain account and the payable loss posts to the corresponding loss account. If the run proposes the opposite sign, check the quotation of the rate table, the item type and whether the account is flagged as an open item account managed in foreign currency. #### Common mistakes **Body:** Entering an inverse rate for one of the two inputs. Forgetting that realized gains and losses arise at settlement, not at valuation. Valuing items already revalued in a prior period without using the new baseline. Using the wrong key date or running valuation before all period-end postings are complete. **Cta:** If your close includes manual rate checks across many currencies, Netray can help build a read-only assistant on top of your SAP finance data. Get in touch to scope it. **Faq:** #### Is the result realized or unrealized? **Answer:** Unrealized. It arises because open items are marked to the closing rate. A realized difference appears when the item is cleared by payment at the actual rate, and SAP posts that separately at clearing. #### Why are payables the opposite sign? **Answer:** A payable in foreign currency costs more local currency when that currency strengthens, so the same rate move gives a loss. For a receivable the same move gives a gain. #### What does the reversal do? **Answer:** Many companies post the valuation with an automatic reversal on the first day of the next period, so that the original document values stay intact. The P&L effect then comes only from the net movement in the period of the valuation. #### Can I use average rates? **Answer:** SAP valuation uses the rate type and key date you configure, usually the closing or month-end rate. Average rates are used for P&L translation in consolidation, so do not mix them with balance sheet valuation. ## Search terms sap foreign currency valuation, sap F.05 calculation, unrealized fx gain loss calculator, sap exchange rate difference, foreign currency revaluation calculator, sap open items revaluation, fx revaluation receivables payables, sap fagl_fcv --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json