Constructing an FPMS in a medium-sized consulting company using a combination of an ERP system and Microsoft Excel

Anders Rom and Carsten Rohde

International Journal of Accounting and Finance, 2010, vol. 2, issue 1, 67-83

Abstract: This paper reports on a study on how Integrated Information Systems (IISs) support financial project management in a medium-sized consulting company. The study applies the case study method and the Constructive Research Approach (CRA). It was found that the Enterprise Resource Planning (ERP) system (an Online Transaction Processing (OLTP) system) primarily supports the task of data collection, while Microsoft Excel (an Online Analysis Processing (OLAP) system) can be used for reporting, budgeting and budget control. These two subsystems of the IIS are integrated with regard to ex post data stored in a common database. This allows access to real-time data throughout the IIS. However, some degree of disintegration exists as the project budgets are only stored in the spreadsheets, which presents a number of limitations with regard to reporting and analysis. The reason for using the combination of OLTP and OLAP systems is the need for flexibility and user-friendliness. Based on the findings, this paper expands the limited knowledge on how different kinds of systems support different management accounting tasks. The findings indicate that not only do OLTP systems support the management accounting of companies, but the user-friendliness and flexibility of OLAP systems also complement the OLTP systems in that respect.

Keywords: constructive research approach; enterprise resource planning; ERP; integrated information systems; management accounting; small and medium-sized enterprises; SMEs; consulting companies; consultancies; Microsoft Excel; online transaction processing; OLTP; data collection; online analysis processing; OLAP; budgeting; budgets; budgetary control; ex post data; common databases; real-time data; data storage; spreadsheets; reporting; flexibility; user-friendliness; financial project management systems; FPMS; accounting; finance. (search for similar items in EconPapers)
Date: 2010
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=31912 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:intjaf:v:2:y:2010:i:1:p:67-83

Access Statistics for this article

More articles in International Journal of Accounting and Finance from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().