Improve Your Business Processes: Upload Financial Transactions and Report from SAP Without Ever Leaving Excel!

1
Improve Your Business Processes Upload
Financial Transactions and Report from SAP
Without Ever Leaving Excel!

Presented by Z Option and Excel4apps
2
Agenda In This Session

• Z Option Information
• Excel4apps Information
• GLSU and GL Wand Demos
• QA
• Wrap-Up

3
Learning Objectives

• Learn how you can streamline financial data entry
  from Excel directly into SAP (using GLSU from Z
  Option) and then be able to immediately report on
  posted results (using GL Wand from Excel4apps),
  without ever leaving Excel.
• See how financial data can be uploaded into SAP
  using a flexible, configurable spreadsheet
  interface.
• Learn how to automate monthly uploads.
• Observe how data can be extracted from SAP to
  Excel in real time.
• Experience the difference between static vs.
  flexible ad-hoc reporting and analysis.
• Discover how to accelerate month-end processing
  and error resolution.

4
Welcome
Spreadsheet Integration For the SAP Professional
5
Presenter
Tim Curtin Solution Specialist
6
About us

• Located in Lewisville, Texas (Near Dallas, TX
  U.S.)
• Formed in 1998 by accountants and programmers
• SAP software solutions partner
• Customers of all sizes and industries, worldwide

7
Customers
Z Option has hundreds of customers with thousands
of users worldwide.
For a more complete list of our customers, visit
www.zoption.com
8
Software Tools

• GLSU
• Budget Loader
• EzySolutions

9
Software Tools

• Powerful, flexible, user- friendly solutions
• Reduce support and development costs
• GLSU uses standard SAP authorizations
• Start posting documents in a few hours with a
  free Remote Installation Service
• Free Trial

10
Current Challenges

• Non-flexible upload tool
• Large external file uploads
• Errors on large journal entries
• SAP upgrade
• Mergers/acquisitions

• New implementations
• Month-end closing process
• Multiple currencies
• Cross company postings
• Multiple vendors

11
Key Features of GLSU

• Easy user interface
• Leverage existing Excel skills
• Post directly from the spreadsheet
• Flexible layouts
• SAP Document Numbers returned
• Pre-validation of data before posting
• Master Data lookups
• Post more than 1,000 lines
• Attach source workbook to posted document in SAP

12
GLSU Common Uses

• Attach source document (entire workbook)
• Misc. vendors
• Payroll
• Travel and Expense process
• COPA
• Multiple currency entries
• Cross-company transactions
• P-cards i.e. phone bills, lease payments
• Accrual entries
• Acquisition/Migration moving legacy information

Customer Success Stories http//www.zoption.com/
myfiles-c8-Success_Stories.aspx
13
Customer Comments

• With GLSU, we save time and money. FI Project
  Manager
• Well have been using GLSU for two years and I
  cannot tell you what a positive impact it has had
  on our finance users. Director
• Since implementing GLSU, weve managed to
  achieve our goal of a much shorter closing,
  down from 8 weeks. ICT Officer, FI Unit
• There is simply no limit to how you can use GLSU
  if youre familiar with Excel. SAP Business
  Analyst
• We use GLSU to improve overall productivity.
  Senior Accountant
• SAP is dynamic, my clients businesses are
  dynamic, and they need dynamic tools like GLSU.
  Independent SAP Consultant

14
Welcome
15
Presenter
Ryan Schmidt Territory Manager
16
About us

• Founded 2004
• gt420 customers, gt10000 Users
• gt60 countries
• Largest installed base is NA
• HQ Sydney, Australia
• NA Offices Raleigh Pittsburgh

17
Currently
Reporting cycle
Many organizations employing dual SAP Microsoft
strategies
18
GL Wand for SAP
Reporting cycle
19
Business Intelligence (Hyperion, OBIEE, Business
Objects, etc.)
Executive Information for strategic decisions
Reports Dashboards Graphics
Data Cubes
Business Intelligence Tools (e.g., Hyperion,
Business Obj.)
Datawarehouse
Operational Intelligence
Data transformation (summarized, filtered)
ETL Process
Operational Information for Daily Analysis
Periodically Updated (e.g., weekly, monthly)
Reports Dashboards Graphics
ERP Systems (Oracle, SAP, JDE, PS)
Microsoft Excel
Real-Time Data
Transactional Data (GL, AP, AR, FA, PO)
Datasheets
Drill-Down Capability
20
Architecture
MySAP Technology
Microsoft .NET environment
GL Wand for SAP v1.1 (Excel Add-in)
Excel Add-in
Installed as a Transport
Client PC
SAP connector for Microsoft .NET v2.01
RFC Layer
WAN support
Read only access
Remote PC upgrades
21
History
Brief product history Mar-03 Proof of concept
released Sep-04 First sale to listed Investment
Bank, Schroders, running Oracle 11i Jan-06
GL Wand 3.00 series released with HTTP
framework Feb-07 GL Wand 3.20 - Twenty Three
New features including Office 2007
support Dec-07 GL Wand 3.50 Thirty Three
enhancements Aug-09 GL Wand for SAP V1.0 for
New GL Nov-09 GL Wand for SAP v1.1 Jan-10 Sales
Wand for SAP v1.1 April 10 SAP Certified
Integration with SAP Applications May
11 Support for 4.7 included from GLW 1.15 Feb
12 Version 3.45
SAP ERP SAP ERP
SAP Version ECC 5.0 ECC 6.0, 4.7
Connectivity options SAP connector for Microsoft.Net v2.01 SAP connector for Microsoft.Net v2.01
GL Wand versions Compatible 1.10 1.15 2.00 3.45
MS Office requirements Office 2000 Office 2003 Office 2007 Office 2010 Office 2000 Office 2003 Office 2007 Office 2010
22
Customers
NATO
Adcock Ingram Al Fahim Enterprises Auscott
Limited Australian Prudential Regulation
Authority (APRA) Australian Red Cross Blood
Service Avista Corp Avtec Limited Bank of
Scotland Treasury Bartter Enterprises Pty
Ltd Bateman Projects Limited Bossini Enterprises
Limited Brick Warehouse Capital Finance Australia
Limited Cell C (Pty) LTd Clark County Cochlear
Ltd Coogee Chemicals Department of Indigenous
Affairs (DIA) Destination Hotels Resorts DHL
Excel Supply Chain Singapore Pte Ltd Edgars
Consolidated Stores Ltd Ellerine Furnishers (PTY)
Ltd Epol a Division of Rainbow Farms Euramax
Exterior Products Geratech GFI Group
Inc Glatfelter Insurance Group
Harmony Gold Mining Pty Ltd HBO
Films Indianapolis Airport Authority Insurance
Commission of Western Australia (ICWA) Integro
Insurance Brokers Internet Solutions ITV Plc JSC
Severstal Kawasaki Kisen Kaisha, Ltd. (K
Line) Knapp KPMG Lancashire County
Council Lancashire Fire Rescue Lancashire
Police Authority Louisville Metro
Government MasterCard International MB Petroleum
Services LLC Mediacom Communications
Corp MediMedia Metrobus Multiplex
Limited National Health Laboratory Service NATO
CIS Services Agency Network Ten Nextel
Communications Argentina SA North-West
University Optium Corporation
Paramount Citrus Association (PCA) Paramount
Farms Parliament of Victoria PAS
Technologies Perry Equipment Corp Red Rock
Consulting Pty Ltd Resmed Roll International Rural
Ambulance Victoria Samim SARCC Schroders
Investment Management Limited Schweitzer Mauduit
Intl Inc SITA (Pty) Ltd South African
Tourism Spectranetics The British Library The
University of Melbourne Tourism
Australia University of Johannesburg University
of the Witwatersrand University of Western
Sydney Vodacom (Pty) Ltd VW Credit
Inc Wesbank Wesfarmers Energy Limited Wyndham
Hotels and Resorts
23
Demonstration
24
Wrap Up

• With GLSU and GL Wand
• Simply and efficiently generate reports and
  inquiries from SAP Financial (FI) modules using
  Excel with full drill down to transactional
  details
• Improve the efficiency of financial data entry
  functions including cutover data, FI postings,
  and vendor invoice processing directly from
  Excel to SAP and even enhance your SAP
  environment by posting more than 1,000 lines and
  multiple documents from one worksheet, and
  attaching source documents in SAP
• Start streamlining your accounting processes for
  better error resolution, improved data accuracy,
  reduced time and effort, and a shorter month-end
  close cycle

25
Looking For More Information?
Next Steps
Z Option GLSU Schedule a No-Obligation WebEx
Demo one hour www.zoption.com Set Up Your Free
30-day Trial
Excel4apps GL Wand Schedule an Online
Demonstration http//www.excel4apps.com/sap Try
GL Wand free for a 30-day Trial
26

• Thank you.