Free Excel template · AU-C 501

Inventory Observation Memo and Test Count Sheet (AU-C 501)

When inventory is material, AU-C 501 requires the auditor to attend the physical count (unless impracticable) to evaluate management’s instructions, observe the count, inspect the inventory and make test counts, and then test the final inventory records against the count results.

Standard
AU-C 501
Format
Excel (.xlsx)
Cost
Free
Access
No sign-up

What it is

When inventory is material, AU-C 501 requires the auditor to attend the physical count (unless impracticable) to evaluate management’s instructions, observe the count, inspect the inventory and make test counts, and then test the final inventory records against the count results.

This workbook has a memo tab for the observation (procedures, controls, condition, cut-off) and a test count tab that compares auditor counts with client counts in both directions and values the differences.

When to use it

What’s inside

Standard cited

This template follows AU-C 501. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use. See AU-C 501 explained.

Download free Excel template (.xlsx)

Questions

Is the auditor required to attend the inventory count?

If inventory is material, AU-C 501 requires attendance at the physical count unless that is impracticable. If attendance is impracticable, the auditor performs alternative procedures; if those fail to give enough evidence, the opinion is modified.

Why test counts in both directions?

Floor-to-sheet (tag to listing) tests completeness: items on hand are in the count. Sheet-to-floor (listing to tag) tests existence: items in the count are really there.

Related templates

Last updated 11/04/2026. All free templates.