Search results

1 – 2 of 2
Open Access
Article
Publication date: 21 February 2022

Héctor Rubén Morales, Marcela Porporato and Nicolas Epelbaum

The technical feasibility of using Benford's law to assist internal auditors in reviewing the integrity of high-volume data sets is analysed. This study explores whether Benford's…

3284

Abstract

Purpose

The technical feasibility of using Benford's law to assist internal auditors in reviewing the integrity of high-volume data sets is analysed. This study explores whether Benford's distribution applies to the set of numbers represented by the quantity of records (size) that comprise the different tables that make up a state-owned enterprise's (SOE) enterprise resource planning (ERP) relational database. The use of Benford's law streamlines the search for possible abnormalities within the ERP system's data set, increasing the ability of the internal audit functions (IAFs) to detect anomalies within the database. In the SOEs of emerging economies, where groups compete for power and resources, internal auditors are better off employing analytical tests to discharge their duties without getting involved in power struggles.

Design/methodology/approach

Records of eight databases of an SOE in Argentina are used to analyse the number of records of each table in periods of three to 12 years. The case develops step-by-step Benford's law application to test each ERP module records using Chi-squared (χ²) and mean absolute deviation (MAD) goodness-of-fit tests.

Findings

Benford's law is an adequate tool for performing integrity tests of high-volume databases. A minimum of 350 tables within each database are required for the MAD test to be effective; this threshold is higher than the 67 reported by earlier researches. Robust results are obtained for the complete ERP system and for large modules; modules with less than 350 tables show low conformity with Benford's law.

Research limitations/implications

This study is not about detecting fraud; it aims to help internal auditors red flag databases that will need further attention, making the most out of available limited resources in SOEs. The contribution is a simple, cheap and useful quantitative tool that can be employed by internal auditors in emerging economies to perform the first scan of the data contained in relational databases.

Practical implications

This paper provides a tool to test whether large amounts of data behave as expected, and if not, they can be pinpointed for future investigation. It offers tests and explanations on the tool's application so that internal auditors of SOEs in emerging economies can use it, particularly those that face divergent expectations from antagonist powerful interest groups.

Originality/value

This study demonstrates that even in the context of limited information technology tools available for internal auditors, there are simple and inexpensive tests to review the integrity of high-volume databases. It also extends the literature on high-volume database integrity tests and our knowledge of the IAF in Civil law countries, particularly emerging economies in Latin America.

Details

Journal of Economics, Finance and Administrative Science, vol. 27 no. 53
Type: Research Article
ISSN: 2218-0648

Keywords

Article
Publication date: 1 January 1953

M. ROBERT‐HENRI BAUTIER

Avant‐propos sous les auspices de l'Institut international de Coopération intellectuelle, paraissait en 1934 le t. I, consacré à l'Europe, du Guide international des Archives. Le…

Abstract

Avant‐propos sous les auspices de l'Institut international de Coopération intellectuelle, paraissait en 1934 le t. I, consacré à l'Europe, du Guide international des Archives. Le questionnaire envoyé à tous les États européens comportait sous les points 4 et 6 les questions suivantes: ‘Existe‐t‐il un guide général pour les diverses catégories d'Archives ou des guides particuliers pour l'une ou l'autre d'entre elles?’ et ‘Existe‐t‐il des catalogues imprimés, des publications tant officielles que privées, susceptibles de constituer un instrument complet de référence pour tout ou partie importante des fonds d'archives?’ Les réponses des divers pays à ces questions, malgré leur caractère très inégal, ont fait du Guide international un bon instrument d'information générale sur les Archives. Malheureusement les circonstances ont empêché la publication du volume consacré aux États non européens, tandis que le temps qui s'écoulait tendait à rendre périmés les renseignements fournis sur les Archives européennes.

Details

Journal of Documentation, vol. 9 no. 1
Type: Research Article
ISSN: 0022-0418

1 – 2 of 2