Skip to main content
IFRS Academy

CERTYNEX IFRS ACADEMY

Search the Academy

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

Workpapers

Workpaper template

WorkpaperIAS 7 — Statement of Cash FlowsL2 · L3 · L4

Reconciliation of liabilities arising from financing activities

10 missions8 sections to document45 min
Prepared by
AI-assisted draft
Reviewed by
Not reviewed — human review required
Status
Published

Objective of the workpaper

For each class of liabilities (one instance per class: bank borrowings, lease liabilities, bonds…), check that it is a liability arising from financing activities, take the opening and closing balances from the statement of financial position, split the changes between financing cash flows, changes from obtaining or losing control, exchange effects, fair value changes and other non-cash changes, check that the reconciliation agrees with the reported balance and prepare the disclosure with its links to the statement of cash flows and the primary statements.

8 sections · 28 blocks · 4 calculations · 0 entries

  • IAS 7 §17
  • IAS 7 §43
  • IAS 7 §44
  • IAS 7 §44A
  • IAS 7 §44C
  • IAS 7 §44B
  • IAS 7 §44D
  • IAS 7 §44E
  • IAS 7 §33A
  • IAS 7 §34A

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.

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

File and entity
Borrowings, leases, debt conversion and foreign currency debt: reconciliation of financing liabilities
Case tasks documented here
  • Which liabilities enter the reconciliation, accrued interest payable included?
  • Split the lease payments.
  • Check the repayments against the balances.
  • Prepare the reconciliation by class and in total.
  • Draft the note and the disclosures on non-cash transactions.
1

Inputs

Inputs
  • Class of liabilities examined, contracts and line item in the statement of financial position

    TextRequired

    BANK_LOANS_EUR_AND_USD

  • Opening balance (statement of financial position)

    Number

    2,400,000

  • Reported closing balance (statement of financial position)

    Number

    2,736,000

  • New drawdowns received in cash

    Number

    800,000

  • Repayments paid (bank statements)

    Number

    500,000

  • Lease payments of the period (total)

    Number

  • Interest portion of the lease payments (schedule)

    Number

    Case datum (IFRS 16 schedule, frozen reference): outside para. 34B, the interest element is a financing cash flow like the principal element (para. 34A(a) and 17); the schedule separates the two elements for the disclosure of interest paid.

  • Liabilities assumed with subsidiaries acquired

    Number

  • Liabilities derecognised with subsidiaries disposed of

    Number

  • Exchange differences increasing the liability

    Number

    36,000

  • Exchange differences decreasing the liability

    Number

  • Fair value increases

    Number

  • Fair value decreases

    Number

  • New lease liabilities (leases entered into in the period)

    Number

  • Debt converted into equity

    Number

  • Other non-cash increases (interest added to the debt…)

    Number

2

Supporting evidence

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

    EvidenceRequired

3

Scope of financing liabilities

Analysis

IAS 7 §17IAS 7 §43IAS 7 §44IAS 7 §44AIAS 7 §44C

  • Points reviewed

    ChecklistRequired

    • Past or future cash flows of the class classified in financing
    • Financial assets whose cash flows are financing (hedges of financing liabilities)
    • Information enabling users to evaluate changes, whether cash or non-cash
    • Non-cash transactions excluded from the statement and disclosed elsewhere
    • Dividends payable and interest payable: liabilities arising from financing activities as soon as their cash flows are classified as financing (dividends paid; interest paid outside para. 34B)
4

Financing cash flows and reconciliation

Calculations

IAS 7 §17IAS 7 §44BIAS 7 §44D

  • Principal portion of the lease payments (financing cash flow)

    Calculation

    0

    Lease payments of the period (total) ; − Interest portion of the lease payments (schedule)

  • Repayments derived from the balances (check)

    Calculation

    500,000

    Opening balance (statement of financial position) ; New drawdowns received in cash ; Liabilities assumed with subsidiaries acquired ; − Liabilities derecognised with subsidiaries disposed of ; Exchange differences increasing the liability ; − Exchange differences decreasing the liability ; Fair value increases ; − Fair value decreases ; New lease liabilities (leases entered into in the period) ; − Debt converted into equity ; Other non-cash increases (interest added to the debt…) ; − Reported closing balance (statement of financial position)

  • Closing balance rebuilt

    Calculation

    2,736,000

    Opening balance (statement of financial position) ; New drawdowns received in cash ; − Repayments paid (bank statements) ; − Principal portion of the lease payments (financing cash flow) ; Liabilities assumed with subsidiaries acquired ; − Liabilities derecognised with subsidiaries disposed of ; Exchange differences increasing the liability ; − Exchange differences decreasing the liability ; Fair value increases ; − Fair value decreases ; New lease liabilities (leases entered into in the period) ; − Debt converted into equity ; Other non-cash increases (interest added to the debt…) ; Reported closing balance (statement of financial position)

  • Difference: reported − rebuilt balance

    Calculation

    0

    Opening balance (statement of financial position) ; New drawdowns received in cash ; − Repayments paid (bank statements) ; − Principal portion of the lease payments (financing cash flow) ; Liabilities assumed with subsidiaries acquired ; − Liabilities derecognised with subsidiaries disposed of ; Exchange differences increasing the liability ; − Exchange differences decreasing the liability ; Fair value increases ; − Fair value decreases ; New lease liabilities (leases entered into in the period) ; − Debt converted into equity ; Other non-cash increases (interest added to the debt…) ; Reported closing balance (statement of financial position)

    Check: a non-zero difference points to a change left out (often a non-cash change) or a wrong balance.

5

Qualification of the class

Judgment

IAS 7 §44C

  • Is the class within the reconciliation?

    JudgmentRequired

    Liability arising from financing activities

    Liability arising from financing activities / Financial asset whose cash flows are financing / Out of scope (operating or investing liability, component of cash)

    Professional judgement: an overdraft forming part of cash or trade payables are outside the reconciliation; a hedging asset of a financing liability is in it, as are dividends and interest payable whose cash flows are classified as financing (para. 44C).

  • Rationale: facts relied on, analysis, alternative rejected

    TextRequired

6

Disclosure

Disclosure

IAS 7 §44BIAS 7 §44DIAS 7 §44EIAS 7 §43

  • Items of the note

    ChecklistRequired

    • Changes from financing cash flows
    • Changes from obtaining or losing control
    • Effect of changes in foreign exchange rates
    • Changes in fair values
    • Other changes (new leases, conversions…)
    • Links to the line items of the statement of financial position and of cash flows
    • Separate presentation if combined with other assets and liabilities (net debt)
  • Draft note (reconciliation table and comments)

    Text

7

Conclusion

Conclusion
  • Reconciliation finalised, differences explained and points submitted to the reviewer

    ConclusionRequired

8

Normative references

References
  • Paragraphs cited in this workpaper (verification status shown from the register)

    References

9

Checks and financial statement impact

  • Qualification documentedPass
  • Repayments per bank statements = repayments derived from balancesPass
Assets
0
Liabilities
0
Profit or loss
0
OCI
0
Equity
0