Owning your data: How smart analytics makes CFOs more valuable

By Jodi Joseph, Divisional Executive, Caseware Africa.

As a former CFO, I know that reporting and compliance are top priorities, but they can be time consuming and prone to error. Every CFO wants to be thorough and accurate, and no CFO wants the auditors to find something they haven’t. But the volumes of data to be processed are growing exponentially, and it is becoming harder for CFOs to keep their fingers on the pulse of everything happening in the business.

This challenges a growing requirement for the CFO to become a strategic partner to the CEO and a catalyst for better business. Deloitte reported last year that today’s CFOs need to add long-term value to the organisation and help shape corporate strategy.

At the same time, risk is growing and the need to control costs is a top concern. Traditional ways of doing things aren’t enough anymore. CFOs today need smarter tools to empower them to work more efficiently and strategically.

Most organisations are still working in traditional ways, assuming analytics is the domain of internal and external auditors, where it is only used a few times a year. Times have changed and this model needs to be redefined. Accountants and CFOs should be becoming data scientists, using advanced analytics to save time, underpin governance and improve business outcomes all the time.

Unfortunately, this concept has been slow to gain traction, partly because stakeholders aren’t pushing it as an expectation, and possibly because many organisations, auditors, and CFOs themselves don’t fully understand the benefits. There may also be misconceptions around the cost and resources needed to bring advanced analytics into the CFO’s domain.

Simple, smart risk mitigation

The technology allowing CFOs to leverage data analytics has advanced dramatically, becoming user-friendly and cost-effective, with an exponential return on investment (ROI). Using data analytics tools helps CFOs reduce risk so that they are more enabled to find anomalies, outliers, and fraud. This frees up time so that CFOs are empowered to transform the way they work and are better enabled to help run the business more effectively.

Accountants have always been analysts and data scientists. However, modern software is an evolution allowing them to interrogate vast volumes of data across the business – all the time. While younger accountants will enter the workplace expecting technology such as this to help them be more efficient, the older accountants and CFOs also need to change the way they work to become more valuable to the business.

The technology exists now to empower finance teams more than ever before, making them more thorough and proactive, reducing fraud and losses, and ensuring that there are no surprises at internal and external audit. In organisations where risk is high, CFOs can schedule and run tests daily, or build in real time checks to send alerts before a payment is released.

Everyone in the value chain should be using the technology to be more effective and provide better assurances. This empowers auditors too. Given the risk and size of datasets they are now auditing, they need new approaches, too. If CFOs were running analytics monthly – or even more frequently – as a standard part of processes, auditors could validate the reports annually as a test of controls. This reduces audit risk and the audit work.

Better business

At CFO level, the first time you run the datasets and observe the patterns exposed in a user-friendly way, that’s it – the results cannot be unseen after that. This dispels long held beliefs and assumptions about the business. Suddenly, the business can be better understood with all its hidden patterns, risks, and opportunities to do things in new ways.

Proper use of analytics slashes costs and improves profitability. CFOs armed with the appropriate analytics tools can detect interesting discounting practices, misallocation of payments and fraud. By building analytics into the payroll system, they can mitigate the risk of fraud and ghost employees. They can also expose waste in systems, such as not optimising ordering to maximise payment periods.

Often, we think of data analysis in financial terms, but data also allows us to examine user patterns, document terms, emails and communications. We often start in the land of numbers, but all data – financial and non-financial – could be valuable for the CFO. Non-financial data could also help to deliver a deeper understanding of the business risk, performance, profitability, and sustainability. It’s up to the imagination as to how wide this could go. For example, one might support revenue forecasts by analysing complaints and collections emails to understand how happy customers are.

Many organisations have rich data sources, but they don’t monetise and use them effectively. You can’t know what you don’t know, but CFOs who have embraced analytics have gained a world of unexpected insights into the business. Once they can view and interrogate data from across the enterprise, CFOs report that they don’t know how they ever managed without it. They become more strategic and valuable to the enterprise, identifying opportunities to reduce losses and boost revenue.

In time, those who understand their data best and act on the insights, will win.

Jodi Joseph, Divisional Executive, Caseware Africa, a division of Adapt IT.

Jodi is a Chartered Accountant (SA) with incomparable experience as a financial professional. She completed her articles at Grant Thornton – Kessel Feinstein and thereafter joined Investec in various roles including Chief Operating Officer and Chief Financial Officer. In 2013 she was appointed Chief Operating Officer of CQS Holdings – which was subsequently acquired by Adapt IT.

Caseware Africa continues to expand with Caseware IDEA®

Empowering finance professionals to turn their data into insights

Johannesburg, 1 June 2022: Following on from the 2020 launch of Caseware IDEA® – the powerful comprehensive data analysis solution – Caseware Africa, a division of Adapt IT, has announced the expansion of Caseware IDEA® to the Southern Africa market for internal audit, governance, risk, compliance and gathering insights.

The solution – designed by audit, data, and finance experts – provides for advanced analytical functionalities, a powerful data processing engine and the ability to process large volumes of data that empowers professionals to turn their data into insights and optimise their operations. “As organisations continue to enhance their business technologies and the quality of their data, any Internal Auditor, CEO, CFO, FD, and FM is now provided with the opportunity to deliver even higher value through the power of data analytics,” says Christiaan Steyn, Assurance Product Manager, Caseware Africa.

Caseware IDEA® data analytics equips professionals with the ability to transform financial audits, IT audits, operations, governance, and fraud risk management. Every day, over 500,000 global finance professionals rely on Caseware IDEA® to gather deeper insights and make more informed business decisions. “Leaders depend on Caseware IDEA® to help them manage their businesses more efficiently in a timely, cost-effective, and automated manner – whether it is to support internal audit, governance, managing risk, compliance or streamlining operations,” notes Steyn.

Caseware IDEA® empowers finance professionals with significant time savings and the ability to focus their attention to where it is needed most by helping them to:

  • Connect and use data from a diverse set of sources.
  • Process large volumes of data with ease.
  • Generate insights from both financial and non-financial datasets.
  • Analyse 100% of transactions, regardless of type, volume, or location in less time.
  • Prioritize areas with elevated risk.
  • Deliver better audit coverage and assurance.
  • Easily identify anomalies.
  • Quickly identify suspicious or fraudulent transactions.
  • Improve operations, compliance initiatives and internal audit reputation.
  • Become trusted advisors within their organisation.
“Caseware has been a market leader for over a quarter of a century, helping accountants and auditors to automate compliance. With Caseware IDEA®, finance professionals across professional practice, corporate and government are better enabled to leverage the power of their data, whether it is from their accounting platform or ERP, their HR system or any operational data source and system that is used to manage the business. Given the ever-increasing volume of data within organisations, the onus on data management and the key role that data is playing in digital transformation, it is now more important than ever for firms to implement and take advantage of a robust data analytics solution.” Steyn concludes.

Powerful Data Analytics with Caseware IDEA®

Caseware IDEA® Data Analysis is a comprehensive commanding data analytics tool that guarantees data integrity and accelerates the performance of analytics that yield faster and more effective external audits.

As an external auditor, making sense of the organisational data of your clients can be challenging, to say the least. Caseware IDEA® enables you to read, display, analyse, manipulate, sample and extract data with ease and from almost any source through a user-friendly, intuitive interface.

Auditors can quickly produce tailored reports, identify trends and outliers and detect fraud in the external audit.

According to Christiaan Steyn, Assurance Product Manager, Caseware Africa, auditing teams spend a significant amount of their time selecting samples and analysing client data for audit engagements. “It is now more important than ever for auditors to look at all of the data in the audit, rather than just a sample. This is because of the explosion of the amount of data available to auditors, together with the fact that risk-based auditing is now the expected standard for external audits, as well as the focus upon the analysis and management of risk that’s applied within the risk-based auditing approach.”

Steyn confirms that although auditors cannot be expected to identify 100 percent of all fraud in all cases, they have an obligation to find material misstatements that would change the audit opinion.

“It doesn’t matter whether it’s due to an error or fraud – if it’s a material misstatement, auditors need to identify it. With IDEA®, auditing teams can increase their data coverage, by investigating a larger number of items and potentially covering 100% of the transactions,” he explains.

What took hours, now takes minutes with IDEA®.

“IDEA® enables teams to save an enormous amount of time using a built-in risk-based sample model that allows for systematic, random and monetary unit techniques, and prioritises areas of elevated risks. Not only can teams easily sample within minutes, but also take advantage of over 100 audit functions for a robust analysis, including ageing, duplication detection and Benford’s Law,” says Steyn.

IDEA® allows audit teams to import information seamlessly and easily from almost any data source, in almost any format.

Once data is imported, IDEA® protects source data integrity by providing teams with read-only access. With built-in workflows, teams are empowered with a full suite of analytical tests for financial audits, that drive additional efficiencies and again saves an incredible amount of time.

Steyn further explains that IDEA® allows auditors to display data in different ways, and to generate analyses that would otherwise not be available. “IDEA® can also be helpful in identifying unusual or strange items, testing the validity of items by cross-checking them against other information, or validating calculations.”

Pinpoint trends and perform advanced analytics with ease with IDEA®

Additional features include the ability to pinpoint patterns, trends and outliers visually based on the outcomes of tests, to focus audit efforts. IDEA® provides for a built-in audit trail that easily enables repeatable analysis, and which can also be used as audit evidence. It further enables users to implement bespoke advanced analytics in the analysis process with Python scripting support.

Steyn acknowledges that while new auditing tools and emerging technologies hold the key to evolving the audit process, strategic risks around their adoption remain, and must be acknowledged to ensure the industry continues to develop systems that generate value for firms and their clients. The quality of data, auditor’s knowledge of databases, and experience will contribute to the success of the processes that IDEA® enables.

“Not only will the amount of Internet of Things (IoT) and real-time generated data dramatically expand, but so will the amount of data that will be created and managed by enterprises. It is estimated that by 2025, nearly 60% of the 175 zettabytes (~175 billion Terabytes) of existing data will be created and managed by enterprises versus consumers,” says Steyn.

He encourages auditors to empower their teams with analytical tools like IDEA®. “Given the volume of transactions, quantity of data and the rate at which both are growing, it is imperative for auditors to embrace analytical tools.”

He notes that in his experience, the best way for firms to build adoption is by starting small. “Identify a few audit engagements and commit the partner and the team to start and, especially to complete the audit, enabled by IDEA®.”

IDEA® Powering the audit of the future.

By building up a collection of successful audit engagements powered by analytics in IDEA®, teams build expertise, confidence, and skill. “The audit of the future will undoubtedly not be possible without data-driven analytical tools. Audit firms that drive adoption first, will be best-placed to meet the needs of the rapidly changing audit landscape,” Steyn confirms.

Key Features

Connect & Consolidate
Import information seamlessly and easily from almost any data source, in almost any format.

Source Data Protection
Protect source data integrity with read-only access to all imported datasets.

Key Insights

Deliver Key Insights
Use over 100 audit functions for a robust analysis, including ageing, duplication detection and Benford’s Law.

Risk-based-transaction-analysis
Apply a risk-based sample model using systematic, random or monetary unit techniques, and prioritise areas with elevated risks.

Built-in-Workflows
Execute a full suite of analytical tests for financial audits with the SmartAnalyzer FinApp.

Explore-&-Visualise
Pinpoint patterns, trends and outliers visually based on the outcomes of tests to focus audit efforts.

Record-Process
Follow a clear built-in audit trail that allows for repeatable analysis and audit evidence.

Advanced Analysis Using Python
Incorporate advanced analytics in the analysis process with Python scripting support.

Caseware Africa launches Caseware IDEA

Caseware Africa, a division of Adapt IT, has released details of its latest product addition, Caseware IDEA® Data Analysis – a comprehensive powerful data analytics tool that guarantees data integrity, accelerates the performance of data analytics, and enables faster, more effective external audits.

“Auditing teams spend a significant amount of time selecting samples and analysing client’s data for audit engagements”, says Christiaan Steyn, Assurance Product Manager, Caseware Africa. “It is now more important than ever for auditors to look at all of the data in the audit, rather than just a sample. This is because of the explosion of the amount of data available to auditors, together with the fact that risk-based auditing is now the expected standard for external audits, as well as the focus on the analysis and management of risk that’s applied within the risk-based auditing approach.”

Steyn says that although auditors cannot be expected to identify 100 percent of fraud in all cases, they have an obligation to find material misstatements that would change the audit opinion. “It does not matter whether it is due to an error or fraud – if it is a material misstatement, auditors need to identify it. With IDEA®, auditing teams can increase their data coverage, by investigating a large number of items and potentially covering 100% of the transactions” explains Steyn.

“IDEA® enables teams to save an enormous amount of time using built-in risk-based sample models that allow for systematic, random and monetary unit techniques, and prioritise areas of elevated risk” notes Steyn. “Not only can teams easily sample within minutes but can also take advantage of over 100 audit functions for a robust analysis, including ageing, duplication detection and Benford’s Law.”

IDEA® allows audit teams to import information seamlessly and easily from almost any data source, in almost any format. “Once data is imported, IDEA® protects source data integrity by only providing teams with read-only access” adds Steyn. “With a built-in workflow, teams are empowered with a full suite of analytical tests for financial audits, that drive additional efficiency and again saves a great deal of time” Steyn further explains that IDEA® allows auditors to display data in different ways, and to generate analyses that would otherwise not be available. “IDEA® can also be helpful in identifying unusual or strange items, testing the validity of items by cross-checking them against other information, or validating calculations.”

Additional features include the ability to visually pinpoint patterns, trends and outliers based on the outcomes of tests to focus audit efforts. “IDEA® provides a built-in audit trail that easily enables repeatable analysis which can be used as audit evidence”. Steyn notes that IDEA® also provides users with the ability to implement bespoke advanced analytics in the analysis process with Python scripting support.

Steyn confirms that while new auditing tools and emerging technologies hold the key to evolving the audit, strategic risks around their adoption remain, and must be acknowledged, to ensure the industry continues to develop systems that generate value for firms and their clients. The quality of data, auditor’s knowledge of databases, and experience will contribute to the success of the processes that IDEA® enables.
“Not only will the amount of the Internet of Things and real-time generated data dramatically expand, but so will the amount of data that will be created and managed by enterprises,” says Steyn. “It is estimated that by 2025, nearly 60% of the 175 zettabytes (~175 billion Terabytes) of existing data will be created and managed by enterprises versus consumers.”

Steyn encourages auditors to empower their teams with analytical tools like IDEA®. “Given the volume of transactions, quantity of data and the rate at which both are growing, it is imperative for auditors to embrace analytical tools”. He notes that in his experience, the best way for firms to build adoption is by starting small.  “Identify a few audit engagements and commit the partner and the team to start and, especially, to complete the audit enabled by IDEA®”.  By building up a collection of successful audit engagements powered by analytics in IDEA®, teams build expertise, confidence, and skill. “The audit of the future will undoubtedly not be possible without data-driven analytical tools”. Audit firms that drive adoption first, will be best-placed to meet the needs of the rapidly changing audit landscape,” Steyn concludes.

We use cookies to determine how our website is used and help provide tailored online content. For more information see our Cookies Policy.

Caseware + Adapt It Logo

Ask about the Caseware cloud solutions that are empowering firms and organisations to collaborate remotely with clients and colleagues.