Dashboard Data Analysis and Financial Reporting Based on Google Spreadsheet (Case Study of Bam’s Barbershop MSME)
Keywords:
MSME, SAK EMKM, financial reports, Google Spreadsheet, SDLC, TELOSAbstract
MSMEs play an important role in the Indonesian economy, but many still face obstacles in recording transactions and preparing financial reports according to standards. MSME Bams Barbershop, for example, still uses manual recording through notebooks and mobile phones, which makes it difficult to report accurately and on time. This study aims to develop dashboard for data analysis and financial reporting based on Google Spreadsheet in accordance with SAK EMKM. The method used is descriptive qualitative with interview, observation, and documentation techniques, as well as the System Development Life Cycle (SDLC) approach. The system feasibility evaluation uses the TELOS method. The system developed includes a worksheet of account lists, general journals, ledgers, trial balances, profit and loss statements, financial position statements, and Notes to the Financial Statements, as well as additional features such as customer recaps, service packages, and automatic bonus calculations. The dashboard result can help for data transaction analysis to help the owner. The system also produce financial reports automatically, accurately, and according to standards. The feasibility evaluation shows that this system is feasible to be implemented from technical, economic, legal, operational, and time aspects, and can be implemented effectively in MSME operations.Downloads
Download data is not yet available.
References
Al Farisi, S., & Iqbal Fasa, M. (2022). Peran Umkm (Usaha Mikro Kecil Menengah) Dalam Meningkatkan Kesejahteraan Masyarakat. Jurnal Dinamika Ekonomi Syariah, 9(1). http://ejurnal.iaipd- nganjuk.ac.id/index.php/es/index
Apandi, A., Sampurna, D. S., Santoso, J. B., Syamsuar, G., Maliki, F., Tinggi, S., Ekonomi, I., Jakarta, I., Kayu, J., Raya, J., & 11 A, N. (2023). Pentingnya
Laporan Keuangan Yang Baik Bagi Usaha Mikro, Kecil Dan Menengah (UMKM) (Studi Pada UMKM Wilayah Jakarta Utara Kecamatan Penjaringan). In PROGRESIF (Vol. 3, Issue 2). https://ejournal.stei.ac.id/index.php/PROGRESIF
Bank Indonesia. (2022). Framework Pengembangan UMKM Bank Indonesia. Hidayati Nur, Abdullah Syukri, Adriana Nana, Kamal Maulana, Bonara Ribka,
Samekto Agus, Loso Judijanto, Astuti Tri, Mariana, Rafika Uksi, Bawono
Icuk Rangga, Seran Adiutrix, Kristianto Giovanny, Amin Ahmad, & Masradin. (2024). Teori Akuntansi (Teori, Implementasi dan Perkembanganya) (Rianty Erfina, Ed.). PT. Green Pustaka Indonesia.
Kadek, N., Trisnadewi, A., Putu, L., Stie, P., & Dharma, S. (2022). (ST UDI KASUS PADA UMKM SARI MINA AYU) a. In Jurnal Ilmiah Akuntansi dan Bisnis (Vol. 7, Issue 1). http://journal.undiknas.ac.id/index.php/akuntansi
Kieso Donald E, Kimmel Paul D, & Weygandt Jerry J. (2015). Accounting Principles (McDonald Michale, Ed.; 12th ed.). Wiley.
Mustika, I. (2022). Analisa Kesiapan Usaha Mikro Kecil Dan Menengah Dalam Penyusunan Laporan Keuangan Sesuai Standar Akuntansi Keuangan dan Penerapan SAK EMKM Pada Laporan Keuangan UMKM. (Studi Kasus Pada UMKM Laundry Box di Kota Batam) (Vol. 3, Issue 2).
Pantare Alam, A., & Rio Rita, M. (2022). PENERAPAN SAK EMKM PADA UMKM: SURVEI PADA UMKM YANG BERADA DI KECAMATAN TINGKIR,
SALATIGA. Jurnal Visi Manajemen, 8(1).
Razali Geofakta, Syamil Ahmad, Hurit Roberta Uron, Asman Aulia, Lestariningsih, Radjawane Louise, Bagenda Christina, Falasifah Nihlatul, Amane Ade Putra, S Sumarni, Gultom Novianti, Fadhilatunisa Della, Fakhri M Miftach, & Rosidah. (2023). METODOLOGI PENELITIAN KUATITATIF, KUALITATIF, DAN KOMBINASI (Bahri Syaiful, Ed.). CV.
Media Sains Indonesia.
Romney Marshall B, Steinbart Paul John, Summers Scoutt L, & Wood David A. (2021). Accounting Information Systems. Pearson.
Samsu. (2021). METODOLOGI PENELITIAN (Teori dan Aplikasi Penelitian Kualitatif, Kuantitatif, Mixed Methods, serta Research & Development) (Rusmini, Ed.). Pusaka Jambi.
Saputra Novi Chandra, Hadiyat Yana Rochdiana, Dewi Putu Pande, Septiawan Budi, Kosadi Ferry, Fatah Khoirul, Budiadnyani Ni Putu, Herliansyah Yudhi, Putri Kompiang Martina, Musyaffi Ayatulloh Michael, Evayani, Rahmawati Indah, & Rikah. (2024). Sistem Informasi Akuntansi (Welly Yerisma, Ed.). CV. Media Sains Indonesia.
Sutikno M Sobry, & Hadisaputra Prosmala. (2020). Penelitian Kualitatif
(Nurlaeli, Ed.). Holistica.
Trixie, M. A., & Nugroho, H. (2024). Perancangan Aplikasi Sistem Pencatatan Transaksi Dan Pelaporan Keuangan Studi Kasus Pada UMKM Tauco Ci Enjon Tangerang.
Vidyasari Rahmanita, & Febriyan. (2022). Komputerisasi Pencatatan Akuntansi dan Pelaporan Keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink (Vol. 9, Issue 1).
Apandi, A., Sampurna, D. S., Santoso, J. B., Syamsuar, G., Maliki, F., Tinggi, S., Ekonomi, I., Jakarta, I., Kayu, J., Raya, J., & 11 A, N. (2023). Pentingnya
Laporan Keuangan Yang Baik Bagi Usaha Mikro, Kecil Dan Menengah (UMKM) (Studi Pada UMKM Wilayah Jakarta Utara Kecamatan Penjaringan). In PROGRESIF (Vol. 3, Issue 2). https://ejournal.stei.ac.id/index.php/PROGRESIF
Bank Indonesia. (2022). Framework Pengembangan UMKM Bank Indonesia. Hidayati Nur, Abdullah Syukri, Adriana Nana, Kamal Maulana, Bonara Ribka,
Samekto Agus, Loso Judijanto, Astuti Tri, Mariana, Rafika Uksi, Bawono
Icuk Rangga, Seran Adiutrix, Kristianto Giovanny, Amin Ahmad, & Masradin. (2024). Teori Akuntansi (Teori, Implementasi dan Perkembanganya) (Rianty Erfina, Ed.). PT. Green Pustaka Indonesia.
Kadek, N., Trisnadewi, A., Putu, L., Stie, P., & Dharma, S. (2022). (ST UDI KASUS PADA UMKM SARI MINA AYU) a. In Jurnal Ilmiah Akuntansi dan Bisnis (Vol. 7, Issue 1). http://journal.undiknas.ac.id/index.php/akuntansi
Kieso Donald E, Kimmel Paul D, & Weygandt Jerry J. (2015). Accounting Principles (McDonald Michale, Ed.; 12th ed.). Wiley.
Mustika, I. (2022). Analisa Kesiapan Usaha Mikro Kecil Dan Menengah Dalam Penyusunan Laporan Keuangan Sesuai Standar Akuntansi Keuangan dan Penerapan SAK EMKM Pada Laporan Keuangan UMKM. (Studi Kasus Pada UMKM Laundry Box di Kota Batam) (Vol. 3, Issue 2).
Pantare Alam, A., & Rio Rita, M. (2022). PENERAPAN SAK EMKM PADA UMKM: SURVEI PADA UMKM YANG BERADA DI KECAMATAN TINGKIR,
SALATIGA. Jurnal Visi Manajemen, 8(1).
Razali Geofakta, Syamil Ahmad, Hurit Roberta Uron, Asman Aulia, Lestariningsih, Radjawane Louise, Bagenda Christina, Falasifah Nihlatul, Amane Ade Putra, S Sumarni, Gultom Novianti, Fadhilatunisa Della, Fakhri M Miftach, & Rosidah. (2023). METODOLOGI PENELITIAN KUATITATIF, KUALITATIF, DAN KOMBINASI (Bahri Syaiful, Ed.). CV.
Media Sains Indonesia.
Romney Marshall B, Steinbart Paul John, Summers Scoutt L, & Wood David A. (2021). Accounting Information Systems. Pearson.
Samsu. (2021). METODOLOGI PENELITIAN (Teori dan Aplikasi Penelitian Kualitatif, Kuantitatif, Mixed Methods, serta Research & Development) (Rusmini, Ed.). Pusaka Jambi.
Saputra Novi Chandra, Hadiyat Yana Rochdiana, Dewi Putu Pande, Septiawan Budi, Kosadi Ferry, Fatah Khoirul, Budiadnyani Ni Putu, Herliansyah Yudhi, Putri Kompiang Martina, Musyaffi Ayatulloh Michael, Evayani, Rahmawati Indah, & Rikah. (2024). Sistem Informasi Akuntansi (Welly Yerisma, Ed.). CV. Media Sains Indonesia.
Sutikno M Sobry, & Hadisaputra Prosmala. (2020). Penelitian Kualitatif
(Nurlaeli, Ed.). Holistica.
Trixie, M. A., & Nugroho, H. (2024). Perancangan Aplikasi Sistem Pencatatan Transaksi Dan Pelaporan Keuangan Studi Kasus Pada UMKM Tauco Ci Enjon Tangerang.
Vidyasari Rahmanita, & Febriyan. (2022). Komputerisasi Pencatatan Akuntansi dan Pelaporan Keuangan berbasis Microsoft Excel pada UMKM Umita Food and Drink (Vol. 9, Issue 1).
Downloads
Published
2025-08-01
Issue
Section
Articles
How to Cite
Dashboard Data Analysis and Financial Reporting Based on Google Spreadsheet (Case Study of Bam’s Barbershop MSME). (2025). Proceeding of International Conference on Economics, Technology, Management, Accounting, Education, and Social Science (ICETEA), 1, 959-975. https://conference.unita.ac.id/index.php/icetea/article/view/438
