Welcome to DTN TRAINING The session will begin
Welcome to: DTN TRAINING The session will begin shortly.
INTRODUCTION
ADDITIONAL INFORMATION Note Warning
BW SUPPORT ACE Support • systemsupport@exxonmobil. com • 1 -800 -265 -0060 DTN Support • Issues with reports or the delivery of reports • 1 -800 -779 -5779 • energysupplierhelp@dtn. com Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en BW Resources: • DTN Virtual Training • DTN User Guide • DTN Quick Reference Guide Retailer Resources: • Retailer Reports Guide • Retailer Quick Reference Guide
DTN USER AND QRG GUIDES Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en
DTN ACTIVITY DTN Activity ?
AGENDA DTN Portal Manage Retailers View Reports Use Reports
MODULE 1 MODULE 2 MODULE 3 MODULE 4: USE REPORTS
CREDIT CARD REPORTS Code Report Name Description Credit Card Reports BW R CCM Card Settlement Report Day/Shift summary totals and adjustments DFM Daily Card Sales Fee Report Daily summary of total sales and card fees by card type FMM Monthly Card Sales Fee Report Monthly summary of the daily card sales fee reports PCR PRICE PRIVILEGES/Car Wash Redemption Report PRICE PRIVILEGES/Car Wash dollar amounts for loyalty points redeemed. RTV Ticket Requests Ticket retrieval request Multiple Sales Report Daily report identifying multiple inside sales (credit only; no debit or Fleet) by truncated card number, to help detect possible fraud MSR
LOYALTY REPORTS Code Report Name Description Loyalty Reports LRD Daily Loyalty Detail Report BW BW Loyalty Detail Report (LRD): • LRDa: Transaction level dollar amounts for loyalty points issued/redeemed for all BW Dealers • LRDb: Transaction level details for loyalty points issued/redeemed for all BW Dealers Dealer Loyalty Detail Report (LDD): • LDDa: Transaction level dollar amounts for loyalty points issued/redeemed • LDDb: Transaction level details for loyalty points issued/redeemed Periodic report – Summary of cards that were used multiple times at a site in one day LPF Daily Loyalty Potential Fraud LRS Daily Loyalty Summary Report Loyalty program summary data by Dealer with BW totals LMS Monthly Loyalty Summary Report Monthly roll up of loyalty activity for all BW Dealers R
START AND END MESSAGES Start Report Message IOL 1 3152950000 DFM-0008 12 -08 -17 START MSG Definition IOL 1 BW ID Report Code – Sequence ID Date sent: Month-day-year Start of report message End Report Message IOL 1 3152950000 DFM-0008 12 -08 -17 END MSG Definition IOL 1 BW ID Report Code – Sequence ID Date sent: Monthday-year End of report message
CARD CODES CODE Card Type MC Mastercard Fleet VI Visa DI Discover EB Citi Exxon. Mobil Consumer Citi Exxon. Mobil Commercial Fleet AX American Express DE Interac Debit GA Esso and Mobil Gift Card Activation GR Esso and Mobil Gift Card Redemption CA Esso and Mobil Carwash Card Activate CW Esso and Mobil Carwash Card Redeem CP PRICE PRIVILEGES Card Activate CD PRICE PRIVILEGES Card Redeem WX WEX Esso and Mobil Fleet WEX Universal and Other Fleet EF WEX Exxon. Mobil Fleet
RECONCILIATION Card Settlement Report (CCM) • Indicates IOL payment to be received. TOTAL SALES / NET SALES AMT MINUS DE (Debit Card Sales) ADD TOTAL CD (PRICE PRIVILEGES Card Redemptions) ADD TOTAL CW (Esso and Mobil Car Wash Redemptions) ADD ALL Sites Total (NET of $$ Value of Points Redeemed MINUS Total Issued Value) DFM Daily Card Sales Fee Report PCR – PRICE PRIVILEGES/Car Wash Redemption Report LRDa Daily Loyalty Detail Report Note: Totals from POS may vary slightly with DTN Report totals due to rounding.
CARD SETTLEMENT REPORT (CCM) • Indicates IOL payment to be received. Report Start Message Retailer #1 Information • Shift Totals • Total Fees • Total POS Sales and NET Retailer #2 Information • Shift Totals • Total Fees • Total POS Sales and NET BW Summary Information • TOTAL PROCESSING FEES • GRAND TOTAL = IOL Payment • Debit Transactions not included End Report Message
ACTIVITY CODES O-OUT, I-IN, E-CREDIT/DEBIT CARD, S-SPEEDPASS, P-PAPER, M-MOBILE, X-MCX Code O-OUT I-IN E-CREDIT/DEBIT CARD S-SPEEDPASS P-PAPER M-MOBILE X-MCX Description Outside Sales Inside Sales Credit or Debit Card Speedpass Not used in Canada Speedpass+ Mobile Application Not used in Canada
DAILY CARDS SALES FEE REPORT – PAGE 1 Sale and Process Dates Retailer #1 Information • Retailer #1 Number • Retailer #1 Transaction Information Retailer #1 Summary Information Continued message
DAILY CARDS SALES FEE REPORT – PAGE 2 Retailer #2 Information • Dealer Number • BW ID Number Retailer #2 Transaction and Summary Information BW Summary Information • Distributor Summary for all Retailers • Tran Fee vs. % Fee DEBIT CARD Summary • Not just INTERAC END MSG
DEBIT CARD SUMMARY DEBIT CARD Summary • Not just INTERAC Includes the following transactions: • DE INTERAC Debit Card Transactions • GA Esso and Mobil Gift Card Activations • GR Esso and Mobil Gift Card Redemptions • CA Esso and Mobil Car Wash Activations • CP PRICE PRIVILEGES Activations
RECONCILIATION 1 – DFM Reconciliation 1: DFM TOTAL SALES / NET SALES AMT MINUS DE (Debit Card Sales) Note: The existing Retailer settlement process related to Interac Debit transactions has not changed.
PRICE PRIVILEGES/CAR WASH REDEMPTION REPORT (PCR) Retailer # 1 • • PRICE PRIVILEGES Redemptions Esso and Mobil Carwash Card Redemptions Retailer #2 • • PRICE PRIVILEGES Redemptions Esso and Mobil Carwash Card Redemptions Distributor Summary • All Retailers Redemptions Reconciliation 2: PCR ADD TOTAL CD (PRICE PRIVILEGES Redemptions) ADD TOTAL CW (Esso and Mobil Carwash Card Redemptions)
DAILY LOYALTY DETAIL REPORT – LRDa Retailer #1 Information • $ amounts for points • Fuel & non-Fuel sub-totals Retailer #2 Information BW Summary Information ALL Site Total: • NET of $S Value of Points Redeemed MINUS $ Total Issued Value Reconciliation 3: LRDa ADD ALL Site Total
SUMMARY REPORTS Credit Card Reports 1. Monthly Card Sales Fee Report (FMM) 2. Ticket Requests (RTV) Loyalty Reports 1. Daily Loyalty Detail Report (LRDb) 2. Daily Loyalty Potential Fraud (LPF) BW Only Reports 3. Daily Loyalty Summary Report (LRS) 4. Monthly Loyalty Summary (LMS)
MONTHLY CARD SALES FEE REPORT (FMM) Monthly summary of the daily card sales fee reports Retailer #1 Information • Card Type and various Totals information by ü Transactions ü Gross Sales ü Total Fees ü Net Sales Amt Retailer #2 Information Distributor Summary • Summary of information from all Retailers
TICKET REQUESTS (RTV) Ticket Requests (RTV)
DAILY LOYALTY DETAIL REPORT (LRD b) Transaction level details for loyalty points issued or redeemed. Retailer #1 Information • Total Points Redeemed • Total Points Issued üBase Points Issued üBW Promo Points Issued (N/A) üIOL Promo Points Issued Retailer #2 Information BW Summary Information • Totals ü Fuel ü Non-Fuel ü Transaction count ü Points redeemed ü Points issued
DAILY LOYALTY POTENTIAL FRAUD (LPF) Daily Loyalty Potential Fraud (LPF)
DAILY LOYALTY SUMMARY REPORT (LRS) Loyalty program summary data by Retailer with BW totals Summary by Retailer BW Summary Information
MONTHLY LOYALTY SUMMARY (LMS) Monthly roll up of loyalty activity for all BW Retailers. Summary by Retailer BW Summary Information
DTN USER AND QRG GUIDES Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en
BW SUPPORT ACE Support • systemsupport@exxonmobil. com • 1 -800 -265 -0060 DTN Support • Issues with reports or the delivery of reports • 1 -800 -779 -5779 • energysupplierhelp@dtn. com Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en BW Resources: • DTN Virtual Training • DTN User Guide • DTN Quick Reference Guide Retailer Resources: • Retailer Reports Guide • Retailer Quick Reference Guide
? Q&A Questi ns
THANK YOU! YOU
- Slides: 32