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: DTN Portal MODULE 2 MODULE 3 MODULE 4
ACCESS ACE • https: //cs-selfserve. exxonmobil. com ACE Access • systemsupport@exxonmobil. com • 1 -800 -265 -0060 DTN Access • Complete ACE registration form requesting DTN access.
LOGGING ON Logging On • Go to ACE • Enter your User ID and Password
GO TO MY ACCOUNT Open Select My Account; a submenu appears Click on My Account in the submenu
MY ACCOUNT DTN Portal: Opening page Account Number Manage Retailer Reports
REPORTS DISPLAY Filter Icon Search Results Note: The Search box is not used in DTN.
DTN USER AND QRG GUIDES Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en
? CHECK-IN Questi ns
MODULE 1 MODULE 2: MANAGE RETAILERS MODULE 3 MODULE 4
MANAGE BW SITE REPORTS • Indicates which reports are automatically sent to Retailers
MANAGE DEALERS • Scroll to find a Retailer • Type in Retailer Number to search • Drop-down menu with matching Retailer numbers appears
DEALER DETAILS • Retailer name • Report Recipients • Retailer Language • French and English only
EMAIL ADDRESS • Enter a valid email address • Before you can Select Reports to send to the Retailer
REPORTS TO SEND • Select individual reports OR • All reports
RETAILER REPORTS Code Report Name Description Credit Card Reports 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 redeemed. MSR Multiple Sales Report Daily report identifying multiple inside sales (credit only; no debit or Fleet) by truncated card number, to help detect possible fraud RTV Ticket Requests Periodic report – Ticket retrieval request Loyalty Reports • LDD LPF Dealer Loyalty Detail Report (2 reports) Daily Loyalty Potential Fraud • 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
ADDING • Select individual reports OR • All reports • Maximum 4 email addresses.
COMPLETING • Information updated on Dealer Details screen • Click Close to return to My Account
RETAILER UPDATED • Retailer information updated • Click My Account
DTN USER AND QRG GUIDES Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en
? CHECK-IN Questi ns
MODULE 1 MODULE 2 MODULE 3: VIEW REPORTS MODULE 4
CREDIT CARD REPORTS Code Filter Display Report Name Description Credit Card Reports BW R CCM Credit Card Settlement Report Day/Shift summary totals and adjustments DFM Daily Fee Memo Daily Card Sales Fee Report Daily summary of total sales and card fees by card type FMM Monthly Fee Memo Monthly Card Sales Fee Monthly summary of the daily card sales fee Report reports Ticket Requests RTV Credit Card Ticket Requests Periodic report – Ticket retrieval request PRICE PRIVILEGES/Car PRICE PRIVILEGES & PRICE PRIVILEGES/Car Wash dollar amounts PCR Wash Redemption Car Wash Redemptions for loyalty points redeemed. Report MSR Multiple Sales Report Daily report identifying multiple inside sales (credit only; no debit or Fleet) by truncated card number, to help detect possible fraud
LOYALTY REPORTS Code Filter Display Report Name Description Loyalty Reports LRD Loyalty Details BW Daily Loyalty Detail Report R 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 LRS Loyalty Details Summary Daily Loyalty Summary Loyalty program summary data by Dealer with BW Report totals LMS Loyalty Monthly Summary Monthly Loyalty Summary Report Monthly roll up of loyalty activity for all BW Dealers LPF Loyalty Potential Fraud Daily Loyalty Potential Fraud Periodic report – Summary of cards that were used multiple times at a site in one day Note: Arrangements can be made with DTN Support to have reports sent in a digital format to allow for integration into the BW’s system.
DAY-END CLOSE Day-End Close Process Ø Once every 24 hours Ø Between 2: 00 pm -1: 45 pm EST Ø DTN reports delivered by 6: 00 am EST next calendar day Day-End Close Ø Run Shift and Day-End Ø Initiates ü Interac Debit Batch Close ü Loyalty Day-End Close Back-Office Day-End pushkey Ø Only if Retailer has a Back-Office connection Forced Day-End Ø Ø Forced at 1: 45 pm EST Interact Debit NOT triggered. Loyalty day-end NOT forced. No loyalty info. in DTN reports Note: There are no changes to the existing Retailer settlement process related to Interac Debit transactions.
FILTERING REPORT Filter icon • Report Search Edit icon • Sold-to: Number
MESSAGE DATE FILTER Click: Calendar icon. Select: Click on arrows to select month. Click on date in calendar. Select FROM and TO dates Note: The FROM and TO dates cannot be more than 31 days apart.
REPORT RESULTS • Apply Filters • Results Display • Credit Cards • Loyalty • Number of reports
SECONDARY FILTER - TYPE Secondary filter • Type • Credit Card • Loyalty Note: The Transaction Date secondary filter is not currently functional.
SECONDARY FILTER REPORT RESULTS • Apply All filters • Sub-set of Results Display • Credit Cards • Loyalty
DISPLAY REPORTS • • Report and Sequence ID Report Code Date Report was created Viewing Format Icons Code Filter Labels Report Name Credit Card Reports CCM Credit Card Settlement Report DFM Daily Fee Memo Daily Card Sales Fee Report FMM Monthly Fee Memo Monthly Card Sales Fee Report PCR PRICE PRIVILEGES & Car Wash Redemptions PRICE PRIVILEGES/Car Wash Redemption Report Loyalty Reports LRDa LRDb LRD Loyalty Details Daily Loyalty Detail Report LRS Loyalty Details Summary Daily Loyalty Summary Report LMS Loyalty Monthly Summary Monthly Loyalty Summary Report LPF Loyalty Potential Fraud Daily Loyalty Potential Fraud Note: Each report is assigned a Sequence ID that indicates the chronological order in which that report type was produced.
VIEW REPORTS • Report View PDF ü RECOMMENDED • Report Download Untranslated (TXT) Warning: The report should “pop-up” in PDF format in a new tab in your browser. If the report does not appear, the DTN User Guide explains how to disable the “pop-up blocker” in the settings for your browser.
DOWNLOAD REPORTS • Select All • # of reports selected • Category • Individual Reports • PDF / Untranslated • Single file or Zip Note: The DTN User Guide contains some tips on how to open zip files on your computer.
FILE NAMING All the reports into a single file: PDF or TXT • date the consolidated file was downloaded • Multiple PDF_201808010148. pdf • Multiple TXT_201808010159. txt All reports into a zip file: PDF or TXT • PDF > Multiple PDF_201808010148. zip o TXT > “Untranslated. zip” Report file names inside zip file • Sold-to number and Report code o 315295 -DFM-20180125 -1 o 315295 -LRD-20180111 -9
DTN USER AND QRG GUIDES Settlement Information Portal: http: //www. essoandmobilpos. com/fep/en
? CHECK-IN Questi ns
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 dollar amounts for loyalty Redemption Report 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: 67