Development of an AI-Assisted Web-Based Class Treasury Management System with OCR-Based Receipt Scanning

Authors

  • Encep Riswan Suherlan

DOI:

https://doi.org/10.31980/5sxhpp95

Keywords:

class treasury, financial information system, flask, optical character recognition, black-box testing

Abstract

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

22-10-2026