Design of the Simple Receipt Application to Minimize Errors and Increase Work Efficiency of the Assistant Expenditure Treasurer
- 10.2991/aer.k.201221.092How to use a DOI?
- Assistant Expenditure Treasurer, receipt application, Microsoft Excel
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.
- © 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/).
Cite this article
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 -