Journals Testing by Bloch.ai
A end-to-end example journal entry testing workflow for auditors with 6 tests showing how to use KNIME to test 100% of journal entries rather than manual sampling or expensive commercial options.
The workflow covers:
Importing and cleansing journal entries and trial balance data
Reconciling aggregated journal movements to trial balance figures
Applying six automated audit tests
Filtering and exporting flagged entries to timestamped Excel files
Visualising journal activity by account
Audit tests included:
Self-approved entries (segregation of duties)
Missing descriptions
Round amounts (divisible by 1,000)
Backdated journals
Out-of-hours postings
Large transactions relative to materiality