Truck Driver Hours of Service Log + Expense Tracker — HOS Daily Log, IFTA Mileage & Tax Prep
Every mile logged. Every dollar tracked. Tax time handled.This Google Sheets workbook was built for CDL truck drivers who are tired of paper logs, scattered receipts, and scrambling at tax time. Whether you're an owner-operator or company driver, this tracker covers your entire year in one place.What's inside (6 tabs): ✅ HOS Daily Log — FMCSA-compliant 70-hr/8-day rolling tracker with duty status dropdowns and automatic limit alerts ✅ Load Income Tracker — Log every load with rate/mile, fuel cost, lumper fees, and net pay per load ✅ IFTA Mileage by State — Track miles per state for all 48 contiguous US states + Canadian provinces, by quarter ✅ Expense Tracker — Fuel, maintenance, tolls, insurance, DOT per diem meals — categorized for Schedule C ✅ Annual Tax Summary — Auto-calculated gross income, deductions, estimated self-employment tax, and quarterly payment estimate ✅ Dashboard — Live summary of HOS remaining, net profit, and IFTA state count Who it's for:Owner-operators, lease drivers, and self-employed CDL holders who need to stay compliant and keep clean records for tax season.No subscriptions. No apps. No internet required. Open in Google Sheets or Microsoft Excel. Fill it in daily — done.FAQDoes this work in Excel?Yes — fully compatible with Microsoft Excel. Download the .xlsx file and open directly.Does this replace my ELD?No — ELDs are federally required for most drivers. This is a backup log and financial tracker, ideal for exempt drivers or as a cross-reference record.Is the HOS logic correct?Yes — built around the FMCSA 70-hour/8-day rule for property-carrying drivers. The rolling total auto-updates as you enter daily hours.Can my CPA use the Tax Summary tab?Yes — the Annual Tax Summary is structured to match Schedule C line items and includes per diem and mileage summaries.Ready to drive smarter? Get instant access below.
Get it → pattybun.gumroad.com