Sample report EXAMPLE VALUES
This is what your audit looks like
Two pages from invented files. Nothing here is real. Use it to see the layout, the formulas and how potential, verified and collected money stay apart.
EXAMPLE VALUES Invented data
Every load, lane, broker and amount in this example is invented to show how the page works. None of it comes from a real carrier or broker. Brokers are shown as Broker A, B, C and so on.
Page 1
Findings, load by load, with the document match
Twenty invented loads. For each finding the report shows four checks: rate confirmation, POD, invoice and payment. A tick means the document supports the figure, a cross means it disagrees, a dash means nothing to compare yet.
Totals are computed from the rows on this page, so they always add up. Slow pay is shown as timing, not as money lost. Recovery depends on your contracts and on what brokers accept; we do not promise any amount.
Page 2
Fleet numbers, Fleet Score and the ledger
A second invented file (12 loads, report date 2026-09-30), calculated with exact decimal arithmetic when this page was built. Detention is valued at an assumed $60.00 per hour that we typed in. In a real audit you supply your own.
Revenue per all mile
$2.73
Revenue per loaded mile
$3.20
Empty miles
14.8%
Unpaid more than 30 days
$1,990.00
12 loads, $15,600.00 revenue, 4,870 loaded miles, 845 empty miles. The gap between the loaded-mile and all-mile rate is $0.47 per mile: that is what the empty miles cost in rate terms.
Payment speed on 8 paid invoices: average 25.1 days, median 23.0, 90th percentile 36, 2 took longer than 30 days.
First fixes (fixed order, evidence only)
- Cash at risk. $1,990.00 on 2 invoices is unpaid and more than 30 days old.
- Detention. 6.0 detention hours over free time with nothing billed or paid. At the assumed $60.00/h that is $360.00.
- Broker concentration. Broker A is 42.1% of revenue.
Fleet Score: 44 of 100
An internal heuristic with thresholds we chose. It is not an industry benchmark and not a credit score.
| Component | Value | Points | Max |
|---|---|---|---|
| Empty-mile share | 14.8% | 18.0 | 30 |
| Paid within 30 days | 6 of 10 | 18.0 | 30 |
| Top broker share | 42.1% | 8.0 | 20 |
| Money at risk / revenue | 12.8% | 0.0 | 20 |
Money at Risk ledger
Each item has one status and sits in one total only. Potential, verified and collected are never added together.
Potential
$360.00
identified + evidence needed. Not proven yet.
Verified
$395.00
verified + claimable + submitted + approved. Supported by documents, cash not received.
Collected
$200.00
Payment seen. The only number that is cash.
Not counted in any total: rejected + closed = $90.00. Unpaid invoices ($1,990.00 above) are tracked as cash at risk, not as ledger items, so no dollar appears twice.
| Item | Load | What | Status | Amount |
|---|---|---|---|---|
| M-01 | S-1002 | Detention, 1.5 h over free time Hours come from the load file. No timestamps checked yet. | identified | $90.00 |
| M-02 | S-1005 | Detention, 3.5 h over free time Need signed in/out times from the BOL. | evidence needed | $210.00 |
| M-03 | S-1006 | Rate con vs invoice: invoice $40.00 under rate con Rate con and invoice both on file and compared. | verified | $40.00 |
| M-04 | S-1007 | Lumper receipt not billed Receipt matched to the load. Ready for your approval. | claimable | $85.00 |
| M-05 | S-1003 | Lumper receipt not billed Sent to the broker after owner approval. | submitted | $120.00 |
| M-06 | S-1011 | Layover Broker approved. Not paid yet. | approved | $150.00 |
| M-07 | S-1001 | Layover Payment seen on remittance. | collected | $200.00 |
| M-08 | S-1008 | Detention shortfall: 2.0 h x $60.00 = $120.00, paid $75.00 Broker declined: no signed times. | rejected | $45.00 |
| M-09 | S-1010 | Lumper receipt not billed Owner chose not to pursue. | closed | $45.00 |
| M-10 | S-1012 | Detention, 1.0 h over free time Hours come from the load file. No timestamps checked yet. | identified | $60.00 |
No items with this status.
What each status means
| Status | Meaning | Counted in | Amount |
|---|---|---|---|
| identified | Found in the load file. No document checked yet. | Potential | $150.00 |
| evidence needed | We know what proof is missing (signed times, receipt, rate con). | Potential | $210.00 |
| verified | Documents match. The amount is supported. | Verified | $40.00 |
| claimable | Supported and ready for the owner to approve. | Verified | $85.00 |
| submitted | Sent to the broker or customer after owner approval. | Verified | $120.00 |
| approved | The other side agreed to pay. Cash not received. | Verified | $150.00 |
| collected | Payment seen on a remittance or bank line. | Collected | $200.00 |
| rejected | Declined. Kept for the record, not counted. | Not counted | $45.00 |
| closed | Owner chose to drop it. Not counted. | Not counted | $45.00 |
Revenue by broker
Concentration index (HHI) 3,003 of 10,000. Synthetic data.
Days from invoice to payment
Paid invoices only. 30 days is the line the audit uses. Synthetic data.
Load data used
| Load | Lane | Broker | Rate | Loaded mi | Empty mi | Per all mile | Days to pay |
|---|---|---|---|---|---|---|---|
| S-1001 | Dallas, TX to Atlanta, GA | Broker A | $2,450.00 | 780 | 45 | $2.97 | 23 |
| S-1002 | Atlanta, GA to Charlotte, NC | Broker B | $1,150.00 | 245 | 120 | $3.15 | 35 |
| S-1003 | Charlotte, NC to Columbus, OH | Broker A | $1,380.00 | 410 | 60 | $2.94 | 23 |
| S-1004 | Columbus, OH to Chicago, IL | Broker C | $980.00 | 355 | 30 | $2.55 | unpaid |
| S-1005 | Chicago, IL to Memphis, TN | Broker B | $1,620.00 | 530 | 210 | $2.19 | 36 |
| S-1006 | Memphis, TN to Dallas, TX | Broker A | $1,500.00 | 450 | 40 | $3.06 | 23 |
| S-1007 | Dallas, TX to Houston, TX | Broker D | $720.00 | 240 | 15 | $2.82 | 24 |
| S-1008 | Houston, TX to New Orleans, LA | Broker D | $1,050.00 | 350 | 20 | $2.84 | 23 |
| S-1009 | New Orleans, LA to Atlanta, GA | Broker B | $1,320.00 | 470 | 90 | $2.36 | unpaid |
| S-1010 | Atlanta, GA to Nashville, TN | Broker C | $1,010.00 | 250 | 60 | $3.26 | unpaid |
| S-1011 | Nashville, TN to Columbus, OH | Broker A | $1,240.00 | 380 | 55 | $2.85 | 14 |
| S-1012 | Columbus, OH to Charlotte, NC | Broker C | $1,180.00 | 410 | 100 | $2.31 | unpaid |
Formulas used
- Revenue per all mile = total rate / (loaded + empty miles)
- Empty share = empty miles / (loaded + empty miles)
- Detention per stop = max(0, hours on site - 2.0 free hours); missed = hours with nothing paid
- Money at risk = rate of unpaid invoices dated more than 30 days before the report date
- Ledger totals = sum by status group; each item is in exactly one group
How to read it
- Potential is what our rules flag as earned but not billed or paid. It is not proven.
- Verified means the documents support the amount. It is still not cash.
- Collected means a payment was seen and matched. It is the only cash number.
- One dollar, one total. A finding sits in exactly one of the three, so totals never double count.
What it will not say
- It will not rank you against other fleets. We have no benchmark we can source.
- It will not name brokers other than the ones in your own file.
- It will not promise that a broker will pay a finding.
See the full list of measures or try the interactive workspace.
See what your last 20 loads show.
One short form. We reply by email with the next step, and a one-page report follows. Free, no obligation.
Mon-Fri, 9:00 a.m.-5:00 p.m. Eastern Time (Raleigh, NC). Voicemail is answered the next business day.