University of Twente Student Theses

Login

The risks and benefits of spreadsheet-based financial reporting as a form of shadow it in complex information systems: an action design research leading to the FRASIT-framework

Berg, D.A. van den (2015) The risks and benefits of spreadsheet-based financial reporting as a form of shadow it in complex information systems: an action design research leading to the FRASIT-framework.

This is the latest version of this item.

[img]
Preview
PDF
2MB
Abstract:FoodCorp (pseudonym) experiences problems with the process of generating the required financial information out of the available data. Problems regarding efficiency in terms of finding the data, transforming data into the required reports and the assurance that the data is complete and correct. Both for financial accounting and managerial accounting. The organization uses one Enterprise Resource Planning system for all financial administration, a Business Intelligence (Cognos) system for data aggregation and reports and further, lots of spreadsheets (Microsoft Excel) for creating finalized reports. Although Excel-reporting is very flexible for the end-user, it has a fundamental limitation. Excel is in essence a spreadsheet program and not a completely managed and secured reporting and Business Intelligence solution. The goal of this research is twofold. First, this study aims at solving a practical problem for FoodCorp. Second, a four phase framework is designed using the method Action Design Research that aids in analyzing a financial reporting architecture and arrive at a reporting architecture without shadow IT. This framework is called the 'Financial Reporting Architecture without Shadow IT (FRASIT)'-framework. This framework is further developed to include four design principles which can be applied to other organizations to improve the financial reporting process, where ERP, BI, spreadsheets and/or end-user financial reporting software is present to transform data into reports.
Item Type:Essay (Master)
Faculty:BMS: Behavioural, Management and Social Sciences
Subject:54 computer science, 85 business administration, organizational science
Programme:Business Administration MSc (60644)
Link to this item:http://purl.utwente.nl/essays/66905
Export this item as:BibTeX
EndNote
HTML Citation
Reference Manager

 

Repository Staff Only: item control page