20707M PeopleSoft Treasury For Dummies By Dummies

WCRUG ‘15PeopleSoft Treasury 101 for Dummiesby DummiesNovember 2015

AgendaYour SpeakersSession ObjectivePeopleSoft Treasury OverviewCash ManagementDeal ManagementWorkflows & IntegrationDashboardsQuestions1 Deloitte & Touche LLP and affiliated entities.

The Dummies

The DummiesSharan SharmaJosh Chapman3Role: PeopleSoft Financials ConsultantDeloitte: 5 Experience: PeopleSoft Financials and Reporting Senior Consultant PMP Certified Oracle PeopleSoft 9 General Ledger Consultant Certified Over 5 years of PeopleSoft implementation and upgrade experienceRole: PeopleSoft Financials ConsultantDeloitte: 4 Experience: PeopleSoft Financials and Supply Chain Senior Consultant Certified Management Consultant (CMC) Implemented large scale ERP projects in higher education, healthcare and Financial Services Deloitte & Touche LLP and affiliated entities.

Session Objective

Objective Outlining the Business Process as the Foundational Scope How PeopleSoft’s Treasury Management Drives Value Comprehensive Perspective with Dashboards and WorkCenters Integrated Enterprise Solution5 Deloitte & Touche LLP and affiliated entities.

PeopleSoft Treasury Overview

PeopleSoft Treasury OverviewManage short & long term cash inflows and outflows through accuratecash forecasts and modelingCash ManagementCash ForecastingInvest organization cash in accordance with forecasted cash inflow & outflowusing deal managementCash ManagementDeal ManagementCreate risk management strategies and implement hedging tactics to lessenorganizational riskDeal Management7Working Capital Deloitte & Touche LLP and affiliated entities.

Banking

Bank AccountsBank Accounts provide the foundation for the transfer of funds between your organization and counterpartiesDefining bank, counterparty and bank account informationEstablishing payment methods such as electronic funds transfer, automated clearing house andWIRE formatsDefining account reconciliation methodsReconciling bank statement information with system transactionsManaging and resolving reconciliation exceptions9 Deloitte & Touche LLP and affiliated entities.

Statement ReconciliationPeopleSoft delivers a variety of methods to reconcile your organization’s bank statementsAutomatic reconciliation- Automatic journal entries for defined discrepancies- Bank statement accounting; searches to reconcile exceptions that match predefined criteriaSemi-manual reconciliation- Bank statement accounting- Manual journal entries for differencesManual reconciliation- Manual journal entries for differences10 Deloitte & Touche LLP and affiliated entities.

Integration with Financial InstitutionStandard messaging directly with Bank including acknowledgement of payment status’; centralizing all bankactivity and bank communications into one applicationFG generates the defined form ID and layout for the electronic settlement of Wire TransfersSupports creation of payments into multiple EFT file formats; eliminates enhancements of SQRs used in thecreation of EFT filesSupports consolidation of EFT Files, minimizing the number of files created and transmittedAbility to process bank statements in a variety of formats (Ex. BAI2 statement format commonly provided byBanks)11 Deloitte & Touche LLP and affiliated entities.

Integration with Financial Institution12 Deloitte & Touche LLP and affiliated entities.

Cash Forecasting

Cash ForecastsPeopleSoft allows various options to configure, setup and view a Cash ForecastActual vs Projected, Bank Account View, Daily/Intra-Day Cash ForecastAbility to enter manual cash positionsConfigure forecast rules to run comparativesImport Cash Forecast Data from third party systems14 Deloitte & Touche LLP and affiliated entities.

Actual vs Projected15 Deloitte & Touche LLP and affiliated entities.

Bank Account View16 Deloitte & Touche LLP and affiliated entities.

Daily Cash Forecast17 Deloitte & Touche LLP and affiliated entities.

Forecasting Rules18 Deloitte & Touche LLP and affiliated entities.

Deal Management

Deal ManagementOptimize Treasury activity by configuring deals and automating deal administrationSet up InstrumentsSet up instrument related accounting entry templatesCapture and store deal informationGenerate Payment Schedule Information based on captured deal attributes20 Deloitte & Touche LLP and affiliated entities.

Instruments – Accounting Templates21 Deloitte & Touche LLP and affiliated entities.

Deals – Payment Schedules22 Deloitte & Touche LLP and affiliated entities.

Workflows & Integration

Workflows & IntegrationDelivered workflows for Cash Management & Deal ManagementFinancial GatewayDeal Management, Cash Management, Risk Management Integrate with General LedgerAdditional Cash Management Integration with Accounts Payable, Accounts Receivable24 Deloitte & Touche LLP and affiliated entities.

WorkCenters & Dashboards

Treasury WorkCenterThe Treasury WorkCenter is a central navigational component that is designed for the end userCentralizes frequently used pages and pagelets – each pagelets contain links, subdivided intofunctional groupings that assist end users in day to day tasksDesign for specific roles with access to specific componentsWithin the primary tabs of the WorkCenter, there are the following pagelets:Main Tab:- My Work- LinksReports/Queries- Queries- Reports and Processes26 Deloitte & Touche LLP and affiliated entities.

Treasury WorkCenter27 Deloitte & Touche LLP and affiliated entities.

Treasury DashboardThe Treasury Dashboard will provide managers with a unique view of the cash position for the organization28 The Treasury Dashboard consists of components which display cash management, deal management and operationaldata in summary, detail and chart formats. Provides a clear visual concept of the financial state of an organization, enabling managers to effectively manage andmonitor cash in the organization.Cash Management Dashboard Cash Position by Bank Cash Position by Transaction Currency Cash Position by Source Set Cash Position by Business Unit Cash Position by Worksheet Line ItemDeal Management Dashboard Investment Mix Debt Mix Fixed versus Floating Rate Investments Fixed versus Floating Rate Debt Open Foreign Exchange ContractsPayment Dashboard Payments by Source Payments by Status Payments by Bank Payments by Payment MethodBank Statement Load Dashboard Deloitte & Touche LLP and affiliated entities.

Treasury Dashboard29 Deloitte & Touche LLP and affiliated entities.

Questions

The Dummies Role: PeopleSoft Financials Consultant Deloitte: 5 Experience: PeopleSoft Financials and Reporting Senior Consultant PMP Certified Oracle PeopleSoft 9 General Ledger Consultant Certified Over 5 years of PeopleSoft implementation and upgrade experience Sharan Sharma Role: PeopleSoft Financials Consultant