Improve Your Business Processes Upload Financial Transactions and

Improve Your Business Processes: Upload Financial Transactions and Report from SAP Without Ever Leaving Excel! [ JUERGEN LINDNER [ SAP POINT OF CONTACT MEMBER SINCE: 1998 ] Presented by: Z Option and Excel 4 apps [ LINDA WILSON ASUG INSTALLATION MEMBER SINCE: 1999 [ ATUL PATANKAR ASUG INSTALLATION MEMBER SINCE: 2000

[ Agenda – In This Session… § Z Option Information § Excel 4 apps Information § GLSU and GL Wand Demos § Q&A § Wrap-Up Real Experience. Real Advantage. 2

[ 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 Excel 4 apps), 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. Real Experience. Real Advantage.

[ Welcome Spreadsheet Integration For the SAP Professional Real Experience. Real Advantage.

[ Presenter Tim Curtin Solution Specialist Real Experience. Real Advantage.

[ 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 Real Experience. Real Advantage.

[ Customers Z Option has hundreds of customers with thousands of users worldwide. For a more complete list of our customers, visit www. zoption. com Real Experience. Real Advantage.

[ Software Tools • GLSU • Budget Loader • Ezy. Solutions Real Experience. Real Advantage.

[ 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 Real Experience. Real Advantage.

[ Current Challenges § Non-flexible upload tool § New implementations § Large external file uploads § § Errors on large journal entries Month-end closing process § Multiple currencies § SAP upgrade § Cross company postings § Multiple vendors § Mergers/acquisitions Real Experience. Real Advantage.

[ Key Features of GLSU § Easy user interface § Leverage existing Excel skills § Pre-validation of data before posting § Master Data lookups Post directly from the spreadsheet § Post more than 1, 000 lines § Flexible layouts § Attach source workbook to posted document in SAP § SAP Document Numbers returned § Post multiple documents from one worksheet § Real Experience. Real Advantage.

[ GLSU Common Uses Attach source document (entire workbook) Multiple currency entries Cross-company transactions § P-cards – i. e. phone bills, lease payments § Accrual entries § § § Acquisition/Migration – moving legacy information Misc. vendors § Payroll § Travel and Expense process § COPA Customer Success Stories: http: //www. zoption. com/myfiles-c 8 -Success_Stories. aspx Real Experience. Real Advantage.

[ 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 Real Experience. Real Advantage.

[ Welcome Real Experience. Real Advantage.

[ Presenter Ryan Schmidt Territory Manager Real Experience. Real Advantage.

[ About us • • • Founded 2004 >420 customers, >10000 Users >60 countries Largest installed base is NA HQ: Sydney, Australia NA Offices: Raleigh & Pittsburgh Real Experience. Real Advantage.

[ Currently Reporting cycle Define Execute • Review Distribute • 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 Monthly Reporting • Ad hoc Enquiries Changing requirements • Time to log on Specialist Report Painter / Writer skills • • • Time to query Report Painter limitations e. g. , charting • SAP Excel integration Loss of productivity Real Experience. Real Advantage. • Time to convert to distribute • User frustration • • No out of the box SAP Excel integration Manual refresh process / retype • Iterative export / imports • Loss of productivity • User frustration

[ GL Wand for SAP Reporting cycle Define • Execute Review Innovative reporting tool built around finance role in organizations running SAP Distribute • Installs in minutes • Monthly Reports • Ad hoc Enquiry Use custom functions to retrieve balances Copy / Paste to edit report definitions • • Highly productive Real Experience. Real Advantage. • • Fast query to resolution Drill to details SAP Excel integration • . Net connector direct to SAP • • SAP sign on / security Range / Sheet / Workbook refreshable on demand Distribute information Reduced frustration Easy to use • Report built @ cell level

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 Data transformation ETL Process Periodically Updated (summarized, filtered) Operational Intelligence Operational Information for Daily Analysis (e. g. , weekly, monthly) Reports Dashboards ERP Systems (Oracle, SAP, JDE, PS) Transactional Data (GL, AP, AR, FA, PO) Real Experience. Real Advantage. Real-Time Data Microsoft Excel Drill-Down Capability Graphics Datasheets

[ Architecture Microsoft. NET environment GL Wand for SAP v 1. 1 (Excel Add-in) My. SAP Technology Excel Add-in Client PC SAP connector for Microsoft. NET v 2. 01 RFC Layer Read only access WAN support Real Experience. Real Advantage. Remote PC upgrades Installed as a Transport

[ History Brief product history SAP ERP Mar-03 Sep-04 SAP Version ECC 5. 0 ECC 6. 0, 4. 7 Connectivity options SAP connector for Microsoft. Net v 2. 01 Jan-06 Feb-07 Dec-07 Aug-09 GL Wand versions Compatible MS Office requirements Real Experience. Real Advantage. 1. 10 Office 2000 2003 2007 2010 1. 15 2. 00 3. 45 Office 2000 2003 2007 2010 Nov-09 Jan-10 Proof of concept released First sale to listed Investment Bank, Schroders, running Oracle 11 i GL Wand 3. 00 series released with HTTP framework GL Wand 3. 20 - Twenty Three New features including Office 2007 support GL Wand 3. 50 – Thirty Three enhancements GL Wand for SAP V 1. 0 for “New GL” GL Wand for SAP v 1. 1 Sales Wand for SAP v 1. 1 April 10 SAP Certified Integration with SAP Applications May 11 Support for 4. 7 included from GLW 1. 15 Version 3. 45 Feb 12

[ 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 Real Experience. Real Advantage. 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 Master. Card International MB Petroleum Services LLC Mediacom Communications Corp Media 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

[ Demonstration Real Experience. Real Advantage.

[ 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 Real Experience. Real Advantage. 24

[ Looking For More Information? Next Steps Z Option: GLSU Schedule a No-Obligation Web. Ex Demo – one hour www. zoption. com Excel 4 apps: GL Wand Schedule an Online Demonstration http: //www. excel 4 apps. com/sap Set Up Your Free 30 -day Trial Try GL Wand free for a 30 -day Trial Real Experience. Real Advantage. 25

] [ § Thank you. Real Experience. Real Advantage. 26