IDEAS home Printed from https://ideas.repec.org/a/ami/journl/v19y2020i2p379-404.html
   My bibliography  Save this article

Implementing Benford’s Law in Continuous Monitoring Applications

Author

Listed:
  • Kishore Singh
  • Peter Best

    (Central Queensland University, Australia)

Abstract

Research Question: Do modern ERP systems record sufficient information to allow retrospective monitoring of accounts payable transactions? Can Benford’s Law be applied to these transactions to detect potential fraud in accounting data? Motivation: Modern ERP systems are capable of recording several thousands of transactions daily. This makes it difficult to find a few instances of anomalous activities among legitimate transactions. As organizations continue to become more complex and demand more integrated business processes, automated analytics may provide auditors and fraud examiners some degree of assurance on continuous information simultaneously with, or shortly after disclosure of information. Idea: In this study we develop a proof of concept prototype to monitor invoice transactions and identify those that violate Benford’s law. The prototype exploits audit trails in enterprise systems. Data: Data was obtained from the SAP ERP systems of two large organizations. Organization 1, a government department, provided a one month sample of accounting transaction data. Organization 2, a global manufacturing company, provided a six month sample of their transaction data. Tools: Verification and validation was achieved by obtaining independent reviews from an expert and a panel of auditing practitioners. Their feedback was sought using a survey instrument where they rated various aspects of the prototype software. Findings: A key aim was to demonstrate the feasibility of implementing Benford’s analysis in continuous monitoring applications by exploiting audit trails in ERP systems. The concept was demonstrated by designing prototype software. We found that Benford’s analysis, is a useful tool for identifying suspicious transactions. These transactions may contain possible errors, potential fraud or other irregularities. Contribution: An important contribution of the study is that the entire population of transactions for a specified time period are analyzed. This approach is in contrast with the traditional or manual audit approach which is limited because it reviews only a small percentage of a large population of transactions. The prototype demonstrates the application of technology and data analytics to process transaction data from a SAP ERP system in a near real-time basis. This represents the next step in the evolution of the financial audit from manual to automated methods.

Suggested Citation

  • Kishore Singh & Peter Best, 2020. "Implementing Benford’s Law in Continuous Monitoring Applications," Journal of Accounting and Management Information Systems, Faculty of Accounting and Management Information Systems, The Bucharest University of Economic Studies, vol. 19(2), pages 379-404, June.
    • Handle: RePEc:ami:journl:v:19:y:2020:i:2:p:379-404
    as

    Download full text from publisher

    File URL: http://online-cig.ase.ro/RePEc/ami/articles/19_2_8.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Vasarhelyi, Miklos A. & Alles, Michael & Kuenkaikaew, Siripan & Littley, James, 2012. "The acceptance and adoption of continuous auditing by internal auditors: A micro analysis," International Journal of Accounting Information Systems, Elsevier, vol. 13(3), pages 267-281.
    2. Tam Cho, Wendy K. & Gaines, Brian J., 2007. "Breaking the (Benford) Law: Statistical Fraud Detection in Campaign Finance," The American Statistician, American Statistical Association, vol. 61, pages 218-223, August.
    3. Sinisa Slijepcevic & Branimir Blaskovic, 2014. "Statistical detection of fraud in the reporting of Croatian public companies," Financial Theory and Practice, Institute of Public Finance, vol. 38(1), pages 81-96.
    4. Adrian Cojocariu & Alin Munteanu & Ofelia Sofran, 2005. "Verification, Validation and Evaluation of Expert Systems in Order to Develop a Safe Support in the Process of Decision Making," Computational Economics 0510002, University Library of Munich, Germany.
    5. Debreceny, Roger S. & Gray, Glen L., 2010. "Data mining journal entries for fraud detection: An exploratory study," International Journal of Accounting Information Systems, Elsevier, vol. 11(3), pages 157-181.
    6. Scott Marchi & James Hamilton, 2006. "Assessing the Accuracy of Self-Reported Data: an Evaluation of the Toxics Release Inventory," Journal of Risk and Uncertainty, Springer, vol. 32(1), pages 57-76, January.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Amani, Farzaneh A. & Fadlalla, Adam M., 2017. "Data mining applications in accounting: A review of the literature and organizing framework," International Journal of Accounting Information Systems, Elsevier, vol. 24(C), pages 32-58.
    2. Montag, Josef, 2017. "Identifying odometer fraud in used car market data," Transport Policy, Elsevier, vol. 60(C), pages 10-23.
    3. Lee, Kang-Bok & Han, Sumin & Jeong, Yeasung, 2020. "COVID-19, flattening the curve, and Benford’s law," Physica A: Statistical Mechanics and its Applications, Elsevier, vol. 559(C).
    4. Montag, Josef, 2015. "Identifying Odometer Fraud: Evidence from the Used Car Market in the Czech Republic," MPRA Paper 65182, University Library of Munich, Germany.
    5. Fábio Albuquerque & Paula Gomes Dos Santos, 2023. "Recent Trends in Accounting and Information System Research: A Literature Review Using Textual Analysis Tools," FinTech, MDPI, vol. 2(2), pages 1-27, April.
    6. Matthew A. Cole & David J. Maddison & Liyun Zhang, 2020. "Testing the emission reduction claims of CDM projects using the Benford’s Law," Climatic Change, Springer, vol. 160(3), pages 407-426, June.
    7. Vadim S. Balashov & Yuxing Yan & Xiaodi Zhu, 2020. "Who Manipulates Data During Pandemics? Evidence from Newcomb-Benford Law," Papers 2007.14841, arXiv.org, revised Jan 2021.
    8. John Morrow, 2014. "Benford's Law, Families of Distributions and a Test Basis," CEP Discussion Papers dp1291, Centre for Economic Performance, LSE.
    9. Martin Quinn & Peter Cleary & Catherine Batt & Pall Rikhardsson, 2021. "Accounting and Information Systems in Irish Family SME: Professionalisation Effects," Journal of Accounting and Management Information Systems, Faculty of Accounting and Management Information Systems, The Bucharest University of Economic Studies, vol. 20(3), pages 454-476, September.
    10. Yoon, Kyunghee & Liu, Yue & Chiu, Tiffany & Vasarhelyi, Miklos A., 2021. "Design and evaluation of an advanced continuous data level auditing system: A three-layer structure," International Journal of Accounting Information Systems, Elsevier, vol. 42(C).
    11. Marco Schreyer & Timur Sattarov & Christian Schulze & Bernd Reimer & Damian Borth, 2019. "Detection of Accounting Anomalies in the Latent Space using Adversarial Autoencoder Neural Networks," Papers 1908.00734, arXiv.org.
    12. Ronelle Burger & Canh Thien Dang & Trudy Owens, 2017. "Better performing NGOs do report more accurately: Evidence from investigating Ugandan NGO financial accounts," Discussion Papers 2017-10, University of Nottingham, CREDIT.
    13. Roy Cerqueti & Claudio Lupi, 2023. "Severe testing of Benford’s law," TEST: An Official Journal of the Spanish Society of Statistics and Operations Research, Springer;Sociedad de Estadística e Investigación Operativa, vol. 32(2), pages 677-694, June.
    14. Stefan Günnel & Karl-Heinz Tödter, 2009. "Does Benford’s Law hold in economic research and forecasting?," Empirica, Springer;Austrian Institute for Economic Research;Austrian Economic Association, vol. 36(3), pages 273-292, August.
    15. Dang, Canh Thien & Owens, Trudy, 2020. "Does transparency come at the cost of charitable services? Evidence from investigating British charities," Journal of Economic Behavior & Organization, Elsevier, vol. 172(C), pages 314-343.
    16. Janet Currie, 2011. "Ungleichheiten bei der Geburt: Einige Ursachen und Folgen," Perspektiven der Wirtschaftspolitik, Verein für Socialpolitik, vol. 12(s1), pages 42-65, May.
    17. Wang, Delu & Chen, Fan & Mao, Jinqi & Liu, Nannan & Rong, Fangyu, 2022. "Are the official national data credible? Empirical evidence from statistics quality evaluation of China's coal and its downstream industries," Energy Economics, Elsevier, vol. 114(C).
    18. Long, Michael A. & Lynch, Michael J. & Stretesky, Paul B., 2018. "The Great Recession, the Treadmill of Production and Ecological Disorganization: Did the Recession Decrease Toxic Releases Across US States, 2005–2014?," Ecological Economics, Elsevier, vol. 146(C), pages 184-192.
    19. Slamet Soedarsono & Sri Mulyani & Hiro Tugiman & Didik Suhardi, 2019. "Information Quality and Management Support as Key Factors in the Applications of Continuous Auditing and Continuous Monitoring: An Empirical Study in the Government Sector of Indonesia," Contemporary Economics, University of Economics and Human Sciences in Warsaw., vol. 13(3), September.
    20. Grendar, Marian & Judge, George & Schechter, Laura, 2007. "An empirical non-parametric likelihood family of data-based Benford-like distributions," Physica A: Statistical Mechanics and its Applications, Elsevier, vol. 380(C), pages 429-438.

    More about this item

    Keywords

    Benfords Law; fraud; accounts payable; SAP audit trail analysis; internal audit;
    All these keywords.

    JEL classification:

    • M41 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Accounting - - - Accounting
    • M42 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Accounting - - - Auditing

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:ami:journl:v:19:y:2020:i:2:p:379-404. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Cristina Tartavulea (email available below). General contact details of provider: .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.