Get documents about "Download Canadian Bank Data File for Peoplesoft
Description
Download Canadian Bank Data File for Peoplesoft document sample
Document Sample
Laurent Vreven, Global Commercial Products
Smart Data OnLine
Product Update
Market Requirements
Customer Expectations • GDS’s
• TMC’s
„ Universal Acceptance • Rail
Issuers Data Sourcing • Hotels
„ Tight Cost Control •…
„ Policy Compliance
„ Expense Automation
Data collection Global
„ Management Information Data Multinational
Data consolidation
Repository Consolidation
„ VAT Evidence Data matching
„ Multinational Reach
Standard Export Files Custom
„ Supplier Negotiation Data MIS Export Files
„ Competitive Pricing „ Unique requirements
„ Integration with legacy
„ Implementation & Support systems
MC differentiates with tools, systems,
infrastructure and innovation.
3
Smart Data OnLine
„ Proven: 8 years market presence
„ Cost effective: hosted solution
„ Supports all MasterCard corporate card programs
„ Turns card transaction data into useful company information:
‟ Transaction review
‟ Enriched data
‟ Reporting (spending analysis, supplier tracking…)
‟ Export Capability
„ Multi-lingual (14 languages)
„ Continuous enhancements through roadmap and releases
6
Smart Data OnLine Global Penetration
85 Issuers 41 Countries 50,000 Companies
(Europe: 28) (Europe: 14) (Europe: 24,100)
Belgium Netherlands
Denmark Norway
Finland Poland
France Spain
Canada Ireland Sweden
Italy Switzerland
Germany UK South
China Korea
USA Lebanon
Kuwait Japan
Saudi India Taiwan
Mexico Arabia UAE
Hong Kong
Venezuela Oman
Philippines
Languages Bahrain Thailand
„ Chinese-Traditional Singapore
„ Chinese-Simplified
Colombia Malaysia
„ Dutch
„ English-Int’l Brazil
„ English-American
„ French
Chile South Africa
„ French-Canadian Australia
„ German
„ Italian
„ Japanese Argentina
„ Korean
„ Portuguese Current Issuer Countries New Zealand
„ Spanish-Latin Amer
„ Spanish-Castilian
7
Transaction Flow from Point of Sales
to Global Data Repository
Cardholder Merchant Acquirer Interchange Issuer
CDF Components
GCMS Data
Local Transaction Data
CDF Corporate Hierarchy
CDF Global Data Repository Portfolio Mgmt Data
Cardholder Information
Customer System Generated Messages
GDR
Supplemental Data
Airline Data
Lodging Data
SDOL Line Item Details
10
SDOL Functionalities
„ Allows cardholders to access their data and to cost
allocate transactions and create expense reports
„ Allows managers to view and approve employee purchases
„ Allows a company administrator to access all
cardholder account information and transaction data
„ Provides reports:
- To track and analyze card and supplier spend
- To manage and monitor overall program
- To facilitate government tax reporting such as VAT
„ Offers data extract tool that allows customer to select from the hundreds of data fields available and
download in a variety of formats
11
1. Viewing Information:
from Big Pictures to Granular Details
13
1. Viewing Information: Enhanced Data Sample Screens
Enhanced Lodging Detail
Airline Trip Segment Detail
Purchasing Level 3 Line Item Detail
14
2. Enriching Information
Card Transaction data, credits,
bank fees, etc arrive on SDOL
via the CDF process.
Cost allocation codes, merchant
associated codes or other custom
information, entered by If necessary, easy to use drop
administrators is automatically added down boxes and input fields
to the existing transaction data. allow users to make any
manual changes to codes.
Even non-card
transactions can
be added to the
system.
15
3. Analyzing and Reporting Information
Standard Reports - examples
SDOL Administration
Account Status Merchant Information
User Authorities Merchant Category Monthly Summary
Merchant Detail
Program/Account Reports Merchant Monthly Summary
Account Spending Analysis - Summary Top Ten Merchant Spend
Account Spending Analysis - Detail
Account Statement Purchasing Card Information
Card Program Analysis Line Item Detail
Cost Allocation - Detail Merchant Supplier Summary
Cost Allocation - Summary Supplier Transaction Detail
Non Card Transaction Detail VAT Reports
Original Currency
Top Ten Cardholder Spend Travel & Entertainment
Airline City Pair Detail
VAT Advisor Airline Summary
Summary Expense
Detail Original Currency
Top Hotel Chains
17
4. Exporting Information
Custom Exports can be offered to large
organizations:
• User defined data elements
downloaded
• Includes Excel & tab delimited
formats
• Data can be further analyzed
• Data can be imported into ERP
system
19
Global Data Repository
(GDR)
MasterCard ExpenSys
Makes business travel simpler, more efficient by allowing companies to…
„ Automate the integration of card transactions
with expenses.
Member „ Reduce chances of data manipulation and
Financial
Institutions errors.
MasterCard Data
Repository
„ Automate expense reports management.
MasterCard
Cardholders „ Choose the expense management provider
that’s right for them.
Alliance Partners
21
Issuer Support
Issuer & Customer Support
User Documentation: Online Help: Help Desk:
„ Issuer Guide „ MCW provides 24x7 Level 2 support:
„ Company Guide „ Phone & email
„ Manager Guide „ Issuer provides Level 1 support to
„ Account User Guide customers
„ Sample Reports „ May assign an online customer
„ Export Fields Guide support email address in SDOL
„ Custom Export Guide
„ Authorities Guide (new!)
24
Third European Smart Data User Group
„ 2006 April 25 & 26 in Brussels
„ Agenda:
‟ Presentation of the new releases 7.1 and 7.2
‟ Outline on SDOL customer & training support in Europe
‟ Workshop 1: desired product enhancements
‟ Workshop 2: communications
„ 19 participants from 11 issuers
„ 95% very satisfied or satisfied
„ Proposed enhancement list compiled
“The conference is a great idea to meet with other issuers and understand/compare
thoughts/problems/ideas”
25
Fourth European Smart Data User Group
Agenda Day 1 (Nov 29)
„ 10:00 - 10:15 Welcome and Introduction L. Vreven
„ 10:15 - 10:45 European Update L. Vreven
„ 10:45 - 12:00 SDOL 8.2 Release Presentation J. Mayer
„ 12:00 - 12:15 Break
„ 12:15 -13:00 Customer Services E. Cauwenbergh
„ 13:00 - 14:00 Lunch
„ 14:00 -14:45 Smart Data Gen 2 Roadmap J. Mayer
„ 14:45 - 15:30 Smart Data Gen 2 for Business J. Eigner
„ 15:30 - 16:00 Break
„ 16:00 - 16:45 Smart Data Gen 2 for Corporate J. Mayer
„ 16:45 - 17:30 Migration Planning P. Manning
„ 17:30 - 17:45 Wrap up L. Vreven
26
Fourth European Smart Data User Group
Agenda Day 2 (Nov 30)
Workshop (Main Room) - 09:00 till 13:00
„ Workshop Session 1
„ 09:00 - 09:15 Welcome L. Vreven
„ 09:15 - 10:15 Smart Data Gen 2 ‟ Demonstration J. Eigner
„ 10:15 ‟ 11:00 SDOL Advanced Function ‟ Training C. Ludorf
„ Workshop Session 2 (idem as session 1)
„ 11:15 - 12:15 Smart Data Gen 2 ‟ Demonstration J. Eigner
„ 12:15 ‟ 13:00 SDOL Advanced Function ‟ Training C.Ludorf
One to One Session (Individual Issuer session of 20 min) ‟ 09:00 till 13:00
„ 13:00 - 14:00 Lunch
27
Marketing Support
28
Key Takeaways &
Summary
SDOL Proposition - Summary
„ Robust ‟ years of proven experience
„ Fresh- continuous developments
„ Cost Efficient
„ Scalable - support all Commercial Card Products
„ User Centric - Allow for Product Segmentation
„ Accredited - VAT Invoices compliant
„ Flexible - Interface to multiple accounting system
„ Global - Multinational/multi issuer capable
30
Thank you.
31
Multinational Consolidation
„ Standard data file process and Global Data Repository
„ Supports global MIS consolidation and local reporting
XYZ UK
Lead Bank
Local
Member Bank
XYZ
XYZ HQ Hong Kong
XYZ Local
Mexico Member Bank
Lead Bank Affiliate
Local Local
= MasterCard International Member Bank XYZ Member Bank
Smart Data Repository South Africa
= Corporation HQ and Subsidiary XYZ Brazil
Local
Member Bank XYZ
= Lead Bank to Multinational Subs. Australia
= Lead Bank
= Local CDF Transmission Feeds
= Smart Data Reporting to Subsidiary
= Global Roll-up to Multinational HQ 32
Multinational Capabilities:
Company Group Structure
Company Group Admins (CGA):
„ Access to all group data
Company „ Apply currency conversions
Group Admin „ Run local or global reports
„ CGA capabilities same as local Company Administrators allowing to manage all
companies if desired
Company 1 Company 2 Company 3 Company 4
Australia U.K. Japan U.S.
Company Admin Company Admin Company Admin Company Admin
„ Company Administrators manage all aspects of local programs and are restricted to their local company data
33
Smart Data OnLine
„ Supports all MasterCard corporate card programs
„ Turns card transaction data into useful company information:
‟ Transaction review
‟ Enriched data
‟ Reporting (spending analysis, supplier tracking…)
‟ Export Capability
„ Cost effective web based application
„ Multi-lingual (14 languages)
„ Continuous enhancement through roadmap and releases
34
Smart Data Express
„ Launched August 2003
„ Targeted for Small Business
„ Set of functionalities:
‟ Transaction review
‟ Three expense reports
‟ Two export formats
„ Web-based reporting solution built on java platform
„ Flexible architecture and methodology
„ Allows for regional and issuer differentiation
„ Available in 12 languages
35
MasterCard ExpenSys
„ Some customers only need card data ‟ not SDOL ‟ and can receive this direct from the GDR.
„ ExpenSys service offers data preformatted for many ERP systems.
Other ERP file integration experience:
„ Customer-Defined, Extensity, GXS, IBM TEA, iCMS, myPCard.
One customer can have multiple data file distributions:
„ SDOL for transaction investigation and reporting.
„ ERP file output for GL allocation.
36
myProvider
„ Web-based self-service giving Issuer Support Staff immediate access to GDR data and common maintenance tasks
„ Cross-check transaction and hierarchy data
„ Verification of processor-sent hierarchy
„ Monitor inbound and outbound files at a glance
„ Research GDR data based on the information you have
„ Troubleshoot “missing transactions”
„ Setup Wizard for SDOL application
„ View Company Group Membership
„ Resend data files
37
Security
Protocol, Encryption, and Firewall
‟Access to SDOL through standard secured data transmission protocol HTTPS (SSL)
‟SDOL uses 128-bit encryption
‟Database behind 2 MasterCard Firewalls
User ID and Permissions
‟Access only via unique user ID & password
‟All access granted with specific permissions
‟e.g. Cardholders restricted to their own financial transactions
Masked sensitive information
‟Account Numbers are masked
‟Full account number never sent to the browser
‟Option to mask Employee ID
38
SDOL Highlights
„ Issuer
‟ Extensive co-branding
‟ Multiple setups for different card programs if desired
‟ Complete customisation
‟ Access to all customer data
‟ Main menu system messaging ‟ all or Company specific
‟ Offline and online cardholder maintenance
‟ Offline disputes
39
SDOL Highlights (2)
„ Company Administrator
‟ Extensive customisation
‟ Company logo on main menu
‟ Define and assign access
‟ Spending exception setup
‟ Mass download/upload
‟ Automated hierarchy setup
40
SDOL Highlights (3)
„ Multinational
‟ Global rollup reporting
‟ Currency conversion
‟ Accommodates different issuers and card brands
„ Enhanced Data
‟ Level 1, 2, and 3
‟ Airline, hotel, LID, car rental, fleet
‟ Airline reservation systems
‟ Travel agency
41
SDOL Highlights (4)
„ User Access & Transaction Review
‟ Assign user ID to any hierarchy level
‟ Supervisor ID available for non-hierarchy
‟ Automated registration & password reset
‟ Transaction review/approval process
‟ Transaction dispute process
‟ Transaction Audit Trail
42
SDOL Highlights (5)
„ Cost Allocation
‟ Extensive company-defined GL capabilities:
‟ 12 drop-down lists, 16 input boxes, 16 flags
‟ Cross Validation:
‟ Accommodates different GL systems
‟ GL options based on user
‟ Input validation
‟ MCC, supplier, Point of Sale Code, GL process
‟ Default mapping
‟ ERP data mapping and export
43
SDOL Highlights (6)
„ Expense Reporting
‟ Cash (non-card) expense input
‟ Transaction splitting
„ Reporting & Data Export
‟ Fifty standard product-specific reports
‟ Robust Custom Export tool with filtering
‟ Various export formats
‟ Report and export schedulers
44
User Types
Company Administrator
„ Configures & Maintains System for Company
„ Manages Hierarchy if issuer doesn’t
„ Creates & Maintains Users & Templates
„ Can lock & unlock all transactions
„ Access to all cardholder transaction information
Intermediate User
„ Access to cardholder information based upon organisational structure
„ Ability to lock & unlock transactions for assigned cardholders
„ Maintain & configure assigned users
Supervisor User
„ Access to cardholder information as assigned by Company Administrator
- Not dependent on company hierarchy
„ Ability to lock & unlock transactions for assigned cardholders
„ Maintain & configure assigned users
Account User
„ Only has access to their individual account information
„ Ability to only lock transactions
45
Related docs
Other docs by dsa14261
Dont Take Internal Customer for Granted Explain No Ensure Information Overflow
Views: 39 | Downloads: 0
