You are the audit senior responsible for the audit of Mavuno Supermarkets Ltd., a large retail chain with over 50 outlets
across Africa. The Supermarket recently implemented a new Enterprise Resource Planning (ERP) system that integrates its
sales, inventory, payroll and supplier management modules.
Your audit firm, Integrity Auditors, a firm of Certified Public Accountants, plans to leverage data analytics tools to
enhance audit efficiency and improve the quality of audit evidence throughout the engagement. The engagement partner
has therefore requested you to assess how data analytics could be applied at different stages of the audit.
To achieve this, the audit team has proposed the following data analytics tests:
- Using Benford’s Law to identify unusual or irregular sales transactions.
- Applying continuous auditing tools to flag transactions exceeding user-defined limits in real time.
- Performing data matching between supplier invoices and goods received notes to detect fictitious vendors.
- Conducting trend and ratio analysis to identify branches with declining profit margins.
- Testing payroll data for duplicate bank accounts and potential ghost employees.
Despite these initiatives, the engagement partner has expressed several concerns, particularly regarding:
- The reliability and integrity of client data extracted from the ERP system.
- The competence of the audit team in effectively using data analytics tools.
- The interpretation and documentation of data analytics results as sufficient and appropriate audit evidence.
- Data security and confidentiality: Ensuring that client data accessed for analytics is handled securely to prevent
unauthorised access or breaches.
Required:
(a) (i) Discuss how data analytics could be applied at the planning, execution and completion stages of the audit
of Mavuno Supermarkets Ltd. to enhance audit effectiveness. (ii) With reference to the concerns raised by the engagement partner, evaluate the THREE challenges
Integrity Auditors might face in using data analytics for the audit of Mavuno Supermarkets Ltd. and
recommend appropriate responses to each challenge.
(b) Suggest FOUR ways to address the concerns raised by the engagement partner regarding the use of data analytics
in the audit engagement.
Answers and Explanations are locked.
Login to View Answer