Perancangan dan Implementasi Sistem Pengendalian Manajemen Berbasis Microsoft Access pada Pengelolaan Keuangan PT. Vibe Akademik Bahasa
DOI:
https://doi.org/10.56910/safari.v5i2.3417Keywords:
Company Performance, Financial Management, Information System, Management Control, Microsoft AccessAbstract
Financial data management at PT. Vibe Akademik Bahasa was previously done manually using Microsoft Excel, which resulted in inefficiency and delays in calculations and reporting. To overcome this problem, this activity designed a management control system using Microsoft Access that automates student data recording, payment transactions, and the issuance of invoices and financial reports. This activity used observation, interviews, and document analysis to identify user needs, followed by system design that included the design of data input forms and payment transactions. The resulting system enables automatic invoice issuance based on student identification numbers, supports payment recording, and provides real-time profit and loss reports that can be accessed by partner institutions. This implementation demonstrates that a database-based management control system can improve accuracy, timeliness, and transparency in financial data management. Further activities are recommended to enhance the system with web-based access, multi-user functionality, and integration with other financial tools to improve operational efficiency and scalability.
References
Andarista, M. M. A. (2023). Studi perencanaan lampu penerangan jalan (PJU) di jalan utama penghubung Kecamatan Udanawu dan Kecamatan Ponggok Kabupaten Blitar. Journal of Science Nusantara, 3(1), 1–12. https://doi.org/10.28926/jsnu.v3i1.778
Andrian, R., & Sa’di, A. (2024). Implementation of Telegram bot notification on network device monitoring system. SISTEMASI, 13(1), 74. https://doi.org/10.32520/stmsi.v13i1.3110
Anisya, A., Fajrin, F., Warman, I., Minarni, M., Syahrani, A., & Nugroho, F. (2025). Development of WebGIS for street light mapping using geospatial tools. Jurnal Teknik Informatika (JUTIF), 6(4), 1941–1956. https://doi.org/10.52436/1.jutif.2025.6.4.4777
Ayu Fitria Putri, Anggraini, W., & Fuadah, L. L. (2024). The relevance of management control systems in the business environment and the role of digitalization in transformation for sustainability: A comprehensive literature review. International Journal of Economics, Accounting and Management, 1(4), 226–233. https://doi.org/10.60076/ijeam.v1i4.890
Badrul, M. (2021). Penerapan metode waterfall untuk perancangan sistem informasi inventory pada Toko Keramik Bintang Terang. PROSISKO: Jurnal Pengembangan Riset dan Observasi Sistem Komputer, 8(2), 57–62. https://doi.org/10.30656/prosisko.v8i2.3852
Edirisinghe, U. C., Hossain, M. M., & Alam, M. (2025). Sustainability integration in management control systems: Evidence from a developing country. Journal of Management Control. https://doi.org/10.1007/s00187-025-00395-8
Enriko, I. K. A., Gustiyana, F. N., Kurnianingsih, K., & Puspita Sari, E. L. I. (2023). LoRaWAN for smart street lighting solution in Pangandaran Regency. JOIV: International Journal on Informatics Visualization, 7(4), 2452. https://doi.org/10.62527/joiv.7.4.1198
Fähndrich, J. (2023). A literature review on the impact of digitalisation on management control. Journal of Management Control, 34(1). https://doi.org/10.1007/s00187-022-00349-4
Franco-Santos, M., Kennerley, M., Micheli, P., Martinez, V., Mason, S., Marr, B., Gray, D., & Neely, A. (2007). Towards a definition of a business performance measurement system. International Journal of Operations and Production Management, 27(8), 784–801. https://doi.org/10.1108/01443570710763778
Granlund, M., & Malmi, T. (2002). Moderate impact of ERPS on management accounting: A lag or permanent outcome? Management Accounting Research, 13(3), 299–321. https://doi.org/10.1006/mare.2002.0189
Heri Khariono, Parlika, R., Kusuma, H. A., & Setyawan, D. A. (2021). Pemanfaatan bot Telegram sebagai e-learning ujian berbasis file. Jurnal Informatika Polinema, 7(4), 65–72. https://doi.org/10.33795/jip.v7i4.696
Ihramsyah, I., Yasin, V., & Johan, J. (2023). Perancangan aplikasi sistem informasi penjualan makanan cepat saji berbasis web: Studi kasus Kedai Cheese.Box. Jurnal Widya: Akademi Manajemen Informatika Komputer Widyaloka, 4(1), 117–139.
Ismail. (2024, Desember 15). Keluhkan minimnya penerangan lampu di Jalan Pontianak–Sungai Kakap, kendati pajak penerangan dikenakan 10%. Media Kalbar.
Itan, I., & Meiviana, M. (2024). Implementasi sistem akuntansi keuangan berbasis Microsoft Access pada UMKM Marina Samudra Stationery. Journal of Human and Education (JAHE), 4(4), 777–787. https://doi.org/10.31004/jh.v4i4.1323
Ivan Rio Setiadi, Hariyanto, S., & Widyastuti Kusuma, L. (2024). Sistem penerangan lampu jalan otomatis berbasis Internet of Things menggunakan sensor cahaya dengan Telegram. ALGOR, 5(2), 20–29. https://doi.org/10.31253/algor.v5i2.2356
Kurniadin, N., Prasetya, F. V. A. S., Hadi, P. K. S., & Feri, W. (2023). Pemanfaatan sistem informasi geografis berbasis web (WebGIS) untuk pemetaan aset lahan dan bangunan Politeknik Pertanian Samarinda. Jurnal Sains Informasi Geografi, 6(1), 20. https://doi.org/10.31314/jsig.v6i1.1359
Kusuma, A. P., Rahmat, M. F., & Rofiq, A. A. (2023). Analisis pengujian sistem pengiriman barang menggunakan black box testing. J-INTECH, 11(2), 287–293. https://doi.org/10.32664/j-intech.v11i2.999
Maulana Malik Ibrahim, & Silvino Violita, E. S. V. (2023). Perancangan sistem pengendalian manajemen berdasarkan Four Levers of Control pada start-up (Studi kasus pada Start-up XYZ). Jurnal Wahana Akuntansi, 18(1), 105–127. https://doi.org/10.21009/wahana.18.017
Mohaidin, N. J. (2025). Digital transformation in financial reporting: Institutional pressures shaping eXtensible Business Reporting Language implementation in...
Mufidatul Ummah, Z. (2025). Perancangan sistem pengaduan kerusakan infrastruktur berbasis geographic information system pada Kelurahan Bulakan. Jurnal Informatika dan Teknik Elektro Terapan, 13(3). https://doi.org/10.23960/jitet.v13i3.6862
Mukmin, M., Purnawansyah, P., & Hasnawi, M. (2022). Notifikasi bot Telegram untuk monitoring jaringan pada Kementerian Kelautan dan Perikanan Untia. Buletin Sistem Informasi dan Teknologi Islam, 3(2), 127–133. https://doi.org/10.33096/busiti.v3i2.1162
Nabila, O. L., Asliana, E., & Ridwansyah, E. (2022). Pembuatan sistem laporan keuangan sederhana berbasis Microsoft Access untuk usaha mikro, kecil, dan menengah. Jurnal Ilmiah ESAI, 16(1), 23–32. https://doi.org/10.25181/esai.v16i1.2409
Nugraha, A. E., Pramudya, E. R., & Abdussalam, A. (2025). Web-based public street lighting complaint application with realtime WhatsApp notification using prototype method in Pemalang Regency. Journal of Applied Intelligent System, 9(1), 172–183. https://doi.org/10.62411/jais.v9i1.10445
Pacheco, A., Yupanqui, R., Mogrovejo, D., Garay, J., & Uribe-Hernández, Y. (2025). Impact of digitization on educational management: Results of the introduction of a learning management system in a traditional school context. Computers in Human Behavior Reports, 17. https://doi.org/10.1016/j.chbr.2025.100592
Panji Christyan Wijaya, W., & Mizanul Achlaq, M. (2024). Implementasi API bot Telegram untuk sistem notifikasi LibreNMS pada perusahaan BLIP Integrator. JATI (Jurnal Mahasiswa Teknik Informatika), 7(6), 3152–3159. https://doi.org/10.36040/jati.v7i6.7991
Purnama, R. W., Desriyanti, D., & Kurniawan, E. (2020). Monitoring battery lighting and public street light (PJU) with Telegram-based information system microcontroller. JEEE-U (Journal of Electrical and Electronic Engineering-UMSIDA), 4(2), 181–189. https://doi.org/10.21070/jeeeu.v4i2.838
Purwianti, L., & Chan, K. R. (2025). Implementasi penggunaan sistem Microsoft Access untuk pengelolaan keuangan pada UMKM OLA. Jurnal Pengabdian Kepada Masyarakat Nusantara, 6(1), 530–539.*
Rahi, A. F., Johansson, J., Fagerström, A., & Blomkvist, M. (2022). Sustainability reporting and management control system: A structured literature review. Journal of Risk and Financial Management, 15(12). https://doi.org/10.3390/jrfm15120562
Ratnasari, R., Hafiizah, N., Erdiani, N. W., & Hari Wibowo, A. (2024). Implementasi sistem client-server berbasis Flask dan MySQL untuk pengelolaan data mahasiswa dengan protokol TCP/IP. JATI (Jurnal Mahasiswa Teknik Informatika), 8(6), 12577–12582. https://doi.org/10.36040/jati.v8i6.11999
Saman. (2025). Financial management strategy for micro, small and medium enterprises post-pandemic: A qualitative approach based on interviews with MSME actors. International Journal of Business, Management, and Innovation Review, 2(3), 10–21. https://doi.org/10.62951/ijbmir.v2i3.159
Sari, Y., & Riyansah, H. (2021). Aplikasi tracking pedagang keliling dengan GPS Google Maps API berbasis Android. IKRAITH-INFORMATIKA, 5(3), 178–191.*
Vina, P., & Al, E. (2025). The effect of management information system implementation on the effectiveness of decision making in educational settings. Unpublished manuscript.
Wijayanti, D., & Cahyadi, R. T. (2024). Management control system design and innovation: A systematic literature review. Jurnal Economia, 20(3), 419–432. https://doi.org/10.21831/economia.v20i3.57511
Wirabuana, S., & Papilaya, F. S. (2020). Using operational dashboard for ArcGIS as a solution for monitoring of public street lighting. Journal of Applied Geospatial Information, 4(1), 283–288. https://doi.org/10.30871/jagi.v4i1.1926.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 SAFARI :Jurnal Pengabdian Masyarakat Indonesia
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
