Authors : John Lory P. Amparo; Jake N. Cuyugan; Rosalie L. Paculanan; Joeven Stephen C. Secusana; Gabriel C. Suarez; Kent Russell N. Casiño; Neptale S. Roa III

Volume/Issue : Volume 10 - 2025, Issue 12 - December

Google Scholar : https://tinyurl.com/2dzw4zb9

Scribd : https://tinyurl.com/5n9ymk9r

DOI : https://doi.org/10.38124/ijisrt/25dec1459

Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.

Abstract : This study addresses the prevalence of fraudulent activities and revenue inconsistencies in Pisonet businesses caused by reliance on manual monitoring methods. The primary objective of the project is to develop an Automated Coin Slot Sales Tracking System using a microcontroller to enhance financial transparency and operational efficiency. The system was developed using the Modified Waterfall SDLC model, covering requirements gathering through deployment, and was built using ESP32 microcontrollers, Firebase Firestore, Next.js, and Tailwind CSS for its implementation. It is intended for Pisonet business owners and branch partners, offering features such as real-time coin counting, automated financial reporting, offline data synchronization, and multi-branch management. Testing and evaluation show that the system achieves high accuracy in recording transactions, maintains stable connectivity via a dedicated network, and provides an organized interface that simplifies sales verification. The project effectively establishes a transparent digital audit trail that minimizes human error and prevents fraud, though physical security against altered coins remains dependent on the coin slot hardware.

Keywords : Pisonet, Automation, Sales Tracking, ESP32, Internet of Things, Next.js, Firebase.

References :

1. Ratnasri, N., & Sharmilan, T. (2021, June). Vending machine technologies: A review article. International Journal of Sciences: Basic and Applied Research, 60, 160–166. https://www.researchgate.net/publication/357577286.
2. Kahar, N. I., & Lias, J. (2024, November 6). IoT-Based coin slot of the vending machine. EEE Periodicals. https://publisher.uthm.edu.my/periodicals/index.php/eeee/article/view/17641.
3. Casaclang, F. C. G., Jugao, H. S. G., Advincula, R. J. N., Francisco, P. F. Y., Cruz, A. M. D., & Limos-Galay, J. A. (2024). Arduino-Uno-based automated coin-counting machine. International Journal of Research Studies in Educational Technology, 8(3), 81–88. https://www.researchgate.net/profile/Jenny-Galay- Limos/publication/382266695_Arduino-Uno-based_automated_coin- counting_machine/links/66a352a74433ad480e7b46d5/Arduino-Uno-based-automated- coin-counting-machine.pdf.
4. Lale, D., Săvescu, C., Gogoneață, S., & Niculescu, F. (2021). Passengers Monitoring System with Infrared Sensors and Microcontroller. ResearchGate. https://www.researchgate.net/publication/357180151_Passengers_Monitoring_System_w ith_Infrared_Sensors_and_Microcontroller.
5. Booc, R. P., Rafaela, K. B., Jabonero, L. C., II, Cortuna, I. J. M., Gabiana, B. M., De Sagun, L. J. B., & Asuncion, J. E. (2020). IOT BASED: MOBILE CONTROLLED APPLIANCES WITH ONLINE MONITORING SYSTEM. Theoretical & Applied Science, 88(08), 58– 64. https://doi.org/10.15863/tas.2020.08.88.15.
6. Eremić, Borjanović, I. (2024). AI-Supported Solution for Proposal to Improve Indoor Air Quality Using Web Application and Airthings Radon Detector. Paper presented at Sinteza 2024 - International Scientific Conference on Information Technology, Computer Science, and Data Science. doi:10.15308/Sinteza-2024-25-30.
7. Al-Sa’di, A., & Litayem, N. (2023, September). *User frustration: Shaping the experience of automotive and computing*. In *2023 IEEE 3rd International Conference on Computer Systems (ICCS)* (pp. 56–61). IEEE. [https://doi.org/10.1109/ICCS59700.2023.10335584].
8. Le, G. T., Tran, N. M., & Tran, T. V. (2021). IoT system for monitoring a Large-Area environment sensors and control actuators using Real-Time Firebase Database. In Lecture notes in computer science (pp. 3–20). https://www.researchgate.net/publication/349066443_IoT_System_for_Monitoring_a_La rge-Area_Environment_Sensors_and_Control_Actuators_Using_Real- Time_Firebase_Database.
9. Manop, N., Kamata, K., & Suksakulchai, S. (2022). IoT-based sales reporting devices. International Journal of Computer Theory and Engineering, 14(4), 174-178. https://www.ijcte.com/vol14/1325-E0017.pdf.
10. Firebase Realtime database. (n.d.). Firebase. https://firebase.google.com/docs/database Gheorghiu, R. (2023, August 1). The Power of ERD Diagrams in Database Design: A Step-by- Step Guide for Beginners. Vertabelo Data Modeler. https://vertabelo.com/blog/erd- diagram/.
11. Fitzgerald, A. (2022, May 31). Tailwind CSS: What It Is, Why Use It & Examples. HubSpot. https://blog.hubspot.com/website/what-is-tailwind-css.