AuditSampler

AuditSampler is a statistical sampling and data analytics software which enables efficient and effective audits based on statistical methods and the auditing standards (AU-C 530, ISA 530, ISA 315).

Easy-to-use audit tool to calculate the sample size, select samples and evaluate the results for Attributes Sampling, Monetary Unit Sampling and Classical Variables Sampling. Select samples based on random, systematic, cell and value-weighted selection. Query and filter data for exception reporting and analysis.

The sample size and upper error limits computed are in accordance with the AICPA audit sampling guide (Appendix A and Appendix C).

Our clients include CPA’s and accounting firms in these countries:

United States

Cayman Islands

Canada

Puerto Rico

South Korea

Netherlands

South Africa

Cyprus

Saudi Arabia

UAE

India

France

Bulgaria

Belgium

Sweden

Sarawak

Italy

Main Features and Sampling Methods

Audit Risk

• Audit Risk Calculator
  • Calculate RMM, DR, Substantive Assurance
• Audit Risk Assessment Worksheet
  • Identify and assess the risks of material misstatement
  • Identify significant account balances, classes of transactions
  • Identify inherent risks, relevant assertions and controls
  • Calculate RMM / DR for each account or class

Audit Risk Calculator

Audit Risk Assessment Worksheet

Attributes Sampling

• Tests of controls / compliance testing
• Three (3) sampling distributions:
  1. Binomial
  2. Hypergeometric (for small populations)
  3. Poisson
• Calculate a sufficient sample size:
  • Confidence level: 50% – 99%
  • Expected error rate: 0.00% – 18%
  • Tolerable error rate: 2% – 20%
• Select samples: systematic, random and cell selection methods
• Evaluate results: upper error limit (UEL) for deviations

Attributes Sampling

Sample Size (Binomial)

Evaluate Results (Binomial)

Sample Size (Hypergeometric)

Evaluate Results (Hypergeometric)

Attributes Select Sample

Systematic Sample Selection

Random Sample Selection

Cell Sample Selection

Monetary Unit Sampling (MUS)

• Substantive tests of transactions, account balances
• Calculate a sufficient sample size:
  • MUS confidence factor for sampling
  • Population value: up to 2000 million
  • Confidence level: 10% – 99%
• Select samples: systematic, random and cell value-weighted selection
• Evaluate results: lower/upper misstatement bounds

MUS Sampling

MUS Sample Size

MUS Evaluate Results

MUS Select Sample

MUS Systematic Selection

MUS Random Selection

MUS Random Selection (sorted)

MUS Cell Selection

Classical Variables Sampling (CVS)

• Substantive tests of transactions, account balances
• Overstatements, understatements, high error rate
• Calculate an efficient sample size:
  • Stratified difference/ratio estimation
  • Sample allocation: optimal, proportional
  • Confidence interval: 1 or 2-sided
  • Confidence level (1-alpha): 80% – 99%
  • Power (1-beta): 50% – 99%
• Select samples: stratified random selection
• Evaluate results: point estimate, lower/upper precision limits

Efficient Sample Size

CVS Sample Size 1-Sided

CVS Sample Size 1-Sided

CVS Sample Size 1-Sided

CVS Sample Size 1-Sided

CVS Sample Size 2-Sided

CVS Sample Size 2-Sided

CVS Sample Size 2-Sided

CVS Sample Size 2-Sided

Stratified Random Selection

CVS Evaluate Results

CVS Evaluate Results

Data Import/Export

• Import data from Excel, Csv, Txt, Sqlite files
• Import up to 20 million rows and 30 columns
• Export data and save as Excel, Csv, Txt, Sqlite files
• Save large data to SQLite file for fast access and reuse

Data Import CSV 20million

Data Import SQLite 20million

Excel 1million 30columns

CSV 1million 30columns

Data Analytics

• Statistics (min, max, avg, stdev, z-score, skewness, negative/zero/blank values)
• Boxplot (minimum, first quartile, median, third quartile, maximum, outliers)
• Query data and filter exceptions (<, >, =, !=, In, Like, Between, And, Or)
• Summarize data for analysis (group by field/date, stratification, aging)
• Chart analysis (histogram, column, line, scatter, pie, doughnut charts)
• Detect duplicate records, sequence gaps
• Add computed columns, join two tables

Data Query Filter

Statistics

Histogram

Boxplot

Boxplot Outliers

Boxplot Outliers

Boxplot Outliers

Outliers IQR Z-Score

Extreme Outliers

Stratification

Stratification

Stratification

Aging

Sales Analysis

Sales Analysis

Sales Analysis

Sales Analysis

Save/Copy/Paste Results

• Save sample results to Excel, Csv, Pdf file formats
• Copy and paste results directly into Excel and Word

Product Information

• AuditSampler v3 User Guide
• MUS systematic selection
• MUS random selection
• MUS random selection sorted
• MUS cell selection

AuditSampler is a Windows desktop application. Multiple windows can be open for multitasking. A temporary SQLite table is created for each user session to query the data and the temporary table is automatically deleted when that session ends. The application does not store any data.

System Requirements for Windows

• Operating system: Windows 10, 11 (64-bit), Windows Server 2019
• Memory: 4GB RAM or more

* Note: Mac OS is not supported.

Version Update

• 3.0.8879.42537 (23 April 2024)
• File Size: 4.82 MB

Version History:
2.0.7428.31722 (3 May 2020)
1.1.7340.39527 (5 Feb 2020)

Product License

Annual subscription based license, valid for one (1) year and includes software updates and upgrades. The subscription must be renewed every year to continue using the software.

• AuditSampler (2 User License) – USD $60

• AuditSampler (5 User License) – USD $120

• AuditSampler (Site License) – USD $300

The site license is for a single site/location and allows unlimited users within that site to install and use the software.

Note: The license key and download details will be sent to your email within 1-6 hours. If you do not receive please check your email spam folder. The download link and files are scanned with Norton Safe Web and Trend Micro Site Safety Center to ensure it is safe.

---