1. Visual Flows
Build analytics by connecting steps together in a flow. Each task represents part of the audit test, making the process easier to design, review, explain, and rerun.
- Drag-and-drop style workflow design
- Clear view of each analytics step
- Easier review of logic and dependencies
- Reusable flows for recurring audit work
2. Data Import and Preparation
Bring data into the application and prepare it for analysis using structured, repeatable steps.
- Import Excel and CSV files
- Prepare and clean source data
- Rename fields and organize outputs
- Create working tables for testing
3. SQL-Based Processing
Use a modern SQL backend to perform analytics and transformations efficiently.
- Joins, filters, summaries, and calculations
- Large dataset processing
- Repeatable SQL-backed task execution
- Transparent logic behind each step
4. Audit Analytics Tests
Run analytics designed for common audit needs.
- Journal entry analytics
- Duplicate detection
- Gap and sequence checks
- Sampling
- Summaries and stratification
- Exception reporting
- Reconciliations and reasonableness testing
5. Output and Documentation
Generate outputs that support audit review and documentation.
- Structured results tables
- Clear exception outputs
- Export-ready results
- Repeatable test evidence
- Workflows that help explain what was done
6. ACL Project Compatibility
For organizations that still use ACL, Visual Audit Analytics can also work with ACL projects and scripts. This allows teams to keep value from existing ACL work while moving toward a more modern visual analytics approach.
- Open or reference existing ACL projects
- Support legacy ACL workflows where needed
- Help transition from script-heavy processes
- Keep ACL support as an optional feature, not the main workflow