Month-end FX revaluation
How to calculate unrealised FX gains and losses and track the cashflow risk
Unrealised FX is the movement in base-currency value on foreign-currency invoices and bills that are still open. Finance teams need the accounting number and the cash timing behind it.
For accountants and operators searching how to calculate unrealised FX on unpaid invoices.
The short answer
Calculate the base-currency value of each unpaid foreign-currency invoice at the original booked rate, calculate it again at the month-end revaluation rate, and keep that movement separate from any invoice that has already settled.
Open invoice revaluation example
Illustrative figures, not customer data.
| Item | Value | Note |
|---|---|---|
| Invoice raised | USD 180k receivable | Booked at the invoice-date accounting rate. |
| Month end | Still unpaid | Revalue the open receivable at the month-end rate. |
| Finance risk | Cash still outstanding | A favourable revaluation still needs the customer payment to arrive. |
| What to separate | Open P&L vs cash P&L | Keep unpaid invoice revaluation separate from settled realised FX. |
What finance should check before posting revaluation
| Stage | Finance question | What to check |
|---|---|---|
| Invoice list | Which foreign-currency invoices are still open? | Receivables, payables, due dates, currency, original booked value. |
| Rate source | Which rate is used at month end? | Accounting policy and source consistency for the revaluation rate. |
| Cash timing | Can the receivable fund the payable? | Payment date gap. A later receivable leaves the near-term bill exposed. |
| Reporting | Is this realised or unrealised? | Open items stay unrealised; settled items move into realised FX. |
Common mistake
Mixing paid and unpaid invoices in one FX number makes the month-end bridge look cleaner than it really is.
Where Hedgr fits
Use Hedgr to split open invoice revaluation from realised settlement impact, then review exposure by due date before deciding what needs attention.
Related guides
Hedgr is read-only. It does not execute trades, move funds or give investment advice.
Guides
- FX exposure basics
- SME FX policy template
- Unrealised FX gains and losses
- Realised vs unrealised FX
- Multi-currency invoice cashflow risk
- Xero FX exposure workflow
- QuickBooks Online FX exposure workflow
- Exporter month-end FX reporting
- Multi-entity FX consolidation
- SARB BoP categories after the August 2026 change
- Sage One South Africa FX exposure workflow
- Rand exposure for SA importers and exporters
- IAS 21 and the margin basis: does your FX impact double-count?
- FX risk management software for SMEs
- What FX hedging software does
- Hedge accounting software vs FX exposure software
- FX risk for e-commerce and DTC exporters