Home › CA Final › financialreporting › Accounting and Technology — ICOFR-ERP Integration, Inventory, Derivatives & Segment Automation › Identify the BEST way to use spreadsheet automat…
Identify the BEST way to use spreadsheet automation under Ind AS 109 derivative classification when ERP is not configured to do so.
AExtract contract data into Excel; codify Ind AS 109 'own-use' / net-settlement-in-practice tests via logical functions (IF/AND/OR/VLOOKUP); apply consistently across the contract portfolio with a flag for derivative vs executory
BTreat all net-settled contracts as derivatives without further analysis
CHand-classify every contract; do not use spreadsheets
DUse Excel only for printing pretty reports; classification stays manual
Answer & Solution
Correct answer: A. Extract contract data into Excel; codify Ind AS 109 'own-use' / net-settlement-in-practice tests via logical functions (IF/AND/OR/VLOOKUP); apply consistently across the contract portfolio with a flag for derivative vs executory
Codifying Ind AS 109's substance tests (net-settlement intent, history of net settlement, own-use exception) in Excel formulae allows consistent classification at scale. Manual-only (A, C) loses consistency; defaulting all net-settled to derivative (D) ignores the own-use exemption.
Related questions
Which of the following is the MOST defensible position on whether automation can fully repNew Way Ltd. wants to (i) define enforceable-rights criteria for identifying contracts undA listed company's ICOFR weakness states 'no procedures to ensure all postings have occurrWhich of the following is the WEAKEST automated control to detect potential inventory frauA Responsibility Assignment Matrix (RAM/RACI) is configured into the ERP for ICOFR. The BEIdentify the MOST appropriate use of the ERP audit trail comparing 'transaction date' vs 'An ERP integrates ICOFR for inventory. Which control combination BEST addresses the risk tAn entity sells broadband, voice and modem in various combinations. To codify Ind AS 115 d