Professional Validation Library

Controls That Actually Run · Kai London

ERP Financial Control Automation: Test Transaction Completeness, Reconciliations and Exception Handling

Automated ERP controls are easy to trust. Can you prove what the system really does?

Automated ERP controls are easy to trust and hard to prove. This independent practitioner reference shows you how to test transaction completeness, reconciliations and exception handling so that your control evidence demonstrates what the system really does.

Part I is a practitioner guide that takes you from the problem through the core controls and tests. Part II is a field toolkit of labs, case studies and annotated templates you can adapt. Part III is reference and practice, with workbooks and templates for repeatable work. Part IV is an evidence casebook of worked cases, and Appendix A collects checklists for use in the field.

The guide covers automated controls in ERP, control design, completeness and accuracy tests, interface reconciliations, sub-ledger to general ledger reconciliation, and exception workflows. Later chapters address period-end controls, data analytics for control testing, evidence for auditors and continuous monitoring, closing with a worked order-to-cash case. Lab chapters build an order-to-ledger control lab, inject failures and automate control tests.

It is written for finance controllers, internal auditors, ERP and finance systems teams and risk managers who need repeatable testing rather than reliance on a reconciliation that merely reports success.

Every chapter is built for working professionals: a real headline, a dramatised boardroom scene, decision tables, worked examples with expected results, the evidence to keep, a checklist, the board question and a self-test. The book closes with a capstone assessment, consolidated checklists, model answers, a standards crosswalk, a certification domain map for CISSP, CISM, CRISC and CISA, and a full index.

Professor Kai London