NA: 1 (888) 669.4225
EUR: +44 (0) 1189 49 7434 | ASIA: (65) 6316 1481

Vendor Scoring – Identifying the Best Vendors to Audit for Fraud Recovery – Part 2

This is the fourth post in a series called Practical Data Alchemy Using ACL Software by Rich Lanza. Part 1 of this post was focused on developing a vendor score to improve sample selections of vendors.  The vendor score was assigned based on the key field, a unique vendor number and a
Continue Reading →

Vendor Scoring – Identifying the Best Vendors to Audit for Fraud Recovery – Part 1 of 2

This is the third post in a series called Practical Data Alchemy Using ACL Software by Rich Lanza. In any organization, there may be thousands of vendors but it is difficult to determine which vendors are the most ripe for review from an error, fraud, or cost recovery perspective. Usu
Continue Reading →

Top 25 Analytic Tests for Every Organization: Test 4 T&E – Expense Profiling

Today we’re taking a break from journal testing and focusing our attention on travel and entertainment (T&E) expenses. Often, this is not an area that warrants detailed attention, because the transactions are too small to be material. What’s the point in chasing after
Continue Reading →

Top 25 Analytic Tests for Every Organization: Test 3 GL – Journal Entries with Outlier amounts

Last time we targeted potential outliers in a specific GL account. This time, we’ll look at broadening our reach by applying statistical analysis across the whole field of GL accounts! To do this, we want to figure out what would be the typical sized posting to each account, and
Continue Reading →

Optimizing Script Performance Part 4: To PRESORT or not to PRESORT (that is the scripting question)

This is part four of an ongoing series on Optimizing Script Performance – part three focused on Keyword Searches. Hello my fellow scripting friends! I hope you are ready for some more tips and tricks in the world of data analytics…so let’s get right to it. Today, we are go
Continue Reading →

Optimizing Script Performance Part Three – Keyword Searches

Previously we looked at how you can improve script performance with some simple (yet often overlooked) commands. In case you missed the earlier posts on Optimizing Script Performance, read Part 1 and Part 2. Greetings scripters! Today, I would like to touch on a slightly more advanced
Continue Reading →

Why I love Desktop 9.3

Recently, ACL hosted a webinar on our new product release, ACL Importer. During the question period, we received a nice compliment from one our longstanding customers, David Hermansen, Project Professional, Experis, ACDA, CISA (retired), stating that he “loves Desktop 9.3.” It’s alway
Continue Reading →

Optimizing Script Performance: Part Two

The demand for automated solutions is increasing, especially with companies scrambling to interpret big data. ACL data analytics provides a great solution for automation with an easy-to-learn scripting language that can be applied to practically any data set. This series is aimed at p
Continue Reading →

Optimizing Script Performance: Part One

Writing efficient and effective scripts in ACL data analytics software requires a combination of knowledge, experience and creativity. This is what makes scripting in ACL data analytics so much fun (and why I love it so much). You can solve extremely complex problems using ACL’s power
Continue Reading →