Track C: Audit & Data Analytics
What you will be able to do
- Prove audit data is complete before testing
- Pick random, interval, stratified and money-based samples
- Run duplicate, gap, weekend, round-amount and Benford tests
- Test journals, ageing and three-way matches
- Write an exception report with clear findings
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Getting audit data ready
- Completeness: record counts and control totals
- Profiling a ledger export
- Cleaning an audit extract with Power QueryReal Excel
Module 2: Sampling
- Random sample with SORTBY
- Systematic (interval) sample
- Stratified sample with value bands
- Monetary unit sampling basics
Module 3: Data tests
- Duplicate payments
- Gaps in invoice or cheque numbers
- Weekend and holiday postings
- Round amounts and amounts just below a limit
- Benford's law first-digit test
- Journal entry testing
Module 4: Balances and reporting
- Receivables ageing and overdue balances
- Three-way match: order, goods received, invoice
- Exception report and summary of findings
Capstone: audit analytics on a purchase ledger
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free