Cloud View User Guide
ES Success in Trucking Cloud View User Guide
“Keep your head in the clouds and your feet on the ground.” Technology In Transportation
This document is intended to give an overview of the terminology and a simple “How to” on using Oracle Analytics Cloud dashboards.
If you should have need to ask specific questions, please contact your service coordinator. They can set aside private time to review as needed.
Please keep in mind, this data is not meant to be a full accounting of your truck and business. It is meant to give you a snapshot of how you are performing in certain metrics.
Also, keep in mind this data is based on your information sent to us by the carriers. Most carriers send us information on a load as it is delivered that only has basic information like Loaded Miles and LineHaul revenue. We do not receive all your information on accessorials and fuel surcharge data until final settlement of the pro. This information is also delayed by sometimes up to 2 weeks after delivery.
Each carrier also makes changes to their system occasionally and we will attempt to stay in front of those changes.
Definitions of Terms:
Make: This is the unit number for the Truck.
Carrier: This is the motor carrier
Customer: This is ES’s customer- YOU!
Service Coordinator: Person at ES responsible for assisting you.
Deliver Prd: This is the time frame that a load was delivered in. Ex: 2020-02, this means year 2020, month 2, or February.
Total Loaded Miles: This is the delivered amount of loaded miles sent by the carrier for the given period.
Solo Miles: This is a target for a solo operator to achieve in order to meet baseline standards for financing. It however does not guarantee financing into a unit.
Team Miles: This is a target for a contractor team operation to achieve in order to meet baseline standards for financing. It however does not guarantee financing into a unit.
Load Revenue Amt: This is the amount of Line Haul Revenue sent from the carrier to ES for your delivered loads.
Deadhead Amt: This is the amount of your Deadhead accessorial pay sent from the carrier to ES for your delivered loads. Some carriers do not always qualify the code as Deadhead. Sometimes it will appear in Other Amt. See below.
Variance Amt: This is the amount of Variance Pay as coded by the carrier and sent to ES for your delivered loads. Some carriers do not pay Variance Pay. Some carriers include this amount in the Other Amt as well.
Other Amt: These are other accessorial amounts that have no specific category. These could be Lumper, Load Acceptance Pay, Xtra Stop Pay, Detention Pay, etc
Tolls Amt: This is the amount of tolls reimbursement paid on a delivered load.
FSC Amt: This is the amount of fuel surcharge paid to the unit on delivered loads.
Total Revenue: This is a sum of the above fields. Load Revenue Amt + Deadhead Amt + Variance Amt + Other Amt + Tolls Amt + FSC Amt.
Solo Total Rev: This is a target for a solo operation to achieve in order to meet baseline standards for financing. It however does not guarantee financing into a unit.
Team Total Rev: This is a target for a team operation to achieve in order to meet baseline standards for financing. It however does not guarantee financing into a unit.
ContractorPay: It is ES’s opinion that every business should recognize the cost for operating the truck. Your time is worth something and you never know when you might have to pay someone to drive the truck with you or for you. Every truck will show contractor pay to recognize this cost. If there is contractor pay based upon a contract, this will be actual dollars. Otherwise, if there is no contract to determine this, we will baseline a calculation of total revenue times 35% to calculate Contractor Pay.
Fuel Dollars: This is the amount of fuel spent in the given period as determined through EFS transactions.
Deductions: These are items that are charged on either a weekly/monthly basis from ES, the carrier or elective 3rd party expenses. They include items such as Qualcomm, Insurance, Legal Fees, Accounting Fees, Carrier Fees, Management Fees, etc.
RM Dollars: These are the actual dollars spent on Repair and Maintenance for the unit that have gone through the ES system.
Solo Truck Payment: This is an example solo truck payment (principle and interest).
Solo Truck Insurance: This is insurance for the truck itself. It does not include Occupational Insurance Coverage (OIC).
Team Truck Payment: This is an example team truck payment (principle and interest).
Team Truck Insurance: This is insurance for the truck itself. It does not include Occupational Insurance Coverage (OIC).
Solo Total Expense: This is a calculation. Driverpay + Fuel Dollars + Deductions + RM Dollars + Solo Truck Payment + Solo Truck Insurance.
Team Total Expense: This is a calculation. Driverpay + Fuel Dollars + Deductions + RM Dollars + Team Truck Payment + Team Truck Insurance.
Net Profit (Loss) Solo: This is a calculation. Total Rev less Solo Total Expense.
Net Profit (Loss) Team: This is a calculation. Total Rev less Team Total Expense
Solo Owner Opp: This currently has no value, but it will be the suggested Owner Profit for a Solo Owner.
Team Owner Opp: This currently has no value, but it will be the suggested Owner Profit for a Team Owner.
Using the Dashboard:
When you have opened the Dashboard and are on Profit & Loss (page 1), you will notice certain options at the top of the page. These have choices that you can use to look at your data.
As a single truck operator, you will only see your data for your truck that you are currently driving. If you have recently changed trucks, you will only see the data that is applicable to your driver id on your current truck.
As a fleet owner, you will see all trucks that are in your fleet that run through Expediter Services. You can select one single truck, or as many or as few as you like. If you have multiple carriers that you have trucks contracted with, you can select one carrier or all carriers as well.
Deliver Period can also be changed to select any period back to the beginning of the prior year. Since it is now May of 2020, the data is accessible back to January of 2019.
If for some reason, you are unable to see all of the choices in a certain selection box, you can click the Search button at the bottom of the dropdown list. See below:
Once you have made all of your selections, you will need to click the “Apply” button. This submits your choices that you have made.
If you find that you want to go back to the default setting that you arrived into the Dashboard, you can click the “Reset” button and select, “Reset to default values”. See below:
At the bottom of the screen, there are other options that are in blue. See below:
You will only be able to refresh, print, and export.
You can export to many different programs including Excel, Powerpoint, CSV and PDF.