PracticeAUDFree practice exam

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

Audit Data Suitability: Relevance and Precision

Accurate, complete data must also fit the measure and level of detail needed for the audit procedure. Below, one net-sales scenario changes one fact at a time to show what makes a report suitable.

The ruleWhen using entity-produced information, obtain evidence about its accuracy and completeness and evaluate whether it is sufficiently precise and detailed for the purpose. If it does not fit, obtain suitable data or redesign the procedure.

Try one first

An auditor plans to use a substantive analytical procedure as primary evidence over Year 2 recorded net sales. Management provides a client report showing monthly units shipped by product family and the current list price for each family. The auditor expects to be able to test completeness and accuracy of the units-shipped data from the ERP. However, list prices changed twice during the year for several high-volume products, discounts vary significantly by product family, and the report omits returns and actual transaction prices. No separate substantive procedures over discounts or returns have yet been designed. Before relying on this report for the planned analytical procedure, what should the auditor do?
Hint

Ask whether the dataset measures net sales (actual transaction prices less discounts and returns) or a different metric (e.g., units × current list price).

Same scenario, one fact changes

Base case

During Alder Co.'s Year 2 audit, the auditor plans monthly net-sales analytics. An ERP report provides transaction-level units shipped and actual sales amounts net of discounts and returns, grouped by month. Prices and discounts vary during the year. The auditor has tested the report's logic, completeness, and accuracy.

Answer: Suitable as an input to the monthly net-sales analytics.

The tested report measures actual net sales and provides the monthly detail the procedure needs. Suitability as an input does not, by itself, establish that the analytical procedure provides sufficient evidence.

Before you open each one, predict the answer.

Change 1The report substitutes units multiplied by current list prices for actual sales amounts net of discounts and returns.

Answer: Not suitable without adjustment or redesigned procedures.

Current list prices omit actual pricing differences, discounts, and returns. Tested unit counts do not make that measure suitable for net-sales analytics.

Change 2The report is aggregated to annual totals, with no monthly or transaction detail.

Answer: Not suitable for the planned monthly analytics.

Accurate annual totals cannot supply the monthly amounts needed for monthly expectations. Obtain monthly detail or redesign the procedure.

Change 3The report comes from a spreadsheet rather than the ERP; all other facts remain unchanged.

Answer: Still suitable as an input to the monthly net-sales analytics.

The source change does not defeat suitability. The stated testing still supports the report, and its measure and monthly detail still fit.

Key points

  • Remember: accurate data can still be the wrong data for the procedure.
  • Net-sales analytics need actual sales amounts after discounts and returns, not units multiplied by current list prices.
  • Monthly expectations require monthly information; annual totals hide the detail needed.
  • A spreadsheet is not automatically unsuitable, just as an ERP report is not automatically suitable.

How the exam traps you

  • Treating tested completeness and accuracy as proof that current list prices measure net sales. Check whether the amounts reflect actual transaction prices, discounts, and returns.
  • Using accurate annual totals to develop monthly expectations. Obtain monthly detail before using the report for monthly analytics.
  • Rejecting a tested report solely because it comes from a spreadsheet. Evaluate its evidence and fitness for the procedure, not just its source.

Now the same facts as questions

Each question changes one fact from the one before. Watch which change flips the answer.

Question 1

During Alder Co.'s Year 2 audit, the auditor plans monthly net-sales analytics. An ERP report provides transaction-level units shipped and actual sales amounts net of discounts and returns, grouped by month. Prices and discounts vary during the year. The auditor has tested the report's logic, completeness, and accuracy. Which conclusion is best supported?

Question 2

Same facts, except the report substitutes units multiplied by current list prices for actual sales amounts net of discounts and returns. What should the auditor conclude?

Question 3

Same facts, except the report is aggregated to annual totals, with no monthly or transaction detail. Is it suitable for the planned monthly net-sales analytics?

Question 4

Same facts, except the report comes from a spreadsheet rather than the ERP; all other facts remain unchanged. Which conclusion is best supported?

3 more, each from a different angle

0 of 3 answered · 0 correct

Question 2

During the Year 2 audit of a manufacturer, the auditor plans to test the customer rebate liability by developing an independent expectation from a system-generated sales report. The report is a standard ERP report; IT general controls and relevant application controls over sales processing and report generation were tested and found effective, no manual post-export changes were made, and the report's annual sales total agrees to the general ledger. However, the report summarizes sales only by product family and quarter. Rebate percentages differ by customer tier, and several significant contracts changed rebate rates during Q3. The auditor intends to use the report as the principal data input for a substantive analytical procedure. What is the primary issue the auditor should address before using this report as audit evidence?
Hint

Separate two questions: Is the data reliable, and is it granular enough for the way the auditor plans to use it?

Question 3

An auditor plans a substantive analytical procedure over Year 2 product revenue and wants to use (1) a monthly internal "net sales by channel" report from the entity's data warehouse and (2) monthly industry sales statistics from a national trade group. Assume the auditor needs data that are suitable for developing a monthly expectation of total recognized product revenue across all channels. The following facts are known: - The internal report is a custom report built from ERP order, shipping, and billing tables. - Testing of IT general controls identified ineffective program-change controls over custom reports. - The auditor reconciled the annual total on the internal report to the general ledger. - For a sample of transactions around year-end, the auditor reperformed the report logic and found the report records sales by invoice date, while the entity recognizes revenue on shipment date. - The report also records returns in the month the credit memo is issued rather than the month of the original sale. - The trade-group statistics are from a reputable source but cover only the domestic retail channel, which represents 62% of the entity's total revenue. Which conclusion is best supported regarding use of this data and information, without additional adjustment, for the planned substantive analytical procedure?
Hint

Separate two questions: Is the information reliable enough, and is it fit for this exact audit purpose? A report can pass some reliability testing and still be unusable if its timing or coverage does not match the assertion being tested.

Question 4

An auditor plans to test the reasonableness of monthly warranty expense using a report prepared in the normal course of business that lists warranty claims by month. Which factor most directly governs whether the auditor can appropriately use this report as audit evidence for that procedure?
Hint

Focus on what the auditor must establish about entity-produced information before relying on it, not just who reviewed it or how it was produced.

Drill all 120 Use of Data and Information questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

What makes audit data relevant and sufficiently precise?

The data must match what the procedure tests and provide enough detail. For monthly net-sales analytics, that means actual net sales amounts and monthly information.

Why aren't accurate units shipped and list prices enough to test net sales?

Current list prices do not capture changing transaction prices, discounts, and returns. Accurate unit counts do not fix that measurement mismatch.

Can an auditor use a spreadsheet as audit evidence?

Yes. In this scenario, the spreadsheet remains a suitable input because its logic, completeness, and accuracy were tested, and its measure and monthly detail fit the procedure.

Watch it solved

A full CPA AUD task-based simulation on Use of Data and Information, worked step by step.

Data Extract Reliability & Duplicate Payments | CPA AUD 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 Use of Data and Information

All Use of Data and Information 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.