Design of the Simple Receipt Application to Minimize Errors and Increase Work Efficiency of the Assistant Expenditure Treasurer

DOI

10.2991/aer.k.201221.092How to use a DOI?

Keywords

Assistant Expenditure Treasurer, receipt application, Microsoft Excel

Abstract

The use of expenditure receipts at the Inspectorate considered having a low level of efficiency due to impracticality and recording errors that are often found in recipient data, resulting in wrong recipients of activity funds. This error was caused by the Microsoft Excel system being used was still manual and had not yet maximised the available Microsoft Excel functions and features. Therefore, the researcher intends to update the method used by using available formulas and features. This study uses a research and development approach method. The research that carried out resulted in a Microsoft Excel-based assistant treasurer receipt application with the formula VlookUp, Excel Add-Ins, Hyperlink, and VBA Macro Excel. The simple receipt application that made produces five application menus; namely the main menu, receipt menu, transaction data history menu, an application supporting data menu, and menus around the application.

Copyright

© 2020, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Pau Lim
AU  - Ira Novianty
PY  - 2020
DA  - 2020/12/22
TI  - Design of the Simple Receipt Application to Minimize Errors and Increase Work Efficiency of the Assistant Expenditure Treasurer
BT  - Proceedings of the International Seminar of Science and Applied Technology (ISSAT 2020)
PB  - Atlantis Press
SP  - 560
EP  - 565
SN  - 2352-5401
UR  - https://doi.org/10.2991/aer.k.201221.092
DO  - 10.2991/aer.k.201221.092
ID  - Lim2020
ER  -