Development of an Approach to Automate Performance Evaluation of Bank Staff by Internal Audit Using Excel Program

Abstract

Banks perform activities affecting directly the society; this requires theimposition of an efficient, effective and sustainable control on its activities.Control imposition relies basically on the internal control department. Internalauditing is an independent, objective assurance and consulting activity that addsvalue and improves an economic unit’s operations. This paper aims at sheddinglight on contemporary developments taking place in the internal audit, withproposing an approach calls for making use of general application program suchas Microsoft Excel in monitoring and evaluating the performance, and as a steptowards applying Computer Auditing Assisting Techniques (CAATs).Conclusions of most importance are: (1) Microsoft Excel can be used as apreliminary step to adopt (CAATs), by utilizing the program’s functions in theaccumulation and analysis of audit data, documentation of results. (2) Sortingand classifying errors according to their risk impact into serious, influential, andsmall, translating these classes to values, makes the evaluation more objective.(3) The evaluation is characterized by its efficiency and effectiveness. (4) Usingthe approach helps to direct management and audit committee attention towardproviding assurances about controls.