Audit transformation through data analytics
Increased audit efficiency by 20% and inventory-testing performance by 30% by directing audit work towards material entries and control exceptions.
-
The problem
Manual, time-intensive procedures made material entries and workpaper errors difficult to surface early.
-
My role
Analysed journal data to concentrate procedures on material entries and exceptions.
-
Where it stands
Audit efficiency increased by 20% through optimised PCAOB documentation; inventory testing performance improved by 30% for an aerospace engineering client.
Results and evidence
Source notes
Increased audit efficiency by 20%.
Applied journal analytics and optimised PCAOB documentation.
Business impact
Improved audit speed and reliability by surfacing material entries earlier.
How I did it
- 01
Improved PCAOB documentation and used Excel controls to identify workpaper errors.
Tools and working context
PwC UK Audit Transformation team; PCAOB and JSOX clients across Europe and the US.
- Tools
- Excel · Audit analytics
- Business area
- Audit
- Skill type
- Finance · Data & Reporting
Why I made these choices
- Used exception-led journal analysis to focus effort where financial risk sat.
Skills used
- Training & enablement Ways of Working Strong
What I learned
- Audit analytics creates value when it redirects attention to risk rather than only automating existing steps.
What comes next
- Apply the exception-led method to current finance controls and automation.