1 / 20

PS Financial Gateway Implementation v9.0 Use Case

PS Financial Gateway Implementation v9.0 Use Case. By Rick Gray rgray2@aep.com (614)716-1998. Contents. AEP – Company Overview Project Scope FG Overview Implementing – Bank File Loading Upgrading Bank Account Reconciliation Payment Process Upgrading AP Electronic Payment Process

jana
Download Presentation

PS Financial Gateway Implementation v9.0 Use Case

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. PS Financial Gateway Implementation v9.0Use Case By Rick Gray rgray2@aep.com (614)716-1998

  2. Contents AEP – Company Overview • Project Scope • FG Overview • Implementing – • Bank File Loading • Upgrading Bank Account Reconciliation • Payment Process • Upgrading AP Electronic Payment Process • Implementing Treasury Electronic Payment Process • FG Processing Customization and Challenges • FG - “What we liked” • AEP Requests for FG • Questions

  3. AEP – Company Overview American Electric Power has been providing electric service for more than 100 years and is one of the nation’s largest electric utilities, serving in 11 states. 2009 • Revenues $13.5 billion • Net Income $1.362 billion • Service Territory ~ 200,000 Square Miles • Total Assets $45.2 billion • U.S. Customers Over 5.2 million • Employees ~ 20,000

  4. Project Scope • PS Modules: AP, AR/BI, GL, Treasury, Project Costing • Technical Upgrade • Reapply customizations, unless no longer required • No new functionality, unless replaced customizations • AP previously had custom electronic payment processes Financial Gateway replaced existing customizations • FG added functionality to Treasury for electronic payments • Technical Scope • Double upgrade from 8.0 -> 8.9 -> 9.0 (1.8 tera-bytes of data) • 5,358 Functional Requirements • 441 Customizations (Work Units) • 18,204 PeopleSoft, 222 non-PeopleSoft Objects customized

  5. Financial Gateway Scope Overview • Bank Statements (prior and current day) • Electronic Payments • Payment Acknowledgements PeopleSoft FCM Banks PeopleSoft FinancialGateway • Positive Pay Files (Customized) • Payroll (HRM) Can Build Custom Table

  6. Financial Gateway Overview Bank Statement Process Flow TreasuryManagement Bank Statement Table TreasuryManagement Cash Position Operations Back-end Bank System FinancialGateway Treasury Bank Reconciliation BAI Bank Statement Files Accounts Receivables Posting (Not Implemented at AEP)

  7. Implementing Bank File Loads • AEP imports bank files from 4 banks • All 4 sources (161 accounts) have prior day bank statement file imports • Two sources (100 accounts) have current day file imports (including Fed presentments for controlled disbursement accounts). Current Day imports are hourly from 8:00AM through 3:00PM. • Bank Transaction Volumes • 120,000 bank transactions a month in BAI2 format • BAI2 codes are used on the import mapping into the Treasury Bank Statement Tables • Customizations • None! • We did contact two banks and request some changes from the formatting we were using in the old version and they made the changes

  8. Upgrading Automated Bank Recon • Bank Transaction Volumes • 120,000 bank transactions per month • Reconciled 210,000 source transactions to the bank transactions • Sources include integrated AP, Other Accounts Receivable and Treasury • External sources include Payroll and Customer AR system • Post Upgrade • Auto reconciliation process went from 2 hour process to ½ hour each day • 96% of transactions auto-reconciled • Currently we reconcile “batch” total, we are looking to change to more detail line level based on improved performance, increasing accuracy.

  9. Upgrading Automated Bank Recon • Bank Reconciliation Customizations • We reduced customizations. Some reductions due to understanding the system better and others based on improved functionality. • Customizations still in place • Identifying Match Groups - places an id on each transaction to easily view the transactions matched, and provides detail on how they matched (which common field(s)). • Auto process initiation - This process determines which Accounts have activity and queues up the process initiation for each Account. This makes the reconciliation process more efficient and automated. Otherwise this would be a manual process or the process would run all banks and accounts at once. • Parse data within Adenda - Moves data out of addenda to a separate field for more efficient matching (instead of searching on the addenda (which is large), we parse that data out before hand to enhance performance of the matching process. • Sign-adjuster - Customization to determine the sign of the amounts on the bank statement. The bank statements do not have an identifier (+/-) for the amounts passed to us in the file. We created a customization to determine the sign based upon the BAI code.

  10. Financial Gateway Payment Overview Payment Process Flow Payment Acknowledgement Accounts Payables FinancialGateway Back-end Bank System Wire/Transfers TreasuryManagement ACH Payments

  11. Financial Gateway Overview Pages Used in FG for Payment Processing FinancialGateway Accounts Payables DispatchPayments Page Bank TreasuryManagement Override Payment and File Status (Change Transaction Status) Cannot Alter Data Import AcknowledgmentFiles Page • Payment Review with Drill Down capabilities does exist and is great!

  12. Financial Gateway Overview Configuration Required for Electronic Payments Integration Broker (Part ofPeopleTools) Communication AEP Sends to internal B2B (Webmethods encrypts and communicates with banks)

  13. Implementing FG Electronic Payments • Accounts Payables (AP) • AP had Existing Feeds for ACH and Wire Payments with two external banks • Re-engineered to electronic payments via FG, with no functionality loss! • Main Functionality Points or Requirements: • Separate AP payments from Treasury, ACH’s from Wires • Bank Accounts required new configuration (payment methods) • Non-standard payment information flow through • Payment review process

  14. Implementing FG Electronic Payments • AP Customizations: • Automatically switch the payment layout code between ACH and WIRE • AP users were prevented from changing payment layout • Customized FG dispatch to populate different comments in addenda field for Tax payments

  15. Implementing FG Electronic Payments • Treasury (TR) • Electronic payments is new functionality for TR • TR responsible for managing bank accounts, short and long term financing payments, and the daily funding of business units • Segregation of duties is very critical • Bank Account Configuration • Settlement Instructions • Initiating cash transactions • Bank Account Reconciliation • Timing (near real time) of payments • Ease and thorough review and/or approve payments • Audit trail in order to trace payment back to source

  16. Implementing FG Electronic Payments • Treasury (TR)Customizations • Security • Segregate Settlement Information from initiating payment • Require Templates (EFT’s) • Not removing any access to beneficiary account and routing numbers • Locked the Require two approvers to “Select” and “Approve” Settlements configuration • Allow update access to addenda information only • Payment Review – prior to release • Review All settlement information within Financial Gateway • Default Layout method based on payment type (avoid AP conflicts)

  17. Implementing FG Electronic Payments • Overall FG Implementation Challenges: • Extensive and complicated configuration • Coordinate communications with banks is a substantial effort • Mapping layouts • Encryption and/or decryption • Other security (passwords and test vs. production) • Exception Processing for Treasury • Cancel Payments, change a payment, payment must be in paid status • FG Customizations: • Scrub Delimiters • Customized Maps for Payments and Acknowledgments • Backing out a Bank Statement Load

  18. Financial Gateway – Accolades • FG “things we liked!”: • Sound module – not buggy • Intuitive for users…easy to navigate • Love the drill back to source transaction feature! • Drill back even allows you to go directly back to where you came from. • View of the payment and bank statement raw data is very useful • Integrated well with other Finance modules including accounting status

  19. Request for Improvements with FG • AEP’s Wish List: • Exception Processing for Treasury • Better Segregation of Duties – Security • Approval Process for Settlement Instructions • EFT Templates should not be editable • Scrub Delimiters • Payment Review should include a view of all settlement instruction, including addenda • Default payment layout based on payment type and disallow editing • Include HR (Payroll - Delivered) and Positive Pay Files • Map Fed Reference wire payment numbers from Acknowledgements back to source tables for reconciliation process • Backing out a Bank Statement Load

  20. Questions? Rick Gray AEP Cash Management rgray2@aep.com

More Related