Random Sample Generator

Both versions of our random number generator will allow entry of the following information :

Client name
Preparers name
Description of sample
Date of selections
Fiscal Year for selections
Select up to 999,999 samples and up to 999,999 additional samples from a range of 1 to 999,999,999,999
An additional random sample percent or an actual number of additional samples can be entered for generating additional random numbers for substitution of invalid transactions, such as voided checks. The additional percent can equal up to 100% of the original number of selections.
Import an unlimited number of ranges from a csv data file
Import population with up to five columns from a csv data file
Enter the population as journal pages and items per page
Enter multiple checking account ranges with overlapping check numbers by using the account prefix feature
Print from 0 to 10 columns for the attribute testing work paper

OUR ADVANCED VERSION INCLUDES THE FOLLOWING ADDITIONAL FEATURES

Calculate a suggested sample size for statistical sampling using the following :

Sample precision - 1% thru 10%

Confidence levels - 99.9%, 99.8%, 99.5%, 99%, 98%, 97.5%, 97%, 96%, 95%, 94%, 93%, 92.5%, 92%, 91%, 90%, 87.5%, 85%, 82.5%, 80%, & 75%

Maximum Tolerable Error Rate - 1% thru 10%

Once the random numbers used for the sample selection are generated, the following options are available in both versions :

Print a criteria selection report which lists the sample size, all ranges in the population, the additional sample percent, the random numbers generated, and the additional sample selections that were generated. This printout is shown in the order each number was selected. See the selection criteria printout below.

Print an audit sample selection testing workpaper listing the random numbers generated in a grid with columns for marking various tests performed on the sample population. This workpaper can be printed in selection order, sorted in ascending order, or sorted in descending order. See the selection testing workpaper below.

Export the random numbers and the additional samples generated to a csv data file to be used in external programs such as Excel® or Lotus®

Our random number generator software has been in use by C.P.A.’s for over 15 years.

	Our random sample generator software has been designed by C.P.A.’s to simplify random number selections for audit sampling purposes. Our software was created to provide an extremely easy method of obtaining random numbers to be used for audit random sample selections from multiple ranges of numbers. Our multiple range entry makes our random number software stand out from all other random number generators. The population can be entered manually or imported from a csv data file. Multiple checking accounts with overlapping check numbers can be easily entered. We also feature selecting line numbers from pages of journals where the page number and entries per page are used as the population. The generated samples can be exported for use in other programs. Our advanced version includes calculating a suggested sample size using sample precision, confidence level, maximum expected error rate, and tolerable error rate. Try a demo of our software and see its ease of use and versatility.

Sample printouts in Adobe® pdf file format : Selection Criteria Printout Selection Testing Workpaper	Other information : End User License Agreement Random Sample Generator Price List
[Fixed Asset Depreciation] [Loan Amortization] [Loan Tracker] [MaterialityCalculator]