Leveraging Enterprise Resource Planning, Data Mining, and Data Warehousing for Financial Statement Fraud Detection

Blasius Erik Sibarani, Rizki Oktavianto

Abstract


Financial statement fraud remains a significant concern for companies and stakeholders because it undermines the reliability of financial reporting and damages corporate reputation. Although fraudulent practices may provide short-term benefits, they ultimately erode investor confidence and reduce stakeholder trust. Therefore, effective mechanisms are required to assist auditors in detecting potential fraud in financial reports. Advances in digital information systems offer new opportunities to strengthen fraud detection in the auditing process. In particular, Enterprise Resource Planning (ERP) systems provide integrated organizational data that can help auditors trace transactions and identify irregularities during financial reporting. In addition, data mining techniques enable auditors to analyze large volumes of financial data to uncover hidden patterns, anomalies, and potential fraudulent activities. Data warehouses further support this process by consolidating and organizing data from multiple sources to facilitate comprehensive analysis. This article provides an overview of how ERP systems, data mining, and data warehousing can be utilized as technological tools to enhance the detection of fraudulent schemes in corporate financial reporting.

Full Text:

PDF

References


ACFE. (2016). Report To the Nations on Occupational Fraud and Abuse: 2016 Global Fraud Study. Association of Certified Fraud Examiners, pp. 1–92. Available at: https://s3-us-west-2.amazonaws.com/acfepublic/2016-report-to-the-nations.pdf.

Albizri, A., Appelbaum, D. & Rizzotto, N. (2019) 'Evaluation of financial statements fraud detection research: a multi-disciplinary analysis', International Journal of Disclosure and Governance. Palgrave Macmillan UK. doi:10.1057/s41310-019-00067-9.

Albrecht, W. S., Albrecht, C., & Albrecht, C. C. (2008). Current trends in fraud and its detection. Information Security Journal: a global perspective, 17(1), 2-12. https://doi.org/10.1080/19393550801934331

Al-Okaily, A., Al-Okaily, M., Teoh, A. P., & Al-Debei, M. M. (2023). An empirical study on data warehouse systems effectiveness: the case of Jordanian banks in the business intelligence era. EuroMed Journal of Business, 18(4), 489-510. https://doi.org/10.1108/EMJB-01-2022-0011

Arboleda, F. J. M., Guzman-Luna, J. A., & Torres, I. D. (2018). Fraud detection-oriented operators in a data warehouse based on forensic accounting techniques. Computer Fraud & Security, 2018(10), 13–19. https://doi.org/10.1016/S1361-3723(18)30098-8.

Arora, R., Pahwa, P., & Gupta, D. (2017). Data quality improvement in data warehouse: a framework. International Journal of Data Analysis Techniques and Strategies, 9(1), 17-33. https://doi.org/10.1504/IJDATS.2017.083062

Bimonte, S., Antonelli, L., & Rizzi, S. (2021). Requirements-driven data warehouse design based on enhanced pivot tables. Requirements Engineering, 26(1), 43-65. https://doi.org/10.1007/s00766-020-00331-3

Byrne, S., & Pierce, B. (2007). Towards a More Comprehensive Understanding of the Roles of Management Accountants. European Accounting Review, 16(3), 469–498. https://doi.org/10.1080/09638180701507114

Carlsson‐Wall, M., Goretzki, L., Hofstedt, J., Kraus, K., & Nilsson, C. J. (2022). Exploring the implications of cloud‐based enterprise resource planning systems for public sector management accountants. Financial accountability & management, 38(2), 177-201. https://doi.org/10.1111/faam.12300

Chakraborty, S., Islam, S. H., & Samanta, D. (2022). Introduction to data mining and knowledge discovery. In Data Classification and Incremental Clustering in Data Mining and Machine Learning (pp. 1-22). Cham: Springer International Publishing. https://doi.org/10.1007/978-3-030-93088-2_1

Costa, C. J., Ferreira, E., Bento, F., & Aparicio, M. (2016). Enterprise resource planning adoption and satisfaction determinants. Computers in Human Behavior, 63, 659-671. https://doi.org/10.1016/j.chb.2016.05.090.

Debreceny, R. S., & Gray, G. L. (2010). Data mining journal entries for fraud detection: An exploratory study. International Journal of Accounting Information Systems, 11(3), 157–181. https://doi.org/10.1016/j.accinf.2010.08.001.

DeLone, W. H., & McLean, E. R. (2003). The DeLone and McLean model of information systems success: a ten-year update. Journal of management information systems, 19(4), 9-30. https://doi.org/10.1080/07421222.2003.11045748

Eggert, M., & Alberts, J. (2020). Frontiers of business intelligence and analytics 3.0: a taxonomy-based literature review and research agenda. Business Research, 13(2), 685-739. https://doi.org/10.1007/s40685-020-00108-y

Faccia, A., & Petratos, P. (2021). Blockchain, enterprise resource planning (ERP) and accounting information systems (AIS): Research on e-procurement and system integration. Applied Sciences, 11(15), 6792. https://doi.org/10.3390/app11156792

Geisler, S., Quix, C., Koren, I., & Jarke, M. (2025). Conceptual modeling of user perspectives–From data warehouses to alliance-driven data ecosystems. Data & Knowledge Engineering, 102502. https://doi.org/10.1016/j.datak.2025.102502

Gray, G. L., & Debreceny, R. S. (2014). A taxonomy to guide research on the application of data mining to fraud detection in financial statement audits. International Journal of Accounting Information Systems, 15(4), 357–380. https://doi.org/10.1016/j.accinf.2014.05.006.

Gupta, H., & Mumick, I. S. (2005). Selection of views to materialize in a data warehouse. IEEE Transactions on Knowledge and Data Engineering, 17(1), 24-43. https://doi.org/10.1109/TKDE.2005.16

Halim, S., Mubarokah, I., & Hidayanto, A. N. (2020, November). Rank critical success factors (CSFs) of data warehouse and business intelligence (DW/BI) implementation in banking sector using analytical hierarchy process (AHP). In 2020 International Conference on Informatics, Multimedia, Cyber and Information System (ICIMCIS) (pp. 313-318). IEEE. https://doi.org/10.1109/ICIMCIS51567.2020.9354331

Han, J. & Kamber, M. (2006). Data Mining: Concepts and Techniques. 2nd Edition, Morgan Kaufmann Publishers, San Francisco.

Han, J., Pei, J., & Tong, H. (2022). Data mining: concepts and techniques. Morgan kaufmann.

Handoko, B. L., & Nabila, N. N. (2020). Enterprise resources planning for application control in revenue and expenditure. Test Engineering and Management, 83(5-6), 10743-10749.

Ikbal, M., Irwansyah, I., Paminto, A., Ulfah, Y., & Darma, D. C. (2020). Financial intelligence: Financial statement fraud in Indonesia. Journal of Intelligence Studies in Business, 10(3).

Jawad, Z. N., & Balázs, V. (2024). Machine learning-driven optimization of enterprise resource planning (ERP) systems: a comprehensive review. Beni-Suef University Journal of Basic and Applied Sciences, 13(1), 4. https://doi.org/10.1186/s43088-023-00460-y

Khan, S., & Shaheen, M. (2023). From data mining to wisdom mining. Journal of Information Science, 49(4), 952-975. https://doi.org/10.1177/01655515211030872

Kothari, C. R. (2004) Research Methodology - Methods & Techniques. New Delhi: New Age International.

Kroll. (2017). Global Fraud & Risk Report Building Resilience in a Volatile World. Annual Edition. Accessed 2025

List, B., Bruckner, R. M., Machaczek, K., & Schiefer, J. (2002). A comparison of data warehouse development methodologies case study of the process warehouse. In International conference on database and expert systems applications (pp. 203-215). Berlin, Heidelberg: Springer Berlin Heidelberg. https://doi.org/10.1007/3-540-46146-9_21

Morris, J. J. (2011). The impact of enterprise resource planning (ERP) systems on the effectiveness of internal controls over financial reporting. Journal of Information Systems, 25(1), 129–157. https://doi.org/10.2308/jis.2011.25.1.129.

Neuman, W. L. (2011) Social Research Methods: Qualitative and Quantitative Approaches, Pearson Education.

Perols, J. L., & Lougee, B. A. (2011). The relation between earnings management and financial statement fraud. Advances in Accounting, incorporating Advances in International Accounting, 27(1), 39–53. https://doi.org/10.1016/j.adiac.2010.10.004.

Polit, D. F., & Beck, C. T. (2010). Generalization in quantitative and qualitative research: Myths and strategies. International Journal of Nursing Studies, 47, 1451-1458. https://doi.org/10.1016/j.ijnurstu.2010.06.004

Quattrone, P., & Hopper, T. (2005). A Ôtime–space odysseyÕ: management control systems in two multinational organisations. Accounting, Organizations and Society, 30, 735–764. https://doi.org/10.1016/j.aos.2003.10.006.

Salur, M. N., & Kattar, W. K. (2021). The impact of enterprise resource planning (ERP) on the audit in the context of emerging technologies. Ekonomi Maliye İşletme Dergisi, 4(2), 115–123. https://doi.org/10.46737/emid.1032735.

Sanchez-Rodriguez, C., & Spraakman, G. (2012). ERP systems and management accounting : a multiple case study. Qualitative Research in Accounting & Management, 9(4), 398–414. https://doi.org/10.1108/11766091211282689.

Scapens, R. W., & Jazayeri, M. (2003). ERP systems and management accounting change : opportunities or impacts ? A research note. European Accounting Review, 12(1), 201–233. https://doi.org/10.1080/0963818031000087907.

Segal, S. Y. (2016). Accounting frauds – review of advanced technologies to detect and prevent frauds. Economics and Business Review, 2(4), 45–64. https://doi.org/10.18559/ebr.2016.4.3

Sekaran, U., & Bougie, R. (2016). Research Methods For Business: A Skill Building Approach, 7th Edition. New Jersey: Wiley.

Simeunovic, N., Grubor, G., & Ristic, N. (2016). Forensic accounting in the fraud auditing case. The European Journal of Applied Economics, 13(2), 45–56. https://doi.org/10.5937/ejae13-10509.

Singh, N., Lai, K. H., Vejvar, M., & Cheng, T. E. (2019). Data‐driven auditing: A predictive modeling approach to fraud detection and classification. Journal of Corporate Accounting & Finance, 30(3), 64-82. https://doi.org/10.1002/jcaf.22389

Tarigan, Z. J. H., Siagian, H., & Jie, F. (2021). Impact of enhanced Enterprise Resource Planning (ERP) on firm performance through green supply chain management. Sustainability, 13(8), 4358. https://doi.org/10.3390/su13084358

Tzelepis, D., Tampakas, V., & Kotsiantis, S. (2006). Forecasting fraudulent financial statements using data mining. International Journal of Computational Intelligence, 3(2), 104-110.

Wang, J., & Yang, J. G. (2009). Data mining techniques for auditing attest function and fraud detection. Journal of Forensic & Investigative Accounting, 1(1), 1-24.




DOI (PDF): https://doi.org/10.30596/liabilities.v9i1.29529.g15403

Refbacks

  • There are currently no refbacks.