Design of a Web-Based Accounting Information System for Sales and Inventory Recording Using MySQL at UMKM Abadi Asikin
1Gita Ismi Fauziah, 2Ida Farida*, 3Aryanto
1,2,3Department of accounting, Politeknik Harapan Bersama, Tegal, Jawa Tengah, Indonesia
https://doi.org/10.47191/jefms/v8-i3-44ABSTRACT:
Abadi Asikin is a Micro, Small and Medium Enterprise (MSME) engaged in the production of crackers. However, until now Abadi Asikin MSME has not made records, making it difficult to find out information related to sales and inventory of goods owned. The purpose of this study is to design a website-based sales accounting and inventory recording information system using MySQL at MSME Abadi Asikin. The research design in this final assignment uses descriptive research methods with a qualitative approach. The development method used to create a system is the Software Development Life Cycle (SDLC) with a waterfall model. Based on the results of testing using the blackbox testing method through a functional testing approach carried out by media experts and material experts, the system can run according to its function. So, it can be concluded that researchers have successfully designed a website-based sales accounting and inventory recording information system using MySQL and this system is feasible to use or operate.
KEYWORDS:
Accounting Information System; Income transactions; Inventory system; MySQL; MSME's Business.
REFERENCES:
1) Ariana, A. A. G. B., Mulya, K. S., Supartha, I. K. D. G., Ariantini, M. S., Ermanuri, Anggaeni, A. F., Rahayu, N. M. A., Octaviany, F., Pramawati, I. D. A. A. T., & Magribi, R. M. (2023). Sistem Informasi Akuntansi Pengantar & Penerapan SIA Berbagai Sektor (Sepriano & Efitra (eds.); Issue May). Jambi : Sonpedia Publishing Indonesia.
2) Dewi, N. P. N. K., Dharma, A. M., & Paramitha, A. A. I. I. (2023). Analisis dan Perancangan Sistem Informasi Penjualan dan Pengelolaan Persediaan Pada PT Alfajores Bali Enak Menggunakan Metode Waterfall. SMART TECHNO (Smart Technology, Informatics and Technopreneurship), 5(1), 59–64. https://doi.org/10.59356/smart-techno.v5i1.80
3) Farida, I., & Setiawan, D. (2024). The nexus between management control systems, firm performance, green innovation and social media networking in Indonesian real estate companies. Innovation and Management Review. https://doi.org/10.1108/INMR-04-2023-0056
4) Farida, I., Sunandar, & Aryanto. (2019). Faktor-faktor yang berpengaruh terhadap kinerja UMKM di Kota Tegal. Jurnal Monex, 8(2), 79–82.
5) Farida, I., & Sutopo, B. (2023). the Nexus Between Digital Innovation Technology and Competitive Advantage: Mediated By Management Business Strategy. Corporate Governance and Organizational Behavior Review, 7(1), 18–28. https://doi.org/10.22495/cgobrv7i1p2
6) Fatiyah, H., Lestari, O. R., & Romadhan, G. (2020). PERANCANGAN SISTEM INFORMASI PERSEDIAAN OBAT BERBASIS WEB PADA APOTEK DERMAPINK TEMBESI. JAAB : Jurnal of Applied Accounting And Business, 2(1), 33-101–108.
7) Giovani, S., & Novianty, I. (2020). Perancangan Aplikasi Sistem Informasi Akuntansi Persediaan Barang Menggunakan Microsoft Access 2016 (Studi Kasus Toko Villi Bandung). Indonesian Accounting Literacy Journal, 1(1), 169–187.
8) Prabowo, R., Singgih, M. L., Karningsih, P. D., & Widodo, E. (2020). New product development from inactive problem perspective in indonesian SMEs to open innovation. Journal of Open Innovation: Technology, Market, and Complexity, 6(1). https://doi.org/10.3390/JOITMC6010020
9) Prakasita N, D., & Nugroho, M. A. (2018). Perancangan Sistem Informasi Akuntansi Penjualan Dan Persediaan Di Central Steak and Coffee Boyolali. Nominal, Barometer Riset Akuntansi Dan Manajemen, 7(1), 69–81. https://doi.org/10.21831/nominal.v7i1.19360
10) Putri, N. K., & Maghfiroh, S. (2022). Implementation Of Accounting Information Systems By Small And Medium Enterprises In Banyumas. JAS (Jurnal Akuntansi Syariah), 6(1), 83–92. https://doi.org/10.46367/jas.v6i1.566
11) Rohman, A., & Bhakti, H. D. (2023). Perancangan Sistem Informasi Persediaan Barang Berbasis Web. Syntax Literate ; Jurnal Ilmiah Indonesia, 7(9), 15304–15313. https://doi.org/10.36418/syntax-literate.v7i9.14255
12) Rusly, F. H., Talib, Y. Y. A., Hussin, M. R. A., & Mutalib, H. A. (2021). Modelling the internal forces of smes digital adaptation strategy towards industry revolution 4.0. Polish Journal of Management Studies, 24(1), 306–321. https://doi.org/10.17512/pjms.2021.24.1.18
13) Shim, T. S., Pae, S. J., & Choi, E. (2020). The effects of auditor designation by the regulator on auditor decisions: Evidence from Korea. Behavioral Research in Accounting, 32(1), 21–36. https://doi.org/10.2308/bria-52629
14) Tsai, C. H., & Peng, K. J. (2017). The FinTech Revolution and Financial Regulation: The Case of Online Supply-Chain Financing. Asian Journal of Law and Society, 4(1), 109–132. https://doi.org/10.1017/als.2016.65
15) Widiyanti, W., & Wibowo, A. (2021). Sistem Informasi Akuntansi Penjualan Dan Persediaan Barang Pada Toko Dua Putri Pekanbaru. Jurnal Ilmu Komputer Dan Bisnis, 12(1), 116–132. https://doi.org/10.47927/jikb.v12i1.97
