1 / 32

DTN Training Session: Modules & Reports Guide

Welcome to DTN Training! In this session, you will find detailed information on the modules covered, how to manage retailers, view reports, and best use the reports in the DTN Portal. Get familiar with credit card reports, loyalty reports, daily card sales fees, and more. This training guide aims to enhance your understanding of the settlement process and reconciliation steps. Additional support contact details are available for any issues or queries you may have. Start your learning journey now to make the most of the DTN system.

mccabe
Download Presentation

DTN Training Session: Modules & Reports Guide

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. Welcome to: DTN Training The session will begin shortly.

  2. introduction

  3. Additional Information Warning Note

  4. 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

  5. DTN USER and QRGGUIDEs Settlement Information Portal: http://www.essoandmobilpos.com/fep/en

  6. DTN activity ? DTNActivity

  7. agenda Manage Retailers View Reports Use Reports DTN Portal

  8. MODULE 1 • MODULE 2 • MODULE 3 • MODULE 4: • USE REPORTS

  9. Credit card reports

  10. Loyalty reports

  11. START and EnD MESSAGES

  12. CARD COdes

  13. reconciliation • Card Settlement Report (CCM) • Indicates IOL payment to be received. • ADD ALL Sites Total • (NET of • $$ Value of Points Redeemed • MINUS • Total Issued Value) • 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) 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.

  14. 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

  15. Activity COdes O-OUT,I-IN,E-CREDIT/DEBIT CARD,S-SPEEDPASS,P-PAPER,M-MOBILE,X-MCX

  16. 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

  17. 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

  18. Debit card summary • DEBIT CARD Summary • Not just INTERAC • Includes the following transactions: • DE INTERAC Debit Card Transactions • GAEsso and Mobil Gift Card Activations • GREsso and Mobil Gift Card Redemptions • CAEsso and Mobil Car Wash Activations • CPPRICE PRIVILEGES Activations

  19. RECONCILIATION 1 – DFM • TOTAL SALES / NET SALES AMTMINUS • DE • (Debit Card Sales) Reconciliation 1: DFM Note: The existing Retailer settlement process related to Interac Debit transactions has not changed.

  20. 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)

  21. 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 RedeemedMINUS$ Total Issued Value • ADD ALL Site Total Reconciliation 3: LRDa

  22. Summary reports Credit Card Reports • Monthly Card Sales Fee Report (FMM) • Ticket Requests (RTV) Loyalty Reports • Daily Loyalty Detail Report (LRDb) • Daily Loyalty Potential Fraud (LPF) BW Only Reports • Daily Loyalty Summary Report (LRS) • Monthly Loyalty Summary (LMS)

  23. Monthly Card Sales Fee Report (FMM) • Retailer #1 Information • Card Type and various Totals information by • Transactions • Gross Sales • Total Fees • Net Sales Amt Monthly summary of the daily card sales fee reports Retailer #2 Information • Distributor Summary • Summary of information from all Retailers

  24. Ticket Requests (RTV) Ticket Requests (RTV)

  25. Daily Loyalty Detail Report (LRDb) 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

  26. Daily Loyalty Potential Fraud (Lpf) Daily Loyalty Potential Fraud (LPF)

  27. Daily Loyalty Summary Report (LRS) Loyalty program summary data by Retailer with BW totals Summary by Retailer BW Summary Information

  28. Monthly Loyalty Summary (LMS) Monthly roll up of loyalty activity for all BW Retailers. Summary by Retailer BW Summary Information

  29. DTN USER and QRGGUIDEs Settlement Information Portal: http://www.essoandmobilpos.com/fep/en

  30. 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

  31. ? Q&A Questins

  32. THANK Thank you! YOU

More Related