SISTEM INFORMASI OPERASIONAL UMKM BERBASIS PROGRESSIVE WEB APP (PWA) UNTUK PENGELOLAAN ABSENSI KARYAWAN BERBASIS GEOLOCATION DAN LAPORAN KEUANGAN PADA UMKM SEMPOL AYAM RATIH TEGAL

Sofiullah Abi Sadzili; Slamet Wiyono; Syefudin Syefudin

doi:10.31539/7gk96v24

Authors

Sofiullah Abi Sadzili Universitas Harkat Negeri Tegal
Slamet Wiyono Universitas Harkat Negeri Tegal
Syefudin Syefudin Universitas Harkat Negeri Tegal

DOI:

https://doi.org/10.31539/7gk96v24

Abstract

Ratih Chicken Sempol MSME in Tegal continues to face challenges in managing its operational data, particularly in employee attendance and financial reporting, which are still handled manually and are not yet integrated. Employee attendance is recorded through a WhatsApp group by submitting photos as proof of attendance, while financial records are maintained separately using handwritten notebooks and Microsoft Excel. As a result, the data are not stored in a centralized system, making data management, retrieval, and recapitulation less efficient and more prone to recording errors. This study aims to design and develop a geolocation-based employee attendance system and a financial reporting system based on a Progressive Web App (PWA), integrated into a single platform to support the operational data management of Ratih Chicken Sempol MSME in Tegal. The system was developed using the Waterfall methodology, with PHP as the programming language, the Laravel framework, and MySQL as the database management system. System testing was conducted using the Black Box Testing method. The system utilizes geolocation technology to validate employee attendance locations and provides a financial reporting module in the form of a General Cash Book (GCB) to centrally manage financial transactions. Based on the testing results, all system functionalities operated according to the specified requirements. The developed system successfully supports location-validated employee attendance and integrated financial reporting, thereby improving the effectiveness and efficiency of operational data management.

References

Arinal, M. B. Yel, A. Maulida, G. Angel, and A. A. Putra, “Pengembangan Sistem Informasi Manajemen Usaha Mikro Kecil dan Menengah ( UMKM ) Seblak Reyhan Berbasis Web,” vol. 4, no. 4, pp. 12977–12985, 2026.

M. Romadhon and D. Sutaji, “Integrasi Sistem Presensi Pegawai Berbasis Web dengan Geolokasi dan Swafoto di PT Gresik Migas,” vol. 3, no. 2, 2025.

L. Melani and V. Ilhadi, “Perancangan dan Implementasi Sistem Informasi Absensi Karyawan K3 PLN Berbasis Website,” vol. 9, no. 2, pp. 12–27.

P. Untuk, M. Redudansi, and D. A. N. Anomali, “Optimalisasi basis data sistem keuangan UMKM pizzaupps untuk mengatasi redudansi dan anomali data”.

I. Fahzirah et al., “Pengenalan Sistem Database : Konsep Dasar,” vol. 1, no. 4, pp. 673–678, 2024.

M. B. Firdaus, G. M. Putra, M. Wisdan, and P. Putra, “Rancang Bangun Aplikasi Presensi Pegawai Berbasis Area Menggunakan Geolocation,” 2023, doi: 10.47002/metik.v7i1.406.

I. C. U. Aji Mustaqim, “Rancang Bangun Sistem Informasi Laporan Keuangan Berbasis Web Pada UMKM Jago Sore Di Boyolali,” 2025.

C. Kusuma, M. Bimanatara, F. A. Akbar, and E. Y. Puspaningrum, “Implementasi Progressive Web Application ( PWA ) Dalam Pengembangan Sistem Pesan- Antar Makanan ( Studi Kasus : Wirawiri Bojonegoro ),” vol. 13, no. 2, pp. 185–196, 2025.

S. F. A. W. Margi Aminulloh Achri Biyanda, Anik Vega Vitianingsih, Pamudi, Litafira Syahadiyanti, “Penerapan Metode Waterfall Pada Sistem Manajemen Keuangan Dan Absensi Karyawan Berbasis Web Studi Kasus:Warung Jokodolog25 Surabaya,” vol. 17, no. 1, pp. 1–11, 2025.

M. Jannah and I. Nawangsih, “Implementasi Aplikasi Absensi Karyawan Menggunakan Geolocation,” vol. 7, no. 3, pp. 797–819, 2023, doi: 10.52362/jisamar.v7i3.1176.

H. Daniel, W. Tucunan, and N. Heryana, “Sistem Informasi Persediaan Produk Makanan Ringan Berbasis Web ( Studi Kasus : D ’ Caruluk Bogor ),” vol. 7, no. 1, pp. 45–53, 2023.

A. Mulyana, S. Komputer, T. Komputer, and U. K. Indonesia, “Sistem Absensi Pengenalan Wajah dengan Menggunakan pustaka Dlib dan metoda K-NN pada Jaringan LAN,” vol. 11, pp. 127–135, 2022.

A. R. Damanik, D. Hartama, and I. Gunawan, “Sistem Presensi Pegawai Berbasis Digital Signatures Dan GPS Location,” vol. 1, pp. 30–36, 2023.

A. G. H and B. Box, “Pengembangan sistem informasi keuangan UMKM berbasis web menggunakan metode waterfall dan Black Box Testing,” vol. 1, no. 2026.

A. Z. Ibna et al., “Implikasi Penggunaan Basis Data Dalam Era Big,” vol. 2, no. 4, pp. 255–265, 2024.

I. Kos-kosan, N. Dwiyanto, and I. V. Paputungan, “Implementasi Teknologi Progressive Web App ( PWA ) Pada Sistem,” vol. 6, no. 1, 2024, doi: 10.47065/josh.v6i1.6074.

N. M. Adelin, M. A. Muhammad, P. B. Wintoro, K. Akhir, T. Informatika, and U. Lampung, “Implementasi Progressive Web Apps ( PWA ) Untuk Meningkatkan Kinerja Dan Performa,” vol. 12, no. 1, pp. 655–663, 2024.

L. Rahmawati and S. Sumarsono, “Desain Pengembangan Website dengan Arsitektur Model View Controller pada Framework Laravel,” J. Teknol. Dan Sist. Inf. Bisnis, vol. 6, no. 4, pp. 785–790, 2024, doi: 10.47233/jteksis.v6i4.1497.

P. L. Jatika, M. Saefudin, D. A. Megawaty, D. Alita, R. Arundaa, and E. Tenda, “Penerapan Framework Laravel Pada Sistem Informasi Posyandu Berbasis Website,” vol. 4, pp. 213–220, 2023.

C. A. Binangkit, A. Voutama, N. Heryana, F. I. Komputer, U. S. Karawang, and A. Musik, “Pemanfaatan Uml ( Unified Modeling Language ) Dalam Perencanaan Sistem Pengelolaan Sewa Alat Musik Berbasis,” vol. 7, no. 2, pp. 1429–1436, 2023.