Excel-based assistance in financial management of micro-enterprises in the catering industry

Micro, Small, and Medium Enterprises (MSMEs) are productive economic activities that can be managed individually or through business entities. One of the micro businesses in the catering services sector in Surabaya is Bunda Tasty. These businesses face challenges in financial management that are no...

Full description

Saved in:
Bibliographic Details
Main Authors: Ellen Theresia Sihotang, Riski Aprillia Nita, Kartika Marta Budiana
Format: Article
Language:Indonesian
Published: Universitas Muhammadiyah Malang 2025-04-01
Series:Journal of Community Service and Empowerment
Subjects:
Online Access:https://ejournal.umm.ac.id/index.php/jcse/article/view/37003
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1849702278735331328
author Ellen Theresia Sihotang
Riski Aprillia Nita
Kartika Marta Budiana
author_facet Ellen Theresia Sihotang
Riski Aprillia Nita
Kartika Marta Budiana
author_sort Ellen Theresia Sihotang
collection DOAJ
description Micro, Small, and Medium Enterprises (MSMEs) are productive economic activities that can be managed individually or through business entities. One of the micro businesses in the catering services sector in Surabaya is Bunda Tasty. These businesses face challenges in financial management that are not yet systematized. Record-keeping is still done manually using Excel and does not refer to the Accounting Standards for Entities without Significant Public Accountability (SAK-ETAP). The community service team, consisting of lectures from the Faculty of Economics and Business at Hayam Wuruk University (UHW) Perbanas, provides a solution in the form of financial management using the Excel for Accounting (EFA) application. This application is relatively simple and still utilizes Excel worksheets. The method used involves mentoring in the design and implementation of EFA along with its socialization. The mentoring activities, including the socialization of EFA, were conducted from March to August 2023. The community service activities consist of three main stages: preparation, implementation, and evaluation. A series of community service programs took place over approximately six months. Based on the evaluation, the activities were very successful and provided new knowledge for the partners. The partners can make decisions through systematized financial management. They have also implemented EFA in managing their business since September 2023.
format Article
id doaj-art-e9d466e8f768423b9032ccfef7e59ace
institution DOAJ
issn 2722-4244
2722-5291
language Indonesian
publishDate 2025-04-01
publisher Universitas Muhammadiyah Malang
record_format Article
series Journal of Community Service and Empowerment
spelling doaj-art-e9d466e8f768423b9032ccfef7e59ace2025-08-20T03:17:43ZindUniversitas Muhammadiyah MalangJournal of Community Service and Empowerment2722-42442722-52912025-04-016110.22219/jcse.v6i1.37003Excel-based assistance in financial management of micro-enterprises in the catering industryEllen Theresia Sihotang0Riski Aprillia Nita1Kartika Marta Budiana2Management Department, Faculty of Business and Economic, University of Hayam Wuruk Perbanas, IndonesiaAccounting Department, Faculty of Business and Economic, University of Hayam Wuruk Perbanas, IndonesiaAccounting Department, Faculty of Business and Economic, University of Hayam Wuruk Perbanas, Indonesia Micro, Small, and Medium Enterprises (MSMEs) are productive economic activities that can be managed individually or through business entities. One of the micro businesses in the catering services sector in Surabaya is Bunda Tasty. These businesses face challenges in financial management that are not yet systematized. Record-keeping is still done manually using Excel and does not refer to the Accounting Standards for Entities without Significant Public Accountability (SAK-ETAP). The community service team, consisting of lectures from the Faculty of Economics and Business at Hayam Wuruk University (UHW) Perbanas, provides a solution in the form of financial management using the Excel for Accounting (EFA) application. This application is relatively simple and still utilizes Excel worksheets. The method used involves mentoring in the design and implementation of EFA along with its socialization. The mentoring activities, including the socialization of EFA, were conducted from March to August 2023. The community service activities consist of three main stages: preparation, implementation, and evaluation. A series of community service programs took place over approximately six months. Based on the evaluation, the activities were very successful and provided new knowledge for the partners. The partners can make decisions through systematized financial management. They have also implemented EFA in managing their business since September 2023. https://ejournal.umm.ac.id/index.php/jcse/article/view/37003CateringCatering ServiceEFAExcel
spellingShingle Ellen Theresia Sihotang
Riski Aprillia Nita
Kartika Marta Budiana
Excel-based assistance in financial management of micro-enterprises in the catering industry
Journal of Community Service and Empowerment
Catering
Catering Service
EFA
Excel
title Excel-based assistance in financial management of micro-enterprises in the catering industry
title_full Excel-based assistance in financial management of micro-enterprises in the catering industry
title_fullStr Excel-based assistance in financial management of micro-enterprises in the catering industry
title_full_unstemmed Excel-based assistance in financial management of micro-enterprises in the catering industry
title_short Excel-based assistance in financial management of micro-enterprises in the catering industry
title_sort excel based assistance in financial management of micro enterprises in the catering industry
topic Catering
Catering Service
EFA
Excel
url https://ejournal.umm.ac.id/index.php/jcse/article/view/37003
work_keys_str_mv AT ellentheresiasihotang excelbasedassistanceinfinancialmanagementofmicroenterprisesinthecateringindustry
AT riskiaprillianita excelbasedassistanceinfinancialmanagementofmicroenterprisesinthecateringindustry
AT kartikamartabudiana excelbasedassistanceinfinancialmanagementofmicroenterprisesinthecateringindustry