Audit data analytics (ADAs) is a great place to start. Using tools you already have – Excel, for example – you can analyze entire populations, find anomalies and identify patterns. To help you on your way, we’ve outlined five basic steps for planning, performing and evaluating the results of an ADA used to perform an audit procedure.
- Plan the ADA.
The first step is to develop a solid plan. Figure out what information you’ll be reviewing and what you want to get out of it. Are you performing a risk assessment procedure, substantive analytical procedure, or test of details? Or are you seeking to form an overall conclusion from the audit? Once you know your objective, then think about the population of data you have available. Give preliminary consideration to how available, relevant and reliable it is (you’ll consider this in more detail in step 3). Finally, identify which specific ADA procedures, techniques and tools you’ll use.