Sharing Key Performance Indicators
I was just passing by in restaurant, buying a coffee and then I’ve heard one very interesting conversation of two colleagues. They were commenting how corporation gathers thousands of KPI’s from daughter companies in controlling departments but none of the board management members except CFO can see more then 5 Key Performance
Continue reading Sharing Key Performance Indicators [...]
Excel loves controlling and controllers (comptrollers) adore Excel mostly due to its superb functionalities. It is love in both way, pure chemical reaction. Therefore Excel is very often used in Controlling processes like planning, reporting and forecasting, budgeting and many more. Yes Excel and Controlling are tightly connected and often wrongly percepted by management and by IT.
Continue reading Excel in Controlling [...]
Controllers generate many keys and this is perhaps best metaphor, key masters. Keys toward management view over business and keys to substitute information flow fails.
Continue reading Controlling importance and Key masters from controlling [...]
Controlling with specialised tools, knowledge of finance and business logic (at least in agregated form) is ideal place to make necessary knowledge mix, financial and non financial, that fully cover management view into company performance. Sometimes it is the main management monitor into company.
Continue reading There is no life beyond controlling [...]
How to slow down all processes related to Business Intelligence, Data Warehouse with one single and minor organizational effort? Simply, just strengthen internal audit with many employees and let them do the work properly. If managers will not guide them they will find what to dig and how to make processes be by the book.
Continue reading Internal audit is the king and excellent business intelligence party-breaker [...]
CONTROLLING AND MANAGEMENT FUNCTIONS Introducing Controlling and Management functions
Global research dealing with profitability of controlling applications’ own deployment versus buying finished and standardized solutions are very rare and are mostly concentrated on enhancement of table calculators in controlling processes.
Table calculators cannot be adequately used for complete business information of controlling processes mostly due to lack of
Continue reading Controlling and Management Functions [...]
Reporting toward external customers like stock, owners, tax, regulators, auditors and others or internal reporting is one of main role of controlling, more in article about controlling. Main task of controlling is to prepare reports out of accounting data for management in understandable and custom formats. Preparation of many types of reports are made in Excel, which is excellent platform for table data preparation and calculation.
Continue reading Excel and controlling [...]
Controlling is using Excel for Reporting, as Decision Basis, and for Business Analysis
Numbers of studies show great Excel representation as tool in controlling departments, as basis for Reporting from Excel, for Business Analysis and to make Decisions from Excel. Study made by Deloitte for German market with questions what tools are used and what tools are known to users is presented in
Continue reading Excel for Controlling [...]