Skip to content
The title slide and first slides of the Truck Driver Expense Log template

Truck Driver Expense Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

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.

Useful for

  • Count days away from home by month
  • Work out fuel cost and price per gallon
  • Compare cost per loaded mile across trips

What's included

  • 5 tabs: Dashboard, Loads, Road Costs, Per Diem, How to use
  • Dashboard: a dashboard with 6 summary figures
  • Loads: a table
  • Road Costs: a table
  • Per Diem: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Loads tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What records does a truck driver need for tax time?

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.

How do I track days away from home?

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.

How do I calculate cost per mile as a driver?

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.

  • #tax-tracker
  • #truck-driver-expense-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…