real-time sap reporting in...

12
Real-Time SAP Reporting in Excel Discover the Magic of Excel4apps Wands ®

Upload: truongkhue

Post on 30-Jan-2018

227 views

Category:

Documents


5 download

TRANSCRIPT

Real-Time SAP Reporting in Excel

Discover the Magic of Excel4apps Wands

®

2

ovERviEW

Real-Time SAP Reporting in Excel

Excel4apps Wand solutions are SAP® Certified and proven Excel-based reporting and inquiry tools for finance departments running SAP Financials. GL Wand and Reports Wand enable highly efficient, real-time financial reporting and faster refreshes directly from SAP, resulting in shorter month ends.

Key IT Benefits • Excel-based reporting

for SAP• Integrated into SAP

ECC6, ECC5 and 470• Mass reporting and

distribution• High performance

architecture• Leverages SAP security

Key User Benefits • Easy-to-use• Microsoft Excel-based• Real-time reporting• No import/export• No data replication• No implementation• Same SAP sign-on• Drill to line items• Drill to document level

www.excel4apps.com/seeit

3

SAP Architecture

• WAN Support• Remote PC Upgrades• Installed as a Transport

SAP ARchiTEcTuRE

4 www.excel4apps.com/rwsap

Excel-Based Financial Reporting Solution for SAP

GL Wand for SAP is a proven Excel-based reporting and inquiry tool for finance departments running SAP Financials. With GL Wand, users can easily create, edit, and publish financial reports in real time without the assistance of IT and with minimal training. GL Wand reports are refreshable on demand, yet preserve all formatting and Excel formulas.

• Extract data from SAP to Microsoft Excel in real time • Easy flexible ad-hoc reporting and analysis • Report balances from the new GL, classic GL, cost center

accounting, profit center accounting, orders, activity types, statistical key figures (SKF), all with the ease of Excel

gl WAnD

www.excel4apps.com/glwsap

5

REPoRTS WAnD

Real-Time, Excel-Based Reporting Beyond Fico

Reports Wand provides an easy-to-use Excel front end to your SAP data. Users won’t waste time continuously exporting from other tools into Excel and reformatting data. Reports Wand allows you to edit report layouts, apply formatting, formulas, and charts and then simply refresh the data at the click of a button for further sharing or collaboration. Reports Wand also provides the ability to drill to detail or drill to other related data for advanced analysis.

• Enables users to style their own reports in Excel with less reliance on IT in real time

• No additional hardware needed• No data warehouse

www.excel4apps.com/rwsap

6

SuRvEy SAyS

high net Promoter (nPS) Score

Independent research was conducted in 2013 with various Excel4apps customers and partners to determine their satisfaction level. The overall responses reflected a tremendous favorability for Excel4apps products, service and support including a rating of 66 for the Americas region. 1“There are many successful and profitable organizations with an NPS of less than 10. What this means to Excel4apps is that they share a customer satisfaction level comparable to many of the highest respected companies in the world.”. - Karl M. Kirsch, lead researcher on the project

Top Reasons for high nPS Score

• Ease of use of product• Creates reports in desired format• Speed at which reprots run• Ability to drill down and

access live data• Satisfaction with customer

service and support• Low cost of the product1Source: Karl M. Kirsch, CAE and Principal, Ascend Consulting Inc. an Atlanta, GA based association and technology user group consulting firm. “Excel4apps Net Promoter Score” report delivered February 2014

7

WhAT ouR cuSToMERS ARE SAying

“Excel4apps has brought USL the ability to have real-time data in a reporting and analysis tool that our

finance users know how to use and want to use, allowing them to spend more time providing better data and

information to the management team.” Dale Kukielka, Senior Business Analyst, Upsher-Smith Laboratories

“A report that used to take me an 8-hour day to create during a heavy sales month now, on

average, takes just one hour to complete.” Kevin Lybbert, Senior Cost/SAP Analyst, Purcell Systems

“GL Wand has streamlined our tight month-end close so that we spend less time struggling to prepare data and

more time analyzing it to improve our business strategy and responses. With minimal training, our finance users can develop complex reports in GL Wand in just minutes,

without programming support. Because the reports access real-time SAP data, we are assured that we

are analyzing the most relevant data possible.” Andrew Roberts, Finance Manager, Fletcher Insulation

www.excel4apps.com/loveit

8

cASE STuDy

odyssey Re® About odyssey Re®

• Leading worldwide underwriter of reinsurance and specialty insurance

• Ranked among the top 15 global reinsurance groups in terms of premium volume

• $10.7 billion in total assets and $3.1 billion in statutory surplus

The challenge

• SAP BW with BEx Delays with cube updating• Faulty implementation• Distrust and frustration from users

The Solution

• Streamlined processes• Users now have access to real-time financial data• Ability to drill down to line item and document

level details• Cost effective• Quick user adoption due to ease of use

9

cASE STuDy

Purcell Systems About Purcell Systems

• Global leader in the design and manufacture of high-quality electronic equipment enclosures for telecom and other industries.

• Founded in Spokane Valley, Washington in 2000

The challenge

• Problems with expediting both ad-hoc and standard financial reporting processes

• No data refreshes with their reports from SAP into Excel, thereby continuously re-creating reports

• Reporting was time-consuming and cumbersome• Manual process linking tables and reports

The Solution

• Instantaneous reports (down from 2 – 4 hours daily)• Posted journal entries are immediately reflected on

income statements• Smooth interface• Real-time SAP information into reports

go.excel4apps.com/purcell

10

cASE STuDy

upsher Smith laboratories About upsher-Smith laboratories

• Independent and privately-held company, focused on product growth and innovation for both branded and branded-generic pharmaceuticals

• Driven by the ever-changing needs of patients, physicians, pharmacists, and healthcare organizations

• Pursuing improved drug therapies to improve people’s lives The challenge

• Out-of-the-box reports not flexible enough for users• Custom reports were too specialized, too many versions• Resource and expertise for custom reports not always

readily available• Out-of-the-box reports not presentation quality The Solution

• SAP integration and Excel integration• Low level of effort to manage and administer• Minimal IT resource time to deploy and support• Ability to leverage SAP security profiles• Reasonable cost• User acceptance/ease of use• Real-time data• SAP Partner

go.excel4apps.com/upshersmith www.excel4apps.com/trialit

11

TRiAl PRocESS & TRAining

gl Wand and Reports Wand are available for immediate download and 30-day free trial It’s easy. Download in 5 minutes. Install in 45 minutes, including the once off server installation. Complete your first report in 30 minutes. Your trial can have an unlimited number of users and servers and any reports you create in the trial can be used in Production.

• Free in-house 30-day trial • Unlimited users • No middleware or data warehouse requirements • Installed as an Excel ad-in on the PC and a transport

on the SAP server• Use Report Wizard to build reports • Free web-based training

DOWNLOAD INSTALL COMPLETE FIRST REPORT

www.excel4apps.com/trialit

12

conTAcT uS

www.excel4apps.com/[email protected]

Excel4apps is a best-in-class provider of Excel-based reporting and budget-loading software for SAP. Designed for financial professionals, the award-winning GL Wand and Reports Wand products easily and securely deliver real-time ERP data using Microsoft Excel to save reporting time and effort. Excel4apps serves over 19,000 users in 62 countries, with offices in the United States, United Kingdom, Australia, United Arab Emirates and South Africa.

About Excel4apps