Audit Command Language (ACL) Analytics: A Practical Guide for Beginners

2020 ◽  
Author(s):  
Haslinda Hassan ◽  
Raja Haslinda Raja Mohd Ali ◽  
Nurulhuda Ghazali
Keyword(s):  
Information Technology ◽  
User Interfaces ◽  
Accounting Information ◽  
Command Language ◽  
Accounting Information Systems ◽  
Integrity Verification ◽  
Advantages And Disadvantages ◽  
It Audit ◽  
The Relationship

Tired of performing an audit manually? This module provides a useful step-by-step approach to perform an audit using ACL. Easy to understand and follow. No such module in the market so far. This module is designed to assist users on how to use ACL as a powerful tool to audit. The module is divided into 8 Chapters. Chapter 1 introduces audit and information technology (IT) audit, audit assertions, audit procedures, and the relationship between audit assertions and audit procedures. Chapter 2 explains ACL in the audit, describing in brief its advantages and disadvantages. Chapter 3 assists users with using ACL. In this chapter, users will learn how to install ACL (version 9), and get familiar with the ACL menus and user interfaces. This module uses a step-by-step approach to guide users from creating a new project from ACL to viewing and modifying the table in ACL. Chapter 4 elaborates how to use ACL commands for data integrity verification. For this purpose, users will learn how to count records, total numeric fields or expression, and check for validity errors. Chapter 5 shows users how to analyse their data using the ACL command. The analyse include statistics, stratify, classify, examine the sequence, check for gaps, check for duplicates, ageing, and summarise commands. The remaining chapters cover three main accounting information systems (AIS) cycles, namely, sales and cash receipts (Chapter 6), purchase and cash payments (Chapter 7), and human resource (Chapter 8). For each cycle, cases are given for better assimilation.

scholarly journals IT General Controls Testing: Assessing the Effectiveness of User Access Management

2019 ◽  
Vol 14 (1) ◽  
pp. 15-34 ◽  
Author(s):  
Lorraine Lee ◽  
Rebecca Sawyer
Keyword(s):  
Information Technology ◽  
Information Systems ◽  
Accounting Information ◽  
Access Management ◽  
Graduate Level ◽  
General Control ◽  
Accounting Information Systems ◽  
User Access ◽  
It Audit

ABSTRACT The verification of Information Technology (IT) controls is a core responsibility of IT auditors. This case places the student in the role of an IT auditor assigned to test the operating effectiveness of a specific IT general control: user access management. In addition to learning about IT controls, the case introduces several Excel functions such as VLOOKUP, MATCH, INDEX, and various text functions. The student documents the results of the IT controls tests by completing a testing matrix and writing a memo. General controls, user access management, and Excel applications are all topics taught in Accounting Information Systems (AIS) and Audit courses. As such, instructors can use this case at the undergraduate or graduate level in an IT Audit, Accounting Information Systems, or Audit class.

scholarly journals Measuring AIS Course Outcomes: The Relationship Between Knowledge/Skills and Interest/Enjoyment

2010 ◽  
Vol 5 (1) ◽  
pp. 47-69 ◽  
Author(s):  
Grover S. Kearns
Keyword(s):  
Information Technology ◽  
Career Paths ◽  
Accounting Information ◽  
Two Dimensions ◽  
Accounting Information Systems ◽  
Knowledge And Skills ◽  
Number Of Factors ◽  
Course Outcomes ◽  
The Relationship

Information technology (IT) has become increasingly important to accounting professionals. Education in relevant IT-related topics, however, appears to have lagged workplace demands. Most undergraduate accounting programs require an Accounting Information Systems (AIS) course to fulfill the major program requirements. Because this course is often the only one to address AIS topics, students may tend to view IT as being less important to their career paths. Such attitudes may reduce the quality of course outcomes. A survey of 103 undergraduate AIS students was conducted to assess attitudes along two dimensions: knowledge and skills and interest and enjoyment. Results showed that, for a number of factors, interest and enjoyment was positively associated with knowledge and skills. The level of the two dimensions, however, varied, and students displayed greater interest in traditional accounting than in technology-related courses. Most importantly, attitude towards IT affected success.

scholarly journals The Relationship between Accounting Information Systems and Making Investment Decisions in the Industrial Companies Listed in the Saudi Stock Market

2017 ◽  
Vol 10 (6) ◽  
pp. 199 ◽  
Author(s):  
Qasim Alawaqleh ◽  
Mahmoud Al-Sohaimat
Keyword(s):  
Decision Making ◽  
Information Systems ◽  
Investment Decision ◽  
Accounting Information ◽  
Kingdom Of Saudi Arabia ◽  
Policy Makers ◽  
Accounting Information Systems ◽  
Industrial Companies ◽  
Investment Decision Making ◽  
The Relationship

The study aimed to measure the relationship between the investment decision-making in the industrial companies listed in the Saudi Stock Market with the (IVs) characteristics of the accounting information systems (appropriateness and reliability, comparability and understanding), and renovation and maintenance of the hardware and software. The problem in the Kingdom of Saudi Arabia is that the government depends on oil revenues more than on attracting investments, therefore, the importance of this study is constituted by the provision of critical recommendations to policy makers in the Kingdom of Saudi Arabia in order to overcome this issue and improve the investments. In order to achieve the objectives of this study, questionnaires were administered to 194 people representing the study population; a multiple regression (standard regression) was also used to test the study hypotheses. In general, all variables were positively significantly related with the investment decision-making.The findings of this study also showed that the independent variables explained more than 65% of the variance in investment decision-making. The Saudi government and policy makers should issue new regulations to increase the interest in accounting information systems in order to attract the investment. In relation to the practical and theoretical contribution, this study used new variables in the new model, such as renovation and maintenance of the hardware and software. Furthermore, practical contribution will help policy makers and the Saudi government to advance in this area and implement new policies for investors in order to protect the economy and the society stability due to the war in Yemen and Syria.

Designing Accounting Information Systems for Primary Cash Receipts and Expenditures in Open ERP-based Retail Units (ODOO)

2021 ◽  
Vol 4 (2) ◽  
pp. 199-208
Author(s):  
Ivana Larasati Putri Navalina ◽  
Ludfi Djajanto ◽  
Ari Kamayanti
Keyword(s):  
Information Technology ◽  
Information Systems ◽  
Customer Satisfaction ◽  
Accounting Information ◽  
Industrial Technology ◽  
Accounting Information Systems ◽  
Business People ◽  
Technology Revolution ◽  
Over Time

Over time, this type of cooperative business slowly begins to lose its existencedue to increasingly fierce business competition. This is because the role ofcooperatives, which is identical to the provision of basic foodstuffs for theneeds of the community, has now been taken over by the existence ofsupermarkets both in cities and in the regions. This is due to the influence ofthe industrial technology revolution 4.0 which requires business people tocontinue to be able to improve services and offer technology-basedconvenience so that it has an impact on customer satisfaction. This literaturereview aims to describe the role of the use of information technology systemsfor accounting for primary cash receipts and disbursements in cooperatives.

scholarly journals Pengaruh Komitmen Manajemen, Kemampuan Teknik Personal Dan Information Technology Sophistication Pada Kinerja Sistem Informasi Akuntansi

2019 ◽  
pp. 694
Author(s):  
Luh Gede Ira Pratiwi Swara ◽  
Ni Luh Sari Widhiyani
Keyword(s):  
Information Technology ◽  
Information Systems ◽  
Linear Regression Analysis ◽  
Accounting Information ◽  
Multiple Linear Regression Analysis ◽  
Entire Study ◽  
Accounting Information Systems ◽  
Technical Ability ◽  
Management Commitment ◽  
Sample Technique

This study aims to empirically the effect of management commitment, personal technical skills and information technology sophistication on the performance of accounting information systems in rural banks in Badung Regency. The population of this study was 52 rural banks in Badung Regency. Sampling used saturated sample technique or census, where the entire study population will used samples, so that the samples used as many as 52 BPR. Respondents in this study then selected 3 people in each BPR. Data analysis technique used multiple linear regression analysis. The results show that: 1) management commitment has positive and significant effect on the performance of BPR accounting information systems in Badung Regency, 2) personal engineering skills have positive and significant effect on the performance of BPR accounting information systems in Badung Regency and 3) information technology sophistication positive and significant effect on the performance of the BPR accounting information system in Badung Regency. Keywords: Management commitment, personal technical ability, IT sophistication, SIA performance.

The Impact Of Information Technology On Performance: The Mediating Role Of Management Accounting Systems

2012 ◽  
Author(s):  
Noor Azizi Ismail
Keyword(s):  
Information Technology ◽  
Information Systems ◽  
Firm Performance ◽  
Management Accounting ◽  
Accounting Information ◽  
Accounting Systems ◽  
Mediating Role ◽  
Management Accounting Systems ◽  
The Impact ◽  
The Relationship

Kertas kerja ini melaporkan hasil kajian yang menerangkan hubungan antara kecanggihan Teknologi Maklumat (IT) dan prestasi firma yang bersaiz kecil dan sederhana (SMEs), dengan memasukkan ke dalam model kajian, keupayaan sistem perakaunan pengurusan untuk menghasilkan maklumat perakaunan pengurusan (kapasiti MAS). Bagi menguji hubungan tersebut, data telah dikumpul daripada 310 firma menggunakan kaedah soal selidik. Hasil ujian menunjukkan bahawa kecanggihan IT merupakan penentu kepada kapasiti MAS, sementara kapasiti MAS pula akan menentukan prestasi firma. Dalam kata lain, kapasiti MAS memainkan peranan sebagai penghubung antara kecanggihan IT dengan prestasi firma. Interpretasi hasil ujian ini ialah firma yang menggunakan IT yang lebih canggih akan dapat menghasilkan maklumat perakaunan pengurusan yang mencukupi dan seterusnya dapat meningkatkan prestasi firma. Kata kunci: Teknologi Maklumat, sistem maklumat, sistem perakaunan pengurusan, sistem maklumat perakaunan, industri kecil dan sederhana This paper reports the results of a study which offers an explanation for the relationship between Information Technology (IT) sophistication and performance of small and medium sized enterprises (SMEs), by incorporating into the model of the capability of management accounting systems to generate management accounting information (MAS capacity). To assess the relationship, data were collected from 310 (25% response rate) SMEs by way of questionnaire surveys. The results indicate that IT sophistication is a determinant of MAS capacity, which, in turn, is a determinant of firm performance. In other words, MAS capacity plays a mediating role in the relationship between IT sophistication and firm performance. An interpretation of the results is that those firms that employed sophisticated IT can generate sufficient management accounting information and thereby improve performance. Key words: Information Technology, information systems, management accounting system, accounting information systems, small and medium enterprises

scholarly journals Pengaruh Efektivitas SIA, Kecanggihan Teknologi Informasi, dan Kemampuan Teknik Pemakai SIA pada Kinerja Individu

2019 ◽  
pp. 1735
Author(s):  
Luh Putu Radhakrishnan Dewi ◽  
Ida Bagus Dharmadiaksa
Keyword(s):  
Information Technology ◽  
Information Systems ◽  
Linear Regression Analysis ◽  
Accounting Information ◽  
Multiple Linear Regression Analysis ◽  
Individual Performance ◽  
Accounting Information Systems ◽  
Technical Ability ◽  
Analysis Technique ◽  
Saturated Sample

The purpose of this study is to obtain empirical evidence regarding the effect of the effectiveness of accounting information systems, the sophistication of information technology, and the technical ability users of accounting information systems of individual performance. This research was conducted on 27 BPR in Gianyar Regency. The number of samples taken is 108 respondents with the method of determining the sample, namely the saturated sample method. Data collection is done by distributing questionnaires, documentation and interviews. The data analysis technique used is multiple linear regression analysis techniques. The results of this study indicate that the effectiveness of accounting information systems, the sophistication of information technology, and the technical ability users of accounting information systems have a positive effect of individual performance. Keywords: Effectiveness AIS, sophistication IT, technical ability users AIS, individual performance.

scholarly journals PENGARUH KECANGGIHAN TEKNOLOGI INFORMASI DAN KEMAMPUAN TEKNIK PERSONAL TERHADAP EFEKTIVITAS PENGGUNAAN SISTEM INFORMASI AKUNTANSI DI LPD KECAMATAN UBUD

2020 ◽  
Vol 2 (1) ◽  
pp. 1-15
Author(s):  
Ni Made Kansa Dewi Putri ◽  
Ni Luh Putri Srinadi
Keyword(s):  
Information Technology ◽  
Information System ◽  
Information Systems ◽  
Linear Regression Analysis ◽  
Accounting Information ◽  
Multiple Linear Regression Analysis ◽  
Validity And Reliability ◽  
Accounting Information System ◽  
Accounting Information Systems ◽  
Library Research

The application of an accounting information system is an important investment for a company. The use of information systems can improve the competitiveness of companies so as not excluded in their environment. This research was conducted in LPD Sub-district of Ubud. The purpose of this study is to analyze the influence of the sophistication of information technology and the ability of personal techniques on the effective use of accounting information systems. Researchers use Multiple Linear Regression Analysis as a method of data analysis, where data collection is done by observation, interviews, library research, and questionnaires. As an initial stage of the analysis will be tested for validity and reliability of the research instrument. The results showed that the sophistication of Information Technology and Personal Engineering Capabilities had a positive and significant effect on the Effectiveness of the Use of Accounting Information Systems in LPD, Ubud Gianyar District. This research will recommend the formulation of a technology-based accounting information system so that it can compete in the midst of the tight and competitive world of competition.

Sign in / Sign up

Export Citation Format

Share Document