Navigation:


DISCUSSIONS > SPECIALTY GROUPS [ REFRESH ]
Thread Title: Audit Command Language
Created On Saturday July 29, 2006 10:09 AM
  Audit Command Language
  Audit Command Language
  Audit Command Language
  Audit Command Language
  Audit Command Language


Garry


Posts: 1
Joined: May 2006

Saturday July 29, 2006 10:09 AM

User is offline View thread in raw text format

I am trying to get general information regarding audit command language (ACL). Please advise if you use this and if so, what you use it for. Thanks.

-------------------------
Garry Kornrumpf

Reply
Quote
Top
Bottom



Crash


Posts: 1770
Joined: Jun 2004

Monday July 31, 2006 10:35 AM

User is offline View thread in raw text format

Check out their web site. Look at IDEA as an alternate tool. These tools are used to assess properties of data sets. The list of properties to assess is as endless as your creativity. Maybe someone else has the patience to list their uses, but you should go to a seminar to really get a feel for the product.

-------------------------
Do the right things for the right reasons.

Reply
Quote
Top
Bottom



bigkell


Posts: 2448
Joined: Oct 2003

Monday July 31, 2006 12:01 PM

User is offline View thread in raw text format

Auditsoftware.net puts this out. It applies to using EXCEL for audits, but I'm sure the concepts can be envoked using ACL / IDEA.

http://www.auditsoftware.net/documents/excel-audit-software.pdf

Reply
Quote
Top
Bottom



j0cy


Posts: 2
Joined: Mar 2007

Monday March 12, 2007 1:30 PM

User is offline View thread in raw text format

I just began using ACL. It's pretty useful as there are limitations on Microsoft Access and Microsoft Excel. There has always been row limitations of 65,000 but I think that has been eliminated with Microsoft Office 2007. Don't quote me though... I have not verified it.

I suggest taking the beginners foundations course if you do decide to use ACL. I spent a few days getting used to the functionalities in ACL and then went to the class. The main plus about using ACL is that if the data is not formatted correctly, ACL has the capability to reformat all of the data in the correct format before you begin your analysis.

ACL also only reads the data, so that you know you are never making changes to the original data itself.

Reply
Quote
Top
Bottom



MMK


Posts: 2
Joined: Mar 2007

Thursday March 15, 2007 3:20 AM

User is offline View users profile View thread in raw text format

The major functionality of any General Audit software (GAS) will be

File Access ( Diffrent clients will be using diffrent platforms u cant be aware of all platforms, so we have to have a common platform to work with different files)

File Reorganisation ( converting file formats as per requirement)

Statistical ( Statistical sampling, other statistical analysis)

Arithmetic ( Totaling,summarise,counting etc)

Stratification & frequency analysis ( Survey of population,overall view of transactions)

Indicating Fraud ( By use of benford law)

Reporting (U can report ur analysis in a presentable format)

How ever the real benifits can be achived only when we are clear on our audit objectives.

---------------------
Kumar



-------------------------
Muthu Kumar

Reply
Quote
Top
Bottom

DISCUSSIONS > SPECIALTY GROUPS [ REFRESH ]
The Institute of Internal Auditors • 247 Maitland Avenue Altamonte Springs, FL. 32701-4201 USA
+1-407-937-1100 • FAX +1-407-937-1101 • www.theiia.org