JPM
Vol. 4 No. 2 (2026): July- JPM

Pendampingan Optimalisasi Pencatatan Data Daily worker Berbasis Microsoft Excel pada Departemen Human Resources Hotel APendampingan Optimalisasi Pencatatan Data Daily worker Berbasis Microsoft Excel pada Departemen Human Resources Hotel A

Vivin Alifianti Rusyana (Politeknik Negeri Bandung)
Koernia Purwihartuti (Politeknik Negeri Bandung)
Dewi Sekar Ayu (Politeknik Negeri Bandung)



Article Info

Publish Date
01 Jul 2026

Abstract

The hospitality industry requires an orderly workforce administration system, particularly in managing daily workers who support daily operational needs. In the human resources Department of Hotel A in Bandung, daily worker data recording was initially conducted using physical forms before being recapitulated into a digital file. This condition made the data less structured, increased the possibility of misplaced documents, and made it difficult to monitor the number of workers by department. This community service activity aimed to optimize daily worker data recording through assistance in developing and implementing a Microsoft Excel-based template. The implementation method consisted of partner needs identification, workflow mapping, template development, template implementation, and evaluation of the application results. The results show that the Excel template helped organize daily worker data more systematically based on department, section, working date, payment method, and worker category, namely approval and additional. The implementation also improved data accessibility through a shared folder, supported weekly recapitulation, and reduced dependence on physical documents. This activity indicates that simple digitalization using Microsoft Excel can serve as a practical solution for improving human resources administration efficiency in the hospitality industry.

Copyrights © 2026






Journal Info
JPM

Abbrev

jpm

Publisher

Subject

Humanities Economics, Econometrics & Finance Public Health Social Sciences Other

Description

Jurnal Pengabdian Masyarakat (JPM) adalah jurnal yang menerbitkan artikel-artikel penelitian sebagai hasil pengabdian masyarakat dimana Focus dan Scope pada bidang pendidikan, Hukum, Ekonomi, Humaniora, Teknik, Pertanian, Komunikasi, Kesehatan, dan Rekayasa. Jurnal PKM ini memuat publikasi hasil ...