Real-time general ledger data in Excel for analysis and reporting

Securely access live general ledger balances and account details from SAP S/4HANA Cloud directly in Excel. Reports such as trial balance, profit and loss, and balance sheet update instantly using OData APIs with OAuth 2.0 authentication and AIR key compliance. This integration eliminates data exports, accelerates month-end reporting, and ensures consistency with the source SAP system.

Overview

Accelerate financial reporting cycles

Retrieve live general ledger balances directly in Excel to eliminate manual exports, shorten month-end close, and deliver accurate financial insights faster across teams.

Ensure data accuracy and compliance

Access trusted SAP S/4HANA financial data through secure OData APIs using OAuth 2.0 and AIR key compliance to maintain audit integrity, data consistency, and regulatory confidence.

Empower finance teams with flexibility

Use Excel PivotTables, charts, and familiar tools to design and refresh real-time SAP S/4HANA reports, giving finance teams freedom to analyze and present results without IT dependence.

Details

Solution type

Extensions and Add-ons

Industry

Cross-Industry, Oil, Gas, and Energy, Industrial Manufacturing, Professional Services, Mining

Compatibility

Works with

This product is compatible with or enhances the functionality of these SAP solutions but doesn't require them.
SAP S/4HANA Cloud Private EditionSAP HANA, enterprise editionSAP ERPShow more

Features

Connect securely to SAP S/4HANA in real time

Establish a read-only connection to SAP S/4HANA Cloud using standard OData APIs and OAuth 2.0 authentication to ensure secure, compliant, and instant access to live financial data.

Connect securely to SAP S/4HANA in real time
Enlarge

Refresh data instantly within Excel

Refresh general ledger balances and account details with a single click to eliminate data exports and ensure that every financial report reflects the most current information.

Refresh data instantly within Excel
Enlarge

Build custom financial reports easily

Create trial balance, profit and loss, and balance sheet reports using familiar Excel features, enabling finance users to analyze data flexibly without custom development or IT support.

Build custom financial reports easily
Enlarge
View media gallery

Plans and pricing

Pro Edition

Unlimited data extracts

Includes unlimited Data VolumeIncludes 1 User License
Price unavailable in this region
  • Minimum contract 1 year

Unlimited data extracts

Includes unlimited Data VolumeIncludes 1 User License

Technical Information

Solution type Extensions and Add-ons
Category Accounting and Financial Close
Industry Cross-Industry, Oil, Gas, and Energy, Industrial Manufacturing, Professional Services, Mining
Works with
  • SAP S/4HANA Cloud Private Edition
  • SAP HANA, enterprise edition
  • SAP ERP

Resources

Excel Finance Reporting for SAP S/4HANA

Architecture Overview

Zentrix Excel Add-In for SAP S/4HANA Demo

Publisher