Audit Data Analytics Corp
(864)625-2524
contact@auditdataanalytics.net
Menu
  • Home
  • Professional Services
    • Custom Excel Solutions
    • Help Desk Support
  • Forum
  • Blog
  • Research
  • About Us
  • Privacy
  • Download
    • Windows
    • Mac
  • Shop
    • Cart
    • Checkout
    • My Account
  • ADA Help
Menu

Sampling Tool

Our Sampling Tool is for auditors who do heavy lifting when it comes to audit sampling. The Sampling Tool lets you sample in Excel, adjust your samples in Excel and keep all your documentation – including the random seed number – in Excel. The Sampling Tool can be set up to automatically have your samples ready for you after the push of a button. All you have to do is check them out and make sure they’re right.

If you need to stratify your population data not by amount but by GL accounts, business areas, groups of accounts, different risk buckets, etc., then the Sampling Tool is for you. Have as many of these things as you want. Each stratum will go in a different Excel worksheet. Get a standard, perfect format/look-and-feel in Excel every time.

Exercise your auditor judgment and tailor the random sample to fit your needs. Our Sampling Tool is a macro-enabled workbook where we automatically install the Excel VBA macro needed to perform all the functions. You simply push the buttons.

For each worksheet/stratum:

  • You can edit the population data – remove pesky reversals/offsets or duplicate items
  • The Removed Data section provides a documented area where unused population data can be stored
  • A pivot table holds the random sample data and can automatically be updated with the push of a button
  • You can change the sample size and large dollar threshold cutoff and then automatically update the random sample with the push of a button
  • Summary statistics automatically update so you know exactly how much you have sampled
Sampling Tool
Sampling Tool

You can also password protect all the worksheets in your Sampling Tool workbook with the push of a button. This way you can share the workbook with your clients and colleagues. They can read and see all the content, but they can’t make changes. Get the data back exactly the way you had it. Note that this is different than password protecting a workbook where the password protection prevents someone from opening the workbook at all.

Sampling Tool Inputs and Errors
Sampling Tool Inputs and Errors

Examples

Check out some examples of our work that employ the Sampling Tool:

  • FAR 31 Audit Sampling

 

Share with:

Facebook Twitter Google StumbleUpon LinkedIn Reddit Email Print


Contact

To discuss your needs and how we can help you best, please contact:

Donna Ellis, Director of Professional Services

(864) 625-2171

donna@auditdataanalytics.net

Professional Services

  • Professional Services Home
    • Custom Excel Solutions
      • FAR 31 Audit Sampling for A/E/C Companies
      • Automated Analysis Toolboxes
      • Business Intelligence Reporting
      • Versatile Excel Importer
      • Sampling Tool
      • Report Builder
      • Automated Audit Analyzer
      • Excel Graphics and Power BI Packages
    • Help Desk Support
©2021 Audit Data Analytics Corp | Design: Newspaperly WordPress Theme