The Design of An Accounting Information System Based on VBA Macros in Microsoft Excel

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.