excel zero to sap hero - blog.asug.com ac slide decks tuesday/asug82538... · automated...
TRANSCRIPT
![Page 1: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/1.jpg)
May 7 – 9, 2019
Excel Zero to SAP Hero: A Phased Approach to Implementing SAP Treasury
Patti Hocker, Manager, Treasury Operations, TDS Brooke McCullick, Senior Treasury Analyst, TDS
Session ID ASUG82538
![Page 2: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/2.jpg)
About the Speakers
Patti Hocker
• Manager, Treasury Operations, TDS
• Over 30 years of experience in treasury and banking. MBA-Finance, CTP, AAP
Brooke McCullick
• Senior Treasury Analyst, TDS
• 11 years experience in Treasury
![Page 3: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/3.jpg)
Key Outcomes/Objectives
1. Stop using Excel by creating a effective business case for SAP Treasury.
2. Implement treasury modules in phases to eliminate scope creep and stay on budget.
3. Structure your project team to enhance knowledge transfer and break down silos.
![Page 4: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/4.jpg)
Agenda
• Company Overview
• Business Case
• Phased Approach
– Phase 1
– Phase 2
• Project Team Alignment
• Lessons Learned
• Questions
![Page 5: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/5.jpg)
Company Overview
![Page 6: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/6.jpg)
Operations
![Page 7: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/7.jpg)
Treasury Organization
![Page 8: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/8.jpg)
Cash Management Structure
• Legal Entities
• Bank Rationalization
• Investments
• Debt
![Page 9: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/9.jpg)
SAP Environment
• One instance of SAP ECC 6.0
– Enhancement Pack 7
• SAP Treasury and Risk Management:
– Transaction Manager • Money Market
• Debt Management
– SAP Cash & Liquidity Management • Cash Management
![Page 10: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/10.jpg)
Business Case Strategy
Strategic Focus
Integrated Treasury System
Deploy Best Practices
Trusted Business
Partner to the Enterprise
Maintain Well Controlled
Environment
![Page 11: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/11.jpg)
Objectives
BEFORE
• Heavy reliance on Excel
• No integration between SAP & Treasury spreadsheets used to produce financially relevant data
• Limited IT technical support
• Manual amortization schedules and journal entries
AFTER
• No reliance on Excel
• SAP & Business Intelligence integration used to produce financially relevant data & reporting
• Full IT technical support
• Automated amortization and journal entries
![Page 12: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/12.jpg)
Driving Factors
• Risk mitigation
• Improve internal controls
• Integration into SAP FI
• Improve operational efficiency
• Refine cash forecasting
• Enhance reporting functionality
![Page 13: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/13.jpg)
Solution Assessment
• Socialized the treasury strategy internally
• Partnered with IT & stakeholders to identify requirements
• Evaluated several treasury workstations
• Consulted with treasury professionals and associations
• Performed a gap analysis
• Vetted industry-leading consulting firms
• Interviewed SAP Treasury clients
![Page 14: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/14.jpg)
Recommendation
• Implement SAP Treasury
• External Consulting Firm
• Phased Approach
• Short Durations
• Limited Scope
![Page 15: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/15.jpg)
Benefits of Phased Approach • Control scope creep
• Stay on budget
• Achieve milestones on schedule
• Prevent team burnout
• Expedite business case approval
• Retain consistent resources
• Narrow focus for knowledge transfer
• Keep team focused on big picture
• Breathing room to solidify and document daily processes
![Page 16: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/16.jpg)
Phase I Cash Management
• Daily cash position
• Initiate ACH & domestic wire transfers
• Prior and current day BAI files
Short-term & Long-Term Investments
• Record interest accruals, amortization, coupon payments
• Distribute interest income to subsidiaries
• Utilize Business Objects for management reporting
Long-Term Debt
• Record deferred debt charges, accretion of discount, interest accruals and payments
![Page 17: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/17.jpg)
Phase I Timeline
![Page 18: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/18.jpg)
Phase II - Short Term Debt Inter-Company Lines of Credit
• Capitalized Interest
• Initiate and record borrowing and repayment of principal
• Record interest payments through inter-company netting
Revolving Credit Agreements & Term Loan
• Initiate and record borrowing and repayment of principal
• Initiate and record interest and fee payments
• Record accruals for interest and fees
Standby Letters of Credit
• Initiate and record fee payments
• Record accruals for fees
![Page 19: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/19.jpg)
Phase II Timeline
![Page 20: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/20.jpg)
Project Team Alliance
• Cross functional SMEs
• One large work room
• Duration is beginning to end
• Involved in all aspects including UAT
• Reduced functional silos, increased engagement & accelerated learning
![Page 21: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/21.jpg)
• Timing of go-live
• Understand the big picture
• Open, sharing, fun environment
• Ownership and escalation of issues
• Adequate time for knowledge transfer
• Multiple pass & cross-functional testing
• Engage banking partners early and often
• Have a clear understanding of deliverables
• Command center environment
• Don’t be afraid to ask for help and challenge the status quo
• Celebrate your success!
Lessons Learned
![Page 22: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/22.jpg)
Take the Session Survey.
We want to hear from you! Be sure to complete the session evaluation on the SAPPHIRE NOW and ASUG Annual Conference mobile app.
![Page 23: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/23.jpg)
Access the slides from 2019 ASUG Annual Conference here:
http://info.asug.com/2019-ac-slides
Presentation Materials
![Page 24: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/24.jpg)
Q&A For questions after this session, contact us at:
![Page 25: Excel Zero to SAP Hero - blog.asug.com AC Slide Decks Tuesday/ASUG82538... · Automated amortization and journal entries. Driving Factors •Risk mitigation •Improve internal controls](https://reader030.vdocuments.us/reader030/viewer/2022040313/5e0a0d013378ee2b48443ae1/html5/thumbnails/25.jpg)
Let’s Be Social. Stay connected. Share your SAP experiences anytime, anywhere.
Join the ASUG conversation on social media: @ASUG365 #ASUG