3.5 Audit Data Analytics And Analytical Procedures
“the science and art of discovering and analyzing patterns, identifying anomalies, and extracting other useful information in data underlying or related to the subject matter of an audit through analysis, modeling, and visualization for the purpose of planning or performing the audit.” audit data analytics professional skepticism and exercise professional judgment. ADAs are methods of performing various audit procedures, including those applied in (a) risk assessment (planning), (b) tests of controls, (c) substantive analytical procedures, (d) tests of details, or (e) final review (forming an overall conclusion). The auditor should plan and perform ADAs and other procedures with visualizations. they also often help auditors process large volumes of complex data. ADAs include reports and plan the ADA access and prepare the data consider the relevance and reliability of the data perform the ADA Evaluate the results and conclude whether the purpose and objectives have been achieved. five basic steps are an approach an auditor might use to plan, perform, and evaluate the results of an ADA: Determine the overall purpose and objectives of the ADA and select the ADA that is likely best suited for the intended purpose and objectives, including the methods, tools, graphics, and tables to be used. plan the ADA Format and filter the data. Consider the ability to maintain data security and integrity. access and prepare the ADA Evaluate the relevance, availability, and reliability of the data. consider the relevance and reliability of the data Obtain output and judge whether the identified items warrant further auditor consideration. perform the ADA Document the steps and results in the audit documentation (working papers). Evaluate the results and conclude whether the purpose and objectives have been achieved. a study of plausible relationships among financial and nonfinancial data. Analytical procedures are evaluations of financial information made by investigating fluctuations or relationships that (a) are inconsistent with other information or (b) differ significantly from expectations. Plausible relationships among data are reasonably expected to exist and continue in the absence of known conditions to the contrary. Analytical procedures also include substantive procedures. Analytical procedures may be applied not only as risk assessment procedures (analytical procedures used to plan the audit) but also as _______ These are procedures (tests of details and analytical procedures) designed to detect material misstatements at the assertion level. substantive procedures Determine their suitability for specific assertions after considering the assessed RMMs and any tests of details. Evaluate the reliability of data used to develop an expectation of an amount or ratio. Develop an expectation and determine whether it is sufficiently precise to identify a material misstatement. Use them to assist in forming an overall conclusion near the end of the audit about whether the statements are consistent with the auditor's understanding of the entity. When applying substantive analytical procedures, the auditor should the understanding of the client's business and significant transactions and events since the last audit. They also may identify unusual transactions or events and amounts, ratios, and trends that might indicate matters with audit planning implications. But when they use highly aggregated data, they provide only broad indications about the RMMs. Analytical procedures applied as risk assessment procedures at the beginning of the audit may improve Financial Information from Comparable Prior Period(s) Anticipated Results, such as budgets or forecasts prepared by management (or others) prior to the end of the period Relationships among Elements of Financial Information, such as those among the balances on the financial statements Comparable Information from the Client’s Industry Relationships between Financial and Relevant Nonfinancial Information The auditor develops expectations or predictions of recorded balances or ratios. The candidate should learn the five sources of information used to develop analytical procedures. They are frequently tested on the CPA exam. trend of sales- If a client's prior reported sales were $120,000 in Year 1, $130,000 in Year 2, and $140,000 in Year 3, respectively, the auditor is likely to predict Year 4 sales to be approximately $150,000 based on the trend. If management's reported sales are materially different, the auditor increases the assessed RMM and investigates the underlying causes. Financial Information from Comparable Prior Period(s) budgeted results- If management's budget at the beginning of the period includes cost of sales of $100,000, the auditor expects cost of sales to approximate $100,000 at year end. The use of standard costs and variance analysis facilitates the application of analytical procedures in this context. Anticipated Results, relation of sales and A/R-If the auditor determines that sales increased by 25% for the year, accounts receivable should increase by approximately that amount. Relationships among Elements of Financial Information, industry inventory turn over ratio- If the usual inventory turnover ratio in the industry is 10 times per year, the auditor expects the client's turnover ratio to be approximately 10 times. Comparable Information from the Client’s Industry labor costs and hours worked-If the number of hours worked increased by 30%, the auditor expects an increase in labor costs of approximately 30%. Relationships between Financial and Relevant Nonfinancial Information
Document information
- Uploaded on
- October 5, 2022
- Number of pages
- 7
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers