University of Twente Student Theses
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.
|
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: | https://purl.utwente.nl/essays/66905 |
| Export this item as: | BibTeX EndNote HTML Citation Reference Manager |
Show download statistics for this publication
Show download statistics for this publicationRepository Staff Only: item control page