Multi-Currency Revaluation Gain and Loss Calculator
Month-end revaluation is where multi-currency balances meet the income statement. This calculator isolates the arithmetic for one balance so you can check the postings from SYSPRO, Sage Evolution, Odoo or any other ERP.
Your numbers
Your results
Simplified single-balance example. Your accounting policy, tax treatment and ERP revaluation method decide the actual postings.
Unrealised gain (loss) vs period end rate
Sweeps Rate at period end from 16 to 21, holding your other inputs fixed.
Revaluation check over your ERP
We can outline a read-only report that recomputes revaluation per open item for a second check.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the open foreign currency balance, whether it is a receivable or a payable, and the three rates: the rate when the invoice was booked, the period-end closing rate and the expected or actual settlement rate. The unrealised figure is what the revaluation journal posts at period end. The realised figure is the total effect once the balance is settled at the settlement rate.
- Use the closing rate your policy specifies.
- Check the sign: payables behave opposite to receivables.
- Compare the result with the ERP revaluation preview.
The accounting logic
Under IAS 21, monetary items such as receivables and payables are retranslated at the closing rate, with the difference taken to profit or loss. A receivable gains when the foreign currency strengthens against the local currency, while a payable loses. The formula is direction times amount times the difference between the new rate and the booking rate. At settlement the cumulative result is recognised; the previously booked unrealised amount is reversed so only the incremental movement is added in the settlement period.
Reading the result
If the unrealised and realised numbers have opposite signs, the rate reversed between the month end and payment, and the settlement period will show the opposite effect. Large unrealised swings on payables in a depreciating currency are common for African importers, and they can wipe out a month's operating profit. Trend them rather than treating them as noise.
ERP notes
Run revaluation after all rates are loaded and before locking the period. Make sure the unrealised accounts are reversed automatically in the next period, or your realised gain will be double counted. Where local rules force a particular central bank rate, such as in some markets with official and parallel rates, load that rate and document it.
Frequently Asked Questions
Which items are revalued?
Monetary items denominated in a foreign currency: receivables, payables, bank balances and loans. Non-monetary items such as inventory held at historical cost are not retranslated.
Why reverse the revaluation?
If the unrealised amount stays on the books and the settlement posts the full difference as well, the gain is counted twice. Reversal at the start of the next period leaves only the incremental movement.
What if the market has two official rates?
Follow your accounting framework and local regulation to decide which rate applies, record the source and apply it consistently. Tax authorities and auditors usually want documentation of that choice.
Does this handle many invoices?
No, it shows one balance. For many invoices, apply the same formula per line. The reference to the policy template on this site helps define the rules your ERP revaluation should follow.
Where finance teams spend days on reval checks, a read-only report over ERP balances can show the numbers in minutes. Talk to us about it.
Related Tools
ERP Multi-Currency Exchange Rate Policy Template
Generate a one-page policy that fixes where exchange rates come from, who loads them, how often balances are revalued and who approves exceptions.
Country & TaxAfrica and Middle East Currency Codes Reference for ERP Setup
Look up ISO currency codes, minor unit digits and common pegs for African and Gulf currencies before configuring an ERP currency table.
Costing & FinanceRand Weakness Margin Erosion Calculator
See how much margin you lose when a quote was priced at one rand rate and the dollar-cost materials are bought at another, and what price restores it.
Country & TaxSouth Africa Import Landed Cost and VAT Calculator
Work out the true rand landed cost of an imported component, including duty, the 10 percent VAT uplift and cash-flow VAT, and see how the exchange rate moves it.
More Costing & Finance tools
See all- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
- SyteLine Cost Rollup Variance Calculator