Obtaining Assurance Over the Data You Receive From Clients for Data Analysis

When performing data analytics it is important that you have effective processes in place around the conversion and import of your source data into the application you are using. If your data lacks integrity at the start, then the results and outcomes from your analyses will include those errors. Some simple tips for auditors requesting datasets from clients:

  1. Request record counts
  2. Request control totals
  3. Request field definitions and record structure

I have previously used a data extract confirmation sheet.  See this attached version.  Data analytics confirmation sheet