Pengenalan ACL (Audit Command Language)

aclACL dikembangkan sejak tahun 1970-an oleh Prof. Hart J. Will dari Canada dan kemudian dikelola oleh ACL Services Ltd, Vancouver, Canada, dan merupakan pemimpin pasar dalam teknologi pengambilan data, analisis data, serta pelaporan (hasil survey tahunan The Institute of Internal Auditors, USA, 2005).

ACL telah dikembangluaskan dengan fungsi untuk memenuhi kebutuhan analisis data seluruh aktivitas bisnis operasional di dalam perusahaan, di antaranya pada bidang audit untuk analisis data, pencocokan dan pembandingan data, laporan penyimpangan, dsb; pada bidang IT (Information Technology) untuk data migration, data cleansing, data matching, data integrity testing; selain itu juga untuk analisis, konsolidasi, rekonsiliasi data, dan pelaporan pada divisi lain seperti Keuangan, Pemasaran, Distribusi, Operasional, dan lain sebagainya.





ACL dapat membaca data dari berbagai macam sistem yang terbentang mulai dari model sistem mainframe lama hingga ke relational database modern. ACL adalah aplikasi yang hanya ‘read-only’, ACL tidak pernah mengubah data sumber asli sehingga aman untuk menganalisis jenis live-data. Keanekaragaman sumber data dan teknologi akses data, cara mengakses data juga bervariasi dari satu sumber data ke lain. ACL membaca beberapa sumber data secara langsung dengan mengimpor dan menyalin sumber data sehingga dapat dianalisis. ACL dirancang khusus untuk menganalisa data dan menghasilkan laporan audit baik untuk pengguna biasa (common/nontechnical users) maupun pengguna ahli (expert users). Dengan menggunakan ACL, pekerjaan auditing akan jauh lebih cepat daripada proses auditing secara manual yang memerlukan waktu sampai berjam-jam bahkan sampai berhari-hari.

Software ini dapat melakukan akses data langsung ke dalam database ataupun dalam bentuk teks file dalam waktu yang singkat tanpa menganggu sistem yang sedang berjalan, melakukan proses verifikasi hasil dari data yang diperoleh untuk menciptakan integrasi data yang dipercaya, dan hasil analisa data yang dapat diandalkan. Semua dapat dilakukan dengan cepat, tepat, aman, dan akurat.




Manfaat ACL antara lain:




  • Bagi auditor: Penggunaan ACL akan membantu mereka dalam melaksanakan tugas audit secara lebih terfokus, cepat, efisien, efektif, dan murah dengan lingkup yang lebih luas dan analisis mendalam. Indikasi penyimpangan dapat dilakukan dengan cepat, akurat, dan dengan beraneka ragam analisis menggunakan ACL sehingga auditor dapat menemukan lebih banyak penyimpangandan memiliki lebih banyak waktu untuk melakukan pembuktian.






  • Untuk manajemen termasuk profesi akunting dan keuangan: ACL dapat membantu mereka dalam menganalisis data dan informasi perusahaan, pengujian pengendalian yang telah ada, dan pembuatan laporan manajemen secara cepat dan fleksibel






  • Untuk Sumber Daya Manusia/Pemeriksa, IT, dan lainnya: Dapat melakukan sistem pelaporan yang sesuai dengan keinginan atau laporan yang diinginkan (independensi) dengan akurasi dan kualitas data yang sangat bagus sehingga data pelaporan dapat dipercaya. Proses pembuatan rekapitulasi dengan sangat cepat.




Audit berbantuan komputer dengan menggunakan software Audit Command Language dimulai dari pendefinisian berbagai macam tipe data yang dapat dibaca oleh software ACL, analisa laporan keuangan perusahaan dimulai dari Neraca  beserta Rugi Laba ditelusuri ke Buku Besar dengan menggunakan fungsi yang terdapat pada software ACL, yaitu:  Verification, Count, Total, Age, Search, Sort, Index, Statistic, Profile, Summarize, Stratification, Sample, Export, Import, Extract, Relation, Joint, Merge, pembuatan laporan yang dihasilkan dari fungsi yang ada di software ACl, serta dilengkapi dengan pembuatan batch (meliputi tahapan pemeriksaan laporan keuangan yang dirangkum menjadi satu program.




Fitur dan kemampuan ACL Software Tools:



  1. Universal Data Access, yaitu dapat mengakses data dari hampir semua jenis database yang ada (DBF, XLS, Text File, report file, Oracle, SQL, DB2, AS/400 FDF, COBOL, dsb) dan semua platform (PC, minicomputer, dan mainframe).


  2. Jumlah Data Besar, yaitu kemampuan dalam mengakses dan memproses data dalam jumlah yang sangat besar (hingga ratusan juta record).


  3. Kecepatan Waktu Proses, kemampuannya untuk memproses dalam waktu yang singkat walaupun data yang diproses dalam jumlah yang besar.


  4. Integritas Data, dengan kemampuan mengakses database 100% (tanpa metode sampling) serta data yang bersifat Read Only yang dapat menjamin orisinalitas, keamanan dan integritas data untuk pengolahan menjadi informasi yang bermanfaat bagi user dan manajemen.


  5. Automasi, pembuatan aplikasi audit yang sangat cepat dan mudah untuk melakukan automasi analisis data untuk efisiensi proses kerja.


  6. Multi File Process, dapat digunakan untuk menangani beberapa file sekaligus, tanpa mengganggu operasional teknologi informasi yang dijalankan oleh perusahaan.


  7. Log File Navigation, dilengkapi dengan log file untuk pencatatan proses analisis yang telah dilakukan sehingga menghasilkan suatu audit trail yang komprehensif.


  8. Fungsi Analisis yang Lengkap, dilengkapi fungsi-fungsi analisis yang sangat lengkap yang dapat dengan mudah dikombinasikan dalam menghasilkan temuan-temuan yang tidak pernah terkirakan sebelumnya.


  9. Pelaporan yang Handal, kemudahan untuk merancang laporan yang handal sarat informasi yang bermanfaat serta dapat dikirimkan secara otomatis via email atau integrasi ke dalam software aplikasi Crystal Report.


  10. IT Audit, kemudahan dalam menguji integritas data dan menganalisis data yang ada di dalam database ataupun menganalisis user-user yang telah masuk ke dalam suatu jaringan/network.




Manfaat menggunakan ACL Software Tools:



  • Dapat membantu dalam mengAkses data baik langsung (Direct) kedalam system jaringan ataupun  tidak langsung (InDirect) melalui media lain seperti softcopy dalam bentuk teks file/report.


  • Menempatkan kesalahan dan potensial fraud sebagai pembanding dan menganalisa file-file menurut aturan-aturan yang ada.


  • Mengidentifikasi kecenderungan/gejala-gejala, dapat juga menunjukan dengan tepat/sasaran pengecualian data dan menyoroti potensial area yang menjadi perhatian.


  • Mengidentifikasi proses perhitungan kembali dan proses verifikasi yang benar.


  • Mengidentifikasi persoalan sistem pengawasan dan memastikan terpenuhinya permohonan dengan aturan-aturan yang telah ditetapkan.


  • Aging dan menganalisa Account Receivable/Payable atau beberapa transaksi lain dengan menggunakan basis waktu yang sensitif.


  • Memulihkan biaya atau pendapatan yang hilang dengan pengujian data pada data-data duplikasi pembayaran, menguji data-data nomor Invoice/Faktur yang hilang atau pelayanan yang tidak tertagih.


  • Menguji terhadap hubungan antara authorisasi karyawan dengan supplier.


  • Melakukan proses Data Cleansing dan Data Matching atau pembersihan data dari data-data duplikasi terutama dari kesalahan pengetikan oleh End-User.


  • Dapat melaksanakan tugas pengawasan dan pemeriksaaan dengan lebih fokus, cepat, efisien, dan efektif dengan lingkup yang lebih luas dan analisa lebih mendalam. Mengidentifikasi penyimpangan (Fraud Detection) dapat dilakukan dengan cepat dan akurat sehingga memiliki waktu lebih banyak alam menganalisa data dan pembuktian.




sumber: http://trisnadi169.blogspot.com/2011/07/pengenalan-acl.html

56 komentar:

  1. Agen s128 adalah situs sabung ayam online sebagai salah satu penyedia jasa
    judi sabung ayam, di indonesia.

    BalasHapus
  2. Really well written article! This blog was... how do you say it? Awesome! {I honestly think this might assist with the situation.
    You really deserve a big kiss right now.
    This site looks just like my old website.|This sure is a whole lot to try and take in and I'm not sure if I can really understand what you are trying to convey.|This really solved my question.
    I am super impressed with your writing skills.|Do you have you tube videos on the topic?|I was shopping for a real estate the other day but I still This stuff is like vitamins for my mind. And to think, I풀싸롱

    BalasHapus
  3. Greetings to each one, it’s really a particular for me to visit this website page, it comprises of helpful Information. 토토

    BalasHapus
  4. I every time spent my half an hour to read this weblog’s content every day along with a mug of coffee. racesite.pro
    racesite.info

    BalasHapus
  5. Ive got to say, the layout alone made me come back to this web page again. But now that Ive read what youve got to say, Ive got to share it with the world! oncasinosite.net

    BalasHapus
  6. I couldnt currently have asked for a much better blog. You happen to be ever present to give excellent tips, going right to the point for easy understanding of your visitors. Youre really a terrific specialist in this subject. Thanks a ton for always being there for folks like me. totopick.pro

    BalasHapus
  7. Great work! That is the type of information that are meant to be shared
    around the net. Shame on the seek engines for no longer positioning this publish upper!
    Come on over and discuss with my site . Thanks
    =)

    Here is my webpage; 카지노사이트

    BalasHapus
  8. Wonderful, what a weblog it is! This webpage gives valuable data to us, keep it up
    오피월드

    oworldsmewep

    BalasHapus
  9. Thank you for sharing your info. I really appreciate your
    efforts and I am waiting for your next write ups thanks once again.
    바카라사이트

    BalasHapus
  10. Excellent information on your blog, thank you for taking the time to share with us. Amazing insight you have on this, It's nice to find a website that details so much information about different artists.

    텍사스홀덤사이트

    BalasHapus
  11. I have read your writings and I have read articles on this topic in several articles from other sources. I got a lot of information from your writing, is there any other suggestions you can convey regarding the theme of your writing? so that I can get more and more complete information.

    I certainly thank you for writing this article well, hopefully it will become a reference in journals or other scientific writings and can help many people. thanks.

    Best Regards Gladies

    BalasHapus
  12. That's a really impressive new idea! casino api It touched me a lot. I would love to hear your opinion on my site. Please come to the site I run once and leave a comment. Thank you.

    BalasHapus
  13. The kind and easy-to-understand explanation made it easy to understand difficult topics. Your writing skills are great. I want to learn great writing skills. 슬롯머신

    BalasHapus
  14. Jika anda ingin mendownload software tersebut silakan klik link Slot deposit pulsa tanpa potongan yang kami sediakan download autocad bandicam full version yang telah dilengkapi dengan Situs slot deposit pulsa berbagai fitur yang dapat memudahkan anda untuk merekam berbagai kegiatan Slot deposit pulsa yang anda lakukan pada layar komputer anda

    BalasHapus
  15. Hi there, the whole thing is going well here and of course everyone is sharing information, that’s really fine, keep up writing. 온라인카지노

    BalasHapus
  16. I am so happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this greatest doc. 메이저토토

    BalasHapus
  17. Thanks for sharing beautiful content on your blog. I will always support you to do your best in everything.
    download igoal

    BalasHapus
  18. Hello there, You have performed an excellent job. I will definitely dig it and personally suggest to my friends. I’m confident they will be benefited from this web site. Feel free to visit my website;
    야설

    BalasHapus
  19. Hard to ignore such an amazing article like this. You really amazed me with your writing talent. Thank for you shared again. Feel free to visit my website; 한국야동

    BalasHapus

  20. I am always searching online for articles that can help me. There is obviously a lot to know about this. I think you made some good points in Features also. Keep working, great job ! Feel free to visit my website;
    국산야동

    BalasHapus
  21. Great write-up, I am a big believer in commenting on blogs to inform the blog writers know that they’ve added something worthwhile to the world wide web! Feel free to visit my website;
    일본야동

    BalasHapus
  22. This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post. Feel free to visit my website;
    일본야동

    BalasHapus
  23. I totally agree with what you said. Thank you for leaving comments. I think more people should see the comments you wrote. Can I attach your post to my blog? I think many people will agree with you. 메이저토토

    BalasHapus
  24. If you are looking for an author to write on your site, please contact me. I have some good posts that you might be interested in. I'm sure my post will be a good asset for me. If that's burdensome, can I quote your blog data on my blog? If you're interested, please send me an email. Thank you. 메이저토토

    BalasHapus
  25. Thank you for creating a creative blog. It's amazing how you can write in such a creative way. Have you thought about another topic to post? I'm just working on a topic like that. I hope my blog helps you. 메이저토토사이트

    BalasHapus
  26. I am a 슬롯사이트 expert. I've read a lot of articles, but I'm the first person to understand as well as you. I leave a post for the first time. It's great!!

    BalasHapus
  27. Just desire to say your article is as surprising. The clearness on your publish is
    simply spectacular and that i can assume you're knowledgeable on this subject.
    메이저사이트
    온라인경마

    BalasHapus
  28. A lot more peoople must read his and understand this siode of thhe story.
    I was surprised that you're not more popular since you definitely possess the gift.
    majortotosite
    racesite
    oncasinosite
    totopick

    BalasHapus
  29. I was impressed by your writing. Your writing is impressive. I want to write like you. 토토사이트링크

    BalasHapus
  30. That's a really impressive new idea! 안전한놀이터 It touched me a lot. I would love to hear your opinion on my site. Please come to the site I run once and leave a comment. Thank you.

    BalasHapus
  31. Nicee..This is a great post with great information. Bookmarked your blog. We hope you will continue to post these good information frequently. 룰렛사이트탑

    BalasHapus
  32. We are looking for a lot of data on this item. In the meantime, this is the perfect article I was looking for . Please post a lot about items related to 메이저사이트추천 !!! I am waiting for your article. And when you are having difficulty writing articles, I think you can get a lot of help by visiting my .

    BalasHapus
  33. It's the same topic, but I was surprised that it was so different from my opinion. I hope you feel the same after seeing the writings I have written. 안전놀이터

    BalasHapus
  34. Traditional bookstores have always existed on high streets, but in the digital age, the internet is proving to become a serious competitor to traditional brick and mortar stores. This article examines both sides of the coin and provides an appropriate insight into the phenomenon of shopping of books online. 메이저사이트추천

    BalasHapus
  35. It's the same topic , but I was quite surprised to see the opinions I didn't think of. My blog also has articles on these topics, so I look forward to your visit. bitcoincasino

    BalasHapus
  36. Thank you for some other informative blog. Keep on writing man, you're awesome!
    온라인카지노
    바카라사이트
    카지노사이트
    온라인카지노

    BalasHapus
  37. You have a very good gloss. Write more high-quality articles.
    카지노사이트가이드

    BalasHapus
  38. Great job for publishing such a beneficial web site
    온라인카지노

    BalasHapus
  39. Thank you for providing a good quality article.
    바카라사이트

    BalasHapus
  40. I do agree with all of the ideas you’ve presented in your post.
    카지노사이트

    BalasHapus
  41. I’m now not positive the place you are getting your info, however great topic.
    홀덤

    BalasHapus
  42. Here we provide you with the information and resources you need to write better articles. Come here and write more advanced text.
    슬롯머신

    BalasHapus
  43. I enjoy reading all of your post. I wanted to write a little comment to support you.
    바카라사이트

    BalasHapus
  44. Great blog here! Plus, your website has good reviews.123bet vip

    BalasHapus
  45. I simply wish to give you a huge thumbs up for your excellent info you’ve got right here on this post. I am coming back to your site for more soon.
    온라인카지노

    BalasHapus
  46. This website certainly has all of the information and facts I needed concerning this subject and didn’t know who to ask.
    온라인카지노

    BalasHapus
  47. Quality articles or reviews is the important to interest the people to pay a quick visit the website, that’s what this site is providing.
    릴게임

    BalasHapus
  48. I am always searching online for posts that can help me. watching forward to another great blog. 카지노사이트

    BalasHapus
  49. Hello, after reading this amazing post i am too glad to share my experience here with mates.바카라사이트

    BalasHapus
  50. I read your post carefully and found something new. Thank you for this post. 파워볼

    BalasHapus
  51. I extremely appreciate you for imparting such sort of information to us, Please keep offering such kind of decent content! 토토사이트

    BalasHapus

Diberdayakan oleh Blogger.