Executing the Foreign Currency Valuation Run: Document Flow, Postings, and Reversal Logic
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 adjustment accounts, and how reversal on the following day works.
Explanation
Once valuation methods, exchange rate types, and account determination are configured, the actual period-end activity is running the foreign currency valuation program against open items (AP/AR/GL) and foreign-currency balance sheet accounts (bank, intercompany loans). This lesson focuses on what happens operationally when that program runs, not on the configuration steps themselves. The valuation run reads all open items in a foreign currency as of the key date, retranslates them using the exchange rate type and rate defined for that date, and compares the result to the value already posted in local currency. If there is a difference beyond any configured tolerance, the system proposes a posting: a debit or credit to an unrealized exchange rate gain/loss account, offset against a balance sheet adjustment account for that specific vendor, customer, or GL line (rather than posting directly to the original reconciliation account, which would corrupt subledger-to-GL reconciliation). A critical design point consultants must understand: these valuation postings are not permanent adjustments to the underlying open item. They represent a point-in-time revaluation that is technically reversed at the start of the next period. In practice this means the valuation document posted on the last day of the period carries a reversal posting date on the first day of the next period, so the balance sheet adjustment nets back to zero and the next valuation run starts fresh from the original transaction currency value. This reversal behavior is what differentiates FX valuation from a permanent currency translation adjustment; failing to explain this to finance stakeholders often causes confusion when they see the balance appear to jump back. The run is typically executed first in test/preview mode, which lets accountants review the list of items being revalued, the exchange rate applied, and the calculated difference before committing to an update run. This preview is an essential control step: it surfaces items with stale or missing exchange rates, items excluded due to incorrect valuation area assignment, or open items in currencies without a maintained rate for the key date, which would otherwise cause the run to skip items silently or, in stricter configurations, cause it to terminate with an error. Integration-wise, the valuation postings flow into the same ledger structure as regular postings. In ECC, this means a document in the FI ledger with corresponding subledger updates. In S/4HANA, the valuation document updates the Universal Journal directly, and because Universal Journal integrates FI and CO in one table, any account assignment inconsistency (such as a GL account requiring a cost center that wasn't defaulted for the adjustment account) will block the run and must be resolved through account assignment defaults rather than after-the-fact correction. Production support scenarios often involve: valuation postings hitting the wrong P&L account because the valuation area or account determination key was misconfigured for a specific currency; the run picking up items that should have been excluded (e.g., items already flagged for individual valuation with a different method); or reversal documents failing to post because the next period was already closed, which requires either reopening the period briefly or adjusting the reversal date strategy.
Real project scenario
At a manufacturing client with intercompany loans denominated in USD held by a EUR-functional entity, the month-end FX valuation run initially produced large unexplained P&L swings. Investigation showed the valuation area was pulling the average rate instead of the closing spot rate configured for balance sheet items. The fix involved correcting the exchange rate type assignment in the valuation method and re-running in test mode for prior periods to confirm the corrected gain/loss figures before posting adjustments in the current open period, with finance sign-off documented before the update run was executed.
Common mistakes
• Running the valuation program directly in update mode without first reviewing the test/preview list, missing incorrect or missing exchange rates. • Assuming valuation postings are permanent adjustments rather than understanding the automatic reversal in the next period. • Posting FX valuation adjustments directly to the main reconciliation account instead of a dedicated balance sheet adjustment account, breaking subledger reconciliation. • Not checking that all relevant foreign-currency GL accounts and open item accounts are included in the valuation run's account/item selection. • Failing to coordinate the reversal posting date with period-close status, causing the reversal document to fail when the next period is already locked.
Best practices
• Always execute the valuation program in test/preview mode first and have a knowledgeable accountant review the proposed postings before the update run. • Document the reversal date strategy and confirm the next period's status before running valuation late in the close cycle. • Use dedicated balance sheet adjustment accounts per valuation area to preserve subledger-to-GL reconciliation integrity. • Reconcile the total valuation adjustment amount against an independent recalculation for at least the largest currency exposures each period. • Maintain a checklist of foreign-currency accounts in scope for valuation and review it whenever new accounts or currencies are introduced.
Interview angle
Interviewers often ask candidates to explain why FX valuation postings reverse automatically and what account is used for the offsetting entry, testing whether the candidate understands the distinction between a temporary revaluation and a permanent currency translation adjustment. They may also probe on how you would investigate a valuation run that produced unexpected P&L impact, expecting a structured answer covering exchange rate type, valuation method, and account determination checks.