Modernization of Controlling

The know-how of your organization is stored in large, historically grown Excel files with thousands of cell formulas and code:

Microsoft Excel has many advantages...

• Perfectly tailored to your tasks.
• Works and has proven itself - for years.
• Inexpensive and safe investment, because Excel is a core product from Microsoft, one of the largest software manufacturers in the world.
• Comprehensible thanks to cell formulas.
• Highly complex logic feasible.
• Flexible: the specialist department can expand the solution independently.
• Accepted by the users. They are productive in the proven processes.
   

...but also 3 disadvantages:

1) Error-prone:
Manual data entry & corrections. Copy & Paste.

2) Excel chaos:
Which version of the file is the right one?

3) Operational risk for IT:
Excel sprawl is difficult to maintain.

Therefore, the digitalization of controlling should not be continued purely with Excel.
 

Is a browser-based reporting system the silver bullet?

Principle:

• Data is moved to a central database.
• Output takes place in the browser.

Advantage: The database eliminates the 3 disadvantages of Excel:

• Error-prone
  Database ensures 100% data quality.
• Excel-Chaos
  Database provides everyone with exactly the same data.
• Operational risk
  Logic is stored centrally in the database, where IT professionals are responsible for maintenance.

Disadvantage: The browser eliminates the many advantages of Excel:

• Perfectly tailored to your tasks.
  If you buy a ready-made system, you'll have to change the way you work.
• Works and has proven itself
  Every new development has teething problems, and can also miss the point. Never touch a running system.
• Inexpensive and safe investment
  Browser-based user interface is based on a web platform that may become obsolete in the future. Switching to a different platform will then be expensive.
• Transparent
  There are no cell formulas. Only a developer knows the logic.
• Highly complex logic feasible
  The new system cannot replace the powerful Excel 100%.
• Flexible: The specialist department can expand the solution independently.
  Software developers are required.
  
• Accepted by the users. They are productive in the proven processes
  Users have to get used to the new system. New processes first have to be introduced. Training may be necessary.
   

LeanMIS saves half the development time.

LeanMIS saves half the headaches.

LeanMIS saves half the costs.

Find out more about reporting und planning with LeanMIS!