Profit and Loss Statement Template for Truck Drivers

Standard Operating Procedure: Commercial Motor Vehicle (CMV) Profit & Loss Statement System

1. Document Control Block

---

2. Executive Summary & Purpose

The purpose of this Standard Operating Procedure (SOP) is to institutionalize a precise, audit-compliant financial tracking methodology for motor carrier owner-operators, lease-purchase drivers, and small fleet operators.

By enforcing standardized record-keeping and financial classification, this procedure converts disparate operational data—such as rate confirmations, fuel card ledgers, Electronic Logging Device (ELD) reports, and maintenance logs—into a standardized Profit and Loss (P&L) Statement. Execution of this SOP ensures accurate calculated unit economics (e.g., Cost Per Mile, Revenue Per Mile), precise International Fuel Tax Agreement (IFTA) alignment, compliance with IRS Schedule C / Form 1120-S requirements, and clear profit margin optimization.

---

3. Scope & Prerequisites

3.1 Boundaries

• In-Scope: Gross revenue categorization (linehaul, fuel surcharges, accessorials), variable expense tracking, fixed overhead amortization, operational KPI calculation, and monthly financial reconciliation for Class 8 commercial motor vehicles.
• Out-of-Scope: Personal financial budgeting, multi-tier corporate tax structuring, freight brokerage accounting, and cross-border customs tariff processing.

3.2 Required Infrastructure & Tools

• Software: Microsoft Excel (v16.0+), Google Sheets, or dedicated enterprise accounting engines (e.g., QuickBooks Online, TruckingOffice).
• Data Sources:
  • Carrier Settlement Sheets / Broker Rate Confirmations.
  • ELD Distance/Miles Reports (Loaded vs. Deadhead/Unloaded).
  • Automated Fuel Card Activity Exports (e.g., Comdata, EFS, Fleet One).
  • Business Bank Accounts & Credit Card Statements (Strictly separated from personal accounts).
  • Fleet Maintenance and Repair Logs.

---

4. Roles & Responsibilities (RACI Matrix)

Legend: R = Responsible for execution; A = Accountable for final outcome; C = Consulted for context; I = Informed of results.

---

5. Step-by-Step Procedure

Phase 1: Ledger Initialization & Baseline Architecture Setup

• 1.1 Establish Ledger Timeframe and Vehicle Identifiers

  • Configure the workbook with strict monthly, quarterly, and annual aggregation tabs.
  • Input metadata: Vehicle Identification Number (VIN), Truck Unit #, Trailer Unit #, Primary Primary Operational Region, and Target Minimum Revenue Per Mile ($/mi).

• 1.2 Define Mileage Baseline Data Vectors

  • Extract monthly distance metrics directly from ELD certified reports.
  • Log three core operational distance values:
    1. Loaded Miles ($M_L$): Distance driven generating freight revenue.
    2. Unloaded/Deadhead Miles ($M_D$): Non-revenue distance driven between loads.
    3. Personal Conveyance Miles ($M_{PC}$): Non-operational travel (tracked for tax compliance).
  • Calculate Total Operational Miles: $$\text{Total Miles } (M_T) = M_L + M_D$$

---

Phase 2: Revenue Ingestion & Categorization

• 2.1 Aggregate Settlement Revenue Sources

  • Match each settlement stub to cleared bank deposits.
  • Disaggregate gross settlement payouts into discrete ledger line items:
    • Linehaul Freight Pay: Base rate for cargo transit.
    • Fuel Surcharge (FSC): Variable reimbursement offset based on DOE diesel index.
    • Accessorial Revenues:
      • Detention Pay: Hourly wait-time compensation.
      • Layover Pay: Compensation for unscheduled idle days.
      • Driver Load/Unload (Lumper) Reimbursements.
      • Stop-Off Pay: Extra payout for multi-stop delivery routes.

• 2.2 Compute Gross Operating Revenue

  • Verify calculation: $$\text{Gross Revenue } (R_G) = \text{Linehaul} + \text{FSC} + \text{Accessorials}$$

---

Phase 3: Variable Expense (OpEx) Tracking

Variable expenses scale directly with operational miles driven.

• 3.1 Record Fuel & Diesel Exhaust Fluid (DEF) Incurrence

  • Import raw fuel card statements. Reconcile total gallons, location, and total costs.
  • Isolate non-fuel purchases made at fuel stops (e.g., scale fees, fluid additives).

• 3.2 Log Route-Specific Operational Expenses

  • Capture charges across standard variable categories:
    • Tolls: Electronic toll pass usage (EZPass, PrePass, Bestpass) reconciled to statements.
    • Scales: CAT scale receipt validation.
    • Lumper Fees: Match outbound lumper payments against offsetting carrier reimbursements.
    • Driver Work Equipment: Straps, chains, load bars, PPE, and tarps.

• 3.3 Log Maintenance, Tires, and Equipment Upkeep

  • Categorize disbursements as Preventative Maintenance (PM) (oil changes, grease, filter replacements) vs. Unscheduled Repairs (towing, unexpected mechanical fixes).
  • Record tire replacements and retreads separately to track asset wear lifecycle.
  • Calculate required contribution to Maintenance Reserve Fund (Standard Baseline: $0.12 - $0.20 per total mile driven).

---

Phase 4: Fixed Expense Overheads & Amortization

Fixed expenses remain constant regardless of whether the truck operates or sits idle.

• 4.1 Log Equipment Capital & Financing Obligations

  • Tractor Payment/Lease: Input monthly principal plus interest or lease charge.
  • Trailer Payment/Lease: Track dry van, reefer, or flatbed lease/finance charges.

• 4.2 Record Commercial Insurance Premiums

  • Primary Auto Liability: Required regulatory limit (e.g., $750k–$1M).
  • Cargo Insurance: Load loss/damage coverage.
  • Physical Damage (Comp/Collision): Coverage based on stated asset value.
  • Non-Trucking Liability (Bobtail) / Occupational Accident (Occ-Acc): Independent operator protections.

• 4.3 Track Fixed Regulatory, Administrative, and Software Fees

  • Permits & Taxes: Heavy Vehicle Use Tax (IRS Form 2290 annualized/12), IFTA quarterly balances, state highway permits (NY HUT, KYU, OR, NM).
  • Technology Compliance: Monthly ELD system fees, dashcam connectivity, load board subscriptions, dispatch/accounting software.
  • Professional Services: Bookkeeping retainers, legal funds, and drug/alcohol consortium compliance fees.

---

Phase 5: Income Reconciliation & Unit Economics Engine

• 5.1 Execute Profitability Equation

  • Calculate Operating Expenses ($\text{OpEx}_V = \text{Total Variable Expenses}$) and Overhead Expenses ($\text{OpEx}_F = \text{Total Fixed Expenses}$).
  • Calculate Net Operating Income (NOI): $$\text{NOI} = R_G - (\text{OpEx}_V + \text{OpEx}_F)$$

• 5.2 Compute Institutional Freight KPIs

  • Compute operational metrics to validate business performance against target baselines:

---

6. Quality Assurance & Pro-Tips

6.1 Quality Assurance Metric Thresholds

1. Operating Ratio Threshold: If Operating Ratio (OR) exceeds 88%, audit variable costs immediately (primarily fuel efficiency and deadhead miles).
2. Maintenance Reserve Reserve Integrity: The Maintenance Reserve Account balance must equal or exceed $5,000 per Class 8 vehicle at all times to prevent operational failure from major mechanical events (e.g., engine overhaul, transmission failure).
3. Deadhead Alert: If monthly deadhead exceeds 12%, perform immediate route analysis and update broker load acceptance strategies.

6.2 Common Pitfalls to Avoid

• Co-mingling Funds: Paying personal expenses from the carrier operating account obscures true Net Operating Income and risks invalidating corporate liability shields.
• Misclassifying FSC as Revenue Overhead: Treating Fuel Surcharge as pure profit rather than a direct variable cost offset masks poor fuel efficiency.
• Treating Loan Principal as an Expense: Principal payments reduce balance sheet liabilities rather than acting as a P&L expense line item. Depreciate the vehicle asset over its tax life (MACRS 5-year) while claiming loan interest on the P&L statement.

6.3 Strategic Engineering Pro-Tips

• Automate Fuel Surcharge Realization Calculations: Set up conditional logic formulas that check your engine MPG against actual retail fuel costs to detect efficiency losses from excess idling or poor driving habits.
• Per Diem Deduction Capture: Ensure qualified drivers track per diem travel days. IRS allowable per diem rates (e.g., $80/day for transportation industry inside the continental US) provide massive tax shield adjustments outside standard line-item operational expenses.

---

7. Frequently Asked Questions (FAQ)

Q1: How should I account for trailer drop fees or lumper payments that are reimbursed weeks later?

Answer: Treat reimbursed accessorials under accrual accounting or log them as offsetting line items in the same month accrued. When a lumper fee is paid out-of-pocket, record it under "Reimbursable Accessorial Expense." When the carrier/broker reimburses the charge on a settlement sheet, apply the credit directly to that expense line rather than entering it as Gross Freight Revenue. This prevents artificial inflation of your gross operational revenue figures.

Q2: Should I include driver pay/draw on my P&L if I operate as a Sole Proprietorship vs. S-Corporation?

Answer:

• Sole Proprietorship / Single-Member LLC: Owner draws are not tax-deductible expenses on a P&L statement. Profit is calculated as Gross Revenue minus allowable business expenses; taxes are paid on the resulting Net Operating Income regardless of how much cash is withdrawn.
• S-Corporation: The driver-owner must be paid a reasonable W-2 salary. This W-2 wage, along with employer payroll taxes, is explicitly recorded under Operating Costs as Driver Wages, directly reducing the company's net P&L income.

Q3: How do I handle IFTA quarterly tax adjustments on my monthly P&L statement?

Answer: IFTA payments or refunds reflect fuel tax differentials across jurisdictions, not new fuel purchases. When an IFTA payment is due at quarter-end, log it under Fixed Expenses -> Taxes & Permits. If you receive an IFTA refund credit, record it as a negative expense in that same sub-account to adjust your cumulative operating costs accurately.