Workpapers
Workpaper template
Analysis of cash and cash equivalents
- Prepared by
- AI-assisted draft
- Reviewed by
- Not reviewed — human review required
- Status
- Published
Objective of the workpaper
From the bank statements and confirmations, the features of the investments and the overdraft agreements, qualify each balance (cash, cash equivalent, excluded investment, overdraft that is part of cash management or financing), determine closing cash and cash equivalents, compute the effect of exchange rate changes, reconcile opening and closing cash with the net change in the statement, identify balances that are not available for use and prepare the note on the components.
8 sections · 31 blocks · 4 calculations · 0 entries
- IAS 7 §6
- IAS 7 §7
- IAS 7 §8
- IAS 7 §9
- IAS 7 §48
- IAS 7 §49
- IAS 7 §25
- IAS 7 §26
- IAS 7 §27
- IAS 7 §28
- IAS 7 §45
- IAS 7 §46
- IAS 7 §47
- IAS 7 §50
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.
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cashOpen the mission · Closing cash
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cashOpen the mission · Term deposit of 1 December 20X4
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cashOpen the mission · Listed shares
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cashOpen the mission · Money market fund with daily liquidity
- File for preparing the consolidated statement of cash flows of a retail groupOpen the mission · Cash at the end
- File for preparing the consolidated statement of cash flows of a retail groupOpen the mission · Cash at the beginning
- File for preparing the consolidated statement of cash flows of a retail groupOpen the mission · Six-month term deposit
7 instances from the cases: the calculations and entries below are run by the calculation engine.
- File and entity
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cash
- Case tasks documented here
- Qualify each balance: cash, cash equivalent, excluded investment or financing.
- Is the overdraft part of cash management? Are the subsidiary's balances available?
- Determine the qualifying and excluded investments and closing cash.
- Compute the effect of exchange rate changes on cash.
- Reconcile opening and closing cash.
- Prepare the note: components, reconciliation with the statement of financial position, policy, unavailable balances.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
SOLVANNE_GROUP_BALANCES_31_DECEMBER_20X8
Cash on hand
NumberRequired
6,000
Demand deposits (including translated foreign currency accounts)
NumberRequired
842,000
Investments qualifying as cash equivalents
Number
420,000
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
430,000
Bank overdrafts repayable on demand that are part of cash management
Number
95,000
Other short-term bank borrowings (financing)
Number
200,000
Balances not available for use by the group (included in the components)
Number
210,000
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
905,000
Net increase in cash per the statement
Number
236,000
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
210,000
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
150,000
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
28,000
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
1,173,000
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
32,000
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
1,173,000
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
0
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Cash equivalent
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashPass
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
- File and entity
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cash
- Case tasks documented here
- Qualify each balance: cash, cash equivalent, excluded investment or financing.
- Is the overdraft part of cash management? Are the subsidiary's balances available?
- Determine the qualifying and excluded investments and closing cash.
- Compute the effect of exchange rate changes on cash.
- Reconcile opening and closing cash.
- Prepare the note: components, reconciliation with the statement of financial position, policy, unavailable balances.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
TERM_DEPOSIT_14_MONTHS_SUBSCRIBED_1_DECEMBER_20X7
Cash on hand
NumberRequired
Demand deposits (including translated foreign currency accounts)
NumberRequired
Investments qualifying as cash equivalents
Number
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
250,000
Bank overdrafts repayable on demand that are part of cash management
Number
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
0
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Excluded: maturity of more than three months when acquired
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashNot evaluated
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
- File and entity
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cash
- Case tasks documented here
- Qualify each balance: cash, cash equivalent, excluded investment or financing.
- Is the overdraft part of cash management? Are the subsidiary's balances available?
- Determine the qualifying and excluded investments and closing cash.
- Compute the effect of exchange rate changes on cash.
- Reconcile opening and closing cash.
- Prepare the note: components, reconciliation with the statement of financial position, policy, unavailable balances.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
LISTED_SHARES_PORTFOLIO
Cash on hand
NumberRequired
Demand deposits (including translated foreign currency accounts)
NumberRequired
Investments qualifying as cash equivalents
Number
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
180,000
Bank overdrafts repayable on demand that are part of cash management
Number
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
0
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Excluded: equity instrument
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashNot evaluated
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
- File and entity
- Investments, overdraft and cash trapped abroad: composition and reconciliation of cash
- Case tasks documented here
- Qualify each balance: cash, cash equivalent, excluded investment or financing.
- Is the overdraft part of cash management? Are the subsidiary's balances available?
- Determine the qualifying and excluded investments and closing cash.
- Compute the effect of exchange rate changes on cash.
- Reconcile opening and closing cash.
- Prepare the note: components, reconciliation with the statement of financial position, policy, unavailable balances.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
MONEY_MARKET_FUND_DAILY_LIQUIDITY
Cash on hand
NumberRequired
Demand deposits (including translated foreign currency accounts)
NumberRequired
Investments qualifying as cash equivalents
Number
120,000
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
Bank overdrafts repayable on demand that are part of cash management
Number
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
0
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Cash equivalent
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashNot evaluated
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
- File and entity
- File for preparing the consolidated statement of cash flows of a retail group
- Case tasks documented here
- Qualify the components of cash and the unavailable balances.
- Determine cash and cash equivalents at the beginning and at the end.
- Compute the effect of exchange rate changes on cash.
- Reconcile cash.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
HESTREL_GROUP_BALANCES_31_DECEMBER_20X8
Cash on hand
NumberRequired
20,000
Demand deposits (including translated foreign currency accounts)
NumberRequired
860,000
Investments qualifying as cash equivalents
Number
250,000
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
300,000
Bank overdrafts repayable on demand that are part of cash management
Number
280,000
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
140,000
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
1,200,000
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
375,000
Foreign currency cash at the end of the period, translated at the closing rate
Number
525,000
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
400,000
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
100,000
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
850,000
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
25,000
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
850,000
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
0
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Cash equivalent
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashPass
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
- File and entity
- File for preparing the consolidated statement of cash flows of a retail group
- Case tasks documented here
- Qualify the components of cash and the unavailable balances.
- Determine cash and cash equivalents at the beginning and at the end.
- Compute the effect of exchange rate changes on cash.
- Reconcile cash.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
HESTREL_GROUP_BALANCES_31_DECEMBER_20X7
Cash on hand
NumberRequired
15,000
Demand deposits (including translated foreign currency accounts)
NumberRequired
1,035,000
Investments qualifying as cash equivalents
Number
300,000
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
Bank overdrafts repayable on demand that are part of cash management
Number
150,000
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
1,200,000
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
0
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Cash equivalent
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
No balance unavailable
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashNot evaluated
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
- File and entity
- File for preparing the consolidated statement of cash flows of a retail group
- Case tasks documented here
- Qualify the components of cash and the unavailable balances.
- Determine cash and cash equivalents at the beginning and at the end.
- Compute the effect of exchange rate changes on cash.
- Reconcile cash.
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
SIX_MONTH_TERM_DEPOSIT_PLACED_IN_NOVEMBER_20X8
Cash on hand
NumberRequired
Demand deposits (including translated foreign currency accounts)
NumberRequired
Investments qualifying as cash equivalents
Number
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
300,000
Bank overdrafts repayable on demand that are part of cash management
Number
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
0
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Excluded: maturity of more than three months when acquired
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References
Checks and financial statement impact
- Qualification documentedPass
- Composition = rebuilt cashNot evaluated
- Assets
- 0
- Liabilities
- 0
- Profit or loss
- 0
- OCI
- 0
- Equity
- 0
Inputs
InputsBalances examined at the reporting date (bank, nature, maturity when acquired, terms)
TextRequired
Cash on hand
NumberRequired
Demand deposits (including translated foreign currency accounts)
NumberRequired
Investments qualifying as cash equivalents
Number
Rule: maturity is assessed at the date the investment is acquired, not at the reporting date (para. 7); the qualification of each investment is documented in the judgement section.
Investments excluded from cash equivalents
Number
Bank overdrafts repayable on demand that are part of cash management
Number
Other short-term bank borrowings (financing)
Number
Balances not available for use by the group (included in the components)
Number
Cash and cash equivalents at the beginning of the period (prior period statement)
Number
Net increase in cash per the statement
Number
Net decrease in cash per the statement
Number
Foreign currency cash at the end of the period, translated at the closing rate
Number
Foreign currency cash at the beginning of the period, translated at the opening rate
Number
Foreign currency receipts translated at the rates at the dates of the cash flows
Number
Case data: rates at the dates of the cash flows or an average rate approximating them, never the closing rate for the cash flows of a foreign subsidiary (para. 25 to 27).
Foreign currency payments translated at the rates at the dates of the cash flows
Number
Supporting evidence
EvidenceEvidence obtained and referenced (category, document reference)
EvidenceRequired
Qualification of the balances
AnalysisIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §9
Points reviewed
ChecklistRequired
- Short-term, highly liquid investment, known amount, insignificant risk of changes in value
- Maturity of three months or less from the date of acquisition
- Equity investments excluded, unless cash equivalents in substance
- Overdrafts repayable on demand that are part of cash management (fluctuating balance)
- Movements between components: not cash flows
Composition, exchange effect and reconciliation
CalculationsIAS 7 §6IAS 7 §8IAS 7 §25IAS 7 §26IAS 7 §27IAS 7 §28IAS 7 §45
Closing cash and cash equivalents
Calculation
Cash on hand ; Demand deposits (including translated foreign currency accounts) ; Investments qualifying as cash equivalents ; − Bank overdrafts repayable on demand that are part of cash management
Effect of exchange rate changes on cash
Calculation
Foreign currency cash at the end of the period, translated at the closing rate ; − Foreign currency cash at the beginning of the period, translated at the opening rate ; − Foreign currency receipts translated at the rates at the dates of the cash flows ; Foreign currency payments translated at the rates at the dates of the cash flows
Closing cash rebuilt (opening + net change + exchange effect)
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Difference: composition − rebuilt cash
Calculation
Cash and cash equivalents at the beginning of the period (prior period statement) ; Net increase in cash per the statement ; − Net decrease in cash per the statement ; Effect of exchange rate changes on cash ; Closing cash and cash equivalents
Judgements on composition and availability
JudgmentIAS 7 §6IAS 7 §7IAS 7 §8IAS 7 §48IAS 7 §49
Qualification of the investment examined
JudgmentRequired
Cash equivalent / Excluded: maturity of more than three months when acquired / Excluded: risk of changes in value not insignificant / Excluded: equity instrument
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Bank overdraft
JudgmentRequired
Part of cash management: deducted from cash / Financing: presented with borrowings / No overdraft
Professional judgement: a balance that often fluctuates from positive to overdrawn indicates that the overdraft is part of cash management (para. 8).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Balances not available for use by the group
JudgmentRequired
Significant: amount and management commentary / Not significant / No balance unavailable
Professional judgement: significance is assessed against group cash; exchange controls are an example of unavailability (para. 48 and 49).
Rationale: facts relied on, analysis, alternative rejected
TextRequired
Disclosure
DisclosureIAS 7 §45IAS 7 §46IAS 7 §47IAS 7 §48IAS 7 §50
Items of the note
ChecklistRequired
- Components of cash and cash equivalents
- Reconciliation with the line items of the statement of financial position
- Policy used to determine the composition (wording applicable from 2027)
- Change in the composition policy dealt with under IAS 8
- Significant balances not available, with management commentary
- Encouraged disclosures (undrawn facilities…), not required
Draft note on cash
Text
Conclusion
ConclusionCash finalised, reconciliation, unavailable balances and points submitted to the reviewer
ConclusionRequired
Normative references
ReferencesParagraphs cited in this workpaper (verification status shown from the register)
References