ACL Services: Scouring the Entire HaystackBy Joshua Weinberger | Posted 2003-08-01 Email Print
Re-Thinking HR: What Every CIO Needs to Know About Tomorrow's Workforce
To Catholic Healthcare Audit Network's Jill Linden, ACL "is an incredibly powerful tool.
To Catholic Healthcare Audit Network's Jill Linden, ACL "is an incredibly powerful tool. The level of analysis we can do with ACL makes [our findings] hard to dispute." In fact, the power can at times be overwhelming. "If you're doing all this analysis, you're coming up with all these exception reports"each of which flags a potential anomaly, or a series of transactions that fall outside an expected trend. Every report then needs to be examined. "Clients [sometimes] yell 'Uncle'."
Where Excel maxes out at just over 60,000 records, says BlueCross BlueShield's Clay Cochran, "ACL lets you load any type of file, regardless of the data size. You're basically limited just by your storage capability." Auditors used to look at a small sample and extrapolate. "With ACL, instead of looking at 30 employees, I can look at the entire company," he says. "We've found more errors as a result."
"The closer you are to the raw data, the better," says Meridian's Ralph Wood, "I want the very rawest dataand ACL seems to be able to read anything." But, as with any data-analysis tool, data quality is a constant concern. "If the data's bad, all the analytics will be bad," says HarborView's David A. Less. A series of 12 identical payments could be a problemor they could just be monthly rent checks, poorly tagged.
ACL empowers auditors to try new things. "We go into an audit for a specific reason," Alcatel's Kerry Shulman says. "But with ACL sometimes you just play around and find unique relationships" that lead to unexpected results. And ACL keeps improving. "Each new version gets easier and easier," Shulman says ACL 8 "is more like a portal."
Cochran likes that he can "do a lot of the data analysis myself, instead of having to rely on a programmer. I can have a result in 10 minutes instead of having to wait for two days."
ACL's audit logcapturing every keystroke and queryis another popular feature. Useful groups of queriesknown as batchescan then be shared with other users, according to Linden. "We never have to build from scratchwe're constantly refining our standard batches."
But some limitations remain. When importing data, Shulman says ACL "can't handle report files with wrapped data over multiple lines," and "will only handle importing one tab per spreadsheet," she says. With multiple tabs, "you have to pre-format a little bit," which she says can take a half-hour of preparation time.
That may be time well spent, if looking for needles in a haystack means spinning the hay into gold. KeyCorp's Fred Sarazin says ACL is directly responsible for bringing back $700,000 in duplicate paymentsand for uncovering at least one six-figure fraud.
1550 Alberni Street
Vancouver, British Columbia, V6G 1A5 /
Ticker: Private; founded 1987.
Employees: 152 worldwide
President, CEO, Founder
The company's driving force, his idea was to put his father's 1972 algorithm at the core of an analytic engineand sell it.
VP, Professional Svcs. Grp.
A longtime champion of computer-assisted audit techniques, he leads global consulting, training and support services. Prior to joining ACL in 1991, he was a principal with Deloitte & Touche.
Joined ACL in 2001. Responsible for the overall strategic direction of product development, including R&D activities, product management and quality assurance. Holds a computer science degree and an MBA.
ACL for Windows 8 compares, recalculates, and verifies files of transactional data, looking for errors and fraud. ACL for OS/390 provides direct access to mainframe operational data. The ACL Client/Server System integrates results for analysis.
Recent accounting scandals have cast a spotlight on auditing, but ACL's been gathering converts since long before Enron imploded. Auditors may not be effusive by nature, but get them started on how ACL has heightened their investigative prowess, and the praise flows.
SVP, Operations Risk Management
Project: Regional banking chain has used ACL for more than three years, first in the medical-benefits area, and now in accounts payable and in the branches.
Project: Consulting firm uses ACL to assist British Columbia's Ministry of Provincial Revenue in accurately auditing individuals' and companies' tax compliance.
Catholic Healthcare Audit Networt
Project: Auditing consultancy adds about a dozen ACL users a year to provide its health-care clientele with risk assessments and accounts-payable analysis.
Kerry Shulman Audit Mgr., Alcatel Group Audit Svcs.
Project: Telecommunications giant has 13 worldwide ACL 8 licenses to search for duplicate payments, analyze customer-product-returns data, and validate metrics, among other uses.
BlueCross BlueShield of Louisiana
Senior Audit Consultant
Project: Currently using ACL to keep tabs on its deployment of PeopleSoft, conducting queries on files as large as 500 megabytes. Not yet using ACL for fraud detection.
AIG American General
Jim Goldsmith, Senior Supervising Internal Auditor
Project: Insurance firm upgraded to ACL for Windows in 1998, but use dates back to the "ACL for DOS" era. Used remotely by auditors when performing field audits.
David A. Less
Project: Connecticut-based independent auditing firm brings ACL to bear on its clients' business processes.
The executives listed here are all customers of ACL Services. Their willingness to talk has been confirmed by Baseline.