Tools
FX revaluation: unrealized gain or loss at month end
Paste the foreign-currency balances you revalue at month end, with their carrying amounts and closing rates. You get the revalued amount and the unrealized gain or loss for each, the net by currency, and a balanced journal entry.
Most examples of this entry show one receivable and one rate. At month end you're revaluing a list: receivables, payables, cash in several currencies, with rates quoted both ways. This handles the list, and checks each carrying amount against the closing rate so a rate entered the wrong way round stands out.
Runs entirely in your browser. Nothing you paste is uploaded or stored; it stays in your browser.
Settings
Balances to revalue
One row per balance, tab or comma separated: account, currency, foreign-currency balance, carrying amount, closing rate, quote. Balances are signed: debit balances positive, credit balances negative (receivables and cash positive, payables and loans negative), in both the foreign-currency and carrying columns. Quote is per-fc (functional currency per 1 foreign unit, like 1.0835 USD per EUR; the default if blank) or per-func (foreign units per 1 functional unit, like 148.62 JPY per USD). Rates up to 8 decimals. A header row is fine.
How it's calculated
| Step | Rule |
|---|---|
| Revalued amount | Foreign-currency balance × closing rate (per-fc), or ÷ closing rate (per-func). Exact decimal arithmetic, rounded once to the cent, half away from zero. |
| Adjustment | Revalued amount minus the carrying amount. Positive is a gain, negative a loss, for assets and liabilities alike, because the balances are signed: a payable that grows in functional-currency terms gives a loss. |
| Net | The sum of the rounded adjustments, by currency and in total. |
| Entry | Each adjustment debits (gain) or credits (loss) its own account; the net goes to the gain/loss account. Debits equal credits. |
Which carrying amount to use
If last month's revaluation entry reverses on the first day of the month, the carrying amount is the amount originally booked, and the entry each month is the full difference to the closing rate. If revaluations accumulate, the carrying amount already includes last month's adjustment, and the entry is only this month's change. The arithmetic is the same either way; what changes is which carrying amount you paste. Reversing entries covers the choice.
Explaining the FX line at flux review
The net by currency is the explanation for the unrealized FX gain or loss line: which currency moved, and by how much. Pair it with the change in the closing rate from last month and the size of the balance, and the commentary rests on numbers a reviewer can recompute.
What it doesn't do
It doesn't decide which balances get revalued; that's your list and your policy. It doesn't fetch rates, so use your own rate source and keep it with the workpaper. It doesn't handle realized gains or losses on settlement, translation of a foreign subsidiary, or hedges. It doesn't post anything: it gives you the entry to book.
The balances and rates in the worked example are synthetic.
The FX line is one of many a flux review has to explain. The free flux template flags which balances moved enough to explain. The CloseOps Flux & Variance System ($79) starts from your trial balance instead: confirm each account's classification and it builds the income statement and balance sheet flux statements, then ranks what to investigate.
Related: foreign currency revaluation, with a worked example; reversing entries, for which carrying amount to use; what can I flux right now?, where “FX revaluation run” gates the FX line; the bank reconciliation calculator, since foreign-currency bank accounts reconcile in their own currency first; and month-end flux, step by step.
Found something wrong or missing? Tell me here — anonymous, thirty seconds.