Interaksi : Jurnal Pengabdian Kepada masyarakat
Vol. 3 No. 02 (2026): Juli 2026

PENDAMPINGAN PENYUSUNAN LAPORAN KEUANGAN DIGITALBERBASIS MICROSOFT EXCEL BAGI UMKM

Winda Simanjuntak (Institut Bisnis Dan Komputer Indonesia)
Karina Silaen (Institut Bisnis Dan Komputer Indonesia)
Endang Br Sinaga (Institut Bisnis Dan Komputer Indonesia)



Article Info

Publish Date
31 Jul 2026

Abstract

Poor financial management remains a challenge for many Micro, Small, and Medium Enterprises (MSMEs), particularly in recording transactions and preparing financial reports that can support decision-making. This Community Service activity aimed to improve the ability of MSME owners to prepare digital financial reports using Microsoft Excel. The activity was conducted in May 2026 in Medan City, involving 30 participants from the trade, culinary, and service sectors. It employed a participatory training and mentoring approach consisting of needs identification, training, hands-on practice, individual mentoring, and evaluation. The training materials covered transaction recording, general journals, ledgers, trial balances, income statements, statements of financial position, and the use of simple formulas in an Excel template. The evaluation results showed that the average score increased from 58.40 in the pre-test to 87.60 in the post-test, while the completion rate increased from 33% to 93%. The overall satisfaction rate reached 97%. Participants also began implementing the separation of personal and business finances, routine financial recording, and the use of financial reports as a basis for evaluation. Practice-based mentoring and simple Excel templates have the potential to be replicated to strengthen financial accountability among MSMEs.

Copyrights © 2026






Journal Info

Abbrev

PKM

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Engineering Health Professions

Description

Jurnal Pengabdian ini adalah merupakan jurnal nasional yang berisi hasil-hasil kegiatan pengabdian dan pemberdayaan masyarakat berupa penerapan berbagai bidang ilmu diantaranya Kesehatan, teknik , pertanian, Hukum, Manajemen komputer dan bidang ilmu lainnya. Jurnal PKM Akan terbit 2 (dua) Kali dalam ...