Real-time Excel-based

SAP Financials Reporting

and Inquiry Solution
l4app s Product
Exce
t: GL Wand 3.71+
Datashee

About GL Wand for SAP

GL Wand for SAP is a proven Excel-based reporting and inquiry tool for finance
departments running SAP Financials. GL Wand enables highly efficient,
Key Features
real-time finance reporting and faster refreshes directly from SAP, resulting in • Excel-based SAP finance
shorter month ends. reporting
• Integrated into SAP ECC6,
ECC5 and 470.
Excel-based Financial Reporting
• Mass reporting and distribution
Excel-based tools faciliate rapid user adoption and acceptance. Users can • High performance architecture
easily create, edit, and publish financial reports without the assistance of IT
and with minimal training. GL Wand reports are refreshable on demand, yet • FI and CO data
preserve all formatting and Excel formula. • Secure
• Proven
GL Wand reports are built using custom functions, which link Excel cells to
specific FICO objects and values. The Get Balance function, for example,
returns one or many GL Balances summed as a value into an Excel cell with User Benefits
drilldown to detail. Users can also customize drill layouts. • Easy
• Microsoft Excel-based
Highlights of Get Balance Feature • Real-time reporting
• No recapturing
Balance types YTD, QTD, PTD and CTD, which uses custom ranges • No import/export
• No data replication
Values, ranges, lists, list range combinations
Parameters and “Excludes” are supported • No implementation
• Same SAP Sign-on
Refresh on demand Refresh a cell, range or workbook live from SAP • Drill to line items
• Drill to document level
Use the Get Balance wizard to populate
Wizard driven • Drill to New GL Document view
the parameters and get your first live balance

Simply copy & paste Get Balance functions

Easy as Copy
to build reports, create comparatives, or
& Paste
clone reports “Finally, a real-time reporting
and analysis tool that the
finance organization wants
to use. We can now spend
more time on analysis and
providing better information
to upper management.”
Dale Kukielka
Senior Business Analyst,
Upsher Smith Laboratories

GL Wand Get Balance Feature Shown

Excel4apps Product Datasheet: GL Wand 3.71+

Key Features and Functions

GL Account, Segment, Business Area, Functional Area, Cost Center, Cost Center Group, Cost Element,
Supported Cost Element Group, Profit Center, Profit Center Group, Account Group, Alternate Account, SKF,
FICO Objects SKF Group, Activity Type, Activity Type Group, Order, Order Group, Representative Material, Trading
Partner, Transaction Type

Periods/
Return balances for a single range/period or for a specified budget version
Budget Types

Company
Multiple company code and New GL Parallel ledger reporting in a single workbook
Code/ Ledger

Discovering Easily populate Excel with FICO objects or discover and report on a group hierarchy or hierarchy range

Create List List of value cells can be double-clicked to open dynamic lists of FICO object values, periods,
of Values company codes, currency types, or balance types

Custom Functions include Get Balance for the New GL, Classic GL, Cost Center Accounting
Custom and for Profit Center Accounting, as well as FICO Object Description, Next FICO Object Value,
Functions Previous FICO Object Value, Company Code Name, Currency for Types, CO Orders, Activity
Types, SKFs, Alternate GL Accounts, and New GL Custom Fields

Calculation Set calculation mode to auto-refresh from SAP on edits or to on-demand mode. Calculate a
options range of cells, a whole sheet, a whole workbook or all open workbooks

Snapshot A dynamic GL Wand report can be made static by creating a snapshot

Drill from a Get Balance function to the line items making up that balance. From the line-item
Drill Down report, drill to the document level. The Entry view and the new GL view for document splitting are
supported for the line item and document drill reports. Quantity can be displayed for PCA line items

Custom Field
Enable rapid setup for custom fields in the new GL
Auto-Configuration

Easy installation Server installation contained in a transport. Easy client-side Excel add-in needing only a URL

GL Balances Reporting is directly from the source GL balances tables so a single version of the truth is ensured

User Name/
Use your SAP username and password for authentication
Authorization

Expand/ Expand a row to display balances and child values that roll up into a particular group. Easily
Undo Expand undo an Expand

Refresh Expand Refreshes an expanded selection by applying the latest group definitions

Open List of Values Launch a form to search through FICO object values and descriptions for a specific FICO object

Configuration
Report on the configuration of the currently-selected company code
Sheet

Options Initiate upgrades and set other advanced options

Reports
Mass create reports and optionally distribute them by email in PDF or Excel format. The snapshot
Distribution
or with formulas are options with the Excel format
Manager

Edit Drill Layout Change the drill layout for all future drill downs

© 2013 Excel4apps All trademarks are the property of their respective owners.
 www.excel4apps.com/sap

SAP Financial Touchpoints

Groups for relevant FICO objects are

Hierarchies automatically interpreted allowing reporting Variety of Uses
at any level within the hierarchy.
• Management reporting
• Statutory reporting
Custom Fields Support for new GL custom fields. • Adhoc reporting
• Slice and dice analysis
Currencies and Chart of Accounts as defined • Monthly reconciliations
Calendar,
are available from Excel. Calendar year
Currencies, Chart • Audit compliance
reporting available for company codes with
of Accounts • Planning, budgeting and
non-calendar year fiscal year variants.
forecasting
Function that returns attribute information about • Drilling to detail
Attributes the FICO object, e.g. the person responsible for • Cost allocation models
the cost center. • Dashboards

Reporting is directly from the source GL balances

GL Balances Advantages for IT
tables so a single version of the truth is ensured.
• Easy to support
Budgets Report on budget balances. • No ODBC no SQL Net
• Standard SAP connector
• Centralized management
Drill to Line Items Drill to line item detail.
• Robust
• SAP single sign-on support
Drill to Document Drill to document detail. • Remote upgradability
• Used and supported globally
Use your SAP username and password for
User Names
authorizations.

Secure
GL Wand has been designed to leverage existing security configuration within “A report that used to
the SAP authorization environment.
take me an 8-hour day
Security Features
to create during a heavy
User authorizations
Authorizations for the user are automatically sales month now, on
detected and applied.
average, takes just one
No ODBC, No Sql net and no system users hour to complete.”
Application
need to be setup or maintained. Single sign-on
layer support Kevin Lybbert,
is supported.
Cost Accountant,
Other Features Purcell Systems

Report on foreign characters, or display

Multi-language foreign language FICO object descriptions if
support language loaded in SAP, for example, Chinese
or Japanese.
Compatible with
Download the free trial and get GL Wand access Microsoft Excel
Online IDES
to an online IDES instance or trial GL Wand on your 2003 - 2010
account
own system. (32 and 64 bit)
Free 30-Day Trial • Schedule a Demo • Learn More • www.excel4apps.com/sap

Mass Reporting and Distribution

Use the Reports Distribution Manager to mass create GL Wand reports and automate
the monthly creation and distribution of reports.
Reports Distribution Manager Features

Excel4apps is a best-in-class Easy to use Wizard driven definition creation, completely

provider of Excel-based reporting, Output formats Excel based. Excel, PDF and email.
inquiry, and budget-loading
software for Oracle and SAP. Specify To: CC: BC email recipients, subject and email
Email options
Designed for finance text. Automatically send email in Microsoft Outlook.
professionals, its award-winning
GL Wand, Reports Wand, and Output folder Specify a server or local PC location.
Budget Wand, products easily
and securely deliver real-time ERP
Hide zeros Specify a range of cells to apply the Hide Zeros logic.
data using Microsoft Excel® to
save reporting time and effort.
Execute
Control how you mass produce reports.
individually or all
Excel4apps serves over 12,000
Oracle and SAP users worldwide,
with offices in Australia, the
United States, United Kingdom,
High-Performance Architecture
United Arab Emirates, Singapore, GL Wand has a proven RFC-based architecture for fetching data from source SAP
and South Africa. systems into Excel. Designed to minimise both system impact and network traffic,
and proven by global multinationals.
To schedule a demonstration
and try a free trial, please visit: Installation Options
www.excel4apps.com today.
Simply import the SAP transport provided in the
Easy installation downloaded software. Easy client side Excel
Contact Your Nearest Office: add-in needing only a URL.

www.excel4apps.com/contact RFC is a proven high performance SAP

E-mail [email protected] High performance
communication mechanism.

Variable parallel batch Control the number of calculations that are sent
www.excel4apps.com
numbers/sizes to the server for processing.

facebook.com/ Remote upgrades Control version upgrades through a site option.

excel4apps
Start the Free Trial

linkedin.com/company/ Take advantage of our free 30-day trial for unlimited users. With no middleware
excel4apps or data warehouse requirements. You can get started in just three simple steps.

twitter.com/
excel4apps

DOWNLOAD INSTALL COMPLETE

FIRST REPORT