Abstract

Some MSMEs still use traditional accounting records. Apart from being inefficient, this can also increase the risk of errors in recording and reporting accounting made, and the impact can be detrimental to the MSMEs themselves, especially if the accounting system that is run has not fulfilled SAK EMKM. This study aims to design a sales accounting system application at Reglow by Bundami Distributor. This research uses the Research and Development (R&D) method. The data collection techniques used are observation, interviews, and questionnaires. This research uses the waterfall model, which is a software development process that is carried out sequentially. The Blackbox testing method is also used to test this system, in addition to the validation process from material experts and media experts as well as trials at Reglow by Bundami Distributors. The results of this study conclude that the accounting system created can generate sales reports, total net sales, the number of products sold, and all types of products available. The practical contribution of these findings can help overcome problems regarding sales that have occurred so far, by building a vba macro-based sales information system and can streamline work in the company's sales administration activities.

Keywords:

Accounting information system, Digitisation of accounting, Macro VBA, Waterfall model

References:

1) Amin, M. Al, Sungkono, & Jaya, IMLM (2021). DETERMINANTS OF IMPLEMENTATION OF MSME ACCOUNTING IN YOGYAKARTA. Axiom Accounting Research Journal, 20(2), 91–107. https://doi.org/10.29303/aksioma.v20i2.134

2) Arianti, BF (2020). The Influence of Income and Financial Behavior on Financial Literacy Through Investment Decisions as an Intervening Variable. Journal of Accounting, 10(1), 13–36. https://doi.org/10.33369/j.akuntansi.10.1.13-36

3) Biby, S., Asbar, Y., & Jufridar. (2023). The Analysis of the Green Economy Implementation on Sustainability of Small and Medium Enterprises in Lhokseumawe City. JOURNAL OF MANAGEMENT AND BUSINESS ECONOMICS, 24(1), 31–37.

4) Dewi, NHU, & Nur'aini Rokhmania. (2021). Investment in Accounting Information Systems, Financial Performance and Productivity of Malmquist and IFR as Intervening in the Banking and Financial Industry. JOURNAL OF ASSETS (ACCOUNTING RESEARCH), 13(1), 63–71.

5) Halim, A. (2020). The Influence of the Growth of Micro, Small and Medium Enterprises on the Economic Growth of Mamuju Regency. Scientific Journal of Development Economics, 1(2), 157–172. https://stiemmamuju.e-journal.id/GJIEP/article/view/39

6) Divine, ME, & Jaya, IMLM (2020). THE REALITY OF OBSTACLES OF IAS 41 LISTING (BIOLOGICAL ASSETS) FOR FISHERY AND LIVESTOCK MSMEs IN EAST JAVA. Gorontalo Accounting Journal (GAJ, 3(2), 94–104.

7) Ismiwati, B., Chaidir, T., & S, IAP (2022). EMPOWERING WOMEN TRADERS THROUGH INCREASING LITERACY AND FINANCIAL INCLUSION IN EAST MATARAM DISTRICT, MATARAM DISTRICT, MATARAM CITY. INDEPENDENT ABDIMAS Journal, 3(2), 38–46. https://doi.org/https://doi.org/10.29303/independent.v3i2.234

8) Kesuma Jaya, MSA, Gumilang, P., Wati, T., Andersen, YP, & Desyani, T. (2019). Black Box Testing on the Decision Support System Application for Selection of Candidates for Civil Servants Using the Equivalence Partitions Technique. Pamulang University Journal of Informatics, 4(4), 131. https://doi.org/10.32493/informatika.v4i4.3834

9) Puspitawati, L., Hilmi, & Novitasyari, A. (2021). Organizational Factors on the Quality of Financial Applications in Insurance Companies Lilis. ASET Journal (Accounting Research, 13(2), 197–210.

10) Riski, AD (2022). Waterfall Model Analysis: Definition, Stages, Advantages and Disadvantages. https://osc.medcom.id/community/analysis-model-waterfall-pengertian-phase-kebesaran-dan-kekurangan-4352

11) Sugiyono. (2018). Quantitative, Qualitative, and R&D Research Methods. Alphabet.

12) Zakariah, MA, Afriani, V., & Zakariah, KM (2020). QUALITATIVE, QUANTITATIVE, ACTION RESEARCH, RESEARCH AND DEVELOPMENT (R n D) RESEARCH METHODOLOGY. Al Mawaddah Warrahmah Kolaka Islamic Boarding School Foundation. https://books.google.co.id/books?id=k8j4DwAAQBAJ&hl=en&source=gbs_navlinks_s