Analytical Procedures: From Trend to Audit Question

A surprising ratio is the beginning of an investigation, not its conclusion. The value of analytical procedures comes from turning an unexpected relationship into a question that the evidence can answer.

Start with the business relationship

Consider a hypothetical retailer whose sales are growing while its gross margin percentage falls. That combination can have several explanations: a different product mix, more promotions, higher purchase costs, recording differences or a combination of changes. The movement alone does not tell you which explanation is correct.

First define the decision. Are you trying to understand commercial performance, identify where audit work should focus, or obtain evidence about a particular financial statement assertion? The same chart can support different purposes, but it cannot automatically deliver the same assurance.

Make the comparison meaningful

Confirm that both periods use comparable populations, dates, currencies, accounting policies and definitions. Separate new stores from established stores when that distinction matters. Check whether returns, rebates and inventory adjustments enter the measure consistently.

A trend compares the measure over time. A ratio relates one measure to another. Common-size analysis expresses components against a chosen base. Each can reveal a useful question, but the denominator and aggregation can conceal changes within the business.

Develop an expectation before the explanation

State what relationship you expected and why. For the illustrative retailer, compare category-level margin movements with changes in category sales mix. A lower total margin might be compatible with more sales in lower-margin categories, even when category margins remain broadly stable.

Treat that as a hypothesis. Do not write that product mix caused the movement until the records support it. Explain which data would distinguish mix from price, purchase cost or timing differences. A budget can be a comparison point; it still needs scrutiny if it was unrealistic or built on a different scope.

Follow the difference to evidence

Select the category, period or transaction group that drives the unexpected movement. Compare source sales records, pricing changes, purchase terms and relevant accounting entries. Ask the responsible team for context, then corroborate important explanations with records that answer the question.

If the explanation accounts for only part of the movement, keep the unexplained portion visible. An attractive narrative is not a substitute for a reconciliation. A stable overall ratio can also conceal offsetting errors or differences between segments.

Match the conclusion to the work

PCAOB AS 2305, a US external-audit standard, discusses substantive analytical procedures, including data reliability, expectation precision and investigation of unexpected differences. It also distinguishes that purpose from analytical work used to assess risk.

For substantive use, procedure design must address the relevant assertion and required assurance. A broad dashboard comparison should not be described as a completed substantive test simply because it covers every record. The applicable engagement standards and methodology determine the work required.

Leave a traceable answer

Document the population, measure, comparison, expectation, difference, explanations tested, corroborating evidence and remaining uncertainty. State what the work supports and what additional procedures are necessary.

The useful output is a supported answer to a business question—not a chart with a confident story attached.

Beyond the numbers. Inside the business.