Post exchange differences
Updated
Revalue foreign-currency customer or supplier debt at the rate on the document date, or let the payment book the gap when you settle.
Note
Empty Exchange gain account posts no gain or loss line. A payment still settles the debt. A revaluation still moves the carrying amount. The gap stays in receivables or payables. The same is true of empty Exchange loss account.
How to#
Realised difference is posted by the payment, not by this card. A customer payment or a vendor payment settles the carrying amount of the open debt and books the gap.
Unrealised difference is a revaluation document of its own.
To revalue what customers owe, open Ribbon → Sales → Documents → Receivable revaluations.
Press New. Pick Legal entity, Save. Then press Fill revaluation. Lines lists every open foreign-currency customer and contract of that entity at the rate on the document date: Customer, Contract, Currency, Open amount, Rate, Carrying amount, Revalued amount, Difference.
Then press Post revaluation. The state becomes Posted. The carrying amount stays at the new rate; the next payment measures its difference against it.
The state on the card does not post the revaluation. Only Post revaluation does. Until you press it, the card stays Draft, however many times you save.
To revalue what you owe suppliers, open Ribbon → Purchasing → Documents → Payable revaluations. Fill, post, and cancel with the same three buttons. A rise in the rate is a loss on a payable.
Cancel revaluation is on a Posted card. It takes the revaluation back to Draft.
Example
Books in the entity currency (rate 1). Contract in EUR. Rate 40 until 15 June, 42 from 16 to 25 June, 41 from 26 to 30 June.
Invoice 100 EUR on 10 June. Carrying amount: 100 × 40 = 4,000.
Payment 60 EUR on 20 June. Cash: 60 × 42 = 2,520. Debt falls at the old carrying rate: 60 × 40 = 2,400. Realised gain: 2,520 − 2,400 = 120. Remaining open: 100 − 60 = 40 EUR, still carried at 40 × 40 = 1,600.
Fill revaluation on 30 June at rate 41. Revalued: 40 × 41 = 1,640. Difference: 1,640 − 1,600 = 40. Post revaluation. That 40 is unrealised gain. The last 40 EUR paid at 41 then has no further difference: 40 × 41 = 1,640, already the carrying amount.
After the invoice After the 60 EUR payment After 30 June revaluation Open EUR 100 40 40 Carrying amount 4,000 1,600 1,640 Cash — 2,520 2,520 Realised gain — 120 120 Unrealised gain — — 40
Tip
Rates live under Ribbon → Common → Dictionaries → Exchange rates. Each row is one currency's Rate to base in a date window (Effective from / Effective to). A document stamps Exchange rate from the window that covers its date. Point Exchange gain account and Exchange loss account on Set ledger accounts. Revalue on period close, in Exchange differences on Ribbon → Accounting → Settings → Accounting settings, posts both revaluations on the period's last day when you close the period. Off is the default: you create and post the documents yourself. Fill revaluation reads balances on the revaluation date, so a June fill run in July does not pick up July's invoices.
If the command refuses#
| What you see | What to do |
|---|---|
| The command asks for the legal entity whose debt you are revaluing | Fill Legal entity, Save, then Fill revaluation. |
| The command says there is nothing to revalue and to fill first | Lines is empty. Press Fill revaluation, then Post revaluation. |
| The command says the legal entity has no open foreign-currency debt | There is nothing to revalue on this date. Check the entity, the date, and that the contract or supplier currency differs from the entity's. |
| The command names a missing rate for a contract currency on a date | Add Rate to base for that currency under Ribbon → Common → Dictionaries → Exchange rates, covering that date. |
| A foreign-currency invoice or payment is refused and the message names a date | No rate window covers that document date. Add the rate, then post again. |
| Post revaluation is not on the card | The document is not Draft, or it is already Posted. Use Cancel revaluation only to take Posted back to Draft. |
See also