Which detention charges are building up, and who pays them?
Join Tai load charges to Macropoint stop times and your accessorial schedule. See where trucks wait, which detention never reached the shipper's invoice, and how much the schedule lets you bill.
Open QuerriWhat you'll need
Querri (Free trial) to join the exports and run the checks
A Tai export, a Macropoint file and your accessorial schedule: Step 1 says what each adds
Your detention rules: so every stop is measured the same way
Free resources
Start your free trial here →Sample data sets
Synthetic data for a made-up freight brokerage. Not real shipper data.
Need help?
If you have any questions, you can request a demo or email our team.
Before we begin
Detention shows up first as a carrier charge. Whether it ever reaches the shipper depends on someone noticing, checking the schedule, and adding the line to the invoice. The charges are in the TMS, the wait is in Macropoint and what each shipper agreed to pay is in a spreadsheet, so detention that should be billed is often absorbed instead.
This playbook measures the wait at every stop, finds carrier detention with no matching shipper charge, and shows which shipper and receiver it keeps coming from.
How it works:
- • Upload the Tai and Macropoint exports
- • Measure time past free time at every stop
- • Match carrier detention to shipper charges
- • Find where detention keeps happening
- • Build the detention review
Follow the steps
Upload the Tai and Macropoint exports and the schedule
Three sources, one project:
- •
Tai load export and load charges (or your TMS reports): appointments for each stop, and every customer and carrier charge line by charge code.
- •
Macropoint stop events: arrival and departure at every pickup and delivery.
- •
Accessorial schedule (Excel): each shipper's free time and whether detention is billable to them.
All three come in as files. Upload next week's over the old ones and every view rebuilds.
Tip: Pull six months of deliveries, so every shipper has a usual month of detention to compare with.
-
Tai loads and charges
-
Macropoint stop events
-
Accessorial schedule
Measure hours past free time at every stop
Start with the stop record, not the charges:
"Using Macropoint arrival and departure times, how many October stops ran 30 minutes or more past free time, and where?"
700 October stops ran 30 minutes or more past free time, 1.72 hours on average. Fresno to Denver has 115 of them at almost 3 hours each, and one receiver, Front Range Distribution, accounts for 108.
| Lane | Detention stops | Hours past free time |
|---|---|---|
| Fresno to Denver | 115 | 2.94 |
| Atlanta to Dallas | 58 | 1.31 |
| Los Angeles to Phoenix | 27 | 1.36 |
| Memphis to Charlotte | 16 | 2.05 |
| All lanes | 700 | 1.72 |
October 2026 stops 30 minutes or more past free time, by lane.
Match carrier accessorials to shipper charges by load
For every carrier accessorial, look for the matching line on the shipper side:
"Which carrier accessorials in October have no matching charge to the shipper, and how much of that does the schedule let us bill?"
$22,050 of carrier charges on 153 loads has no shipper charge, all of it detention. $20,355 of it falls under shipper schedules that make detention billable. $10,335 sits on carrier lines operations hasn't approved yet.
| Under the schedule | Amount |
|---|---|
| Potentially billable to the shipper | $20,355 |
| Not billable, Brinlow absorbs | $1,695 |
| Total, 153 loads | $22,050 |
October 2026 carrier detention with no matching shipper charge.
Find where detention keeps happening
Compare each shipper's unbilled detention with its usual month:
"Which shipper's unbilled detention is furthest above its usual month, and at which receiver do the trucks wait?"
Tarrowby Foods carries $14,565 of October's unbilled detention, more than 20 times its usual month. 108 of its 129 detention stops were at Front Range Distribution in Denver, at 3.29 hours past free time.
| Shipper | October | Usual month |
|---|---|---|
| Tarrowby Foods | $14,565 | $612.50 |
| Stanwood Farms | $915 | $112 |
| Pellham Home Goods | $420 | $638 |
| Tammore Merchandise | $405 | $5 |
| All shippers | $22,050 |
Unbilled detention by shipper, October 2026 against the April to September monthly average.
Build the detention review for the account managers
Four numbers for the account review, and what to do with each dollar.
The narrative Querri writes:
Detention is building on one lane at one receiver, and almost none of it is reaching the shipper's invoice.
What you can create or export:
- The list, to Excel, CSV or Google Sheets
- A live dashboard that refreshes with each upload
- A presentation for the meeting, to PDF or PowerPoint
| Detention | Amount | Action |
|---|---|---|
| Tarrowby Foods, Fresno to Denver | $12,810 | Check hours and rates, then bill |
| Tarrowby Foods, other lanes | $1,755 | Check hours and rates, then bill |
| Other shippers, billable | $5,790 | Check hours and rates, then bill |
| Not billable under the schedule | $1,695 | Absorb, or raise at renewal |
The detention review, October 2026.
Bill the wait while the stop times are still fresh.
Try it on your own dataTips for detention that gets billed
Start from the stop, not the charge
Macropoint shows where trucks wait whether or not anyone billed it. Measure the wait first and the missing charges follow.
Bring the receiver to the account review
A shipper whose receiver keeps trucks waiting is a conversation about the dock, not only the invoice. The stop times make it a short one.
Teach Querri your rules once. Every answer after that follows them.
What counts as detention, how much free time each shipper gets, what is billable: say each rule once and Querri applies it to every question on that data.
Show me how
Say it in chat
Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.
"Detention is 30 minutes or more past free time, measured from the later of arrival and appointment to departure. Save that as a rule for the Macropoint stop events."
Or bring the document that already says it
Upload your customer rate confirmations or accessorial terms like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:
- Free time: from the accessorial schedule, 2 hours where missing
- Wait: Macropoint departure less the later of arrival and appointment
- Detention stop: 30 minutes or more past free time
- Unbilled: a carrier accessorial with no matching shipper line
- Billable: the schedule says detention is billable to the shipper
- Matching: Macropoint Order ID to Tai load number
"Read our accessorial terms and propose the rules they state about free time, detention rates and billing. I'll review them in the Inbox."
Where the rules reach
A rule is attached to the data, not to one person's chat, so it follows the data everywhere:
- • Every question asked in chat, by any account manager
- • Every view the Librarian builds on that data
- • Every step of a project, including the code it writes
- • Dashboards and scheduled runs, each time they refresh
- • Claude and ChatGPT, when they ask Querri
You stay in control
Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.
The payoff at the account review
The account manager walks in with the receiver, the hours and the dollars, and billing gets a list it can send. Changing free time is a sentence.
Frequently asked questions
What counts as detention here?
Where does free time come from?
What if Macropoint has no departure?
What does billable under the schedule mean?
What about detention operations hasn't approved?
Do I need a TMS connector?
Does Querri change anything in Tai?
How often should this run?
Other popular resources
Playbook
Shippers tendering less
Which shippers are tendering fewer loads than usual?
Playbook
On-time numbers for the QBR
What are each shipper's on-time and tender acceptance numbers for the QBR?
Demo
Request a walkthrough
See Querri in action with your own data.
Pricing
Compare plans
Find the right plan for individuals, teams, or enterprise.