Unique Trucking Mileage Spreadsheet

Whether with cars trucks or buses a good part of the operations of companies of all sizes depends on some level of the use of those vehicles.

Trucking mileage spreadsheet. Also this template is unique according to its specific purpose. Trucking Spreadsheet The transport and freight in United states is made mostly by the road. There are several advantages to using the trucking expenses spreadsheet template.

We hope you can find what you need here. Quick tutorial showing you how to set up a Google Spreadsheet to automatically calculate and keep track of your business mileage ready for your year-end exp. To ensure accuracy in calculating your costs per mile you must account for your companys expenses.

We always effort to show a picture with HD resolution or at least with perfect images. The third column is the result of dividing the annual costs by the number of miles run in the year. For our example we are assuming the truck was driven for 100000 miles.

This mileage log in Excel makes it easy to track distances for personal and business travel. We dont intend to display any copyright protected images. Steve Stewart Trucking Contracting is trucking company providing freight transportation services and hauling cargo.

Enter your trip details and odometer readings at the start and end of your trip and the mileage log template in Excel automatically calculates your total miles. The spreadsheet tells us pretty quickly when it is time to have an overhead run on the truck or if something is going wrong as our fuel mileage will start dropping off. Steve Stewart Trucking Contracting is a licensed and bonded freight shipping and trucking company running freight hauling business from Princeton Indiana.

So since the annual mortgage payments on the truck were 16000 we divide 16000 by the 100000 miles and we find the cost of the truck mortgage in 016 cents per mile. It has some neat features such as automatic computation and totaling of weekly monthly and cumulative miles and number of rides for the month and year to date. You can use the following log as documentation for your mileage deduction.