Search
Close this search box.

Insights

Utilizing Data Analytics to Enhance Internal Audits Value

Meredith F. Piotti

ABOUT THE AUTHOR

Meredith F. Piotti

Principal

Read Bio

AREAS OF EXPERTISE

Financial Services
Healthcare
Manufacturing
Distribution & Retail
Technology

Share

LinkedIn
Facebook
Threads
X
Reddit
Email

Data analytics can provide valuable insights for companies in many industries when used as part of the internal audit process. While utilizing data analytics to optimize audit operations isn’t a new concept, the ever-evolving landscape of technology and rapidly changing markets has caused the benefits of utilization to grow exponentially. Among many other improvements, data analytics can offer:

  • Process automation
  • Robust client management and report systems
  • Ability to access and disburse data

Data analytics can be effectively integrated into all phases of the audit process, from providing statistical information in determining high-risk areas of focus, to performing entire population testing instead of sampling.

Across industries, there are many areas in internal audit where data analytics can be easily implemented and exceptionally useful.

For investment advisors, areas include:

  • Transaction monitoring for compliance with set approval limits, including trade processing, disbursement requests, or investment portfolio thresholds
  • Duplicate trades, disbursements, or check numbers
  • Comparison of internal investment holding records to custodians

For financial institutions, areas include:

  • Transaction monitoring for compliance with set approval limits, including lending authority, payment processing, or investment purchases
  • Duplicate purchase orders, invoice numbers, or check numbers
  • Review of file maintenance for appropriate segregation of duties

For manufacturing, distribution, and retail companies, areas include:

  • Transaction monitoring for compliance with set approval limits, including supply requisitions, payment processing, or overtime monitoring
  • Agreement of purchase order amounts to invoices for inventory received
  • Process monitoring for compliance with set time frames
  • Agreement of invoices to cash receipts

Creating or Enhancing Your Data Analytics Audit Program

Here are some steps you can take to establish or enhance your data analysis plan:

  1. Identify personnel with data analytics skills. If necessary skill sets need enhancement, conduct trainings or find outside resources to assist in the program development. The number of individuals required to be trained will vary based on how you plan to use data analytics.
  2. Review your existing audit program and identify current manual tests that can be automated.  Update the audit programs to provide clear guidance on new techniques.
  3. Ensure internal audit personnel have necessary access to data and an understanding of the data format required to utilize the data analysis tool.
  4. Establish validation methods for ensuring completeness of information provided.
  5. Review results of data analytic procedures and update your approach to reflect resolution of false positives.
  6. Convert established data analytic steps into automated tests through the use of scripts or other methods.
  7. Review automated tests and determine if similar techniques can be used in other areas.
  8. Create scripts to automatically perform the audit procedures for routine tests.
  9. Develop a schedule for automated tests and communicate results to management regularly.
  10. Periodically review automated scripts for required updates and effectiveness.

Conclusion

Accurate analysis of data can be burdensome, often taking up valuable time and resources to sift through information to adequately audit internal processes. However, a streamlined approach can be created using the latest in data analytics—allowing investment advisors, financial institutions, and manufacturing, distribution, and retail companies to capitalize on fast access to critical data and organized systems of information.

CONTACT
Meredith F. Piotti

Meredith F. Piotti

Merry is a Principal in Wolf’s Advisory Group and serves on the Firm’s Internal Audit Team, where she provides internal…

Read Bio

"*" indicates required fields

Get the insights that matter.

Stay informed with priority news and key industry updates by filling out the form to subscribe.
Name*
This field is hidden when viewing the form
This field is for validation purposes and should be left unchanged.

Connect with a Wolf Expert

"*" indicates required fields

Wolf Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

Newsletter (Insight & Case Study | Wolf Website

"*" indicates required fields

Get the insights that matter.

Stay informed with priority news and key industry updates by filling out the form to subscribe.
Name*
This field is hidden when viewing the form
This field is for validation purposes and should be left unchanged.

Data Solutions | LinkedIn Ads Form

"*" indicates required fields

Data Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

Get back to business with accounting support from Wolf & Company.

"*" indicates required fields

Outsourced Accounting Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

Data Solutions | Page

Get back to business with accounting support from Wolf & Company.

"*" indicates required fields

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

"*" indicates required fields

Data Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

Connect with a Wolf Expert

"*" indicates required fields

Wolf Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

Fintech Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name(Required)

Fintech Inquiry Form

Fill out the form below and our team will reach out to you soon.

Get back to business with accounting support from Wolf & Company.

"*" indicates required fields

Outsourced Accounting Solutions Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

"*" indicates required fields

DenSecure Inquiry Form

Fill out the form below and our team will reach out to you soon.
Name*
This field is for validation purposes and should be left unchanged.

We’re here to help.

"*" indicates required fields

Fill out the form below and our team will reach out to you soon.
Name*
This field is hidden when viewing the form
This field is for validation purposes and should be left unchanged.