It's a Team's Life

Income Per Mile - Spreadsheet

By Linda Caffee
Posted Jan 5th 2019 7:31AM

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. Not only can you track your numbers but you can use Docs to keep track of information.

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 for my own preference.

My first 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. Once 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. 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: