Audit Command Language – How to set up ACL project

How an Audit Command Language project is set up can improve the efficiency of the overall workflow. It is safe to say that there is definitely no clearly defined way to set up your project, but there are nonetheless a few guidelines you may want to follow. Follow the procedures below:

Set Up Project Folder 

Audit Command Language is quite peculiar in the way it creates its own set of files with their own set of extensions like ‘.fil’, ‘.lix’ etc. It can be quite confusing to have them in the same folder as the raw data files or any other output files that you might create. As general rule, create your project in a directory as shown in the screenshot


In data folder, place your raw data files. The points any files being exported to the ‘Output’ folder. Create your ACL Audit Command Language project in the ACL folder. See screenshot.

Creating a new project in Audit Command Language Software
Open new project in Audit Command Languge


Naming the Project

Name the project which best describes your nature of work, with the name including the date. For example, ‘Customer Analytics – Instore Evaludations 01012016 through 06302016′. This format of naming helps to identify the project clearly and is carried over all the way through the log files generated in “Audit Command Language”.

Create a Standard Directory Structure for all Projects

Always create a directory structure dedicated for all Audit Command Language projects. This practice enables users to better manage the project work. This is categorically true for young professionals. Those going through ACL training may want to adopt this best practice as early as possible.

For those interested in Audit Command Language certification, please refer to reference materials provided alongside the posts. These are helpful study materials to prepare for various certification exams. Also, please sign up for our newsletter to stay up to date with the latest activity on the site.