Wands for SAP

Turn SAP ECC and S/4HANA Data into Live SAP Reporting Right Inside Excel with Wands for SAP

Book a Demo & Discovery Call

See how Wands for SAP turns your SAP ECC or S/4HANA data into live reports, share your details and our team will reach out shortly.

Join our growing family of Jet Reports customers who trust and rely on our solutions for smarter business insights.

What is Wands for SAP?

Wands for SAP is a live Excel reporting tool built for SAP ECC and SAP S/4HANA, designed to solve a problem every SAP reporting team knows well that is exported data going stale the moment it’s downloaded. Instead, Wands keeps a real-time connection to SAP, so finance teams build P&Ls, balance sheets and trial balances using familiar Excel formulas, with full drill-down to the underlying transaction. No T-codes, no ABAP development, no waiting on IT. For organizations searching for an SAP reporting solution that doesn’t require coding, Wands turns Excel itself into the SAP reporting tool teams already know how to use.

What to expect from Wands for SAP?

Live SAP Connection

Wands connects directly to SAP ECC, SAP S/4HANA and SAP S/4HANA Public Cloud using standard RFC and OData interfaces so when you refresh, you’re looking at SAP data as it stands.

Zero Training Required

If your team already knows Excel, they already know how to use Wands. Reports are built with standard Excel formulas so finance teams start producing SAP reports without training cycle.

Fast Installation, Faster First Report

Installation takes 2-3 hours and most finance teams build their first live report the same day using pre-built templates for common financial statements.

Transaction-Level Insight

See a number that looks wrong? Click it. Wands drills straight from a report total down to the SAP transaction behind it, so you can fix the issue and refresh.

Spot Trends Automatically

Built-in AI flags anomalies, surfaces patterns, and answers questions about your data, catching issues a manual review might miss.

Seamless SAP Integrations

Wands natively understands SAP General Ledger, cost centers, and materials data, with support spanning SAP ECC, SAP S/4HANA, and SAP S/4HANA Public Cloud.

Featured Integrations

Wands for SAP modiles

One Suit, built to grow with your SAP reporting needs

Start with GL Wand for core SAP financing reporting and add specialized modules as your needs expand. Each Wand works independently or together inside Excel. 

● Financial Reporting

GL Wand — SAP financial reporting in Excel

The core Wands for SAP module. GL Wand connects directly to SAP General Ledger data — P&Ls, balance sheets, trial balances, cost centers, and document splits fully refreshable in Excel without a T-code or export. The starting point for any SAP reporting team moving to live Excel reports.

SAP General Ledger Balance sheet Cost centers Document splits
Learn more about GL Wand →
Revenue 482,300
COGS 211,940
Opex 94,120
Net margin 176,240

live SAP GL data • refreshed in one click

● Operational Reporting

Reports Wand — operational SAP data beyond finance

Extends live SAP reporting to inventory, logistics, materials management, procurement, and sales. Reports Wand connects to any SAP table or business view from Excel — no IT involvement, no ABAP development, no custom SAP queries required.

Inventory Logistics Business views SAP tables
Learn more about Reports Wand →
Open PO lines 1,284
Low stock items 37
Shipments in transit 218
Sales orders 6,491

any SAP table • no IT request needed

● Budgeting & Forecasting

Planning Wand — SAP budgeting from Excel

Build budgets and forecasts in Excel and upload them directly into SAP with built-in validation that catches errors before posting. Eliminates manual re-keying of budget figures and keeps data consistent between Excel and SAP throughout the planning cycle.

Budget upload Pre-post validation Forecast cycles
Learn more about Planning Wand →
Q1 budget — validated
Q2 budget — validated
Uploading to SAP... Q3
Q4 budget — pending

Excel → SAP • errors caught before posting

● Journal Entry Automation

Journal Wand — post SAP journals from Excel

Prepare, validate, and post journal entries to SAP directly from Excel without switching screens. Built to speed up month-end close adjustments and recurring postings, with pre-posting validation that prevents incorrectly formatted entries from reaching SAP.

Month-end close Recurring journals Pre-post validation
Learn more about Journal Wand →
Doc #4471829 — posted
Doc #4471830 — posted
Doc #4471831 — posting •••
Doc #4471832 — queued

Excel → SAP • no screen switching during close

● Automated Distribution

Report Distribution Manager — scheduled SAP report delivery

Schedule and deliver SAP reports automatically by email or shared folder. Each recipient gets their own view — cost center managers see only their data, executives see the consolidated picture — output in Excel, PDF, or HTML on a defined schedule.

Scheduled delivery Role-based views Excel / PDF / HTML
Learn more about RDM →
CFO — consolidated view sent
Controller — GL summary sent
CC managers — own data sending
Operations — inv. report queued

scheduled • right report to the right person

Wands for SAP modiles

One Suit, built to grow with your SAP reporting needs

Start with GL Wand for core SAP financing reporting and add specialized modules as your needs expand. Each Wand works independently or together inside Excel. 

● Financial Reporting

GL Wand — SAP financial reporting in Excel

The core Wands for SAP module. GL Wand connects directly to SAP General Ledger data — P&Ls, balance sheets, trial balances, cost centers, and document splits fully refreshable in Excel without a T-code or export. The starting point for any SAP reporting team moving to live Excel reports.

SAP General Ledger Balance sheet Cost centers Document splits
Learn more about GL Wand →
Revenue 482,300
COGS 211,940
Opex 94,120
Net margin 176,240

live SAP GL data • refreshed in one click

● Operational Reporting

Reports Wand — operational SAP data beyond finance

Extends live SAP reporting to inventory, logistics, materials management, procurement, and sales. Reports Wand connects to any SAP table or business view from Excel — no IT involvement, no ABAP development, no custom SAP queries required.

Inventory Logistics Business views SAP tables
Learn more about Reports Wand →
Open PO lines 1,284
Low stock items 37
Shipments in transit 218
Sales orders 6,491

any SAP table • no IT request needed

● Budgeting & Forecasting

Planning Wand — SAP budgeting from Excel

Build budgets and forecasts in Excel and upload them directly into SAP with built-in validation that catches errors before posting. Eliminates manual re-keying of budget figures and keeps data consistent between Excel and SAP throughout the planning cycle.

Budget upload Pre-post validation Forecast cycles
Learn more about Planning Wand →
Q1 budget — validated
Q2 budget — validated
Uploading to SAP... Q3
Q4 budget — pending

Excel → SAP • errors caught before posting

● Journal Entry Automation

Journal Wand — post SAP journals from Excel

Prepare, validate, and post journal entries to SAP directly from Excel without switching screens. Built to speed up month-end close adjustments and recurring postings, with pre-posting validation that prevents incorrectly formatted entries from reaching SAP.

Month-end close Recurring journals Pre-post validation
Learn more about Journal Wand →
Doc #4471829 — posted
Doc #4471830 — posted
Doc #4471831 — posting •••
Doc #4471832 — queued

Excel → SAP • no screen switching during close

● Automated Distribution

Report Distribution Manager — scheduled SAP report delivery

Schedule and deliver SAP reports automatically by email or shared folder. Each recipient gets their own view — cost center managers see only their data, executives see the consolidated picture — output in Excel, PDF, or HTML on a defined schedule.

Scheduled delivery Role-based views Excel / PDF / HTML
Learn more about RDM →
CFO — consolidated view sent
Controller — GL summary sent
CC managers — own data sending
Operations — inv. report queued

scheduled • right report to the right person

Services

We are the authorized reseller and service center for insightsoftware’s Jet suite of products. We provide end to end Business Intelligence and reporting solutions to Microsoft Dynamics ERPs users.

Boost Your SAP Reporting Power:
Save 20% on Wands for SAP License!

Our seasoned SAP reporting consultants build custom Wands reports tailored to your chart of accounts, cost center hierarchy and reporting calendar that evolves seamlessly with your business needs.

Seamless SAP Reporting Starts Here:
Easy 2 hours Wands Installation!

Our certified consultants handle the complete Wands for SAP installation, RFC and OData connection setup, SAP BASIS authorization checks, Excel add-in deployment and pre-built financial report template loading, so your finance team is building live SAP reports.

power bi service
Unlock Live SAP Insights For Free:
Your First Two Reports On The House!

Our seasoned consultants excel in crafting tailored reports from your data, guaranteeing precision. Rely on our expertise not just in custom report development, with Jet Analytics Cloud and Jet Reports Business Central support to ensure your reports and solutions evolve seamlessly with your business needs.

Experience The Next Level:
Upgrade To The Latest Versions For Free!

Level up your experience with seamless upgrades! Still on old versions of Jet? Our experts facilitate smooth transitions to the latest versions. Stay ahead with updates, and we’ll even guide you through Jet reports update to keep your system ahead in the business environment.

What Our Customers Have to Say About Us

Frequently Asked Questions(FAQs)

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.

It turns Excel into a live reporting front end for SAP. 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. 

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.

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 for SAP supports SAP ECC, SAP S/4HANA on-premise, and SAP S/4HANA Public Cloud. Organizations migrating from ECC to S/4HANA can typically carry their Wands-based reports and templates forward with minimal rework. 

GL Wand is built for financial reporting General Ledger balances, document splits, cost center data, P&Ls, balance sheets and trial balances, all with drill-down to source documents. Reports Wand extends that same Excel-based approach to operational SAP data outside of finance, such as materials management, inventory, logistics and sales, by connecting to any SAP table or business view.

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. 

Installation is typically a 2–3 hour process, and most finance teams are able to build their first live report the same day using pre-built templates for common financial statements. This is significantly faster than a traditional SAP reporting or BI project, which can take weeks or months.

If a user already knows Excel formulas, they're largely ready to use Wands for SAP. There's no separate reporting language or new interface to learn reports are built using familiar Excel functions linked to live SAP data, which is why adoption is typically fast across finance teams of varying technical skill levels.

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.

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.