Freight brokerage TMS · Reports
How to see margin by customer, lane, rep and carrier
Open Brokerage Reports and pick a period. Switch between Customers, Lanes, Reps and Carriers to see loads, revenue, carrier cost, margin, margin percent and on-time. Download any view as CSV.
Updated Open this in Tezify
- Open Finance, then Brokerage Reports.
- Pick the period.
- Choose the view: Customers, Lanes, Reps or Carriers. Sort by any column.
- Press the download button for a CSV of that view.
How margin is counted
- Revenue is the customer rate plus billable extras, less credit memos, short pays and write-offs.
- Cost is carrier pay plus payable extras, plus anything owed to earlier carriers.
- Quick pay fees you keep count as income.
- Loads with no carrier cost sit in their own bucket and never count toward margin percent.
- On-time compares delivery with the customer's due time, with 2 hours of grace.
The Desk, the load's money box, Reports and Commissions use the same calculation, so they always agree.
Brokerage health
The report also shows time to cover, buy against target, billing turnaround, days to get paid, quote win rate by who quoted and a profit and loss summary.
Ready to do it? This lives at /admin/brokerage/reports in Tezify.