Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ ZENODOarrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
ZENODO
Article . 2024
License: CC BY
Data sources: ZENODO
ZENODO
Article . 2024
License: CC BY
Data sources: Datacite
ZENODO
Article . 2024
License: CC BY
Data sources: Datacite
versions View all 3 versions
addClaim

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

Authors: Nisa'ul Barkah,; Ida Farida,; Arifia Yasmin,;

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

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.

Related Organizations
Keywords

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

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
Green