Foreign Currency Valuation and Open Item Revaluation at Period-End

Explanation

Foreign currency valuation (FCV) is one of the most common and most misunderstood period-end activities in FI. Any company that holds open items, bank balances, or GL account balances in a currency other than the local (company code) currency must revalue those balances at the closing rate to comply with accounting standards such as IFRS and local GAAP. Without this step, the balance sheet would misstate the true value of receivables, payables, and cash positions. The process relies on a valuation method configured in Customizing, which defines the valuation procedure (lowest value principle, always valuate, or reset), the document type used for the valuation posting, and whether the valuation is reversed at the start of the next period. Exchange rate types (commonly a closing rate type distinct from the daily transaction rate type) are maintained in the exchange rate table and must be updated before the valuation run, otherwise the program will either fail for missing rates or use a stale rate, both of which are frequent production issues. At runtime, the valuation program selects open items on customer, vendor, and GL accounts that are flagged as relevant for foreign currency management, plus GL account balances held in foreign currency. For open items, the program compares the historical exchange rate at posting to the closing rate and calculates an unrealized exchange gain or loss. For balance sheet GL accounts (e.g., foreign currency bank accounts), the valuation is performed on the account balance itself. The resulting entries post to unrealized gain/loss accounts and, where required, to a balance sheet adjustment account per open item, since the original AR/AP reconciliation account cannot be touched directly. A key design decision is whether valuation differences post to the same account for gains and losses or to separate accounts, and whether the posting is reversed automatically in the following period (typical for open item valuation, since realized gain/loss will be recorded when the item is actually cleared). GL account balance valuation is sometimes not reversed, depending on the valuation method and accounting policy. In S/4HANA, the underlying logic is functionally similar to ECC, but valuation results feed directly into the Universal Journal (table ACDOCA) with full account assignment detail, simplifying reconciliation between FI and CO views. Some organizations also use parallel valuation areas to support multiple accounting principles (e.g., local GAAP vs IFRS) with different valuation methods running in parallel, which is more natively supported in S/4HANA's ledger approach than in classic ECC parallel accounts. Controllers must verify that the exchange rate table is current, that the valuation run is executed for the correct key date and valuation area, and that the reversal posting date is correctly set for the next period so revaluation does not double up. A frequent audit finding is valuation being run on the wrong exchange rate type, understating or overstating currency exposure.

Code example

* Illustrative Customizing view path names (not exact IMG nodes)* 1. Define valuation method:* Method: FCVL - Lowest Value Principle* Valuation procedure: Always valuate (for period-end statutory close)* Document type: SA (valuation posting)* Reversal: X (auto-reverse next period)* Exchange rate type: M (closing rate) vs P (average rate) * 2. Assign accounts for valuation gain/loss:* Expense account (loss): 231000 - Unrealized FX Loss* Revenue account (gain): 231100 - Unrealized FX Gain* Balance sheet adjustment account: 132900 - FX Adjustment - AR * 3. Sample valuation posting logic (conceptual, not ABAP)* Open item: Customer invoice EUR equiv 10,000 at posting rate 1.10 USD/EUR* Closing rate: 1.15 USD/EUR* Valuation difference = (10,000/1.10 - 10,000/1.15) => posted to FX Gain/Loss* Entry:*   Dr/Cr Balance Sheet Adjustment - AR      XXX*   Cr/Dr Unrealized FX Gain/Loss            XXX

Real project scenario

A manufacturing company with USD functional currency has EUR-denominated customer invoices outstanding at month-end. The controller runs the foreign currency valuation program using the closing rate type, but the exchange rate for EUR was not updated for the last business day of the month. The program either errors out on missing rate or uses the prior week's rate, materially understating the EUR exposure. The close is delayed while the rate is corrected and the valuation is rerun, and the initial (incorrect) posting must be reversed first to avoid duplicate unrealized gain/loss entries.

Common mistakes

• Running foreign currency valuation before the period-end exchange rate has been loaded, causing use of a stale or missing rate • Confusing the exchange rate type used for daily postings with the one required for period-end closing valuation • Not setting the valuation posting to auto-reverse, leading to overstated balances carrying into the next period • Posting valuation differences directly to the AR/AP reconciliation account instead of a designated balance sheet adjustment account • Running valuation on the wrong valuation area when parallel accounting principles are in use, mixing local GAAP and IFRS results

Best practices

• Establish a rate-loading checklist and cutoff time before triggering foreign currency valuation each period • Use dedicated unrealized gain/loss accounts separate from realized gain/loss accounts for clean P&L analysis • Configure auto-reversal for open item valuation postings to avoid balance carry-forward errors • Run valuation in test/simulation mode first and review a sample of large-value items before posting • Document valuation method assignments per company code and valuation area, especially where multiple accounting principles are active

Interview angle

Interviewers frequently ask candidates to explain the difference between valuating open items versus GL account balances, why a separate balance sheet adjustment account is needed for reconciliation accounts, and how auto-reversal works. Being able to describe the difference between exchange rate types used for transactional postings versus closing valuation, and how parallel valuation is handled differently in S/4HANA's Universal Journal versus classic ECC parallel accounts, demonstrates practical closing experience beyond configuration screenshots.