Skip to content
Workflow · Finance close · Opening soon

Driver settlement report

Export your Loads, Drivers, and Deductions data from Excel, then load the files into Mammoth. It matches the driver keys, totals Monday to Sunday settlements by delivered date, and subtracts deductions like fuel advances and escrow.

Early access opens shortly. Check back soon.

Someone typed

“use the loads, drivers, and deductions to total each driver's monday-to-sunday settlement by delivered date, loaded miles times rate minus all deductions for that driver, and show net pay with status Agrees or Negative settlement”

The agent read it as

use the Loads, Drivers, and Deductions to total each driver's monday-to-sunday settlement by delivered date, loaded miles times rate minus all deductions for that driver, and show net pay with status Agrees or Negative settlement

What the agent built

6 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Loads
    CSV export · 42 rows
  2. File
    Drivers
    CSV export · 6 rows
  3. File
    Deductions
    CSV export · 12 rows
  4. Step
    Prepare load driver keys
    Step 1
  5. Step
    Prepare driver keys
    Step 2
  6. Step
    Total deductions by driver
    Step 3
  7. Join
    Join driver rates
    42 of 42 paired
  8. Join
    Add driver deductions
    42 of 42 paired
  9. Step
    Total weekly settlements
    Step 6
  10. Result
    Driver Settlements
    6 rows · 1 flagged
  11. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 6 rows came out, and the join paired 42 of 42 rows; the join paired 42 of 42 rows.

What you get back

The result of that run, the rows to look at first.

Driver SettlementsSample data6 rows
5 agrees1 negative settlement
DriverNet payStatusLoaded milesRateTotal deductions
Tessa Bloom-986.63Negative settlement3,38933%2,105
Avery Cole2,297.16Agrees3,50372%225
Bria Singh1,092.07Agrees4,29731%240
Caleb Monroe1,654.56Agrees2,86768%295
Diana Ford1,001Agrees3,90029%130
Eli Navarro3,441.50Agrees4,94275%265
6 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Driver Settlements workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Driver Settlements: questions

How do you work out each driver's weekly settlement?
Export your Loads, Drivers, and Deductions data from Excel, then load the files into Mammoth. It matches the driver keys, totals Monday to Sunday settlements by delivered date, and subtracts deductions like fuel advances and escrow. You get net pay for each driver, with status shown as Agrees or Negative settlement.
What export should I use?
Export the spreadsheets that contain your loads, drivers, and deductions data. Use the exported files, not a live workbook.
What happens to rows that do not match?
Rows that do not match a driver key or settlement rule stay out of the matched total. You can review them and decide whether to fix the source data or adjust the rules.
How do I change the rules in words?
Change the rule text to describe the date range, the fields to match, the rate to use, and which deductions to subtract. Then rerun the workflow on the same exported files.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →