Free trucking expense spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Made for owner-operators and small fleets. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank trucking expense and load spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• A load log: pickup date, lane, customer, loaded and deadhead miles, linehaul, extras, fuel, tolls and other trip costs
• Revenue per mile, net on the load and net per mile worked out for every load; loads under $0.50 a mile turn yellow
• A dashboard with loads, miles, revenue, trip costs and net by month
• Every customer or broker with loads, revenue, revenue per mile and net
• 600 load rows and 15 customers

How to track trucking loads, miles and trip costs in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: your brokers and customers and the year.
3. Loads tab: one row per load with miles, pay and trip costs.
4. Open the Dashboard tab: month totals, revenue per mile and every customer compared.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine and by LibreOffice Calc (forced recalculation) with 0 errors, and the Google Sheets copy shows 0 error cells. The example's 64 loads, 38,028 miles and 79,696 revenue equal an independent sum of its load rows, and net on loads (57,610) equals revenue minus trip costs and the dashboard values match between both engines. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, COUNTIFS, IFERROR, INDEX/MATCH) that Excel supports. If something is wrong, email support@tuper.app.

Need running costs, profit and a tax set-aside?

This free sheet tracks loads and trip costs. The paid trucking tracker adds an Expenses tab for truck payment, insurance, permits and tires, profit after running costs, a tax set-aside, deadhead share and fuel cost per mile:

• Owner-operator trucking load tracker (14 USD): for owner-operators who want revenue per mile, deadhead miles, trip costs and profit per load plus running costs in one workbook
• Freelance income and invoice tracker (12 USD): for freelancers who want invoiced vs received, overdue invoices, days to pay per client and profit by month in one workbook
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.