Skip to main content
IFRS Academy

CERTYNEX IFRS ACADEMY

Search the Academy

Home
My learning path
Exercises & quizzes
Cases
Workpapers
Exams
My progress

IAS 21Workpapers (Step 4 of 5)

Workpaper template

Step 4 of 5
WorkpaperIAS 21 — The Effects of Changes in Foreign Exchange RatesL2 · L3 · L4

Foreign operation translation file: rates, translation reserve, goodwill, tax and intragroup balances

5 missions10 sections to document75 min
Prepared by
AI-assisted draft
Reviewed by
Not reviewed — human review required
Status
Published

Objective of the workpaper

Enter the operation's statements in its functional currency and the rates given by the case (closing, average, transaction date, historical), let the file translate the items and compute the translation difference as a balancing figure, document the judgement on the average rate, follow the roll-forward of the translation reserve, then prepare the entries and their effect on the financial statements.

10 sections · 58 blocks · 13 calculations · 5 entries

  • IAS 21 §38
  • IAS 21 §39
  • IAS 21 §40
  • IAS 21 §41
  • IAS 21 §42
  • IAS 21 §44
  • IAS 21 §47
  • IAS 21 §50
  • IAS 21 §55

Work this workpaper as a mission

Each case that uses this template opens in the mission workspace: data, analysis, calculation, entries, conclusion and review, with your progress saved.

5 instances from the cases: the calculations and entries below are run by the calculation engine.

File and entity
Translation of a UK subsidiary: closing rate, average rate, translation reserve and goodwill
Case tasks documented here
  • Translate the assets.
  • Translate the liabilities.
  • Is the average rate acceptable for income and ordinary expenses? Justify.
  • Translate the revenue.
  • Translate the ordinary expenses.
  • Translate the single expense.
  • Translate the opening equity.
  • Compute the translation difference as a balancing figure.
  • Record the translation difference.
  • Translate goodwill and the fair value adjustment at the closing rate.
  • Compute the translation difference on goodwill and the adjustment.
  • Record that difference.
  • Check the roll-forward of the translation reserve.
1

Statements and data

Inputs
  • Foreign operation: functional currency, interest held and acquisition date

    Text

    FILIALE_BRITANNIQUE_DETENUE_EN_TOTALITE_EN_LIVRES_STERLING

  • Presentation currency of the group

    Text

    EUR

  • Closing rate (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

    Number

    120 %

  • Average rate of the period given by the case (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

    Number

    115 %

  • Rate of the date of a single transaction (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

    Number

    118 %

  • Historical rate for equity (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

    Number

    110 %

  • Latest closing rate (hyperinflationary economy; per 100 units of foreign currency: a rate of 0.92 is entered as 92)

    Number

  • Total assets in the operation's functional currency

    Number

    1,000,000

  • Total liabilities in the operation's functional currency

    Number

    300,000

  • Revenue of the period in functional currency

    Number

    900,000

  • Ordinary expenses of the period in functional currency

    Number

    600,000

  • Single expense to translate at the rate of its date

    Number

    100,000

  • Opening equity in functional currency

    Number

    500,000

  • Goodwill and fair value adjustments in the operation's functional currency

    Number

    190,000

  • Same amount translated at the acquisition date rate (case data)

    Number

    209,000

  • Amount restated under IAS 29 in functional currency (hyperinflationary economy)

    Number

  • Intragroup monetary balance translated at the closing rate (case data)

    Number

  • Carrying amount of the intragroup balance before the difference

    Number

  • Translation or exchange difference subject to tax

    Number

  • Tax rate given by the case (in %)

    Number

  • Translation reserve: opening balance

    Number

    0

  • Translation reserve: closing balance recorded

    Number

    82,000

  • Translation difference of the period (net assets)

    Number

    63,000

  • Translation difference of the period on goodwill and adjustments

    Number

    19,000

  • Net investment difference taken to the reserve

    Number

  • Tax effect taken to the reserve (to deduct)

    Number

  • Share allocated to non-controlling interests (to deduct)

    Number

  • Amount reclassified to profit or loss on disposal (to deduct)

    Number

  • Share reattributed to non-controlling interests on a partial disposal (to deduct)

    Number

  • Share of the reserve allocated to non-controlling interests (entry)

    Number

2

Supporting evidence

Evidence
  • Evidence obtained and referenced (category, document reference)

    EvidenceRequired

3

Analysis of the translation

Analysis

IAS 21 §38IAS 21 §39IAS 21 §40IAS 21 §41IAS 21 §42IAS 21 §44IAS 21 §47IAS 21 §50

  • Points reviewed: translation into the presentation currency

    ChecklistRequired

    • Presentation currency chosen by the entity; translation if it differs from the functional currency
    • Assets and liabilities at the closing rate of each statement of financial position
    • Income and expenses at the rates of the transaction dates
    • Average rate used as an approximation, judgement on fluctuations (no threshold)
    • Translation differences in other comprehensive income, accumulated in a separate component of equity
    • Goodwill and fair value adjustments treated as items of the operation and translated at the closing rate
    • Differences on intragroup monetary balances kept in consolidated profit or loss, except net investment
    • Different reporting date of the operation: adjustments for exchange movements between the dates
    • Tax effects of the differences dealt with under IAS 12 (rate given by the case)
    • Hyperinflationary economy: amounts restated under IAS 29 then translated at the latest closing rate
4

Translations and translation difference

Calculations

IAS 21 §39IAS 21 §40IAS 21 §41IAS 21 §42IAS 21 §44IAS 21 §47IAS 21 §50

  • Assets translated at the closing rate

    CalculationRequired

    1,200,000

    Total assets in the operation's functional currency ; Closing rate (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Liabilities translated at the closing rate

    CalculationRequired

    360,000

    Total liabilities in the operation's functional currency ; Closing rate (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Revenue translated at the average rate

    CalculationRequired

    1,035,000

    Revenue of the period in functional currency ; Average rate of the period given by the case (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Ordinary expenses translated at the average rate

    CalculationRequired

    690,000

    Ordinary expenses of the period in functional currency ; Average rate of the period given by the case (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Single expense translated at the rate of its date

    Calculation

    118,000

    Single expense to translate at the rate of its date ; Rate of the date of a single transaction (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Equity translated at the historical rate

    CalculationRequired

    550,000

    Opening equity in functional currency ; Historical rate for equity (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Translation difference as a balancing figure (net assets translated less historical equity and translated result)

    CalculationRequired

    63,000

    Assets translated at the closing rate ; − Liabilities translated at the closing rate ; − Equity translated at the historical rate ; − Revenue translated at the average rate ; Ordinary expenses translated at the average rate ; Single expense translated at the rate of its date

  • Goodwill and adjustments translated at the closing rate

    CalculationRequired

    228,000

    Goodwill and fair value adjustments in the operation's functional currency ; Closing rate (per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Translation difference on goodwill (closing less acquisition date)

    CalculationRequired

    19,000

    Goodwill and adjustments translated at the closing rate ; − Same amount translated at the acquisition date rate (case data)

  • Restated amounts translated at the latest closing rate

    CalculationRequired

    Amount restated under IAS 29 in functional currency (hyperinflationary economy) ; Latest closing rate (hyperinflationary economy; per 100 units of foreign currency: a rate of 0.92 is entered as 92)

  • Exchange difference on an intragroup balance (excluding net investment)

    CalculationRequired

    0

    Intragroup monetary balance translated at the closing rate (case data) ; − Carrying amount of the intragroup balance before the difference

  • Tax effect on the translation or exchange difference

    CalculationRequired

    Translation or exchange difference subject to tax ; Tax rate given by the case (in %)

  • Translation reserve: closing balance recomputed

    CalculationRequired

    82,000

    Translation reserve: opening balance ; Translation reserve: closing balance recorded ; Translation difference of the period (net assets) ; Translation difference of the period on goodwill and adjustments ; Net investment difference taken to the reserve ; − Tax effect taken to the reserve (to deduct) ; − Share allocated to non-controlling interests (to deduct) ; − Amount reclassified to profit or loss on disposal (to deduct) ; − Share reattributed to non-controlling interests on a partial disposal (to deduct)

5

Entries

Entries
  • Entry: translation difference on net assets taken to other comprehensive income

    Entry

    AccountDebitCredit
    Net assets of the foreign operation63,000
    Translation reserve63,000
  • Entry: translation difference on goodwill and adjustments

    Entry

    AccountDebitCredit
    Goodwill19,000
    Translation reserve19,000
  • Entry: exchange difference on an intragroup balance kept in profit or loss

    Entry

    Debit Intragroup receivable ← Exchange difference on an intragroup balance (excluding net investment) ; Credit Exchange gain ← Exchange difference on an intragroup balance (excluding net investment)

  • Entry: tax effect of the difference taken to other comprehensive income

    Entry

    Debit Translation reserve ← Tax effect on the translation or exchange difference ; Credit Deferred tax liability ← Tax effect on the translation or exchange difference

  • Entry: share of the reserve allocated to non-controlling interests

    Entry

    Debit Translation reserve ← Share of the reserve allocated to non-controlling interests (entry) ; Credit Non-controlling interests ← Share of the reserve allocated to non-controlling interests (entry)

6

Judgements

Judgment

IAS 21 §40IAS 21 §42

  • Average rate or rates at the transaction dates

    JudgmentRequired

    Average rate retained (no significant fluctuation)

    Average rate retained (no significant fluctuation) / Rates at the transaction dates retained

    Professional judgement: an average rate is appropriate only if rates do not fluctuate significantly; no numerical threshold is imposed.

  • Rationale for the rates chosen

    Text

    PLAGE_ETROITE_DES_COURS_MENSUELS

  • Hyperinflationary nature of the functional currency

    JudgmentRequired

    Currency not hyperinflationary / Hyperinflationary currency: restatement then latest closing rate

    Professional judgement: assessing whether an economy is hyperinflationary falls under IAS 29, outside the scope of this file; no numerical threshold is imposed here.

  • Rationale for the hyperinflation assessment

    Text

7

Effect on the financial statements

FS impact
  • Effect derived from the entries

    Table

8

Disclosures

Disclosure

IAS 21 §55

  • Points to complete (statements presented in another currency for convenience)

    ChecklistRequired

    • Information presented as supplementary, distinguished from the information that complies with IFRS
    • Presentation currency and functional currency stated
    • Translation method stated
9

Conclusion

Conclusion
  • Translated statements, difference, reserve roll-forward, entries and judgements submitted to the reviewer

    ConclusionRequired

10

Normative references

References
  • Paragraphs cited in this workpaper and their verification status

    References

11

Checks and financial statement impact

  • Judgement on the average rate documentedPass
  • Translation difference entry balancedPass
  • Recomputed reserve equals recorded reservePass
Assets
82,000
Liabilities
0
Profit or loss
0
OCI
82,000
Equity
82,000