全文摘录自2014 gtnews: FP&A TECHNOLOGY SURVEY
2014gtnews FP&A Technology Survey
In March 2014, gtnews sent out a 20-question survey to its corporate practitioner FP&A subscribers which garnered 224 responses that form the basis for this report. Many of the 224 respondent companies have operations that span the globe and do business across multiple regions. A third of survey respondents (34 percent) are from the Asia Pacific region, nearly a third (31 percent) from North America, about one-fourth from Europe (24 percent) and 11 percent from various countries in the African subcontinent. In terms of industry representation, respondents represent a range of sectors. For more information about the profile of survey respondents, as well as the survey itself, please see page 19 of this report. gtnews thanks Workiva for its underwriting support of the 2014 gtnews FP&A Technology Survey. The research department of the Association for Financial ProfessionalsR (AFP), which owns gtnews, designed and implemented the survey questionnaire and analysed the results. gtnews is solely responsible for the content of this report.
Executive Summary: Survey Highlights
The key findings of the 2014 gtnews FP&A Technology Survey include:
FP&A-related Technology Support
- Fifty-three percent of organisations do not currently use a specific FP&A technology system designed to provide analytical support to the function. Only 37 percent use such a dedicated system, with the balance of respondents indicating they are “not sure.”
- Only one-third of respondents (33 percent) report being satisfied with their organisations’ FP&A-related technology support, and 27 percent of respondents are actively dissatisfied.
- Respondents from the 53 percent of organisations that do not currently employ a specific FP&A system indicate they rely primarily upon Microsoft’s Excel software or a similar spreadsheet program. Slightly more than 40 percent of all respondents report that their organisations use Excel and other non-related FP&A systems in some form, while only five percent indicate that they solely utilise non-FPA-related systems.
FP&A Systems Deployed
- Three-quarters (76 percent) of the organisations that do use specific FP&A systems employ traditional ‘Tier 1’ vendor systems such as those of Cognos TM1 (IBM), Hyperion Planning (Oracle) and SAP BPC (SAP). The remainder of FP&A professionals rely on systems developed by smaller, alternative system providers.
- Over half (53 percent) of the organisations that have implemented specific FP&A systems consider them to be effective, indicating there is room for improvement in the development of specific standalone FP&A software.
Use of Excel and Other Spreadsheets
- A majority of the 224 survey respondents (73 percent) report that Excel is used for more thanhalf of the analytical work at their organisations.
- eight percent of financial professionals consider spreadsheet programs effective when sorting through and interpreting large amounts of data; at the same time, 22 percent are displeased with the effectiveness of Excel and other spreadsheet programs when handling data.
- Forty-three percent of survey respondents report Excel is effective in supporting the analytical work for their companies’ FP&A functions.
- The prime challenge organisations face most often during a typical monthly FP&A reporting cycle is the amount of time spent on identifying and correcting errors in spreadsheet programs.
- Excel is used 58 percent of the time for FP&A-related reporting.
Important Desired Functionalities in a FP&A Support System
- Ninety-one percent of survey respondents cite “accurate reporting” as an important attribute
in an organisation’s FP&A support system; 92 percent also indicate “efficient reporting” as a
crucial functionality in any technology system.
Barriers to Greater Investment in FP&A Support Systems
- Budget constraints have prevented greater investment in FP&A systems at 50 percent oforganisations; in 40 percent of companies, lack of IT support is an obstacle.
gtnews, is a major global knowledge resource for over 50,000 treasury, finance, payments and cash management professionals. Online, gtnews is updated daily and a weekly e-newsletter provides subscribers with access to an archive of almost 8,000 global treasury articles in addition to special reports, commentaries, surveys, polls, news, ratings updates and whitepapers. As part of the Association for Financial ProfessionalsR’ global network, gtnews editors encourage experts to share their knowledge on key issues facing treasury and financial professionals including changes in regulations, technology and the pursuit of internal efficiencies.