Development of an AI-Assisted Web-Based Class Treasury Management System with OCR-Based Receipt Scanning
DOI:
https://doi.org/10.31980/5sxhpp95Keywords:
class treasury, financial information system, flask, optical character recognition, black-box testingAbstract
This study describes the design and functional evaluation of a web-based class treasury application built with Flask and MySQL. The application supports cashier authentication, student records, cash transactions, monthly dues, payment reminders, financial reports, receipt scanning, and a rule-based assistant. System requirements and structure are documented using use case, activity, sequence, class, and entity relationship diagrams. Functional behavior was examined through 13 black-box scenarios using the Flask test client and an active MySQL database. The scenarios covered valid and invalid authentication, access to the main application pages, an assistant query, rejection of selected invalid inputs, and extraction of a receipt amount and date from OCR text. All 13 scenarios produced the expected outcomes. These results apply only to the tested cases and do not establish overall security, performance, cross-browser compatibility, or OCR accuracy on a representative collection of receipts. Further testing should cover valid create, update, and delete operations, report export, and varied receipt images.
References
Annisa, A. R., Adhitya, R. Y., Sholikhah, E. N., Rahayu, P. N., Andika, Y., & Ardiana, M. (2025). Digitalisasi sistem keuangan di Yayasan Pendidikan Al-Islah melalui pembuatan sistem informasi keuangan berbasis website. JCES (Journal of Character Education Society), 8(1), 136–146. https://doi.org/10.31764/jces.v8i1.29123
Arifin, S., Asroni, & Kurnianti, A. (2021). Development of a web-based school payment administration information system using the Laravel framework. Emerging Information Science and Technology, 2(1), 8–15. https://doi.org/10.18196/eist.v2i1.16857
Brawijaya, H., & Rahmawati, E. (2025). Pengembangan sistem informasi keuangan sekolah berbasis web dengan model Rapid Application Development. Jurnal INSAN (Journal of Information Systems Management Innovation), 5(2), 90–99. https://doi.org/10.31294/j-insan.v5i2.9731
Hartono, F. D., & Sugiarti, Y. (2022). Perbandingan metode equivalence partitions dan boundary value analysis pada pengujian black box. Majalah Ilmiah METHODA, 12(2), 153–159. https://doi.org/10.46880/methoda.Vol12No2.pp153-159
Huang, Z., Chen, K., He, J., Bai, X., Karatzas, D., Lu, S., & Jawahar, C. V. (2019). ICDAR2019 competition on scanned receipt OCR and information extraction. In 2019 International Conference on Document Analysis and Recognition (ICDAR) (pp. 1516–1520). https://doi.org/10.1109/ICDAR.2019.00244
Hutabri, E., Darman, R. A., & Efendi, R. (2021). Perancangan sistem informasi pembayaran uang komite sekolah berbasis web. Jurnal Komputer Terapan, 7(1), 1–13. https://doi.org/10.35143/jkt.v7i1.4484
International Organization for Standardization. (2023). ISO/IEC 25010:2023 Systems and software engineering—Systems and software Quality Requirements and Evaluation (SQuaRE)—Product quality model. Geneva, Switzerland: Author.
International Organization for Standardization, International Electrotechnical Commission, & Institute of Electrical and Electronics Engineers. (2022). ISO/IEC/IEEE 29119-1:2022 Software and systems engineering—Software testing—Part 1: General concepts. Geneva, Switzerland: Author.
International Software Testing Qualifications Board. (2023). Certified Tester Foundation Level syllabus (Version 4.0). Retrieved from https://www.istqb.org/certifications/certified-tester-foundation-level-ctfl-
v4-0/
Li, M., Lv, T., Chen, J., Cui, L., Lu, Y., Florencio, D., ... Wei, F. (2023). TrOCR: Transformer-based optical character recognition with pre-trained models. Proceedings of the AAAI Conference on Artificial
Intelligence, 37(11), 13071–13081. https://doi.org/10.1609/aaai.v37i11.26538
Loka, R. J., Jangais, A. U., & Rato, K. W. (2024). Web-based vocational high school financial administration information system using Laravel framework. Jurnal Penelitian Teknologi Informasi dan Sains, 2(3), 201–208. https://doi.org/10.54066/jptis.v2i3.2458
Myers, G. J., Badgett, T., & Sandler, C. (2012). The art of software testing (3rd ed.). Hoboken, NJ: Wiley.
Object Management Group. (2017). OMG Unified Modeling Language (OMG UML), version 2.5.1. Retrieved from https://www.omg.org/spec/UML/2.5.1
Oracle. (n.d.). MySQL 8.4 reference manual. Retrieved October 17, 2026, from https://dev.mysql.com/doc/refman/8.4/en/
Pallets Projects. (n.d.). Flask documentation (3.1.x). Retrieved October 17, 2026, from https://flask.palletsprojects.com/en/stable/
Pressman, R. S., & Maxim, B. R. (2020). Software engineering: A practitioner's approach (9th ed.). New York, NY: McGraw-Hill.
Putri, A. T., Husnaya, A. A., Hadafi, D. F., Abdulmalik, H. I., Nasir, M., & Indriasari, S. (2025). Implementation of equivalence partitioning and boundary value analysis in black box testing: A case study on the admin website of PAUD KB Al Husna. Jurnal Teknologi dan Open Source, 8(2), 776–787. https://doi.org/10.36378/jtos.v8i2.5028
Putri, S. J., Putri, D. G. P., & Putra, W. H. N. (2024). Analisis komparasi pada teknik black box testing (studi kasus: Website Lars). Journal of Internet and Software Engineering, 5(1), 23–28. https://doi.org/10.22146/jise.v5i1.9446
Ramadan, A. T., Saputra, G., Adha, M. F., & Haryono, W. (2025). Developing a web-based financial management information system for PAUDQU with Rapid Application Development (RAD) method. TECH-E: Journal of Technology Electronic, 9(1), 73–83. https://doi.org/10.31253/te.v9i1.3944
Ramadani, N., Yul, F. A., & Abdurrahman, A. (2025). Digital transformation of school administration through financial management information system (SIMKU). Jurnal KomtekInfo, 12(2), 78–85. https://doi.org/10.35134/komtekinfo.v12i2.636
Santi, P. A. D. A., Afwani, R., Albar, M. A., Anjarwani, S. E., & Mardiansyah, A. Z. (2022). Black box testing with equivalence partitioning and boundary value analysis methods (study case: Academic Information System of Mataram University). In Proceedings of the First Mandalika International Multi-Conference on Science and Engineering 2022 (pp. 207–219). https://doi.org/10.2991/978-94-6463-084-8_19
Smith, R. (2007). An overview of the Tesseract OCR engine. In Proceedings of the Ninth International Conference on Document Analysis and Recognition (ICDAR 2007) (Vol. 2, pp. 629–633). https://doi.org/10.1109/ICDAR.2007.4376991
Tesseract.js. (n.d.). Tesseract.js: Pure JavaScript OCR for 100 languages. Retrieved October 17, 2026, from https://tesseract.projectnaptha.com/
Unhelkar, B. (2017). Software engineering with UML. Boca Raton, FL: CRC Press. https://doi.org/10.1201/9781351235181
Waziana, W., & Saputra, R. H. (2023). Utilization of information systems in web mobile-based school financial administration management: Case study of Ma'arif 1 Vocational School, Kalirejo. Asia Information System Journal, 2(2). https://doi.org/10.24042/aisj.v2i2.19147
Sommerville, I. (2015). Software engineering (10th ed.). Boston, MA: Pearson.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Encep Riswan Suherlan

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
