ANALYSIS AND DESIGN OF ACCOUNTING INFORMATION SYSTEM DATABASE OF WERKUDARA NIRWANA SAKTI CO. LTD

Aldo Franco Karinda, Harke Revo Leonard Polii, Rifal Richard Pangemanan

Abstract


Abstrak

Penelitian ini bertujuan untuk mengembangkan database sistem informasi akuntansi untuk siklus transaksi pendapatan dan pengeluaran. Penelitian ini merupakan studi kasus pada Werkudara Nirwana Sakti Co. Ltd., sebuah perusahaan biro perjalanan dan event management yang masih menggunakan sistem akuntansi non-database. Penelitian ini menerapkan kerangka kerja REA (Resource-Event-Agent) dalam pemodelan basis data. Basis data dikembangkan dengan menggunakan metodologi FAST (Framework for The Application of Systems Technique). Selain FAST, kerangka kerja PIECES (Performance, Information, Economics, Control, Efficiency, Service) juga digunakan untuk menganalisis dan mengklasifikasikan masalah yang ada di Werkudara Nirwana Sakti Co. Ltd. Penelitian ini merupakan studi kasus dengan menggunakan data yang diambil dari dokumen, wawancara, dan observasi langsung. Hasil dari penelitian ini adalah sebuah rancangan basis data dalam bentuk ERD (Entity Relationship Diagram) dan diagram REA yang disesuaikan dengan kebutuhan data dan informasi akuntansi pada Werkudara Nirwana Sakti Co. Ltd.

Keywords: Resource-Event-Agent (REA), Framework for The Application of Systems Technique (FAST), PIECES, Accounting Information System, Database

Abstract

This research is to develop an accounting information system database for a revenue and expense transaction cycle. This research is a case study on Werkudara Nirwana Sakti Co. Ltd., a travel agency and event management company which is still using a non-database accounting system. This research applies the resource-event-agent (REA) framework in database modelling. The database is developed using FAST (Framework for The Application of Systems Technique) methodology. In addition to the FAST, the PIECES (Performance, Information, Economics, Control, Efficiency, Service) Framework is also used to analyze and classify problems in Werkudara Nirwana Sakti Co. Ltd. This research is a case study using data taken from documents, interviews, and direct observations. The result of this research is a custome database design in the ERD (Entity Relationship Diagram) and the REA diagram those which are adapted to the need of data and accounting information in Werkudara Nirwana Sakti Co. Ltd.

Keywords: Resource-Event-Agent (REA), Framework for The Application of Systems Technique (FAST), PIECES, Accounting Information System, Database

Full Text:

Download PDF

References


Bagranoff, N. A., Simkin, M. G., Norman, C. S. (2010). Core Concept of Accounting Information Systems, 11th Edition. Hoboken: John Wiley & Sons.

Batra, D. (2012). An Event-Oriented Data Modeling Technique Based on the Cognitive Semantics Theory. Journal of Database Management, 23(4): 52-74.

Brazel J. F., Dang L. (2008). The effect of ERP System Implementations on The Management of Earnings and Earnings Release Dates. Journal of Information Systems, 22:1–21.

Colmenares, L. (2008). Benefits of ERP Systems for Accounting and Financial Management. Allied Academies International Conference, vol. 13:1.

Dennis, A., Wixom, B.H., Roth, R. M. (2012). System Analysis and Design, 5th Edition. Hoboken: John Wiley & Sons.

Elliot, R.K. (1992). The Third Wave Break on the Shore of Accounting. Accounting Horizon, vol. VI/2, page:61.

Essex, P. A. (1997). The Use of Databases to Enhance Accounting Information. Ohio CPA Journal, Feb 1997: 56, 1.

Gartner (2015). Gartner Says Worldwide IT Spending on Pace to Grow 2.4 percent in 2015. taken from: http://www.gartner.com/newsroom/id/2959717. [diakses tanggal 30 September 2015].

Kasik, J., Hunka, F. (2011). Business Process Modelling using REA Ontology. Economics and Management, 2011:16.

Laurier, W., Poels, G. (2012). Track and Trace Future, Present, and Past Product and Money Flows with a Resource-Event-Agent model. Information System Management, 29:123-136.

McCarthy, W.E. (1982). The REA Accounting Model: A Generalized Framework for Accounting System In A Shared Data Environment. The Accounting Review, vol. 57:3.

O'Leary, D.E. (2000) Enterprise Resource Planning Systems: Systems, Life Cycle, Electronic Commerce, and Risk. Cambridge: Cambridge University Press.

Poels, G., Maes, A., Gailly, F., Paemeleire, R. (2011). The Pragmatic Quality of Resources-Events-Agents diagrams: An Experimental Evaluation. Information System Journal, 21:63-89.

Post, G.V. (2011). Database Management System: Designing and Building Business Application, 5th Edition. Diunduh dari jerrypost.com.

Romney, M.B., Steinbart, P.J. (2012). Accounting Information System, 10th Edition. Upper Saddle River: Prentice Hall.

Sutton S.G., Arnold, V. (2002). Foundations and Frameworks for AIS research. In: Arnold V, Sutton SG, editors. Researching Accounting as An Information Systems Discipline. American Accounting Association, p. 3-10.

Stephens, R. (2009). Beginning Database Design Solutions. Indiana Police: Wiley Publishing.

Vaassen, E.H.J, Hunton, J.E. (2009). An Eclectic Approach to Accounting Information Systems. International Journal of Accounting Information Systems, 10:173–6.

Vymetal, D., Hunka, F., Hucka, M., Kasik, J. (2010). Enterprise Modeling Based on Combination of Process and REA Value Chain Perspective. Journal of Advanced Research in Management, vol 1 issue 2(2).

Weigand, H., Elsas, P. (2012). Model-Based Auditing Using REA. International Journal of Accounting Information System, vol 13: 287-310.

Whitten, J., Bentley, L. (2007). System Analysis and Design Methods. New York: McGraw Hill.




DOI: https://doi.org/10.37531/sejaman.v6i2.5385

Refbacks

  • There are currently no refbacks.


Flag Counter

Creative Commons License

S E I K O : Journal of Management & Business is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
 
© All rights reserved 2018. S E I K O : Journal of Management & Business - ISSN (Print) : 2598-831X, ISSN (Online) : 2598-8301.
 

Web
Analytics