Substantive Analytical Procedures: Techniques and Applications for CPA Auditors

What Are Substantive Analytical Procedures?

Substantive analytical procedures are audit procedures that use comparisons of financial and nonfinancial data, together with expectations developed by the auditor, to identify potential misstatements in the financial statements. Unlike tests of details, which examine individual transactions or balances, analytical procedures evaluate financial information by studying plausible relationships among data. They can be highly effective and efficient audit procedures when performed properly.

Auditing standards require the use of analytical procedures in two phases of the audit: during planning (to identify areas of potential risk) and during the overall review phase (to assess the conclusions reached and evaluate the overall presentation of the financial statements). Substantive analytical procedures are optional during the fieldwork phase but are often used as a substantive test when the relationships among data are predictable and stable.

Types of Analytical Procedures

Trend Analysis

Trend analysis compares current-period financial data with comparable prior-period data to identify significant changes. Simple trend analysis might compare current-year revenue to prior-year revenue and investigate any significant increases or decreases. More sophisticated trend analysis examines trends over multiple periods and considers the direction, magnitude, and consistency of changes. Trend analysis is most useful when the auditor has a clear expectation of what the trend should be based on the entity operations, industry conditions, and economic environment.

Ratio Analysis

Ratio analysis compares relationships among financial data to identify unusual patterns. Common ratios used in auditing include gross margin percentage, accounts receivable turnover and days sales outstanding, inventory turnover and days of inventory on hand, current ratio and quick ratio, and debt-to-equity ratio. Changes in these ratios from period to period or deviations from industry norms may indicate potential misstatements or areas requiring further investigation.

Reasonableness Testing

Reasonableness testing develops an independent expectation of a financial statement amount using financial and nonfinancial data. For example, the auditor might estimate interest expense by multiplying the average outstanding debt balance by the applicable interest rate. If the actual recorded interest expense differs significantly from this independently developed expectation, the difference warrants investigation. Reasonableness tests are particularly powerful because they use independent data to develop the expectation, making them less susceptible to management manipulation.

Regression Analysis and Statistical Techniques

More advanced analytical procedures use statistical methods such as regression analysis to develop expectations. Regression analysis can model the relationship between a dependent variable, such as sales, and one or more independent variables, such as advertising spending and store count, to predict what the financial statement amount should be. The precision of these models depends on the quality of the data and the strength of the relationships among the variables.

Developing the Expectation

The effectiveness of a substantive analytical procedure depends on the quality of the expectation the auditor develops. A vague or imprecise expectation will not detect misstatements because the auditor cannot distinguish between expected and unexpected results. To develop a reliable expectation, the auditor should use data from independent sources where possible, consider multiple factors that influence the financial statement amount, account for known changes in the entity operations, industry, or economy, and define a threshold for significant differences that is consistent with the overall audit plan.

The level of precision required in the expectation depends on the desired level of assurance from the analytical procedure. If the auditor plans to use the analytical procedure as the sole substantive test for an assertion, the expectation must be sufficiently precise to detect a material misstatement. If the analytical procedure is used in combination with tests of details, a less precise expectation may be acceptable.

Investigating Significant Differences

When the analytical procedure reveals a significant difference between the expected and recorded amounts, the auditor must investigate the cause. Investigation typically begins with inquiry of management and proceeds to corroborating the explanation with additional audit evidence. The auditor should not accept management explanations at face value but should verify them through independent data and other audit procedures.

Possible explanations for significant differences include actual misstatements in the financial statements, changes in business conditions or operations that the auditor did not consider when developing the expectation, and errors in the data used to develop the expectation. The auditor must determine which explanation is supported by the evidence and take appropriate action.

Documentation Requirements

When using substantive analytical procedures, the auditor must document the expectation and the factors considered in developing it, the results of the comparison between the expected and recorded amounts, the threshold used to identify significant differences, the investigation of any significant differences and the conclusions reached, and the basis for the auditor conclusion about the assertion being tested.

Tips for CPA Candidates

• Understand the three phases where analytical procedures are used in the audit and what is required versus optional.
• Know the different types of analytical procedures and when each is most effective.
• Be able to develop a reasonable expectation for a financial statement amount using available data.
• Understand the relationship between the precision of the expectation and the assurance obtained from the analytical procedure.
• Practice investigating differences and determining appropriate follow-up procedures.

Substantive analytical procedures are among the most powerful tools in the auditor arsenal. When performed thoughtfully, they can provide persuasive evidence about financial statement assertions while being more efficient than extensive detail testing.