Dispatch Board & Load Tracker

What it does

Running trucks from a notebook and a load board tab means you never quite know what was delivered, what was invoiced and who still owes you. This spreadsheet is the board on the wall: one line per load, a status you flip as it moves, and a dashboard that reads it all back in real time.

• Loads tab (150 rows): load #, pickup and delivery dates, driver and broker dropdowns, origin, destination, loaded and empty miles, linehaul, fuel surcharge, accessorials, status, invoice date, paid date and factored Y/N
• Every load computes gross, total miles, RPM (loaded and all miles), driver pay from that driver's pay model, dispatch fee, factoring fee, margin and margin %, plus days outstanding and an aging bucket for unpaid invoices
• Board: this week's loads, revenue, miles, dispatch fee and margin (the week is figured from today's date, so it is always current), status counts for Booked / In Transit / Delivered / Invoiced / Paid, revenue per truck, receivables outstanding with 0–30 / 31–60 / 61+ day aging, and your Top 5 brokers by revenue
• Settings box on the Board: dispatch fee %, factoring fee % and the day your week starts (Monday by default, or Sunday) — every week in the file is labeled by its start date, so the New-Year week is never split
• Drivers tab (10): name, truck #, pay model dropdown (per mile all miles, per mile loaded, percent of linehaul, flat per load), rate and phone, with lifetime loads, revenue, pay and margin per driver
• Brokers tab (30): MC #, your credit rating, days to pay and quick-pay % — plus loads, revenue and outstanding $ per broker
• Weekly Summary: every week of the year — loads, miles, revenue, RPM, driver pay, dispatch fee and margin for any year you type, with the current week highlighted

What's included

• 1 Excel workbook (.xlsx) with 6 tabs: Start Here · Board · Loads · Drivers · Brokers · Weekly Summary
• Settings box on the Board for your dispatch fee %, factoring fee % and week-start day
• 31 example loads, 4 drivers and 8 brokers already filled in, with dates keyed to today so the Board is live the moment you open it
• Start Here tab with 6 steps, a color legend and a version line
• Instant digital download — no subscription, no macros

Tabs

• Start Here
• Board
• Loads
• Drivers
• Brokers
• Weekly Summary