Development of a Google Apps Script-Based Transaction System with Business Intelligence for Sales Trend Analysis at Dapoer Mba Nina MSME
DOI:
https://doi.org/10.35870/ijsecs.v6i2.7614Keywords:
Google Apps Script, Business Intelligence, Chart.js, Transaction System, MSMEsAbstract
Dapoer Mba Nina is a culinary micro, small, and medium-sized enterprise (MSME) that still relies on manual transaction recording using a cash book, which creates risks of recording errors, difficulties in monitoring sales trends, and challenges in making data-driven business decisions. This study aims to design and develop a web-based transaction system using Google Apps Script integrated with a Business Intelligence dashboard based on Chart.js to analyze sales trends at Dapoer Mba Nina. The study employed an applied research approach using the Waterfall system development model, which consists of requirements analysis, system design, implementation, testing, and evaluation. The developed system uses Google Apps Script for data processing and the web application, Google Sheets as a cloud-based data storage medium, and Chart.js for visualizing sales data on the dashboard. System testing was conducted using Black Box Testing to validate system functionality and User Acceptance Testing (UAT) to assess user acceptance and the suitability of the system for operational needs. The implementation results show that the system can automate sales transaction recording, generate daily, weekly, and monthly sales reports, and display sales trends and best-selling products through an interactive dashboard. The Black Box Testing results show that all tested scenarios operated as designed, while User Acceptance Testing achieved a score of 96%, categorized as very good. The developed system can help improve transaction data management efficiency and support data-driven business decision-making at Dapoer Mba Nina.
Downloads
References
Aji, S., & Pratmanto, D. (2021). Sistem informasi inventory barang menggunakan metode waterfall. Indonesian Journal on Software Engineering (IJSE), 7(1), 93–99. https://doi.org/10.31294/ijse.v7i1.10601
Anatan, L., & Nur. (2023). Micro, small, and medium enterprises' readiness for digital transformation in Indonesia. Economies, 11(6), 156. https://doi.org/10.3390/economies11060156
Chart.js. (2025). Chart.js: Open source HTML5 charts for your website. Chart.js
Evrita, T., & Tony. (2023). Perancangan dashboard untuk manajemen penjualan produk pada PT. Nutragen Global Esana. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 10(2), 538–550. https://doi.org/10.35957/jatisi.v10i2.4975
Tsani, A. B., Mahardika, F., & Santika, D. (2025). Pembuatan web dashboard interaktif untuk analisis data penjualan vending machine. Modem: Jurnal Informatika dan Sains Teknologi, 3(2), 51–61. https://doi.org/10.62951/modem.v3i2.406
Fahrullah, F., Haerullah, H., & Ridhawani, A. (2025). Analisis blackbox testing dan user acceptance testing terhadap sistem informasi Posyandu Dondang. Journal of Practical Computer Science, 5(1), 42–50. https://doi.org/10.37366/jpcs.v5i1.5780
Florencondia, N. T., Ladignon, C. M., & Muldong, R. M. C. (2024). Enhancing performance metrics: A Google Looker Studio approach to key performance indicator (KPI) management system for Homecorp Offshore Drafting Team. Engineering and Technology Journal, 9(5), 4076–4088. https://doi.org/10.47191/etj/v9i05.25
Handrianto, Y., & Sanjaya, B. (2020). Model waterfall dalam rancang bangun sistem informasi pemesanan produk dan outlet berbasis web. Jurnal Inovasi Informatika, 5(2), 153–160. https://doi.org/10.51170/jii.v5i2.66
Hari Wibowo, A., Faisah, K., & Devianto, Y. (2022). Analisa dan visualisasi data penjualan menggunakan exploratory data analysis pada PT. Telkominfra. Jurnal Teknik Informatika dan Sistem Informasi, 9(3), 2292–2304.
Haryadina Putra, B. A. F., & Dirgahayu, R. (2025). Google App Script untuk pengembangan sistem informasi laboratorium. JATISI (Jurnal Teknik Informatika dan Sistem Informasi), 12(1), 59–75. https://doi.org/10.35957/jatisi.v12i1.9368
Herdiana, O., Maesaroh, S. S., & Nazya, A. F. (2022). Perencanaan business intelligence untuk strategi pengembangan produk unggulan UMKM. Jurnal Teknologi Informatika dan Komputer MH. Thamrin, 8(2), 1–10. https://doi.org/10.37012/jtik.v8i2.1142
Hidayattullah, M. F., Handayani, S. F., Af'idah, D. I., & Hapsari, Y. (2025). Pemanfaatan aplikasi Google Looker Studio untuk membantu visualisasi laporan data keuangan. JMM (Jurnal Masyarakat Mandiri), 9(3), 2757. https://doi.org/10.31764/jmm.v9i3.30285
Limbor, E. G., Putri, T. A., Qadriah, S. A. R., Arisandi, D., & Beng, J. T. (2024). Perancangan dashboard penjualan pakaian di Toko Cleo dengan Power BI. Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, 13(3), 2061–2069. https://doi.org/10.35889/jutisi.v13i3.2383
Muhammad, R., Hendriyana, & Ardimansyah, M. I. (2020). Penerapan Google Spreadsheet dalam pembuatan laporan keuangan untuk pengembangan usaha UMKM Kota Bandung. IKRAITH-ABDIMAS, 3(1), 101–106.
Primadewi, A., Purnomo, T. A., & Sasongko, D. (2021). Analisa perancangan sistem pengelolaan data UMKM berdasarkan Business Intelligence Development Model Framework. Jurnal Sistem Komputer dan Informatika (JSON), 3(2), 209–214. https://doi.org/10.30865/json.v3i2.3587
Putra, A. W. S., & Suprianto, S. (2024). Sistem informasi penjualan berbasis web untuk toko ritel. Indonesian Journal of Applied Technology, 1(2), 1–13. https://doi.org/10.47134/ijat.v1i2.2485
Rahim, S. S. A., Beng, J. T., Arisandi, D., & Nurkholiza, R. (2025). Model visualisasi laporan untuk pengambilan keputusan bisnis menggunakan Laravel dan Chart.js pada PT. XYZ. INTECOMS: Journal of Information Technology and Computer Science, 8(6), 2133–2143.
Rindho, D. C. Y., & Dirgahayu, T. (2024). Pengembangan sistem informasi toko kelontong berbasis Google Apps Script pada Toko Asih. Technologia: Jurnal Ilmiah, 15(4), 930–941. https://doi.org/10.31602/tji.v15i4.16708
Rosanti, R. L., & Swalaganata, G. (2024). Implementasi Google App Script untuk input data pada database master data. Riset dan E-Jurnal Manajemen Informatika Komputer (REMIK), 8(1). https://doi.org/10.33395/remik.v8i1.13273
Salsabila, A., & Maududy, R. (2026). Implementasi business intelligence untuk analisis penjualan Galery Monica menggunakan Microsoft Power BI. RIGGS: Journal of Artificial Intelligence and Digital Business, 5(2), 5450–5458.
Wahyudi, I., & Alameka, F. (2023). Analisis blackbox testing dan user acceptance testing terhadap sistem informasi Solusimedsosku. Jurnal Teknosains Kodepena, 4(1), 1–9. https://doi.org/10.54423/jtk.v4i1.54
Wahyudin, W., & Bela, S. (2021). Rancang bangun sistem informasi inventory stock barang berbasis web. Jurnal Teknik Komputer, 7(2), 214–221. https://doi.org/10.31294/jtk.v7i2.10683
Zen, M., Irwan, I., Hafni, H., & Ananda, M. D. P. (2024). Implementasi dan pengujian menggunakan metode Black Box Testing pada sistem informasi tracer study. Bulletin of Computer Science Research, 4(4), 327–340. https://doi.org/10.47065/bulletincsr.v4i4.359
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Muhammad Umar Hafidz, Dadang Iskandar Mulyana, Mesra Betty Yel
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
