Automated Sampling Plan Generator for Audit Testing

This spreadsheet computes sample sizes and selection rules for audit testing using standard statistical sampling methods (attribute and monetary unit sampling). Input population size and desired confidence/tolerable error rates to get sample counts, selection intervals and stratification suggestions. Include random selection via RAND and INDEX for reproducible picks and document the sampling seed. The sheet produces a sample selection list and a template for recording testing results and exceptions. This standardizes audit testing and ensures statistical validity for control testing and substantive procedures.