Data Analytics for Smarter Audits – Wimgo

Data Analytics for Smarter Audits

Auditing has been around for ages, but the process has barely changed over the years. Auditors have mostly relied on manual samples, professional judgement, and old-school techniques to do their job. But in today’s data-driven world, it’s time for auditing to get a major upgrade using analytics. Trust me, this technology has the potential to completely revamp how audits are done.

Auditing: A Peek at the Past

Auditing originated way back in medieval times when people first started reviewing financial information. With the industrial revolution, business got more complex, and folks needed independent verification of financial statements. Professional audit firms were then established to conduct financial audits. Early on, auditing was about detailed testing of individual transactions – pretty tedious! 

Statistical sampling came around in the 1950s-60s so auditors could work with bigger data sets. This added some efficiency but auditing remained manual. Even with computers in the 1990s, audit practices stuck to their legacy ways. The explosion of data was hard for auditors to leverage without analytics skills and tools.

The Promise and Potential of Data Analytics in Auditing

Advancements in data analytics, including machine learning and artificial intelligence, have opened up possibilities to reimagine auditing. Data analytics refers to techniques that analyze large volumes of data to uncover patterns, anomalies and insights. 

Data analytics introduces game-changing opportunities for auditing:

– Analyze 100% of transactions: Traditional sampling could only feasibly cover a fraction of transactions. Data analytics has the potential to scrutinize entire populations of transactions and data.

– Continuous monitoring: Data analytics enables continuous auditing rather than periodic, manual reviews. Exceptions and anomalies can be flagged as they occur.

– More predictive approach: Data analytics applies predictive techniques to look forward. Risks can be identified before issues arise.

– Higher quality insights: Granular data analytics provides auditors with richer information and insights compared to high-level aggregated data.

– Elevate auditors’ judgment: Analytics augments auditors’ skills and judgment rather than replacing them. Auditors can focus their expertise on interpreting insights.

– Increase capacity: Automating tasks through data analytics expands audit capacity. Time saved on data extraction and analysis can be redeployed to higher-value work.

Challenges and Barriers to Adoption 

Despite the potential benefits, adoption of data analytics in auditing has been gradual. The latest tools and techniques have yet to fully permeate audit practice. There are some key challenges inhibiting adoption:

Legacy Approaches Entrenched in Standards and Mindsets

– Auditing standards emphasize traditional procedures like sampling and confirmations. New standards are needed to provide guidelines integrating analytics.

– Auditors and audit leaders are anchored in legacy ways of working. A cultural shift and upskilling are required across audit teams.

#Skepticism of Technology Among Auditors

– A perception that analytics may compromise auditor judgment and scepticism persists. 

– Fears that technology may “take over the audit” leads to distrust and reluctance to change.

Lack of Analytics Skills and Understanding

– Many audit teams lack personnel with analytics and data science skills to leverage the technology.

– Existing auditors require extensive training to develop analytics acumen and understand techniques.

Obtaining and Preparing Data Remains Difficult

– Actually accessing client data in formats usable for analytics is still a stubborn challenge.

– Data must be carefully structured and normalized before analysis, requiring upfront work.

Interpreting and Acting on Analytics Output 

– Tools generate complex statistical output and visualizations foreign to auditors without guidance and training.

– Auditors accustomed to definitive transaction samples struggle to interpret risk probabilities and anomalies.

– Lack of standards around setting risk thresholds open to inconsistent judgment.

Real World Examples of Data Analytics in Auditing

While barriers exist, data analytics is gaining traction in audit activities:

Continuous Transaction Monitoring

Analytics techniques can continuously monitor transactions. One major retailer implemented an internal audit analytics system that continuously analyzes and scores all their transactions against key risk indicators. The system identifies outliers and anomalies for auditors to investigate, creating continuous monitoring.

Digitalizing Audit Evidence

A large manufacturer automated the collection and archiving of audit evidence such as bank and supplier confirmations. Natural language processing extracts key data which is stored in structured databases. This enables continuous monitoring and analysis of 100% of confirmation data.

Predicting Going Concern Risk

Analytics models can analyze financial ratios, projections and other data to predict the risk a client could cease operations over the next year. Machine learning techniques can derive insights from a large training set of companies to enhance predictive accuracy.

Improving Inventory Audits

Statistical analysis of past inventory counts and performance data is used to optimize audit sampling. Non-sampling variables like location, personnel and product-type are factored in to focus samples on higher risk areas and enhance detection.

Monitoring Procurement Contracts

Text mining tools ingest procurement contracts to extract key terms and conditions. The extracted contract data is structured and analyzed to detect unusual or missing clauses for further audit scrutiny.

Critical Capabilities to Adopt Audit Analytics

Capitalizing on the potential of data analytics in auditing requires deliberate initiatives to build critical capabilities:

Updated Standards and Guidelines 

– New auditing standards need to provide direction on integrating analytics into audit testing and evidence. Analytics adoption is constrained without standards to follow.

– Firms should disseminate detailed guidelines and methodologies for practitioners to apply audit analytics in their work.

Develop Data Architectures and Pipelines

– The ability to efficiently access quality data is the foundation of effective analytics. Audit teams should work with clients to develop architectures and data pipelines.

– Data lakes can consolidate data from disparate systems. Setting standards for data formats, master data and metadata accelerates analytics.

Build Analytics Tools and Dashboards

– Analytics and visualization platforms enable auditors to apply techniques like regression analysis, anomaly detection and natural language processing.

– User-friendly dashboards visualize trends, outliers and risk scores to translate analytics into actionable insights for auditors.

Upskill Teams on Analytics

– Extensive training on analytics techniques, tools and statistical concepts is essential to build competencies across audit teams.

– Data scientists and analytics professionals should be recruited into audit practices to provide expert guidance.

– Focus cultural shift on embracing analytics to elevate auditors’ judgment, not replace it.

Develop Analytics-Based Audit Programs

– Audit programs detailing risk assessment procedures, sampling methods and documentation standards should integrate analytics techniques.

– Programs should link risk factors, audit tests, and thresholds to data analytics models and output.

Enhance Audit Committee Dialogue 

– Discuss how analytics enhances risk assessment and share examples of insights uncovered. Align on comfort level using data analytics for evidence.

– Explore opportunities for real-time monitoring and assurance over financial data through audit committees’ access to systems.

The Future of Audit Analytics

Data analytics represent the most significant opportunity for advancing auditing since the advent of statistical sampling. Modern data capabilities can Spark a revolution in how audits are performed and transform the role of auditors.

Audit practices that take deliberate steps to build analytics capabilities will gain a competitive advantage in delivering higher quality audits. They will also be able to provide more forward-looking assurance as client needs evolve.

But auditor judgment will remain central even in a highly automated world. The unique value of auditors is interpreting the implications of data and guiding appropriate actions, not rote data processing. The future vision is an analytics-empowered audit practice with data-savvy auditors providing unrivaled insights to businesses.