GUEST BLOG POST
With the rise of artificial intelligence and ChatGPT, sometimes I think that we internal auditors will all soon be out of a job. But then I have a very boring task to do, and I wonder why I can’t just ask a machine to do it!
Just recently, for example, we had the task of comparing a 900-page PDF document to an Excel document that was in a slightly different format. Now, if I was going to do that page-by-page manually, it would take a very long time. But, for an intelligent machine, it should be easy, right?
Unfortunately, machine learning is not quite accessible for me to just ask my computer to do it… so I found an intern! (Luckily the intern did find some online tools, but the process was still semi-manual, and then required reviewing.)
So, what types of tasks are we currently getting machines to do and what types of tasks should we soon be able to get machines to do? And how will we get machines to do them? These are important questions, and the internal audit functions that find good answers to them will be ahead of the game.
We recently moved our kids from one high-tech school to a much cheaper school that could not afford any computers. The reason? Because the high-tech school is convinced that our kids need to use PowerPoint and Excel from Grade 3 in every lesson. But PowerPoint and Excel are surely soon a thing of the past, right?
And so is programming! Or data analytics… and internal auditing? The question is real: Could artificial intelligent machines one day take over all the work that internal auditors currently do?
Rise of the Auditor Bots
When you get the latest version of any good data visualization software, such as QLIK, you will be able to use a “bot.” Using the “bot” you can type a question: “what were my sales in 2022”? And before your eyes a chart showing the sales of 2022 will appear. This is really what we mean by machine learning. It is getting the machine to understand the human-formed requirement, and doing the obvious work that any decent data analyst would know how to do. The machine interprets the sentence and does the work to get the result.
See related article: “Using Artificial Intelligence in Internal Audit: The Future is Now“
We can then say to QLIK bot: “what about the margin?” In this question, the bot will be “in context,” meaning that it knows the context of the conversation. It knows that we are talking about 2022 and it will give you the margins for 2022. The machine seems to have “common-sense” and short-term memory.
And we can go further. Indeed, many companies are building ChatGPT-like systems that are trained only on their internal universe and can provide natural language responses to just about any question or query a person using it can think of asking. It’s easy to imagine the benefit that access to such a system could have for internal audit, especially during an audit. The question arises, though: can we imagine such a system conducting the entire audit, relegating the human auditors irrelevant?
So, these things are coming. And it is true that if you have an army of data analytics people in your office, you may not need so many of them in the future. Instead of asking your data analytics team to produce a dashboard on sales margin per product, you will be able to write the sentence, “Sales margin per product,” and the system will present you automatically with a set of options of dashboards for sales margin per product.
You might be thinking – but how does QLIK or another AI system know where to get the data? Well, probably someone at some point is going to create standardized data models for each major ERP (Enterprise Resource Planning: aka accounting tool) system, so that it can become an off-the-shelf SAP robot for QLIK.
You might also be thinking – but how does QLIK know what to do if some of the data is from the ERP and some of the data is from elsewhere? So yes, probably you will still need someone to understand what data is in Excel and elsewhere, and correctly give that data to your robot, so that the robot can identify what the data is, what it is used for. QLIK will know all of these things because the data will be set-up in a Data Lake, by your IT department and it will be categorized and organized correctly so that the robot can easily ask questions of it.
So, if you are in data analytics for audit, you may be wondering what the future holds for your particular skill-set right now.
The Internal Auditor of the Future
Well, IT people like to say that everything works fine before it doesn’t, so while the era of when we can truly speak to our computers is here, it’s still in the earliest stages. We may have a few years before this technology becomes advanced, but probably only a few.
In the relatively near future it means that the internal auditor will need to focus on those more functional skills of actually interpreting the information received.
For example, if you receive a dashboard from your system with the margin per customer, then you might want to just copy-paste it to your audit report, to show that all is good because the margins are all positive.
If you are a good internal auditor, however, you might think, that all looks fine, but are there any products that have negative margins? Maybe, if you ask the questions like that, the machine will always come up with the answer “no.” What if you asked the question “are there any customers that have a negative margin for a particular product?” Then the machine might say “yes, customer ‘Mercedes, Germany is getting product ‘leather upholstery’ on a negative margin basis for the last three years in a row.’”
The machine has given a very interesting answer. Now, the internal auditor could think, “great I can put that in my report.” But if you are a good auditor, you might then think: “OK, but why?” Then you could start asking other questions, such as:
- Does the price for leather upholstery get changed often?
- Are there sales orders for Mercedes and leather upholstery that do not match the price per material in the material database?
- Does the material database have a special material number for upholstery products that is only used for Mercedes?
- Who is entering the sales orders for Mercedes?
- Who is approving the sales orders for Mercedes?
- Are there any cases of sales orders for Mercedes that are entered and approved by the same person?
- Was there a margin control for Mercedes upholstery sales orders?
- How much did we provide in discounts to Mercedes?
- Did we do any marketing events for Mercedes, and if yes, did we calculate the ROI?
- What is our margin for Mercedes in other regions?
- Is that Mercedes office that we are selling to really a real Mercedes office? (Is the tax number valid? is the address valid? do we find them listed in Google at that address?)
- Is the main contact for that Mercedes office any-way linked to someone in our company? (Facebook friends to an employee, LinkedIn shows that they actually work for us rather than Mercedes, same telephone number as an employee, etc.)
A good internal auditor will think about all of the situations and all of the different contexts that could help to explain the anomaly of negative margin for leather upholstery sold to Mercedes. They will use their knowledge and experience of the company, internal control weaknesses, internal audit standards, and non-corporate information sources to think about why the anomaly may have occurred, and then to test those hypotheses until the proof is found. Here, the AI can help answer the questions, but human intuition is still driving the investigation.
This will enable a good internal auditor to go into their audit meeting and present the full story as to what is going on in the company, painting a detailed picture of the fraud scenario, or showing that there is some error in the CRM-SAP interface causing the figures to be wrong.
And yes, maybe in the more distant future, even the machine might be able to think out of the box and answer all of those questions that the auditor would think of asking. For the moment, however, data analytics and data visualization software companies and AI developers are still racing to perfect the “bot,” so that auditors can simply ask the question, “what are the sales margins for 2022,” rather than spending days creating data analytics programs to get the answer.
Looking Forward
From my experience, I would expect that by 2025, most data visualization software will be at the stage where the bot can easily answer basic questions, such as, “What are the sales margins for 2022?” However, the answers to those questions will probably still be disputable because their accuracy will depend on the accuracy of the underlying data lake. Did the IT department match the correct information to the correct category? Did the IT department really understand the non-SAP data sources and how to link them together? As good as machine learning and AI systems have become, the old adage holds: garbage in; garbage out.
Today, we have a lot of errors concerning interfaces between systems. It always amazes me, the number of people employed to re-compute this or that to check if totals from different systems match. Such will probably be the same in 2025, to check if the robot got it right.
And then comes a new task for the auditor, which will be to ensure that there are controls in place to check that the data robot is doing its job properly!
Of course, nobody can truly predict the future and exactly where AI is heading, but it’s hard to imagine it replacing internal audit anytime soon. So, the life of the internal auditor, even the IT auditor, although it will evolve, it is still here to stay for another several years yet. At the same time, the internal auditor will get more intelligent and be expected to ask more questions. So hopefully, the machine and the internal auditor will grow more intelligent together.
Claire Worledge spent the first 10 years of here career at Deloitte, where she managed the Data Quality and Integrity team. She then set-up Aufinia in 2010 and has been helping internal audit teams of large organizations use data analytics. Claire is also the author of the book Data Analytics Secrets and hosts the Tuesday Data Leaders in Internal Audit Webclass.
You can sign-up for the next Webcall, about finding fraud in suspense accounts, here: https://shop.aufinia.com/checkouts/webclass-111-registration-finding-fraud-in-suspense-accounts/
This article had great details. As a retired CIA, CISA, and CFE, I have monitored many constant YouTube videos on AI, and it is clear the people who ignore AI will be out of work, and those who learn AI prompts to get accurate results will be able to get a job anywhere. Companies right now are paying more than $200k to $500k for AI “prompt engineers”.While the writers and actors strike, movie studios are hiring AI experts to create text-to-video movies without hiring extras or writers. The same pattern will erupt for AI skills as it did when some auditors ignored spreadsheets and others didn’t. So internal auditors should start by learning complex, useful AI prompts.