FI / FICObeginner

FICO Foreign Currency Valuation Part 1: Realized vs Unrealized Exchange Differences

Key takeaway

When a company holds receivables, payables or bank balances in foreign currency, their value changes with exchange rates. Learn exchange rate types, translation at posting, realized differences at payment, unrealized differences at period-end valuation, and why valuations are reversed.

What this complete series covers

Learn Foreign Currency Valuation in a clear, practical sequence — from the basic idea to real project use, troubleshooting, and interview-ready understanding.

Who it is for: Best for SAP consultants, developers, and learners who want a practical understanding of Foreign Currency Valuation.
Prerequisites: Basic SAP S/4HANA navigation and an understanding of the business process are helpful. Configuration or transaction steps require suitable access to a practice or project system.
Final outcome: By the end, you should be able to explain Foreign Currency Valuation clearly, follow the main end-to-end flow, apply it in a project scenario, and troubleshoot the most common issues.

Part 1: FICO Foreign Currency Valuation Part 1: Realized vs Unrealized Exchange Differences
Understand why companies must revalue foreign currency balances at period-end, what master data and organizational settings enable it, and when the process fits into the financial close.
Part 2: FICO Foreign Currency Valuation Part 2: Valuation Methods, Rate Types and Accounts
Learn how valuation methods and exchange rate types are configured, how the valuation program calculates gains and losses, and how the resulting postings flow into the general ledger.
Part 3: FICO Foreign Currency Valuation Part 3: Running the Valuation and Understanding Postings
Explains how the foreign currency valuation program executes at period-end, how it generates valuation documents, how postings hit exchange rate difference and balance sheet adjust

System and release assumptions: Examples focus on SAP S/4HANA. Exact apps, transaction codes, configuration paths, and field names can vary by release and deployment model.

Explanation

📌 KEY POINTS
✅ Documents in foreign currency are translated to local currency using exchange rates (typically rate type M, maintained in OB08).
✅ Realized differences post when an open item is cleared at a different rate (e.g. payment).
✅ Unrealized differences are calculated at period-end valuation for open items and FC balances.
✅ Open item valuations are usually reversed at the start of the next period (or handled by delta logic).
⚠️ Missing or late exchange rates make every valuation wrong — maintain rates before running period-end.

━━━━━━━━━━━━━━━━━━━━
▶ WHAT THIS SERIES COVERS
Part 1: Realized vs unrealized differences
Part 2: Valuation methods, rate types and accounts
Part 3: Running valuation and understanding postings

━━━━━━━━━━━━━━━━━━━━
▶ 1. EXCHANGE RATES

Rate types, OB08, translation at posting.

━━━━━━━━━━━━━━━━━━━━
▶ 2. REALIZED DIFFERENCES

Invoice at one rate, payment at another.

━━━━━━━━━━━━━━━━━━━━
▶ 3. UNREALIZED DIFFERENCES

Period-end revaluation of open items and FC GL balances.

━━━━━━━━━━━━━━━━━━━━
▶ 4. REVERSAL

Avoid double counting when items are cleared later.

━━━━━━━━━━━━━━━━━━━━
▶ 5. ACCOUNTS

Gain/loss and balance sheet adjustment accounts.

━━━━━━━━━━━━━━━━━━━━
▶ STEP BY STEP

Post a USD invoice.
Run valuation at month-end.
Pay next month and compare realized vs unrealized.

✅ CHECKPOINT: total difference = realized at payment after reversal.

Code example

ABAP Code

===== EXAMPLE (local currency EUR) =====Invoice USD 1,000 @ 1.10 → EUR 909.09Month-end rate 1.05 → value EUR 952.38 → unrealized loss EUR 43.29 (payable) — reversed next periodPayment @ 1.08 → EUR 925.93 → realized loss EUR 16.84 ===== TRANSACTIONS =====OB08 exchange rates | FAGL_FCV valuation run

Real project scenario

A mid-size manufacturer with US subsidiaries booked large FX losses because month-end valuation used rates from the previous month. A daily rate upload and a period-end check before valuation fixed it.

Common mistakes

Missing rates.
No reversal/delta.
Confusing realized and unrealized.
Valuating wrong accounts.
Wrong rate type.

Best practices

Automate rate upload.
Use reversal or delta logic.
Explain realized vs unrealized.
Define account scope.
Check rates before close.

Interview angle

Questions: "Realized vs unrealized difference?", "Why reverse valuations?", "Which rate type is used?"
Strong answer: translation, realized at clearing, unrealized at valuation, reversal, rates and accounts.

Practice this lesson

Quick check

1. How do realized exchange rate differences differ from the unrealized differences produced by the period-end foreign currency valuation run?

2. Which type of G/L account is generally excluded from being processed by a foreign currency valuation run because there is nothing to revalue?

3. Month-end FX losses were huge because valuation used last month's rates. What prevents this?

Interview questions

1. What are the core concepts of Foreign Currency Valuation, and how would you explain them clearly in an SAP interview?

Answer it in your own words first, then compare.

2. A company with US subsidiaries reports volatile FX results. Explain realized vs unrealized differences in SAP.