Trucking Profit & Expense Tracker: Cost Per Mile Calculator (Excel/Google Sheets)

Owner operator trucking spreadsheet with a cost per mile calculator: log loads, expenses and broker pay, then see your profit, cost per mile and rate to quote.

Works in Microsoft Excel and Google Sheets. For Sheets, upload the .xlsx to Google Drive, open it, then choose File > Save as Google Sheets (formula cells aren't locked in Sheets, so type only in the orange input cells).

WHAT YOU RECEIVE
- One blank XLSX workbook with five tabs: Dashboard, Quote, Loads, Expenses and Guide.
- 300 prepared load rows and 600 prepared expense rows.
- A six-page PDF quick-start guide with a fictional worked example.
- Two printable weekly review and load quote worksheets.
- One-business internal-use license.

WORKBOOK FEATURES
Monthly and annual billed revenue, recorded expenses and recorded profit; revenue and cost per total mile; unpaid balances and overpaid credits; partial-payment and overdue status; expense categories; and flags for incomplete records or duplicate load IDs.

LOAD QUOTE CALCULATOR
Enter your assumptions to estimate fuel, maintenance reserve, driver cost and allocated overhead. See the minimum quote for a target margin and compare it with an offered rate. Quote estimates do not automatically enter your logs.

SOFTWARE AND CAPACITY
Microsoft Excel XLSX format. A desktop or laptop is recommended. Spreadsheet software is not included. Core calculations were checked in an automated calculation engine; a full native Excel workflow has not been independently verified. Mobile workflows are unverified. Use the 300 load rows and 600 expense rows in their existing order. Extensions and sorting are outside the verified workflow. No macros, external connections or bank sync.

HOW IT WORKS
Download the ZIP after payment, extract it, save a working copy, select your reporting year, and enter information in orange cells. Start with the included guide. The workbook arrives blank; listing previews use fictional demonstration records.

UNDERSTAND THE RESULTS
Recorded profit is billed revenue by delivery date minus recorded operating expenses by incurred date. It excludes tax, depreciation and owner draws. Received amounts are cumulative by load. This is a recordkeeping and planning tool, not a formal accounting statement, IFTA filing system or tax return. Results depend on complete, accurate entries.

DIGITAL DOWNLOAD AND LICENSE
No physical product will be shipped. One purchaser may use and adapt the files internally for one business. Resale, redistribution and public sharing of the template are not permitted. Contact the seller through Etsy Messages if you encounter a file problem.

AI DISCLOSURE
This original workbook, guide and listing designs were created with AI assistance and reviewed through calculation and visual checks.

MORE FROM HAULLEDGER STUDIO
• IFTA Fuel & Miles Tracker: https://www.etsy.com/ca/listing/4589329541/owner-operator-ifta-fuel-miles-tracker
• Save with the Profit + IFTA Duo Bundle: https://www.etsy.com/ca/listing/4589339606/owner-operator-trucking-bundle-profit