4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

Quick Summary: Foreign currency revaluation restates open foreign-currency balances at period end and books the unrealized difference through the currency revaluation posting profile. This section covers main account eligibility, the posting profile lookup, simulation and reversal, and a full worked calculation.

---

1. General Ledger Foreign Currency Revaluation Architecture

At the end of an accounting period, foreign-currency denominated monetary balances (such as foreign bank accounts, foreign loans payable, or non-subledger foreign receivables) must be adjusted to reflect the closing spot exchange rate. This process is executed via General ledger > Periodic tasks > Foreign currency revaluation.

+-----------------------------------------------------------------------------+
|                   FOREIGN CURRENCY REVALUATION WORKFLOW                     |
+-----------------------------------------------------------------------------+
|  [1. Identify Accounts]  --> Eligible Main Accounts (Revaluation = Yes)    |
|              |                                                              |
|              v                                                              |
|  [2. Compute Difference] --> (BalanceCur * NewRate) - Current BalanceMST     |
|              |                                                              |
|              v                                                              |
|  [3. Determine Result]   --> Gain (Credit Unrealized) / Loss (Debit Unreal) |
|              |                                                              |
|              v                                                              |
|  [4. Post Voucher]       --> Debit/Credit Main Account vs Unrealized Gain/Loss|
+-----------------------------------------------------------------------------+

Subledger vs. General Ledger Revaluation Boundaries

A critical architectural principle on the MB-310 exam is understanding which revaluation tool to execute for each account type:

---

2. Main Account Eligibility & Revaluation Posting Profiles

Not all general ledger accounts should be revalued. Under IAS 21 / ASC 830, only monetary assets and liabilities (cash, receivables, payables, debt) are subject to periodic revaluation. Non-monetary items (fixed assets, inventory, prepaid expenses, equity) must remain at historical exchange rates.

+-----------------------------------------------------------------------------+
|                    MAIN ACCOUNT REVALUATION CONFIGURATION                   |
+-----------------------------------------------------------------------------+
|  Main Account: 250100 (Foreign Senior Notes Payable - EUR)                  |
|  - Main Account Type: Liability                                             |
|  - Foreign currency revaluation toggle: [ YES ] <--- MANDATORY ELIGIBILITY   |
|  - Exchange rate type: [ CLOSING ] (Optional Override)                     |
+-----------------------------------------------------------------------------+

The "Foreign Currency Revaluation" Toggle

• Located on the General FastTab of the Main accounts form (General ledger > Chart of accounts > Accounts > Main accounts).
• If set to 'No': The main account is completely bypassed during General Ledger foreign currency revaluation, even if the account number is included in the periodic job's query filter.
• If set to 'Yes': The main account's foreign-denominated transaction balances are evaluated and restated by the revaluation engine.

---

3. Revaluation Parameters, Simulation Runs & Reversals

When launching the Foreign currency revaluation periodic job, the accountant configures key calculation parameters:

+-----------------------------------------------------------------------------+
|            PERIODIC REVALUATION PARAMETER DIALOG (GL > Periodic > Reval)     |
+-----------------------------------------------------------------------------+
|  From date:           [ 2026-08-01 ]                                        |
|  To date:             [ 2026-08-31 ]                                        |
|  Date of rate:        [ 2026-08-31 ] (Determines which spot rate to apply)  |
|  Dimension focus:     [ MainAccount_BU_Dept ]                               |
|  Exchange rate type:  [ CLOSING ]                                           |
|  Simulation run:      [ YES ] <--- VALIDATE WITHOUT COMMITTING TO DATABASE  |
|  Records to include:  MainAccount == 250100..250999                         |
+-----------------------------------------------------------------------------+

Key Parameter Explanations

• Date of rate: Specifies the exact calendar date whose exchange rate will be fetched from the designated exchange rate type to recalculate balances.
• Dimension focus: Determines the financial dimension granularity at which balances are revalued and whether gain/loss vouchers will inherit the original transaction dimensions.
• Simulation Run:
  • When 'Yes': Executes the full revaluation algorithm and produces a detailed audit report showing projected gains, losses, and new balances, but does not post any vouchers to the General Ledger.
  • When 'No': Posts live general ledger adjustment vouchers to the Unrealized Gain / Unrealized Loss accounts.

Reversing Historical Revaluations

If a revaluation was run with an incorrect date of rate, erroneous exchange rate type, or incorrect account filter, Dynamics 365 Finance provides an automated reversal feature:

1. Navigate to General ledger > Periodic tasks > Foreign currency revaluation.
2. In the revaluation history grid, select the executed revaluation batch.
3. Click Reverse on the Action Pane.
4. The system automatically creates exact compensating debit/credit vouchers that neutralize the historical unrealized gain/loss postings.

---

4. End-to-End Worked Numerical Example

To understand the dual-currency mechanics and foreign currency revaluation, consider a complete 3-stage accounting lifecycle for US legal entity USMF (Accounting Currency = USD, Reporting Currency = EUR).

Stage 1: Initial Transaction (August 10, 2026)

USMF takes out a foreign currency bank loan of €100,000.00 EUR (Transaction Currency = EUR).

• Spot Exchange Rate on Aug 10: 1 EUR = 1.10 USD
• Accounting Currency Amount ($): $100,000 \times 1.10 = \mathbf{$110,000.00\text{ USD}}$
• Initial GL Voucher Posted:
  • Debit: Foreign Cash Account (110200): $110,000.00 USD (€100,000.00 EUR)
  • Credit: Foreign Notes Payable (250100): $110,000.00 USD (€100,000.00 EUR)

Stage 2: Month-End Revaluation (August 31, 2026)

At month-end, the Euro strengthens against the US Dollar.

• Closing Spot Exchange Rate on Aug 31: 1 EUR = 1.15 USD
• New Valuation of Note Payable: $100,000 \times 1.15 = \mathbf{$115,000.00\text{ USD}}$
• Existing Book Value: $$110,000.00\text{ USD}$
• Unrealized Exchange Loss: $$115,000.00 - $110,000.00 = \mathbf{$5,000.00\text{ USD}}$
• Periodic GL Revaluation Voucher Generated:
  • Debit: Unrealized Foreign Currency Loss (750200): $5,000.00 USD
  • Credit: Foreign Notes Payable (250100): $5,000.00 USD
• Result: Notes Payable balance sheet carrying value is now accurately restated to $115,000.00 USD.

Stage 3: Loan Repayment & Settlement (September 15, 2026)

USMF repays the €100,000.00 EUR loan when the exchange rate has moved to 1 EUR = 1.18 USD.

• Total Cash Paid: $100,000 \times 1.18 = \mathbf{$118,000.00\text{ USD}}$
• Total Realized Loss over original invoice: $$118,000.00 - $110,000.00 = \mathbf{$8,000.00\text{ USD}}$
• Settlement Postings:
  • Debit: Foreign Notes Payable (250100): $115,000.00 USD (Clears carrying balance)
  • Credit: Bank Cash Account (110100): $118,000.00 USD (Actual cash disbursed)
  • Debit: Realized Foreign Currency Loss (750100): $8,000.00 USD
  • Credit: Unrealized Foreign Currency Loss Reversal (750200): $5,000.00 USD (Reverses August unrealized loss)
  • Net P&L Impact in September: $$8,000.00 - $5,000.00 = \mathbf{$3,000.00\text{ Loss}}$ (representing movement from 1.15 to 1.18).

---

5. Step-by-Step Configuration & Execution Walkthrough

+-----------------------------------------------------------------------------+
|                 GL REVALUATION CONFIGURATION & EXECUTION                    |
+-----------------------------------------------------------------------------+
|  1. Enable Main Accounts   --> Set 'Foreign currency revaluation' = Yes     |
|                                                                             |
|  2. Configure Accounts     --> Set Realized/Unrealized Gain & Loss accounts |
|                                                                             |
|  3. Execute Simulation Run --> Run with 'Simulation = Yes', verify report   |
|                                                                             |
|  4. Execute Final Post     --> Run with 'Simulation = No', post vouchers    |
|                                                                             |
|  5. Audit & History        --> Review posted records / Execute Reversal     |
+-----------------------------------------------------------------------------+

Step 1: Enable Main Account for Revaluation

1. Navigate to General ledger > Chart of accounts > Accounts > Main accounts.
2. Select Account 250100 (Foreign Notes Payable).
3. On the General FastTab, toggle Foreign currency revaluation to Yes.
4. Click Save.

Step 2: Configure Revaluation Accounts

1. Navigate to General ledger > Currencies > Currency revaluation accounts.
2. In Main account, select 250100.
3. Populate Unrealized gain account (750150) and Unrealized loss account (750200).
4. Populate Realized gain account (750100) and Realized loss account (750110).
5. Click Save.

Step 3: Run Revaluation in Simulation Mode

1. Navigate to General ledger > Periodic tasks > Foreign currency revaluation.
2. In From date, enter 8/1/2026.
3. In To date, enter 8/31/2026.
4. In Date of rate, enter 8/31/2026.
5. Select Exchange rate type: CLOSING.
6. Toggle Simulation run to Yes.
7. Click Filter under Records to include and filter for MainAccount == 250100.
8. Click OK to view the non-posting simulation preview report.

Step 4: Run Live Posting Revaluation

1. Re-open the form, keep identical parameters, and toggle Simulation run to No.
2. Click OK. The system posts the live revaluation vouchers.

---

6. Exam Traps & Real-World Best Practices

[!WARNING] Exam Trap: Revaluing AP and AR Control Accounts in General Ledger A classic MB-310 exam question tests what happens if an administrator runs General Ledger foreign currency revaluation on Accounts Payable Trade Control (210100) or Accounts Receivable Trade Control (120100). Doing so will generate GL adjustments that do not update the AP/AR vendor/customer open transaction subledgers, causing the GL Trial Balance and the Subledger Aging reports to immediately fall out of balance! Always revalue AP via Accounts payable > Periodic tasks > Foreign currency revaluation and AR via Accounts receivable > Periodic tasks > Foreign currency revaluation.

[!TIP] Consultant Pro-Tip: Automated Revaluation Reversals at Period Open Depending on corporate accounting policy, some enterprises prefer reversing unrealized foreign currency adjustments on the first day of the subsequent month (Period opening reversal). In Dynamics 365 Finance, you can schedule the Foreign currency revaluation job to automatically reverse in the following period by selecting the appropriate revaluation profile method or running the Reverse action on the previous month's batch record.