Use of IT to assist the auditor - part 2

In this lesson

1. 0:00 Data analytics in audit practice
2. 0:36 Visualising transaction data with dashboards
3. 1:16 Identifying revenue anomalies through comparison
4. 2:04 Using analytics to detect unusual patterns

About this lesson

Using a practical example of a luxury ice cream manufacturer, you'll see how visualising transaction data—such as revenue by month—can reveal anomalies that suggest potential misstatements or control failures. This technique is essential for Advanced Audit and Assurance, helping you perform more effective substantive testing and demonstrate professional scepticism during the audit process. Data analytics transforms raw financial data into clear visual dashboards that make trends and irregularities immediately apparent. In the example shown, comparing current year sales to prior year patterns reveals an unexpected revenue spike in October and November—months when sales historically decline sharply. Without this visualisation, you might miss the anomaly entirely. This approach not only strengthens your audit work but also provides valuable insights to your clients, helping them identify potential errors or unusual transactions in their own records. By mastering the use of IT tools like data analytics software, you'll conduct more efficient and thorough audits, reduce sampling risk, and build confidence in your audit conclusions. This is a core skill for the AAA exam and increasingly expected in modern audit practice.

Duration: 3m