Preparing Financial Reports Using Microsoft Excel Based on SAK EMKM (Case Study of Various Kiosk Umkm) in Manado

Authors

  • Raykes Hinrich Tuerah Politeknik Negeri Manado, Indonesia
  • Christony Maradesa Politeknik Negeri Manado, Indonesia
  • Meike Negawati Kesek Politeknik Negeri Manado, Indonesia
  • Ruhiyat Ruhiyat Politeknik Negeri Manado, Indonesia

DOI:

https://doi.org/10.57235/jambuair.v3i1.1149

Keywords:

SAK EMKM, Financial Reports, Microsoft Excel

Abstract

Kios Aneka's business has only been running for 2 years now. Kios Aneka has 2 types of business, namely the gas trading business and the advertising agency business. According to an interview with the kiosk owner, currently the business is running well but not too significantly, he added that currently additional business capital is needed by borrowing capital from banks or other sources. However, the current obstacle is regarding information in submitting financial report documents for administration to the bank or other partners in lending capital. The type of research used in this research is qualitative research. Based on the results of processed financial reports based on SAK EMKM using Microsoft Excel, this report summarizes all income and expenses for one period, including the cumulative impact of income, profits, expenses and losses on Kios Aneka MSMEs. The balance sheet is an accounting report that summarize Kios Aneka's assets (current, long-term and intangible assets). On the liabilities side, there are liabilities (debts, bills and bank loans) and equity (share capital and profits). Notes to financial statements (CALK) are notes or additional information added to the end of a financial report. Based on the results of research conducted at Kios Aneka, it can be concluded that the owner of Kios Aneka does not prepare financial reports based on accounting standards for micro, small and medium enterprises (SAK EMKM), because entrepreneurs do not have knowledge of accounting and accounting standards for micro, small and medium enterprises (SAK EMKM).

Downloads

Download data is not yet available.

References

Advernesia. (2017, November 19). Pengertian Microsoft Excel dan Fungsinya | Tutorial Microsoft Excel. Advernesia. https://www.advernesia.com/blog/microsoft-excel/microsoft-excel-adalah/

Ikatan Akuntan Indonesia. ED SAK EMKM (Mohon untuk merefer ke dokumen SAK EMKM yang final).

Judianto, R. d. (2018). Implementasi Penyusunan Laporan Keuangan UMKM Berdasarkan Standar Akuntansi Keuangan Entitas Mikro dan Menengah (SAK EMKM) Pada UKM Davin Decor Surakarta. JAB Vol.4, No.02.

Muchid, A. (2015). Penyusunan Laporan Keuangan UMKM Berdasarkan Standar Keuangan-Entitas Tanpa Akuntabilitas Publik (SAK-ETAP) (Kasus Pada UD Mobel Novel I di Banyuwangi). Artikel Ilmiah Mahasiswa .

Ningtyas, J. (2017). Penyususnan Laporan Keuagan UMKM Berdasarkan Standar Akuntansi Keuangan Entitas Mikro, Kecil Dan Menengah (SAK- EMKM) (Studi Kasus di UMKM Bintang Malam Pekalongan). Riset dan Jurnal Akuntansi, Volume.2, No.1 .

Sugiono. (2014). Metodologi Penelitian Bisnis. Bandung: Alfabeta.

Sujarweni, V. W, 2019. Akuntansi UMKM (Usaha Mikro Kecil Menengah). Yogyakarta: Penerbit Pustaka Baru

Vision Media. (2023). Peran UMKM Dalam Menghadapi Ancaman Resesi Ekonomi 2023. Https://Smesco.go.id. https://smesco.go.id/berita/peran-umkm-dalam-resesi-2023

Downloads

Published

2024-04-01

Issue

Vol. 3 No. 1 (2024): April 2024

Section

Articles

Citation Check

License

  1. Authors certify that the work reported here has not been published before and contains no materials the publication of which would violate any copyright or other personal or proprietary right of any person or entity.
  2. Authors dont transfer or license the copyright of publishing to JAMBU AIR: Journal of Accounting Management Business and International Research to publish the article in any media format, to share, to disseminate, to index, and to maximize the impact of the article in any databases.
  3. Authors hereby dont agree to transfer a copyright for publishing to JAMBU AIR: Journal of Accounting Management Business and International Research a Publisher of the manuscript. 
  4. Authors reserve the following: 
    1. all proprietary rights other than copyright such as patent rights; 
    2. the right to use all or part of this article in future works of our own such as in books and lectures;
    3. use for presentation in a meeting or conference and distributing copies to attendees; 
    4. use for internal training by author's company;
    5. distribution to colleagues for their research use;
    6. use in a subsequent compilation of the author's works;
    7. inclusion in a thesis or dissertation;
    8. reuse of portions or extracts from the article in other works (with full acknowledgement of final article);
    9. preparation of derivative works (other than commercial purposes) (with full acknowledgement of final article); and
    10. voluntary posting on open web sites operated by author or author’s institution for scholarly purposes, but it should follow the open access license of Creative Common CC BY-NC-SA License.