SAP Active Excel (Interactive Excel) 3.0 combinable with SAP SEM-BCS

Since October 2014 SAP Active Excel (Interactive Excel) 3.0 is available. The new version is accessible via SAP GUI 7.40 or as a stand-alone software component. From this version on SAP Active Excel can be combined with SAP SEM-BCS. Active Excel is a data input and analyzing tool based on Microsoft Excel and could only be used in combination with SAP R/3 EC-CS so far. It allows for flexible analyses and is an interface for entering data into the consolidation system. Additionally custom-made entry masks can be provided and analysis reports generated by the operating department autonomously.

With Active Excel, SAP SEM-BCS gains a flexible MS Excel interface. Besides new options for ad-hoc-reporting, this adds the possiblity to design custom layouts for entry masks. Custom formulas for such masks may also be defined.

We will kindly advise you regarding the necessary system requirements and the manifold fields of application of Active Excel. For further information please contact info@kapcon.de.

Tagetik – an innovative software for strategic and operational planning right up to the reporting of the financial statement

Tagetik is a software for flexible group management which is suitable for internal and external accounting. The creation of an auditable consolidated financial statement is possible in Tagetik as well as the realization of a flexible budget process. PmOne AG is exclusive distributer of Tagetik in Germany, Austria and Switzerland. Since 2014 we are a certified Tagetik-partner of pmOne AG.

We will kindly advise you regarding the various options of Tagetik especially as an alternative to other systems. For further Information please contact info@kapcon.de.

Diversity of projects of KAPCON Managementberatung GmbH

The KAPCON Managementberatung GmbH was founded in December 2003 and started its business activity in January 2004 by the motto „group controlling and group consolidation put in a nutshell“. Since then we have realized various projects with our clients. The range varies from the selection of a system via the accomplishment of realization studies to the implementation of consolidation systems for actual, budget and forecast data according to HGB/BilMoG, US-GAAP or IFRS. We also offer extensive support for live systems. In this connection we also consider new issues like FAIT 4, the implementation of the revaluation method regarding first consolidation. In addition the extended requirements regarding group controlling for instance within the area of planning, key figures and cash flow statement are a focus of our activities.

The project and customer portfolio of the KAPCON Managementberatung GmbH during the first 10 years includes the following:

  • Realization study regarding the replacement of SAP R/3 EC-CS including the optimization of the consolidation process for the group reporting according to HGB/BilMoG for actual, budget and forecast data for an international group in the area of plant engineering
  • Implementation of SEM-BCS 6.34 for the monthly reporting according to IFRS with integrated data supply based on a special-ledger-solution (FI-SL) for an international group in the area of press production – this also included the automated transfer of the consolidated financial statement as individual financial statement to the consolidation system SAP Bo FC of the new mother company taking into account FAIT 4
  • Implementation of SAP R/3 EC-CS for the monthly group reporting according to IFRS, using a portal-based data entry based on Active Excel for an international major bank, including ongoing support after the go-live
  • Implementation of SEM-BCS 6.0 for the preparation of consolidated financial statements according to HGB/BilMoG for actual, budget and forecast data for a group in the area of suppliers for car manufacturers as well as the change to segment information in due consideration of FAIT 4
  • System choice and implementation of SAP R/3 EC-CS with integrated data processing for the quarterly group reporting according to HGB/BilMoG for a group in the publishing sector for medical books
  • Implementation of SAP R/3 EC-CS for group reporting according to IFRS for a group in the area of suppliers for car manufacturers
  • Implementation of SAP SEM-BCS for the preparation of monthly group reporting according to HGB/BilMoG and IFRS for a group in the area of textile colours
  • Implementation of SAP SEM-BCS for the preparation of monthly consolidated financial statements of actual and budget data according to IFRS for a group in the area of household goods
  • System choice and implementation of the software solution IDL for the group reporting according to HGB/BilMoG for a group in the area of metal processing
  • Implementation of SAP R/3 EC-CS with integrated data processing for the preparation of consolidated financial statements according to HGB/BilMoG, US-GAAP and IFRS for actual and budget data for a group in the area of medical technology
  • Implementation of SAP R/3 EC-CS for monthly group reporting of actual and budget data according to HGB/BilMoG for a group in the area of metal processing, including the income statement according to total expenditure format as well as cost of sales format
  • Implementation of SAP R/3 EC-CS for the preparation of consolidated financial statements for sub-groups according to IFRS for a utility company
  • Implementation of SAP R/3 EC-CS for the group reporting according to HGB/BilMoG and IFRS for a group in the area of refrigerator unit engineering

10 years KAPCON Managementberatung GmbH

KAPCON Managementberatung GmbH started its work in January 2004. The original members were the managing directors Winfried Eickhoff and Gerd Schmidt as well as the managers Norbert Nischler, Matthias Schock and Oliver Voges. This experienced and effective team had worked closely with each other for Arthur Andersen Managementberatung GmbH already. After a short episode with Heaven 21 AG they came to the conclusion in December 2003 to continue the business together by the motto „group controlling and group consolidation put in a nutshell“. For this they have access to a competent network of specialists to be able to respond to wide-ranging questions.

The excellent customer contact of the managing directors in combination with direct access to the development division of SAP AG brought about success very quickly. In the following 10 years manifold projects have been realized with emphasis on projects regarding the implementation of consolidation systems. Those included for example such for actual data, budget data and forecast data according to HGB/BilMoG, US-GAAP and IFRS combined with subsequent support. Our customers operate in many different branches covering mechanical and plant engineering, medical technology as well as metal processing, energy provision, automotive supply and banking.

This multifaceted expert knowledge and the claim to commit ourselves to the individual customer wishes and conditions lead to our high consulting quality. By regularly attending internal and external trainings and conventions in the field of group accounting and controlling our consultants are always up-to-date and able to identify future problems at an early stage. The close contact with the SAP AG development department deriving from a development cooperation between SAP AG and Arthur Andersen Managementberatung GmbH regarding the development of SAP R/3 EC-CS, contribute to the efficient and fast way of solving software problems, particularly regarding implementation projects.

The 10th business year of KAPCON Managementberatung GmbH was overshadowed by the sudden and unexpected death of the founding member and managing director Winfried Eickhoff on March, 27th, 2013. However, we managed a reconstruction and realignment in relatively short time. The appointment of Norbert Nischler and Oliver Voges as managing directors had been initiated to continue the business as intended by the deceased founding member. The new strategy of the KAPCON Managementberatung GmbH is characterized by the expansion of the consulting and product portfolio resulting in a staff expansion. While during the past 10 years the main focus had been on the consolidation systems SAP R/3 EC-CS and SAP SEM-BCS, now systems with integrated planning solutions like SAP BPC or Tagetik are supposed to expand the range of services offered. The increased use of remote access reduces the travelling of the consultants and therefore the consulting costs as well. In addition, a prompt support can be ensured at all times.

As our clients have contributed in a crucial way to our success we would like to thank them sincerely for their confidence during the past 10 years. We ensure you that we will continue to dedicate our whole attention to your wishes and requirements regarding a future-oriented group accounting including optimized processes. Furthermore we would also like to thank our former colleagues and our freelancers for the successful collaboration and hope for a good cooperation in the future as well.