Carrier settlement automation has evolved from manual spreadsheets and weekly batch runs into real-time, rule-driven payroll pipelines that handle the full complexity of owner-operator agreements. At Strong Tower Consulting we design these systems for carriers running 50 to 500 power units who need precise split-pay calculations, dynamic escrow management, and direct integration to their accounting platforms.
The Core Components of a Modern Settlement Engine
A production-grade carrier settlement architecture contains four tightly coupled layers:
- Data Acquisition Layer - Pulls load details, stop events, empty/loaded mileage, fuel transactions, and detention from the TMS (Truckmate, McLeod, or TMW) using SQL views or EDI 204/214/210 transaction sets.
- Calculation Engine - Applies contract-specific business rules for percentage splits, per-mile rates, fuel surcharge passthrough, and escrow logic.
- Escrow & Deduction Manager - Dynamically calculates recurring and event-driven deductions for maintenance reserves, insurance, base plates, and compliance costs.
- Output & Reconciliation Layer - Generates driver pay files, 1099 data, GL journal entries, and posts results back to the TMS and ERP for closed-loop reconciliation.
Empty vs Loaded Mileage Split Algorithms
Most owner-operator contracts pay a percentage of linehaul revenue plus a fuel surcharge while the carrier retains a portion to cover dispatch, billing, and overhead. Accurate split-pay requires distinguishing empty (deadhead) miles from loaded miles because many contracts reimburse empty miles at a lower rate or exclude them from revenue share entirely.
Our architectures store each leg's mileage type in a normalized fact table and apply the correct multiplier during settlement. For example:
| Leg Type | Miles | Rate | Owner-Op Split | Carrier Split | Calculated Pay |
|---|---|---|---|---|---|
| Loaded | 1,248 | $2.85/mi | 78% | 22% | $2,775.36 |
| Empty | 187 | $1.15/mi | 65% | 35% | $139.78 |
| Fuel Surcharge | 1,435 | $0.48/mi | 100% | 0% | $688.80 |
Fuel Surcharge Passthrough and Fuel Card Netting
Fuel surcharge revenue captured on the customer invoice (EDI 210) must be compared to actual fuel purchased on the driver's fuel card. Our engines perform daily netting so that any over-recovery is paid to the owner-operator on the next settlement and any shortfall is either carried forward or recovered per contract terms. This process eliminates disputes and provides clean data for IFTA fuel tax reporting.
Dynamic Escrow Deduction Automation
Static weekly escrow deductions often create cash-flow problems for owner-operators. Modern systems monitor actual maintenance events, tire purchases, and insurance renewals in real time. When a qualifying expense posts, the engine can automatically adjust the escrow contribution for the current and future settlements using configurable rules (percentage of revenue, fixed dollar per mile, or event-triggered lump sums). All activity is written to an audit-ready escrow ledger that reconciles to the general ledger.
Direct GL Integration to ERP Platforms
Instead of exporting CSV files for manual import, the settlement engine writes fully balanced journal entries directly to the carrier's accounting system (Sage, QuickBooks, Microsoft Dynamics, or custom ERP). Typical entries include:
- Driver/Owner-Operator settlement expense
- Escrow liability increase/decrease
- Fuel surcharge clearing accounts
- Maintenance reserve offsets
This closed-loop integration eliminates duplicate data entry and ensures month-end reconciliation is automatic.
Implementation Considerations for Truckmate, McLeod, and TMW
Each TMS stores settlement data differently. Truckmate users typically query the LOAD and SETTLEMENT tables; McLeod implementations leverage the OPLOAD and PAYEE tables; TMW users work with the ORD and PAY tables. Strong Tower designs vendor-neutral SQL views that abstract these differences so the settlement rules remain consistent even if the carrier changes TMS platforms later.
Why Independent Architecture Matters
Strong Tower Consulting, LLC and Exspeedite LLC are separately organized sister companies under common ownership. Carriers never have to buy our software. Our only product is better decisions. Whether you run Truckmate, McLeod, TMW, or a custom system, we design the exact settlement, escrow, and reconciliation architecture your operation needs.
Frequently Asked Questions
How do automated settlement engines calculate split-pay for owner-operators?
Rule-based payroll pipelines evaluate each load's empty versus loaded mileage, apply per-mile and percentage splits defined in the carrier-owner operator agreement, net fuel card advances against fuel surcharge revenue, and post recurring escrow deductions before generating both driver pay files and GL journal entries.
What is dynamic escrow deduction automation in trucking settlements?
Dynamic escrow engines monitor real-time maintenance events, tire purchases, insurance renewals, and compliance costs, then automatically calculate and deduct the correct escrow contribution amount on every settlement. Deduction logic can be percentage-based, fixed-dollar, or event-triggered and is fully auditable.
Can carrier settlement automation integrate with Truckmate, McLeod, or TMW?
Yes. Modern settlement architectures read load, stop, and mileage data from Truckmate, McLeod, or TMW via SQL views or EDI 210/214 transactions, apply business rules in a dedicated calculation layer, then write payroll and escrow results back to the TMS or directly to the accounting ERP through integration tables or API.
How does fuel surcharge passthrough work in owner-operator settlement systems?
The engine matches each load's fuel surcharge revenue (from the EDI 210 or customer invoice) to the actual fuel purchased on the driver's fuel card. Any excess surcharge is paid to the owner-operator; deficits are either carried forward or recovered according to the contract terms. All calculations are stored for audit and IFTA reporting.
Ready to replace spreadsheets and manual adjustments with a reliable, auditable settlement and escrow engine? Contact Strong Tower Consulting today.
Speak with Scott Elliott at 763-244-1373