FI / FICOintermediate

FICO Period-End Closing Part 3: Foreign Currency Valuation in the Close

Key takeaway

Place FX valuation correctly in the close: exchange rate upload and checks, valuation of open items and balances per valuation area, interaction with GR/IR and regrouping, reversal, and reconciling FX gains/losses for management — with a checklist to avoid the usual errors.

Explanation

📌 KEY POINTS
✅ Upload and verify key-date rates before any valuation.
✅ Run FAGL_FCV per valuation area (principle/ledger) in test mode first.
✅ Valuate open items (AR, AP, GL open items) and FC balances (e.g. bank accounts).
✅ Reversal (or delta logic) prevents double counting at payment.
⚠️ Running regrouping before FX valuation can reclassify unvaluated amounts — keep the sequence.

━━━━━━━━━━━━━━━━━━━━
▶ WHERE WE ARE
Part 2 listed the steps. Now FX in detail within the close. (See also the Foreign Currency Valuation topic.)

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

Upload, check completeness, lock.

━━━━━━━━━━━━━━━━━━━━
▶ 2. VALUATION RUNS

Per company code and valuation area; test → update.

━━━━━━━━━━━━━━━━━━━━
▶ 3. SCOPE

Open items, balances, GR/IR where relevant.

━━━━━━━━━━━━━━━━━━━━
▶ 4. SEQUENCE

FX valuation before regrouping and reporting.

━━━━━━━━━━━━━━━━━━━━
▶ 5. ANALYSIS

FX gain/loss by currency and account; explanation for management.

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

Check rates for all currencies.
Run test valuation.
Post and analyse results.

✅ CHECKPOINT: FX results explained by currency movements.

Code example

ABAP Code

===== CHECKLIST =====1 Rates uploaded for key date (OB08) → 2 Test run FAGL_FCV (per valuation area) → 3 Review log (missing rates/accounts)4 Update run → 5 Regrouping (FAGLF101) → 6 FX analysis by currency → 7 Reversal date set

Real project scenario

A company with USD functional currency and EUR/GBP payables saw FX losses jump. Analysis showed the EUR rate had been entered inverted. Adding a rate plausibility check before valuation prevented recurrence.

Common mistakes

Missing/inverted rates.
Wrong sequence.
No test run.
Manual adjustments.
No analysis.

Best practices

Rate checks.
Fixed sequence.
Test first.
Rerun properly.
Analyse by currency.

Interview angle

Questions: "Where does FX valuation sit in the close?", "What checks precede it?", "How do you explain FX results?"
Strong answer: rates, runs per area, scope, sequence, analysis.

Practice this lesson

Quick check

1. What must be checked before running FX valuation at period-end?

2. Why should FX valuation run before regrouping?

3. FX losses jumped because a rate was entered inverted. What control helps?

Interview questions

1. FX results swing unexpectedly each month-end. How do you control FX valuation within the close?

Answer it in your own words first, then compare.

2. A production issue is reported in Period-End Closing. What would you check first, and how would you troubleshoot it systematically?