Trucking Dispatch Spreadsheet
A dispatch board and load log in one workbook: every load on one row, status from Booked to Paid, and a dashboard that calculates revenue by month, revenue per loaded mile, deadhead, receivables outstanding and top customers.
Checkout opens on Stripe. The download page appears the moment payment goes through, and your receipt email carries the link. Digital files only; nothing is shipped.
- Excel Dispatch-and-Load-Tracker-US.xlsx
- Excel Dispatch-and-Load-Tracker-Metric-CA.xlsx
- PDF Dispatch-and-Load-Tracker-Quick-Start.pdf
Also sold on Etsy; buying here costs less and the files are the same.
A dispatch board and load log in one workbook: every load on one row, status from Booked to Paid, and a dashboard that calculates revenue by month, revenue per loaded mile, deadhead, receivables outstanding and top customers.
WHAT YOU GET
- Loads sheet: 24 columns, drop-down status and customers, calculated total, rate per loaded mile, month and days outstanding; built for 2,000 loads
- Dashboard: six KPI tiles, loads and revenue by status, by month (with chart), and by customer with outstanding balances
- Customers and Drivers & Trucks sheets that feed the drop-downs
- Start-here sheet with instructions
- Two files: US (miles, US$) and metric (km, CA$)
- Quick-start PDF
16,232 formulas across the two workbooks, recalculated and checked for errors before listing. Sheets: Start here, Dashboard, Customers, Drivers & Trucks, Loads.
HOW TO USE
1. Buy, then download on the page that opens right after payment (your Stripe receipt email carries the same link).
2. Open the workbooks in Excel 2016 or later, Google Sheets or LibreOffice; the quick-start PDF opens in any PDF app.
3. Yellow cells are inputs, grey cells calculate. Replace the example rows with your own.
PLEASE NOTE
- Digital download only; nothing is shipped. Returns are not possible on digital files; if a file will not open, email [email protected] and it gets fixed.
- Works in Excel 2016 or later, Google Sheets and LibreOffice; drop-downs and charts included.
- Templates are not legal, tax or insurance advice. Have agreements reviewed by your own counsel and follow your own operating rules.
- For use in one business. Not for resale or redistribution.
Designed by A3E Studio (Ontario, Canada) and generated by our own software; every formula is recalculated and checked before listing.
