All templates

Automated DAT Detention and Accessorial Tracker

Every morning, WebRun opens DAT One, scans loads completed in the last 48 hours for detention, layover, TONU, or other accessorial charges, logs each one to a Google Sheets tracker, and posts a Slack summary of any unbilled extras so your billing team can invoice them before the window closes.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 DAT scan recent loads for accessorial charges
2 Google Sheets log unbilled accessorials to tracker
3 Slack alert billing team to unbilled charges
In short

How do I automatically track detention and accessorial charges from DAT?

WebRun scans DAT One every morning for loads completed in the past 48 hours and captures any detention, layover, TONU, or other accessorial charges that have not yet been invoiced. It logs each charge to Google Sheets and posts a Slack summary to your billing team so nothing is missed before the billing window closes.

  • No accessorial charge lost between load completion and invoicing
  • Billing team alerted to unbilled charges every morning
  • Detention log available for dispute resolution

Built for freight brokers · billing coordinators · brokerage operations managers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens one.dat.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    DAT - scan recent loads for accessorial charges
    dat.com
    WebRun in DAT: scan recent loads for accessorial charges
    WebRun opens DAT to scan recent loads for accessorial charges.
    • Open DAT One and filter loads completed in the past 48 hours
    • Review each load for detention, layover, TONU, redelivery, or fuel surcharge accessorials
    • Capture load ID, charge type, amount, and carrier for each accessorial found

    Done when All recent loads are reviewed and accessorial charges are captured with amounts and load details.

  3. 2
    Google Sheets - log unbilled accessorials to tracker
    google.com
    WebRun in Google Sheets: log unbilled accessorials to tracker
    WebRun opens Google Sheets to log unbilled accessorials to tracker.
    • Append each new accessorial charge as a row in the detention and accessorials tracker
    • Mark charges as unbilled and note the date they were incurred
    • Skip any load already present in the tracker to avoid duplicates

    Done when Every new accessorial charge from the past 48 hours is logged in Google Sheets.

  4. 3
    Slack - alert billing team to unbilled charges
    slack.com
    WebRun in Slack: alert billing team to unbilled charges
    WebRun opens Slack to alert billing team to unbilled charges.
    • Post a summary to your billing Slack channel listing today's new unbilled accessorials
    • Include total unbilled amount and number of affected loads

    Done when Billing team has a Slack summary of unbilled accessorials to invoice today.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
one.dat.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Accessorials log · Google Sheets · Slack
OutputWhat each run produces - A Google Sheets log of unbilled detention and accessorial charges with load details, plus a daily Slack summary for the billing team.
Spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Which accessorial types does it track?

It tracks detention, layover, truck order not used (TONU), redelivery, and fuel surcharges by default. You can configure it to include any accessorial type your brokerage uses.

Does it create the invoice automatically?

No. It logs the charges and alerts your billing team. Invoicing is handled by your staff so that rates and billing terms can be verified before anything goes to a customer.

How does it avoid logging the same charge twice?

It checks the load ID in the Google Sheets tracker before appending a new row. If a load is already present, it skips it, so each charge is logged exactly once.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.