Presented by: Z Option and Excel4apps

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 • Q&A • 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 • Post multiple documents from one worksheet

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 • “We’ll 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, we’ve 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 you’re 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 • >420 customers, >10000 Users • >60 countries • Largest installed base is NA • HQ: Sydney, Australia • NA Offices: Raleigh & Pittsburgh

17. Define Execute Review Distribute SAP Excel integration Monthly Reporting Ad hoc Enquiries • No out of the box SAP Excel integration • Manual refresh process / retype • Iterative export / imports • Loss of productivity • User frustration • Changing requirements • Specialist Report Painter / Writer skills • Report Painter limitations e.g., charting • Loss of productivity • Time to log on • Time to query • Time to convert to distribute • User frustration Currently Reporting cycle • Finance users demand highly productive review, modelling and distribution interface. • Have MS Excel on desktop and can use it. Many organizations employing dual SAP & Microsoft strategies

18. Innovative reporting tool built around finance role in organizations running SAP • Installs in minutes • Easy to use Define Execute Review Distribute Monthly Reports Ad hoc Enquiry SAP Excel integration • Use custom functions to retrieve balances • Copy / Paste to edit report definitions • Highly productive • Fast query to resolution • Drill to details • Distribute information • Reduced frustration • .Net connector direct to SAP • SAP sign on / security • Range / Sheet / Workbook refreshable on demand • Report built @ cell level 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 Microsoft .NET environment MySAP Technology 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 12Version 3.45

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.