Why Foreign Currency Revaluation Matters for Multi-Currency Operations
Exchange rates shift constantly throughout the month. A receivable recorded at one rate in early September carries a different value by month-end. The same applies to payables, bank balances, and general ledger entries denominated in foreign currencies. Without updating these values, financial statements reflect stale data that no longer matches economic reality.
Foreign currency revaluation in ERP systems addresses this by recalculating open foreign currency transactions using current exchange rates at period-end. The difference between the original recorded value and the revalued amount becomes an unrealized gain or loss. This process ensures financial statements show accurate positions at month-end, quarter-end, or year-end, which matters for both reporting accuracy and compliance with accounting standards.
Manual revaluation across dozens or hundreds of transactions in multiple currencies creates opportunity for error. Finance teams must identify every open transaction, apply the correct exchange rate for the period, calculate differences, and create journal entries. The process consumes time during period-end closing when finance teams face tight deadlines.
How Onfinity ERP Identifies Transactions for Revaluation
The system scans all open foreign currency transactions across the selected organization automatically. This includes unpaid customer invoices, unpaid vendor invoices, unallocated payments from either customers or vendors, unallocated cash receipts, general ledger journal entries, and bank statement lines in foreign currencies.
Onfinity filters these records based on the accounting schema and organization selected for processing. If the accounting schema uses INR as the base currency, the system identifies every transaction recorded in any other currency—EUR, USD, GBP, or others defined in the system.
Not every account qualifies for revaluation. The system only processes accounts where the foreign currency revaluation flag is enabled in the default account setup. This configuration ensures that only appropriate accounts participate in the period-end foreign currency revaluation process, preventing unnecessary entries on accounts that should not carry revaluation adjustments.
Each transaction appears with full context: business partner name, document type, document number, ledger code, document date, foreign currency, foreign currency amount, and the amount already converted to the reporting currency at the original transaction date.
Calculating Unrealized Gains and Losses: The Onfinity Approach
The calculation compares two amounts. First, the system retrieves the original foreign currency amount and the exchange rate that applied on the document date. This produces the amount already recorded in the base currency. Second, the system applies the exchange rate defined for the revaluation date to that same foreign currency amount.
When these two amounts differ, the difference represents an unrealized gain or loss. If the revaluation date amount is higher, the company has an unrealized gain. If lower, an unrealized loss appears.
For example, a EUR 20.18 payment recorded in September converted to INR 2,299.93 using the September exchange rate. At year-end, when the EUR exchange rate changed, the same EUR 20.18 converted to a different INR amount. The difference of INR 21.39 becomes the unrealized exchange gains losses figure for that specific transaction.
Onfinity applies this logic across every qualifying transaction simultaneously. The system retrieves the correct exchange rate for each currency pair and period from the global currency conversion rate tables maintained in the system. This ensures consistent rate application across all calculations without manual lookups or spreadsheet formulas.
Automated Journal Entry Creation and Posting
Once calculations complete, the system generates a single general ledger journal containing all revaluation entries. Each transaction that produced a gain or loss becomes a journal line within this batch. The journal uses the revaluation date as the accounting date, ensuring the adjustments appear in the correct period.
Debit and credit entries post automatically to the unrealized gain and loss accounts preconfigured in the accounting schema. The system references the business partner and ledger code for each line, maintaining clear visibility into which vendor, customer, or account drove each adjustment.
The generated journal carries a system-assigned document number for audit trail purposes. Finance teams can review the journal before posting, drilling down from each line back to the original transaction to verify the calculation. The consolidated view shows all unrealized exchange gains losses in one place rather than scattered across multiple manual entries.
This automation eliminates manual journal entry creation during period-end closing. Instead of building spreadsheets to track each currency movement and then keying entries into the system, finance teams run the revaluation process and review a complete, calculated journal ready for posting.
Configuration Requirements for Accurate Revaluation
The revaluation process depends on proper system configuration. Currency types must be defined for every foreign currency the organization uses. Global currency conversion rates must be maintained for each period, specifying the exchange rate from each foreign currency to the base currency for that month or quarter.
The accounting schema requires four specific accounts configured in the journal ledger section: realized gain, realized loss, unrealized gain, and unrealized loss accounts. Without all four accounts mapped, the system cannot post revaluation entries correctly.
At the business partner level, default accounting settings must specify which accounts should participate in revaluation. The foreign currency revaluation flag enables the process for that account. Each business partner should have only one account flagged for revaluation. Enabling the flag on multiple accounts for the same partner creates conflicts and produces incorrect results.
When these configurations are missing or incomplete, the system either skips transactions or displays ledger code 00, indicating no valid ledger code mapping exists for that business partner. Proper setup ensures every eligible transaction flows through the period end closing process accurately.
Reporting and Audit Support Built Into the Process
Before creating the journal, finance teams can export all revaluation records to Excel. The export includes every transaction, showing original amounts, revalued amounts, and calculated differences side by side. This supports detailed review and validation before committing the entries.
The system also generates a formal foreign currency revaluation report suitable for audit documentation. This report provides a complete record of which transactions were revalued, the rates applied, and the resulting adjustments.
After posting, users can drill down from journal entries back to the source transactions. Clicking a journal line reveals the original invoice, payment, or bank statement that generated the adjustment. This transparency supports reconciliation and audit inquiries without searching through separate systems or spreadsheets.
All calculations, rates, and resulting entries remain visible in the system with full audit trail. Finance teams can demonstrate how each unrealized gain or loss was derived, which exchange rates applied, and when the revaluation occurred. This level of documentation supports both internal controls and external audit requirements during period end closing process reviews.
See Foreign Currency Revaluation in Action
If your finance team manually calculates currency adjustments each month or struggles to maintain accuracy across multiple currencies, request a demo focused on how Onfinity handles multi-currency revaluation. See the complete workflow from transaction identification through journal posting in a working system.
The video above walks through the entire process in Onfinity ERP, showing how the system identifies open foreign currency transactions, applies exchange rates, calculates differences, and generates journal entries automatically.
Follow us on our LinkedIn page for more insights on ERP workflows and financial process automation.