← All skills & workflows

finance

fx-revaluation

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.

Inputs

  • period_id — Period id used to retranslate all open FX monetary items at closing rate and post the gain/loss JE
  • fx_rates — Closing FX rate table for the period.
  • period_id — Period id used to report realised and unrealised FX gains/losses for the period by currency

How you ask

  • FX revaluation
  • Month-end revaluation
  • Year-end revaluation

Outputs

  • conversation
  • fx-revaluation-je (markdown)
  • fx-summary (markdown)
  • revaluation-summary (markdown)
Levelbeginner
Inputdata
Outputspreadsheet
Setup[none]
Roles[Finance Manager]