Study guide
7.4 Substantive Analytical Procedures (AU-C 520)
AICPA CPA Exam — Auditing & Attestation AUD
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Orientation & the Auditing Regulatory Environment
1.1 CPA AUD Exam Structure, Scoring & Blueprint Strategy 1.2 Regulatory Authorities & Auditing Standards Hierarchy 1.3 Preconditions for an Audit & Engagement Letters (AU-C 210)
2 Chapter 2: Professional Ethics & the AICPA Code of Conduct
2.1 AICPA Code of Professional Conduct & Conceptual Framework 2.2 Independence Rules: AICPA vs. SEC and PCAOB Standards 2.3 Independence Under Government (GAGAS) & Employee Benefit (DOL) Standards 2.4 Professional Skepticism, Professional Judgment & Client Confidentiality
3 Chapter 3: Quality Management at Firm & Engagement Levels
3.1 Firm System of Quality Management: SQMS No. 1 3.2 Engagement Quality Reviews: SQMS No. 2 3.3 Engagement-Level Quality Management: SAS 146 & AU-C 220
4 Chapter 4: Audit Planning, Strategy & Materiality
4.1 Audit Planning & Overall Audit Strategy (AU-C 300) 4.2 Materiality, Performance Materiality & Tolerable Misstatement (AU-C 320 & 450) 4.3 The Audit Risk Model & Risk Assessment Mechanics
5 Chapter 5: Entity Understanding, Inherent Risk & Internal Control
5.1 Understanding the Entity, Environment & Inherent Risk Factors (SAS 145 / AU-C 315) 5.2 Economic Conditions, Industry Factors & SOX Corporate Governance 5.3 COSO 2013 Internal Control Framework: 5 Components & 17 Principles 5.4 IT General Controls (ITGCs) & Application Controls 5.5 Evaluating Design & Implementation of Controls
6 Chapter 6: Fraud Risk, Laws & Specialized Resources
6.1 Fraud Risk Assessment & Auditor Responses (AU-C 240) 6.2 Consideration of Laws, Regulations & Non-Compliance (AU-C 250 & NOCLAR) 6.3 Group Audits: AU-C 600 and the SAS No. 149 Transition 6.4 Using the Work of Internal Auditors (AU-C 610) & Specialists (AU-C 620)
7 Chapter 7: Audit Evidence Fundamentals & General Procedures
7.1 Audit Evidence: Sufficiency, Appropriateness & Management Assertions (AU-C 500) 7.2 Audit Data: Relational Databases, Measurement Scales, Extraction & Reliability 7.3 Types of Audit Procedures & Audit Data Analytics (ADA) 7.4 Substantive Analytical Procedures (AU-C 520)
8 Chapter 8: Audit Sampling Concepts & Attribute Testing
8.1 Audit Sampling Principles & Sampling Risk (AU-C 530) 8.2 Attribute Sampling for Tests of Controls 8.3 Non-Statistical Sampling & Dual-Purpose Testing
9 Chapter 9: Variables Sampling & Monetary Unit Sampling (MUS)
9.1 Classical Variables Sampling Methods (MPU, Ratio, Difference) 9.2 Monetary Unit Sampling (MUS / PPS) Mechanics & Sizing 9.3 Evaluating Variables Sampling Results & Upper Misstatement Limits
10 Chapter 10: Substantive Testing: Revenue, Receivables & Confirmations
10.1 Auditing the Revenue and Receivables Cycle & Cutoff 10.2 External Confirmations: Positive, Negative & Non-Responses (AU-C 505) 10.3 Allowance for Credit Losses (CECL) & Valuation of Receivables
11 Chapter 11: Substantive Testing: Purchasing, Inventory, Cash & Long-Term Assets
11.1 Purchasing, Accounts Payable & Search for Unrecorded Liabilities 11.2 Inventory Observation & Valuation (AU-C 501) 11.3 Auditing Cash, Bank Reconciliations & Interbank Transfers (Kiting) 11.4 Auditing Property, Plant & Equipment, Debt & Equity Cycles
12 Chapter 12: Complex Estimates, Related Parties & Concluding Evidence
12.1 Auditing Accounting Estimates & Fair Value (AU-C 540) 12.2 Investments in Securities, Derivatives & Equity-Method Investees 12.3 Related Parties & Significant Unusual Transactions (AU-C 550) 12.4 Litigation, Claims & Assessments and Legal Inquiry (AU-C 501 / ASC 450) 12.5 Subsequent Events & Subsequently Discovered Facts (AU-C 560)
13 Chapter 13: Final Evaluation, Written Representations & Documentation
13.1 Evaluating Audit Findings & Misstatement Accumulation (AU-C 450) 13.2 Going Concern Evaluation (AU-C 570) 13.3 Written Management Representations (AU-C 580) 13.4 Audit Documentation, Assembly & Retention (AU-C 230)
14 Chapter 14: The Standard Audit Report & Opinion Modifications
14.1 The Standard Unmodified Audit Report (AU-C 700) 14.2 Audit Report Modifications: Qualified, Adverse & Disclaimer (AU-C 705) 14.3 Emphasis-of-Matter & Other-Matter Paragraphs (AU-C 706) 14.4 Key Audit Matters (AU-C 701) & Critical Audit Matters (AS 3101)
15 Chapter 15: Comparative Statements, Other Information & PCAOB Reporting
15.1 Comparative Financial Statements & Predecessor Auditor Reporting 15.2 Other Information, Supplementary Information & Special Purpose Frameworks 15.3 Reviews of Interim Financial Information (AU-C 930 & PCAOB AS 4105) 15.4 PCAOB Reporting & Integrated Audits of ICFR (AS 3101 & AS 2201)
16 Chapter 16: SSARS Engagements: Preparation, Compilation & Review
16.1 The SSARS Framework & Hierarchy of Services (AR-C 60-90) 16.2 Preparation of Financial Statements (AR-C 70) 16.3 Compilation Engagements (AR-C 80) 16.4 Review of Financial Statements (AR-C 90)
17 Chapter 17: SSAE Attestation, SOC Reports & Government Audits
17.1 The SSAE Attestation Framework: Assertion-Based and Direct Examinations and Reviews 17.2 Agreed-Upon Procedures Engagements (AT-C 215, SSAE No. 19) 17.3 Service Organization Controls: SOC 1 & SOC 2 Engagements (AT-C 320) 17.4 Reporting on Compliance: AU-C 806, AT-C 315 & AU-C 935 17.5 Government Auditing Standards (Yellow Book / GAGAS) & Uniform Guidance Single Audits
7.4 Substantive Analytical Procedures (AU-C 520)
Key Takeaways Explain This Topic AI
Analytical procedures evaluate plausible relationships among both financial and non-financial data; they are based on the premise that plausible relationships continue in the absence of known conditions to the contrary.
Analytical procedures are MANDATORY in two audit stages: Risk Assessment / Planning (AU-C 315) and Final Overall Review (AU-C 520); they are DISCRETIONARY / OPTIONAL as Substantive Procedures (AU-C 330/520).
Executing substantive analytical procedures requires a rigorous 4-step framework: (1) Determine suitability, (2) Evaluate data reliability, (3) Develop an independent expectation with sufficient precision, and (4) Compare recorded amounts to expectation and investigate differences exceeding the tolerable threshold.
Expectation precision is the critical determinant of effectiveness, influenced by relationship predictability (income statement accounts are more predictable than balance sheet accounts), data disaggregation, and reliance on independent non-financial operating metrics.
Under AU-C 520, the auditor must document the developed expectation, comparison results, and any additional procedures performed to investigate unexplained differences; management inquiries alone are never sufficient to corroborate significant variances.
Last updated: September 2026
7.4 Substantive Analytical Procedures (AU-C 520)
Core Principle: Under AU-C 520 ( Analytical Procedures ), analytical procedures consist of evaluations of financial information made by a study of plausible relationships among both financial and non-financial data. Analytical procedures also encompass the investigation of identified fluctuations or relationships that are inconsistent with other relevant information or that differ from expected values by a significant amount. A basic premise underlying analytical procedures is that plausible relationships among data may reasonably be expected to exist and continue in the absence of known conditions to the contrary .
1. The Three Audit Stages of Analytical Procedures
One of the most frequently tested concepts on the CPA AUD exam is distinguishing between the stages where analytical procedures are mandatory versus where they are discretionary (optional) . THE THREE STAGES OF ANALYTICAL PROCEDURES
- STAGE 1: PLANNING STAGE 2: SUBSTANTIVE STAGE 3: FINAL REVIEW
- (Risk Assessment - AU-C 315) (Fieldwork - AU-C 330/520) (Overall Conclusion - AU-C 520)
- +----------------------------+ +----------------------------+ +----------------------------+
- | MANDATORY | | DISCRETIONARY / OPTIONAL | | MANDATORY |
- | | | | | |
- | - Purpose: Identify areas | | - Purpose: Detect material | | - Purpose: Form overall |
- | of heightened RMM and | | misstatements at the | | conclusion whether F/S |
- | unusual transactions | | assertion level | | are consistent with |
- | - Data: Highly aggregated, | | - Data: Highly disaggre- | | auditor's understanding |
- | high-level financial & | | gated, detailed monthly | | - Data: Broad, high-level |
- | operating figures | | data, non-financial data | | financial statement level|
- +----------------------------+ +----------------------------+ +----------------------------+
- Detailed Comparison Table
- Dimension 1. Risk Assessment (Planning) 2. Substantive Procedures 3. Final Overall Review
- Standard AU-C 315 AU-C 330 & AU-C 520 AU-C 520
- Status MANDATORY DISCRETIONARY (OPTIONAL) MANDATORY
- Timing Initial planning phase Substantive fieldwork phase Near completion of the audit
Primary Objective Identify unexpected fluctuations, unusual transactions, and high-risk accounts to plan the nature, timing, and extent of procedures. Gather substantive audit evidence to reduce detection risk to an acceptably low level for specific assertions. Assist the auditor in forming an overall conclusion as to whether financial statements are consistent with the auditor's understanding of the entity.
Level of Data Aggregation High-level / Aggregated: Consolidated trial balance, prior-year comparisons, high-level liquidity/profitability ratios. Disaggregated: Monthly figures, store-by-store sales, product-line gross margins, volume-rate formulas. Broad / Aggregated: Executive-level financial statements, revised disclosures, significant changes from planning.
Auditor Action if Variance Occurs Directs further audit attention and expands planned substantive testing in that cycle. Requires formal investigation: inquire of management, obtain corroborating evidence, or expand tests of details. Re-evaluates audit conclusions; determines if previously unrecognized misstatement risks exist requiring additional testing.
Exam Trap (The Universal Requirement Trap): Substantive analytical procedures are never mandatory . The auditor may choose to test an account balance entirely through tests of details (e.g., physical inspection, confirmation, recalculation) without executing any substantive analytical procedures. Only risk assessment analytics and final overall-review analytics are required by GAAS.
2. The 4-Step Methodology of Substantive Analytical Procedures
When the auditor elects to use substantive analytical procedures, AU-C 520 dictates a rigorous four-step process : SUBSTANTIVE ANALYTICAL PROCEDURES: 4-STEP FRAMEWORK
- [ STEP 1: DETERMINE SUITABILITY ]
- Assess assertion predictability
- Balance efficiency vs. tests of details
- |
- v
- [ STEP 2: EVALUATE DATA RELIABILITY ]
- Assess source independence
- Test controls over underlying data (IPE)
- |
- v
- [ STEP 3: DEVELOP INDEPENDENT EXPECTATION ]
- Develop expectation BEFORE viewing recorded balance
- Maximize precision (disaggregation & non-financial drivers)
- |
- v
- [ STEP 4: COMPARE & INVESTIGATE DIFFERENCES ]
- Compare recorded amount to expectation
- If difference > Tolerable Threshold:
- * Inquire of management
- * Corroborate with audit evidence (Inquiry ALONE is never enough!)
- * Perform tests of details if uncorroborated
- Step 1: Determine the Suitability of the Procedure
Substantive analytical procedures are not equally effective for all financial statement accounts or assertions:
High Suitability: Large volumes of routine, predictable transactions that recur over time (e.g., rental revenue, straight-line depreciation, interest expense on fixed debt, utility expenses, standardized payroll).
Low Suitability: Non-routine transactions, unique year-end transactions, accounts subject to substantial management discretion or subjective estimates (e.g., warranty liabilities, goodwill impairment, litigation reserves, Level 3 derivative fair valuations). These require direct tests of details .
Step 2: Evaluate the Reliability of the Data Used
The persuasiveness of the expectation depends entirely on the reliability of the underlying data:
Source Independence: Data obtained from independent sources outside the entity (e.g., regulatory filings, published market interest rates, third-party leasing indices) is far more reliable than internal data.
Controls Over Data Preparation: If internal data is used (for example, production units, occupancy counts, or sales volumes), the auditor considers the controls over its preparation and may test those controls or test the data directly for accuracy and completeness (information produced by the entity, or IPE).
Comparability: Industry data must be drawn from genuinely comparable peers, not broad, unstratified global averages.
Audit Status: Prior-year data that was audited provides greater reliability than unaudited historical numbers.
Step 3: Develop an Independent Expectation with Sufficient Precision
The Cardinal Rule of Substantive Analytics: The auditor MUST formulate an independent expectation BEFORE comparing it to the client's recorded balance . Taking the client's recorded general ledger amount and seeking to rationalize it after the fact is a critical auditing failure.
Factors Governing Expectation Precision
Precision is the measure of the closeness of the auditor's expectation to the true underlying amount. Greater precision produces more persuasive audit evidence:
Predictability of the Relationship:
Income statement accounts are more predictable than balance sheet accounts because the income statement represents transactions accumulated over a period of time, whereas the balance sheet represents a snapshot at a single point in time subject to timing anomalies.
Contractual relationships are more predictable than discretionary expenses. Interest expense (governed by loan agreements) and rent expense (governed by lease terms) are highly predictable. Advertising expense, travel & entertainment, and research & development are subject to arbitrary management discretion and are inherently difficult to predict precisely.
Transactions in a stable economic environment are more predictable than those in volatile or rapidly shifting industries.
Level of Disaggregation:
The more disaggregated the data, the higher the precision.
Example: Developing an expectation for sales monthly by individual store is vastly more precise than developing a single annual expectation for total nationwide sales.
The Danger of Aggregation (Offsetting Errors): Highly aggregated data can mask significant material misstatements through offsetting errors (e.g., Store A overstates sales by $2,000,000 and Store B understates sales by $2,000,000; an aggregated annual analysis reveals zero variance!).
Availability and Use of Non-Financial Data:
Incorporating reliable physical operational drivers (e.g., number of occupied rooms in a hotel, number of credit hours billed by a university, total passenger miles flown by an airline) paired with contract pricing yields the most precise expectations.
- Step 4: Compare Recorded Amount to Expectation & Investigate Variances
- A. Setting the Tolerable Difference Threshold
Before performing the comparison, the auditor must establish a threshold of difference that can be accepted without further investigation (the tolerable difference). This threshold:
Is determined based on performance materiality and the desired level of assurance.
Must be small enough that a material misstatement could not hide inside it, so it is set with performance materiality and tolerable misstatement in mind.
B. Investigating Significant Differences
If the difference between the recorded amount and the auditor's independent expectation exceeds the tolerable threshold , AU-C 520 mandates a two-step investigation :
Inquire of Management: Seek management's business explanation for the variance.
Obtain Corroborating Audit Evidence: Inquiry alone is NEVER sufficient. The auditor must independently substantiate management's verbal statements by inspecting supporting documentation (e.g., examining amended contracts, checking price increase authorizations, reviewing bank statements).
Failure to Corroborate: If management cannot provide a valid explanation, or if their explanation is uncorroborated by evidence, the auditor must perform expanded substantive tests of details to quantify the misstatement.
3. Four Types of Analytical Models HIERARCHY OF ANALYTICAL PRECISION
- MODEL TYPE METHODOLOGY PRECISION LEVEL
- +-------------------+-----------------------------------------------+-----------------+
- | 1. TREND ANALYSIS | Comparing account balances across prior years | LOW |
- +-------------------+-----------------------------------------------+-----------------+
- | 2. RATIO ANALYSIS | Financial ratios compared to budget/industry | MODERATE |
- +-------------------+-----------------------------------------------+-----------------+
- | 3. REASONABLENESS | Mathematical models using operating drivers | HIGH |
- +-------------------+-----------------------------------------------+-----------------+
- | 4. REGRESSION | Statistical modeling measuring variables | HIGHEST |
- +-------------------+-----------------------------------------------+-----------------+
Trend Analysis: Comparing a recorded balance over multiple historical periods (e.g., comparing 2026 office supply expense to 2025 and 2024). Provides low precision because it ignores changes in operating conditions.
Ratio Analysis: Computing relationships between financial statement line items (e.g., gross margin percentage, inventory turnover, current ratio) and comparing them to prior years or industry benchmarks. Provides moderate precision.
Reasonableness Testing (Predictive Modeling): Developing a formal mathematical expectation using operational relationships and rate drivers (e.g., calculating expected apartment rental income: Units × Occupancy Rate × Average Monthly Rent × 12 months ). Highly persuasive.
Regression Analysis: Sophisticated statistical modeling that quantifies the exact mathematical relationship between independent economic/operational variables and dependent financial metrics. Provides the highest precision and statistical rigor.
4. Mandatory AU-C 520 Workpaper Documentation Rules
When an auditor performs substantive analytical procedures, AU-C 520 requires documentation of three items: the expectation and the factors considered in developing it (when not otherwise readily determinable), the results of the comparison, and any additional procedures performed on significant unexpected differences with their results. Recording the acceptable threshold is strong practice because it shows how differences were evaluated: +-------------------------------------------------------------------------------------------------------+
- | AU-C 520 DOCUMENTATION (3 REQUIRED ITEMS + THRESHOLD) |
- | |
- | 1. THE EXPECTATION: |
- | The auditor must document the expectation developed and the specific factors considered in its |
- | development (including data sources, assumptions, and formulas). |
- | |
- | 2. THE COMPARISON RESULTS: |
- | The recorded amounts, the expected values, and the quantitative comparison between the two. |
- | |
- | 3. THE ACCEPTABLE THRESHOLD (good practice): |
- | The maximum difference acceptable without further investigation (tolerable difference). |
- | |
- | 4. INVESTIGATION OF UNEXPECTED DIFFERENCES: |
- | Any additional auditing procedures performed when differences exceeded the threshold, management's|
- | explanations, and the specific CORROBORATING AUDIT EVIDENCE obtained. |
- +-------------------------------------------------------------------------------------------------------+
- 5. Concrete Substantive Analytical Models
- Model A: Apartment Complex Rental Revenue Reasonableness Test
Client Facts: Horizon Properties owns a 200-unit residential apartment building. Rent is fixed at $1,800/month per unit. The certified property manager's logs show an average occupancy rate of 95% for the 12-month fiscal year. The client recorded rental revenue of $4,350,000.
Auditor's Independent Expectation: Expected Revenue = 200 units × 95 % occupancy × $ 1 , 800 / month × 12 months = $ 4 , 104 , 000 \text{Expected Revenue} = 200\text{ units} \times 95\%\text{ occupancy} \times \$1,800/\text{month} \times 12\text{ months} = \$4,104,000 Expected Revenue = 200 units × 95% occupancy × $1 , 800/ month × 12 months = $4 , 104 , 000
Auditor's Tolerable Difference Threshold: $50,000.
Variance Analysis: Difference = $ 4 , 350 , 000 (Recorded) − $ 4 , 104 , 000 (Expected) = $ 246 , 000 \text{Difference} = \$4,350,000\text{ (Recorded)} - \$4,104,000\text{ (Expected)} = \$246,000 Difference = $4 , 350 , 000 (Recorded) − $4 , 104 , 000 (Expected) = $246 , 000
Audit Action: The variance of $246,000 far exceeds the tolerable threshold of $50,000. The auditor cannot accept the recorded amount. The auditor must inquire of management and independently corroborate any explanation (e.g., verifying whether unearned upfront lease prepayments were improperly recognized in revenue, which would violate cutoff and occurrence).
Model B: Long-Term Debt Interest Expense Reasonableness Test
Client Facts: Apex Corporation has three fixed-rate term bonds outstanding throughout the entire year:
- Tranche A: $10,000,000 at 5.0% coupon ($500,000)
- Tranche B: $15,000,000 at 6.0% coupon ($900,000)
- Tranche C: $5,000,000 at 4.0% issued on July 1 (half-year = $100,000)
Auditor's Independent Expectation: $1,500,000.
Client Recorded Expense: $1,502,500.
Variance: $2,500, which is well within the tolerable difference of $25,000. Substantive conclusion: Interest expense is materially accurate at the assertion level.