Describing Foreign Currency Valuation

Objective

After completing this lesson, you will be able to explain foreign currency valuation

Foreign Currency Valuation

Two accounting documents showing a balance sheet and profit & loss statement, with various entries including accounts receivable and foreign currency valuation differences. The balance sheet indicates USD 500, EUR 600, and an adjustment account FC with EUR 10, while the profit & loss statement highlights an expense from foreign currency valuation of EUR 10.

If customer or vendor accounts contain open items in a foreign currency, the foreign currency valuation is necessary in FI-GL. The amounts of these open items were translated into the local currency at the time that they were entered using the current exchange rate. The exchange rate is probably different at the time of closing, and, therefore, open items need to be valuated. The valuation cannot be made by a posting to FI-AR or FI-AP because reconciliation accounts cannot be directly posted to. Therefore, the amounts are posted to an adjustment account in FI-GL, which appears in the same line of the balance sheet as the reconciliation account.

Screenshot of a receivables account display showing a customer invoice in foreign currency for 1000 USD with various calculated values and effects due to a change in the exchange rate. Below the table, assumptions, theoretical effects, and accounting consequences are noted.

The preceding figure shows the valuation process with the assumption of a rising exchange rate.

A chart and text discuss the implications of different accounting principles (GAAP and IFRS) on foreign currency valuation of receivables. It includes an example of a USD 1000 receivable and its valuation under varying EUR exchange rates.

The preceding figure shows the valuation process with the assumption of a dropping exchange rate.

The accounting consequence depends on the applied valuation principle:

  • International Financial Reporting Standards (IFRS)
  • United States General Accepted Accounting Principles (US-GAAP)

If your company has to map parallel valuation, open items posted in a foreign currency also have to be addressed. Based on local and international accounting principles, the valuation procedure can be different.

FI-GL covers all important valuation procedures:

  • Always Evaluate

    In this procedure, the items to be valuated have to be entered/reported in the balance sheet with the exchange rate of the current valuation date, no matter if that will mean valuation profits or valuation losses.

  • Lowest Value Principle

    In this procedure, the asset and the liabilities of the balance sheet are treated differently.

    Assets, for example, receivables, will only be valuated with the current exchange rate if the valuated amount will be less than it was at the posting date. If the valuated amount will be higher than the original amount of the posting date, no valuation is needed.

    Liabilities, for example, payables, will only be valuated with the current exchange rate if the valuated amount will be higher than it was at the posting date. If the valuated amount will be lower than the original amount of the posting date, no valuation is needed.

  • Strict Lowest Value Principle

    In this procedure, the valuation is only displayed if the valuation amount on the key date is less than the purchase value in the case of a receivable, and is greater than the purchase value in the case of a payable. That is, there has been a loss due to exchange rate fluctuation. The valuation run automatically uses the date of the last valuation as the comparison date.

FI-GL offers two different solutions to model parallel financial reporting:

  • Account Solution
  • Ledger Solution

FI-GL uses the Ledger Solution to picture the closing activities in the training BR240.

Flowchart and bullet points explain the concepts of valuation run, method assignments, valuation methods, and areas with a differentiation between flexible and fixed method assignments. The diagram illustrates the connection between valuation variant and foreign currency valuation using flexible and fixed method assignments.

You can configure the foreign currency valuation methods and variants in FI-CA customizing via Closing OperationsForeign Currency Valuation.

  • If the different accounting principles have no effect on the valuation of open items, and the valuation is not important for the reclassification, choose Valuation Based on one Account Balancing View.

  • If the system is to consider the valuated open items in the reclassification, choose Valuation Based on Several Account Balancing Views.

  • If the system is to consider the valuated open items in the reclassification, and the inverse postings for the adjustment postings are not to take effect automatically one day after the valuation key date, choose Valuation Based on Several Account Balancing Views with Deferred Inverse Posting.

The Valuation Based on one Account Balancing View setting only allows you to execute transaction FPW1 in combination with a valuation method (fixed method assignment).

The Valuation Based on Several Account Balancing setting and the Valuation Based on Several Account Balancing Views with Deferred Inverse Posting setting only allow you to execute transaction FPW1 in combination with a valuation variant (flexible method assignment).

You can check the Valuation Areas to display different valuation approaches and post to different accounts (Account Solution) or to different ledgers (Ledger Solution) in FI-CA customizing (Define Valuation Areas).

If you use the Ledger Solution, you have to combine a valuation area with the corresponding ledger group to map parallel accounting. The ledger group stands for one ledger or combination of ledgers in FI-GL for the purpose of applying the functions and processes of general ledger accounting to the group as a whole.

An account determination for exchange rate differences is shown, including valuation gains, losses, and balance sheet adjustments. Below, a table displays foreign currency valuation at the end of the month with details like currency, G/L account, ledger group, posting date, and amounts.

If you do not need valuation areas, you can use posting area 0070 to define a balance sheet adjustment account for every G/L account to be evaluated.

Diagram detailing account determination for exchange rate differences by valuation areas, showcasing currency valuation gains, losses, and balance sheet adjustments for account receivables. Specific data includes company code 1010, G/L account 240060, and valuation area YNG, with a foreign currency valuation at the end of the month.

If you use valuation areas, you can use posting area 0071 to define a balance sheet adjustment account for every G/L account to be evaluated.

Execute a Foreign Currency Valuation Run

Business Example

Your company posts documents in foreign currency.

Your company is obliged to evaluate those documents with currency exchange rates.

Note

In this exercise, the value ## should be replaced with your group number.

Task 1: Post a Receivable in Foreign Currency

Steps

  1. Start the SAP Fiori Post Document app (transaction FPE1).

    1. Choose the Document tile group.

    2. Choose the Post Document tile.

  2. Post a receivable of 1000 USD in foreign currency to business partner ac240-##i.

    During posting, change the exchange rate to 0,8.

    Initial Data

    FieldValue
    Document Date15th of last month
    Posting Date15th of last month
    Reconciliation Keyproposed by the system
    Company Code1010
    CurrencyUSD
    Document TypeYM General
    Clearing Reason12 Debit Entry Creation

    BP Item Data

    FieldValue
    Contract Accountac240-##i
    Main Transaction6000 Other Receivable/Credit
    Sub Transaction0010 Other Receivables
    Amount1000
    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose BP Item.

    3. Confirm the daily new reconciliation key, if necessary.

    4. In the Business Partner Items table, enter the values from the BP Item Data table.

    5. Select Enter.

    6. Double-click item 1.

      The local currency amount of 800 EUR is displayed.

      The exchange rate of /1,25 is displayed.

    7. Change the exchange rate from /1,25 to /0,8.

    8. Select Enter.

      The Exchange rate deviates from table rate by 36% message is displayed.

    9. Select Enter to confirm the message.

      The local currency amount changed from 800 EUR to 1250 EUR.

      The local currency amount increased by 450 EUR.

    10. Choose Post.

    11. Note the document number.

    12. Choose Back.

  3. Start the SAP Fiori Display Account Balance app (transaction FPL9).

    1. Choose the Information tile group.

    2. Choose the Display Account Balance tile.

  4. Display the account of business partner ac240-##i using the following data:

    Initial Data

    FieldValue
    Business Partnerac240-##i
    List TypeALLES All Items
    Line Layout013 Line Item Display
    1. On the initial screen, enter the values from the Initial Data table.

    2. Choose Continue to check the basic list.

      The basic list is displayed in EUR and USD.

    3. Choose Back twice.

Task 2: Configure a Valuation Variant Including the Procedure Always Valuate

Steps

  1. Go to the SAP S/4HANA system.

  2. Check the existing valuation methods without changing the settings.

    Which valuation method works with the Always Valuate valuation procedure?

    1. Call transaction FICAIMG to access the FI-CA implementation guide.

    2. Choose Closing OperationsForeign Currency ValuationDefine Methods for Foreign Currency Valuation.

    3. In the Valuation Methods overview, double-click all four variants.

      • The BILM method works with the Always Valuate procedure.
      • The YN03 method works with the Always Valuate procedure.
      • The YN01 method works with the Lowest Value Principle procedure.
      • The YN02 method works with the Strict Lowest Value Principle procedure.
    4. Choose Back.

  3. Check the existing valuation areas without changing the settings.

    Which valuation area transfers its postings to the 0L Leading Ledger ledger group?

    1. Call transaction FICAIMG to access the FI-CA implementation guide.

    2. Choose Closing OperationsForeign Currency ValuationDefine Valuation Areas.

    3. In theValuation Area overview, you find the answer:

      • The 0L Leading Ledger ledger group is assigned to the YNC Customers area.
      • The 0L Leading Ledger ledger group is assigned to the YNG Group area.
    4. Choose Back.

  4. Check which ledger is assigned to the 0L group without changing the settings.

    1. Call transaction /nSPRO to switch to the FI-GL implementation guide.

    2. Choose SAP Reference IMG.

    3. Choose Financial AccountingFinancial Accounting Global SettingsLedgersLedgerDefine Ledger Group.

    4. In the Ledger Group overview, select the 0L Leading Ledger ledger group.

    5. Double-click the Ledger Assignment subfolder.

      Only the 0L Leading Ledger ledger is assigned to 0L Leading Ledger ledger group.

    6. Choose Back twice.

  5. Configure a new valuation variant using the following data:

    Valuation Variant

    FieldValue
    Application AreaS Extended FI-CA
    Valuation Variant KeyV##
    Valuation Variant NameValuation Variant ##

    Valuation Method

    FieldValue
    Company Code1010
    Currency Type10 Company Code Currency
    Valuation MethodYN03 Always valuate, Display per BP
    Valuation AreaYNG Group
    1. Call transaction /nFICAIMG to switch back to the FI-CA implementation guide.

    2. Choose Closing OperationsForeign Currency ValuationDefine Valuation Variants.

    3. In the Valuation Variants overview, choose New Entries.

    4. Enter the values from the Valuation Variant table.

    5. Choose Save.

    6. Select your new entry and double-click the Valuation Methods subfolder.

    7. In the Valuation Methods overview, choose New Entries.

    8. Enter the values from the Valuation Method table.

    9. Choose Save.

    10. Choose Back four times.

Task 3: Execute a Foreign Currency Valuation Test Run

Steps

  1. Start the SAP Fiori Execute Foreign Currency Valuation app (transaction FPW1).

    1. Choose the Closing tile group.

    2. Choose the Execute Foreign Currency Valuation tile.

  2. Execute a foreign currency valuation test run only for business partner ac240-##i.

    A productive run could only be executed without any selection restrictions.

    Selection Data

    FieldValue
    Balance Sheet Key Datelast day of last month
    Company Code1010
    Business Partnerac240-##i
    Valuation VariantV## Valuation Variant ##
    Posting Requesteddo not select
    ALV Displayselect
    1. On the selection screen, enter the values from the Selection Data table.

    2. Choose Execute.

    3. You access the Foreign Currency Valuation list.

      The valuation difference for business partner ac240-##i is displayed.

    4. Choose Back twice.

Log in to track your progress & complete quizzes