• HOME

GL Wand for SAP

Enabling efficient and secure financial reporting, shorter month ends, and faster refreshes with ad-hoc inquiry and drill downs for your organization.

GL Wand is an award-winning, Excel-based financial reporting tool for finance professionals using SAP Financials for SAP 4.7, ERP 2004/ECC 5.0, or ERP 2005/ECC 6.0. As an SAP Certified Integration solution, GL Wand enables highly efficient and secure financial reporting, shorter month ends, and faster refreshes with ad-hoc inquiry and drill downs.

Like all Excel4apps solutions, GL Wand leverages your existing SAP security settings and provides reports with drill-down capabilities that are refreshable on demand, yet preserve formatting and Excel formula. Without middleware or data warehouse requirements, you can install and utilize Excel4apps solutions in minutes – so there’s less reliance on IT support and greater power given to the individual user.

GL Wand for SAP Benefits

  • Quick to install
  • Easy to use
  • High performance, .NET architecture
  • Multiple company code and NEW GL parallel ledger reporting in a single workbook
  • Full drill down to detail
  • Real-time data refreshes
  • Report balances from SAP New GL, Classic GL, Cost Center Accounting, Profit Center Accounting, CO Orders, Activity Types, SKFs, Alternate GL Accounts, and New Custom GL Accounts

  • GL Wand for SAP overview

    GL Wand - SAP - Overview

    A quick overview of the main GL Wand functions including logging on to SAP, building a report using linked functions, using the Get Balance wizard, changing dependent parameters, refreshing a report and drilling to detail.

    GL Wand for SAP Overview

  • Wands (SAP) 3.30 User Guide

    Wands (SAP) 3.25 User Guide

    Wands 3.30 for SAP User Guide. Support for SAP Versions SAP 4.70, SAP ERP 5.0 and SAP ERP 6.0 and for Excel Versions 2003, 2007, 2010 (32bit version only)

    Wands (SAP) 3.30 User Guide

  • Wands (SAP) 3.25 User Guide

    Wands (SAP) 3.25 User Guide

    Wands 3.25 for SAP User Guide. Support for SAP Versions SAP 4.70, SAP ERP 5.0 and SAP ERP 6.0 and for Excel Versions 2003, 2007, 2010 (32bit version only)

    Wands (SAP) 3.25 User Guide

Product News

  • Representative Material (Release 3.15)

    11 days ago

    Feature Description: Balances by Representative Material can be retrieved from the PCA get balance function. Feature Benefit: Additional get balance parameter in the PCA function.

  • SAP insiderProfiles

    SAP insiderPROFILES - The Best of Both Worlds

    27 days ago

    Link the Familiarity of Excel with the Power of SAP ERP Financials

    Many financial professionals use Microsoft Excel to support their financial processes and, typically, they tend to rely on IT to create any uploading templates, queries, and reports from their SAP systems. Z Option and Excel4apps have teamed together to offer SAP ERP Financials end users quick and simple ways to manage their data in a Microsoft Excel-based environment. These Excel-based tools facilitate rapid user adoption and acceptance, allowing financial professionals to use their existing Excel skill sets to create financial reports without having to constantly rely on IT.

    - Download the full article in pdf format - Link the Familiarity of Excel with the Power of SAP ERP Financials or

    - View the article in the: January issue of insiderPROFILES

  • Quantities for PCA line items (Release 3.15)

    29 December 2011

    Feature Description: Quantities are an available field for PCA line item drill downs. Feature Benefit: Improved drill down capability.

  • Drill to FI or CO document (Release 3.15)

    29 December 2011

    Feature Description: In a CCA line item drill down it is possible to drill further to either the FI or CO document should an FI document be available. Feature Benefit: Improved drill down capability.


  • Optimize Groups (Release 3.15)

    29 November 2011

    Feature Description: The user has the option to Optimize Groups which can result in improved performance. Feature Benefit: Improved performance.

  • Cache On Demand (Release 3.15)

    8 November 2011

    Feature Description: Master Data is now cached on demand. Feature Benefit: Improved log on times.

  • Unlock Administrator (Release 3.15)

    8 November 2011

    Feature Description: A code can be requested from Excel4apps to unlock the Administrator functions. Feature Benefit: User assistance.

  • Session timeout (Release 3.15)

    7 November 2011

    Feature Description: The Wand Administrator can set a session timeout value so that inactive users are automatically logged off. Feature Benefit: Enhanced security.

  • Leverage .Net Architecture (Release 3.15)

    31 October 2011

    Feature Description: Leverage of the .Net Architecture has improved performance and the user interface. Feature Benefit: Performance and ease of use.

  • Company Code parameter for PCA function (Release 3.15)

    31 October 2011

    Feature Description: The Company Code has been added as an additional parameter on the PCA balance function. Feature Benefit: Refined balance selection options.

  • Use Chart of Accounts Description (Release 3.15)

    27 October 2011

    Feature Description: The user can select to have the description for the GL Account taken from the Chart of Accounts if desired. Feature Benefit: Additional option for the user.

  • Discover the individual master records within a range (Release 3.15)

    26 October 2011

    Feature Description: This allows the user to set an option so that the discover hierarchy functionality will return either a range of values or the individual master records making up that range. Feature Benefit: Users can return the breakdown of a group as it was defined as a range or automatically list the master records within that range.

  • Drilldown worksheet in current workbook (Release 3.15)

    26 October 2011

    Feature Description: The user now has the option to have the drill down results appear as a new sheet in the current workbook or to be created in a new workbook. Feature Benefit: Improved user flexibility.

  • List of Values persisted (Release 3.15)

    24 October 2011

    Feature Description: The List of Values that have been built are persisted when accessing the List. Feature Benefit: Improved user interface.

  • Lists of Groups (Release 3.15)

    22 October 2011

    Feature Description: Lists of Groups can now be used in get balance functions. Feature Benefit: Extended get balance functionality.

  • Configuration Sheet (Release 3.15)

    21 October 2011

    Feature Description: The Configuration Sheet provides system configuration and master data information. Feature Benefit: Provides information for troubleshooting.

  • Custom Drill Down Layouts (Release 3.15)

    20 October 2011

    Feature Description: Both line item and document drill down layouts can now be customized. Feature Benefit: Improved user interface.

  • Single Sign On (Release 3.15)

    19 October 2011

    Feature Description: Single Sign On capability added to the Excel4apps Wands Connector. Feature Benefit: Single Sign On capability.

  • CO Order, Activity Type and Statistical Key Figure Get Balance Functions (Release 3.15)

    18 October 2011

    Feature Description: New functions provided to access balances from CO Orders, Activity Types and Statistical Key Figures. Feature Benefit: Greater functional scope.

  • Excel 2007/2010 Ribbon

    13 October 2011

    Feature Description: The Excel 2007/2010 ribbon provides a rich user interface to interact with the Wand products. Feature Benefit: Improved user interface.

  • GL Wand for SAP 1.15.43 released

    10 December 2010

    An updated version of GL Wand for SAP is available. This version includes support for currencies with additional decimal places as well as a quicker logon process to the Excel4Apps demo server. Also included is a correction to the foreign language conversion routine for other language descriptions. A number of smaller bug fixes and minor enhancements are also included.

  • Functional area parameter added to the Get_PCA balance function. (Release 1.15.0)

    19 May 2010

    The functional area parameter has been added to the Get_PCA balance function allowing balances and drill down by functional area.

  • Support for SAP version 4.70 (Release 1.15.0)

    19 May 2010

    Support for SAP version 4.70 has been added which requires a different server transport. GL Wand now supports a wider range of SAP versions.

  • SAPINSIDER | New and Noteworthy

    23 April 2010

    News from SAP and Partners Excel4apps Streamlines Financial Reprots with New GL Tool. Read about our release of GL Wand 1.10 for SAP Solutions as published in the SAPINSIDER magazine.

  • See the GL Wand for SAP online demo

    5 November 2009

    See the GL Wand for SAP online demo published today. You will see a brief overview of the main GL Wand functions including logging on to SAP, refreshing a report and drilling to detail. See it online in the GL Wand for SAP demo section of our website or on YouTube.

  • GL Wand 1.00 for SAP available for in-house trial

    27 October 2009

    GL Wand 1.00 for SAP is now available for in-house trial by a limited number of early adopters. Complete the GL Wand for SAP download form to apply for early access.

  • GL Wand for use with SAP coming soon!

    21 August 2009

    Excel4apps are pleased to announce that GL Wand for use with SAP will be available in the coming months for download and trial. This annoucement follows over a year of development and testing.

  • "It’s great to work with a group so committed to providing not only a great product but stellar service as well."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • "GL Wand is a fabulous tool, we love it."   

    Donna Holley, Spectranetics

  • "This has to be the quickest ROI we've had on any software investment."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • “GL Wand has been a big hit with Cairn’s Finance team."

    Chris Hebden, Cairn Energy PLC

  • "It took less than two hours to train report users. The time savings for everyone is incredible."

    Francis Nocom, Applications Manager, Cochlear

  • “GL Wand has proven extremely valuable in accessing our Oracle data with Excel."

    Michael Hinck, Finance Systems Project Manager, HBO

  • "GL Wand has given our finance users the freedom to think outside the box and be more innovative with performance metrics."

    Martin Stanton, Chief Information Officer, Destination Hotels & Resorts

  • "GL Wand has given our finance users a very flexible tool."

    Paul Simpson, Lancashire County Council

Product Documents

Technical Documents

Whitepapers