A Excel for Accounting Assistance as the Solution for SME PT. JAB Surabaya

THE SPIRIT OF SOCIETY JOURNAL, International Journal of Society Development and Engagement

View Publication Info
Field Value
Title A Excel for Accounting Assistance as the Solution for SME PT. JAB Surabaya
Creator Kartika, Titis Puspitaningrum Dewi
Metana, Nosy Yodi
Kurniawati, Sri Lestari
Subject Excel for accounting assistances, SAK EMKM
Description Several studies suggested that most of Small and Medium Enterprises (SMEs) only noted the amount of money received and expended, the amount of bought and sold goods, and the amount of accounts receivable/debt. However, the note is functioned as reminder but not supported with the format desired by the banks. Even though, they are still able to know the amount of final capital each year which is almost the same as if we took a note by using accounting system. Therefore, Small and Medium Enterprises (SMEs) are directed through assistance to start taking notes of its business activities in accordance with the Accounting Standards Entities of Micro, Small and Medium Enterprises (SAK EMKM) simply and completely as needed.
Basically, the partner's problem in this assistance was due to the accounting administration of financial management at PT. JAB which is not properly arranged such as the determination of HPP. This SME produces coffee powder, chocolate and green tea beverages. It reaches income of Rp. 50.000.000,- per month with the total 3-5 employees and has carried out bookkeeping which is currently experiencing loss. It has already made an excel financial report but in determining HPP, the process costs are not taken into account so that this has no basis.
The result of this assistance is the establishment of financial statement which is correct and appropriate in accordance with SAK EMKM. This study is finally able to solve the problem in determining the amount of HPP due to the lack of synchronization between the production data and accounting department. In addition, this study successfully minimizes errors in determining the amount of inventory which affects the error in determining HPP. The problem faced by every SME must be different so that we are expected to provide assistance in making financial reports.
Date 2019-03-30
Type info:eu-repo/semantics/article
Peer-reviewed Article
Format application/pdf
Identifier https://jurnal.narotama.ac.id/index.php/scj/article/view/869
Source THE SPIRIT OF SOCIETY JOURNAL; Vol 2 No 2 (2019): March 2019; 107-120
Language eng
Relation https://jurnal.narotama.ac.id/index.php/scj/article/view/869/568
Rights Copyright (c) 2019 THE SPIRIT OF SOCIETY JOURNAL

Contact Us

The PKP Index is an initiative of the Public Knowledge Project.

For PKP Publishing Services please use the PKP|PS contact form.

For support with PKP software we encourage users to consult our wiki for documentation and search our support forums.

For any other correspondence feel free to contact us using the PKP contact form.

Find Us


Copyright © 2015-2018 Simon Fraser University Library