Freight Brokerage Desk
Freight brokers and small brokerage teams
Quote, cover and track loads, vet carriers, and watch margin per load and per customer.
Use this templateFreight Brokerage Desk
Start here: how this workspace runs
Dashboard
Vetting a new carrier
Covering and tracking a load
Loads
Every load from quote to delivery: customer, carrier, equipment, rate, carrier pay and margin.
| Load | Status | Customer | Carrier | Equipment | Broker rep | Pickup |
|---|---|---|---|---|---|---|
| Dallas to Memphis, paper rolls | Delivered | Trinity Paper Converters | Red Mesa Transport | Tamsin Cole | Oct 12, 12:00 PM | |
| Fresno to Denver, bagged salad | Delivered | Valle Verde Produce Co-op | Coldline Express | Desmond Ebi | Oct 13, 10:30 AM | |
| Birmingham to Atlanta, steel coil | Delivered | Ironline Metals Supply | Steelhook Flatbed LLC | Tamsin Cole | Oct 15, 1:00 PM | |
| Joliet to Columbus, retail pallets | Delivered | Northfield Home Goods DC | Prairie Line Logistics | Lourdes Pineda | Oct 16, 6:00 PM | |
| Laredo to Houston, auto parts | Delivered | Gulfbend Industrial | Red Mesa Transport | Desmond Ebi | Oct 17, 11:00 AM | |
| Salinas to Phoenix, strawberries | In transit | Valle Verde Produce Co-op | Coldline Express | Desmond Ebi | Oct 20, 9:00 AM | |
| Chattanooga to Charlotte, flooring | Covered | Ironline Metals Supply | Two Rivers Heavy Haul | Tamsin Cole | Oct 21, 3:00 PM | |
| Memphis to Indianapolis, appliances | Tendered | Trinity Paper Converters | โ | Lourdes Pineda | Oct 22, 1:00 PM |
Customers
The shippers you move freight for, their terms, credit limit, and what they have paid and owe.
| Customer | Status | Payment terms | Credit limit (USD) | Main lanes | Accounts payable email | Quote a load |
|---|---|---|---|---|---|---|
| Trinity Paper Converters | $60,000 | Dallas out to TN, OK and AR | ap@trinitypaper.net | โ | ||
| Valle Verde Produce Co-op | $90,000 | Central Valley to the Mountain West | payables@valleverdeproduce.net | โ | ||
| Ironline Metals Supply | $50,000 | Birmingham and Chattanooga to the Southeast | ap@ironlinemetals.net | โ | ||
| Northfield Home Goods DC | $75,000 | Joliet and Columbus to the Midwest | carrierpay@northfieldhome.net | โ | ||
| Gulfbend Industrial | $25,000 | Laredo and Houston, Texas loops | ap@gulfbendindustrial.net | โ | ||
| Sierra Crest Bottling | $20,000 | Reno to Northern California | ap@sierracrestbottling.net | โ |
Carriers
Every trucking company you tender to, with authority, insurance, safety rating and loads hauled.
| Carrier | Setup | MC number | USDOT number | Main equipment | Safety rating | Preferred lanes |
|---|---|---|---|---|---|---|
| Red Mesa Transport | Approved | MC-884213 | 3301457 | Texas to the Mid-South | ||
| Coldline Express | Approved | MC-902774 | 3417720 | California to Colorado and Arizona | ||
| Steelhook Flatbed LLC | Approved | MC-771058 | 2984411 | Alabama and Georgia | ||
| Prairie Line Logistics | Insurance expiring | MC-1120934 | 3655102 | Illinois, Ohio, Indiana | ||
| Two Rivers Heavy Haul | Approved | MC-650917 | 2511809 | Tennessee to the Carolinas | ||
| Quickfleet Partners | Pending setup | MC-1198420 | 3802217 | Dallas and Houston | ||
| Longview Haulers | Do not use | MC-1003378 | 3519924 | Texas loops |
Customer invoices
What each delivered load was billed, with detention and extras, and whether the customer has paid.
| Invoice | Status | Load | Customer | Detention and extras (USD) | Due | Paid on |
|---|---|---|---|---|---|---|
| Invoice for load 30418 | Paid | Dallas to Memphis, paper rolls | Trinity Paper Converters | $0 | Oct 20, 2026 | Oct 19, 2026 |
| Invoice for load 30422 | Sent | Fresno to Denver, bagged salad | Valle Verde Produce Co-op | $150 | Oct 30, 2026 | โ |
| Invoice for load 30425 | Overdue | Birmingham to Atlanta, steel coil | Ironline Metals Supply | $75 | Oct 19, 2026 | โ |
| Invoice for load 30427 | Draft | Joliet to Columbus, retail pallets | Northfield Home Goods DC | $0 | Nov 16, 2026 | โ |
| Invoice for load 30431 | Short-paid | Laredo to Houston, auto parts | Gulfbend Industrial | $125 | Oct 21, 2026 | โ |
The four tables
A normal day
Who owns what
A margin you can trust
Quotes and cancelled loads show no margin, so the totals are only freight that moved. Short-paid invoices stay open until the difference is collected or written off by the owner.
| Load | Status | Customer | Carrier | Equipment | Broker rep | Pickup |
|---|---|---|---|---|---|---|
| Dallas to Memphis, paper rolls | Delivered | Trinity Paper Converters | Red Mesa Transport | Tamsin Cole | Oct 12, 12:00 PM | |
| Fresno to Denver, bagged salad | Delivered | Valle Verde Produce Co-op | Coldline Express | Desmond Ebi | Oct 13, 10:30 AM | |
| Birmingham to Atlanta, steel coil | Delivered | Ironline Metals Supply | Steelhook Flatbed LLC | Tamsin Cole | Oct 15, 1:00 PM |
| Load | Status | Customer | Carrier | Equipment | Broker rep | Pickup |
|---|---|---|---|---|---|---|
| Dallas to Memphis, paper rolls | Delivered | Trinity Paper Converters | Red Mesa Transport | Tamsin Cole | Oct 12, 12:00 PM | |
| Fresno to Denver, bagged salad | Delivered | Valle Verde Produce Co-op | Coldline Express | Desmond Ebi | Oct 13, 10:30 AM | |
| Birmingham to Atlanta, steel coil | Delivered | Ironline Metals Supply | Steelhook Flatbed LLC | Tamsin Cole | Oct 15, 1:00 PM |
| Load | Status | Customer | Carrier | Equipment | Broker rep | Pickup |
|---|---|---|---|---|---|---|
| Dallas to Memphis, paper rolls | Delivered | Trinity Paper Converters | Red Mesa Transport | Tamsin Cole | Oct 12, 12:00 PM | |
| Fresno to Denver, bagged salad | Delivered | Valle Verde Produce Co-op | Coldline Express | Desmond Ebi | Oct 13, 10:30 AM | |
| Birmingham to Atlanta, steel coil | Delivered | Ironline Metals Supply | Steelhook Flatbed LLC | Tamsin Cole | Oct 15, 1:00 PM |
| Carrier | Setup | MC number | USDOT number | Main equipment | Safety rating | Preferred lanes |
|---|---|---|---|---|---|---|
| Red Mesa Transport | Approved | MC-884213 | 3301457 | Texas to the Mid-South | ||
| Coldline Express | Approved | MC-902774 | 3417720 | California to Colorado and Arizona | ||
| Steelhook Flatbed LLC | Approved | MC-771058 | 2984411 | Alabama and Georgia |
| Invoice | Status | Load | Customer | Detention and extras (USD) | Due | Paid on |
|---|---|---|---|---|---|---|
| Invoice for load 30418 | Paid | Dallas to Memphis, paper rolls | Trinity Paper Converters | $0 | Oct 20, 2026 | Oct 19, 2026 |
| Invoice for load 30422 | Sent | Fresno to Denver, bagged salad | Valle Verde Produce Co-op | $150 | Oct 30, 2026 | โ |
| Invoice for load 30425 | Overdue | Birmingham to Atlanta, steel coil | Ironline Metals Supply | $75 | Oct 19, 2026 | โ |
| Customer | Status | Payment terms | Credit limit (USD) | Main lanes | Accounts payable email | Quote a load |
|---|---|---|---|---|---|---|
| Trinity Paper Converters | $60,000 | Dallas out to TN, OK and AR | ap@trinitypaper.net | โ | ||
| Valle Verde Produce Co-op | $90,000 | Central Valley to the Mountain West | payables@valleverdeproduce.net | โ | ||
| Ironline Metals Supply | $50,000 | Birmingham and Chattanooga to the Southeast | ap@ironlinemetals.net | โ |
Loads to cover
| Load | Status | Customer | Carrier | Equipment | Broker rep | Pickup |
|---|---|---|---|---|---|---|
| Dallas to Memphis, paper rolls | Delivered | Trinity Paper Converters | Red Mesa Transport | Tamsin Cole | Oct 12, 12:00 PM | |
| Fresno to Denver, bagged salad | Delivered | Valle Verde Produce Co-op | Coldline Express | Desmond Ebi | Oct 13, 10:30 AM | |
| Birmingham to Atlanta, steel coil | Delivered | Ironline Metals Supply | Steelhook Flatbed LLC | Tamsin Cole | Oct 15, 1:00 PM |
Carriers to re-check
| Carrier | Setup | MC number | USDOT number | Main equipment | Safety rating | Preferred lanes |
|---|---|---|---|---|---|---|
| Red Mesa Transport | Approved | MC-884213 | 3301457 | Texas to the Mid-South | ||
| Coldline Express | Approved | MC-902774 | 3417720 | California to Colorado and Arizona | ||
| Steelhook Flatbed LLC | Approved | MC-771058 | 2984411 | Alabama and Georgia |
Money to collect
| Invoice | Status | Load | Customer | Detention and extras (USD) | Due | Paid on |
|---|---|---|---|---|---|---|
| Invoice for load 30418 | Paid | Dallas to Memphis, paper rolls | Trinity Paper Converters | $0 | Oct 20, 2026 | Oct 19, 2026 |
| Invoice for load 30422 | Sent | Fresno to Denver, bagged salad | Valle Verde Produce Co-op | $150 | Oct 30, 2026 | โ |
| Invoice for load 30425 | Overdue | Birmingham to Atlanta, steel coil | Ironline Metals Supply | $75 | Oct 19, 2026 | โ |
How to read the numbers
Before the first load
Red flags
Keeping the list clean
Checklist before tendering
When the customer tenders
Covering it
Check calls
Press Mark picked up at the first call and Mark delivered when the proof of delivery arrives.
When things go wrong
Worked example
Salinas to Phoenix strawberries: tendered at 3,150, covered with a reefer carrier at 2,700 for a 450 margin, about 14 percent. Pickup at 4 am; the reefer temperature is confirmed on the bill of lading at the first check call. The receiver signs clean the next afternoon, the broker presses Mark delivered, and billing sends the invoice before close.
What's inside
5 tables ยท 16 views ยท 1 form ยท 5 row actions ยท 1 agent5 pages
- Freight Brokerage Desk
- Start here: how this workspace runs
- Dashboard
- Vetting a new carrier
- Covering and tracking a load
4 tables
- Loads7 views ยท 13 sample rows
- Customers2 views ยท 6 sample rows
- Carriers2 views ยท 7 sample rows
- Customer invoices5 views ยท 5 sample rows
Related workspaces
Courier and Last-Mile Delivery DeskDispatch same-day and route deliveries, capture proof, retry failed drops, and see margin.
Food Production Kitchen DeskPlan batches, trace lots, track allergens, cost each jar, and ship wholesale orders.
Small Manufacturer Production DeskSmall manufacturer: orders, bill of materials, unit cost, work orders, scrap, QC holds.
Trucking Fleet DeskSmall carrier desk: loads and rate per mile, drivers' hours, maintenance, driver files.
Warehouse Operations DeskWarehouse: SKUs and locations, receiving, picks, cycle counts and the dock schedule.
Moving Company HQFor local movers: surveys, hourly quotes, crews and trucks, move day, damage claims.