← All skills & workflows

finance

fx-revaluation

Applies IAS 21 period-end foreign currency revaluation to receivables, payables, and cash balances.

Retranslate all open foreign currency monetary items at the period-end closing rate per IAS 21. Posts a net FX gain/loss journal entry for the period. Keeps the balance sheet accurate when the company transacts in currencies other than AED.

Difficulty
beginner
Input
data
Output
spreadsheet
Needs
none
Used by
Finance Manager

What it needs

  • period_id
  • fx_rates — Closing FX rate table for the period.

What you get

  • fx-revaluation-je (markdown)
  • fx-summary (markdown)
  • revaluation-summary (markdown)

Ask it like this

  • FX revaluation
  • month-end revaluation
  • year-end revaluation
  • unrealised FX differences.