Connect SAP & Excel: Allevo Junan

SAP Excel integration for finance and FP&A

Allevo Junan is Allevo’s SAP-integrated Excel interface. It enables finance and FP&A teams to access SAP data directly from Microsoft Excel, edit planning data in the familiar Excel environment, and transfer the results back to SAP. Your data remains in the SAP system, and existing SAP authorizations continue to apply – without the need for an additional database or middleware.

Connect SAP FICO with Excel

Familiar Excel. Powerful SAP. A perfect match.

With Allevo Junan, you use Microsoft Excel as a flexible user interface while SAP remains your central data source. Data is loaded directly from SAP into the Excel interface, where it can be edited, calculated, and commented on before being transferred back to SAP.

  • No duplicate data storage: Planning data is exchanged directly with SAP, eliminating the need to manually transfer data between Excel files and SAP.
  • Flexible Excel interface: Planning views, formulas, and structures can be adapted to different processes and requirements.
  • Use your existing SAP infrastructure: Allevo Junan requires no additional servers or separate databases.

Activate Cookie Boost

Enable marketing cookies to watch the video.

Kern AG is SAP Silver Partner
Virtual Forge Certification for Kern AG
Kern AG is SAP Certified

85% Time Savings

Accelerate your financial processes and complete your planning up to two months or more ahead of schedule.

100% SAP-Compliant

Allevo Junan always respects the authorization concept already defined in SAP and complies with SAP standards.

1A Certification

Ranked first for Planning Innovation of the Year and awarded top ratings for performance, programming, and security.

Which planning areas can be covered with Allevo Junan in SAP and Excel?

Allevo Junan can be used for a wide range of financial planning and controlling processes, including:

In addition, individual planning scenarios and business processes can be mapped in the Excel interface and connected directly to SAP.

Excel in SAP: Watch the recording now!

See our financial planning solution in action

Join one of our regular introductory webinars and experience our software live in a free, no-obligation session. Or watch a recording right away – simply complete the form to get instant access. Enjoy the demo!

SAP and Excel in practice: How companies use Allevo

Project Management at Vodafone

Efficient Budgeting & Workflows

"We can now set data live within two minutes, as we operate independently from IT and autonomously." Martin Brand, Senior Controller Finance Technology at Vodafone Germany

Read more

Planning for 400 Profit Centers

Performing standardized planning

"Since the introduction of Allevo, we have been benefiting from the various advantages of fully integrated planning in SAP." Markus Ulrich, Head of Controlling at Bionorica SE

Read more

Integrated Cost Center Planning

A Template for 60 Employees Worldwide

"By leveraging the trial version of Allevo, we were able to significantly reduce the implementation time [...]" Michael Schnepel, Global SAP CO Key User at Weidmüller Group

Read more

The Allevo Junan Excel front end

Allevo Junan connects Microsoft Excel directly to SAP and supports integrated financial planning and controlling processes.
SAP remains the central data source.
 

⚙️ Customize the Excel interface to your company and processes

📊 Load SAP data directly into Excel

✏️ Edit values in the familiar Excel environment

✅ Transfer results directly back to SAP

Allevo Junan mit Excel-Oberfläche in SAP S/4HANA
Excel-Vorlage für die Planung von Controlling-Objekten in SAP

Allevo Junan at a glance

  • Solution: SAP-integrated Excel interface for financial planning and controlling
     
  • Target users: Finance teams, controllers, and planning professionals
     
  • Front end: Microsoft Excel
     
  • SAP systems: SAP ERP/ECC and SAP S/4HANA
     
  • Integration: Allevo Engine as an ABAP add-on in SAP
     
  • Data storage: No separate database required

Discover Allevo Junan

Interested in a live demo? Schedule a meeting with us and see how Allevo Junan can support your planning processes. We look forward to hearing from you.

FAQ – Frequently Asked Questions about Allevo Junan

Allevo Junan is the SAP-integrated Excel interface of the Allevo solution. It connects Microsoft Excel bidirectionally with SAP, enabling financial planning and controlling processes to be managed in Excel while SAP remains the central data source.

Yes. Allevo supports both traditional SAP ERP systems and SAP S/4HANA. The Allevo Engine is integrated directly into the respective SAP system, while Microsoft Excel serves as the user interface for Allevo Junan.

Yes. Allevo Junan loads SAP data into an Excel-based interface. Values can be edited, calculated, and supplemented in Excel and then transferred directly back to SAP. This eliminates manual exports and the subsequent transfer of planning data.

No. Allevo Junan uses your existing SAP infrastructure and requires neither an additional database nor a separate server. Your data remains in SAP.

Yes. Allevo is a business tool for finance and accounting that is customized to each customer’s individual requirements. Depending on what you want to plan or calculate with Allevo, we adapt the user interface to your specific processes and needs. Our goal is to enable you to use and manage Allevo independently after implementation. You can therefore modify, expand, or adapt the Excel interface yourself at any time. If you need assistance, your dedicated customer advisor will be happy to support you.

In addition to traditional CO planning scenarios such as cost centers, projects, and CO-PA, Allevo can also cover FI-driven planning areas such as balance sheet planning and cash flow planning. Additional modules are currently being developed, including solutions for real estate management (RE-FX) and logistics processes.

Allevo reads data from SAP in real time using BAPIs, SAP’s standard technology also used in SAP transactions, and can write the data back to SAP. In addition, Allevo’s satellite technology makes it possible to integrate external data sources into SAP and use them within the planning process.

Because Allevo uses standard SAP processes, the existing SAP authorization structure remains unchanged. If required, an additional Allevo-specific authorization concept can be created and implemented.

Absolutely. Allevo allows you to attach comments and supporting calculations to planning data. This creates a fully traceable history of values and business logic directly in SAP. Comments are also accessible to end users at any time through standard SAP reports.

Yes. With the Allevo Workbook, data can be edited in Excel outside the SAP environment. To transfer and post the data to SAP, the workbook is subsequently reconnected to the SAP-integrated Allevo environment.

Yes. Multiple cost centers can be selected either individually using multiple selection or by selecting a group.

Yes. Allevo’s status management allows you to create distribution lists and automatically send documents by email depending on their current processing status.

Yes. Allevo provides various forms of user documentation, including comprehensive manuals, online help, and a Knowledge Center. In addition, Allevo Studio allows users to create their own documentation directly in SAP and make it available interactively.

The licensing model consists of three components:

  • Base: The base component includes Allevo technology, including the SAP Excel interface.
  • Processes: The process component depends on the business processes covered with Allevo, such as cost center planning, investment planning, or the master data interface.
  • Objects: The object component is based on the number of objects, such as cost centers or internal orders, planned with Allevo.

Once the one-time license fee has been paid, the licensed software components are available permanently. Services such as implementation consulting, customization, maintenance, and support are charged separately.

Interested? Contact us to discuss your individual requirements. We will then prepare an offer tailored to your needs.

Yes. When you purchase Allevo, a maintenance and support agreement is included. This gives you access to our support team whenever you have questions or need assistance. All release updates are also included as part of the agreement.

Let’s talk about your financial planning

Do you have questions or would you like to learn more about our SAP solution Allevo? Send us a message or give us a call.
We look forward to hearing from you.

Christian Bieber, Chief Operation Officer

Christian Bieber

Our SAP expert for finance and financial planning.