Legal and professional services · Playbook 37

Audit anomaly review

Every journal in the ledger extracted, proven complete and scored, with unusual entries grouped and explained for the audit team. The team chooses what to test, investigates and concludes, and the engagement partner signs.

  • Predictive ML
  • Agents with tools
  • Human in the loop
  • FRC ISAs (UK)
  • FRC AI in audit guidance
  • ISQM (UK) 1
  • FRC Ethical Standard
  • ICAEW Code of Ethics
  • UK GDPR

At a glance

The problem
Journal tests produce thousands of hits, the team samples a handful, and proving the ledger extract was complete takes weeks
Typical volume
Around 300 audits a year, with ledgers from 50,000 to 20 million journal lines
Who's involved
Audit quality and methodology, audit technology, engagement teams and partners, ethics and independence, IT security, data protection
Pilot
10–12 weeks on prior-year audits and a few live ones, after a 3–4 week discovery
Platforms
AWS, Azure, or a sovereign or on-prem stack

An illustrative scenario. The numbers are typical examples, not a client case study. The cloud services and UK rules were checked on 9 November 2026.

The business problem

Every audit has to respond to the risk that management overrides controls, and the auditing standards require the team to test the appropriateness of journal entries and other adjustments. Most firms do this with a set of standard filters: entries posted at weekends or after the period closed, round sums, unusual users, rarely used accounts, and certain words in the description. On a large client those filters return thousands of hits. The team picks a sample, works through it, and has to explain on the file why those entries, and not the others, were the right ones to test.

Getting the data is often the slowest part. Each client runs a different ERP, version and chart of accounts, with its own custom fields. Client IT sends exports in whatever shape is easiest, sometimes late, sometimes cut off at a row limit nobody noticed. Before any test means anything, the team has to show the extract is complete and accurate: that it reconciles to the trial balance and that opening balances plus the journals give the closing balances. That reconciliation is frequently done by hand, under deadline, and is where many problems with journal work start.

Firms want to look at the whole population, not just filter hits, and to see entries that are unusual for this client even when they pass every standard rule. Machine learning can do that well. But the FRC expects any tool used on an audit to be certified by the firm, documented centrally and on the audit file, and understood by the people relying on it, and the human auditor stays accountable. The tool has to make the team's judgement sharper, not replace it.

What AI changes

  • Every journal line in the period is extracted with standard, versioned scripts, and reconciled to the trial balance and the balance roll-forward before any test runs. A failed reconciliation stops the analysis and goes back to the team.
  • The firm's standard journal tests still run as plain rules, exactly as the methodology defines them. The machine learning adds to them; it never replaces them.
  • Every entry is scored for how unusual it is for this client, compared with its own history and patterns: who posted it, when, to which account pairs, with what amount and description.
  • Similar unusual entries are grouped into clusters, so the team reviews 40 explained groups instead of 3,000 separate hits, and each flag shows the specific features that made it stand out.
  • An assistant gathers the supporting data for the entries the team chooses and drafts the working paper narrative. The team investigates, edits and concludes, and the reviewer and engagement partner sign off.
  • The audit file gets a standard record of the tool: what it does, which version ran, on which data, with which settings, and what the team did with the results.

How success is measured

Agree these, and measure the baseline, before anything is built. Example targets are typical, not promises.

Time from data received to ready to test

How long it takes to load, reconcile and validate the client's ledger extract.

ExampleFrom about 3 weeks to 3 days

Extracts proven complete

Extracts reconciled to the trial balance and the balance roll-forward, with every difference explained, before any test runs.

ExampleEvery engagement

Population coverage

The share of journal lines scored and tested by the firm's rules, rather than reached only through a sample.

ExampleEvery line

Items for the team to review

The number of groups and entries the team actually looks at, compared with today's raw filter hits, while still covering every rule the methodology requires.

ExampleDozens of explained groups, not thousands of hits

Dismissal rate

How often the team investigates a flag and finds nothing. Very high means the model needs tuning; near zero can mean people have stopped investigating.

ExampleStable, reviewed by the central team

Review findings on journal work

Issues raised by the firm's own quality reviews and by external inspection about journal testing.

ExampleFewer, measured against the last cycle

UK regulation and controls

Cross-sector rules are on the UK regulation map.

  • FRCISA (UK) 240: the auditor's responsibilities relating to fraud

    The team must respond to the risk of management override, including by testing journal entries. The tool helps the team see the whole population and choose what to test; the team still designs the procedures, sets the criteria with the methodology, and evaluates the results. ISA (UK) 240 (Revised March 2026) applies to audits of periods beginning on or after 15 December 2026.

  • FRCISA (UK) 315 (Revised July 2020) and ISA (UK) 330: risk assessment and responses

    The team must understand the client's IT environment, including how journals are posted and approved. Patterns the tool finds, such as an unusual posting user or an account pair never seen before, are inputs to the team's risk assessment, not the risk assessment itself.

  • FRCISA (UK) 500 audit evidence and ISA (UK) 230 documentation

    The ledger is information produced by the client, so the team must evaluate whether it is complete and accurate enough to rely on. Every extract is reconciled before use, and the file records what was run, on which data, with which version and settings, and what the team concluded, so an experienced auditor with no connection to the audit could follow it.

  • FRCISQM (UK) 1, AI in audit guidance (26 June 2025), and Generative and Agentic AI Guidance (30 March 2026)

    The firm certifies the tool centrally before engagement teams use it, under its system of quality management. The June 2025 guidance, whose illustrative example is an AI tool used over journals, sets out proportionate documentation centrally and on the audit file. The March 2026 guidance covers generative and agentic tools such as the drafting assistant. Neither creates new requirements, and the human auditor stays accountable.

  • FRC and ICAEWFRC Ethical Standard (Revised 2024) and the ICAEW Code of Ethics

    The analysis is audit work. Findings go to the client through the normal reporting channels, and the tool is never turned into a monitoring service the client relies on, or used to make management decisions, which would threaten independence. Each client's data stays confidential to its engagement: models learn from that client's own history, and one client's ledger is never used to produce another client's results.

  • ICOUK GDPR and the Data Protection Act 2018

    Ledgers contain personal data: employee names and user IDs, payroll and expense journals, and individuals paid as suppliers. That means a DPIA, minimising fields such as payroll narratives, processing in UK regions, a retention period aligned with the firm's audit file retention, and a contract that stops providers training their models on client data.

  • Home OfficeFailure to prevent fraud (Economic Crime and Corporate Transparency Act 2023), in force since 1 September 2025

    Large organisations can now be criminally liable when an employee or associate commits a listed fraud offence, such as false accounting, intended to benefit them, unless they had reasonable prevention procedures. Clients' boards are paying more attention to journal controls. The auditor's analysis is not part of the client's prevention procedures and should never be described as if it were.

The solution

Showing AWSAzuresovereign / on-prem services. Switch with the toggle; every diagram and table on this page follows it.

Audit anomaly review: reference architecture
  1. 01Channels

    • Client ERP and ledger systems
    • Client IT: extract scripts or exports
    • Client trial balance
  2. 02Intake

    • AWS Transfer Family, Amazon S3Blob Storage with SFTPAn SFTP server, plus Ceph or IONOS S3 Object StorageSecure client upload
    • AWS GlueMicrosoft Fabric (Data Factory)Apache Spark on KubernetesCompleteness checks (rules, not AI)
    • Amazon S3, with a key per engagementOneLake in Microsoft FabricCeph, or IONOS S3 Object StorageEngagement data store, one per client
  3. 03Intelligence

    • AWS Glue, Amazon AthenaMicrosoft FabricApache Spark, or PostgreSQLStandard journal tests (rules)
    • SageMaker AIAzure Machine LearningMLflow and Kubeflow on KubernetesAnomaly scoring and clustering
    • Agent
      Bedrock AgentCoreFoundry Agent ServiceLangGraph on Kubernetes, with open-weight models via vLLMReview assistant
  4. 04Orchestration

    • Step FunctionsLogic Apps / Durable FunctionsTemporalEngagement workflow
    • EventBridge + SQSEvent Grid + Service BusApache Kafka or RabbitMQEvents and queues
  5. 05Systems of record

    • Audit software and audit file
    • Methodology and certified tool register
    • Independence and engagement acceptance
  6. 06People

    • Person
      Audit team: investigates and documents
    • Person
      Engagement partner: judgement and sign-off
    • Person
      Central audit technology and quality team
  • Cloud or platform service (AWSAzuresovereign / on-prem)
  • AI agent
  • A person decides
  • Your existing systems
  • Outside your organisation

Components, side by side

Audit anomaly review: components on AWS, Azure and a sovereign or on-prem stack
LayerAWSAzureSovereign / on-prem
Secure intake from clientsClients upload to a location for their engagement only. Nothing is pulled with standing access to a client's live system.AWS Transfer Family (SFTP), Amazon S3Azure Blob Storage with SFTP enabledAn SFTP server on your own platform, plus Ceph or IONOS S3 Object Storage
Extraction from client ERPsEvery extract comes with a manifest: period, row counts, hash totals and the script version. Never ask for write access.Standard, versioned extract scripts for each ERP family, run by the client or under read-only accessStandard, versioned extract scripts for each ERP family, run by the client or under read-only accessStandard, versioned extract scripts for each ERP family, run by the client or under read-only access
Completeness and integrity checksPlain, tested rules owned by methodology: reconcile to the trial balance, roll balances forward, check for gaps in document numbers, duplicate lines and periods. No model decides whether data is complete.AWS Glue (including Glue Data Quality), Amazon AthenaMicrosoft Fabric (Data Factory and notebooks)Apache Spark on Kubernetes, or PostgreSQL
Standard journal testsThe firm's methodology criteria, run in full on every engagement, exactly as today.AWS Glue, Amazon AthenaMicrosoft FabricApache Spark, or PostgreSQL
Anomaly scoring and clusteringManaged anomaly services have closed: Amazon Lookout for Metrics in October 2025 and Azure AI Anomaly Detector on 1 October 2026. Build and version your own models so they can be documented and certified.Amazon SageMaker AI, with open-source libraries (e.g. scikit-learn isolation forests, PyOD)Azure Machine Learning, with the same open-source librariesMLflow and Kubeflow on Kubernetes, with the same open-source libraries
Reasons for each flagEach flag shows which features made it unusual, in words an auditor can test against.SageMaker AI, with open-source SHAPAzure Machine Learning, with open-source SHAPMLflow and Kubeflow on Kubernetes, with open-source SHAP
Drafting working papersThe model only writes up data and results the tests produced. Every figure links back to the entry it came from.Amazon BedrockMicrosoft FoundryOpen-weight models served with vLLM on your own GPUs, or IONOS AI Model Hub
Agent runtimeThe original Bedrock Agents closed to new customers on 30 July 2026; new builds use AgentCore.Amazon Bedrock AgentCoreFoundry Agent ServiceAn open-source agent framework (e.g. LangGraph) on Kubernetes
WorkflowAWS Step FunctionsLogic Apps or Durable FunctionsTemporal, or n8n
Link to the audit softwareResults and drafts land in the audit file, where the team already works and reviews.Through the audit software's import or API, plus your existing integration platform if you have oneThrough the audit software's import or API, plus your existing integration platform if you have oneThrough the audit software's import or API, plus your existing integration platform if you have one
Human reviewInvestigation, conclusions and review sign-offs are recorded on the file, not in a separate tool.In the audit team's existing audit softwareIn the audit team's existing audit softwareIn the audit team's existing audit software
GuardrailsStops drafts from stating conclusions the team hasn't recorded.Bedrock GuardrailsFoundry guardrails (Azure AI Content Safety)Open-source guardrails (e.g. NeMo Guardrails, Llama Guard)
Identity, keys, data protectionAccess follows the engagement team list. A separate key for each engagement, destroyed in line with the retention policy.IAM Identity Center, KMS, MacieEntra ID, Key Vault, PurviewKeycloak or your existing Active Directory; OpenBao or HashiCorp Vault; an HSM
Monitoring and auditLog every run, model version, setting, flag and decision, so each result can be reproduced.CloudWatch, CloudTrailAzure Monitor, Log AnalyticsPrometheus, Grafana, OpenTelemetry
UK data residencyIONOS AI Model Hub runs in German data centres: EU, not UK, residency. Check each client's own restrictions in its engagement terms.eu-west-2 (London)UK South / UK WestYour own UK data centre, or a UK or EU provider

On a phone, the table shows the platform you pick. Sovereign / on-prem means open, portable components you can run in your own data centre or with a UK or European provider; IONOS is shown as one example, and others exist. What sovereign cloud means →

Hybrid and on-prem

Many organisations keep core systems and sensitive data on their own servers. This is how the same design works across both.

Stays on-prem

Each client's ERP stays exactly where it is, and the firm never connects to it with standing access. Many firms also keep the audit software and archived audit files in their own data centre, and nothing here needs them to move.

Uses cloud AI

Completeness checks, the standard tests, anomaly scoring, clustering and drafting can run in AWS or Azure UK regions, or on the firm's own GPUs for clients whose terms rule out public cloud.

How they connect

Clients upload extracts over SFTP or an encrypted transfer, with a manifest and hash totals. The firm reaches its cloud environment over a private link (AWS Direct Connect or Azure ExpressRoute), and results flow into the audit software through its API.

If the link drops

The audit carries on. The standard journal tests can run in the firm's own environment, as they do today, and the team works the hits by hand. Scoring and drafting catch up when the link returns, and nothing is lost because every extract is held with its manifest.

The agents

What each agent may do through its tools, what it may not, and where a person signs off. The limits are enforced by the platform, not the prompt.

Review assistant

May do

  • Read the scored entries, clusters and test results for this engagement only
  • Pull related lines from the client's extract: the posting user, approver, timing, account pairs and any documents the client provided
  • Draft a summary of each cluster and the working paper narrative for entries the team selected
  • Suggest follow-up questions for client management, for the team to send
  • Record which data, model and test versions each draft used

May not do

  • Choose the items to test, or clear a flag as 'no issue'
  • Conclude whether an entry is misstated or fraudulent
  • Contact the client or anyone at the client
  • See any other client's data
  • Change the extract, the tests, the model or its thresholds
  • Sign, file or mark a working paper as reviewed

Where a person signs offThe audit team decides what to test and concludes on every item. The reviewer and the engagement partner review and sign off under the firm's review policy. The assistant's access is scoped to one engagement at a time and enforced by the platform's identity and policy controls, not by instructions in a prompt.

Middleware and integration

Client data comes in one way: an extract with a manifest, uploaded to that engagement's location. Each ERP family has a standard extract script, owned and versioned by the central team, so the team knows exactly which tables and fields were taken and how. Write access to a client system is never requested.

Every extract is checked before anything else runs. If it doesn't reconcile to the trial balance or roll forward correctly, the workflow stops and the difference goes to the team to resolve with the client. Each extract and run carries an ID, so re-running after a corrected extract creates a new version and keeps the old one for the file.

Results reach the audit file through the audit software's import or API, and through your existing integration platform if you have one. The analysis platform never becomes the audit file; the file stays where your methodology says it lives.

The tool can be switched off without stopping an audit. If it's unavailable, the team runs the standard journal tests and follows the methodology exactly as before.

Process and people

  • The central audit technology team certifies the tool before any engagement uses it, re-certifies on every material change, and keeps the central documentation the FRC's guidance describes.
  • A named owner for each extract script, test, model and prompt, with change control like any other audit methodology change.
  • Engagement teams trained before use, including what the tool can't see: top-side and consolidation adjustments made outside the ledger, entries in sub-ledgers, and fraud that looks normal.
  • A clear route to forensic specialists when a cluster suggests something the team shouldn't investigate alone.
  • An ethics check before any output is shared with a client, so findings go through normal reporting and never become a service the client relies on.
  • The quality team reviews a sample of engagements each cycle, comparing what the tool flagged, what the team tested, and what they concluded.

Delivery plan

  1. 3–4 weeks

    Discovery

    Map today's journal testing and data extraction, list the client ERPs by volume, agree the certification route with methodology, and confirm what client engagement terms allow.

  2. Gate · must be true to passBaseline measured, top ERP families chosen, DPIA and ethics review started, certification criteria agreed.

  3. 10–12 weeks

    Pilot

    Re-run 10–15 completed audits from last cycle, then a few live audits in parallel with the standard approach. Compare what the tool flagged with what the teams tested and found.

  4. Gate · must be true to passExtract checks match or beat today's, flags explainable to the teams, central documentation complete, methodology sign-off.

  5. 4–6 weeks

    Production

    Certified for engagements on the pilot ERP families, with support, training and a rollback to the standard approach.

  6. Gate · must be true to passCertification recorded, support model and training in place, audit file template updated.

  7. Ongoing

    Scale

    Add ERP families one at a time, then reuse the platform for revenue, payroll and expense analytics.

  8. Gate · must be true to passEach new ERP family and each new analytic passes the same certification gate.

Roles and RACI

Who is responsible, accountable, consulted and informed, by activity
ActivityHead of audit qualityProduct owner (audit technology)Solutions architectI can fill thisTechnical PMI can fill thisEngineersI can fill thisMethodology & ethicsDPOSecurityI can fill this
Business case and benefitsAccountableResponsibleConsultedConsultedInformedConsultedInformedInformed
Target architecture and client data intakeInformedConsultedAccountable and ResponsibleConsultedConsultedConsultedConsultedConsulted
Tool certification and central documentationAccountableResponsibleConsultedConsultedConsultedResponsibleInformedConsulted
DPIA, confidentiality and independence reviewConsultedConsultedConsultedInformedInformedResponsibleAccountable and ResponsibleConsulted
Build and integration with the audit softwareInformedConsultedAccountableResponsibleResponsibleConsultedInformedConsulted
Re-running prior-year auditsInformedAccountableResponsibleResponsibleResponsibleConsultedInformedInformed
Go-live decisionAccountableResponsibleConsultedResponsibleInformedConsultedConsultedConsulted
Run, monitor and re-certifyAccountableResponsibleConsultedConsultedResponsibleConsultedConsultedConsulted

Business case and benefits

Head of audit quality
A · Accountable
Product owner (audit technology)
R · Responsible
Solutions architect
C · Consulted
Technical PM
C · Consulted
Engineers
I · Informed
Methodology & ethics
C · Consulted
DPO
I · Informed
Security
I · Informed

Target architecture and client data intake

Head of audit quality
I · Informed
Product owner (audit technology)
C · Consulted
Solutions architect
A/R · Accountable and Responsible
Technical PM
C · Consulted
Engineers
C · Consulted
Methodology & ethics
C · Consulted
DPO
C · Consulted
Security
C · Consulted

Tool certification and central documentation

Head of audit quality
A · Accountable
Product owner (audit technology)
R · Responsible
Solutions architect
C · Consulted
Technical PM
C · Consulted
Engineers
C · Consulted
Methodology & ethics
R · Responsible
DPO
I · Informed
Security
C · Consulted

DPIA, confidentiality and independence review

Head of audit quality
C · Consulted
Product owner (audit technology)
C · Consulted
Solutions architect
C · Consulted
Technical PM
I · Informed
Engineers
I · Informed
Methodology & ethics
R · Responsible
DPO
A/R · Accountable and Responsible
Security
C · Consulted

Build and integration with the audit software

Head of audit quality
I · Informed
Product owner (audit technology)
C · Consulted
Solutions architect
A · Accountable
Technical PM
R · Responsible
Engineers
R · Responsible
Methodology & ethics
C · Consulted
DPO
I · Informed
Security
C · Consulted

Re-running prior-year audits

Head of audit quality
I · Informed
Product owner (audit technology)
A · Accountable
Solutions architect
R · Responsible
Technical PM
R · Responsible
Engineers
R · Responsible
Methodology & ethics
C · Consulted
DPO
I · Informed
Security
I · Informed

Go-live decision

Head of audit quality
A · Accountable
Product owner (audit technology)
R · Responsible
Solutions architect
C · Consulted
Technical PM
R · Responsible
Engineers
I · Informed
Methodology & ethics
C · Consulted
DPO
C · Consulted
Security
C · Consulted

Run, monitor and re-certify

Head of audit quality
A · Accountable
Product owner (audit technology)
R · Responsible
Solutions architect
C · Consulted
Technical PM
C · Consulted
Engineers
R · Responsible
Methodology & ethics
C · Consulted
DPO
C · Consulted
Security
C · Consulted

R ResponsibleA AccountableC ConsultedI Informed· not involved

Where I'd fit

Option A

Lead the architecture

If there's no architect on the programme, I'd own the design end to end: the client data intake and integrity checks, the analytics platform, the link into your audit software and the gates, working with your methodology team so the tool can be certified and documented. I'd report to your programme board and your head of audit quality.

Option B

Support your architect

If your audit technology team or your partner already has an architect, I'd take on the extraction and integrity pipeline, the model platform and the audit software integration under their lead, and give them a second senior opinion on security, client confidentiality and how the documentation will stand up to review.

Where this goes wrong

  1. Goes wrong

    The extract was incomplete, and nobody noticed until the file was reviewed.

    How the design avoids it

    Every extract has a manifest and is reconciled to the trial balance and rolled forward before any test runs. A failure stops the analysis.

  2. Goes wrong

    The model is a black box, so the team can't say why an entry was flagged or why others weren't.

    How the design avoids it

    Reasons on every flag, the standard rules still run in full, and central documentation that explains how the model works and how it was tested.

  3. Goes wrong

    Teams treat a low score as evidence an entry is fine.

    How the design avoids it

    Training and methodology say plainly that a low score proves nothing. Selection and conclusions are the team's, recorded on the file.

  4. Goes wrong

    One client's data leaks into another client's results, or into a provider's model.

    How the design avoids it

    A separate store and key per engagement, models trained on that client's own history, and contracts that stop providers training on the data.

  5. Goes wrong

    The tool is built first and certified afterwards, so the first busy season runs without it.

    How the design avoids it

    Certification criteria agreed with methodology at discovery, and documentation built alongside the tool.

On the horizon

Changes already announced or under way that affect this design. More in the UK horizon scan.

  1. 15 December 2026
    ISA (UK) 240 (Revised March 2026) and ISA (UK) 570 (Revised March 2026) apply to audits of periods beginning on or after this date, with enhanced fraud risk assessment and more transparency in auditor's reports, mainly for publicly traded entities.

    Map the tool's outputs to the revised requirements and update the methodology and audit file template before the first affected audits are planned.

  2. 2027 annual reports
    Provision 29 of the UK Corporate Governance Code 2024 applies to periods beginning on or after 1 January 2026: boards of companies that report against the Code declare whether their material controls were effective. No auditor attestation is required.

    Expect audit committees to ask how journal controls look from the audit side. Keep the analysis as audit evidence, and agree with ethics what can be shared through normal reporting.

  3. No date set
    The government said in January 2026 that it would not take forward the Audit Reform and Corporate Governance Bill, so the FRC will not be replaced by ARGA for now. It still plans to put the FRC on a statutory footing when parliamentary time allows.

    Design to the FRC's current standards and AI guidance, and keep the tool documentation complete enough to satisfy whichever body regulates audit next.

  4. 2028
    The NCSC asks organisations to have a full post-quantum cryptography migration plan by 2028.

    Audit files and client ledgers are kept for years. Record which encryption the platform uses for stored extracts and transfers, and keep it easy to change.

Questions to ask your partner or vendor

Good answers are specific. Vague answers to any of these are worth following up.

Copy them into your next supplier meeting

  1. How do we prove each client's extract was complete before any test ran?
  2. What does the central documentation say the model does, and how was it tested on our clients' data?
  3. Can the team explain why every flagged entry was flagged, and why the methodology's rules still ran in full?
  4. How is each client's data kept separate, and is any of it used to train models for other clients or for a provider?
  5. What happens to an audit if the tool is unavailable in the busiest week of the year?
  6. What does it cost to run per engagement, at our mix of client sizes?

Planning something like this?

Whether you need someone to lead the design or to support the architect you already have, let's talk it through.

Sam Naseem
Sam NaseemBirmingham, UK · UK & Europe
Available now