Analisis Kebutuhan Pengguna Untuk Perancangan Aplikasi Database Laporan Keuangan Dengan Menggunakan Microsoft Access untuk UMKM
DOI:
https://doi.org/10.30630/aista.v3i2.78Keywords:
Aplikasi, Database, Microsoft Access, Laporan Keuangan, SAK EMKMAbstract
Based on the observations conducted in the field, the financial recording in the company under study is still performed using a manual method, specifically through handwritten entries in a cash book. This recording process is limited to cash flow management, which includes tracking incoming and outgoing funds. To evaluate the availability of goods for purchase or sale, the business owner conducts physical checks at the storage location. Consequently, each transaction requires additional time for verification. In some cases, the owner is unaware that the requested inventory has run out during a sales transaction. This situation poses a significant obstacle for the owner in managing business operations. In response to the findings and issues faced, a simple accounting recording method that can directly generate financial reports using Microsoft Access is necessary. This research adopts a qualitative approach to gain a comprehensive understanding of user needs. The methods employed include interviews with the owner and analysis of the collected data and information. The study is conducted on a small and medium-sized enterprise (SME) in Padang that still utilizes a simple financial recording system. The outcome of this research is the creation of a database application for preparing financial reports designed according to user analysis needs
References
Arif, S. &. (2018). Perancangan Sistem Informasi Gudang Obat Pada Rumah Sakit Umum Islam Madinah Kasembon Malang. CESS: Journal of Computer Engineering, System and Science, Vol. 3 No. 1, 23-27.
Bahri, S. (2016). Pengantar Akuntansi. Yogyakarta: Penerbit Andi.
Davis, F. D. (1989). Perceived Usefulness, Perceived Ease of Use, and User Acceptance of Information Technology. MISS Quarterly.
Harahap, S. S. (2013). Analisis Kritis atas Laporan Keuangan. Jakarta: PT Raja Grafindo Persada.
Ikatan Akuntan Indonesia. (2016). Standar Akuntansi Keuangan Entitas Mikro, Kecil dan Menengah. Jakarta: Ikatan Akuntan Inodonesia.
Ismail, N. A., & King, M. (2014). Factors Influencing the Adoption of CLoud Computing in SMEs. International Journal of Business and Management, 9(1), 1-12.
Kementerian Koperasi dan UKM. (2021). Statistik UMKM. Retrieved from https://www.kemenkopukm.go.id/data-umkm
Laudon, K. C. (2020). Management Information Systems: Managing the Digital Firm. Pearson.
M. Sholihin., A. Y. (2020). Analisis Penerapan Sistem Informasi Akuntansi pada UMKM di Indonesia. Jurnal Akuntansi dan Keuangan, 45-58.
Maharsi, S. (2000). Pengaruh Perkembangan Teknologi Informasi Terhadap Bidang Akuntansi Manajemen. Jurnal Akuntansi dan Keuangan, 2 No. 2, 127-137.
Nielsen, J. (2000). Designing Web Usability: The Practice of Simplicity. New Riders Publishing.
Ningtiyas, J. D. (2016). Penyusunan Laporan Keuangan UMKM Berdasarkan Standar Akuntansi Keuangan Entitas Mikro, Kecil, dan Menengah (SAK – EMKM) (Study Kasus di UMKM Bintanng Malam Pekalongan. Riset & Jurnal Akuntansi, Vol. 2 No. 1, 11-17.
Pentiana, D. (2017). Design Application For Preparation Of Financial Statements Using Microsoft Access In The Cooperative Cooperation Of Tani . Prosiding Seminar Nasional Pengembangan Teknologi Pertanian, 285-291.
Prawita, Y. S. (2021). Analysis of the Application of SAK EMKM on MSMEs at Wildan Shops in Talang Kuning Village, Teras Terunjam District, Mukomuko Regency, Bengkulu Province. Journal of Indonesian Management (JIM), Vol. 1 No. 2, 115-119.
Rachmadanti, E. &. (2019). Penyusunan Laporan Keuangan Menggunakan Microsoft Access Pada UMKM Bengkel Hade Motor. Yogyakarta: Universitas Gadjah Mada.
Ria, A. (2018). Analisis Penerapan Aplikasi Keuangan Berbasis Android pada Laporan Keuangan UMKM Mekarsari Depok. Jurnal Sosio e-kons, Vol. 10 No. 3, 207-2019.
Sari, D. P., & Rahadjo, B. (2019). The Influence of Accounting Informastion System on the Performance of SMEs. Jounral of Economics and Business, 2(1), 45-56.
Surya, F. d. (2023). Desain Aplikasi Database Sistem Informasi Akuntansi Sekolah pada Yayasan Ainur Rahmah. Akuntansi dan Manajemen, Vol. 18 No. 1, 73-80.
Uno, O. O., Kalangi, L., & Pusung, R. J. (2019). Analisis Penerapan Standar Akuntansi Keuangan Entitas Mikro, Kecil, Dan Menengah (Sak Emkm) Pada Usaha Mikro, Kecil, Dan Menengah (Studi Kasus Pada Rumah Karawo Di Kota Gorontalo). Jurnal EMBA: Jurnal Riset Ekonomi, Manajemen, Bisnis dan Akuntansi, Vol. 7 No. 3, 3887-3898.
Widyanita, R. R. (2018). Pengembangan Aplikasi Penerimaan dan Pengeluaran Kas Berbasis Microsoft Access Sebagai Sarana Pelayanan Business Centre Bank Mini Barokah SMK Batik 2 Surakarta. Surakarta
