IDEAS home Printed from https://ideas.repec.org/a/ids/intjaf/v2y2010i1p67-83.html
   My bibliography  Save this article

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

Author

Listed:
  • Anders Rom
  • Carsten Rohde

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.

Suggested Citation

  • Anders Rom & Carsten Rohde, 2010. "Constructing an FPMS in a medium-sized consulting company using a combination of an ERP system and Microsoft Excel," International Journal of Accounting and Finance, Inderscience Enterprises Ltd, vol. 2(1), pages 67-83.
    • Handle: RePEc:ids:intjaf:v:2:y:2010:i:1:p:67-83
    as

    Download full text from publisher

    File URL: http://www.inderscience.com/link.php?id=31912
    Download Restriction: Access to full text is restricted to subscribers.
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:ids:intjaf:v:2:y:2010:i:1:p:67-83. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sarah Parker (email available below). General contact details of provider: http://www.inderscience.com/browse/index.php?journalID=231 .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.