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:

Comment ()

This blog post does not have any comments. Be the first!


Sign up to get the latest trucking tips and tricks!


Ask a question


Post a question to our forum and a Pro will answer as well as our community members!


Keep Reading Articles Articles


Balancing Act

March 03, 2019


About Linda Caffee

Bob and Linda have been team drivers since 2005 as expediters. They are leased to Landstar Express America. Bob was a diesel mechanic for twenty years before doing over the road and Linda worked in the courthouse.

View Full Bio and All Posts by Linda Caffee