PracticeAUDFree practice exam

AUD · Performing Further Procedures and Obtaining Evidence · 6 practice questions

Testing Completeness and Accuracy of Client Reports

Test client reports for completeness and accuracy before using them as audit evidence. Follow the checklist to validate a rebate report, judge analytical precision, and identify when tests of details are required.

The ruleEstablish the completeness and accuracy of entity-generated reports before relying on them. Substantive analytics require a sufficiently precise expectation; a substantive response to an assertion-level significant risk must include tests of details.

Try one first

During the Year 1 audit of Hark Co., the auditor plans to use an entity-generated report that lists shipments dated in the last seven days of Year 1 and the first seven days of Year 2 as the sole population for sales cutoff testing and to develop an expectation of year-end shipping trends. The auditor learned that (1) the controller manually enters date parameters each time the report is run, (2) IT change-management controls over the report logic were ineffective during Year 1, (3) sales returns and manual revenue journal entries posted through a separate module do not appear on the report, and (4) the entity does not reconcile the report to the general ledger. Before relying on this report as audit evidence, the auditor should:
Hint

Focus on whether the population/report itself is complete and accurate for the intended audit use, not only on verifying individual listed items.

Step by step

  1. Define the report's purpose

    For a year-end rebate accrual, identify which sales qualify under customer contracts. The report must capture the eligible sales needed to test that accrual.

  2. Check logic and scope

    Test the report's logic, date parameters, and source coverage, or test relevant controls over its preparation. Investigate exclusions that could omit eligible sales.

  3. Test the underlying sales

    Trace eligible shipments from source records into the report for completeness; vouch reported sales to supporting records for accuracy. Check whether shipment dates meet the contracts' eligibility terms.

  4. Judge analytical precision

    Determine whether your expectation can detect a potentially material misstatement in the accrual. Customer-specific tiers and catch-up provisions can make a broad sales-based expectation too imprecise.

  5. Apply the significant-risk requirement

    If the assertion is a significant risk and your response is substantive, include tests of details. Reliable inputs and a precise expectation do not remove this requirement.

  6. Resolve contradictory evidence

    Inspect unusual January rebate settlements and supporting shipment records. Determine whether eligible year-end sales were omitted from the report and accrual.

Key points

  • Remember: A correct formula can still produce the wrong accrual when eligible sales are missing.
  • Agreement with the general ledger does not establish that every eligible sale appears in the report.
  • Management explanations and written representations do not resolve contradictory evidence without supporting audit procedures.

How the exam traps you

  • Recalculate more accrual amounts using the same untested sales report. Test the report inputs, not just the formula applied to them.
  • Vouch selected report entries and conclude the report is complete. Also trace eligible sales from source records into the report to test for omissions.
  • Use precise analytics alone for a significant risk because the report is reliable. A substantive response to an assertion-level significant risk must include tests of details.

5 more, each from a different angle

0 of 5 answered · 0 correct

Question 2

In the Year 1 audit of a manufacturer, valuation of slow-moving specialized inventory is a significant risk. Management's year-end reserve is based on an internally generated aging report and a write-down matrix, but several high-dollar items received lower write-downs because management expects to sell them through pending customer negotiations. The audit team will perform substantive procedures only and will not test operating effectiveness of controls over report generation. Physical existence and quantity were verified; valuation remains the issue. Which audit response would provide the most appropriate evidence about the inventory reserve?
Hint

First consider whether the aging report's source data can be trusted; then think about what item-level, external, or post-year evidence would convincingly corroborate management's override decisions.

Question 3

In the audit of Orion Data Co., a material year-end accrued revenue balance relates to December usage-based charges that are billed in January. The auditor assessed a significant risk because the accrual is generated from a spreadsheet prepared by the revenue manager using data from a recent system conversion, and several of Orion's largest contracts contain customer-specific billing caps and credits. Orion's customers do not receive usage statements until after year-end and generally do not maintain records at the same contract-and-day level used by Orion. The auditor has already recalculated the spreadsheet formulas, performed high-level analytical procedures, and made inquiries of management. Assume the auditor will not rely on controls. Which additional procedure would most directly obtain sufficient appropriate evidence over the year-end accrual?
Hint

Ask which procedure attacks the most vulnerable link: the reliability of the inputs and contract terms, not just the spreadsheet output.

Question 4

During the audit of River Co., the allowance for expected credit losses is material. The auditor plans to compare current-year loss rates to prior years using River's aged trial balance and then discuss unusually old accounts with the credit manager. River changed its billing system in 20X5, the aging report logic was modified during the year, and the auditor did not test controls over report generation. Several individually significant customer balances are more than 120 days past due at year-end. Assuming no confirmations have yet been sent, which conclusion is best supported regarding the planned audit evidence?
Hint

Focus first on whether the auditor can rely on the report being used, and then on whether broad analytics and inquiry are enough for specifically risky balances.

Question 5

In the audit of a manufacturer's year-end customer rebate accrual, the auditor is considering using a substantive analytical procedure as the primary source of evidence. The auditor has tested the completeness and accuracy of the entity-produced sales report used in the analysis and found the relevant IT-dependent controls effective. Historically, rebate expense closely tracked monthly sales by product line. In 20X6, however, one large customer entered a new contract with tiered volume rebates and a year-end catch-up provision that can cause the rebate rate to change sharply once annual thresholds are met. The rebate accrual is material but not assessed as a significant risk. Assume no scope limitation and that the question is whether the analytical procedure can stand largely on its own rather than be supplemented by substantial tests of details. Which factor should govern that decision?
Hint

Do not stop at whether the source data is reliable. Ask whether the analytical model remains predictably tight enough after the contract terms changed.

Question 6

In the audit of a manufacturer's Year 2 financial statements, the auditor is evaluating whether sufficient appropriate evidence has been obtained for the valuation of trade receivables through management's allowance estimate. Management's model relies heavily on an ERP-generated aging report. The auditor tied the report's total receivables balance to the general ledger, but did not test controls over the report and did not test whether individual balances were assigned to the correct aging buckets. The auditor also obtained positive confirmations and tested subsequent cash receipts for selected large customers, which supported the existence of most year-end receivables. Economic conditions worsened late in Year 2, yet management recorded only a modest increase in the allowance. Assume no additional procedures were performed on the aging data or on management's forward-looking assumptions. In deciding whether more audit work is needed, what governing factor should drive the auditor's conclusion?
Hint

Focus on the assertion being tested and ask whether the evidence actually addresses that assertion, not just whether the auditor has collected a lot of evidence.

Drill all 119 Procedures to Obtain Sufficient Appropriate Evidence questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

How do auditors test completeness and accuracy of client-generated reports?

Test report logic, parameters, and source coverage, or relevant controls over report preparation. Trace source transactions into the report for completeness and vouch reported transactions to supporting records for accuracy.

When are substantive analytical procedures precise enough?

The expectation must be precise enough to detect a potentially material misstatement. Customer-specific rebate tiers and catch-up provisions can make a broad sales-based expectation too imprecise, even when the sales data are reliable.

Can substantive analytical procedures alone address a significant risk?

No. A substantive response to an assertion-level significant risk must include tests of details, even when the underlying data are reliable and the analytical expectation is precise.

Watch it solved

A full CPA AUD task-based simulation on Procedures to Obtain Sufficient Appropriate Evidence, worked step by step.

Audit Assertions & Substantive Procedures | CPA AUD Simulation (TBS) on YouTube

Practice AUD like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on Procedures to Obtain Sufficient Appropriate Evidence

All Procedures to Obtain Sufficient Appropriate Evidence practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.