EXCEL APPLICATION TRAINING TO IMPROVE MSME FINANCIAL GOVERNANCE IN BANDUNG DISTRICT

Erislan ERISLAN

doi:10.33068/iccd.v4i1.457

Erislan ERISLAN Sahid University

DOI: https://doi.org/10.33068/iccd.v4i1.457

Keywords: simple bookkeeping, cash book, cost of production, SMEs

Abstract

In the current digital era, where in industry 4.0, information and communication technology has provided various tools to help business actors build their business governance more efficiently and effectively. One of them is by using the Exel application, formulas that have minimal errors in calculations are provided and in one format that can be used forever. Of course this will help business actors to save time for bookkeeping and eliminate errors in calculating business financial records. One of the characteristics of small industries is that there are still many obstacles that they face, both from information technology and business management. In the information technology aspect, the main challenge that hinders business actors is the limited ability to use information technology and computers, including the use of bookkeeping applications, digital marketing applications, e-commerce applications, and other platforms such as Point of Sale (POS). the management of its business is that there has not been much support for promotion, marketing development strategies, and limited distribution and bookkeeping of the results of its business. The same is true for MOLOS FASHION SMEs in Katapang District, Gandasari Village, Warunglobak. Where the MOLOS FASHION business is still a small-scale industry that also has problems in terms of management, especially in terms of recording the results of its business. To overcome one of these problems, Community Service activities were carried out which provided counseling about the importance of bookkeeping and training on making excel bookkeeping in a simple way using the Cash Book for all SME operational activities and evaluating the calculation of the cost of production. The output that can be realized from this Community Service activity is that SME actors are able to carry out bookkeeping for their business on a regular basis by using the Cash Book and calculating the cost of production correctly and online publication of the implementation of the service.

Downloads

Download data is not yet available.

References

Andi, Y., Marlina, T., and Fahmi, A. (2016). Training on Making Financial Reports with Microsoft Excel BUMDes Performances. Journal of Community Service, 1(1), 9–12.
Arsi, P., Pambudi, A. S., and Maisa, W. (2019). Improving the Quality of Human Resources by Utilizing Science and Technology through Basic Computer and Internet Training for Members of the Kedungbanteng Police. Journal of Abdimas BSI, 2(2), 191–196. Retrieved from https://ejournal.bsi.ac.id/ejurnal/index.php/abdimas/ article/view/4244/3281
-diajarkan-pada-2019.
Cahyono, Heri Setiyo and Sulistyawati, Ardiani Ika (2016). Investment Decisions, Funding Decisions and Dividend Policy as Determinants of Company Value, Journal of Acquisitions, Vol 12 No. November 2, 2016, p. 39 – p. 53.
Dewi, HP. (2016) Smart Managing Personal Finance. Publisher: Stiletto Book. Evi Linawati, MI Mitha Dwi Restuti. 2015. Accounting Knowledge of Micro, Small and Medium Enterprises (MSMEs) on the Use of Accounting Information. 2nd Conference in Business, Accounting and Management. UNISSULA
Fajrinshanty, I., Herawati, NT., and Atmadja, AT. (2019). Implementation of Financial Accounting Standards Without Public Accountability (SAK ETAP) at UD Sinar Abadi Jimat Accounting Student Scientific, Journal Undiksha, 8(2).
Ferina, ZI., Hanila, S., Fitriano, Y., Susanti, N., and Soleh, A. (2020). Improving the Financial Management and Accounting of Bumdes in Pulau Panggung Village, Talang Empat District, Central Bengkulu. Raflesia Earth Community Service Journal, 3(1), 324–333. https://doi.org/10.36085/jpmbr.v3i1.752
Hairunisya, N., Subiyantoro, H. and Masyarakat, P. P. (2017) 'Training and assistance in preparing financial reports for MSME entrepreneurs in Karangrejo sub-district, Tulungagung district', J-ADIMAS (Journal of Community Service), 5(1), pp. 35–45.
Hadiyanti, E. (2011). Creativity and Innovation Affect Small Business Entrepreneurship, Journal of Management and Entrepreneurship, Volume 13 Number 13
Rokhayati, I. (2009). Performance Measurement in Micro, Small and Medium Enterprises (MSMEs).
Setyaningrum, F. and Yunista, M. 2018. Strategy for Financial Reporting in Micro, Small and Medium Enterprises. OPTIMA Journal. Volume 2 No. 2.