There are free programs on the internet that can be used.  Google has a good one that I am learning to use.  What I like about this program is that it is cloud based and I can quickly add or see my numbers using my phone, my tablet, or my computer.    Google Sheets

There are lots of tutorials about how to use the spreadsheets or Sheets as they are called in Google.  Google has several free programs that can be used besides Sheets.

The Sheet can be as simple or as complicated at you want it.  For my basic information, I want the load pay, the date the load was picked up, the city where picked up, delivery date, the city where unloaded, loaded miles, and deadhead miles.  I keep some other numbers in there but that is my own preference.

My starting mileage I post on the first day of the year as I will also post the mileage at the end of the year.  When I want to know how much we have made per mile I want all miles.  Once I have established my starting mileage I build from there.  When you get the first load of the year and have delivered it I enter the mileage while at the receiver or consignee.  That is my ending mileage for the load.  I will have two numbers at this point one is for what the load paid and the mileage we were told it would be.  In our situation, we are only told loaded miles.  My next number will be for all miles of that trip and that is the number that I pay the most attention to.

At the end of the year, it is easy to total up the load pay column and divide by total miles driven to know the average rate for all miles.  There are lots of tricks that can be used in Sheets to keep track of numbers.

Here is a simple example of how to get started using Google Sheets:

Comments (0)

Linda Caffee

Bob and Linda started their driver careers after their children left home for college in 2000. Bob started as a driver for a large motor carrier with Linda as a rider. They decided to enter the Expedite industry as team drivers in 2005 and purchased their first Freightliner. Both, Bob and Linda have had their Class A licenses since the early 80's starting out driving in the oil field and hauling grain as fill in drivers where Bob worked as a diesel mechanic. Linda worked at the local country courthouse in data processing.

Read These Next...

BUSINESS Smart

Spot Rate Deflate

September 29, 2018

BUSINESS Smart

UCR 2019 Delay

October 24, 2018