BANDUNG, UNIKOM — On Friday, April 24, 2026, Pengabdian Kepada Masyarakat (PKM), community service team, consisting of lecturers, alumni, and students from Universitas Komputer Indonesia (UNIKOM), carried out a community service activity as a contribution by the university to the empowerment of the micro-business sector. The PKM activity was led by a lecturer from the Faculty of Economics and Business (FEB), Assoc. Prof. Dr. Ely Suhayati, S.E., M.Si., Ak., CA., with team members including lecturer Fakhrian Fadlia Adiwijaya, S.Kom., alumna Dini Fitriyanti, A.Md., and Nasya Rizqiana, a student in the Accounting Program.
The PKM program was made possible through an internal grant from UNIKOM via the Community Service and Empowerment Division (DP2M). Under the theme “Preparing Financial Reports for Kios Bos Kecos Using Excel,” the program also partnered with the SME Kios Bos Kecos, located at Jl. H. Mansyur No. 117, RT 09/RW 04, Bojongsoang, Bandung Regency, West Java 40288.
Kios Bos Kecos is a productive micro-enterprise operating in the garment tailoring service sector and has been in operation since January 2021. Initially, the business handled contract work for other parties. Over time, its strategic roadside location has helped it become increasingly well-known within the local community.
However, throughout its development, Kios Bos Kecos has faced several challenges in business management, particularly in operational and financial aspects. These challenges have resulted in limited business promotion, while financial record-keeping has remained manual, preventing a comprehensive overview of business performance. As a result, it has been difficult for the business to formulate financial strategies or prepare the financial reports required to access financing.
To address these challenges, the UNIKOM PKM team conducted outreach on the basic accounting cycle and provided training on preparing financial reports using Microsoft Excel. The use of Microsoft Excel, combined with Visual Basic for Applications (VBA), was chosen for its ease of implementation, time efficiency, and flexibility in correcting input errors without the need to start over. This system is designed to be directly operated by SME owners.
The activity was implemented using a qualitative descriptive approach through observation, interviews, and direct field surveys. To measure the program’s success, an evaluation was conducted through a post-activity questionnaire, along with consultation services during the system implementation process, whether via telephone, WhatsApp, or direct discussions.
Assoc. Prof. Dr. Ely, as the PKM team leader, stated that through this activity, partners received practical training in financial management that is more organized, systematic, and easy to implement. Additionally, the team provided guidance on utilizing Google Maps and social media to expand the reach of business promotion.
Through this PKM program, the community service initiative is expected to encourage Kios Bos Kecos to adopt more orderly, efficient, and transparent business management practices. Improved capabilities in preparing financial reports are also expected to support more informed decision-making and strengthen access to financial institutions, thereby opening up broader opportunities for future business development. (Directorate of Hms & Pro)