Wands for SAP

Wands for SAP is an Excel-based SAP reporting tool from insightsoftware that connects directly to SAP ECC and SAP S/4HANA so finance and operations teams can build live reports inside Excel. Instead of exporting data or waiting on IT-built queries, users pull real-time SAP data straight into familiar spreadsheets using Excel formulas, with full drill-down to the underlying transactions.This solution also comes with specialized modules each for different business operations such as GL wand for financial reporting, Reports wand for operation reporting, Planning wand for budgeting and forecasting, Journal wand for journal entry automation and RDM for automated report distribution, delivery and scheduling,

It turns Excel into a live reporting front end for SAP. Each team can use it for different purposes such as finance teams use it to build P&Ls, balance sheets, trial balances and variance reports directly from SAP General Ledger data, while operations teams can use it for inventory, sales and logistics reporting all inside Excel and without relying on custom SAP queries.

Wands connects using standard SAP interfaces, primarily RFC and OData connections, so there's no custom ABAP code or modification required inside the SAP system. This keeps the connection supported and upgrade-safe, since it doesn't touch SAP's core configuration. 

Yes. Wands was originally known as Excel4apps before insightsoftware acquired the product line and rebranded it as Wands. Functionally, it is the same Excel-based reporting approach for SAP (and Oracle EBS) data, now sold and supported under the insightsoftware umbrella.

A manual export is a static snapshot, the moment it's downloaded, it's already out of date. Wands maintains a live connection to SAP, so refreshing a report pulls current data, and any drill-down goes straight to the live transaction in SAP rather than a frozen extract. This eliminates the cycle of re-exporting, reformatting, and re-checking numbers every time something changes upstream. 

Yes. It supports SAP ECC, SAP S/4HANA on-premise, and SAP S/4HANA Public Cloud. Any organizations that are migrating from ECC to S/4HANA can typically carry their Wands-based reports and templates forward with minimal rework. 

GL Wand is designed for finance teams that require fast and accurate financial reporting from SAP. It provides direct access to General Ledger balances, P&Ls, balance sheets, trial balances, cost center data and document splits, with drill-down to the underlying SAP transactions. Reports Wand complements GL Wand by extending reporting beyond finance. It connects Excel directly to SAP tables and business views, enabling operations teams to analyze their inventory, materials management, procurement, logistics, sales and other operational data using live SAP data in Excel.

Yes, Wands can pull and consolidate data across multiple company codes within SAP into a single Excel-based report, which is useful for organizations running multiple entities, subsidiaries, or business units on the same SAP system. 

RDM is the scheduling and distribution module that automates sending reports by email or saving them to shared folders on a defined schedule. It supports different views for different recipients for example, cost center managers receiving only their data while executives see a consolidated view and outputs in Excel, PDF,or HTML. 

Pricing depends on factors like the number of users, which modules are needed (GL Wand, Reports Wand, Planning Wand, Journal Wand, RDM), and the SAP environment in use (ECC vs. S/4HANA). Because licensing varies by deployment, the most accurate way to get a number is a direct quote from an authorized partner.