How to Automate FX Revaluation: A Step-by-Step Guide

For UK finance teams closing the books on foreign-currency transactions, FX revaluation is the step that shows how open overseas balances have changed in GBP at the reporting date. A poorly controlled run can leave a payable, receivable or cash balance hard to explain when it reaches the ledger.

This guide explains how to build an FX revaluation process for a UK month-end close, including scope, rate governance, journal preparation, approval, reversal and reconciliation.

We've also explained how Wise Business can help eligible businesses keep international payment activity ready for the accounting record.

Keep payment records ready for revaluation 🌍

---

Note: Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

Wise services and features are not available in all regions, country and product restrictions apply. Visit wise.com to check availability, and for fee details and terms for your region, visit our pricing page for Wise Business.

This content is provided for general educational and informational purposes only. It is not intended to provide legal, tax, financial, investment or professional advice and should not be relied upon as such.

---

FX revaluation at a glance

What is FX revaluation?

FX revaluation updates the functional-currency value of an eligible balance denominated in a foreign currency. A supplier invoice can be recognised at one exchange rate and remain unpaid at the reporting date. If it is in scope, the functional-currency amount may then need to be updated under the business's accounting policy.

According to IAS 21, The Effects of Changes in Foreign Exchange Rates, a closing rate is the spot exchange rate at the end of the reporting period. The standard defines monetary items as units of currency held and assets or liabilities to be received or paid in a fixed or determinable number of currency units.¹

FX revaluation is different from translating the financial statements of a foreign operation into a group's presentation currency. Both use exchange rates, but their purpose, scope and accounting treatment can differ.¹

Which balances may be in scope?

The answer depends on the business's accounting policy and framework. Common candidates for review include:

• Foreign-currency cash and bank balances
• Open trade receivables
• Open trade payables
• Intercompany receivables and payables
• Foreign-currency loans and other monetary assets or liabilities

IAS 21 distinguishes monetary from non-monetary items. It gives examples of non-monetary items including prepayments, goodwill, intangible assets, inventories, property, plant and equipment, and right-of-use assets. Their treatment can differ from that of monetary items, so they shouldn't be added to an automated population without a policy decision.¹

Step-by-step guide to FX revaluation

1. Confirm the accounting framework and policy

Document the functional currency, reporting or presentation currency, period-end date, approved rate type, eligible accounts, gain-and-loss accounts, reversal approach, materiality threshold and review owner. The workflow should apply the policy rather than treat an ERP default as an accounting conclusion.

IAS 21 requires a foreign-currency transaction to be recorded on initial recognition in the functional currency using the spot exchange rate at the transaction date. At subsequent reporting dates, the standard sets out how to translate monetary and non-monetary items.¹

2. Define the eligible population

Create a controlled scope list containing the entity, account or subledger, transaction currency, valuation method and destination account for each balance type. This makes it possible to show why a balance was included, excluded or routed to a different process.

If an ERP has specific bank, accounts-receivable or accounts-payable revaluation processes, check that those balances aren't also included in a general-ledger revaluation. Microsoft describes its Dynamics 365 general-ledger process as excluding the bank, AR and AP main accounts when the corresponding subledger process creates the general-ledger entry, helping avoid duplication.²

3. Load and validate approved rates

Retain the rate source, rate date, currency pair, rate direction, precision, load timestamp and fallback used for each run. Check for missing currencies, stale rates, inverted pairs and movements outside the team's defined tolerance.

IAS 21 defines the closing rate as the spot exchange rate at the end of the reporting period. Where a currency isn't exchangeable, the standard requires an entity to estimate the spot rate at the measurement date in a way that reflects an orderly exchange transaction under prevailing economic conditions.¹

4. Calculate and prepare proposed entries

For each balance in scope, preserve the foreign amount, current carrying amount, valuation rate, recalculated functional-currency amount and difference. A unique run reference, entity, period and source identifier make the resulting journal easier to trace.

As a system example, Microsoft says its Dynamics 365 general-ledger process calculates an unrealised gain or loss for each foreign-currency main-account balance being revalued and can create accounting-currency and reporting-currency transactions where relevant.²

5. Review exceptions and approve the run

Set a named reviewer to investigate material movements, missing rates, unusual currencies, negative or reversed balances, manual overrides, new entities and differences from prior periods. The reviewer should be able to trace a material journal back to its rate, rule and source balance.

Automation should route exceptions for review rather than make them disappear. Maker-checker access, locked rate tables and a documented override process help retain accountability.

6. Post, reverse where required and reconcile

Post only after the required review. Reconcile the journal to the scoped source balances, relevant subledgers, bank information and reporting outputs. Retain the rate file, scope report, calculation output, approval, journal reference, reversal reference and reconciliation sign-off.

Microsoft distinguishes its general-ledger revaluation approach from its AR and AP subledger processes: its general ledger posts the incremental difference against the current carrying amount, while its AR and AP processes reverse the previous revaluation for an unsettled transaction before creating a new one. This is a product-specific example, not a substitute for deciding the business's own accounting treatment.²

---

💡 Waiting for the right moment to exchange money? Wise rate alerts deliver live notifications when the exchange rate reaches your requirements.

Rate alerts can help with a payment-timing decision. They don't determine the reporting-date rate used for FX revaluation, which should follow your accounting policy. For the latest rates and more information, visit our Exchange Rate Alerts page.

---

What is the difference between FX revaluation and translation?

IAS 21 addresses both foreign-currency transactions and foreign operations, including translation into a presentation currency. Keep the two workstreams separate in the process design, because the relevant rates, account treatment and disclosures can differ.¹

How can automation improve the month-end process?

Automation can reduce repetitive preparation work and make the evidence trail easier to review. It doesn't remove the need for accounting judgement.

Microsoft's guidance says Dynamics 365 can run a general-ledger revaluation in real time or as a batch and records the process history, criteria, voucher link and reversal information. Use that as an example of a system capability to test, not a reason to assume that every platform applies the same logic.²

What can go wrong with automated FX revaluation?

Common failure points include an incorrect functional currency, wrong rate direction, stale rate, duplicated scope between a subledger and general ledger, a manual override without review, or a journal posted to the wrong period or entity.

Build test cases around real exceptions, including a missing rate, a new currency, an intercompany balance, a partial data load, an excluded account and a reversal. Compare the result with the prior period and investigate material movements before the period is closed.

What is a simple FX revaluation example?

Assume a business with GBP as its functional currency has an open EUR supplier payable. It was recognised when the invoice met the criteria for recognition, using the relevant transaction-date rate. If it remains open at the reporting date, the finance team applies the policy's appropriate reporting-date approach and compares the recalculated GBP value with the current carrying amount.¹

The resulting difference may be recorded under the accounting policy as an exchange movement. The later settlement can create a further difference because the payment-date rate may not be the same as the rate used at revaluation. The exact entry, presentation and treatment depend on the facts, applicable framework and policy.

Keep international payment records ready for the next FX revaluation run

Once finance teams have established a controlled FX revaluation run, they still need payment records that make settlement, foreign-currency fees and balance movements easier to reconcile at the next close.

Wise Business can help eligible businesses send international supplier payments, convert currencies at the mid-market exchange rate with low, transparent fees, and connect transactions to accounting software.

These features can make the payment currency, amount, fee and reference easier to bring into reconciliation.

Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

With Wise Business, you can:

• 🌍 Send money to 70+ countries and pay overseas invoices at the mid-market exchange rate with low, transparent fees and no hidden exchange rate markups (product availability varies by region)
• 📥 Receive payments in 24 currencies and counting
• 💵 Get local account details for 8+ currencies, including USD and EUR, to let your customers pay in a currency they know and trust - convenience for them and peace of mind for you
• 💰 Hold money in 40+ currencies
• 🔁 Convert currencies anytime at the mid-market exchange rate with low, transparent fees
• ⚡ Use the batch payments tool to create and send up to 1,000 payments in a single transfer
• 👥 Run payroll and make international payments for up to 1,000 employees all over the world - including paying suppliers using local payment methods like ACH, SEPA, and Faster Payments
• 💳 Get business debit cards with 0.5% cashback for you and your team to keep track of team expenses and spend all over the world, with real-time visibility and categorisation. See full cashback terms and conditions
• 🏢 Manage cash in 55+ currencies across international offices from a single business account and move money between business accounts in seconds (exact speeds can vary depending on individual circumstances and may not be the same for all transactions)
• 🧾 Connect and sync every business transaction to your favourite accounting software, including Xero, Quickbooks, and more
• 🔐 Create your own payment approvals process to manage your team better with customised access for different team members, roles and permissions
• 📑 Create custom professional invoices and schedule invoice payments for future dates
• 📈 Earn variable returns on GBP, USD and EUR with Wise Interest (Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative.)
• 🔗 Create payment links and QR codes to get paid easily (Card payment acceptance for new Wise Business customers is currently unavailable. Payment methods subject to eligibility and availability.)
• ⚙️ Automate payouts with the Wise API (comes with 24/7 customer support, a sandbox account to test integrations, API tokens, and clear documents on how to implement and make the most of our API)

Make the wise choice when selecting a business account for your domestic and global needs.

Be Smart, Get Wise.

Register for Wise Business ✍️

Wise Interest disclaimer: Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative. Taxes may apply. 3.32% variable rate on GBP is based on 7 day performance as of 05 Aug 2026. For full 5-year past performance and fund information, visit https://wise.com/interest. Investments are offered by Wise Assets UK Ltd. (FRN 839689)

Wise services and features are not available in all regions, country and product restrictions apply. Visit wise.com to check availability, and for fee details and terms for your region, visit our pricing page for Wise Business..

FAQs

What is FX revaluation in simple terms?

It is the process of updating the functional-currency value of an eligible foreign-currency balance at a later reporting date because exchange rates have changed. The difference is accounted for under the applicable framework and policy.¹

Is FX revaluation the same as realised FX?

No. Revaluation commonly concerns an open balance before settlement. A separate exchange difference can arise when the item is settled. The appropriate treatment and presentation depend on the accounting framework and transaction facts.¹

Do all foreign-currency balances need revaluation?

No single list suits every business. IAS 21 distinguishes monetary and non-monetary items, while the relevant accounting policy determines which balances and modules are in scope and how they are measured.¹

How often should a UK business perform FX revaluation?

Many businesses include it in the month-end or reporting-date close. The appropriate frequency depends on the reporting framework, materiality, volatility, business model and internal policy. An appropriately qualified accountant can advise on the policy for your circumstances.

Can FX revaluation be fully automated?

Systems can automate data collection, rate loading, calculations, journal preparation and exception reporting. Finance still needs to define the accounting policy, validate the rate governance, approve exceptions and review the posted result.

What should an audit trail contain?

Keep the scoped-balance report, rate source and date, calculation output, approvals, journal reference, any reversal record and reconciliation evidence. Microsoft describes revaluation history, criteria, voucher links and reversal records as part of its Dynamics 365 process history.²

Sources:

1. IAS 21 The Effects of Changes in Foreign Exchange Rates | IFRS Foundation
2. Foreign currency revaluation for General ledger | Microsoft Learn

Sources last checked on 23 September 2026