DataConsulting May 2013 Newsletter


Welcome to DataConsulting’s May newsletter and greetings from Saudia Arabia where I am writing my contributions for the Newsletter. I’m out here delivering ACL training and it’s certainly very warm, presently pushing over 40 degrees centigrade!

During the last few weeks I’ve done a bit of travelling including a trip to the ACL Connections conference over in Atlanta. I’m going to elaborate on my trip a bit further on in the newsletter so more on that later. We’re all pretty excited at DataConsulting with the arrival ACL Desktop version 10. No longer to be referred to as ACL Desktop but as ACL Analytics it promises to have increased performance levels, many additional functions as well as the ability to call mobile phones and pass on messages via the new EXECUTE command! There’s plenty more on Analytics 10 in our main feature of the newsletter.

It’s not only Desktop that’s changing its name, AuditExchange is becoming Analytics Exchange so if you referred to it as AX you’re pretty safe to keep using that acronym. As well as briefing you on my trip to Atlanta I’m going to give you an update on ACL’s latest cloud based product ‘ACL GRC’ which is due for release this month. There’s plenty more in the newsletter including a coffee corner from our new starter Rikki Wainman. Hope you enjoy the newsletter, can’t believe its nearly already June!

Best Regards,


Introducing ACL Analytics 10

ACL™ Analytics 10 — Big Data Analysis Made Easy

ACL Analytics 10™ (formerly ACL Desktop™) is now released and available to download! It’s packed with improvements and enhancements such as 15 new analytical commands and functions including native date, time, and datetime data types to make analysis quicker and easier.

Robin’s trip to ACL Connections in Atlanta, Georgia

Over 350 enthusiastic ACL users flocked to Atlanta for the annual ACL Connections conference. The venue was fantastic and the southern hospitality warm as always. The attendees were not to be disappointed as the conference packed in many sessions from the latest news on product releases, technical coaching and training through to keynote speeches from quite comical compliance lawyers!

Introducing ACL GRC

One of the sessions I attended while in Atlanta was on ACL GRC which is ACL’s cloud based product focussed on providing a data driven GRC solution. I was impressed by the usability of the product and its seamless integration with the core ACL analytics products: ACL Analytics and ACL AX. The GRC product comprises Risk Manager (formerly ACL Risk), Project Manager (formerly ACL Workpapers) and Results Manager.

ACL Success Story: Baystate Health Inc.

“ACL gives us the ability to quickly and accurately provide information about our corporate control environment.”

Gail Hormats, Manager, Audit Services, Baystate Health Inc.

how Baystate Health are using ACL to:

  • recover US$2.5 million in lost revenue
  • save approximately US$18.5 million in costavoidance
  • enhance their word with fast server processing and scheduled, repeatable analytics
  • achieve broader audit coverage to enhance controls assurance
  • gain timely insight into critical business issues and processes
Top 25 Analytic Tests for Every Organisation

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 look for unusually sized postings. Now, some accounts will inherently have a large range of sized transactions posted to them, but some will have a very narrow range. We’ll take this into consideration when we identify our outliers.

SAP ERP data analysis streamlined with ACL Direct Link

You can now see a video of April’s lunchtime webinar from DataConsulting and ACL. The webinar demonstrates ACL Direct Link for SAP ERP, and discusses how it can improve your audit coverage, and reduce lead times to obtaining SAP data.

Strengthening Controls in 2013: Travel & Entertainment Expenses

For many organisations, T&E represents a significant spend, with a high risk of exposure to costly abuse, misuse and fraud. Generally, controls within this business process are manual or a matter of policy. The sheer volume of transactions can make it difficult for T&E program managers to validate transaction controls in a cost-effective way. For other organisations, T&E may not be a significant area of expenditure, but analysing T&E spend can provide interesting insights into the organisation’s culture of compliance.

ACL Bootcamp Exercise 10: Data Harmonization

In this Bootcamp session, we’re going to dive into Harmonizing Data with Functions in ACL, to show you how to get the most out of these.

You’ll learn about:

  • how to consistently format data using Upper, Lower, and Proper function
  • how to only include or exclude certain characters in a field using the Exclude and Include function
  • how to manipulate character values using the Split and Substring function
  • how to use the Map function to validate the format of a string

Coffee Corner

Hurrah it’s May!! The lovely month brings us Bank Holidays, BBQs and British Weather… Let’s hope that the sun is out for the first two. This May also brings you the new addition to DataConsulting – Rikki Wainman. For this month’s Coffee Corner I thought it would be a great idea to have a little look at the Top 3 Places to Visit in May. Will these inspire your next trip away…

Upcoming Events and ACL Open Enrolment Courses

ISACA Chapter 20th Anniversary Full Day event and AGM – Solihull, May 23, 2013 – Register

ACL 105: Foundations of ACL – Concepts and Practices – London, September 16-17, 2013 – Get a quote

ACL 302: Advanced ACL Concepts and Techniques: Scripts – London, September 18-19, 2013 – Get a quote

ACL 901: ACL Certified Data Analyst (ACDA) Examination – London, September 20, 2013 – Get a quote


Can’t wait until next months’ newsletter?

… then join us on Twitter, Facebook and LinkedIn to get daily bite-sized updates




Wednesday, May 1, 2013 In: Newsletters Comments (None)

Contact us

3 Appleton Court, Calder Park
Wakefield, WF2 7AR

+44 (0) 1924 254 101

Mailing List

Subscribe to our newsletter.