
Annual Report
Docs + Word6 pages
FeaturedFree
Drivers use this truck driver expense log to turn a year of trips into clear numbers. The Loads tab records each trip with dates, miles and pay, and counts days away from home. The Road Costs tab holds fuel with gallons and price per gallon, tolls, repairs, lodging and parking. The Per Diem tab totals days away by month and multiplies them by the daily rate you enter. The Dashboard shows cost per loaded mile, pay by month and road costs by kind.
Add a trip when you get home while the route is fresh. Take a photo of each fuel receipt and mark it Saved once it is stored. Look up the per diem rate for your situation yourself and type it in; this sheet does not fix a rate because the figure changes. Before you file, hand the totals and trip records to a tax professional.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Loads tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Keep trip dates, routes, miles, fuel receipts and records of any costs you paid yourself. The IRS publishes what records must back per diem and other claims, so read it and ask a tax professional about your case.
Enter the date you left and the date you returned on the Loads tab. The sheet counts the days, and the Per Diem tab adds them up by month.
Divide your road costs by your loaded miles. The Dashboard does this for you from the Road Costs and Loads tabs, so the figure moves as you add rows.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFreeSheets + Excel6 tabs
Free