ACL Analytics

(15)
4.2 out of 5 stars

ACL’s Data Analysis solutions are specifically designed to help risk and control groups, such as Audit, Risk, Compliance, IT or Financial Control professionals perform in-depth analysis of data with ease. Quickly find exceptions and control breakdowns that leave you exposed to financial and reputational risk-increasing coverage and decrease the time it takes to analyze the truth in your transactions can be easy.

Work for ACL Analytics?

Learning about ACL?

We can help you find the solution that fits you best.

ACL Analytics Reviews

Ask ACL a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 17 ACL reviews
LinkedIn Connections
ACL review by Rob T.
Rob T.
Validated Reviewer
Verified Current User
Review Source

"Very powerful analytic tool, can't say enough good things about ACL. "

What do you like best?

ACL'S ability to work with millions of records quickly and easily. It uses a minimalist scripting language for 90% of tasks, and the remaining tool set is easy to learn once the basics are mastered. I spend all day using ACL and enjoy learning better or more elegant ways to apply it against my data warehouse.

What do you dislike?

The only thing that I can say I dislike is that the native ACL 'launchpad' (ACL'S version of a communication hub) is not very good when it comes to searching for help or suggestions. However, I attended the recent ACL Connections conference and ACL is aware of this shortcoming and are addressing it.

Recommendations to others considering the product

ACL is constantly evolving, introducing new concepts and improving on existing functionality. Their support is top notch and the ACL user community is robust and helpful.

What business problems are you solving with the product? What benefits have you realized?

I work in audit, so I primarily use ACL to monitor compliance and to look for fraud. I also do ad hoc functions in support of third-party auditors, and the information that I have been able to provide has made our external audits run smoother because the focus was results focused versus information gathering intensive.

Sign in to G2 Crowd to see what your connections have to say about ACL Analytics
ACL review by Sid J.
Sid J.
Validated Reviewer
Verified Current User
Review Source

"Great Analytics tool for data-intense audits"

What do you like best?

1. Duplicates and Fuzzy Duplicates feature: This is an amazing tool that Excel probably lacks and makes it so easy to pick lines based on one or more fields being duplicate or fuzzy duplicate (can specify the percentage of similarity).

2 Other "Analyze" tools like Classification that eliminate the need to filter and delete in Excel - alll without requiring any script

3. Scripts can be set up with the company's ODBC database as the source for the table

What do you dislike?

1. While importing data is not that difficult, I often get errors in terms of the field name not getting imported properly for performing conditional functions like keyword search

2. Even if multiple spreadsheets have the same format, i.e. same header row, they all need to be imported one by one.

3. Running complex slows down the system making it hard to use other applications like Excel

Recommendations to others considering the product

Make sure you reach out to your company's ACL representative to get phone or in-person support for setting up scripts in ACL Analytics - especially if you don't have time to go through ScriptHub or the online training courses,

What business problems are you solving with the product? What benefits have you realized?

Our Internal Audit team has used it for:

1. Keyword search in General Ledger data for Compliance audits

2. ACL Script for identifying Duplicate payments and vendors for Accounts Payable

3. Analyzing purchase orders with the same order number, issuer and date using the Duplicates function

Benefits realized are reduced time spent trying to figure out these functions using Excel

What Tools for ERP solution do you use?

Thanks for letting us know!
ACL review by G2 Crowd User in Accounting
G2 Crowd User in Accounting
Validated Reviewer
Verified Current User
Review Source

"Excellent product for analyzing large data sets"

What do you like best?

ACL Analytics can accept data files of any size! With this software I am able to compare data sets with similar, yet non identical fields. There are many tools to harmonize data in order to make it comparable for analysis with data from a different source. The log file kept within the software allows for easy supervisor review of the procedures used to analyze data. In addition, the log can be used to create a script to rerun the analysis. Spend a few hours developing a comprehensive analysis of one quarter of data, use the log to create a script, and now you can analyze quarters 2-4 in minutes!

What do you dislike?

The software can be difficult to work with and learn how to use. It is one of those pieces of software where there is so much that you can do with it, that figuring out how to use it and the most efficient way to analyze data with the tools available can be very challenging. Without regular use, it is easy to lose the knowledge and expertise of the system that you have developed.

What business problems are you solving with the product? What benefits have you realized?

We have gained incredible efficiencies in analyzing data. The biggest benefit has been harmonizing data from different sources to compare and test reasonableness of sets of data.

ACL review by Paul C.
Paul C.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Longtime ACL user and consultant"

What do you like best?

I have used ACL software for almost 20 years. In that time, I have been able to easily bring in millions (even billions) of records from different types of data and develop creative data analysis solutions for many customers, from sole proprietors and family members to Fortune 500 companies and other large organizations.

What do you dislike?

ACL is working on features such as increased visualization capabilities and functionality. I wish these updates would come sooner; however, it is entirely worth noting that in recent years, ACL has proven their dedication to more frequent updates.

Recommendations to others considering the product

I would recommend giving ACL a try and sticking with it. Find some basic datasets to pull into the software and play with the data and ACL features. The learning curve varies by person, based on experience, mindset, and skills, but ACL software can be used by anyone of any level of capability and knowledge. Once you find ways to use the software and pull information out of the data, you will likely be hooked. ACL software can easily provide positive return on investment within hours or a few days of use. It does more than just pulling statistically random samples. The capabilities of ACL software are practically only limited by your imagination, which is a liberating feeling!

What business problems are you solving with the product? What benefits have you realized?

I am solving so many business problems for customers right now, including analysis of Accounts Payable, General Ledger, P-Card/T&E, and other data to identify anomalies, fraud, general information about the data, opportunities to improve processes, savings toward the bottomline, etc. Main benefits have included excitement from customers simply from having more insight about their data and a feeling they can make better quality decisions faster.

ACL review by User in Accounting
User in Accounting
Validated Reviewer
Verified Current User
Review Source

"Data analytic tools for audit projects"

What do you like best?

Ease to use, a lot of customized functions for audit projects. The interface is clean and the generated results can be modified to fit project needs.

What do you dislike?

the codes are sometimes different from SQL, makes it confusing sometimes when you are trying to type out codes. Wish there are ways to drag and drop fields (think pivot tables) to generate custom reports.

Recommendations to others considering the product

If pivot tables are not powerful enough for your needs and you do not want to spend time on learning SQL, ACL is somewhere in the middle where you can still get your results with some quick learning. Hopefully it will be more user friendly in future versions.

What business problems are you solving with the product? What benefits have you realized?

I use ACL when I need to analyze a large amount of data at work, and when pivot table might not be powerful enough, especially around areas when I need to perform audit testing. ACL is built for auditors so it makes the process more straight forward.

ACL review by User in Medical Devices
User in Medical Devices
Validated Reviewer
Review Source

"ACL for your analytics needs!"

What do you like best?

I like how ACL is quick to decipher errors within my data. It joins sets super fast, and allows for multiple scripts to run on separate program windows with ease.

What do you dislike?

I dislike the lack of exporting. If you create a summation you cannot simply export this to excel, users jump through multiple hoops to complete this process.

Recommendations to others considering the product

Be sure to take their course offerings and attend in person and webinars to get full access to all of the potential ACL has to offer.

What business problems are you solving with the product? What benefits have you realized?

I am solving automation issues within my department. Since I can call scripts a specific times, I am able to pull and push data with ease. I have found this enhances my profitability as an internal customer.

ACL review by User in Building Materials
User in Building Materials
Validated Reviewer
Review Source

"Easy to use!"

What do you like best?

I like that ACL Analytics is very user friendly and intuitive. I can easily upload most formats of data to analyze without doing too much manipulation to my reports. I also like that it has a great tool for internal control's management. I also like that you can set up to pull / extract data at a scheduled time.

What do you dislike?

There are very few things I dislike about ACL Analytics program. One thing that I have noticed is that it can freeze up or slow down a great deal when there is large data. Sometimes the program can take 30 min to upload / extract data when working off-site. i also have noticed that user access has to be added each time a new report is created, but this could just be the way my company has setup the program for our department use.

Recommendations to others considering the product

Get it!

What business problems are you solving with the product? What benefits have you realized?

The ACL Analytics program is great for speeding up the process for random sampling, comparing different data tables, etc. I really love that I can schedule data pull from our ERP systems for both my weekly and month reports that way I don't have to download the data myself before it is deleted from our system. I like that ACL Analytics is very user friendly and intuitive, so that training time for new employees is short. I can easily upload most formats of data to analyze without doing too much manipulation to my reports.

ACL review by Mehul M.
Mehul M.
Validated Reviewer
Verified Current User
Review Source

"ACL GRC and Analytics review"

What do you like best?

ACL Analytics simplicity. It is easy to use. One can import varied formats of files, connect to ERPs. It directly connects to GRC.

GRC Results manager peace is awesome, which lets user to track exceptions reported and makes people actually accountable.

What do you dislike?

ACL Aanlytics must include features of Predictive analytics, Should remove the feature of FILE based or .FIL system atleast for ERPs connecting via ODBC and Direct Link.

What business problems are you solving with the product? What benefits have you realized?

We are using ACL for Internal controls monitoring, FCPA controls, Third party controls. Tracking of duplicate invoices, payments

Benefits:

1. Real time monitoring

2. Converting onsite audits to offsite audits with the help of Continuous control monitoring, thereby reducing Travel and stay cost, improving efficiency of audits,

ACL review by User
User
Validated Reviewer
Verified Current User
Review Source

"ACL Analytics"

What do you like best?

I like the ability to transform PDFS into Excel as well as use the software for sampling.

What do you dislike?

I think it is hard to initiate a new project.

What business problems are you solving with the product? What benefits have you realized?

My company uses ACL analytics to analyze large data sets for internal auditing purposes. We have found it efficient in running large data sets that Excel cannot normally handle.

ACL review by User in Banking
User in Banking
Validated Reviewer
Review Source

"ACL user in the banking industry"

What do you like best?

ACL gives you the ability to complex analytical tasks with a minimal amount of scripting. The scripting language has an easy syntax, is very intuitive and easy to learn especially for users with programming experience.

Compared to other programming languages, ACL can do in a few lines what would take much more to do with another programming language.

The analytic chain on the ACL Audit exchange makes it really easy to schedule a lot of scripts to run one after the other with the ability to stop a chain if an important script fails.

The NOTIFY command on the ACL Audit Exchange allows a user to send out an e-mail notification with an attachment.

The DICE coefficient and Fuzzy matching tools are useful to compare strings that are not an exact match.

The REGEX function has helped simplify pattern searching scripts and eliminated the need to use GROUP and LOOP.

What do you dislike?

ACL Desktop:

***************

ACL needs to bulk up their statistics package. STAT function is too basic, there needs to be an option to get the median, Q25, Q75 and the deciles, Q10 and Q90.

The lack of an option to create a "user defined function" that can be applied using the summary command.

Four digit SOUNDEX function needs to be replaced with the updated 6 digit SOUNDEX function.

ACL Audit Exchange:

***********************

If data tables are contained in separate schemas then ACL needs to pull the tables into the ACL environment for filtering.

This can be problematic if the data tables on the client database are large in size.

A SQL pass-through query would be helpful as any filtering can be done on the client side.

Ability to assign user access at the analytics level.

What business problems are you solving with the product? What benefits have you realized?

ACL Audit Exchange:

************************

1. No more need to use windows scheduler to automate scripts.

2. Schedule scripts to be run a periodic basis.

3. Direct connection to source databases and the ability to extract data from more than one table.

4. Elevate the profile of audit analytics.

5. Share scripts with the business units.

6. Implement advanced statistics using scripting

7. Fraud Analytics and Benford Analysis

ACL review by User in Hospital & Health Care
User in Hospital & Health Care
Validated Reviewer
Review Source

"Awesome Data Analytics Tool with Excellent Support"

What do you like best?

I love the ease of learning the many useful commands and functions of ACL, and I like having the confidence that the product is supported by a company that puts a lot into technical support as well as product development.

What do you dislike?

I'd like to see an improvement in the wizard for importing complicated PDF files. Other than that, exporting simple PDF files is fairly easy and improvements are always being made to the tool.

Recommendations to others considering the product

I recommend ACL Analytics for its many analytics possibilities, ease of use, and the excellent company and people behind it. I have confidence that this tool will be around for a very long time.

What business problems are you solving with the product? What benefits have you realized?

ACL is very useful in performing Accounts Payable analytics and looking for duplicate vendors.

ACL review by Amol W.
Amol W.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"ACL Analytics is powerful analytics tool"

What do you like best?

ACL Analytics is user-friendly, Can import varied formats of files, RDBMS data.

What do you dislike?

ACL Analytics should remove the feature of FILE based or .FIL system

What business problems are you solving with the product? What benefits have you realized?

We are using ACL to monitor Internal Audit controls and Third party controls.

ACL review by Administrator in Consumer Goods
Administrator in Consumer Goods
Validated Reviewer
Verified Current User
Review Source

"New to ACL "

What do you like best?

Although I am fairly new to ACL, I am finding it to be user friendly and easy to learn. There are a lot of features that are very useful such as the ScriptHub and Inspirations.

What do you dislike?

So far I do not really dislike anything about ACL, as I am still learning.

What business problems are you solving with the product? What benefits have you realized?

We utilize large amounts of data for our audits and the ability to pair down information rather quickly using ACL has been very helpful.

ACL review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"Simple and easy"

What do you like best?

Very easy language to learn. Great first analytics program.

What do you dislike?

Slow for large projects. 10 mil+ is quite a wait for anything, even a simple join.

What business problems are you solving with the product? What benefits have you realized?

I use acl for ARCA management. It is amazing for work originating in pdfs, because you can static values down, which many other languages don't have.

ACL review by User in Banking
User in Banking
Validated Reviewer
Review Source

"ACL Review"

What do you like best?

I like that I can roll forward a journal entry file quickly and then perform journal entry testing.

What do you dislike?

Searching within large files can be cumbersome and cause the program to crash.

What business problems are you solving with the product? What benefits have you realized?

This has greatly improved audit efficiency and has helped to provide beneficial information to clients.

ACL review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"ACL analytics review"

What do you like best?

ACL is user friendly and basic functionality can be learned quickly.

What do you dislike?

Most of the tool mirrors Microsoft Excel, which (to me) is easier to use.

Recommendations to others considering the product

Can you perform the same analysis via Excel?

What business problems are you solving with the product? What benefits have you realized?

Advanced analytics of large data sets.

ACL review by User in Banking
User in Banking
Validated Reviewer
Review Source

"Scripting has saved me a lot of time and effort"

What do you like best?

Scripting functionality is highly useful when conductive repetitive tasks.

What do you dislike?

Scripting functionality is very limited when it comes to calling external applications.

What business problems are you solving with the product? What benefits have you realized?

100% User Acess Testing during Compliance reviews.

Far more effective that using a sampling process which is usually a hit or miss for issues.

Kate from G2 Crowd

Learning about ACL Analytics?

I can help.
* We monitor all ACL Analytics reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.